Update Database Schema 1.1.2 - 1.2.0

[Luke Bedding]

This was my first FOG upgrade and I ran into a couple of issues. I did not setup the system initially so I do not know the MYSQL password. Is there any way I can retrieve or reset it? How do I update the database schema?

[Junkhacker]

the password for mysql is stored in [FONT=arial][COLOR=#262626]/var/www/fog/lib/fog/Config.class.php[/COLOR][/FONT]
[FONT=arial][COLOR=#262626]if it is not correct, the mysql root password can be changed from the linux command line, after which you will need to update Config.class.php to match[/COLOR][/FONT]

[Luke Bedding]

[quote=“Junkhacker, post: 36317, member: 21583”]the password for mysql is stored in [FONT=arial][COLOR=#262626]/var/www/fog/lib/fog/Config.class.php[/COLOR][/FONT]
[FONT=arial][COLOR=#262626]if it is not correct, the mysql root password can be changed from the linux command line, after which you will need to update Config.class.php to match[/COLOR][/FONT][/quote]

I have verified that the mySQL password is correct. How to I update the database schema?

[Tom Elliott]

Have you actually made sure the mysql service is running?

[code]ps -ef|grep mysql[/code]

Does your root system have enough space?

[code]df -h /[/code]

Are you sure the mysql server is actually running? Meaning, have you ensured you’re not getting ibdata errors and such?

If you have any questions about that try the steps here:
[url]https://github.com/mastacontrola/fogproject/issues/1[/url]

[Luke Bedding]

Hello Tom,

I have resolved the issue. I has performed the upgrade too quickly and I missed the prompt to upgrade the database at [B][url]http://10.0.0.3/fog/management[/url] [/B]When I went to the link, there was the magic button to upgrade the database.

I apologise for wasting your time for my mistake. Thank you for your help.