After upgrade from 1.2.10 to 1.2.11 no login possible

[TheBob]

Hello @all,
i have update yesterday out cacti version to 1.2.11.
The update are fully working and i forward directly to the cati main Pacge. Everything seems to be work.
This morning i try to login again and after instert login data (ldap and local) i getting back to login page.
No Main Page are displayed.
What can i Do?

OS: Ubuntu 18.04
PHP 5.6.40
Mysql 5.7.29

thanks in advanced
TheBob

[Osiris]

Anything in your Apache error logs? Did you make any changes to config.php?

Try this MySQL command and see if it starts working:

UPDATE setting SET value'' WHERE name='auth_cache_enabled';

Then close all browsers and login again.

[Osiris]

Last, edit your php.ini file for Apache and set

session.auto_start = off

Then restart Apache.

[ank0l0g]

Hi.

MariaDB [(none)]> use cacti;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [cacti]> UPDATE setting SET value'' WHERE name='auth_cache_enabled';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''' WHERE name='auth_cache_enabled'' at line 1

[TheBob]

Nothing in apache logs that is anything is wrong!

UPDATE setting SET value'' WHERE name='auth_cache_enabled';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''' WHERE name='auth_cache_enabled'' at line 1

php.ini
grep -R "session.auto_start"
5.6/cli/php.ini.ucf-dist:session.auto_start = 0
5.6/cli/php.ini:session.auto_start = 0
5.6/apache2/php.ini.ucf-dist:session.auto_start = 0
5.6/apache2/php.ini:session.auto_start = 0
0 meens off so do you thing i need to change that?

Thanks a lot Osiris!

[TheWitness]

UPDATE setting SET value='' WHERE name='auth_cache_enabled';

[TheWitness]

This has been reported in GitHub as well. Have not seen a solution yet, but I've got the day job too.

[TheWitness]

Please comment out $cacti_cookie_domain from you config.php and see if that helps. We have one user reporting on GitHub that it's working now.

[TheBob]

Please comment out $cacti_cookie_domain from you config.php

That's it!!!! Perfekt and many Thanks Witness!!!!
Happy Eastern @all

[Osiris]

Good to hear!

[masterMetal]

This also worked for me in Version 1.2.11

I commented out in /var/www/cacti/include/config.php the line

#$cacti_cookie_domain = 'cacti.net';

I wasted a lot of time looking for a solution:
a) updating the database users using mysql
mysql> use cacti; update user_auth set password=md5('admin') where username='admin';).

b) Changing the session.auto_start in php.ini to
session.auto_start = On

Noting worked until this I came across this post.

Many, many thanks TheWitness!

[dvdlubbe]

I have the exact same issue after upgrading to 1.2.11.
Unfortunately, I am not able to comment out "$cacti_cookie_domain = 'cacti.net';" since my config file doesn't contain that line. (it's still the old config file I've been using all this time)
Was my config file supposed to be updated in the process?

Maybe this was caused by the problematic upgrade to version 1.2.10 earlier?
It was stuck at 42%. I booted the server and afterwards I was suddenly able to access cacti on version 1.2.10, so I wasn't really sure if the upgrade was really succesfull or not.

Any help would be appreciated.

[TheBob]

The update prozess from 1.210 to 11 was also on my site quit log, about 10-15 minuntes but then everything was again.
Best is restore to 1.2.10 and do the update again.

[dvdlubbe]

Reinstalling 1.2.11 didn't resolve the issue unfortunately.
What I don't get is this: apparently the issue is seen only when $cacti_cookie_domain = 'cacti.net'; is enabled.
I never had this line enabled (because it wasn't in my config), so I would expect that the issue would not show at all.

Anyway, I'm still with the issue that I am not able to login. Is there anything else I can do?
Is there something in the database that needs to be changed? I'm at a loss here...

[TheWitness]

The classic cases have always been permission issues in the /var/lib/php/session directory, or a bad password. The $cacti_cookie_domain issues is new. We have also recently seen an issue where if you have a secure session cookie (remember me concept), that was created under https, you will be unable to login under http. The way you fix that is by deleting rows from the user_auth_cache table.

The last potential issue would be that you are on PHP7.3, and there is some compatibility issue with session management on that release. You will have to provide additional details about your setup for us to even be able to help you.