Issue with Login to Cacti

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

Moderators: Developers, Moderators

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

Issue with Login to Cacti

Post by vennerd »

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: 3441
Joined: Sun Aug 27, 2017 12:05 am

Re: Issue with Login to Cacti

Post by netniV »

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';
Cacti Developer & Release Manager
The Cacti Group

Director
BV IT Solutions Ltd

+--------------------------------------------------------------------------+

Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation
netniV
Cacti Guru User
Posts: 3441
Joined: Sun Aug 27, 2017 12:05 am

Re: Issue with Login to Cacti

Post by netniV »

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.
Cacti Developer & Release Manager
The Cacti Group

Director
BV IT Solutions Ltd

+--------------------------------------------------------------------------+

Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation
vennerd
Posts: 4
Joined: Mon Jun 05, 2017 4:05 pm

Re: Issue with Login to Cacti

Post by vennerd »

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

Who is online

Users browsing this forum: No registered users and 0 guests