Hi all
New problem. I have the following error (line 69) sometimes and that must explain why I have un incident on my mysql database.
password is set in :
/etc/centreon/centreon.conf.php
/etc/centreon/conf.pm
240724 9:53:56 11 Query SELECT nagios_server_id, command_file, cfg_dir, centreonbroker_cfg_path, snmp_trapd_path_conf, engine_start_command, engine_stop_command, engine_restart_command, engine_reload_command, broker_reload_command, init_script_centreontrapd FROM cfg_nagios, nagios_server WHERE nagios_server.id = cfg_nagios.nagios_server_id AND cfg_nagios.nagios_activate = '1'
11 Query SELECT `value` FROM options WHERE `key` = 'gorgone_illegal_characters'
66 Connect centreon@localhost on centreon using Socket
66 Query SET NAMES utf8
67 Connect centreon@localhost on centreon using Socket
67 Query SET NAMES utf8
66 Quit
67 Query SELECT `session_id` FROM session WHERE `session_id` = 'nikmbv8rjbipcr9nnklci1l2cs'
67 Query SELECT name FROM modules_informations
68 Connect centreon@localhost on centreon using Socket
68 Query SET NAMES utf8
68 Query SELECT `session_id` FROM session WHERE `session_id` = 'nikmbv8rjbipcr9nnklci1l2cs'
68 Query UPDATE `session`
SET `last_reload` = 1721807636, `ip_address` = '172.22.219.1'
WHERE `session_id` = 'nikmbv8rjbipcr9nnklci1l2cs'
68 Query SELECT `value`
FROM `options`
WHERE `key` = 'session_expire'
68 Query UPDATE `security_token`
SET `expiration_date` = 1721814836
WHERE `token` = 'nikmbv8rjbipcr9nnklci1l2cs'
68 Quit
67 Quit
240724 9:53:59 69 Connect centreon@localhost on centreon_storage using Socket
69 Connect Access denied for user 'centreon'@'localhost' (using password: YES)
240724 9:54:01 70 Connect centreon@localhost on centreon using Socket
70 Query SET NAMES utf8
71 Connect centreon@localhost on centreon_storage using Socket
71 Query SET NAMES utf8
70 Query SELECT id, running FROM cron_operation WHERE name LIKE 'centAcl.php'
70 Query UPDATE cron_operation SET running = '1', time_launch = 1721807641
WHERE id = 2
70 Query SELECT `key`, `value` FROM `options` WHERE `key` IN ('ldap_auth_enable', 'ldap_last_acl_update')
70 Query START TRANSACTION
70 Query SELECT auth.ar_id, auth.ar_sync_base_date, info.ari_value AS `interval`
FROM auth_ressource auth
INNER JOIN auth_ressource_info info ON auth.ar_id = info.ar_id
WHERE auth.ar_enable = '1' AND info.ari_name = 'ldap_sync_interval'
70 Query COMMIT
71 Query START TRANSACTION
71 Query DELETE FROM centreon_acl WHERE group_id NOT IN (SELECT DISTINCT acl_group_id
FROM `centreon`.acl_groups WHERE acl_group_activate = '1')
71 Query DELETE FROM centreon_acl WHERE group_id NOT IN (SELECT DISTINCT acl_group_id FROM `centreon`.acl_res_group_relations)
71 Query COMMIT
70 Query SELECT acl_res_id, all_hosts, all_hostgroups, all_servicegroups
FROM acl_resources WHERE acl_res_activate = '1'
AND (all_hosts IS NOT NULL OR all_hostgroups IS NOT NULL OR all_servicegroups IS NOT NULL)
70 Query START TRANSACTION
70 Query SELECT host_id FROM host WHERE host_id NOT IN (SELECT DISTINCT host_host_id
FROM acl_resources_host_relations WHERE acl_res_id = 1)
AND host_register = '1'
70 Query COMMIT
70 Query START TRANSACTION
70 Query SELECT hg_id FROM hostgroup
WHERE hg_id NOT IN (
SELECT DISTINCT hg_hg_id FROM acl_resources_hg_relations
WHERE acl_res_id = 1)
70 Query COMMIT
70 Query START TRANSACTION
70 Query SELECT sg_id FROM servicegroup
WHERE sg_id NOT IN (
SELECT DISTINCT sg_id FROM acl_resources_sg_relations
WHERE acl_res_id = 1)
70 Query COMMIT
70 Query SELECT DISTINCT acl_groups.acl_group_id
FROM acl_res_group_relations, `acl_groups`, `acl_resources`
WHERE acl_groups.acl_group_id = acl_res_group_relations.acl_group_id
AND acl_res_group_relations.acl_res_id = acl_resources.acl_res_id
AND acl_groups.acl_group_activate = '1'
AND (
acl_groups.acl_group_changed = '1' OR
(acl_resources.changed = '1' AND acl_resources.acl_res_activate IS NOT NULL)
)
70 Query UPDATE cron_operation
SET running = '0', last_execution_time = 0
WHERE id = 2
71 Quit
70 Quit
and the screenshot
How can I find the cause of this error ?
thanks for help
