---------- Forwarded Message ----------
Subject: BOUNCE [EMAIL PROTECTED]: Non-member submission from ["tdn"
<[EMAIL PROTECTED]>]
Date: Mon, 4 Feb 2002 04:06:07 -0600
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
>From [EMAIL PROTECTED] Mon Feb 4 04:06:05 2002
Received: from mx1.uunet.co.ke (mx1.uunet.co.ke [195.202.64.8])
by server1.open.com.au (8.11.0/8.11.0) with ESMTP id g14A5u327225
for <[EMAIL PROTECTED]>; Mon, 4 Feb 2002 04:05:59 -0600
Received: from [195.202.85.31] (helo=spider)
by mx1.uunet.co.ke with smtp (Exim 3.21 #2)
id 16XkFy-0000ZB-00
for [EMAIL PROTECTED]; Mon, 04 Feb 2002 14:38:11 +0000
Message-ID: <011901c1ad70$71d34c60$[EMAIL PROTECTED]>
From: "tdn" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: AuthBy SQL and PostgreSQL
Date: Mon, 4 Feb 2002 14:38:14 +0300
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2615.200
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
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 [EMAIL PROTECTED]
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 [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
