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 [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.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.