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

[Adam Gerson]

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?
>