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

    FOG Install - sql failed

    Scheduled Pinned Locked Moved Solved
    FOG Problems
    5
    6
    2.4k
    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.
    • cotecC
      cotec
      last edited by cotec

      Hi,

      i installed an ubuntu 14.04 in a productive network and have installed fog_1.2.0.tar.gz.
      During installation sql-error occured and the installer can’t finish.
      I don’t know why its failing because is set up the same machine and used the same commands in an other network and already is fine…

      You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1
      160114
      
      initctl: Unknown job: mysql
      ...
      Setting up and starting MySql...Failed!
      Script sone, file is /var/fog/foginstall.log
      

      Here some details and logs:
      during installation: is this normal?0_1452761774756_fog-.JPG

      after failed installation:
      0_1452761794598_fog.JPG

      0_1452762053236_ERROR.LOG

      0_1452762065393_FOGINSTALL.LOG

      0_1452762286151_fog--.JPG

      Need help =(

      Thanks

      Regards,
      cotec

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

        How did change to the root environment? Make sure you use sudo su - (check the man page on what ‘-’ is for) or sudo -i

        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
        • cotecC
          cotec
          last edited by cotec

          solved, thanks @ CanHasDIY in ubuntuforums

          http://ubuntuforums.org/archive/index.php/t-1094853.html

          do following:
          sudo ./installfog.sh

          IMPORTANT: Use “sudo” always, regardless if u are root or “normal” fog user.

          Tom ElliottT 1 Reply Last reply Reply Quote 0
          • george1421G
            george1421 Moderator
            last edited by

            marking solved.

            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!

            1 Reply Last reply Reply Quote 0
            • Wayne WorkmanW
              Wayne Workman
              last edited by

              Just for future readers, if you install FOG 1.2.0 on Fedora 21, 22, 23, or CentOS 7, you’ll get a similar error.

              You’ll need to install mariadb and mariadb-server and php-mysqlnd instead of php-mysql.
              Then, you’ll need to change the commands for mysql service start to systemctl start mysql

              The only reason I know this is because @Tom-Elliott helped me with FOG 1.2.0 last night.

              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/

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

                @cotec sudo is not needed if you’re root, but it mainly depends on how you are in as root. For example, sudo su does not source the root environment which can leave other the paths in a strange status which could cause problems. sudo su - sources the environment but it is more appropriate to use sudo -i.

                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

                186

                Online

                12.0k

                Users

                17.3k

                Topics

                155.2k

                Posts
                Copyright © 2012-2024 FOG Project