7981 to 8120 - stuck on "Database Schema Installer / Updater"

[plegrand]

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 client

Then 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]

@plegrand At this step is it possible to downgrade to make fog works again ?

[Quazz]

You can safely remove mod_evasive from your install, FOG no longer relies on it.

[Matthieu Jacquart]

I had same problem but after completing config.class.php everything works fine.

[Quazz]

Try replacing localhost with 127.0.0.1 and see if that helps.

[plegrand]

@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]

i added the information in and it worked.

localhost, root and PWD

but once i got it, it was broken in Chrome and not much better in IE

[Quazz]

@ITCC Could you make a seperate thread for that with the Apache error logs included?

[plegrand]

@Quazz nothing interesting in error.log since i remove mod_evasive

[ITCC]

@Quazz

Sure can you remind me of log location.

Also i have reverted our snapshot but am happy to go through it again.

[plegrand]

@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',"");
}

[Quazz]

@plegrand Try restarting mysql and then apache service.

[plegrand]

@Quazz i already made that without success
as the database didn’t modified may be i could downgrade ?

[Quazz]

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

[plegrand]

@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 file

fogguiuser=‘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 ?

[Quazz]

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

[Tom Elliott]

@plegrand All this does is allows the installer to backup the data as necessary.

[Tom Elliott]

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

[plegrand]

@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 ?

[Tom Elliott]

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.