FOG Project

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

    Repeatedly being prompted to update database schema and then receiving errors on v110

    FOG Problems
    4
    9
    2515
    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.
    • M
      Magnus_CA last edited by

      HI fogsters,

      I was having an issue with my fog v1.0.1 server and after a bit of unsuccessful troubleshooting and noticing v1.1.0 had dropped I decided to do a clean install (Ubuntu 14.04 LTS).

      The install went fine and I was able to pull an issue from my client computer with no issues but now I’m being repeatedly prompted to update my database schema despite doing so successfully when asked during the fog server install. When I click the button to update the schema (again) I get an ‘Update/Install Failed’ message.

      I attached a copy of my install log and a copy of the error log I received.

      Can anyone point me to how to resolve this?

      Thanks in advance for the help!

      [url=“/_imported_xf_attachments/0/928_FOG 1.1.0 Database Schema Installer _ Updater.txt?:”]FOG 1.1.0 Database Schema Installer _ Updater.txt[/url][url=“/_imported_xf_attachments/0/929_v110_foginstall.txt?:”]v110_foginstall.txt[/url]

      1 Reply Last reply Reply Quote 0
      • A
        Andy Abplanalp Developer last edited by

        Just to update this thread - I don’t know if this was an issue just for a short while after reboot but it seems to have cleared up (although I haven’t been making any changes to the DB). I also added “service mysql restart” to the /etc/rc.local file.

        1 Reply Last reply Reply Quote 0
        • A
          Andy Abplanalp Developer last edited by

          Tom -

          Fresh install of 1.1.0
          New install of Ubuntu 13.10 Serverx64
          MySQL 5.5.32-0ubuntu7
          AMD880 chipset, AMD hex core CPU, 16GB RAM

          When I make changes to snapins, groups, etc., I’m sporadically being asked to update the database schema and a “service mysql restart” will allow me to log in again.

          Andy

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

            I’d recommend Debian 7.5, Ubuntu 10 thru 13, Centos 6.5.

            Either of these I haven’t heard or seen anything major.

            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
            • M
              Magnus_CA last edited by

              [quote=“Wolfbane8653, post: 29564, member: 3362”]Ubuntu 14.04 LTS is having serious issues with mysql. At this time it is[B] not recommended[/B] by anyone here to have your fog installation on Ubuntu 14.04.[/quote]

              That’s great. I’ve lost count of how many times I’ve re-installed my linux server. What do you recommend for the most headache free fog experience? The latest version of Debian (I’d want to install a desktop environment)? Ubuntu 13.10?

              I don’t need a bleeding edge Linux OS…just a stable environment for using fog.

              1 Reply Last reply Reply Quote 0
              • M
                Magnus_CA last edited by

                [quote=“Tom Elliott, post: 29566, member: 7271”]All those having mysql problems on 14.04, what is the RAM amount on your systems?

                What’s the mysql version installed?

                [URL=‘https://bugs.launchpad.net/ubuntu/+source/mysql-5.6/+bug/1312936’]https://bugs.launchpad.net/ubuntu/ source/mysql-5.6/ bug/1312936[/URL][/quote]

                I have 4GB of RAM and running mysql v5.5.37.

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

                  All those having mysql problems on 14.04, what is the RAM amount on your systems?

                  What’s the mysql version installed?

                  [url]https://bugs.launchpad.net/ubuntu/+source/mysql-5.6/+bug/1312936[/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
                  • W
                    Wolfbane8653 Developer last edited by

                    Ubuntu 14.04 LTS is having serious issues with mysql. At this time it is[B] not recommended[/B] by anyone here to have your fog installation on Ubuntu 14.04.

                    1 Reply Last reply Reply Quote 0
                    • M
                      Magnus_CA last edited by

                      Update - restarting the mysql service and then clicking install/upgrade seems to have fixed the problem. It reported no upgrade was necessary and I’m no longer being prompted. Hope it doesn’t return.

                      Thanks.

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

                      170
                      Online

                      10.2k
                      Users

                      16.3k
                      Topics

                      149.9k
                      Posts

                      Copyright © 2012-2020 FOG Project