new install, works, stops, user reverted to default cactiuser

[voytek]

I'm trying to setup cacti on centos 7, new install, installed centos, mariadb 10.2, php73, etc, configured cacti 1.2.19, setup cacti host, system autodiscovered NAS, this Win10 host, another Win10 host, started working as expected, all seems OK, some graphs from auto working, some not, seem OK, will continue tomorrow..

this morning noticed graphs stopped, looking in error log see around 50 like this:

FATAL: Connection Failed, Error:'1045', Message:'Access denied for user 'cactiuser'@'localhost' (using password: YES)'
FATAL: Connection Failed, Error:'1045', Message:'Access denied for user 'cactiuser'@'localhost' (using password: YES)'

in main log:

2021-11-19 09:05:00 - SYSTEM STATS: Time:298.5788 Method:spine Processes:1 Threads:1 Hosts:4 HostsPerProcess:4 DataSources:39 RRDsProcessed:0
2021-11-19 09:05:00 - POLLER: Poller[Main Poller] PID[19396] Maximum runtime of 298 seconds exceeded. Exiting.
2021-11-19 08:55:04 - SYSTEM STATS: Time:2.3788 Method:cmd.php Processes:1 Threads:1 Hosts:4 HostsPerProcess:4 DataSources:39 RRDsProcessed:35
2021-11-19 08:50:04 - SYSTEM STATS: Time:2.3371 Method:cmd.php Processes:1 Threads:1 Hosts:4 HostsPerProcess:4 DataSources:39 RRDsProcessed:35

2021-11-19 08:45:03 - SYSTEM STATS: Time:2.4145 Method:cmd.php Processes:1 Threads:1 Hosts:4 HostsPerProcess:4 DataSources:39 RRDsProcessed:35
2021-11-19 08:40:07 - SYSTEM DSDEBUG STATS: Type:poller, ChecksPerformed:14, TotalIssues:11, Time:1.0756
2021-11-19 08:40:07 - DSDEBUG Bad Data Found for Data Source ID 20
/few more/
2021-11-19 08:40:06 - DSDEBUG Bad Data Found for Data Source ID 32
2021-11-19 08:40:04 - SYSTEM STATS: Time:2.7453 Method:cmd.php Processes:1 Threads:1 Hosts:4 HostsPerProcess:4 DataSources:39 RRDsProcessed:35
2021-11-19 08:38:54 - AUTH LOGIN: User 'admin' Authenticated
2021-11-19 08:35:03 - SYSTEM STATS: Time:2.3621 Method:cmd.php Processes:1 Threads:1 Hosts:4 HostsPerProcess:4 DataSources:39 RRDsProcessed:35
2021-11-19 08:30:04 - SYSTEM STATS: Time:2.3453 Method:cmd.php Processes:1 Threads:1 Hosts:4 HostsPerProcess:4 DataSources:39 RRDsProcessed:35

checked db.php has correct user/pass

but, error log says " 'cactiuser'@'localhost' " ??

so, added a new user to mariadb/cacti db, as per default, cactiuser/cactiuser

and:
2021-11-19 11:00:04 - SYSTEM STATS: Time:2.3243 Method:spine Processes:1 Threads:1 Hosts:4 HostsPerProcess:4 DataSources:25 RRDsProcessed:23
2021-11-19 10:55:04 - SYSTEM STATS: Time:2.5146 Method:spine Processes:1 Threads:1 Hosts:4 HostsPerProcess:4 DataSources:25 RRDsProcessed:23
2021-11-19 10:50:03 - SYSTEM STATS: Time:2.3604 Method:spine Processes:1 Threads:1 Hosts:4 HostsPerProcess:4 DataSources:25 RRDsProcessed:23
2021-11-19 10:50:00 - SYSTEM STATS: Time:298.5867 Method:spine Processes:1 Threads:1 Hosts:4 HostsPerProcess:4 DataSources:25 RRDsProcessed:0
2021-11-19 10:50:00 - SYSTEM WARNING: Primary Admin account does not have an email address! Unable to send administrative Email.
2021-11-19 10:50:00 - POLLER: Poller[Main Poller] PID[26705] Maximum runtime of 298 seconds exceeded. Exiting.

working again.... ?

so, after I've created additional sql user, using default cactiuser/cactiuser, it restarted working ??

what did I screw up...?
where is the cactiuser id coming from...? /etc/cacti/db.php has NOT cactiuser/cactiuser

thanks for any pointers!

[macan]

I'm trying to setup cacti on centos 7, new install, installed centos, mariadb 10.2, php73, etc, configured cacti 1.2.19, setup cacti host, system autodiscovered NAS, this Win10 host, another Win10 host, started working as expected, all seems OK, some graphs from auto working, some not, seem OK, will continue tomorrow..

