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



  • Hello
    I upgraded from 7981 to 8120
    0_1466060042303_Sans titre.png

    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



  • ok that works thanks


  • Senior Developer

    That would lead me to think you need to edit your /var/www/fog/lib/config.class.php file.



  • 0_1466083410942_Sans titre.png

    Internet explorer, Firefox, Iceweasel


  • Senior Developer

    @davido38 is it displaying a message? What browser are you using?





  • @davido38 i just upgrade to 5694 ant it works for me


  • Senior Developer

    @davido38 Hard refresh.



  • Just upgrade to 5694 and same problem it stay stuck on “Database Schema Installer / Updater”


  • Senior Developer

    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.



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


  • Senior Developer

    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


  • Senior Developer

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


  • Moderator

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



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


  • Moderator

    @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 i already made that without success
    as the database didn’t modified may be i could downgrade ?


  • Moderator

    @plegrand Try restarting mysql and then apache service.



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

    Sure can you remind me of log location.

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


Log in to reply
 

Looks like your connection to FOG Project was lost, please wait while we try to reconnect.