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

    SVN 3254 not responding after update

    Scheduled Pinned Locked Moved
    FOG Problems
    3
    11
    3.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.
    • Joseph HalesJ
      Joseph Hales Testers
      last edited by

      Just updated to SVN 3254
      it had a new prompt during the install about SQL type I accepted the default of MYSQLI_ASYNC when it asked me to update my schema the website was unresponsive any suggestions? Apache seems to be ok because I am able to access webmin but not the fog/management page. Here are the last lines of the apache log.
      [COLOR=#393939][Wed Apr 15 11:02:02 2015] [error] [client 10.6.51.156] PHP Warning: mysqli::real_escape_string(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 286
      [Wed Apr 15 11:02:02 2015] [error] [client 10.6.51.156] PHP Warning: mysqli::real_escape_string(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 286
      [Wed Apr 15 11:02:02 2015] [error] [client 10.6.51.156] PHP Warning: mysqli::real_escape_string(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 286
      [Wed Apr 15 11:02:02 2015] [error] [client 10.6.51.156] PHP Warning: mysqli::real_escape_string(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 286
      [Wed Apr 15 11:02:02 2015] [error] [client 10.6.51.156] PHP Warning: mysqli::real_escape_string(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 286
      [Wed Apr 15 11:02:02 2015] [error] [client 10.3.50.87] PHP Warning: mysqli::real_escape_string(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 286
      [Wed Apr 15 11:02:02 2015] [error] [client 10.3.50.87] PHP Warning: mysqli::real_escape_string(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 286
      [Wed Apr 15 11:02:02 2015] [error] [client 10.3.50.87] PHP Warning: mysqli::real_escape_string(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 286
      [Wed Apr 15 11:02:02 2015] [error] [client 10.3.50.87] PHP Warning: mysqli::real_escape_string(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 286
      [Wed Apr 15 11:02:02 2015] [error] [client 10.3.50.87] PHP Warning: mysqli::real_escape_string(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 286
      [Wed Apr 15 11:02:02 2015] [error] [client 10.3.50.87] PHP Warning: mysqli::real_escape_string(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 286
      [Wed Apr 15 11:02:02 2015] [error] [client 10.3.50.87] PHP Warning: mysqli::real_escape_string(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 286
      [Wed Apr 15 11:02:02 2015] [error] [client 10.3.50.87] PHP Warning: mysqli::real_escape_string(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 286
      [Wed Apr 15 11:02:02 2015] [error] [client 10.43.48.180] PHP Warning: mysqli::query(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 122
      [Wed Apr 15 11:02:02 2015] [error] [client 10.43.48.180] PHP Warning: mysqli::query(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 122
      [Wed Apr 15 11:02:02 2015] [error] [client 10.43.48.180] PHP Warning: mysqli::query(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 122
      [Wed Apr 15 11:02:02 2015] [error] [client 10.43.48.180] PHP Warning: mysqli::query(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 122
      [Wed Apr 15 11:02:02 2015] [error] [client 10.43.48.180] PHP Warning: mysqli::query(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 122
      [Wed Apr 15 11:02:02 2015] [error] [client 10.43.48.180] PHP Warning: mysqli::query(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 122
      [Wed Apr 15 11:02:02 2015] [error] [client 10.43.48.180] PHP Warning: mysqli::query(): Couldn’t fetch mysqli in /var/www/fog/lib/d[/COLOR]

      1 Reply Last reply Reply Quote 0
      • Joseph HalesJ
        Joseph Hales Testers
        last edited by

        After 10 mins the schema page suddenly came up but after clicking update it also seems to time out.

        1 Reply Last reply Reply Quote 0
        • Joseph HalesJ
          Joseph Hales Testers
          last edited by

          Ok no response on the fog page at all now reran svn no errors shown here is the latest log entries.
          [COLOR=#393939][Wed Apr 15 11:48:21 2015] [error] [client 10.1.51.113] PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user ‘p:10.200.10.150’@‘localhost’ (using password: NO) in /var/www/fog/lib/db/MySQL.class.php on line 90
          [Wed Apr 15 11:48:21 2015] [error] [client 10.1.51.113] PHP Warning: mysqli::query(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 122
          [Wed Apr 15 11:48:21 2015] [error] [client 10.9.50.80] PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user ‘p:10.200.10.150’@‘localhost’ (using password: NO) in /var/www/fog/lib/db/MySQL.class.php on line 90
          [Wed Apr 15 11:48:21 2015] [error] [client 10.9.50.80] PHP Warning: mysqli::query(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 122
          [Wed Apr 15 11:48:21 2015] [error] [client 10.103.32.46] PHP Warning: mysqli::real_escape_string(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 286
          [Wed Apr 15 11:48:21 2015] [error] [client 10.103.32.46] PHP Warning: mysqli::real_escape_string(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 286
          [Wed Apr 15 11:48:21 2015] [error] [client 10.43.48.176] PHP Warning: mysqli::real_escape_string(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 286
          [Wed Apr 15 11:48:21 2015] [error] [client 10.43.48.176] PHP Warning: mysqli::real_escape_string(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 286
          [Wed Apr 15 11:48:21 2015] [error] [client 10.43.48.176] PHP Warning: mysqli::real_escape_string(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 286
          [Wed Apr 15 11:48:21 2015] [error] [client 10.43.48.176] PHP Warning: mysqli::real_escape_string(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 286
          [Wed Apr 15 11:48:21 2015] [error] [client 10.6.51.114] PHP Warning: mysqli::query(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 122
          [Wed Apr 15 11:48:21 2015] [error] [client 10.6.51.114] PHP Warning: mysqli::query(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 122
          [Wed Apr 15 11:48:21 2015] [error] [client 10.103.32.46] PHP Warning: mysqli::real_escape_string(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 286
          [Wed Apr 15 11:48:21 2015] [error] [client 10.103.32.46] PHP Warning: mysqli::real_escape_string(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 286
          [Wed Apr 15 11:48:21 2015] [error] [client 10.103.32.46] PHP Warning: mysqli::real_escape_string(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 286
          [Wed Apr 15 11:48:21 2015] [error] [client 10.103.32.46] PHP Warning: mysqli::real_escape_string(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 286
          [Wed Apr 15 11:48:21 2015] [error] [client 10.103.32.46] PHP Warning: mysqli::real_escape_string(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 286
          [Wed Apr 15 11:48:21 2015] [error] [client 10.103.32.46] PHP Warning: mysqli::real_escape_string(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 286
          [Wed Apr 15 11:48:21 2015] [error] [client 10.103.32.46] PHP Warning: mysqli::real_escape_string(): Couldn’t fetch mysqli in /var/[/COLOR]

          1 Reply Last reply Reply Quote 0
          • Wayne WorkmanW
            Wayne Workman
            last edited by

            I am also running r3254 and am[B] not[/B] having any issues. Fedora 21.

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

              I am too! Well probably 3255 now!

              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
              • Joseph HalesJ
                Joseph Hales Testers
                last edited by

                I had fallen behind on updates when I updated to 3254 it wouldn’t seem to complete the database schema installer/updater. I then tried 3255 when i run it it returns a string of errors like the following.
                Open Source Computer Cloning Solution

                Database Schema Installer / Updater

                Install / Update Failed!

                The following errors occured

                Update ID: 1 - 0

                Database Error:

                Access denied for user ‘p:10.200.10.150’@‘localhost’ (using password: NO), Message: Check that database is running
                Database SQL:

                CREATE DATABASE fog

                The only other new thing was the first time I updated to SVN 3254 it asked me about the SQL connection type was I wrong to choose the default MySQL Connection Type: MYSQLI_ASYNC

                1 Reply Last reply Reply Quote 0
                • Joseph HalesJ
                  Joseph Hales Testers
                  last edited by

                  This post is deleted!
                  1 Reply Last reply Reply Quote 0
                  • Tom ElliottT
                    Tom Elliott
                    last edited by

                    Possibly. Do you have mysqlnd installed?

                    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
                    • Joseph HalesJ
                      Joseph Hales Testers
                      last edited by

                      jhales@934fog2:~/svn/trunk/bin$ sudo apt-get install mysqlnd
                      Reading package lists… Done
                      Building dependency tree
                      Reading state information… Done
                      E: Unable to locate package mysqlnd
                      This ubuntu 12.04 LTS server

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

                        try:
                        [code]sudo apt-get install php5-mysqld[/code]

                        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
                        • Joseph HalesJ
                          Joseph Hales Testers
                          last edited by

                          Looks like installing the SVN the first time when it added MySQL Connection Type: MYSQLI_ASYNC to the .fogsettings it corrupted the entry for sqluser placing the local host in that place and losing a semicolon. Fixing that and restarting sql fixed it. This is the threads that lead me to it [url]http://community.spiceworks.com/topic/564935-fog-database-error[/url] and [url]http://fogproject.org/forum/threads/fog-is-inoperable-after-server-reboot.11460/[/url]

                          1 Reply Last reply Reply Quote 0
                          • 1 / 1
                          • First post
                            Last post

                          193

                          Online

                          12.1k

                          Users

                          17.3k

                          Topics

                          155.3k

                          Posts
                          Copyright © 2012-2024 FOG Project