1.5.7, 1.5.8 & DEV Install issues
-
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-64Two nics
eno4-Internet
eno3-FOGThank you in advance for your help!
-
@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.
-
Hi Sebastian,
Is “password” in red supposed to be my password or is password the password?
-
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 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
-
Hello, sorry for the delay here’s what I got:
-
Here’s the rest of the command string:
-
@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 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
-
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.
-
@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.