Cannot login cacti 1.2.11

[mnl2048]

I have just installed cacti 1.2.10 and upgraded to 1.2.11 on the latest centos 7

I have mikrotik-develop plugin installed.

A day after installation I'm stuck at the login page. I tried to overwrite the admin password but it is still looping at the login screen.

It was working the previous day.

How do I troubleshoot the issue?

[netniV]

Are you seeing any browser errors? If you look at the cacti.log are there any errors? Are there any errors in the system logs (eg, apache, mysql or php).

[mnl2048]

No related errors generated on the following log directory

/var/log/cacti
/usr/share/cacti/log
/var/log/httpd
/var/log/mariadb

[Osiris]

Try truncatng the auth_sessions table if you are using remember me support.

[mnl2048]

still cannot login after truncating

MariaDB [cacti]> show tables;
+----------------------------------------+
| Tables_in_cacti |
+----------------------------------------+
| aggregate_graph_templates |
| aggregate_graph_templates_graph |
| aggregate_graph_templates_item |
| aggregate_graphs |
| aggregate_graphs_graph_item |
| aggregate_graphs_items |
| automation_devices |
| automation_graph_rule_items |
| automation_graph_rules |
| automation_ips |
| automation_match_rule_items |
| automation_networks |
| automation_processes |
| automation_snmp |
| automation_snmp_items |
| automation_templates |
| automation_tree_rule_items |
| automation_tree_rules |
| cdef |
| cdef_items |
| color_template_items |
| color_templates |
| colors |
| data_debug |
| data_input |
| data_input_data |
| data_input_fields |
| data_local |
| data_source_profiles |
| data_source_profiles_cf |
| data_source_profiles_rra |
| data_source_purge_action |
| data_source_purge_temp |
| data_source_stats_daily |
| data_source_stats_hourly |
| data_source_stats_hourly_cache |
| data_source_stats_hourly_last |
| data_source_stats_monthly |
| data_source_stats_weekly |
| data_source_stats_yearly |
| data_template |
| data_template_data |
| data_template_rrd |
| external_links |
| graph_local |
| graph_template_input |
| graph_template_input_defs |
| graph_templates |
| graph_templates_gprint |
| graph_templates_graph |
| graph_templates_item |
| graph_tree |
| graph_tree_items |
| host |
| host_graph |
| host_snmp_cache |
| host_snmp_query |
| host_template |
| host_template_graph |
| host_template_snmp_query |
| plugin_config |
| plugin_db_changes |
| plugin_hooks |
| plugin_mikrotik_credentials |
| plugin_mikrotik_dhcp |
| plugin_mikrotik_interfaces |
| plugin_mikrotik_mac2hostname |
| plugin_mikrotik_processes |
| plugin_mikrotik_processor |
| plugin_mikrotik_queues |
| plugin_mikrotik_system |
| plugin_mikrotik_system_health |
| plugin_mikrotik_trees |
| plugin_mikrotik_users |
| plugin_mikrotik_wireless_aps |
| plugin_mikrotik_wireless_registrations |
| plugin_realms |
| poller |
| poller_command |
| poller_data_template_field_mappings |
| poller_item |
| poller_output |
| poller_output_boost |
| poller_output_boost_processes |
| poller_output_realtime |
| poller_reindex |
| poller_resource_cache |
| poller_time |
| processes |
| reports |
| reports_items |
| sessions |
| settings |
| settings_tree |
| settings_user |
| settings_user_group |
| sites |
| snmp_query |
| snmp_query_graph |
| snmp_query_graph_rrd |
| snmp_query_graph_rrd_sv |
| snmp_query_graph_sv |
| snmpagent_cache |
| snmpagent_cache_notifications |
| snmpagent_cache_textual_conventions |
| snmpagent_managers |
| snmpagent_managers_notifications |
| snmpagent_mibs |
| snmpagent_notifications_log |
| user_auth |
| user_auth_cache |
| user_auth_group |
| user_auth_group_members |
| user_auth_group_perms |
| user_auth_group_realm |
| user_auth_perms |
| user_auth_realm |
| user_domains |
| user_domains_ldap |
| user_log |
| vdef |
| vdef_items |
| version |
+----------------------------------------+
123 rows in set (0.00 sec)

MariaDB [cacti]> truncate sessions;
Query OK, 0 rows affected (0.01 sec)

MariaDB [cacti]> select * from user_auth_cache ;
Empty set (0.00 sec)

[Osiris]

Sorry, user_auth_cache. Wrong table.

[Osiris]

The other thing that can cause login issues is the /var/lib/php/session directory becomes read only by Apache or the volume fills up.

[mnl2048]

php session directory looks ok. I see new sessions when I attempt to login.

[root@cacti session]# ls -lt
total 156
-rw------- 1 apache apache 1456 Apr 7 13:58 sess_cn4v2282jfbgmmggo2lb1ovgk5
-rw------- 1 apache apache 1456 Apr 7 13:54 sess_n0jt2ups8n3om3cefe7umm9ve0
-rw------- 1 apache apache 1507 Apr 7 13:54 sess_og2dni5fngggv2j66k55r7e6f5
-rw------- 1 apache apache 1456 Apr 7 13:28 sess_538g59o68jb0hq8m3kibj57h43
-rw------- 1 apache apache 1507 Apr 7 13:28 sess_v0of7gk6er17fvn72ah4iqodf0
-rw------- 1 apache apache 1456 Apr 7 06:35 sess_snmqkm9663bqbdq31288962fq0
-rw------- 1 apache apache 1507 Apr 7 06:35 sess_fvhft8tjjb27bah1dfg9l7aa92
-rw------- 1 apache apache 1456 Apr 7 02:54 sess_jc63b7duno5uoq70lf6j8oig81

[root@cacti session]# pwd
/var/lib/php/session

[Osiris]

Are you on php7.3 by chance?

[Osiris]

If you are, edit the global.php file in the include directory. Look for a comment block or call to php_version_compare for same site cookies, and comment out the setting for php7.3. I have a sneaking suspicion.

[mnl2048]

[root@cacti session]# php -v
PHP 5.4.16 (cli) (built: Nov 1 2019 16:04:20)
Copyright (c) 1997-2013 The PHP Group
Zend Engine v2.4.0, Copyright (c) 1998-2013 Zend Technologies

[Osiris]

Anything on the debug console tab? (F12)

[mnl2048]

Im not familiar with using the debug function on the browser.

[duvi]

I'm facing the samme issue since the upgrade to 1.2.11
Nothing in cacti or apache logs.
There is a console error though:

Code: Select all

Uncaught TypeError: Cannot read property 'regional' of undefined
    at jquery-ui-timepicker-hu.js?4e83e7aac9149ac4aa082e34dfb1343b:4
    at jquery-ui-timepicker-hu.js?4e83e7aac9149ac4aa082e34dfb1343b:22

[lohmeyer]

Same for me, can't login after the upgrade. I tried everything posted in this thread to no avail.

The upgrade process also took a disproportionate amount of time and was stuck at 42% forever until the login screen finally appeared.