---------- Forwarded Message ----------
Subject: BOUNCE [EMAIL PROTECTED]: Non-member submission from ["tdn"
<[EMAIL PROTECTED]>]
Date: Tue, 5 Feb 2002 01:21:16 -0600
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
>From [EMAIL PROTECTED] Tue Feb 5 01:21:15 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 g157Km302454;
Tue, 5 Feb 2002 01:21:02 -0600
Received: from [195.202.85.31] (helo=spider)
by mx1.uunet.co.ke with smtp (Exim 3.21 #2)
id 16Y4A6-0001HF-00; Tue, 05 Feb 2002 11:53:22 +0000
Message-ID: <014801c1ae22$976feb60$[EMAIL PROTECTED]>
From: "tdn" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
References: <[EMAIL PROTECTED]>
<[EMAIL PROTECTED]> Subject: Re: (RADIATOR)
AuthBy SQL and PostgreSQL
Date: Tue, 5 Feb 2002 11:53:33 +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 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.
-------------------------------------------------------
--
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.
