[RADIATOR] Could not connect to SQL database

Wed Nov 16 09:22:09 CST 2011

After looking around I ended up discovering that I'm actually trying to
connect to a Microsoft SQL server and all my research was around mysql.
Now I'm almost back to stage zero and many problems/questions arise.

Meanwhile the attempts I've done:

-       Installed DBD module Msql-Mysql-modules as proposed in 26.2 mSQL -
manual version 4.9
-       Ended up discovering that this msql is actually a mini-sql from
Hugher and not Microsoft SQL (correct me if I'm wrong)

Can you explain me how can I inject accounting from radiator directly into
Microsoft SQL server 7.0?

Thanks in advance,
Nuno Marques

-----Original Message-----
From: Michael [mailto:ringo at vianet.ca]
Sent: terça-feira, 15 de Novembro de 2011 15:26
To: Nuno Marques
Cc: radiator at open.com.au
Subject: Re: [RADIATOR] Could not connect to SQL database

The incoming request is coming from a 10. network, and your mysql server is
on an 192 network.  is your network configuration setup properly for this to
work? ie. your system/router knows how to get to the 192 network?  Do you
use a firewall/iptables?

try ronald.higgins suggestion first. can you connect manually to the sql
server:
mysql DB -u username -p[password] -h dbhostname

On 11-11-15 09:45 AM, Nuno Marques wrote:
> 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.
>
>
> _______________________________________________
> radiator mailing list
> radiator at open.com.au
> http://www.open.com.au/mailman/listinfo/radiator

________________________________

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.