Cacti user management not showing users list.

[TheWitness]

First time I've seen that...

[tedseu]

Code: Select all

rename table user_log to user_log_backup;
create table user_log like user_log_backup;

Then bring up User Management again.

TheWitness

In my case, STRICT_TRANS_TABLES was the main issue.
- User Management will show nothing (empty user list), but if you select * from user_auth in "cacti" database, you will get at least "admin and guest" user as default return.
- other plugins (such as Monitor and Threshold) can not function properly. Error: "You are running MySQL in Strict Mode, which is not supported by Thold."

# rename table user_log to user_log_backup; ==> OK
# create table user_log like user_log_backup; ==> Useless, with error related to time(), even if i try to truncate user_log table.

i just solve this problem by changing sql-mode in my.ini.

# vim /etc/mysql/my.cnf

!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/

[mysqld]
sql-mode=""

just save it, then restart mysql service

# service mysql restart


Notes
=====
Default sql_mode in MySQL ver 5.7 is STRICT_TRANS_TABLES
# mysql -u root -p

mysql> SHOW VARIABLES LIKE 'sql_mode';
+---------------+-------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value |
+---------------+-------------------------------------------------------------------------------------------------------------------------------------------+
| sql_mode | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+---------------+-------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

Mysql-Server Version 5.7.13-0ubuntu0.16.04.2
PHP Version 7.0.9-1+deb.sury.org~xenial+1
Cacti Version 0.8.8f
SNMP Version NET-SNMP version: 5.7.3
RRDTool Version RRDTool 1.4.x
Type SPINE 0.8.8b Copyright 2002-2013 by The Cacti Group