Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Fri Feb 22, 2019 5:37 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: Issue with Login to Cacti
PostPosted: Thu Nov 15, 2018 4:52 pm 
Offline

Joined: Mon Jun 05, 2017 4:05 pm
Posts: 4
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?


Top
 Profile  
 
 Post subject: Re: Issue with Login to Cacti
PostPosted: Fri Nov 16, 2018 4:02 am 
Offline
Cacti Guru User

Joined: Sun Aug 27, 2017 12:05 am
Posts: 2080
MySQL is case sensitive when it comes to columns and tables (but not keywords).

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

_________________
Official Cacti Developer

Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation

My resources:
How to submit Pull Requests
Development Wiki and How To's
Updated NetSNMP Memory template for Cacti 1.x
Cisco SFP template for Cacti 0.8.8


Top
 Profile  
 
 Post subject: Re: Issue with Login to Cacti
PostPosted: Fri Nov 16, 2018 4:04 am 
Offline
Cacti Guru User

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

_________________
Official Cacti Developer

Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation

My resources:
How to submit Pull Requests
Development Wiki and How To's
Updated NetSNMP Memory template for Cacti 1.x
Cisco SFP template for Cacti 0.8.8


Top
 Profile  
 
 Post subject: Re: Issue with Login to Cacti
PostPosted: Fri Nov 16, 2018 6:17 pm 
Offline

Joined: Mon Jun 05, 2017 4:05 pm
Posts: 4
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.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: Google [Bot] and 7 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group