(RADIATOR) AuthBy SQL and PostgreSQL

[Hugh Irvine]

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.