1.5.7, 1.5.8 & DEV Install issues

[Sebastian Roth]

@Sharo It’s a bit hard to guess as we don’t have installer logs yet but I will give it a try. Still you might take a look at the sub directory where you ran the FOG installer script from (e.g. fogproject/bin/error_logs) and post the last 10-20 lines of those files here.

I am not sure why FOG 1.5.7 would fail on SSL CA issue. This version has been released long ago and many people have installed this version on Ubuntu 16.04.6 LTS I am sure. We’d need the logs to know what exactly went wrong.

However, now all installations complain about mysql root user’s password. Mysql’s root pass was set manually, however I’ve always left this blank in other installations. as root I cannot login with the password I set. Very strange,

FOG 1.5.7 didn’t care about that but we changed that in FOG 1.5.8. We had an issue in FOG 1.5.8 which would set a random DB root password but that should not be the case for Ubuntu 16.04.6 LTS I am fairly sure. Nevertheless it seems like you cannot login to the DB anymore and we need to fix that:

systemctl stop mysql
mysqld_safe --skip-grant-tables &
mysqladmin -u root password
mysqladmin -u root shutdown
systemctl start mysql
mysql -u root -p

See if you can login with that last command properly again.

So all in all I would say get the DB root access right, re-download the latest dev-branch and try again. We push commits to that often (sometimes daily) and so you need to re-pull for the latest.

[Sharo]

@Sebastian-Roth

Hi Sebastian,

Is “password” in red supposed to be my password or is password the password?

[Sharo]

@Sebastian-Roth

Here’s what I got after running those commands. You’re not going to hurt my feelings if you suggest I remove or default mysql and associated users

Thank you for your help.

[Sebastian Roth]

@Sharo said in 1.5.7, 1.5.8 & DEV Install issues:

Is “password” in red supposed to be my password or is password the password?

It’s supposed to be written like this. Don’t put in your password as command parameter as it will ask you on the console when calling it. You will see.

Sorry, I forgot to mention you need to run those as root!

sudo -i
systemctl stop mysql
mysqld_safe --skip-grant-tables &
mysqladmin -u root password
mysqladmin -u root shutdown
systemctl start mysql
mysql -u root -p

[Sharo]

@Sebastian-Roth

Hello, sorry for the delay here’s what I got:

[Sharo]

@Sebastian-Roth

Here’s the rest of the command string:

[Sebastian Roth]

@Sharo Seems like you are not able to stop the mysql service. Please run

sudo -i
ps ax | grep -i -e mysql -e mariadb
systemctl stop mysql
systemctl stop mysqld
systemctl stop mariadb
ps ax | grep -i -e mysql -e mariadb

to see if we can shut it down properly this way.

[Sharo]

@Sebastian-Roth

Hello, thank you for your response. Here’s what I got:

Thank you

[Sebastian Roth]

@Sharo Well, database seems to be down now, so try:

sudo -i
mysqld_safe --skip-grant-tables &
mysqladmin -u root password
...
mysqladmin -u root shutdown
systemctl start mysql
mysql -u root -p

[Sharo]

@Sebastian-Roth

I’m just going to reinstall Ubuntu 16.04 followed by creating a timeshift restore point pre 1.5.7 fog installation.

Could you point me to an updated install guide?

Thank you for your help.

[Sebastian Roth]

@Sharo It’s not that hard to get this back up. No need to reinstall just because of that. Shall we do a shared desktop session? See speak bubble in the top right corner.