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 > [email protected] > http://lists.open.com.au/mailman/listinfo/radiator > _______________________________________________ radiator mailing list [email protected] http://lists.open.com.au/mailman/listinfo/radiator
