(RADIATOR) AuthBy SQL and PostgreSQL

[tdn]

Hello Hugh,

I had compiled the DBD and DBI from source, I have used the FreeBSD ports
collection and now it works fine.
Well, can't figure out why, but it works

Thanks
TDN
----- Original Message -----
From: Hugh Irvine <hugh at open.com.au>
To: tdn <tdn at tdn.co.ke>; <radiator at open.com.au>
Sent: Wednesday, February 06, 2002 2:31 AM
Subject: Re: (RADIATOR) AuthBy SQL and PostgreSQL


>
> Hello -
>
> Could you please send me a copy of your configuration file (no secrets)
> together with a trace 4 debug from Radiator showing what is happening.
>
> thanks
>
> Hugh
>
>
> On Tue, 5 Feb 2002 19:53, tdn wrote:
> > Hi Hugh
> >
> > > The correct syntax for the DBSource line is this:
> > >
> > > DBSource        dbi:Pg:dbname=radius
> >
> > I actually noticed that and rectified, however the problem still occurs
> > when auth by SQL.
> > Authenticating by flat file works OK.
> >
> > > And of course you must install the DBI and DBD modules first.
> >
> > I have pgsql_perl5-1.9.0 for the DBD and DBI-1.201 for the DBI
> >
> >
> >
> > Rgds
> > TDN
> >
> >
> > ----- Original Message -----
> > From: Hugh Irvine <hugh at open.com.au>
> > To: tdn <tdn at tdn.co.ke>; <radiator at open.com.au>
> > Sent: Tuesday, February 05, 2002 1:38 AM
> > Subject: Re: (RADIATOR) AuthBy SQL and PostgreSQL
> >
> > > Hello TDN -
> > >
> > > > Hi,
> > > >
> > > > I'd like to have radiator authenticate users from a Postgres SQL
> >
> > database.
> >
> > > > I get the following error whenever I try to test it using radpwtst.
> > > >
> > > > Can't read $DBI::errstr, last handle unknown or destroyed at
> > > > /usr/local/lib/perl5/site_perl/5.005/Radius/SqlDb.pm line 136
> > > >
> > > > Am running Radiator 2.19 and PostgreSQL 7.1
> > > >
> > > > see part of my radius.cfg
> > > >
> > > > <Realm DEFAULT>
> > > >         #<AuthBy FILE>
> > > > #               # The filename defaults to %D/users
> > > > #       </AuthBy>
> > > >         # Log accounting to the detail file in LogDir
> > > > #       AcctLogFileName %L/detail/detail.%Y%m%d
> > > >         <AuthBy SQL>
> > > >                 DBSource        dbi:pg:dbname=radius
> > > >                 DBUsername      xxx
> > > >                 DBAuth          xxx
> > > >                 AuthSelect select CLEARTEXTPASSWORD from USERS where
> > > > USERID='%n';
> > > >         </AuthBy>
> > > > </Realm>
> > >
> > > The correct syntax for the DBSource line is this:
> > >
> > > DBSource        dbi:Pg:dbname=radius
> > >
> > > And of course you must install the DBI and DBD modules first.
> > >
> > > regards
> > >
> > > Hugh
> > >
> > > --
> > > Radiator: the most portable, flexible and configurable RADIUS server
> > > anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
> > > -
> > > Nets: internetwork inventory and management - graphical, extensible,
> > > flexible with hardware, software, platform and database independence.
>
> --
> Radiator: the most portable, flexible and configurable RADIUS server
> anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
> -
> Nets: internetwork inventory and management - graphical, extensible,
> flexible with hardware, software, platform and database independence.
> ===
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.
>

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.