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 <[EMAIL PROTECTED]> > To: tdn <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > 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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
