Upgrade from Trunk to 1.4.2 Failed

[Tom Elliott]

@Avaryan ANd what’s the output of mysql -v?

[Avaryan]

@Tom-Elliott said in Upgrade from Trunk to 1.4.2 Failed:

@Avaryan ANd what’s the output of mysql -v?

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 575
Server version: 5.5.55-0ubuntu0.14.04.1 (Ubuntu)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Reading history-file /home/user/.mysql_history
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

If I sudo that or log in with root I get access denied message.

[Tom Elliott]

@Avaryan Do you have a root password defined for Mysql access?

[Avaryan]

@Tom-Elliott Good question. No clue! I didn’t set the server up.

How would I go about checking? And how would I go about changing it and/or removing if that’s what I need to do.

[Tom Elliott]

@Avaryan this is where things get tricky I suppose as I have no idea of knowing.

Can you check in /opt/fog/.fogsettings and look for snmysqlpass?

The password should be there, though I suspect that’s where things might be also breaking.

[Avaryan]

@Tom-Elliott I don’t see a .fogettings in /opt/fog

Only thing in there is log, service, snapins, utils directories.

Edit: Nevermind. It showed up when I manually typed it in.

[george1421]

@Avaryan ls -la /opt/fog please try

[Avaryan]

@Tom-Elliott said in Upgrade from Trunk to 1.4.2 Failed:

@Avaryan this is where things get tricky I suppose as I have no idea of knowing.

Can you check in /opt/fog/.fogsettings and look for snmysqlpass?

The password should be there, though I suspect that’s where things might be also breaking.

snmysqlpass='XXXXXXXX'

Moderator note: I removed the password to your mysql database. The important part is that YOU know what it is

[george1421]

@Avaryan Now that you know your password attempt to log into your database from the linux command line mysql -u root -p fog then provide your database password.

[Avaryan]

@george1421 said in Upgrade from Trunk to 1.4.2 Failed:

@Avaryan Now that you know your password attempt to log into your database from the linux command line mysql -u root -p fog then provide your database password.

This was the output when I tried the password listed in .fogsettings

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

However, I tried another password and got this:

Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 28556
Server version: 5.5.55-0ubuntu0.14.04.1 (Ubuntu)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

Assuming that is what I should see on a correct login, I at least know what the password is.

[Tom Elliott]

That /opt/fog/.fogsettings file, pelase edit the snmysqlpass line to make it match what you “know” what it is. THen rerun the installer. Apparently it got changed at some point in time.

[Avaryan]

@george1421 said in Upgrade from Trunk to 1.4.2 Failed:

@Avaryan Now that you know your password attempt to log into your database from the linux command line mysql -u root -p fog then provide your database password.

Our live FOG server is now on 1.4.2, revision 6072. Thanks! Now to figure out how that password got changed…

edit: You can mark this as solved.