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

[Adam Gerson]

That worked. Thank you. What did -i do?

Adam


-- 
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/24/10 5:10 AM, Hugh Irvine wrote:
>
> 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?
>