(RADIATOR) Connection failure with MySQL

[Gustavo Castro Puig]

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.