(RADIATOR) AuthBy SQL and PostgreSQL

[Hugh Irvine]

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 radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.