• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login

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

Scheduled Pinned Locked Moved Solved
Bug Reports
6
28
7.0k
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • P
    plegrand
    last edited by plegrand Jun 16, 2016, 2:59 AM Jun 16, 2016, 7:35 AM

    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

    P 1 Reply Last reply Jun 16, 2016, 9:22 AM Reply Quote 0
    • P
      plegrand @plegrand
      last edited by Jun 16, 2016, 9:22 AM

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

      1 Reply Last reply Reply Quote 0
      • Q
        Quazz Moderator
        last edited by Jun 16, 2016, 9:25 AM

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

        P 1 Reply Last reply Jun 16, 2016, 9:33 AM Reply Quote 0
        • M
          Matthieu Jacquart
          last edited by Jun 16, 2016, 9:25 AM

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

          Fog 1.5.9.138
          Debian 11
          Vmware ESXi

          1 Reply Last reply Reply Quote 0
          • Q
            Quazz Moderator
            last edited by Jun 16, 2016, 9:27 AM

            Try replacing localhost with 127.0.0.1 and see if that helps.

            P 1 Reply Last reply Jun 16, 2016, 9:39 AM Reply Quote 0
            • P
              plegrand @Quazz
              last edited by plegrand Jun 16, 2016, 3:33 AM Jun 16, 2016, 9:33 AM

              @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

              1 Reply Last reply Reply Quote 0
              • I
                ITCC
                last edited by Jun 16, 2016, 9:35 AM

                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

                0_1466069703162_upload-b0fb4a51-2d03-4d5b-b037-bd75524807ff

                Q 1 Reply Last reply Jun 16, 2016, 9:36 AM Reply Quote 0
                • Q
                  Quazz Moderator @ITCC
                  last edited by Jun 16, 2016, 9:36 AM

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

                  P I 2 Replies Last reply Jun 16, 2016, 9:37 AM Reply Quote 0
                  • P
                    plegrand @Quazz
                    last edited by Jun 16, 2016, 9:37 AM

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

                    1 Reply Last reply Reply Quote 0
                    • I
                      ITCC @Quazz
                      last edited by Jun 16, 2016, 9:37 AM

                      @Quazz

                      Sure can you remind me of log location.

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

                      1 Reply Last reply Reply Quote 0
                      • P
                        plegrand @Quazz
                        last edited by plegrand Jun 16, 2016, 3:40 AM Jun 16, 2016, 9:39 AM

                        @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',"");
                        }
                        
                        Q 1 Reply Last reply Jun 16, 2016, 9:44 AM Reply Quote 0
                        • Q
                          Quazz Moderator @plegrand
                          last edited by Jun 16, 2016, 9:44 AM

                          @plegrand Try restarting mysql and then apache service.

                          P 1 Reply Last reply Jun 16, 2016, 9:46 AM Reply Quote 0
                          • P
                            plegrand @Quazz
                            last edited by Jun 16, 2016, 9:46 AM

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

                            Q 1 Reply Last reply Jun 16, 2016, 9:50 AM Reply Quote 0
                            • Q
                              Quazz Moderator @plegrand
                              last edited by Jun 16, 2016, 9:50 AM

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

                              P 1 Reply Last reply Jun 16, 2016, 9:51 AM Reply Quote 0
                              • P
                                plegrand @Quazz
                                last edited by Jun 16, 2016, 9:51 AM

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

                                Q T 2 Replies Last reply Jun 16, 2016, 9:53 AM Reply Quote 0
                                • Q
                                  Quazz Moderator @plegrand
                                  last edited by Jun 16, 2016, 9:53 AM

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

                                  1 Reply Last reply Reply Quote 0
                                  • T
                                    Tom Elliott @plegrand
                                    last edited by Jun 16, 2016, 9:54 AM

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

                                    Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                                    Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                                    Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                                    1 Reply Last reply Reply Quote 0
                                    • T
                                      Tom Elliott
                                      last edited by Jun 16, 2016, 9:55 AM

                                      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

                                      Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                                      Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                                      Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                                      P 1 Reply Last reply Jun 16, 2016, 9:56 AM Reply Quote 0
                                      • P
                                        plegrand @Tom Elliott
                                        last edited by plegrand Jun 16, 2016, 4:00 AM Jun 16, 2016, 9:56 AM

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

                                        1 Reply Last reply Reply Quote 0
                                        • T
                                          Tom Elliott
                                          last edited by Jun 16, 2016, 10:19 AM

                                          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.

                                          Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                                          Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                                          Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                                          1 Reply Last reply Reply Quote 0
                                          • 1
                                          • 2
                                          • 1 / 2
                                          1 / 2
                                          • First post
                                            5/28
                                            Last post

                                          176

                                          Online

                                          12.0k

                                          Users

                                          17.3k

                                          Topics

                                          155.2k

                                          Posts
                                          Copyright © 2012-2024 FOG Project