Upgrade from Trunk to 1.4.2 Failed

[Avaryan]

So, on a whim, I decided to checkout revision 07fc221, the first FOG 1.3.0 that I saw. It installed. Thought behind this was that maybe there have been too many changes from the pre 1.3 trunk build to the current 1.4.2 build and that I could update incrementally.

However, on loading the webpage I get this:

Your database connection appears to be invalid. FOG is unable to communicate with the database. There are many reasons why this could be the case. Please check your credentials in /var/www/html/fog/lib/fog/config.class.php. Also confirm that the database is indeed running. If credentials are correct, and if the Database service is running, check to ensure your filesystem has enough space.

[Tom Elliott]

Can you provide output of lsb_release -a?

[Avaryan]

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

Can you provide output of lsb_release -a?

No LSB modules are available.
Distributor ID: Ubuntu
Description:    Ubuntu 14.04.5 LTS
Release:        14.04
Codename:       trusty

Note: The ‘Backing up datebase’ part while installing 1.3.0 seemed to have worked, while in 1.4.2 it did not.

[Tom Elliott]

@Avaryan What’s output of php -v?

[Avaryan]

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

@Avaryan What’s output of php -v?

PHP 7.1.5-1+deb.sury.org~trusty+2 (cli) (built: May 22 2017 13:39:01) ( NTS )
Copyright (c) 1997-2017 The PHP Group
Zend Engine v3.1.0, Copyright (c) 1998-2017 Zend Technologies
    with Zend OPcache v7.1.5-1+deb.sury.org~trusty+2, Copyright (c) 1999-2017, by Zend Technologies

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