7981 to 8120 - stuck on "Database Schema Installer / Updater"
-
Hello
I upgraded from 7981 to 8120
I made the changes into /var/www/html/fog/lib/fog/config.class.php without success
private static function db_settings() { define('DATABASE_TYPE','mysql'); // mysql or oracle define('DATABASE_HOST','localhost'); define('DATABASE_NAME','fog'); define('DATABASE_USERNAME','root'); define('DATABASE_PASSWORD',""); }
But it stay stuck on “Database Schema Installer / Updater”
In the source code of the web page i can see that :
<div id="dbNotRunning" class="hidden"> Your database connection appears to be invalid. FOG is unable to communicate with the database. There are many reasons why this could be the case. Please check your credentials in /var/www/fog/lib/fog/config.class.php. Also confirm that the database is indeed running. If credentials are correct, and the Database service is running, check to ensure your filesystem has enough space. </div>
mysql -h localhost -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 93 Server version: 5.5.49-0+deb8u1 (Debian) Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> use fog Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql>
df -h Sys. de fichiers Taille Utilisé Dispo Uti% Monté sur /dev/sda1 8,2G 1,2G 6,6G 15% / udev 10M 0 10M 0% /dev tmpfs 6,3G 154M 6,2G 3% /run tmpfs 16G 0 16G 0% /dev/shm tmpfs 5,0M 0 5,0M 0% /run/lock tmpfs 16G 0 16G 0% /sys/fs/cgroup /dev/sda5 2,7G 471M 2,1G 19% /var /dev/sda7 360M 3,8M 334M 2% /tmp /dev/sda8 842G 245G 555G 31% /home
What i have to do ?
I’m wondering if it’s not the evasive mod, could it be that ?
there is a lot of file /tmp/dos-xxx.xxx.xxx.xxx, it seems to be blacklisted clientThen i made a test : a2dismod evasive
then it works !!!a2enmod evasive
it doesnt work !!I speak too fast same problem
Then i modified the .fogsettings like that
snmysqluser=‘root’
snmysqlpass=“”
snmysqlhost=‘localhost’
irun again installer same problem.
It’s a big problem for us because i cant use fog for the moment -
@plegrand At this step is it possible to downgrade to make fog works again ?
-
You can safely remove mod_evasive from your install, FOG no longer relies on it.
-
I had same problem but after completing config.class.php everything works fine.
-
Try replacing localhost with 127.0.0.1 and see if that helps.
-
@Quazz i made that but in fact it didnt solve the problem
i thought it solved it but no
Everything worked fine before this upgrade -
-
@ITCC Could you make a seperate thread for that with the Apache error logs included?
-
@Quazz nothing interesting in error.log since i remove mod_evasive
-
Sure can you remind me of log location.
Also i have reverted our snapshot but am happy to go through it again.
-
@Quazz i made test with 127.0.0.1 same problem
snmysqluser='root' snmysqlpass="" snmysqlhost='127.0.0.1' private static function db_settings() { define('DATABASE_TYPE','mysql'); // mysql or oracle define('DATABASE_HOST','127.0.0.1'); define('DATABASE_NAME','fog'); define('DATABASE_USERNAME','root'); define('DATABASE_PASSWORD',""); }
-
@plegrand Try restarting mysql and then apache service.
-
@Quazz i already made that without success
as the database didn’t modified may be i could downgrade ? -
@plegrand You could, I suppose, although seeing as the issue is resolved for most it might be necessary to figure out why it’s not working for you.
If you need FOG then downgrade yes.
-
@Quazz during install i’ve got this message :
########################################################################################
FOG has adjusted to using a login system to protect what can/cannot be downloaded
We have detected that you don’t have credentials defined to perform the backup
If you would like the database to be backed up during install please define
in your /opt/fog/.fogsettings filefogguiuser=‘usernameOfFOGGUI’
fogguipass=‘passwordOfFOGGUIUser’You can also re-run this installer as:
fogguiuser=‘usernameOfFOGGUI’ fogguipass=‘passwordOfFOGGUIUser’ ././installfog.sh
########################################################################################Do you think that could be the problem ?
-
@plegrand Don’t know enough about it to say for certain, but it won’t hurt to add those lines to your .fogsettings file with your webgui login credentials.
-
@plegrand All this does is allows the installer to backup the data as necessary.
-
If disabling mod_evasive allows things to work, why not just remove it?
On CentOS the command to remove would be:
yum remove mod_evasive
I don’t remember what it is for ubuntu though I would imagine something like:
apt-get purge libmod-apache2-evasive
-
@Tom-Elliott as i said before remove mod_evasive didn’t solve the problem. I thought but no.
I’m on debian stable
Do you think i can downgrade ? -
I think the main issue was indeed solved, but then there was an issue in loading DB side. The Javascript that displays the normal text was not able to be displayed as the script that handles it was loaded out of order. Should be fixed, again, in the latest.