[RADIATOR] Radiator logging halted

[Rauno Tuul]

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 at lag-14:357.1537 at 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 at lists.open.com.au
> http://lists.open.com.au/mailman/listinfo/radiator
>