• Recent
    • Unsolved
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Register
    • Login
    1. Home
    2. John Hough
    J
    • Profile
    • Following 0
    • Followers 0
    • Topics 0
    • Posts 2
    • Best 0
    • Controversial 0
    • Groups 0

    John Hough

    @John Hough

    3
    Reputation
    220
    Profile views
    2
    Posts
    0
    Followers
    0
    Following
    Joined Last Online

    John Hough Unfollow Follow

    Latest posts made by John Hough

    • RE: Fog upgrade 1.1.1 --> 1.1.2 database error

      Did some more troubleshooting based on those Apache errors, I did a diff between the DatabaseManager.class.php between the versions and noticed the changes in where it is checking for the DATABASE_TYPE. I went into the Config.class.php that is used with 1.1.2 and found a static password entry for the root user when connecting to the MySQL database. I removed the static password leaving just the “” on the line, I then loaded up the page and the database update processed without problems.

      posted in FOG Problems
      J
      John Hough
    • RE: Fog upgrade 1.1.1 --> 1.1.2 database error

      I am experiencing the same issue, if I reinstall 1.1.1 I can get back in. While trouble shooting it I made copies of my before and after .fogsettings file in the /opt/fog directory and noticed a couple of things.

      First this is the one from the 1.1.1 installation:

      Created by the FOG Installer

      Version: 1.1.1

      Install time: Thu 26 Jun 2014 10:56:41 AM MDT

      ipaddress=“172.16.0.13”;
      interface=“bond0”;
      routeraddress=“# option routers x.x.x.x;”;
      plainrouter=“”;
      dnsaddress=“# option domain-name-servers x.x.x.x; “;
      dnsbootimage=””;
      password=“b5a9cd”;
      osid=“2”;
      osname=“Debian”;
      dodhcp=“n”;
      bldhcp=“0”;
      installtype=“N”;
      snmysqluser=“root”;
      snmysqlpass=“”;
      snmysqlhost=“localhost”;
      installlang=“0”;
      donate=“1”;
      fogupdateloaded=“1”

      Next is the one after 1.1.2 was installed:

      Created by the FOG Installer

      Version: 1.1.1

      Install time: Thu 26 Jun 2014 11:12:18 AM MDT

      ipaddress=“172.16.0.13”;
      interface=“bond0”;
      routeraddress=“# option routers x.x.x.x;”;
      plainrouter=“”;
      dnsaddress=“# option domain-name-servers x.x.x.x; “;
      dnsbootimage=””;
      password=“a41d31”;
      osid=“2”;
      osname=“Debian”;
      dodhcp=“n”;
      bldhcp=“0”;
      installtype=“N”;
      snmysqluser=“root”
      snmysqlpass=“a41d31”;
      snmysqlhost=“localhost”;
      installlang=“0”;
      donate=“1”;
      fogupdateloaded=“1”

      The installer changed the password entries and I noticed the semicolon is missing after the mysqluser line as well as the fogupdateloaded line.

      However I do not believe that this is the problem, my apache2 error log fills up with these errors with 1.1.2 installed and not with 1.1.1 installed.

      [Thu Jun 26 11:49:59.404576 2014] [:error] [pid 4933] [client 172.16.3.24:52333] PHP Warning: MySQL::sqlerror(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 180
      [Thu Jun 26 11:49:59.404833 2014] [:error] [pid 4933] [client 172.16.3.24:52333] PHP Warning: mysqli::escape_string(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 247
      [Thu Jun 26 11:49:59.404906 2014] [:error] [pid 4933] [client 172.16.3.24:52333] PHP Warning: mysqli::query(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 89
      [Thu Jun 26 11:49:59.404946 2014] [:error] [pid 4933] [client 172.16.3.24:52333] PHP Warning: MySQL::sqlerror(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 180

      posted in FOG Problems
      J
      John Hough