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

[Hugh Irvine]

Hello Adam -

The error message you show below indicates your database is not running (or is unreachable for some reason).

regards

Hugh


On 22 Jun 2010, at 15:03, Adam Gerson wrote:

> 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
> 
> _______________________________________________
> radiator mailing list
> radiator at open.com.au
> http://www.open.com.au/mailman/listinfo/radiator



NB: 

Have you read the reference manual ("doc/ref.html")?
Have you searched the mailing list archive (www.open.com.au/archives/radiator)?
Have you had a quick look on Google (www.google.com)?
Have you included a copy of your configuration file (no secrets), 
together with a trace 4 debug showing what is happening?

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
Includes support for reliable RADIUS transport (RadSec),
and DIAMETER translation agent.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.