FOG Project

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

    Fog Crashed this morning... When i try to connect => Database Schema Installer / Updater

    FOG Problems
    5
    10
    3050
    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
      raymondub last edited by

      Hi,
      i have a big problem… Yesterday before leaving from work, i ran an image and this morning i was checking the size of the file of the image on the web interface and it was written 0.
      So i checked the filesystem, it looks correct except the permissions on the files. For some images folder it was “fog” the owner (the one with size 0 if i m remember well) and other with root.
      So i ran this:
      chmod -R 777 /images
      chown -R root:root /images

      I went back on the web interface and i m redirected to the page:
      [url]http://xxxxx/fog/commons/schemaupdater/index.php?redir=1[/url]

      i tried to make the backup:
      root@ubufog:/opt/fog/utils# cd ~;mysqldump --allow-keywords -x -v fog > fogbackup.sql
      – Connecting to localhost…
      mysqldump: Got error: 2002: Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2) when trying to connect

      and i got also that message:
      fog Can’t get stat of ‘./fog’ (Errcode: 13)

      So I don t know what to do… New installation is maybe the only way BUT i need to keep all my images. Is it possible to restore them in a new installation ?

      For sure when it ll be working again, i ll run every day a backup like written in the wiki…

      thx…

      1 Reply Last reply Reply Quote 0
      • R
        Rich-C @Wayne Workman last edited by

        @Wayne-Workman Hint received. Just figured since I have an identical issue that I’d keep it all within a single thread.

        1 Reply Last reply Reply Quote 0
        • Wayne Workman
          Wayne Workman @Rich-C last edited by

          @Rich-C Or you could fix it, and ask for help with doing that in a new thread. 😉

          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/

          R 1 Reply Last reply Reply Quote 0
          • Q
            Quazz Moderator @Rich-C last edited by

            @Rich-C Assuming you have a good copy of your images and your database you can basically reinstall your OS, install FOG, put the images back, then restore the database and everything is the way it should be.

            1 Reply Last reply Reply Quote 1
            • R
              Rich-C @raymondub last edited by

              @raymondub I realize that this topic is very old but in theory this SHOULD work…has anyone confirmed this as a viable solution to recovering from a server failure if you have a good copy of your images?

              Q Wayne Workman 2 Replies Last reply Reply Quote 0
              • R
                raymondub last edited by

                well thank for your advice but i didn t work…
                I made a very bad manipulation… I wanted to change the ownership and rights just on /images but it s seems that i forgot to write images and thus all the rights have been changed on the whole filesystem.
                So i tried to capture ownerships and rights from my other serveur to overwrite on this one.
                Scratch fog installation by remove all php* and mysql* package
                Reinstall fog
                install some missing php package
                and… it s working again…
                But my server is like “cheese” with too many permissions…
                But at least i can take a backup and put it on a new server…
                🙂

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

                  Or,

                  Follow the instructions found here:

                  [url]https://github.com/fogproject/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
                  • R
                    raymondub last edited by

                    what if:

                    1. i make a NEW installation
                    2. i create image with the same name of on my prod installation except that to make it quicker, i ll capture image of small vm windows 7
                    3. I replace the images folder on the new server with the “old” image server
                      Will it work ?
                      I don t care of the existing mac address, hostname,… I just need to get back my images working
                    R 1 Reply Last reply Reply Quote 0
                    • R
                      raymondub last edited by

                      nothing about today…

                      root@ubufog:~# vi /var/log/apache2/error.log

                      [Sun Mar 08 07:46:03 2015] [notice] Apache/2.2.22 (Ubuntu) PHP/5.3.10-1ubuntu3.16 with Suhosin-Patch configured – resuming normal operations
                      [Mon Mar 09 11:22:21 2015] [error] [client xxxx] File does not exist: /var/www/favicon.ico
                      [Mon Mar 09 11:22:21 2015] [error] [client xxxx] File does not exist: /var/www/favicon.ico
                      [Mon Mar 09 11:24:00 2015] [error] [client xxxx] File does not exist: /var/www/fog/images, referer: [url]http://zzzzz/fog/management/css/fog.css[/url]
                      [Mon Mar 09 11:44:31 2015] [error] [client xxxx] File does not exist: /var/www/fog/images, referer: [url]http://zzzzz/fog/management/css/fog.css[/url]
                      [Mon Mar 09 15:51:40 2015] [error] [client eeee] File does not exist: /var/www/favicon.ico
                      [Mon Mar 09 15:51:41 2015] [error] [client eeee] File does not exist: /var/www/favicon.ico
                      [Mon Mar 09 16:22:12 2015] [error] [client eeee] File does not exist: /var/www/favicon.ico
                      [Mon Mar 09 16:22:12 2015] [error] [client eeee] File does not exist: /var/www/favicon.ico
                      [Mon Mar 09 16:52:36 2015] [error] [client xxxx] File does not exist: /var/www/favicon.ico
                      [Tue Mar 10 10:00:09 2015] [error] [client eeee] PHP Warning: array_filter() expects parameter 1 to be array, null given in /var/www/fog/lib/pages/GroupManagementPage.class.php on line 252, referer: [url]http://zzzzz/fog/management/index.php?node=group&sub=add[/url]
                      [Wed Mar 11 10:49:24 2015] [error] [client eeee] File does not exist: /var/www/fog/management/css/images/ui-bg_highlight-soft_75_cccccc_1x100.png, referer: [url]http://zzzzz/fog/management/css/jquery-ui.css[/url]
                      [Wed Mar 11 10:49:24 2015] [error] [client eeee] File does not exist: /var/www/fog/management/css/images/ui-bg_glass_75_e6e6e6_1x400.png, referer: [url]http://zzzzz/fog/management/css/jquery-ui.css[/url]
                      [Wed Mar 11 10:49:24 2015] [error] [client eeee] File does not exist: /var/www/fog/management/css/images/ui-bg_flat_75_ffffff_40x100.png, referer: [url]http://zzzzz/fog/management/css/jquery-ui.css[/url]
                      [Wed Mar 11 10:49:58 2015] [error] [client eeee] File does not exist: /var/www/fog/management/css/images/ui-bg_highlight-soft_75_cccccc_1x100.png, referer: [url]http://zzzzz/fog/management/css/jquery-ui.css[/url]

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

                        root@ubufog:~# vi /var/log/mysql/error.log
                        150312 8:40:39 [ERROR] /usr/sbin/mysqld: Can’t find file: ‘./fog/groupMembersTemp.frm’ (errno: 13)
                        150312 8:40:39 [ERROR] /usr/sbin/mysqld: Can’t find file: ‘./fog/groupMembersTemp.frm’ (errno: 13)
                        150312 8:41:03 [ERROR] /usr/sbin/mysqld: Can’t find file: ‘./fog/groupMembersTemp.frm’ (errno: 13)
                        150312 8:41:03 [ERROR] /usr/sbin/mysqld: Can’t find file: ‘./fog/groupMembersTemp.frm’ (errno: 13)
                        150312 8:41:18 [Note] /usr/sbin/mysqld: Normal shutdown

                        150312 8:41:18 [Note] Event Scheduler: Purging the queue. 0 events
                        150312 8:41:20 [Warning] /usr/sbin/mysqld: Forcing close of thread 9147 user: ‘root’

                        150312 8:41:20 [Warning] /usr/sbin/mysqld: Forcing close of thread 2 user: ‘root’

                        150312 8:41:20 [Warning] /usr/sbin/mysqld: Forcing close of thread 1 user: ‘root’

                        150312 8:41:20 InnoDB: Starting shutdown…
                        150312 8:41:21 InnoDB: Shutdown completed; log sequence number 1773129
                        150312 8:41:22 [Note] /usr/sbin/mysqld: Shutdown complete

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

                        249
                        Online

                        10.2k
                        Users

                        16.3k
                        Topics

                        149.9k
                        Posts

                        Copyright © 2012-2020 FOG Project