[RADIATOR] Could not connect to SQL database

[Nuno Marques]

Hello,

                I’m trying to store accounting into a SQL daba-base and I’m getting this error:

Tue Nov 15 14:19:32 2011: ERR: Could not connect to SQL database with DBI->connect dbi:mysql:Accounting:192.168.69.222, xxxx, xxxx:
Tue Nov 15 14:19:32 2011: ERR: Could not connect to any SQL database. Request is ignored. Backing off for 600 seconds

Radiator doesn’t even try to reach the data-base IP address (sniffed the traffic to confirm this).
I’ve no idea what’s wrong, all looks fine. Any help is greatly appreciated.

Thanks in advance,
Nuno Marques


radius.cfg:

LogDir          /var/log/radius
DbDir           /etc/radiator/
Trace           4
AuthPort 1812
AcctPort 1813

<Client 10.240.1.1>
        Secret xxxxxxxxxxxxxxxxxxxxxxxx
</Client>

<AuthBy RADIUS>
        Identifier PEAP_IAS
        Secret xxxxxxxxxxx
        AuthPort 1812
        AcctPort 1813
        Retries 3
        SSLeayTrace 4
        Host ubidc1.ubi.pt
</AuthBy>

<AuthBy SQL>
        Identifier SQLAccounting
        DBSource dbi:mysql:Accounting:192.168.69.222
        DBUsername xxxx
        DBAuth xxxxx
        IgnoreAuthentication
        AuthSelect
        AccountingTable Accounting-table
        HandleAcctStatusTypes Start,Stop
      #Just putting something into the DB
        AcctColumnDef Nome, User-Name
</Authby>

<Handler Realm=/ubi.pt/i>
        AuthByPolicy ContinueAlways
        AuthBy SQLAccounting
        AuthBy PEAP_IAS
</Handler>


Logfile:

Tue Nov 15 14:19:32 2011: ERR: Attribute number 1 (vendor 52) is not defined in your dictionary
Tue Nov 15 14:19:32 2011: DEBUG: Packet dump:
*** Received from 10.240.1.1 port 20009 ....
Code:       Accounting-Request
Identifier: 15
Authentic:  <<235><173>x<164><226>d<193><171><168>0<239>)<240>g&
Attributes:
        Acct-Status-Type = Stop
        Acct-Authentic = RADIUS
        Acct-Multi-Session-Id = "SESS-63907-d2d8d0-365628-402"
        Acct-Session-Id = "SESS-63907-d2d8d0-365628-402"
        User-Name = "xxxxxx at ubi.pt"
        Event-Timestamp = 1321366775
        Calling-Station-Id = "00-1C-BF-72-63-92"
        NAS-Port-Id = "AP7/1"
        Called-Station-Id = "00-11-88-D2-D9-62:RAD-Test"
        NAS-Port = 185
        Framed-IP-Address = 192.168.228.121
        Class = "l<127><6>F<0><0><1>7<0><1><2><0><192><168>d<1><0><0><0><0><0><0><0><0><0><0><0><0><1><204><159><178><6>2n<159><0><0><0><0><0><18><155>-"
        Acct-Session-Time = 1146
        Acct-Output-Octets = 1349445
        Acct-Input-Octets = 1925391
        Acct-Output-Packets = 3538
        Acct-Input-Packets = 13777
        NAS-Port-Type = Wireless-IEEE-802-11
        NAS-IP-Address = 10.240.1.1
        NAS-Identifier = "enterasys"
        Acct-Delay-Time = 0

Tue Nov 15 14:19:32 2011: DEBUG: Handling request with Handler 'Realm=/ubi.pt/i', Identifier ''
Tue Nov 15 14:19:32 2011: DEBUG:  Deleting session for nmarques at ubi.pt, 10.240.1.1, 185
Tue Nov 15 14:19:32 2011: DEBUG: Handling with Radius::AuthSQL: SQLAccounting
Tue Nov 15 14:19:32 2011: DEBUG: Handling accounting with Radius::AuthSQL
Tue Nov 15 14:19:32 2011: ERR: Could not connect to SQL database with DBI->connect dbi:mysql:Accounting:192.168.69.222, xxxx, xxxx:
Tue Nov 15 14:19:32 2011: ERR: Could not connect to any SQL database. Request is ignored. Backing off for 600 seconds
Tue Nov 15 14:19:32 2011: DEBUG: do query is: 'insert into Accounting-table (Nome) values ()':
Tue Nov 15 14:19:32 2011: DEBUG: AuthBy SQL result: IGNORE, Database failure
Tue Nov 15 14:19:32 2011: DEBUG: Handling with Radius::AuthRADIUS
Tue Nov 15 14:19:32 2011: DEBUG: Packet dump:

________________________________

UBI amiga do ambiente: Antes de imprimir este e-mail pense bem se tem mesmo que o fazer. As árvores são um bem imprescindível.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.open.com.au/pipermail/radiator/attachments/20111115/9981ab33/attachment-0001.html