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

    Fog upgrade 1.1.1 --> 1.1.2 database error

    Scheduled Pinned Locked Moved
    FOG Problems
    15
    24
    14.9k
    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.
    • R
      RipAU
      last edited by

      Hi guys,

      Just having trouble getting fog to update to version 1.1.2.
      I’m not sure if this is a bug or something I may have done.
      but I get the following when trying to run the Database Schema Install / Updater

      [CODE]1.1.2
      Open Source Computer Cloning Solution
      Database Schema Installer / Updater

      Update/Install Failed!
      The following errors occured

      Update ID: 1 - 0

      Database Error:

      Database SQL:

      CREATE DATABASE fog

      Update ID: 1 - 1

      Database Error:

      Database SQL:

      CREATE TABLE fog.groupMembers (
      gmID int(11) NOT NULL auto_increment,
      gmHostID int(11) NOT NULL,
      gmGroupID int(11) NOT NULL,
      PRIMARY KEY (gmID),
      KEY new_index (gmHostID),
      KEY new_index1 (gmGroupID)
      ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC[/CODE]

      That is a small snip but it lists on and on for quite awhile.

      I’ve pasted the full error here: --> [url]http://pastebin.com/vY2FVYQh[/url]

      Cheers,

      1 Reply Last reply Reply Quote 0
      • Tom ElliottT
        Tom Elliott
        last edited by

        Please check the /opt/fog/.fogsettings file and fix for your environment. I fixed many installer issues but I couldn’t fix this file.

        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
        • R
          RipAU
          last edited by

          I’m not sure what you mean by fix?

          I tested the following and am still getting the error:

          [CODE]ipaddress=“10.0.0.254”;
          interface=“eth0”;
          routeraddress=“”;
          plainrouter=“”;
          dnsaddress=“”;
          dnsbootimage=“”;
          password=“password”;
          osid=“1”;
          osname=“Redhat”;
          dodhcp=“n”;
          bldhcp=“0”;
          installtype=“N”;
          snmysqluser=“”
          snmysqlpass=“password”;
          snmysqlhost=“”;
          installlang=“0”;
          donate=“0”;
          fogupdateloaded=“1”
          [/CODE]

          So I am guessing that isn’t correct?

          Cheers,

          1 Reply Last reply Reply Quote 0
          • Tom ElliottT
            Tom Elliott
            last edited by

            Correct its not correct from what I can tell. Snmysqlhost should be localhost for default install. Snmysqluser should be root and snmysqlpass should be whatever the mysql root password is.

            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
            • C
              ckruijntjens
              last edited by

              Hello,

              I have the same issue??

              1 Reply Last reply Reply Quote 0
              • JunkhackerJ
                Junkhacker Developer
                last edited by

                [quote=“ckruijntjens, post: 31412, member: 24566”]Hello,

                I have the same issue??[/quote]

                then have you tried the same suggested solution?

                signature:
                Junkhacker
                We are here to help you. If you are unresponsive to our questions, don't expect us to be responsive to yours.

                1 Reply Last reply Reply Quote 0
                • J
                  John Hough
                  last edited by

                  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

                  1 Reply Last reply Reply Quote 0
                  • I
                    ianabc Testers
                    last edited by

                    This is more of a workaround than a solution

                    I had the same issue with the installer, the mysql configuration in /var/www/html/fog/lib/fog/Config.class.php ended up being incorrect this led to the upgrade script in the fog GUI not detecting my current settings and trying to do a CREATE as in the first post. Putting the correct information allowed the update script to complete successfully.

                    1 Reply Last reply Reply Quote 0
                    • J
                      John Hough
                      last edited by

                      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.

                      1 Reply Last reply Reply Quote 0
                      • R
                        RipAU
                        last edited by

                        Ahhh yep, fixing up the root password and localhost fixed the issue.
                        I was confused as it seemed to work perfect the way it was on previous installations.

                        Thank you very much. I’ll start the upgrade on my storage nodes now as well.

                        1 Reply Last reply Reply Quote 0
                        • hariskarH
                          hariskar
                          last edited by

                          I had the same issue because during installation in the last message I pressed Enter without reading it. But the message was first to update database and then press enter. So I uninstalled fog and reinstalled correctly.

                          1 Reply Last reply Reply Quote 0
                          • D
                            darkxeno
                            last edited by

                            This post is deleted!
                            1 Reply Last reply Reply Quote 0
                            • D
                              darkxeno
                              last edited by

                              Im have the same issue but updating my setting didnt help me at all

                              1 Reply Last reply Reply Quote 0
                              • D
                                darkxeno
                                last edited by

                                just fixed it I went in to the /var/www/fog/lib/fog/Config.class.php and removed the password from there and it fixed it

                                1 Reply Last reply Reply Quote 0
                                • R
                                  Rui Araújo
                                  last edited by

                                  [quote=“darkxeno, post: 31683, member: 4011”]just fixed it I went in to the /var/www/fog/lib/fog/Config.class.php and removed the password from there and it fixed it[/quote]
                                  Thank you so much! It solved my problem too! 😄

                                  1 Reply Last reply Reply Quote 0
                                  • D
                                    darkxeno
                                    last edited by

                                    [quote=“Rui Araújo, post: 31804, member: 24515”]Thank you so much! It solved my problem too! :D[/quote]
                                    no problem anything to help

                                    1 Reply Last reply Reply Quote 0
                                    • B
                                      Bob Martens
                                      last edited by

                                      Thank you for the thread! This just saved me hours of work!

                                      1 Reply Last reply Reply Quote 0
                                      • B
                                        Bob Martens
                                        last edited by

                                        It looks like now that it is updated, it is still going to the scheme updater package. How can I get back to my login screen?

                                        1 Reply Last reply Reply Quote 0
                                        • B
                                          Bob Martens
                                          last edited by

                                          This one is done. Now I’m working on the non-booting machines issues.

                                          1 Reply Last reply Reply Quote 0
                                          • Quintin GiesbrechtQ
                                            Quintin Giesbrecht
                                            last edited by

                                            [quote=“darkxeno, post: 31683, member: 4011”]just fixed it I went in to the /var/www/fog/lib/fog/Config.class.php and removed the password from there and it fixed it[/quote]

                                            Thanks! that did it for me as well.

                                            Quintin Giesbrecht
                                            IT Manager
                                            Smith Neufeld Jodoin LLP

                                            1 Reply Last reply Reply Quote 0
                                            • 1
                                            • 2
                                            • 1 / 2
                                            • First post
                                              Last post

                                            167

                                            Online

                                            12.0k

                                            Users

                                            17.3k

                                            Topics

                                            155.2k

                                            Posts
                                            Copyright © 2012-2024 FOG Project