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, can I re-use any code I've proposed
below?
Thanks in advance,
Nuno Marques
*From:*Faisal Imtiaz [mailto:[email protected]]
*Sent:* terça-feira, 15 de Novembro de 2011 14:56
*To:* Nuno Marques
*Subject:* Re: [RADIATOR] Could not connect to SQL database
Could be a couple of possibilities...
First things first, can you connect to the MySql Server from the
command line (where Radiator is running ) ?
Most likely this is a firewall or connectivity issue ....
Regards
Faisal Imtiaz
Snappy Internet& Telecom
7266 SW 48 Street
Miami, Fl 33155
Tel: 305 663 5518 x 232
Helpdesk: 305 663 5518 option 2 Email:[email protected]
<mailto:[email protected]>
On 11/15/2011 9: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 = "[email protected]" <mailto:[email protected]>
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
[email protected] <mailto:[email protected]>, 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
[email protected] <mailto:[email protected]>
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.
