Database command failed on write to eventlog table

Features, capabilities, and information about SecAst
Post Reply
reinstaller
Posts: 4
Joined: Sat Sep 29, 2018 7:18 pm

Database command failed on write to eventlog table

Post by reinstaller » Sat Sep 29, 2018 7:23 pm

I'm seeing this error in Event Log.

Everything seems to work well, what can be wrong?

Code: Select all

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
User avatar
Telium Support
Posts: 184
Joined: Sun Nov 27, 2016 3:27 pm

Re: Database command failed on write to eventlog table

Post by Telium Support » Sun Sep 30, 2018 12:55 am

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.
reinstaller
Posts: 4
Joined: Sat Sep 29, 2018 7:18 pm

Re: Database command failed on write to eventlog table

Post by reinstaller » Wed Oct 03, 2018 2:05 pm

Its contiguous and database are in same server

With dblevel=debug after restart secast, direct log:

Code: Select all

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
User avatar
Telium Support
Posts: 184
Joined: Sun Nov 27, 2016 3:27 pm

Re: Database command failed on write to eventlog table

Post by Telium Support » Fri Oct 05, 2018 2:57 am

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

Does the contents of the database appear correct in the web interface?
reinstaller
Posts: 4
Joined: Sat Sep 29, 2018 7:18 pm

Re: Database command failed on write to eventlog table

Post by reinstaller » Fri Oct 05, 2018 7:50 am

Code: Select all

[database]  ;=================================================================
; This stanza provides access details for the (optional) SQL database, as
; well as control of how data is retained.

; Whether or not to enable use of a database for read/write
;   Valid values include Yes/True/1 / No/False/0
;   If left blank will default to false
enabled=true

; Which database driver should be used.  At this time only "mysql" is accepted.
; If left blank will default to "mysql"
;   Valid values include mysql
driver=mysql

; Name of the host which contains the database.  This can be localhost, the
; ip of a host, or the fully qualified domain name of a host.
; If left blank will default to "localhost"
hostname=localhost

; Name of the database which will contain the the SecAst tables.
; If left blank will default to "secast"
; default: secast
databasename=secastdb1

; Username for database access
; default: secastun
username="secast"

; Password for database access
; default: secastpw
password="xxxxxxxx"

; Database can hold records from multiple SecAst hosts (in the event of a 
; cluster).  Upon purging old records, should SecAst delete all records of
; the specified type, or only those which originated from this hostname.
;   Valid values: Yes/True/1 / No/False/0
;   Default value: false
purgeonlyown=false
Image

Image


This?
The password of database are modified
User avatar
Telium Support
Posts: 184
Joined: Sun Nov 27, 2016 3:27 pm

Re: Database command failed on write to eventlog table

Post by Telium Support » Fri Oct 05, 2018 12:47 pm

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)
reinstaller
Posts: 4
Joined: Sat Sep 29, 2018 7:18 pm

Re: Database command failed on write to eventlog table

Post by reinstaller » Mon Oct 08, 2018 5:30 pm

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
Post Reply