Authentication Error

[Wayne Workman]

@Joe-Gill Going off of this thread, I think your DB is dirty.
Please try the database maintenance commands here. Please report back with the outcome.

[Tom Elliott]

@Joe-Gill said in Authentication Error:

5/16/2017 3:48 PM Middleware::Response Error multiple hosts returned for list of mac addresses

The quoted text is the problem, which means it doesn’t know which host to associate with.

I don’t know that the DB is necessarily “dirty” persay, but most likely one of the mac’s being passed is associated to more than one host. (This is bad and technically dirty I suppose, but can happen for more reasons than “corrupt” database though much less likely now than in the past.)

[Wayne Workman]

@Tom-Elliott I guess we need a maintenance command to delete MACs that are associated to more than one host. Dirty isn’t the same as corrupt - corrupt is a question of integrity being compromised. Dirty is just things not being right. Like a typo in a text file is dirty, and half the text file just going missing one day is corrupt.

[Joe Gill]

@Tom-Elliott
@Wayne-Workman

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)

[Joe Gill]

Nevermind… I see that mysql can be a problem with Ubuntu… I will follow the steps in the Wiki and report back.

[Wayne Workman]

@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.

[Joe Gill]

@Tom-Elliott
@Wayne-Workman

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:~#

[Tom Elliott]

You need to find the mac’s that system is sending, and figure out which one is already associated to another host.

[Joe Gill]

@Tom-Elliott

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?

[Joe Gill]

@Tom-Elliott

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?

[Wayne Workman]

@Joe-Gill

sudo -i
mysql -u root -D fog

[Joe Gill]

@Wayne-Workman
I tried that… I’m still getting this.

ERROR 1045 (28000): Access denied for user 'root@localhost' (using password: NO)

[Tom Elliott]

@Joe-Gill Does your mysql root user have a password?

[Wayne Workman]

@Joe-Gill look in the .fogsettings file and see if there is a password set for the mysql one.