[RADIATOR] AuthBy SQL result: IGNORE, User database access error
Hugh Irvine
hugh at open.com.au
Fri Jun 25 15:45:11 CDT 2010
Hello Adam -
The -I parameter to perl indicates where to find the Radiator modules.
Here is the help for perl:
Radiator-4.6 hugh$ perl -h
Usage: perl [switches] [--] [programfile] [arguments]
-0[octal] specify record separator (\0, if no argument)
-a autosplit mode with -n or -p (splits $_ into @F)
-C[number/list] enables the listed Unicode features
-c check syntax only (runs BEGIN and CHECK blocks)
-d[:debugger] run program under debugger
-D[number/list] set debugging flags (argument is a bit mask or alphabets)
-e program one line of program (several -e's allowed, omit programfile)
-E program like -e, but enables all optional features
-f don't do $sitelib/sitecustomize.pl at startup
-F/pattern/ split() pattern for -a switch (//'s are optional)
-i[extension] edit <> files in place (makes backup if extension supplied)
-Idirectory specify @INC/#include directory (several -I's allowed)
-l[octal] enable line ending processing, specifies line terminator
-[mM][-]module execute "use/no module..." before executing program
-n assume "while (<>) { ... }" loop around program
-p assume loop like -n but print line also, like sed
-P run program through C preprocessor before compilation
-s enable rudimentary parsing for switches after programfile
-S look for programfile using PATH environment variable
-t enable tainting warnings
-T enable tainting checks
-u dump core after parsing program
-U allow unsafe operations
-v print version, subversion (includes VERY IMPORTANT perl info)
-V[:variable] print configuration summary (or a single Config.pm variable)
-w enable many useful warnings (RECOMMENDED)
-W enable all warnings
-x[directory] strip off text before #!perl line and perhaps cd to directory
-X disable all warnings
regards
Hugh
On 26 Jun 2010, at 00:16, Adam Gerson wrote:
> 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?
>>
>
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.
More information about the radiator
mailing list