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

Database update failed 1.1.0 to 1.1.1

Scheduled Pinned Locked Moved
FOG Problems
13
32
14.7k
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.
  • Z
    zeusnl
    last edited by Jun 13, 2014, 8:01 PM

    I down loaded the newest version of fog (1.1.1) today. When I installed it using /bin/installfog.sh I get stuck on Database Schema Installer / Updater. After I press update now I get stuck on the screen below. When I setup fog I set a my sql root password. During the update the installer asked if the root password was blank, I said no. The installer never asked for the password which I assume it retrieved from the current install. I have tried restarting the mysql service, but the schema update still fails.
    [IMG]http://fogproject.org/forum/data/attachments/1/1002-552a8d84d51c42ae89132e9e4abf5e40.jpg[/IMG]

    [url=“/_imported_xf_attachments/1/1002_fog error.png?:”]fog error.png[/url]

    1 Reply Last reply Reply Quote 0
    • M
      Michael Mullins
      last edited by Jun 13, 2014, 8:07 PM

      you can manually set the database password by editing config.php under /var/www/fog/commons

      1 Reply Last reply Reply Quote 0
      • A
        Atomos
        last edited by Jun 13, 2014, 8:10 PM

        Yep, I am getting the same issue, even on a clean installation of FOG.

        1 Reply Last reply Reply Quote 0
        • T
          Tom Elliott
          last edited by Jun 13, 2014, 8:24 PM

          Try redownloading the tar and reinstall. I just pushed a fix for the installer issue. Sorry about that.

          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
          • Z
            zeusnl
            last edited by Jun 13, 2014, 8:38 PM

            After using the new installer I was able to get everything working. It still appears to have blanked out the password in the config.php file.

            to fix the password (if you have problems)

            sudo gedit /var/www/fog/commons/config.php

            find this line

            define(‘DATABASE_PASSWORD’, ‘YourPasswordHere’);

            Place the password in between the parenthesis after the coma.
            restart apache (not sure you need to but I did)
            sudo service apache2 stop
            sudo service apache2 start

            Thanks for the quick help. Fog is awesome! Tom Rocks!

            1 Reply Last reply Reply Quote 0
            • T
              Tom Elliott
              last edited by Jun 13, 2014, 8:39 PM

              [quote=“zeusnl, post: 30273, member: 24640”]After using the new installer I was able to get everything working. It still appears to have blanked out the password in the config.php file.

              to fix the password (if you have problems)

              sudo gedit /var/www/fog/commons/config.php

              find this line

              define(‘DATABASE_PASSWORD’, ‘YourPasswordHere’);

              Place the password in between the parenthesis after the coma.
              restart apache (not sure you need to but I did)
              sudo service apache2 stop
              sudo service apache2 start[/quote]

              You shouldn’t have to restart apache because you’re editing the config for the web folder, not the apache configuration.

              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
              • T
                TheWizardUk
                last edited by Jun 14, 2014, 9:32 AM

                i had this problem this morning again with updating from 1.1.0 to 1.1.1 i reran the install when asked Did you leave the mysql password blank during install? (Y/n) answer n

                enter your sql db password

                this worked for me

                1 Reply Last reply Reply Quote 0
                • E
                  Eli Kelly
                  last edited by Jun 17, 2014, 6:24 PM

                  Just upgraded to 1.1.1 svn 1858 and am now having the same problem as OP.

                  I didn’t ever set the MySQL root password but /var/log/httpd/error_log shows this:
                  [CODE][Tue Jun 17 08:17:24 2014] [error] [client 10.1.10.192] PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user ‘root’@‘localhost’ (using password: YES) in /var/www/html/fog/lib/db/MySQL.class.php on line 64[/CODE]
                  followed by a number of lines of PHP warnings … Couldn’t fetch mysqli in …

                  There is no config.php in /var/www/fog/commons (/var/www/html/fog/commons for my installation). In addition the ipxe boot menu no longer shows up when clients boot.

                  FOG 1.1.1 svn 1858
                  CentOS 6.5
                  foginstall.log indicates “* Starting FOG Multicast Management Server…Failed!”

                  1 Reply Last reply Reply Quote 0
                  • T
                    Tom Elliott
                    last edited by Jun 18, 2014, 1:20 AM

                    Could you give these a suggestions a shot?
                    [url]http://howterrorisminindia.blogspot.com/2013/03/error-2002-hy000-cant-connect-to-local.html[/url]

                    Also, as you’re running svn, change your /var/www/fog/lib/fog/Config.class.php and reset the database password to ‘’ from whatever it currently is.

                    To fix this for future upgrades, edit the /opt/fog/.fogsettings file and set the snmysqlhost, snmysqluser, snmysqlpass properly. FOG is using the snmysqlpass to set the password for the database. It was broken in rev’s past, but I “fixed” it. One issue, though, is that this file, if exists, does not get recreated on other upgrades. So my guess is it’s got, more or less, a random password in place, which is what your db password is set to.

                    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
                    • E
                      Eli Kelly
                      last edited by Jun 18, 2014, 12:28 PM

                      Brilliant!

                      Editing the entries in Config.class.php fixed it. I also corrected the entries in .fogsettings. I ran the installer again. The database update ran and the logs look clean.

                      I was not able to determine how to apply the information from the blog link to my situation. At this point everything including MySQL appears to be working as expected. It is not clear that creating a symbolic link to a MySQL socket file will solve anything for me. The instructions are written for Ubuntu but if there is a pressing reason you advise this I will work through how to translate them for use with CentOS.

                      Thanks

                      Eli

                      1 Reply Last reply Reply Quote 0
                      • R
                        rhythmtone
                        last edited by Jun 18, 2014, 4:31 PM

                        Ubuntu 14.04 x64
                        FOG 1.1.0 -> 1.1.1

                        Hello,
                        I too am having this exact problem after upgrading to 1.1.1 - I have not had time to try a fresh installation yet. For testing purposes, I guess that would be the next step but it would be great to get the update to load on an existing FOG installation as well.

                        I have tried every possible combination of settings mentioned in this thread and tried the steps from the link to the MySQL.sock page, no success…

                        I have never fully understood the MySQL password thing with FOG, how it has 2 SQL passwords - one main one (for the database) and one for the storage, or I don’t know? I did set a MySQL database password and I have verified that it is correct at /var/www/fog/commons/ - config.php

                        I checked .fogsettings and this is what I had :
                        snmysqluser=“”
                        snmysqlpass=“some random password”
                        snmysqlhost=“”

                        I’ve tried removing .fogsettings and re-installing, doesn’t work. I’ve also tried every setting I can think of inside the .fogsettings file including :
                        snmysqluser=“fog”
                        snmysqluser=“root”
                        snmysqlhost=“127.0.0.1”
                        snmysqlhost=“10.10.10.10”
                        snmysqlpass=“old random .fogsettings password”
                        snmysqlpass=“new random .fogsettings password”
                        snmysqlpass=“SQL database password from /var/www/fog/commons/ - config.php”

                        None of these seem to work…

                        Is snmysql user supposed to be “fog”, “root”, or “” - I believe that it was “” in previous versions and that worked…?
                        Is snmysqlpass supposed to be the database password from /var/www/fog/commons - config.php ? Or a random password generated by the FOG installer?

                        Maybe I’m screwed because I didn’t document earlier random passwords generated by FOG? I know what I set the database password to during installation, but I’ve gone through several random passwords trying to get this to work…

                        Thanks for any help,
                        D.L.

                        1 Reply Last reply Reply Quote 0
                        • T
                          Tom Elliott
                          last edited by Jun 18, 2014, 4:36 PM

                          Please try latest SVN and update the /opt/fog/.fogsettings file to be relevant to your server.

                          Also, with the DB issues, I think I’ve figured out a whole bunch of things to try:
                          See this post:
                          [url]https://github.com/mastacontrola/fogproject/issues/1[/url]

                          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
                          • E
                            Eli Kelly
                            last edited by Jun 18, 2014, 4:43 PM

                            Rhythmtone- What worked for me was “root” for the user values and “localhost” for the host values. I didn’t set my SQL password so I set it to an empty string (“”). My guess is that it needs to be the one you picked for the SQL root user which is probably the one you entered in config.php

                            1 Reply Last reply Reply Quote 0
                            • R
                              rhythmtone
                              last edited by Jun 18, 2014, 4:44 PM

                              Thanks for the reply,
                              I have no idea how to use SVN, but I will look into that and figure it out.

                              Regarding the .fogsettings file, is there any documentation on how it should be set? Excuse my lack of knowledge, but I have no idea what the settings are actually supposed to be, I’m just guessing. I can guess what the host should be (127.0.0.1 or my actual IP) but I’m not sure what the snmysqluser or snmysqlpass is supposed to be…

                              Especially confusing is the snmysqlpass - is that supposed to be the database password that I set? Or a random one generated by the FOG installer/configuration?

                              Thank you,
                              D.L.

                              edit - Seen last post, will try… but I still don’t get the randomly-generated password thing, which seemed to be what worked in FOG 1.1.0…

                              1 Reply Last reply Reply Quote 0
                              • T
                                Tom Elliott
                                last edited by Jun 18, 2014, 4:46 PM

                                snmysqluser should be the fogstorage user on storagenodes: i.e.: StorageNodeMYSQLUSER or snmysqluser, if it’s not a node you can leave it blank OR make it root, either way it won’t hurt anything.
                                smysqlpass should be the fogstorage users password on storagenodes: i.e.: StorageNodeMYSQLPASS or snmysqlpass, if it’s not a node you should set this field to whatever the root password is set to OR if no password was set, leave it blank with two double quotes.

                                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
                                  rhythmtone
                                  last edited by Jun 18, 2014, 5:42 PM

                                  Thanks for the reply,
                                  I’m only doing a Normal installation for now, so I’m attempting with those settings…

                                  However the snmysqlpass field still doesn’t make sense to me - I went ahead and this to my SQL database password (that I set during initial installation) and re-ran the FOG installer and it overwrites it with a random password … so something seems wrong …

                                  If it were using the password that I put into snmysqlpass before installation/upgrade, then why does it overwrite it?

                                  Thanks,
                                  D.L.

                                  edit - fixed syntax mistakes…

                                  1 Reply Last reply Reply Quote 0
                                  • R
                                    rhythmtone
                                    last edited by Jun 18, 2014, 9:32 PM

                                    After a bunch of trial and error, I just reset the MySQL password with this command :

                                    sudo dpkg-reconfigure mysql-server-5.5

                                    I put this same password into .fogsettings under snmysqlpass, and also into config.php and re-ran the FOG installer.

                                    It overwrote my password in .fogsettings with yet another randomly-generated one (I still have no idea why or where this password is actually used) but after that everything worked great!

                                    I’m sure I just screwed something up along the way and/or entered the MySQL password incorrectly…

                                    Thanks for the help and advice, as always,
                                    D.L.

                                    P.S. - I did use snmysqluser=“root” and snmysqlhost=“localhost” - thanks for that info!

                                    1 Reply Last reply Reply Quote 0
                                    • T
                                      Tom Elliott
                                      last edited by Jun 18, 2014, 9:45 PM

                                      I’m aware of this bug, and it’s been fixed trunk, so next release you may have to reset values in .fogsettings one more time, but that should be it.

                                      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
                                      • M
                                        mlnancejr8808
                                        last edited by Jun 20, 2014, 1:23 PM

                                        I did the upgrade to 1.1.1 and it still saying that I am not on the latest version. Also, on the main login page for the WebGUI, instead of the cloud in the upper left hand corner saying FOG 1.1.1 it says FOG 1880. then under \var\www\fog\commons I don’t have a config.php file anymore.

                                        1 Reply Last reply Reply Quote 0
                                        • T
                                          Tom Elliott
                                          last edited by Jun 20, 2014, 1:49 PM

                                          [quote=“mlnancejr8808, post: 30934, member: 654”]I did the upgrade to 1.1.1 and it still saying that I am not on the latest version. Also, on the main login page for the WebGUI, instead of the cloud in the upper left hand corner saying FOG 1.1.1 it says FOG 1880. then under \var\www\fog\commons I don’t have a config.php file anymore.[/quote]

                                          Then you’re not running 1.1.1. You’re running SVN Version 1880.

                                          The config file for the SVN is now located in:
                                          /var/www/fog/lib/fog/Config.class.php

                                          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
                                          • 1
                                          • 2
                                          • 1 / 2
                                          1 / 2
                                          • First post
                                            7/32
                                            Last post

                                          197

                                          Online

                                          12.0k

                                          Users

                                          17.3k

                                          Topics

                                          155.2k

                                          Posts
                                          Copyright © 2012-2024 FOG Project