this morning noticed graphs stopped, looking in error log see around 50 like this:

FATAL: Connection Failed, Error:'1045', Message:'Access denied for user 'cactiuser'@'localhost' (using password: YES)'
FATAL: Connection Failed, Error:'1045', Message:'Access denied for user 'cactiuser'@'localhost' (using password: YES)'

in main log:

2021-11-19 09:05:00 - SYSTEM STATS: Time:298.5788 Method:spine Processes:1 Threads:1 Hosts:4 HostsPerProcess:4 DataSources:39 RRDsProcessed:0
2021-11-19 09:05:00 - POLLER: Poller[Main Poller] PID[19396] Maximum runtime of 298 seconds exceeded. Exiting.
2021-11-19 08:55:04 - SYSTEM STATS: Time:2.3788 Method:cmd.php Processes:1 Threads:1 Hosts:4 HostsPerProcess:4 DataSources:39 RRDsProcessed:35
2021-11-19 08:50:04 - SYSTEM STATS: Time:2.3371 Method:cmd.php Processes:1 Threads:1 Hosts:4 HostsPerProcess:4 DataSources:39 RRDsProcessed:35

2021-11-19 08:45:03 - SYSTEM STATS: Time:2.4145 Method:cmd.php Processes:1 Threads:1 Hosts:4 HostsPerProcess:4 DataSources:39 RRDsProcessed:35
2021-11-19 08:40:07 - SYSTEM DSDEBUG STATS: Type:poller, ChecksPerformed:14, TotalIssues:11, Time:1.0756
2021-11-19 08:40:07 - DSDEBUG Bad Data Found for Data Source ID 20
/few more/
2021-11-19 08:40:06 - DSDEBUG Bad Data Found for Data Source ID 32
2021-11-19 08:40:04 - SYSTEM STATS: Time:2.7453 Method:cmd.php Processes:1 Threads:1 Hosts:4 HostsPerProcess:4 DataSources:39 RRDsProcessed:35
2021-11-19 08:38:54 - AUTH LOGIN: User 'admin' Authenticated
2021-11-19 08:35:03 - SYSTEM STATS: Time:2.3621 Method:cmd.php Processes:1 Threads:1 Hosts:4 HostsPerProcess:4 DataSources:39 RRDsProcessed:35
2021-11-19 08:30:04 - SYSTEM STATS: Time:2.3453 Method:cmd.php Processes:1 Threads:1 Hosts:4 HostsPerProcess:4 DataSources:39 RRDsProcessed:35

checked db.php has correct user/pass

but, error log says " 'cactiuser'@'localhost' " ??

so, added a new user to mariadb/cacti db, as per default, cactiuser/cactiuser

and:
2021-11-19 11:00:04 - SYSTEM STATS: Time:2.3243 Method:spine Processes:1 Threads:1 Hosts:4 HostsPerProcess:4 DataSources:25 RRDsProcessed:23
2021-11-19 10:55:04 - SYSTEM STATS: Time:2.5146 Method:spine Processes:1 Threads:1 Hosts:4 HostsPerProcess:4 DataSources:25 RRDsProcessed:23
2021-11-19 10:50:03 - SYSTEM STATS: Time:2.3604 Method:spine Processes:1 Threads:1 Hosts:4 HostsPerProcess:4 DataSources:25 RRDsProcessed:23
2021-11-19 10:50:00 - SYSTEM STATS: Time:298.5867 Method:spine Processes:1 Threads:1 Hosts:4 HostsPerProcess:4 DataSources:25 RRDsProcessed:0
2021-11-19 10:50:00 - SYSTEM WARNING: Primary Admin account does not have an email address! Unable to send administrative Email.
2021-11-19 10:50:00 - POLLER: Poller[Main Poller] PID[26705] Maximum runtime of 298 seconds exceeded. Exiting.

working again.... ?

so, after I've created additional sql user, using default cactiuser/cactiuser, it restarted working ??

what did I screw up...?
where is the cactiuser id coming from...? /etc/cacti/db.php has NOT cactiuser/cactiuser

thanks for any pointers!

For cacti you need only one mysql db user. Howto create user - https://www.digitalocean.com/community/ ... s-in-mysql

Cacti has db connection configured in <cacti_install>/include/config.php. I don't know if any distribution uses another path like /etc....
You have method cmd.php and later you switched to spine.
cmd.php uses db user from config. Spine has own configuration file (in FreeBSD /usr/local/etc/spine.conf, in linux maybe /etc/spine.conf).

[voytek]

duh...
of course.... Thanks!!, much obliged, fixed. yeah, totally forgot about /etc/spine.conf, thanks for spotting this