AuthBy SQL and PostgreSQL

[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>


Any ideas ?

Rgds
TDN

-------------------------------------------------------

-- 
Mike McCauley                               mikem at open.com.au
Open System Consultants Pty. Ltd            Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia   http://www.open.com.au
Phone +61 3 9598-0985                       Fax   +61 3 9598-0955

Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, 
Platypus, Freeside, TACACS+, PAM, external, Active Directory etc etc 
on Unix, Win95/8, 2000, NT, MacOS 9, MacOS X
===
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.