Solved 1.5.7, 1.5.8 & DEV Install issues

[Sharo]

Hello,

I’ve attempted to install 1.5.7, 1.5.8 (fog_stable at time of posting), and dev_branch. 1.5.7 and 1.5.8 gave me issue with SSL CA.

Upon reading the forms it was recommend I try installing dev_branch as others had success at this point in the installation. dev_branch gave me issue at installation with mysql.

Original install status
1.5.7&1.5.8:
Issues with SSL CA
dev_branch:
Issues at mysql portion of install. Fail to login.

Interestingly, having run all installations one after It seems dev_branch did fix SSL CA. 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, I’m hoping I missed something Below are specs of this server

Host info:
Static hostname: FOG01
Icon name: computer
Machine ID: 963549a897194de18043780fb842385c
Boot ID: 21253c11aafb491c88c030e766f1f8c2
Operating System: Ubuntu 16.04.6 LTS
Kernel: Linux 4.15.0-45-generic
Architecture: x86-64

Two nics
eno4-Internet
eno3-FOG

Thank you in advance 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.

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

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

Thank you

[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

Here’s the rest of the command string:

[Sharo]

@Sebastian-Roth

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

[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

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.

[Sharo]

@Sebastian-Roth

Hi Sebastian,

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

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