Hello Feite -
I would suggest you upgrade to Radiator 2.18 (plus all patches) and
then make sure you have both DBI and the DBD-Pg modules installed.
hth
Hugh
At 18:24 +0200 01/4/11, Feite Brekeveld wrote:
>Hi,
>
>I have a radiator 2.15 and want to config it with Postgresql.
>
>I keep getting messages in the log like:
>
><snip>
>./radiusd -config_file ./goodies/common-sql.cfg
>Can't read $DBI::errstr, last handle unknown or destroyed at
>Radius/SqlDb.pm line 127.
>Wed Apr 11 17:35:52 2001: ERR: Could not connect to SQL database with
>DBI->connect dbi:Pg:dbname=radius:port=5432, user=postgres,
>password=postgres:
>Wed Apr 11 17:35:52 2001: ERR: Could not connect to any SQL database.
>Request is ignored. Backing off for 600 seconds
><snip>
>
>while with a test perl-script I can extract data from the database:
>
><snip>
>#!/usr/bin/perl -w
>
>use DBI;
>use Pg;
>$conn = Pg::connectdb("dbname=radius port=5432 user=postgres
>password=postgres ");
>die $conn->errorMessage unless PGRES_CONNECTION_OK eq $conn->status;
>print "connected to radius\n";
>
>Pg::doQuery($conn, "select * from subscribers", \@ary);
>for $i ( 0 .. $#ary ) {
> for $j ( 0 .. $#{$ary[$i]} ) {
> print "$ary[$i][$j]\t";
> }
> print "\n";
>}
><snip>
>
>What to do ?
>
>Thanks,
>
>
>Feite Brekeveld
>
>
>===
>Archive at http://www.starport.net/~radiator/
>Announcements on [EMAIL PROTECTED]
>To unsubscribe, email '[EMAIL PROTECTED]' with
>'unsubscribe radiator' in the body of the message.
--
NB: I am travelling this week, so there may be delays in our correspondence.
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
