Hi,

Maybe You have the same issue as we did?
Check the thread: "mysql DBI timed out connections and too many open
files (sockets)" in archives:

http://lists.open.com.au/pipermail/radiator/2017-April/thread.html

-- 
rauno

On 20.06.2017 16:08, rohan.henry cwjamaica.com wrote:
> Hi, 
> 
> Radiator logging frequently stops and I have to restart the server every time 
> for it to run again. It appears to be stopping when attempting to connect to 
> a database. Every time I view the logs when it stops it looks similar to 
> below with the same IP. Should this cause logging to stop? 
> 
> Thu Jun 15 12:54:20 2017: DEBUG: Handling with Radius::AuthSQL: 
> GNDSQLAccounting-remote 
> Thu Jun 15 12:54:20 2017: DEBUG: Handling accounting with Radius::AuthSQL 
> Thu Jun 15 12:54:20 2017: DEBUG: do query to 
> 'dbi:mysql:radius_accounting:172.21.6.51': 'insert into GND_ACCOUNTING_201706 
> (ACCTINPUTOCTETS,ACCTOUTPUTOCTETS,ACCTSESSIONID,ACCTSESSIONTIME,ACCTTERMINATECAUSE,CALLINGSTATIONID,FRAMEDIPADDRESS,MACADDRESS,NAS,NASIPADDRESS,NASPORT,NASPORTTYPE,SPECIALDATE,SPECIALTIME,TIME_STAMP,USERNAME)
>  values (236238648,3685480321,'roxannebhola@lag-14:357.1537@mega_2017/06/14 
> 16:49:08',86406,'Session-Timeout','lag-14:357.1537','65.48.136.101','00:23:6a:92:08:89','GND_STGS_PE1','216.110.125.249',23397889,'PPPoEoQinQ',('20170615'),('12:54:20'),1497545660,'roxannebhola')':
>  
> Thu Jun 15 12:54:20 2017: DEBUG: AuthBy SQL result: ACCEPT, 
> Thu Jun 15 12:54:20 2017: DEBUG: Handling with Radius::AuthSQL: 
> GNDSQLAccounting-test-server 
> Thu Jun 15 12:54:20 2017: DEBUG: Handling accounting with Radius::AuthSQL 
> Thu Jun 15 12:54:20 2017: DEBUG: Connecting to 
> 'dbi:mysql:radius_accounting:192.168.127.103' 
> 
> Regards, 
> Rohan 
> 
> 
> 
> _______________________________________________
> radiator mailing list
> radiator@lists.open.com.au
> http://lists.open.com.au/mailman/listinfo/radiator
> 
_______________________________________________
radiator mailing list
radiator@lists.open.com.au
http://lists.open.com.au/mailman/listinfo/radiator

Reply via email to