SVN 3254 not responding after update


  • Testers

    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]


  • Testers

    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]


  • Senior Developer

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


  • Testers

    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


  • Senior Developer

    Possibly. Do you have mysqlnd installed?


  • Testers

    This post is deleted!

  • Testers

    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


  • Senior Developer

    I am too! Well probably 3255 now!



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


  • Testers

    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]


  • Testers

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


 

382
Online

41.8k
Users

12.3k
Topics

116.0k
Posts