No subject

[tdn]

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 <hugh at open.com.au>
To: tdn <tdn at tdn.co.ke>; <radiator at open.com.au>
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                               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.