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

    Problem updating fog: Backing up Database ... failed

    Scheduled Pinned Locked Moved Solved
    FOG Problems
    4
    28
    9.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.
    • S
      Sebastian Roth Moderator
      last edited by

      @K-Hays What do you see in the last 20 lines of the install logs (/path/to/checked/out/fogproject/bin/error_log/…)??

      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

      K 2 Replies Last reply Reply Quote 1
      • K
        K.Hays @Sebastian Roth
        last edited by K.Hays

        @Sebastian-Roth

        The script you are attempting to invoke has been converted to an Upstart
        job, but lsb-header is not supported for Upstart jobs.
        insserv: warning: script 'friendly-recovery' missing LSB tags and overrides
        insserv: Default-Start undefined, assuming empty start runlevel(s) for script `friendly-recovery'
        insserv: Default-Stop  undefined, assuming empty stop  runlevel(s) for script `friendly-recovery'
        The script you are attempting to invoke has been converted to an Upstart
        job, but lsb-header is not supported for Upstart jobs.
        insserv: warning: script 'cron' missing LSB tags and overrides
        insserv: Default-Start undefined, assuming empty start runlevel(s) for script `cron'
        insserv: Default-Stop  undefined, assuming empty stop  runlevel(s) for script `cron'
         * Starting FOG Computer Imaging Solution: FOGMulticastManager
           ...fail!
         * Starting FOG Computer Imaging Solution: FOGImageReplicator
           ...fail!
         * Starting FOG Computer Imaging Solution: FOGSnapinReplicator
           ...fail!
         * Starting FOG Computer Imaging Solution: FOGScheduler
           ...fail!
         * Starting FOG Computer Imaging Solution: FOGPingHosts
           ...fail!
         * Stopping NFS kernel daemon
           ...done.
         * Unexporting directories for NFS kernel daemon...
           ...done.
         * Exporting directories for NFS kernel daemon...
           ...done.
         * Starting NFS kernel daemon
           ...done.
        

        This is the other error log. There is two, one for the new version which i posted below, and one for the old version which is posted here.

        1 Reply Last reply Reply Quote 0
        • K
          K.Hays @Sebastian Roth
          last edited by

          @Sebastian-Roth Im currently on Version 7084, and was trying to upgrade to 1.3.0-RC-8.

          Q 1 Reply Last reply Reply Quote 0
          • Q
            Quazz Moderator @K.Hays
            last edited by

            @K.Hays Could you post your /opt/fog/.fogsettings file here?

            K 2 Replies Last reply Reply Quote 1
            • K
              K.Hays @Quazz
              last edited by

              This post is deleted!
              1 Reply Last reply Reply Quote 0
              • K
                K.Hays @Quazz
                last edited by

                This post is deleted!
                1 Reply Last reply Reply Quote 0
                • S
                  Sebastian Roth Moderator
                  last edited by

                  @K-Hays Sorry for the delay. I am preparing to move house these days and don’t get much time for FOG stuff…

                  Sorry didn’t see that you already posted this:

                  ln: failed to create symbolic link ‘/var/www/fog/fog’: File exists
                  ...
                  --2016-08-12 14:22:17--  http://10.40.0.7//fog//maintenance/backup_db.php
                  Connecting to 10.40.0.7:80... connected.
                  HTTP request sent, awaiting response... 500 Internal Server Error
                  2016-08-12 14:22:17 ERROR 500: Internal Server Error.
                  

                  Maybe something went wrong with those links. If you don’t have any modifications (kernels, initrds or whatever) within /var/www/ then I’d ask you to completely delete those and re-run the installer. See what you have in that directory, possibly there is /var/www/html/fog and /var/www/fog…

                  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

                  K 1 Reply Last reply Reply Quote 1
                  • K
                    K.Hays @Sebastian Roth
                    last edited by

                    @Sebastian-Roth That got me further! But when i got to the Updating database schema there is no update option on the web page.

                    Wayne WorkmanW 1 Reply Last reply Reply Quote 0
                    • Wayne WorkmanW
                      Wayne Workman @K.Hays
                      last edited by Wayne Workman

                      @K.Hays I suspect db issues. Try to connect to the DB, use the credentials in your .fogsettings file.

                      mysql -u fog -h fog -pfoggy -D fog
                      Note that no space between -p and foggy is intentional.

                      The snmysqlhost being set to fog is suspicious… normally this is left blank, is set to localhost or 127.0.0.1 for the main server.

                      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!
                      Daily Clean Installation Results:
                      https://fogtesting.fogproject.us/
                      FOG Reporting:
                      https://fog-external-reporting-results.fogproject.us/

                      K 1 Reply Last reply Reply Quote 1
                      • K
                        K.Hays @Wayne Workman
                        last edited by

                        @Wayne-Workman it said unknown host

                        Wayne WorkmanW 1 Reply Last reply Reply Quote 0
                        • Wayne WorkmanW
                          Wayne Workman @K.Hays
                          last edited by

                          @K.Hays Now try mysql -u fog -pfoggy -D fog

                          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!
                          Daily Clean Installation Results:
                          https://fogtesting.fogproject.us/
                          FOG Reporting:
                          https://fog-external-reporting-results.fogproject.us/

                          K 1 Reply Last reply Reply Quote 1
                          • K
                            K.Hays @Wayne Workman
                            last edited by

                            @Wayne-Workman Access denied for user ‘fog’@‘localhost’ (using password: YES)
                            d430@

                            Wayne WorkmanW 1 Reply Last reply Reply Quote 0
                            • Wayne WorkmanW
                              Wayne Workman @K.Hays
                              last edited by

                              @K.Hays Ok, now try mysql -u root -D fog

                              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!
                              Daily Clean Installation Results:
                              https://fogtesting.fogproject.us/
                              FOG Reporting:
                              https://fog-external-reporting-results.fogproject.us/

                              K 1 Reply Last reply Reply Quote 1
                              • K
                                K.Hays @Wayne Workman
                                last edited by K.Hays

                                @Wayne-Workman that worked, as in it let me in mysql

                                Wayne WorkmanW 1 Reply Last reply Reply Quote 0
                                • Wayne WorkmanW
                                  Wayne Workman @K.Hays
                                  last edited by Wayne Workman

                                  @K.Hays Ok. then inside of /opt/fog/.fogsettings set snmysqluser to root, and blank out snmysqlpass and snmysqlhost, re-run the installer, and you should be good to go.

                                  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!
                                  Daily Clean Installation Results:
                                  https://fogtesting.fogproject.us/
                                  FOG Reporting:
                                  https://fog-external-reporting-results.fogproject.us/

                                  K 1 Reply Last reply Reply Quote 1
                                  • K
                                    K.Hays @Wayne Workman
                                    last edited by

                                    @Wayne-Workman That worked! Any idea to what caused this whole thing? Im going to have to update my other servers, and obviously this one in the future and would like to avoid this whole ordeal again haha

                                    Wayne WorkmanW 1 Reply Last reply Reply Quote 0
                                    • Wayne WorkmanW
                                      Wayne Workman @K.Hays
                                      last edited by

                                      @K.Hays said in Problem updating fog: Backing up Database ... failed:

                                      Any idea to what caused this whole thing?

                                      Somebody messed with the .fogsettings file and put in the wrong information. If things in there are wrong and you update - things in fog will be wrong.

                                      For you and future readers, information on the .fogsettings file and passwords are in these two articles:
                                      https://wiki.fogproject.org/wiki/index.php?title=.fogsettings
                                      https://wiki.fogproject.org/wiki/index.php?title=Password_Central

                                      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!
                                      Daily Clean Installation Results:
                                      https://fogtesting.fogproject.us/
                                      FOG Reporting:
                                      https://fog-external-reporting-results.fogproject.us/

                                      K 1 Reply Last reply Reply Quote 2
                                      • K
                                        K.Hays @Wayne Workman
                                        last edited by

                                        @Wayne-Workman Ok ill be sure to look for that in the future. Thanks to everyone who helped! Ill be sure too update frequently now haha

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

                                        162

                                        Online

                                        12.1k

                                        Users

                                        17.3k

                                        Topics

                                        155.3k

                                        Posts
                                        Copyright © 2012-2024 FOG Project