error with spine and the poller

[networkk]

I have many problem with the package version (debian) of cacti.
I use cacti 1.2.24, php 8.2.7 and rrdTool 1.7.2.+

When I want to change the number of threads to fix the problem with SPINE in Console > Data Collection > Data Collectors > Edit, I can't choose the timezone so I can't edit. There is no list of timezone available. You can see the logs below.

Can you help me ? Thanks

Code: Select all

 
CMDPHP ERROR: A DB Row Failed!, Error: SELECT command denied to user 'userAppliCACTI'@'domain' for table `mysql`.`time_zone_name`
2024-02-19 10:31:02 - BOOST ERROR: Failed to retrieve any rows from archive tables
2024-02-19 10:31:01 - SPINE: Poller[Main Poller] PID[1027421] PT[140715109309312] WARNING: There were 361 threads which did not run
2024-02-19 10:31:01 - SPINE: Poller[Main Poller] PID[1027421] PT[140715109309312] ERROR: Device[X] polling timed out while waiting for 1 Threads to End
2024-02-19 10:31:01 - SPINE: Poller[Main Poller] PID[1027421] PT[140715109309312] ERROR: Device[X] HT[1] Spine Timed Out While Processing Devices External
2024-02-19 10:31:01 - SPINE: Poller[Main Poller] PID[1027421] PT[140715109309312] ERROR: Device[X] HT[1] polling timed out while acquiring Available Thread Lock
2024-02-19 10:31:01 - SPINE: Poller[Main Poller] PID[1027421] PT[140715109309312] ERROR: Device[X] HT[1] polling timed out while acquiring Available Thread Lock
2024-02-19 10:31:01 - SPINE: Poller[Main Poller] PID[1027421] PT[140715109309312] ERROR: Device[X] HT[1] polling timed out while acquiring Available Thread Lock
2024-02-19 10:31:01 - SPINE: Poller[Main Poller] PID[1027421] PT[140715109309312] ERROR: Device[X] HT[1] polling timed out while acquiring Available Thread Lock

[macan]

https://docs.cacti.net/Install-Under-CentOS_LAMP.md

Two articles:
Populate timezone table with available timezones
Grant cacti username to MySQL timezone table

[networkk]

Thanks,

But I have some problems :

I gave the access right to the cacti user but I have an error message with access denied for my user :

Code: Select all

MariaDB [(none)]> show grants for `user`@`host`;                                                                   
+------------------------------------------------------------------------------------------------------------------------+
| Grants for `user`@`host`                                                                                               |
+------------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO `user`@`host` IDENTIFIED BY PASSWORD 'mdp'                                                       |
| GRANT ALL PRIVILEGES ON `cacti`.* TO `user`@`host`                                                                     |
| GRANT SELECT ON `mysql`.`time_zone_name` TO `user`@`host`                                                              |
+------------------------------------------------------------------------------------------------------------------------+
3 rows in set (0,000 sec)


MariaDB [mysql]> SELECT COUNT(*) FROM mysql.time_zone_name;
ERROR 1142 (42000): SELECT command denied to user 'user'@'name_of_the_vm' for table `mysql`.`time_zone_name`
MariaDB [mysql]> 

[macan]

It seems that it isn't set correctly. If you have mysql and cacti on the same server, it could be somthing like:
GRANT ALL PRIVILEGES ON `cacti`.* TO `your_user`@`localhost` IDENTIFIED BY PASSWORD 'your_password';
GRANT SELECT ON `mysql`.`time_zone_name` TO `your_user`@`localhost`;
flush privileges;

In cacti/include/config.php will be
$database_hostname = '127.0.0.1';
database_username = 'your_user';
$database_password = 'your_password';

[networkk]

I figured it out, the problem was that I didn't have the right access to the database, naw it works. Thanks