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 [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
