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:[email protected]] Sent: terça-feira, 15 de Novembro de 2011 15:26 To: Nuno Marques Cc: [email protected] 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 = "[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], 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] > 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. _______________________________________________ radiator mailing list [email protected] http://www.open.com.au/mailman/listinfo/radiator
