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.
    %(#393939][Wed Apr 15 11)[ [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]


  • 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 http://community.spiceworks.com/topic/564935-fog-database-error and http://fogproject.org/forum/threads/fog-is-inoperable-after-server-reboot.11460/


  • Senior Developer

    try:

    sudo apt-get install php5-mysqld
    

  • 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!


  • Moderator

    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.
    %(#393939][Wed Apr 15 11)[ [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/]


  • Testers

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


Log in to reply
 

490
Online

38926
Users

10692
Topics

101460
Posts

Looks like your connection to FOG Project was lost, please wait while we try to reconnect.