Authentication Error
-
Well I may have bigger issues than this… mysql will not run… not even as root.
root@fogserver:~# mysql -D fog ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) -
Nevermind… I see that mysql can be a problem with Ubuntu… I will follow the steps in the Wiki and report back.
-
@Joe-Gill It doesn’t mention that if you have a password set, you should use the password option. I figure that’s something the admin should just know… but it should be in the wiki.
-
Well, I followed the steps in the Wiki to resolve the mysql issue with zero luck. I also tried to re-install mysql and did not succeed.
I verified that the Username and Password were correct from the /var/www/fog/lib/fog/Config.class.php and /opt/fog/.fogsettings files… and re-ran sudo dpkg-reconfigure mysql-server-5.5… I even tried re-running this command with the password found in the Config.class.php file. The command ran but I was still getting the same error.
Any ideas?
root@fogserver:~# sudo apt-get install mysql-server-5.5 Reading package lists... Done Building dependency tree Reading state information... Done mysql-server-5.5 is already the newest version. mysql-server-5.5 set to manually installed. The following packages were automatically installed and are no longer required: libonig2 libqdbm14 Use 'apt-get autoremove' to remove them. 0 upgraded, 0 newly installed, 0 to remove and 7 not upgraded. root@fogserver:~# mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) root@fogserver:~# -
You need to find the mac’s that system is sending, and figure out which one is already associated to another host.
-
I can do that. But do I need to find them within the SQL database and if so, what do I do since I can’t seem to access the database?
-
I got it figured out. Yes there were multiple machines with the same Mac addresses. I removed one and that resolved the issue. Thanks for making me look harder!
Now… As for the mysql problem. Do you have any ideas on how to resolve that?
-
sudo -i
mysql -u root -D fog -
@Wayne-Workman
I tried that… I’m still getting this.ERROR 1045 (28000): Access denied for user 'root@localhost' (using password: NO) -
@Joe-Gill Does your mysql root user have a password?
-
@Joe-Gill look in the .fogsettings file and see if there is a password set for the mysql one.
