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

    Storage ID 0 is not valid / A valid database connection could not be made

    Scheduled Pinned Locked Moved Solved
    FOG Problems
    4
    27
    10.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.
    • E
      entr0py
      last edited by

      Also, either user should work given the grants in MySQL.

      mysql> show grants for fog;
      ±---------------------------------------------------------------------------------------------------+
      | Grants for fog@% |
      ±---------------------------------------------------------------------------------------------------+
      | GRANT USAGE ON . TO ‘fog’@‘%’ IDENTIFIED BY PASSWORD ‘2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19’ |
      | GRANT ALL PRIVILEGES ON fog.
      TO ‘fog’@’%’ WITH GRANT OPTION |
      ±---------------------------------------------------------------------------------------------------+
      2 rows in set (0.00 sec)

      mysql> show grants for fogstorage;
      ±----------------------------------------------------------------------------------------------------------+
      | Grants for fogstorage@% |
      ±----------------------------------------------------------------------------------------------------------+
      | GRANT USAGE ON . TO ‘fogstorage’@‘%’ IDENTIFIED BY PASSWORD ‘2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19’ |
      | GRANT ALL PRIVILEGES ON fog.
      TO ‘fogstorage’@’%’ WITH GRANT OPTION |
      ±----------------------------------------------------------------------------------------------------------+
      2 rows in set (0.00 sec)

      mysql>

      1 Reply Last reply Reply Quote 0
      • Tom ElliottT
        Tom Elliott @entr0py
        last edited by

        @entr0py I confirmed the storage id 0 is not valid issue. Mind you, this was literally just a message. The node was indeed created and functional even though this message was there.

        When you create a new node, the page redirects to the “edit” page. This edit page needs to have the id passed into it. I missed passing it the “edit” portion and had the id being incorrectly set.

        While this was a very minor bug, I have republished as RC-20. Sorry for not noticing it sooner.

        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

        E 1 Reply Last reply Reply Quote 0
        • E
          entr0py @Tom Elliott
          last edited by

          @Tom-Elliott

          Any thoughts on why the storage node still doesn’t work? If I try to create a task it says the node doesn’t exist. If I try to create a task I get the following:

          0_1478480560515_failed.png

          If I try to show the node on the dashboard it isn’t even listed:

          0_1478480581836_node list.png

          If I try to image a computer using “Deploy Image” on GRUB menu:

          0_1478480682552_20161106_190157.jpg

          1 Reply Last reply Reply Quote 0
          • Tom ElliottT
            Tom Elliott
            last edited by Tom Elliott

            It’s seems it’s connecting to the db now, but we can’t seem to connect to the other nodes.

            This might be due to two things.

            I modified a function to help ensure the nodes are available before getting data. The () on the nodes tells me the main server is unable to request the other nodes’ urls. This might simply be because the isAvailable is using a connection timeout of 500 ms. Maybe this is just too short to see those servers? It worked fine in my testing, but my nodes are admittedly within the same network I am. To test this theory, please open up the file:

            /var/www/fog/lib/fog/fogurlrequests.class.php.

            At lines: 271 and 327.

            Please make them read as:
            $options[CURLOPT_CONNECTTIMEOUT_MS] = 2000;

            I think maybe then you’ll start seeing data filling in these areas?

            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

            Tom ElliottT 1 Reply Last reply Reply Quote 0
            • Tom ElliottT
              Tom Elliott @Tom Elliott
              last edited by Tom Elliott

              and I think that will fix for the unable to create the task issue for you too. (The changing the timeout to 2000 miliseconds).

              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

              E 2 Replies Last reply Reply Quote 0
              • E
                entr0py
                last edited by entr0py

                That might be the problem considering I don’t even have that file…

                root@FOG-Virtual-Machine:/var/www/fog/lib/fog# ls -lsa quests
                ls: cannot access quests: No such file or directory

                Those are supposed to be asterisks for anything quests anything. I only have one file in the whole lib/fog directory with a newer date than August 13 2014…

                1 Reply Last reply Reply Quote 0
                • E
                  entr0py @Tom Elliott
                  last edited by

                  @Tom-Elliott

                  Nevermind… how about /var/www/html/fog/lib/fog

                  My bad.

                  Tom ElliottT 1 Reply Last reply Reply Quote 0
                  • E
                    entr0py @Tom Elliott
                    last edited by

                    @Tom-Elliott

                    Upgraded to 6007 on both host and node, made the change you suggested and still nothing. Same routine.

                    I created another node with all the same settings, placed it in the same storage group, disabled the old node and enabled the new one and still nothing. If I select that storage group on the dashboard it shows 0/0/0 with and the node doesn’t show in the list either.

                    1 Reply Last reply Reply Quote 0
                    • Tom ElliottT
                      Tom Elliott @entr0py
                      last edited by

                      @entr0py your issue brought another partial issue for what I would call doubles. At one point the server only used /var/www/fog for ubuntu (this is usually set as a link now).

                      Please try running:
                      rm -rf /var/www/fog; ln -s /var/www/{html/,}fog

                      This should allow the server to see the files regardless of how you’re accessing the data (why you didn’t see fogurlrequests).

                      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
                      • Tom ElliottT
                        Tom Elliott
                        last edited by

                        Remoted in and found that the server was in fairly funky state.

                        It is ubuntu 12.04, and while we typically recommend to update, this particular issue was simply due to ondrej attempting to install php 7, but the packages variable on fogsettings was pre-labelled as php 5. Removed the packages variable and php/apache on the node, updated the php version stored in the fogsettings, reinstalled ondrej, and re-ran installer .

                        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 1
                        • 1
                        • 2
                        • 2 / 2
                        • First post
                          Last post

                        207

                        Online

                        12.0k

                        Users

                        17.3k

                        Topics

                        155.2k

                        Posts
                        Copyright © 2012-2024 FOG Project