CMDPHP ERROR: A DB Cell Failed! - After install syslogplugin

[Riccardo00001]

Hi all,

I just installed the Syslog plug-in on cacti, on a dedicated DB called "Syslog" and all is working, but i notice this annoying message on logs, and I don't understand how to fix it
Syslog plugin use a dedicated user to access on own db.

Code: Select all

2021-11-14 03:35:04 - CMDPHP ERROR: A DB Cell Failed!, Error: SELECT command denied to user 'cactiuser'@'localhost' for table 'syslog_incoming'
2021-11-14 03:35:04 - CMDPHP SQL Backtrace: (/plugins/syslog/syslog_process.php[187]:db_fetch_cell(), /lib/database.php[411]:db_fetch_cell_prepared(), /lib/database.php[427]:db_execute_prepared())
2021-11-14 03:40:03 - CMDPHP ERROR: A DB Cell Failed!, Error: SELECT command denied to user 'cactiuser'@'localhost' for table 'syslog_incoming'
2021-11-14 03:40:03 - CMDPHP SQL Backtrace: (/plugins/syslog/syslog_process.php[187]:db_fetch_cell(), /lib/database.php[411]:db_fetch_cell_prepared(), /lib/database.php[427]:db_execute_prepared())

Can you help me, i don't know much about dbs
Thanks,
Riccardo

[Riccardo00001]

Solved missing this command

Code: Select all

GRANT SELECT  ON syslog.* TO  'username cacti db user'@'localhost';