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. === 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.