[RADIATOR] AuthBy SQL result: IGNORE, User database access error

[Adam Gerson]

Well, nothing has changed in my config file and my database is still up 
and working. I have not used Radiator for a week or two. I started it 
today to test it and now it cannot contact the database. I got an email 
saying my trail had experienced, but at startup Radiator reports its 
good until 2011 or 1000 connections.





Tue Jun 22 14:59:47 2010: DEBUG: Finished reading configuration file 
'/etc/radiator/radius.cfg'
This Radiator license will expire on 2011-02-01
This Radiator license will stop operating after 1000 requests
To purchase an unlimited full source version of Radiator, see
http://www.open.com.au/ordering.html
To extend your license period, contact admin at open.com.au

Tue Jun 22 14:59:47 2010: DEBUG: Reading dictionary file 
'/etc/radiator/dictionary'
Tue Jun 22 14:59:47 2010: DEBUG: Creating authentication port 0.0.0.0:1645
Tue Jun 22 14:59:47 2010: DEBUG: Creating accounting port 0.0.0.0:1646
Tue Jun 22 14:59:47 2010: NOTICE: Server started: Radiator 4.6 on 
sidekick.cgps.org (LOCKED)
Tue Jun 22 14:59:54 2010: DEBUG: Packet dump:
*** Received from 192.168.1.92 port 52380 ....
Code:       Access-Request
Identifier: 144
Authentic:  -e<204><0><155>W<174><163>g<227><181><149><134>sP<148>
Attributes:
	User-Name = "adam"
	User-Password = <175><244>t<214>bP0<25>+6c?<237><196><137>K
	NAS-IP-Address = 192.168.1.92
	Service-Type = Login-User
	Framed-IP-Address = 10.93.3.23
	Called-Station-Id = "00:19:92:02:B4:3A"
	Calling-Station-Id = ""
	NAS-Identifier = "Bluesocket"
	Acct-Session-Id = "00:19:92:02:B4:3A:1277233194"
	NAS-Port-Type = Wireless-IEEE-802-11

Tue Jun 22 14:59:54 2010: DEBUG: Handling request with Handler 
'Realm=DEFAULT'
Tue Jun 22 14:59:54 2010: DEBUG:  Deleting session for adam, 192.168.1.92,
Tue Jun 22 14:59:54 2010: DEBUG: Handling with Radius::AuthSQL:
Tue Jun 22 14:59:54 2010: DEBUG: Handling with Radius::AuthSQL:
Tue Jun 22 14:59:54 2010: ERR: Could not connect to SQL database with 
DBI->connect dbi:mysql:jamfsoftware:127.0.0.1, jamfsoftware, ***:
Tue Jun 22 14:59:54 2010: ERR: Could not connect to any SQL database. 
Request is ignored. Backing off for 600 seconds
Tue Jun 22 14:59:54 2010: DEBUG: AuthBy SQL result: IGNORE, User 
database access error
Tue Jun 22 14:59:54 2010: DEBUG: Handling with Radius::AuthSQL:
Tue Jun 22 14:59:54 2010: DEBUG: Handling with Radius::AuthSQL:
Tue Jun 22 14:59:54 2010: ERR: Could not connect to SQL database with 
DBI->connect dbi:mysql:jamfsoftware:127.0.0.1, jamfsoftware, ***:
Tue Jun 22 14:59:54 2010: ERR: Could not connect to any SQL database. 
Request is ignored. Backing off for 600 seconds
Tue Jun 22 14:59:54 2010: DEBUG: AuthBy SQL result: IGNORE, User 
database access error
^C

-- 
Adam Gerson
Assistant Director of Technology
Columbia Grammar and Prep School
phone. 212-749-6200 ex. 321
fax.  212-428-6806
agerson at cgps.org
http://www.cgps.org