(RADIATOR) Connection failure with MySQL

[Hugh Irvine]

Hello Gustavo -

Have you installed and configured the DBI/DBD modules for Perl?

regards

Hugh



>Hi guys,
>
>	I'm trying to set up a radiator server with a MySQL server only to
>assign three address pools.  The trouble is that radiator can't connect to
>the sql server, and I don't understand the reason why.
>
>	If I use command line mysql monitor, I can connect and make the
>queries, but the server can't do it.
>	May be something with perl stuff, or it's something with Radiator?
>
>	MySQL version is 3.23.40.
>
>realone:~/Radiator-2.18.4 # ./radiusd -config_file radius.cfg -trace 5
>Tue Oct 30 16:24:53 2001: DEBUG: Checking address 200.40.8.11
>Tue Oct 30 16:24:53 2001: DEBUG: Query is: select STATE from RADPOOL where
>YIADDR='200.40.8.11'
>
>Can't read $DBI::errstr, last handle unknown or destroyed at
>Radius/SqlDb.pm line 136, <FILE> line 111.
>Tue Oct 30 16:24:53 2001: ERR: Could not connect to SQL database with
>DBI->connect dbi:mysql:RADIUS, , :
>Tue Oct 30 16:24:53 2001: ERR: Could not connect to any SQL database.
>Request is ignored. Backing off for 600 seconds
>Tue Oct 30 16:24:53 2001: DEBUG: Checking address 200.40.8.67
>Tue Oct 30 16:24:53 2001: DEBUG: Query is: select STATE from RADPOOL where
>YIADDR='200.40.8.67'
>
>Tue Oct 30 16:24:53 2001: DEBUG: Checking address 200.40.144.1
>Tue Oct 30 16:24:53 2001: DEBUG: Query is: select STATE from RADPOOL where
>YIADDR='200.40.144.1'
>
>Tue Oct 30 16:24:53 2001: DEBUG: Reclaiming expired leases
>Tue Oct 30 16:24:53 2001: DEBUG: do query is: update RADPOOL set STATE=0
>where STATE!=0 and EXPIRY < 1004469893
>
>realone:~/Radiator-2.18.4 # Tue Oct 30 16:24:53 2001: INFO: Server
>started:
>Radiator 2.18.4 on real1
>
>	This is an entry of radius.cfg
>----------------------8<----------------------------
>[...]
><AddressAllocator SQL>
>         Identifier SQLAllocator
>         DBSource        dbi:mysql:RADIUS
>[...]
>---------------------->8----------------------------
>
>	I will appreciate any king of help.
>	Thanks in advance!
>
>Saludos,
>	Gustavo Castro Puig.
>	G.C.P. Software
>	http://www.gcpsoftware.com.uy
>
>===
>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.

-- 

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