• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • 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.3k
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 Mar 12, 2015, 8:11 AM

    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 Mar 12, 2015, 8:30 AM

      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 Mar 12, 2015, 8:33 AM

        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 Mar 12, 2015, 8:37 AM

          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 May 30, 2016, 5:12 PM Reply Quote 0
          • T
            Tom Elliott
            last edited by Mar 12, 2015, 9:40 AM

            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 Mar 13, 2015, 8:20 AM

              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 May 30, 2016, 5:12 PM

                @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 W 2 Replies Last reply May 30, 2016, 6:14 PM Reply Quote 0
                • Q
                  Quazz Moderator @Rich-C
                  last edited by May 30, 2016, 6:14 PM

                  @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
                  • W
                    Wayne Workman @Rich-C
                    last edited by May 31, 2016, 6:25 PM

                    @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 Jun 3, 2016, 6:08 PM Reply Quote 0
                    • R
                      Rich-C @Wayne Workman
                      last edited by Jun 3, 2016, 6:08 PM

                      @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

                      193

                      Online

                      12.0k

                      Users

                      17.3k

                      Topics

                      155.2k

                      Posts
                      Copyright © 2012-2024 FOG Project