• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • 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.
  • J
    Joseph Hales Testers
    last edited by Apr 15, 2015, 4:02 PM

    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
    • J
      Joseph Hales Testers
      last edited by Apr 15, 2015, 4:17 PM

      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
      • J
        Joseph Hales Testers
        last edited by Apr 15, 2015, 4:50 PM

        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
        • W
          Wayne Workman
          last edited by Apr 15, 2015, 5:25 PM

          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
          • T
            Tom Elliott
            last edited by Apr 15, 2015, 5:49 PM

            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
            • J
              Joseph Hales Testers
              last edited by Apr 15, 2015, 6:28 PM

              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
              • J
                Joseph Hales Testers
                last edited by Apr 15, 2015, 6:29 PM

                This post is deleted!
                1 Reply Last reply Reply Quote 0
                • T
                  Tom Elliott
                  last edited by Apr 15, 2015, 6:31 PM

                  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
                  • J
                    Joseph Hales Testers
                    last edited by Apr 15, 2015, 6:34 PM

                    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
                    • T
                      Tom Elliott
                      last edited by Apr 15, 2015, 6:53 PM

                      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
                      • J
                        Joseph Hales Testers
                        last edited by Apr 15, 2015, 7:19 PM

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

                        150

                        Online

                        12.0k

                        Users

                        17.3k

                        Topics

                        155.2k

                        Posts
                        Copyright © 2012-2024 FOG Project