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 <[EMAIL PROTECTED]> To: tdn <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> 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 <[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. > === 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.
