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 = "xxx...@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 nmarq...@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@open.com.au > http://www.open.com.au/mailman/listinfo/radiator _______________________________________________ radiator mailing list radiator@open.com.au http://www.open.com.au/mailman/listinfo/radiator
