Accueil › Forums › SecAst (Security for Asterisk) › General › Database command failed on write to eventlog table

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • teliumcustomer4
    Participant
    September 29, 2018 at 7:23 pm
    Post count: 3
    #6546

    I’m seeing this error in Event Log.

    Everything seems to work well, what can be wrong?


    Fri, 28 Sep 2018 22:03:18 +0000 Information Database Database closed
    Fri, 28 Sep 2018 22:03:18 +0000 Error Database Database command failed on write to eventlog table
    Fri, 28 Sep 2018 22:03:28 +0000 Information Database Database open for archiving
    Sat, 29 Sep 2018 18:36:48 +0000 Information Database Database closed
    Sat, 29 Sep 2018 18:36:48 +0000 Error Database Database command failed on write to eventlog table
    Sat, 29 Sep 2018 18:36:56 +0000 Information Asterisk Controller Connection established to AMI
    Sat, 29 Sep 2018 18:36:57 +0000 Information General SecAst state changing to protecting
    Sat, 29 Sep 2018 18:36:58 +0000 Information Database Database open for archiving

    thanks

    • This topic was modified 4 years, 11 months ago by WebMaster.
    Avatar photoTelium Support Group
    Participant
    September 30, 2018 at 12:55 am
    Post count: 265
    #6788

    I assume the log excerpt you posted is not contiguous (i.e. you removed lines). Is there something in the removed lines pointing to some other issue?

    It’s unusual for the database connection to close (failed write). Is the database on the same server as SecAst?

    You may wish to increase logging to the DEBUG level for more information.

    teliumcustomer4
    Participant
    October 3, 2018 at 2:05 pm
    Post count: 3
    #6789

    Its contiguous and database are in same server

    With dblevel=debug after restart secast, direct log:


    Wed Oct 3 15:48:05 2018, 00000103, I, General, Received shutdown request via TERM signal
    Wed Oct 3 15:48:05 2018, 00000126, W, Controller, Manual shutdown request by module Operating System
    Wed Oct 3 15:48:05 2018, 00010038, W, Controller, Stopping
    Wed Oct 3 15:48:05 2018, 00000128, D, Telnet Server, Requesting disconnect of all telnet clients
    Wed Oct 3 15:48:05 2018, 00000120, D, Socket Server, Requesting disconnect of all socket clients
    Wed Oct 3 15:48:05 2018, 00000107, I, General, SecAst state changing to not protecting
    Wed Oct 3 15:48:05 2018, 00000800, D, Alert, Sent email: Entering Non-Protecting State
    Wed Oct 3 15:48:05 2018, 00001211, D, Asterisk Controller, Flushed 0 message(s) from received message queue
    Wed Oct 3 15:48:05 2018, 00001210, D, Asterisk Controller, Flushed 1 message(s) from sent message queue
    Wed Oct 3 15:48:06 2018, 00001400, D, Controller, Flushed 0 IP(‘s) from IP watch list
    Wed Oct 3 15:48:06 2018, 00000903, D, Threat Info, Flushed 8 IP(‘s) from internal blocked list
    Wed Oct 3 15:48:06 2018, 00002823, D, Controller, Stopping – stage 1
    Wed Oct 3 15:48:06 2018, 00001211, D, Asterisk Controller, Flushed 0 message(s) from received message queue
    Wed Oct 3 15:48:06 2018, 00001210, D, Asterisk Controller, Flushed 0 message(s) from sent message queue
    Wed Oct 3 15:48:06 2018, 00001259, I, Asterisk Controller, Stopped
    Wed Oct 3 15:48:06 2018, 00001303, I, Geo IP, Closed GeoIP database
    Wed Oct 3 15:48:06 2018, 00001307, D, Geo IP, Flushed 0 location(s) from geoIP cache
    Wed Oct 3 15:48:06 2018, 00001602, I, Controller, Pipe server stopping
    Wed Oct 3 15:48:06 2018, 00000201, I, Controller, Telnet server stopping
    Wed Oct 3 15:48:06 2018, 00000601, D, Security Event Queue, Security event queue stopping
    Wed Oct 3 15:48:06 2018, 00000604, D, Security Event Queue, Flushed 0 event(s) from queue
    Wed Oct 3 15:48:06 2018, 00002832, I, Controller, Recovery state will no longer be automatically saved
    Wed Oct 3 15:48:06 2018, 00002833, D, Controller, Initiating final recovery state save
    Wed Oct 3 15:48:06 2018, 00000905, D, Threat Info, Saved recovery state
    Wed Oct 3 15:48:06 2018, 00002808, D, Controller, firewall (iptables) not flushed on shutdown
    Wed Oct 3 15:48:07 2018, 00002823, D, Controller, Stopping – stage 2
    Wed Oct 3 15:48:07 2018, 00000800, D, Alert, Sent email: Stopping Normally
    Wed Oct 3 15:48:07 2018, 00000113, D, General, SecAst state changing to stopping
    Wed Oct 3 15:48:07 2018, 00002824, I, Controller, Stopped
    Wed Oct 3 15:48:07 2018, 00000101, I, General, SecAst terminating with exit code 0 (normal termination) after running for 34 seconds
    Wed Oct 3 15:48:09 2018, 00000100, I, General, SecAst version 1.5.9 starting as daemon under process ID 31226
    Wed Oct 3 15:48:09 2018, 00000100, D, General, SecAst Build 1157; Build date Monday June 25 2018 10:47:00 AM CEST; Architecture Intel 64-bit; Distribution unknown
    Wed Oct 3 15:48:09 2018, 00000111, D, General, SecAst state changing to starting
    Wed Oct 3 15:48:09 2018, 00001700, D, Database Controller, Database manager thread started
    Wed Oct 3 15:48:09 2018, 00001009, I, License, Unable to find license file ‘/usr/local/secast/secast.license’. Switching to Free Edition
    Wed Oct 3 15:48:09 2018, 00000122, I, General, Settings contained 0 information; 0 warning; and 0 error messages.
    Wed Oct 3 15:48:09 2018, 00000300, I, Controller, Telnet server listening on 0.0.0.0:3000
    Wed Oct 3 15:48:09 2018, 00001600, I, Controller, Pipe server listening on /run/secast.sock
    Wed Oct 3 15:48:09 2018, 00002810, D, Controller, firewall (iptables) not flushed on start
    Wed Oct 3 15:48:09 2018, 00001300, D, Geo IP, Found GeoIP database version 2.0.1501721259 updated Thursday August 3 2017 2:47:39 AM CEST
    Wed Oct 3 15:48:09 2018, 00001302, I, Geo IP, Opened GeoIP database
    Wed Oct 3 15:48:09 2018, 00000600, D, Security Event Queue, Security event queue starting
    Wed Oct 3 15:48:09 2018, 00000612, E, Security Event Queue, Adding 8 IP addresses found in firewall as managed addresses
    Wed Oct 3 15:48:09 2018, 00002835, D, Controller, Restoring recovery state from file
    Wed Oct 3 15:48:09 2018, 00002837, I, Controller, Restoring recovering state from file created by host ‘My VOIP PBX’ at Wed Oct 3 13:48:06 2018 GMT
    Wed Oct 3 15:48:09 2018, 00002831, I, Controller, Recovery state will be saved every 60 seconds
    Wed Oct 3 15:48:09 2018, 00001258, I, Asterisk Controller, Starting
    Wed Oct 3 15:48:09 2018, 00000902, D, Threat Info, Adding IP address ‘37.75.214.124’ to banned IP list
    Wed Oct 3 15:48:09 2018, 00000902, D, Threat Info, Adding IP address ‘185.85.241.179’ to banned IP list
    Wed Oct 3 15:48:09 2018, 00000902, D, Threat Info, Adding IP address ‘173.249.38.228’ to banned IP list
    Wed Oct 3 15:48:09 2018, 00000902, D, Threat Info, Adding IP address ‘104.206.96.186’ to banned IP list
    Wed Oct 3 15:48:09 2018, 00000902, D, Threat Info, Adding IP address ‘162.245.239.26’ to banned IP list
    Wed Oct 3 15:48:09 2018, 00000902, D, Threat Info, Adding IP address ‘185.53.91.49’ to banned IP list
    Wed Oct 3 15:48:09 2018, 00000902, D, Threat Info, Adding IP address ‘209.95.48.131’ to banned IP list
    Wed Oct 3 15:48:09 2018, 00000902, D, Threat Info, Adding IP address ‘173.249.32.182’ to banned IP list
    Wed Oct 3 15:48:09 2018, 00000900, D, Threat Info, Ignoring attempt to add recovery IP ‘37.75.214.124’ to banned IP list due to already present
    Wed Oct 3 15:48:09 2018, 00000900, D, Threat Info, Ignoring attempt to add recovery IP ‘185.85.241.179’ to banned IP list due to already present
    Wed Oct 3 15:48:09 2018, 00000900, D, Threat Info, Ignoring attempt to add recovery IP ‘173.249.38.228’ to banned IP list due to already present
    Wed Oct 3 15:48:09 2018, 00000900, D, Threat Info, Ignoring attempt to add recovery IP ‘104.206.96.186’ to banned IP list due to already present
    Wed Oct 3 15:48:09 2018, 00000900, D, Threat Info, Ignoring attempt to add recovery IP ‘162.245.239.26’ to banned IP list due to already present
    Wed Oct 3 15:48:09 2018, 00000900, D, Threat Info, Ignoring attempt to add recovery IP ‘185.53.91.49’ to banned IP list due to already present
    Wed Oct 3 15:48:09 2018, 00000900, D, Threat Info, Ignoring attempt to add recovery IP ‘209.95.48.131’ to banned IP list due to already present
    Wed Oct 3 15:48:09 2018, 00000900, D, Threat Info, Ignoring attempt to add recovery IP ‘173.249.32.182’ to banned IP list due to already present
    Wed Oct 3 15:48:09 2018, 00000800, D, Alert, Sent email: SecAst Starting
    Wed Oct 3 15:48:09 2018, 00000107, I, General, SecAst state changing to not protecting
    Wed Oct 3 15:48:09 2018, 00000800, D, Alert, Sent email: Entering Non-Protecting State
    Wed Oct 3 15:48:09 2018, 00001201, I, Asterisk Controller, Connection established to AMI
    Wed Oct 3 15:48:09 2018, 00001205, D, Asterisk Controller, Login to AMI succeeded
    Wed Oct 3 15:48:09 2018, 00000108, I, General, SecAst state changing to protecting
    Wed Oct 3 15:48:09 2018, 00000800, D, Alert, Sent email: Entering Protecting State
    Wed Oct 3 15:48:10 2018, 00002828, D, General, Installed SecAst version (1.5.9) at or beyond latest version (0.0.0) available for download
    Wed Oct 3 15:48:10 2018, 00001705, D, Database Controller, Opened database ‘secastdb1’ on host ‘localhost’
    Wed Oct 3 15:48:10 2018, 00001705, I, Database Controller, Database open for archiving
    Wed Oct 3 15:48:13 2018, 00001603, D, Socket Server, Connection 1: Connecting
    Wed Oct 3 15:48:13 2018, 00001605, D, Socket Server, Connection 1: Executing command [getdatabasestatus]
    Wed Oct 3 15:48:13 2018, 00001604, D, Socket Server, Connection 1: Disconnecting
    Wed Oct 3 15:48:13 2018, 00001603, D, Socket Server, Connection 2: Connecting
    Wed Oct 3 15:48:13 2018, 00001605, D, Socket Server, Connection 2: Executing command [getdatabasestatus]
    Wed Oct 3 15:48:13 2018, 00001605, D, Socket Server, Connection 2: Executing command [geteventloglist]
    Wed Oct 3 15:48:13 2018, 00000002, D, Socket Server, open db connection
    Wed Oct 3 15:48:13 2018, 00001611, D, Socket Server, Opened database [secastdb1] on host [localhost]
    Wed Oct 3 15:48:13 2018, 00001613, D, Socket Server, Database closed
    Wed Oct 3 15:48:13 2018, 00001604, D, Socket Server, Connection 2: Disconnecting
    Wed Oct 3 15:48:18 2018, 00001603, D, Socket Server, Connection 3: Connecting
    Wed Oct 3 15:48:18 2018, 00001605, D, Socket Server, Connection 3: Executing command [getdatabasestatus]
    Wed Oct 3 15:48:18 2018, 00001604, D, Socket Server, Connection 3: Disconnecting
    Wed Oct 3 15:48:23 2018, 00001603, D, Socket Server, Connection 4: Connecting
    Wed Oct 3 15:48:23 2018, 00001605, D, Socket Server, Connection 4: Executing command [getdatabasestatus]
    Wed Oct 3 15:48:23 2018, 00001604, D, Socket Server, Connection 4: Disconnecting
    Wed Oct 3 15:48:27 2018, 00001603, D, Socket Server, Connection 5: Connecting
    Wed Oct 3 15:48:27 2018, 00001605, D, Socket Server, Connection 5: Executing command [getdatabasestatus]
    Wed Oct 3 15:48:27 2018, 00001605, D, Socket Server, Connection 5: Executing command [gethistoricalbannediplist]
    Wed Oct 3 15:48:27 2018, 00000002, D, Socket Server, open db connection
    Wed Oct 3 15:48:27 2018, 00001611, D, Socket Server, Opened database [secastdb1] on host [localhost]
    Wed Oct 3 15:48:27 2018, 00001613, D, Socket Server, Database closed
    Wed Oct 3 15:48:27 2018, 00001604, D, Socket Server, Connection 5: Disconnecting
    Wed Oct 3 15:48:29 2018, 00001603, D, Socket Server, Connection 6: Connecting
    Wed Oct 3 15:48:29 2018, 00001605, D, Socket Server, Connection 6: Executing command [getdatabasestatus]
    Wed Oct 3 15:48:29 2018, 00001605, D, Socket Server, Connection 6: Executing command [geteventloglist]
    Wed Oct 3 15:48:29 2018, 00000002, D, Socket Server, open db connection
    Wed Oct 3 15:48:29 2018, 00001611, D, Socket Server, Opened database [secastdb1] on host [localhost]
    Wed Oct 3 15:48:29 2018, 00001613, D, Socket Server, Database closed
    Wed Oct 3 15:48:29 2018, 00001604, D, Socket Server, Connection 6: Disconnecting
    Wed Oct 3 15:48:34 2018, 00001603, D, Socket Server, Connection 7: Connecting
    Wed Oct 3 15:48:34 2018, 00001605, D, Socket Server, Connection 7: Executing command [getdatabasestatus]
    Wed Oct 3 15:48:34 2018, 00001604, D, Socket Server, Connection 7: Disconnecting
    Wed Oct 3 15:48:39 2018, 00001603, D, Socket Server, Connection 8: Connecting
    Wed Oct 3 15:48:39 2018, 00001605, D, Socket Server, Connection 8: Executing command [getdatabasestatus]
    Wed Oct 3 15:48:39 2018, 00001604, D, Socket Server, Connection 8: Disconnecting
    Wed Oct 3 15:48:44 2018, 00001603, D, Socket Server, Connection 9: Connecting
    Wed Oct 3 15:48:44 2018, 00001605, D, Socket Server, Connection 9: Executing command [getdatabasestatus]
    Wed Oct 3 15:48:44 2018, 00001604, D, Socket Server, Connection 9: Disconnecting
    Wed Oct 3 15:48:50 2018, 00001603, D, Socket Server, Connection 10: Connecting
    Wed Oct 3 15:48:50 2018, 00001605, D, Socket Server, Connection 10: Executing command [getdatabasestatus]
    Wed Oct 3 15:48:50 2018, 00001604, D, Socket Server, Connection 10: Disconnecting
    Wed Oct 3 15:48:53 2018, 00001603, D, Socket Server, Connection 11: Connecting
    Wed Oct 3 15:48:53 2018, 00001605, D, Socket Server, Connection 11: Executing command [getdatabasestatus]
    Wed Oct 3 15:48:53 2018, 00001605, D, Socket Server, Connection 11: Executing command [geteventloglist]
    Wed Oct 3 15:48:53 2018, 00000002, D, Socket Server, open db connection
    Wed Oct 3 15:48:53 2018, 00001611, D, Socket Server, Opened database [secastdb1] on host [localhost]
    Wed Oct 3 15:48:53 2018, 00001613, D, Socket Server, Database closed
    Wed Oct 3 15:48:53 2018, 00001604, D, Socket Server, Connection 11: Disconnecting
    Wed Oct 3 15:48:55 2018, 00001603, D, Socket Server, Connection 12: Connecting
    Wed Oct 3 15:48:55 2018, 00001605, D, Socket Server, Connection 12: Executing command [getdatabasestatus]
    Wed Oct 3 15:48:55 2018, 00001605, D, Socket Server, Connection 12: Executing command [geteventloglist]
    Wed Oct 3 15:48:55 2018, 00000002, D, Socket Server, open db connection
    Wed Oct 3 15:48:55 2018, 00001611, D, Socket Server, Opened database [secastdb1] on host [localhost]
    Wed Oct 3 15:48:55 2018, 00001613, D, Socket Server, Database closed
    Wed Oct 3 15:48:55 2018, 00001604, D, Socket Server, Connection 12: Disconnecting
    Wed Oct 3 15:49:00 2018, 00001603, D, Socket Server, Connection 13: Connecting
    Wed Oct 3 15:49:00 2018, 00001605, D, Socket Server, Connection 13: Executing command [getdatabasestatus]
    Wed Oct 3 15:49:00 2018, 00001604, D, Socket Server, Connection 13: Disconnecting
    Wed Oct 3 15:49:05 2018, 00001603, D, Socket Server, Connection 14: Connecting
    Wed Oct 3 15:49:05 2018, 00001605, D, Socket Server, Connection 14: Executing command [getdatabasestatus]
    Wed Oct 3 15:49:05 2018, 00001604, D, Socket Server, Connection 14: Disconnecting
    Wed Oct 3 15:49:08 2018, 00000905, D, Threat Info, Saved recovery state
    Wed Oct 3 15:49:10 2018, 00001603, D, Socket Server, Connection 15: Connecting
    Wed Oct 3 15:49:10 2018, 00001605, D, Socket Server, Connection 15: Executing command [getdatabasestatus]
    Wed Oct 3 15:49:10 2018, 00001604, D, Socket Server, Connection 15: Disconnecting
    Wed Oct 3 15:49:16 2018, 00001603, D, Socket Server, Connection 16: Connecting
    Wed Oct 3 15:49:16 2018, 00001605, D, Socket Server, Connection 16: Executing command [getdatabasestatus]
    Wed Oct 3 15:49:16 2018, 00001604, D, Socket Server, Connection 16: Disconnecting
    Wed Oct 3 15:49:21 2018, 00001603, D, Socket Server, Connection 17: Connecting
    Wed Oct 3 15:49:21 2018, 00001605, D, Socket Server, Connection 17: Executing command [getdatabasestatus]
    Wed Oct 3 15:49:21 2018, 00001604, D, Socket Server, Connection 17: Disconnecting
    Wed Oct 3 15:49:26 2018, 00001603, D, Socket Server, Connection 18: Connecting
    Wed Oct 3 15:49:26 2018, 00001605, D, Socket Server, Connection 18: Executing command [getdatabasestatus]
    Wed Oct 3 15:49:26 2018, 00001604, D, Socket Server, Connection 18: Disconnecting
    Wed Oct 3 15:49:31 2018, 00001603, D, Socket Server, Connection 19: Connecting
    Wed Oct 3 15:49:31 2018, 00001605, D, Socket Server, Connection 19: Executing command [getdatabasestatus]
    Wed Oct 3 15:49:31 2018, 00001604, D, Socket Server, Connection 19: Disconnecting
    Wed Oct 3 15:49:36 2018, 00001603, D, Socket Server, Connection 20: Connecting
    Wed Oct 3 15:49:36 2018, 00001605, D, Socket Server, Connection 20: Executing command [getdatabasestatus]
    Wed Oct 3 15:49:36 2018, 00001604, D, Socket Server, Connection 20: Disconnecting
    Wed Oct 3 15:49:41 2018, 00001603, D, Socket Server, Connection 21: Connecting
    Wed Oct 3 15:49:41 2018, 00001605, D, Socket Server, Connection 21: Executing command [getdatabasestatus]
    Wed Oct 3 15:49:41 2018, 00001604, D, Socket Server, Connection 21: Disconnecting
    Wed Oct 3 15:49:46 2018, 00001603, D, Socket Server, Connection 22: Connecting
    Wed Oct 3 15:49:46 2018, 00001605, D, Socket Server, Connection 22: Executing command [getdatabasestatus]
    Wed Oct 3 15:49:46 2018, 00001604, D, Socket Server, Connection 22: Disconnecting
    Wed Oct 3 15:49:51 2018, 00001603, D, Socket Server, Connection 23: Connecting
    Wed Oct 3 15:49:51 2018, 00001605, D, Socket Server, Connection 23: Executing command [getdatabasestatus]
    Wed Oct 3 15:49:51 2018, 00001604, D, Socket Server, Connection 23: Disconnecting
    Wed Oct 3 15:49:56 2018, 00001603, D, Socket Server, Connection 24: Connecting
    Wed Oct 3 15:49:56 2018, 00001605, D, Socket Server, Connection 24: Executing command [getdatabasestatus]
    Wed Oct 3 15:49:56 2018, 00001604, D, Socket Server, Connection 24: Disconnecting
    Wed Oct 3 15:50:01 2018, 00001603, D, Socket Server, Connection 25: Connecting
    Wed Oct 3 15:50:01 2018, 00001605, D, Socket Server, Connection 25: Executing command [getdatabasestatus]
    Wed Oct 3 15:50:01 2018, 00001604, D, Socket Server, Connection 25: Disconnecting
    Wed Oct 3 15:50:06 2018, 00001603, D, Socket Server, Connection 26: Connecting
    Wed Oct 3 15:50:06 2018, 00001605, D, Socket Server, Connection 26: Executing command [getdatabasestatus]
    Wed Oct 3 15:50:06 2018, 00001604, D, Socket Server, Connection 26: Disconnecting
    Wed Oct 3 15:50:08 2018, 00000905, D, Threat Info, Saved recovery state
    Wed Oct 3 15:50:11 2018, 00001603, D, Socket Server, Connection 27: Connecting
    Wed Oct 3 15:50:11 2018, 00001605, D, Socket Server, Connection 27: Executing command [getdatabasestatus]
    Wed Oct 3 15:50:11 2018, 00001604, D, Socket Server, Connection 27: Disconnecting
    Wed Oct 3 15:50:16 2018, 00001603, D, Socket Server, Connection 28: Connecting
    Wed Oct 3 15:50:16 2018, 00001605, D, Socket Server, Connection 28: Executing command [getdatabasestatus]
    Wed Oct 3 15:50:16 2018, 00001604, D, Socket Server, Connection 28: Disconnecting
    Wed Oct 3 15:50:22 2018, 00001603, D, Socket Server, Connection 29: Connecting
    Wed Oct 3 15:50:22 2018, 00001605, D, Socket Server, Connection 29: Executing command [getdatabasestatus]
    Wed Oct 3 15:50:22 2018, 00001604, D, Socket Server, Connection 29: Disconnecting
    Wed Oct 3 15:50:27 2018, 00001603, D, Socket Server, Connection 30: Connecting
    Wed Oct 3 15:50:27 2018, 00001605, D, Socket Server, Connection 30: Executing command [getdatabasestatus]
    Wed Oct 3 15:50:27 2018, 00001604, D, Socket Server, Connection 30: Disconnecting
    Wed Oct 3 15:50:32 2018, 00001603, D, Socket Server, Connection 31: Connecting
    Wed Oct 3 15:50:32 2018, 00001605, D, Socket Server, Connection 31: Executing command [getdatabasestatus]
    Wed Oct 3 15:50:32 2018, 00001604, D, Socket Server, Connection 31: Disconnecting
    Wed Oct 3 15:50:37 2018, 00001603, D, Socket Server, Connection 32: Connecting
    Wed Oct 3 15:50:37 2018, 00001605, D, Socket Server, Connection 32: Executing command [getdatabasestatus]
    Wed Oct 3 15:50:37 2018, 00001604, D, Socket Server, Connection 32: Disconnecting
    Wed Oct 3 15:50:42 2018, 00001603, D, Socket Server, Connection 33: Connecting
    Wed Oct 3 15:50:42 2018, 00001605, D, Socket Server, Connection 33: Executing command [getdatabasestatus]
    Wed Oct 3 15:50:42 2018, 00001604, D, Socket Server, Connection 33: Disconnecting
    Wed Oct 3 15:50:47 2018, 00001603, D, Socket Server, Connection 34: Connecting
    Wed Oct 3 15:50:47 2018, 00001605, D, Socket Server, Connection 34: Executing command [getdatabasestatus]
    Wed Oct 3 15:50:47 2018, 00001604, D, Socket Server, Connection 34: Disconnecting
    Wed Oct 3 15:50:52 2018, 00001603, D, Socket Server, Connection 35: Connecting
    Wed Oct 3 15:50:52 2018, 00001605, D, Socket Server, Connection 35: Executing command [getdatabasestatus]
    Wed Oct 3 15:50:52 2018, 00001604, D, Socket Server, Connection 35: Disconnecting
    Wed Oct 3 15:50:57 2018, 00001603, D, Socket Server, Connection 36: Connecting
    Wed Oct 3 15:50:57 2018, 00001605, D, Socket Server, Connection 36: Executing command [getdatabasestatus]
    Wed Oct 3 15:50:57 2018, 00001604, D, Socket Server, Connection 36: Disconnecting
    Wed Oct 3 15:51:02 2018, 00001603, D, Socket Server, Connection 37: Connecting
    Wed Oct 3 15:51:02 2018, 00001605, D, Socket Server, Connection 37: Executing command [getdatabasestatus]
    Wed Oct 3 15:51:02 2018, 00001604, D, Socket Server, Connection 37: Disconnecting
    Wed Oct 3 15:51:07 2018, 00001603, D, Socket Server, Connection 38: Connecting
    Wed Oct 3 15:51:07 2018, 00001605, D, Socket Server, Connection 38: Executing command [getdatabasestatus]
    Wed Oct 3 15:51:07 2018, 00001604, D, Socket Server, Connection 38: Disconnecting
    Wed Oct 3 15:51:08 2018, 00000905, D, Threat Info, Saved recovery state
    Wed Oct 3 15:51:12 2018, 00001603, D, Socket Server, Connection 39: Connecting
    Wed Oct 3 15:51:12 2018, 00001605, D, Socket Server, Connection 39: Executing command [getdatabasestatus]
    Wed Oct 3 15:51:12 2018, 00001604, D, Socket Server, Connection 39: Disconnecting
    Wed Oct 3 15:51:17 2018, 00001603, D, Socket Server, Connection 40: Connecting
    Wed Oct 3 15:51:17 2018, 00001605, D, Socket Server, Connection 40: Executing command [getdatabasestatus]
    Wed Oct 3 15:51:17 2018, 00001604, D, Socket Server, Connection 40: Disconnecting
    Wed Oct 3 15:51:22 2018, 00001603, D, Socket Server, Connection 41: Connecting
    Wed Oct 3 15:51:22 2018, 00001605, D, Socket Server, Connection 41: Executing command [getdatabasestatus]
    Wed Oct 3 15:51:22 2018, 00001604, D, Socket Server, Connection 41: Disconnecting
    Wed Oct 3 15:51:27 2018, 00001603, D, Socket Server, Connection 42: Connecting
    Wed Oct 3 15:51:27 2018, 00001605, D, Socket Server, Connection 42: Executing command [getdatabasestatus]
    Wed Oct 3 15:51:27 2018, 00001604, D, Socket Server, Connection 42: Disconnecting
    Wed Oct 3 15:51:32 2018, 00001603, D, Socket Server, Connection 43: Connecting
    Wed Oct 3 15:51:32 2018, 00001605, D, Socket Server, Connection 43: Executing command [getdatabasestatus]
    Wed Oct 3 15:51:32 2018, 00001604, D, Socket Server, Connection 43: Disconnecting
    Wed Oct 3 15:51:38 2018, 00001603, D, Socket Server, Connection 44: Connecting
    Wed Oct 3 15:51:38 2018, 00001605, D, Socket Server, Connection 44: Executing command [getdatabasestatus]
    Wed Oct 3 15:51:38 2018, 00001604, D, Socket Server, Connection 44: Disconnecting
    Wed Oct 3 15:51:43 2018, 00001603, D, Socket Server, Connection 45: Connecting
    Wed Oct 3 15:51:43 2018, 00001605, D, Socket Server, Connection 45: Executing command [getdatabasestatus]
    Wed Oct 3 15:51:43 2018, 00001604, D, Socket Server, Connection 45: Disconnecting
    Wed Oct 3 15:51:48 2018, 00001603, D, Socket Server, Connection 46: Connecting
    Wed Oct 3 15:51:48 2018, 00001605, D, Socket Server, Connection 46: Executing command [getdatabasestatus]
    Wed Oct 3 15:51:48 2018, 00001604, D, Socket Server, Connection 46: Disconnecting
    Wed Oct 3 15:51:53 2018, 00001603, D, Socket Server, Connection 47: Connecting
    Wed Oct 3 15:51:53 2018, 00001605, D, Socket Server, Connection 47: Executing command [getdatabasestatus]
    Wed Oct 3 15:51:53 2018, 00001604, D, Socket Server, Connection 47: Disconnecting
    Wed Oct 3 15:51:58 2018, 00001603, D, Socket Server, Connection 48: Connecting
    Wed Oct 3 15:51:58 2018, 00001605, D, Socket Server, Connection 48: Executing command [getdatabasestatus]
    Wed Oct 3 15:51:58 2018, 00001604, D, Socket Server, Connection 48: Disconnecting
    Wed Oct 3 15:52:03 2018, 00001603, D, Socket Server, Connection 49: Connecting
    Wed Oct 3 15:52:03 2018, 00001605, D, Socket Server, Connection 49: Executing command [getdatabasestatus]
    Wed Oct 3 15:52:03 2018, 00001604, D, Socket Server, Connection 49: Disconnecting
    Wed Oct 3 15:52:08 2018, 00001603, D, Socket Server, Connection 50: Connecting
    Wed Oct 3 15:52:08 2018, 00001605, D, Socket Server, Connection 50: Executing command [getdatabasestatus]
    Wed Oct 3 15:52:08 2018, 00001604, D, Socket Server, Connection 50: Disconnecting
    Wed Oct 3 15:52:08 2018, 00000905, D, Threat Info, Saved recovery state
    Wed Oct 3 15:52:13 2018, 00001603, D, Socket Server, Connection 51: Connecting
    Wed Oct 3 15:52:13 2018, 00001605, D, Socket Server, Connection 51: Executing command [getdatabasestatus]
    Wed Oct 3 15:52:13 2018, 00001604, D, Socket Server, Connection 51: Disconnecting
    Wed Oct 3 15:52:18 2018, 00001603, D, Socket Server, Connection 52: Connecting
    Wed Oct 3 15:52:18 2018, 00001605, D, Socket Server, Connection 52: Executing command [getdatabasestatus]
    Wed Oct 3 15:52:18 2018, 00001604, D, Socket Server, Connection 52: Disconnecting
    Wed Oct 3 15:52:23 2018, 00001603, D, Socket Server, Connection 53: Connecting
    Wed Oct 3 15:52:23 2018, 00001605, D, Socket Server, Connection 53: Executing command [getdatabasestatus]
    Wed Oct 3 15:52:23 2018, 00001604, D, Socket Server, Connection 53: Disconnecting
    Wed Oct 3 15:52:28 2018, 00001603, D, Socket Server, Connection 54: Connecting
    Wed Oct 3 15:52:28 2018, 00001605, D, Socket Server, Connection 54: Executing command [getdatabasestatus]
    Wed Oct 3 15:52:28 2018, 00001604, D, Socket Server, Connection 54: Disconnecting
    Wed Oct 3 15:52:33 2018, 00001603, D, Socket Server, Connection 55: Connecting
    Wed Oct 3 15:52:33 2018, 00001605, D, Socket Server, Connection 55: Executing command [getdatabasestatus]
    Wed Oct 3 15:52:33 2018, 00001604, D, Socket Server, Connection 55: Disconnecting
    Wed Oct 3 15:52:38 2018, 00001603, D, Socket Server, Connection 56: Connecting
    Wed Oct 3 15:52:38 2018, 00001605, D, Socket Server, Connection 56: Executing command [getdatabasestatus]
    Wed Oct 3 15:52:38 2018, 00001604, D, Socket Server, Connection 56: Disconnecting
    Wed Oct 3 15:52:43 2018, 00001603, D, Socket Server, Connection 57: Connecting
    Wed Oct 3 15:52:43 2018, 00001605, D, Socket Server, Connection 57: Executing command [getdatabasestatus]
    Wed Oct 3 15:52:43 2018, 00001604, D, Socket Server, Connection 57: Disconnecting
    Wed Oct 3 15:52:49 2018, 00001603, D, Socket Server, Connection 58: Connecting
    Wed Oct 3 15:52:49 2018, 00001605, D, Socket Server, Connection 58: Executing command [getdatabasestatus]
    Wed Oct 3 15:52:49 2018, 00001604, D, Socket Server, Connection 58: Disconnecting
    Wed Oct 3 15:52:54 2018, 00001603, D, Socket Server, Connection 59: Connecting
    Wed Oct 3 15:52:54 2018, 00001605, D, Socket Server, Connection 59: Executing command [getdatabasestatus]
    Wed Oct 3 15:52:54 2018, 00001604, D, Socket Server, Connection 59: Disconnecting
    Wed Oct 3 15:52:59 2018, 00001603, D, Socket Server, Connection 60: Connecting
    Wed Oct 3 15:52:59 2018, 00001605, D, Socket Server, Connection 60: Executing command [getdatabasestatus]
    Wed Oct 3 15:52:59 2018, 00001604, D, Socket Server, Connection 60: Disconnecting
    Wed Oct 3 15:53:04 2018, 00001603, D, Socket Server, Connection 61: Connecting
    Wed Oct 3 15:53:04 2018, 00001605, D, Socket Server, Connection 61: Executing command [getdatabasestatus]
    Wed Oct 3 15:53:04 2018, 00001604, D, Socket Server, Connection 61: Disconnecting
    Wed Oct 3 15:53:08 2018, 00000905, D, Threat Info, Saved recovery state
    Wed Oct 3 15:53:09 2018, 00001603, D, Socket Server, Connection 62: Connecting
    Wed Oct 3 15:53:09 2018, 00001605, D, Socket Server, Connection 62: Executing command [getdatabasestatus]
    Wed Oct 3 15:53:09 2018, 00001604, D, Socket Server, Connection 62: Disconnecting
    Wed Oct 3 15:53:14 2018, 00001603, D, Socket Server, Connection 63: Connecting
    Wed Oct 3 15:53:14 2018, 00001605, D, Socket Server, Connection 63: Executing command [getdatabasestatus]
    Wed Oct 3 15:53:14 2018, 00001604, D, Socket Server, Connection 63: Disconnecting
    Wed Oct 3 15:53:19 2018, 00001603, D, Socket Server, Connection 64: Connecting
    Wed Oct 3 15:53:19 2018, 00001605, D, Socket Server, Connection 64: Executing command [getdatabasestatus]
    Wed Oct 3 15:53:19 2018, 00001604, D, Socket Server, Connection 64: Disconnecting
    Wed Oct 3 15:53:24 2018, 00001603, D, Socket Server, Connection 65: Connecting
    Wed Oct 3 15:53:24 2018, 00001605, D, Socket Server, Connection 65: Executing command [getdatabasestatus]
    Wed Oct 3 15:53:24 2018, 00001604, D, Socket Server, Connection 65: Disconnecting
    Wed Oct 3 15:53:29 2018, 00001603, D, Socket Server, Connection 66: Connecting
    Wed Oct 3 15:53:29 2018, 00001605, D, Socket Server, Connection 66: Executing command [getdatabasestatus]
    Wed Oct 3 15:53:29 2018, 00001604, D, Socket Server, Connection 66: Disconnecting
    Wed Oct 3 15:53:34 2018, 00001603, D, Socket Server, Connection 67: Connecting
    Wed Oct 3 15:53:34 2018, 00001605, D, Socket Server, Connection 67: Executing command [getdatabasestatus]
    Wed Oct 3 15:53:34 2018, 00001604, D, Socket Server, Connection 67: Disconnecting
    Wed Oct 3 15:53:39 2018, 00001603, D, Socket Server, Connection 68: Connecting
    Wed Oct 3 15:53:39 2018, 00001605, D, Socket Server, Connection 68: Executing command [getdatabasestatus]
    Wed Oct 3 15:53:39 2018, 00001604, D, Socket Server, Connection 68: Disconnecting
    Wed Oct 3 15:53:45 2018, 00001603, D, Socket Server, Connection 69: Connecting
    Wed Oct 3 15:53:45 2018, 00001605, D, Socket Server, Connection 69: Executing command [getdatabasestatus]
    Wed Oct 3 15:53:45 2018, 00001604, D, Socket Server, Connection 69: Disconnecting
    Wed Oct 3 15:53:50 2018, 00001603, D, Socket Server, Connection 70: Connecting
    Wed Oct 3 15:53:50 2018, 00001605, D, Socket Server, Connection 70: Executing command [getdatabasestatus]
    Wed Oct 3 15:53:50 2018, 00001604, D, Socket Server, Connection 70: Disconnecting
    Wed Oct 3 15:53:55 2018, 00001603, D, Socket Server, Connection 71: Connecting
    Wed Oct 3 15:53:55 2018, 00001605, D, Socket Server, Connection 71: Executing command [getdatabasestatus]
    Wed Oct 3 15:53:55 2018, 00001604, D, Socket Server, Connection 71: Disconnecting
    Wed Oct 3 15:54:00 2018, 00001603, D, Socket Server, Connection 72: Connecting
    Wed Oct 3 15:54:00 2018, 00001605, D, Socket Server, Connection 72: Executing command [getdatabasestatus]
    Wed Oct 3 15:54:00 2018, 00001604, D, Socket Server, Connection 72: Disconnecting
    Wed Oct 3 15:54:05 2018, 00001603, D, Socket Server, Connection 73: Connecting
    Wed Oct 3 15:54:05 2018, 00001605, D, Socket Server, Connection 73: Executing command [getdatabasestatus]
    Wed Oct 3 15:54:05 2018, 00001604, D, Socket Server, Connection 73: Disconnecting
    Wed Oct 3 15:54:08 2018, 00000905, D, Threat Info, Saved recovery state
    Wed Oct 3 15:54:10 2018, 00001603, D, Socket Server, Connection 74: Connecting
    Wed Oct 3 15:54:10 2018, 00001605, D, Socket Server, Connection 74: Executing command [getdatabasestatus]
    Wed Oct 3 15:54:10 2018, 00001604, D, Socket Server, Connection 74: Disconnecting
    Wed Oct 3 15:54:15 2018, 00001603, D, Socket Server, Connection 75: Connecting
    Wed Oct 3 15:54:15 2018, 00001605, D, Socket Server, Connection 75: Executing command [getdatabasestatus]
    Wed Oct 3 15:54:15 2018, 00001604, D, Socket Server, Connection 75: Disconnecting
    Wed Oct 3 15:54:20 2018, 00001603, D, Socket Server, Connection 76: Connecting
    Wed Oct 3 15:54:20 2018, 00001605, D, Socket Server, Connection 76: Executing command [getdatabasestatus]
    Wed Oct 3 15:54:20 2018, 00001604, D, Socket Server, Connection 76: Disconnecting
    Wed Oct 3 15:54:25 2018, 00001603, D, Socket Server, Connection 77: Connecting
    Wed Oct 3 15:54:25 2018, 00001605, D, Socket Server, Connection 77: Executing command [getdatabasestatus]
    Wed Oct 3 15:54:25 2018, 00001604, D, Socket Server, Connection 77: Disconnecting
    Wed Oct 3 15:54:31 2018, 00001603, D, Socket Server, Connection 78: Connecting
    Wed Oct 3 15:54:31 2018, 00001605, D, Socket Server, Connection 78: Executing command [getdatabasestatus]
    Wed Oct 3 15:54:31 2018, 00001604, D, Socket Server, Connection 78: Disconnecting
    Wed Oct 3 15:54:37 2018, 00001603, D, Socket Server, Connection 79: Connecting
    Wed Oct 3 15:54:37 2018, 00001605, D, Socket Server, Connection 79: Executing command [getdatabasestatus]
    Wed Oct 3 15:54:37 2018, 00001604, D, Socket Server, Connection 79: Disconnecting
    Wed Oct 3 15:54:43 2018, 00001603, D, Socket Server, Connection 80: Connecting
    Wed Oct 3 15:54:43 2018, 00001605, D, Socket Server, Connection 80: Executing command [getdatabasestatus]
    Wed Oct 3 15:54:43 2018, 00001604, D, Socket Server, Connection 80: Disconnecting
    Wed Oct 3 15:54:49 2018, 00001603, D, Socket Server, Connection 81: Connecting
    Wed Oct 3 15:54:49 2018, 00001605, D, Socket Server, Connection 81: Executing command [getdatabasestatus]
    Wed Oct 3 15:54:49 2018, 00001604, D, Socket Server, Connection 81: Disconnecting
    Wed Oct 3 15:54:55 2018, 00001603, D, Socket Server, Connection 82: Connecting
    Wed Oct 3 15:54:55 2018, 00001605, D, Socket Server, Connection 82: Executing command [getdatabasestatus]
    Wed Oct 3 15:54:55 2018, 00001604, D, Socket Server, Connection 82: Disconnecting
    Wed Oct 3 15:55:01 2018, 00001603, D, Socket Server, Connection 83: Connecting
    Wed Oct 3 15:55:01 2018, 00001605, D, Socket Server, Connection 83: Executing command [getdatabasestatus]
    Wed Oct 3 15:55:01 2018, 00001604, D, Socket Server, Connection 83: Disconnecting
    Wed Oct 3 15:55:07 2018, 00001603, D, Socket Server, Connection 84: Connecting
    Wed Oct 3 15:55:07 2018, 00001605, D, Socket Server, Connection 84: Executing command [getdatabasestatus]
    Wed Oct 3 15:55:07 2018, 00001604, D, Socket Server, Connection 84: Disconnecting
    Wed Oct 3 15:55:08 2018, 00000905, D, Threat Info, Saved recovery state
    Wed Oct 3 15:55:13 2018, 00001603, D, Socket Server, Connection 85: Connecting
    Wed Oct 3 15:55:13 2018, 00001605, D, Socket Server, Connection 85: Executing command [getdatabasestatus]
    Wed Oct 3 15:55:13 2018, 00001604, D, Socket Server, Connection 85: Disconnecting
    Wed Oct 3 15:55:19 2018, 00001603, D, Socket Server, Connection 86: Connecting
    Wed Oct 3 15:55:19 2018, 00001605, D, Socket Server, Connection 86: Executing command [getdatabasestatus]
    Wed Oct 3 15:55:19 2018, 00001604, D, Socket Server, Connection 86: Disconnecting
    Wed Oct 3 15:55:25 2018, 00001603, D, Socket Server, Connection 87: Connecting
    Wed Oct 3 15:55:25 2018, 00001605, D, Socket Server, Connection 87: Executing command [getdatabasestatus]
    Wed Oct 3 15:55:25 2018, 00001604, D, Socket Server, Connection 87: Disconnecting
    Wed Oct 3 15:55:31 2018, 00001603, D, Socket Server, Connection 88: Connecting
    Wed Oct 3 15:55:31 2018, 00001605, D, Socket Server, Connection 88: Executing command [getdatabasestatus]
    Wed Oct 3 15:55:31 2018, 00001604, D, Socket Server, Connection 88: Disconnecting
    Wed Oct 3 15:55:37 2018, 00001603, D, Socket Server, Connection 89: Connecting
    Wed Oct 3 15:55:37 2018, 00001605, D, Socket Server, Connection 89: Executing command [getdatabasestatus]
    Wed Oct 3 15:55:37 2018, 00001604, D, Socket Server, Connection 89: Disconnecting

    • This reply was modified 4 years, 11 months ago by WebMaster.
    Avatar photoTelium Support Group
    Participant
    October 5, 2018 at 2:57 am
    Post count: 265
    #6790

    Could you post the [database] stanza of your secast.conf file?

    Does the contents of the database appear correct in the web interface?

    Avatar photoTelium Support Group
    Participant
    October 5, 2018 at 12:47 pm
    Post count: 265
    #6792

    It looks like your MySQL server database is closing the connection – causing SecAst to constantly reopen the connection. Normally a support rep would connect to your system by SSH to look for a MySQL related issue, or to capture more detail about the cause of the database closure. As you are running the free edition we can’t assist much further, but I’ve opened a ticket to see if we can reproduce this in our lab prior to our next release. Could you post your Linux distro, version, and architecture? (So I can add to the ticket)

    teliumcustomer4
    Participant
    October 8, 2018 at 5:30 pm
    Post count: 3
    #6793

    Ok, no problem anyway seems all working, and banning ip works like a charm.

    The system is debian9 on aruba.it vps, VMware it’s little pbx
    Linux 4.9.0-8-amd64 x86_64 GNU/Linux

  • Author
    Posts
Viewing 6 posts - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.