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

Database fails to initialize 2

Scheduled Pinned Locked Moved Solved
Bug Reports
5
24
7.4k
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.
  • S
    syschuck
    last edited by Aug 16, 2016, 10:00 PM

    This is a continuation of the Database fails to initialize. The problem is still present even with a clean install of Mageia5. This is using the latest SVN 5950 on a fresh clean install of Mageia 5. Everything in the installer works, but there are some package names that need to be updated in the lib/redhat/config.sh
    mod_ssl becomes apache-mod_ssl, php-process becomes php-pcntl, lastly php-pdo and php-pdo_mysql need to be added to the $packages list.

    Also fog wants to add and apache fog.conf to /etc/httpd/conf.d which doesn’t exist. /etc/httpd/conf/conf.d does and is the correct location for it. (I’ve just been adding a softlink to fix the glitch, ln -s /etc/httpd/conf/conf.d /etc/httpd/conf.d)

    Back to the original problem; When the installer gets to the part where mysql is populating and installing the schema, it should be calling mysql somewhere. Do you know were that might be at? Either there is an error when it’s getting launched or somehow it’s getting skipped.

    1 Reply Last reply Reply Quote 1
    • T
      Tom Elliott
      last edited by Aug 16, 2016, 10:40 PM

      If you want to take a look, I know you helped with the initial install of mageia layout for 0.33, which was left mostly unchanged until the current dev (1.3.0-RC’s) and what not started coming into existence.

      The changes we made earlier in the other post is only going to show up on RC-9, so it’s not surprising you’re seeing these things. However, what I may need to do is work with you to figure out exactly what changes need to be made, and what additions might be required.

      Most of the elements in the 1.3.0-RC-8 installer are now based on variable calls which will only be set IF they’re not already set. There is of course a few obscurities as I’m only so much robot (see what I did there lol). At anyrate, things you could look at would be:

      You can set inline with varname=values ./installfog.sh -y or store in .fogsettings file (much more likely and recommended)

      packages
      etcconf
      

      The only time I imagine this being an issue is on fresh installs, of which the suggestions for mageia’s package changes and etc configuration will be available for RC-9 (thanks to the detailed information).

      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

      S 1 Reply Last reply Aug 17, 2016, 3:09 PM Reply Quote 1
      • T
        Tom Elliott
        last edited by Aug 16, 2016, 10:48 PM

        To see, and if you’d like validate, here’s what’s changed.
        https://github.com/FOGProject/fogproject/commit/7b06043cc963a52d1a13836c72fb21c11ceb9b7e

        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
        • S
          syschuck @Tom Elliott
          last edited by Aug 17, 2016, 3:09 PM

          @Tom-Elliott Wow 0.33. It has been a while hasn’t it? I just tied the installer with your patches and it works perfectly. That needed updating for a while now. Thank you.

          The database schema issue that is still present though. Would you know off the top of you head where the schema is initially built? Were does mysql initially get called to build the database? I’m going to poke around today and see what I can find.

          S 1 Reply Last reply Aug 18, 2016, 2:32 PM Reply Quote 0
          • S
            syschuck @syschuck
            last edited by Aug 18, 2016, 2:32 PM

            @syschuck; Uhh-oh. This looks like a serious bug in the installer. I just installed the latest fog from github on a freshly installed Ubuntu 16.04 LTS and it too has the exact same issue with the database not getting build during the install.

            W Q 2 Replies Last reply Aug 18, 2016, 3:10 PM Reply Quote 0
            • W
              Wayne Workman @syschuck
              last edited by Aug 18, 2016, 3:10 PM

              @syschuck I’ve been sorta working on Ubuntu 16 here: https://forums.fogproject.org/topic/8338/fresh-clean-ubuntu-16-with-fog-trunk
              More like feeding the Devs what I find lol.

              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!
              Daily Clean Installation Results:
              https://fogtesting.fogproject.us/
              FOG Reporting:
              https://fog-external-reporting-results.fogproject.us/

              1 Reply Last reply Reply Quote 1
              • Q
                Quazz Moderator @syschuck
                last edited by Aug 18, 2016, 3:11 PM

                @syschuck You could try checking out the error logs in bin/error_logs (of your svn folder). There should be a log for each attempted version install.

                S 1 Reply Last reply Aug 18, 2016, 5:13 PM Reply Quote 0
                • S
                  syschuck @Quazz
                  last edited by Aug 18, 2016, 5:13 PM

                  @Quazz. That is part of the problem. There are no errors that are reported. The install script runs perfectly up to the point where it say;

                  • You still need to install/update your database schema.

                  • This can be done by opening a web browser and going to:

                    http://192.168.1.4/fog/management

                  • Press [Enter] key when database is updated/installed.

                  When you do go to http://192.168.1.4/fog/management your get the message:

                  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.

                  When I examine, the fog database hasn’t even been created in mysql.
                  That’s SVN 5950 on two freshly installed systems of Mageia 5, and Ubuntu 16.04.

                  S 1 Reply Last reply Aug 19, 2016, 9:33 PM Reply Quote 0
                  • S
                    syschuck @syschuck
                    last edited by Aug 19, 2016, 9:33 PM

                    @syschuck. I’m still baffled with this bug. Just to make sure it wasn’t the OS or a library causing some issue, I when back to fog_1.2.0, downloaded the tar, built and installed it on Mageia 5. It worked perfect! So I thought, maybe the new fog 1.3.0 RC8 would be different if there was already a database installed. It didn’t. I’m trying now to go-back to a SVN revision where the SQL initialization worked.

                    W 1 Reply Last reply Aug 19, 2016, 9:36 PM Reply Quote 0
                    • W
                      Wayne Workman @syschuck
                      last edited by Aug 19, 2016, 9:36 PM

                      @syschuck Find the line that creates the DB, and run it manually. Echo out any variables the line is using so you can construct the command to run.

                      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!
                      Daily Clean Installation Results:
                      https://fogtesting.fogproject.us/
                      FOG Reporting:
                      https://fog-external-reporting-results.fogproject.us/

                      S 1 Reply Last reply Aug 22, 2016, 9:58 PM Reply Quote 0
                      • S
                        syschuck @Wayne Workman
                        last edited by Aug 22, 2016, 9:58 PM

                        @Wayne-Workman. Solved! I’ve found something. I had to turn on debugging by changing two lines in packages/web/lib/fog/fogbase.class.php.

                        protected static $debug = false;
                        protected static $info = false;

                        Changing those to true opens a large amount of debug info.

                        The first line I see is the following;
                        FOG DEBUG: PDODB: Failed to connect: SQLSTATE[HY000] [2002] Connection refused
                        Several lines later.
                        FOG DEBUG: User: isValid Failed: Error: Invalid ID

                        There are also a large number of
                        FOG DEBUG: PDODB: Failed to query: Cannot connect to database
                        FOG DEBUG: PDODB: Failed to fetch: No query result, use query() first
                        FOG DEBUG: PDODB: Failed to get: No connection to the database

                        That might make since this is a first time install and the database doesn’t exist. This is using user = root and password = ‘’. I tested mysql with $ mysql -u root (from a ordinary user account) and was successfully logged in as mysql root without issue.

                        The web eventually does report:

                        Database Schema Installer / Updater
                        No connection available

                        So I suspect it’s not ever connecting the mysql database. PDODB: Failed to connect: SQLSTATE[HY000] [2002] Connection refused . Well a little googling shows that this error occurs when using the wrong host in mysql. We’ve been using an IP adress 127.0.0.1 as the hostname instead of ‘localhost’. So add;

                        echo “snmysqlhost=‘localhost’” >> lib/common/config.sh

                        fixed it!

                        So in otherwords, mysql was using user ‘root’@‘127.0.0.1’ instead of user ‘root’@‘localhost’.

                        W T 2 Replies Last reply Aug 22, 2016, 10:04 PM Reply Quote 1
                        • W
                          Wayne Workman @syschuck
                          last edited by Aug 22, 2016, 10:04 PM

                          @syschuck That’s interesting. I think it’s possible to pass variables to the installer. I’ll try that with Ubuntu 16 later.

                          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!
                          Daily Clean Installation Results:
                          https://fogtesting.fogproject.us/
                          FOG Reporting:
                          https://fog-external-reporting-results.fogproject.us/

                          1 Reply Last reply Reply Quote 0
                          • T
                            Tom Elliott @syschuck
                            last edited by Aug 22, 2016, 10:17 PM

                            @syschuck I usually use 127.0.0.1 so persistent connections can work, as I saw somewhat major issues using persistent connections and socket connections. Glad it was able to be fixed, but why does it matter if you use localhost vs. 127.0.0.1? I know one is socket (localhost) and the other is tcp (127.0.0.1), but why isn’t the default allowing creation of the root user to BOTH addresses? Interesting find. I’ll change the installer code to use localhost rather than 127.0.0.1 if the snmysqlhost field is blank.

                            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

                            W S 2 Replies Last reply Aug 23, 2016, 1:28 AM Reply Quote 0
                            • W
                              Wayne Workman @Tom Elliott
                              last edited by Aug 23, 2016, 1:28 AM

                              @Tom-Elliott But, did we not have a mess with Ubuntu on this very issue before, and you chose to use 127.0.0.1 because of it?

                              I’d ask to only set it as localhost for Mangeia 5.

                              I’ll test this setting also with Ubuntu 16 as it suffers from the DB not being created.

                              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!
                              Daily Clean Installation Results:
                              https://fogtesting.fogproject.us/
                              FOG Reporting:
                              https://fog-external-reporting-results.fogproject.us/

                              1 Reply Last reply Reply Quote 0
                              • S
                                Sebastian Roth Moderator @Tom Elliott
                                last edited by Aug 23, 2016, 5:00 AM

                                @Tom-Elliott said:

                                but why isn’t the default allowing creation of the root user to BOTH addresses?

                                Mysql does not automatically allow access to the reverse lookup of a hostname or vice versa. Even full qualified vs. short hostname might cause trouble. This is just the way mysql does things. You might want to look into adding both localhost and 127.0.0.1 but then there is the mess of keeping the passwords in sync. 😞

                                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

                                T 1 Reply Last reply Aug 23, 2016, 9:55 AM Reply Quote 0
                                • T
                                  Tom Elliott @Sebastian Roth
                                  last edited by Aug 23, 2016, 9:55 AM

                                  @Sebastian-Roth The issue, as I’m seeing it, is somewhere there was a change. Maybe this 127.0.0.1 vs. localhost change (I don’t care, at this point, for FQDN vs. short hostname) happened in a different version of mysql? I’ve never seen an issue using 127.0.0.1 or localhost on mysql, until now.

                                  In either case, using localhost shouldn’t pose an issue, and the only reason, as I stated earlier, that I started using tcp vs. socket was solely for persistent connections. Mind you this was still when I was using mysqli as the method of managing connections to the DB and I now use PDO which might have some better handling for this type of thing.

                                  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
                                  • S
                                    Sebastian Roth Moderator
                                    last edited by Aug 23, 2016, 11:08 AM

                                    @Tom-Elliott What I mean is explained here: http://serverfault.com/questions/544187/cant-connect-to-mysql-using-localhost-but-using-127-0-0-1-its-ok

                                    mysql> select user,host from mysql.user;
                                    +------+--------------------------------+
                                    | user | host                           |
                                    +------+--------------------------------+
                                    | root | 127.0.0.1                      | 
                                    | root | ::1                            |
                                    | root | localhost                      |
                                    +------+--------------------------------+
                                    3 rows in set (0.00 sec)
                                    

                                    As you can see there are different entries for the same user but different host entries in the mysql user table.

                                    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

                                    T 1 Reply Last reply Aug 23, 2016, 11:17 AM Reply Quote 0
                                    • T
                                      Tom Elliott @Sebastian Roth
                                      last edited by Aug 23, 2016, 11:17 AM

                                      @Sebastian-Roth I understand, just I’m used to them all being ready to use at the same time when the initial installation occurs.

                                      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

                                      S 1 Reply Last reply Aug 23, 2016, 2:13 PM Reply Quote 0
                                      • S
                                        syschuck @Tom Elliott
                                        last edited by Aug 23, 2016, 2:13 PM

                                        @Tom-Elliott I think I’ve found the explanation for this behavior. It’s controlled by an option in the mysql configuration /etc/my.cnf. The option is controlled by the variable skip-network which on the MariaDB on Mageia 5 and Ubuntu 16 is enabled. Apparently this is a security enhancement. If the skip-network line is remarked out in /etc/my.cnf Fog has no problems with 127.0.0.1 (or ::1 ip6 for that matter).

                                        It raises the question of how FOG should handle this. As newer security conscious distros come out, I suspect this will come up more and more.

                                        T 1 Reply Last reply Aug 23, 2016, 2:14 PM Reply Quote 1
                                        • T
                                          Tom Elliott @syschuck
                                          last edited by Aug 23, 2016, 2:14 PM

                                          @syschuck I’ve updated the installer to default to localhost as a “safety” of course you can still set your own host after, or inline with the installer.

                                          I believe the variable is:

                                          snmysqlhost='127.0.0.1'

                                          Of course you can run the installer as:

                                          snmysqlhost='localhost' ./installfog.sh -y

                                          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

                                          S 1 Reply Last reply Aug 23, 2016, 3:27 PM Reply Quote 0
                                          • 1
                                          • 2
                                          • 1 / 2
                                          1 / 2
                                          • First post
                                            2/24
                                            Last post

                                          156

                                          Online

                                          12.0k

                                          Users

                                          17.3k

                                          Topics

                                          155.2k

                                          Posts
                                          Copyright © 2012-2024 FOG Project