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

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

    Scheduled Pinned Locked Moved
    FOG Problems
    5
    10
    3.2k
    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
        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
        • 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

            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
            • Tom ElliottT
              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

                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
                • 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 WorkmanW 2 Replies 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
                    • Wayne WorkmanW
                      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
                      • 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
                        • 1 / 1
                        • First post
                          Last post

                        161

                        Online

                        11.7k

                        Users

                        17.2k

                        Topics

                        154.7k

                        Posts
                        Copyright © 2012-2024 FOG Project