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

Thu Jun 24 04:10:00 CDT 2010

Hello Adam -

Try this:

	/opt/local/bin/perl -I /usr/local/src/Radiator/Radiator-Locked-4.6 /usr/local/src/Radiator/Radiator-Locked-4.6/radiusd -config_file /etc/radiator/radius.cfg -pid_file /var/run/radiusd.pid

regards

Hugh

On 24 Jun 2010, at 03:46, Adam Gerson wrote:

> I have figured out that MacPorts installs its own copy of perl into /opt/local/bin
> 
> I need to use that perl, which includes the mysql packages. When I call that perl explicitly I get this error:
> 
> sidekick:~ sadmin$ /opt/local/bin/perl /usr/local/src/Radiator/Radiator-Locked-4.6/radiusd -config_file /etc/radiator/radius.cfg -pid_file /var/run/radiusd.pid
> 
> Can't locate Radius/ServerConfig.pm in @INC (@INC contains: . /opt/local/lib/perl5/site_perl/5.8.9/darwin-2level /opt/local/lib/perl5/site_perl/5.8.9 /opt/local/lib/perl5/site_perl /opt/local/lib/perl5/vendor_perl/5.8.9/darwin-2level /opt/local/lib/perl5/vendor_perl/5.8.9 /opt/local/lib/perl5/vendor_perl /opt/local/lib/perl5/5.8.9/darwin-2level /opt/local/lib/perl5/5.8.9 .) at (eval 8) line 20, <_> line 575.
> BEGIN failed--compilation aborted at (eval 8) line 20, <_> line 575.
> 	...caught at /usr/local/src/Radiator/Radiator-Locked-4.6/radiusd line 2, <_> line 575.
> 
> 
> 
> 
> -- 
> 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
> 
> On 6/22/10 3:21 PM, Hugh Irvine wrote:
>> 
>> 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?
>> 
> 

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.