FOG Project

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

    Solved The following errors occured --Database Error IN FOG

    FOG Problems
    2
    8
    1678
    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.
    • B
      BasavarajC last edited by

      Database Schema Installer / UpdaterUpdate/Install Failed!

      The following errors occured
      Update ID: 1 - 0

      Database Error:

      Database SQL:

      CREATE DATABASE fog


      Update ID: 1 - 1

      Database Error:

      Database SQL:

      CREATE TABLE fog.groupMembers (
      gmID int(11) NOT NULL auto_increment,
      gmHostID int(11) NOT NULL,
      gmGroupID int(11) NOT NULL,
      PRIMARY KEY (gmID),
      KEY new_index (gmHostID),
      KEY new_index1 (gmGroupID)
      ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC


      Update ID: 1 - 2

      Database Error:

      Database SQL:

      CREATE TABLE fog.groups (
      groupID int(11) NOT NULL auto_increment,
      groupName varchar(50) NOT NULL,
      groupDesc longtext NOT NULL,
      groupDateTime datetime NOT NULL,
      groupCreateBy varchar(50) NOT NULL,
      groupBuilding int(11) NOT NULL,
      PRIMARY KEY (groupID),
      KEY new_index (groupName)
      ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1

      aboushard, 1 minute ago Edit Report

      #1

      1 2
      
      1 Reply Last reply Reply Quote 0
      • S
        Sebastian Roth Moderator last edited by

        Please try restarting the mysql service with this command: sudo service mysql restart and see if you can run the Database Update on the web interface directly after 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
        • B
          BasavarajC @Sebastian Roth last edited by

          @Sebastian-Roth
          Dear Sir,
          Thanking you for giving me reply, Thank you Sir…

          I am trying over here To make a Success , But Some Trouble I am Facing about Editing of ‘ROOT’ , ‘PasswordIfYouHaveOne’, ‘Localhost’ in /opt/fog/.fogsettings

          I have opened this file using gedit /var/www/fog/lib/fog/Config.class.php

          It is showing programs like script, So I did not understand that What to check in this file and what to select in this file.

          Please Do help STEP BY STEP, Sincerely it’s my gratitude to you Sir.

          Thanking you,
          Basavaraj

          1 Reply Last reply Reply Quote 0
          • S
            Sebastian Roth Moderator last edited by

            @BasavarajC Did you get this solved? Please let us know.

            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

            B 1 Reply Last reply Reply Quote 0
            • S
              Sebastian Roth Moderator last edited by

              You are welcome! Thanks for the details. Please take a look at this guide and follow the steps to see what your database is up to: https://wiki.fogproject.org/wiki/index.php/Troubleshoot_MySQL

              As well you might want to check this out: https://github.com/fogproject/fogproject/issues/1

              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
              • B
                BasavarajC last edited by

                Dear Sir,
                I am heartily Thankful to you for giving me immediate Reply. Here I am trying to install Fog On My Ubuntu Desktop Edition. Installation Process Completed Successfully. But When I put Link On Browser, It Showed The Previous Error.

                My System Configuration is as below

                Is this a new install or upgrade?
                YES , This is New Installation On Ubuntu 14.04.3 LTS i686 i686 i686 GNU/Linux
                ( First Time I am Trying this FOG Software On Ubuntu Computer and After Watching Many Videos On YOUTUB Site)

                Which version are you trying to install?
                Downloaded the FOG SOFTWARE From This https://sourceforge.net/projects/freeghost/files/latest/download
                Version is fog_1.2.0.tar.gz

                What system/OS on?
                root@vivekanand:~# sudo lsb_release -a
                No LSB modules are available.
                Distributor ID: Ubuntu
                Description: Ubuntu 14.04.3 LTS
                Release: 14.04
                Codename: trusty

                root@vivekanand:~# uname -a
                Linux vivekanand 3.19.0-25-generic #26~14.04.1-Ubuntu SMP Fri Jul 24 21:18:00 UTC 2015 i686 i686 i686 GNU/Linux

                1 Reply Last reply Reply Quote 0
                • B
                  BasavarajC last edited by

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

                    Is this a new install or upgrade? Which version are you trying to install? What system/OS on?

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

                    253
                    Online

                    10.2k
                    Users

                    16.3k
                    Topics

                    149.9k
                    Posts

                    Copyright © 2012-2020 FOG Project