Issue with Login to Cacti

Post support questions that relate to the Windows 2003/2000/XP operating systems.

Moderators: Moderators, Developers

Post Reply
Author
Message
vennerd
Posts: 4
Joined: Mon Jun 05, 2017 4:05 pm

Issue with Login to Cacti

#1 Post by vennerd » Thu Nov 15, 2018 4:52 pm

Downloaded the latest version of the .exe and installed it on a brand new install of Windows Server 2016.
The install seemed to complete successfully but the MySQL service would not start. After trying a few solutions on the web I decided to uninstall the MySQL software and reinstall from a fresh copy. This worked successfully and I then followed the instructions on the Cacti website "Installing Under Windows - MySQL section".

Question: Step 8 - Does the bit about old password still need to be done?

I did go through the process but get errors when trying to run the sql command:
UPDATE mysql.user SET Password = OLD_PASSWORD('cactipwd') WHERE Host = 'localhost' AND User = 'cactiuser';
ERROR 1054 (42S22): Unknown column 'Password' in 'field list'

On researching the error I found that the "Password" field no longer exists in the database table and it has been replaced by "authentication_string". So changing this in the command then produces a different error:
ERROR 1305 (42000): FUNCTION mysql.OLD_PASSWORD does not exist

If the old password step still needs to be done then can you help resolve the issues I am having?

netniV
Cacti Guru User
Posts: 2795
Joined: Sun Aug 27, 2017 12:05 am

Re: Issue with Login to Cacti

#2 Post by netniV » Fri Nov 16, 2018 4:02 am

MySQL is case sensitive when it comes to columns and tables (but not keywords).

Code: Select all

UPDATE user_auth SET password=MD5('admin') where username='admin';

netniV
Cacti Guru User
Posts: 2795
Joined: Sun Aug 27, 2017 12:05 am

Re: Issue with Login to Cacti

#3 Post by netniV » Fri Nov 16, 2018 4:04 am

If this relates to the actual SQL connection's username/password, then you need to follow https://dev.mysql.com/doc/refman/8.0/en ... sions.html but replace the root user with the one that you are trying to do.

vennerd
Posts: 4
Joined: Mon Jun 05, 2017 4:05 pm

Re: Issue with Login to Cacti

#4 Post by vennerd » Fri Nov 16, 2018 6:17 pm

Apologies but made a massive mistake, after removing MySQL and reinstalling the setup was from scratch using the instructions on the Cacti website so the username and password defaulted back to the defaults and not those created as part of the v1.1.38 install. I entered the defaults, changed the password and accessed the Cacti GUI.

I guess that step 8 in the instructions on the site about old-password is no longer required in v1.1.38.

Post Reply