Can't access FOG Management Portal after clean OS and FOG install
-
@Wayne-Workman What’s the cause of Updating Database failing? Have you tried the url we call?
http://fogserver/fog/management/index.php?node=schema&confirm=1
-
You must remember, the “updating database” failing on a fresh install would ultimately mean the database didn’t get created.
I’d start by taking a look at the apache error logs.
-
Please pull the latest master branch:
sudo -i ufw disable cd mv fogproject fogproject_bak git clone https://github.com/fogproject/fogproject.git cd fogproject/bin ./installfog.sh -yI’ve added a few more “checks” and balances to the PDODB class that should prevent the errors (if indeed you were seeing updating database failed.)
With any luck the server will install properly.
I’m still on the fence that this is a firewall issue though. This is why the command set above includes the ufw disable command.
-
Thanks for all your replies.
The firewall is disabled (confirmed with
sudo ufw status). I pulled the latest master branch and re-ran./installfog.sh -y, but received the same Updating Database… Failed! message.I confirmed that the fog database was never created in MySQL.
I can try upgrading to Ubuntu 16.04, but ran into the same issue when I installed FOG on a 16.04 VM a few days ago. Perhaps pulling the latest master branch and disabling the firewall will do the trick on 16.04. Stay tuned…
-
@acole Could you post the foginstall error log here?
Located in your git folder/bin/error_logs
-
Is your mysql root user password blank? If it is, would you mind trying:
mysql -u root ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY ''; ALTER USER 'root'@'127.0.0.1' IDENTIFIED WITH mysql_native_password BY ''; quit -
I finally got the installation to finish successfully by:
- Upgrading Ubuntu to 16.04
- Completely uninstalling FOG and deleting the fog user
- Creating the FOG database manually
- Modifying the credentials for the MySQL user in /var/www/html/fog/lib/fog/config.class.php to match the root password.
I was able to create the schema and login to FOG, so now it looks like it’s working again. No idea why FOG had trouble creating the DB on a clean install of Ubuntu…
-
@acole said in Can't access FOG Management Portal after clean OS and FOG install:
Modifying the credentials for the MySQL user in /var/www/html/fog/lib/fog/config.class.php to match the root password.
Not a good idea. You set mysql credentials and all other things inside of
/opt/fog/.fogsettings
Without modifying it in this place, the next time you re-run the installer the custom changes inside of config.class.php will be erased. Without doing it right, you’re just going to have the exact same issues the next time.See these articles for details:
https://wiki.fogproject.org/wiki/index.php?title=.fogsettings
https://wiki.fogproject.org/wiki/index.php?title=Password_Central -
This post is deleted! -
So, If I modify /opt/fog/.fogsettings to reflect the correct MySQL password, will that take care of it?
-
FOG version: 1.3.4
OS: Ubuntu Server 16.04 (virtual under Hyper-V)Clean install of Ubuntu Server (partitions formatted)
Clean install of FOGThe install process seems okay except for:
- Copying new files to web folder…OK
find: `/home//fog_web_1.3.4.BACKUP/management/other/´: No such file or directory - Creating config file…OK
But when I get to:
- You still need to install/update your database schema.
- This can be done by opening a web browser and going to:
http://IPaddress/fog/management
- Press [Enter] key when database is updated/installed.
I use a browser to go to the IP address and get the default Apache page, but if I add /fog/management I get a blank page with a 500 error.
Firewall is disabled.
The only databases listed in MySql are (1) information_schema, (2) mysql, (3) performance_schema, and (4) sys
- Copying new files to web folder…OK
-
Perhaps a factor:
/images
is mounted at /dev/sda6 -
It has nothing to do with the /images location.
The problem is to deal with localhost vs. 127.0.0.1
Something switched on us apparently, as the code for handling alter user appears to have now changed in some way (even though the scripts handling this interaction hasn’t).
I’ve added a bit of a fix hopefully in the working-1.3.5:
https://github.com/FOGProject/fogproject/commit/9acc65bcb9fa6ea50facfc38615f7400b0afcc26#diff-c7d534e343a3d117623765442be0d709I don’t know if it will work, but I suspect it will make things a little bit more managable.
-
@acole said in Can't access FOG Management Portal after clean OS and FOG install:
So, If I modify /opt/fog/.fogsettings to reflect the correct MySQL password, will that take care of it?
Changing stuff inside of /opt/fog/.fogsettings and then re-running the fog installer will make the settings you set become ‘in use’, plus the installer will re-use these settings the next time it’s run, be it this version of FOG or a future one.
-
@Tom-Elliott
Would installing an earlier version (after re-installing OS) work? I’m not sure how I would install a RC, don’t even know if your addition has been added to RC. -
@TRex No.
I think if you’re willing to jump around, please jump to what will be released soon, vs going back and forth. I don’t jump back and forth unless I absolutely have to and only to find a specific cause of a change.
Since I know the ALTER user stuff hasn’t changed for quite a while, the only other thing I can think is a change in Ubuntu’s layout structures. This caused a change in representation to mysql for localhost which is why you see the code change I’ve added in the earlier posting. I’ve made this change based on my own findings in an attempt to help correct any potential issues in the future regarding localhost/127.0.0.1 representation.
-
@Tom-Elliott
Using the instructions at https://wiki.fogproject.org/wiki/index.php?title=Installation#Current_development_version I ran the installation. The only problem I noted during installation was a failure of backing up database. There was no prompt for ‘Press [Enter] key when database is updated/installed.’ I still get a blank page when trying to go to http://<ipaddress>/fog/management and mysql still shows the same four databases (none for FOG). -
@Tom-Elliott
Just installed version 1.3.3 / SVN Revision: 6061 — installed without a hitch. -
@Tom-Elliott
Running that command, I get - Status: inactiveI’m seeing the same issue with Ubuntu 14.04 and 16.04 in a VMware environment with 1.3.4.
-
@Tom-Elliott I’m having the same problem after a new install using CentOS. I tried running sudo ufw status but it says the command isn’t found. The website wouldn’t work during or after install.
