SIEM logs not generating in MYSQL database
ERROR DESCRIPTION:- Inside the SIEMEnvision Table we are not receiving the logs.
Troubleshooting: Check the event viewer logs for SIEM Service. If we are getting the error message as "You are using the Safe update Mode and you tied to update a table without a WHERE that uses a KEY column" kindly follow the resolution steps mentioned.
Screenshot:-
RESOLUTION:-
How to fix Error Code 1175
Turn OFF "Safe Update Mode" temporary
SET SQL_SAFE_UPDATES = 0;
UPDATE options SET title= 'kiemvieclam24h' WHERE url = 'http://kiemvieclam24h.net';
SET SQL_SAFE_UPDATES = 1;
Turn OFF "Safe Update Mode" forever
Mysql workbench 8.0:
MySQL Workbench => [ Edit ] => [ Preferences ] -> [ SQL Editor ] -> Uncheck "Safe Updates"
Old version can:
MySQL Workbench => [Edit] => [Preferences] => [SQL Queries]Related Articles
Video Logs Consume more Size Issue After Archival.
Der Team, Sometime we face storage issue from our multiple customer for the video logs. So we have a configuration in the Log Archival config file & in global configuration as mentioned below. Which will reduce the size & length of the video by doing ...How to Implement PYLAS Service on windows server
Prerequisites - Pylas service and Database server Credentials required to created db file Steps to install - 1. Steps to create DB file - Navigate to the main package folder and then to the "pySRV-LAS-240408\Utilities\DB-ENC" directory. Locate the ...Enable Service from database when not visible in Modify service type.
If you want to enable a service but not able to find the service in Modify Service Type. Solution Connect to ARCON Database ARCOSDB. Run the below query with the Connector you want to enable. select * from sso_table_values where tbv_description like ...How to resolve error message "EXECUTE permission was denied on the object 'usp_GetSelectData', database 'ARCOSDB', schema 'dbo'."
How to resolve error "EXECUTE permission was denied on the object 'usp_GetSelectData', database 'ARCOSDB', schema 'dbo'." while hosting ACMO page. Resolution: In SQL Server Management Studio, go to security->schema->dbo. Double-click dbo, select the ...Status not changing for Bulk Update of Services from "NewAddedList" to "Validated"
Issue After uploading the Bulk Update Server data in Import section if the Status does change from "NewAddedList" to "Validated" . Resolution This occurs when the "_ORI" data given in sheet doesn't match with the data present in the Database or ...