FOG Project

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

    SVN 3254 not responding after update

    FOG Problems
    3
    11
    2516
    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 Hales
      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 Hales
        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
        • Tom Elliott
          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 Hales
            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 Elliott
              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 Hales
                Joseph Hales Testers last edited by

                This post is deleted!
                1 Reply Last reply Reply Quote 0
                • Joseph Hales
                  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
                  • Tom Elliott
                    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
                    • Wayne Workman
                      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
                      • Joseph Hales
                        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
                        • Joseph Hales
                          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
                          • 1 / 1
                          • First post
                            Last post

                          200
                          Online

                          10.2k
                          Users

                          16.3k
                          Topics

                          149.9k
                          Posts

                          Copyright © 2012-2020 FOG Project