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

    Fog Trunk Git 7645 update fails at SQL

    Scheduled Pinned Locked Moved Solved
    FOG Problems
    4
    18
    3.5k
    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.
    • Tom ElliottT
      Tom Elliott
      last edited by

      Please pull in the latest and reinstall.

      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

      fry_pF 1 Reply Last reply Reply Quote 0
      • fry_pF
        fry_p Moderator @Tom Elliott
        last edited by

        @Tom-Elliott I am actually using a script that checks for the latest and installs. To my knowledge, this is the latest. Please see below for my script:

        echo *MYPASSWORD* | sudo -S apt-get update -y
        sudo -S apt-get upgrade -y
        
        
        sudo cp /opt/fog/service/etc/config.php /home/fogadmin/fogInstalls # config file
        sudo cp /etc/exports /home/fogadmin/fogInstalls/exports # Exports file
        sudo cp /var/www/html/fog/service/ipxe/bzImage /home/fogadmin/fogInstalls # 64 bit kernel
        sudo cp /var/www/html/fog/service/ipxe/bzImage32 /home/fogadmin/fogInstalls # 32 bit kernel
        sudo cp /var/www/html/fog/service/ipxe/bg.png /home/fogadmin/fogInstalls # custom background
        mysqldump -u root --all-databases --events > all-Databases-backup.sql # database backup
        
        cd /home/fogadmin/fogInstalls
        time_stamp=$(date +%Y_%m_%d_%H_%M_%S)
        mkdir ${time_stamp}
        cd ${time_stamp}
        
        
        sudo svn checkout https://svn.code.sf.net/p/freeghost/code/trunk
        sudo chown -R fog /home/fogadmin/fogInstalls
        sudo chgrp -R fog /home/fogadmin/fogInstalls
        sudo chmod -R 777 /home/fogadmin/fogInstalls
        
        cd ${PWD}/trunk/bin
        sudo yes | ${PWD}/installfog.sh
        wget -O - --post-data=“confirm=yes” “http://${FOGWEBIP}/commons/schemaupdater/index.php” 2>/dev/null
        
        
        #sudo rm /opt/fog/service/etc/config.php
        #sudo cp /home/fog/fogInstalls/config.php /opt/fog/service/etc
        #sudo rm /home/fog/fogInstalls/bzImage && sudo rm /home/fog/fogInstalls/bzImage32
        #sudo cp /home/fog/fogInstalls/bzImage /var/www/html/fog/service/ipxe
        #sudo cp /home/fog/fogInstalls/bzImage32 /var/www/html/fog/service/ipxe
        #sudo cp /home/fog/fogInstalls/bg.png /var/www/html/fog/service/ipxe
        #sudo cp /tftpboot/undionly.kpxe /tftpboot/undionly.kpxe.original && mv /tftpboot/undionly.kpxe /tftpboot/undionly.0
        #sudo cp /tftpboot/undionly.0 /var/www/html/fog/service/ipxe/undionly.0
        
        sudo chown -R fog /var/www/html/fog
        sudo chgrp -R fog /var/www/html/fog
        sudo chmod -R 775 /var/www/html/fog
        sudo chown -R fog /images
        sudo chgrp -R fog /images
        sudo chmod -R 775 /images
        
        
        
        sudo /etc/init.d/apache2 restart
        sudo service mysql restart
        sudo service tftpd-hpa restart
        

        Please let me know if you see anything wrong with it.

        Like open source community computing? Why not do it for a good cause?
        Use your computer/server for humanitarian projects when it is idle!
        https://join.worldcommunitygrid.org?recruiterId=1026912

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

          @fry_p The sudo yes | installfog.sh isn’t necessary. You can just pass it the -y option now. So it could be ${PWD}/installfog.sh -y

          I don’t understand why all the work though.

          The files look like they should be updated, but if your cloud is still showing 7645 while the actual version is now 7671, it would seem something somewhere isn’t working. Maybe you edited one of the files and the svn checkout isn’t completing updating because of that issue?

          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

          fry_pF 2 Replies Last reply Reply Quote 0
          • fry_pF
            fry_p Moderator @Tom Elliott
            last edited by

            @Tom-Elliott Thanks for the tip. I only have a script so it can run automatically at 3 am every morning to stay up to date. Even without using the script I am failing at the same point. Would apache logs help? I don’t touch anything outside the script when it comes to updating.

            Like open source community computing? Why not do it for a good cause?
            Use your computer/server for humanitarian projects when it is idle!
            https://join.worldcommunitygrid.org?recruiterId=1026912

            1 Reply Last reply Reply Quote 0
            • fry_pF
              fry_p Moderator @Tom Elliott
              last edited by

              @Tom-Elliott This is what I’m getting when I manually try to update mysql-server:

              Fogadmin@FOGTEST:~$ sudo apt-get install mysql-server
              [sudo] password for fogadmin: 
              Reading package lists... Done
              Building dependency tree       
              Reading state information... Done
              Some packages could not be installed. This may mean that you have
              requested an impossible situation or if you are using the unstable
              distribution that some required packages have not yet been created
              or been moved out of Incoming.
              The following information may help to resolve the situation:
              
              The following packages have unmet dependencies:
               mysql-server : Depends: mysql-server-5.5 but it is not going to be installed
              E: Unable to correct problems, you have held broken packages.
              

              This may be an Ubuntu issue and not Fog I’m thinking?

              Like open source community computing? Why not do it for a good cause?
              Use your computer/server for humanitarian projects when it is idle!
              https://join.worldcommunitygrid.org?recruiterId=1026912

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

                @fry_p I’d agree but what happens if you run sudo apt-get dist-upgrade --force

                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

                fry_pF 1 Reply Last reply Reply Quote 0
                • fry_pF
                  fry_p Moderator @Tom Elliott
                  last edited by

                  @Tom-Elliott This is what I get, syntax I think

                  fogadmin@FOGTEST:~$ sudo apt-get dist-upgrade --force
                  E: Command line option --force is not understood
                  fogadmin@FOGTEST:~$ 
                  

                  Without --force

                  
                  The following packages were automatically installed and are no longer required:
                    liblua5.1-0 libntdb1 linux-headers-4.2.0-27 linux-headers-4.2.0-27-generic
                    linux-image-4.2.0-27-generic linux-image-extra-4.2.0-27-generic python-ntdb
                  Use 'apt-get autoremove' to remove them.
                  0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
                  

                  Like open source community computing? Why not do it for a good cause?
                  Use your computer/server for humanitarian projects when it is idle!
                  https://join.worldcommunitygrid.org?recruiterId=1026912

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

                    @fry_p said:

                    mysql-server : Depends: mysql-server-5.5 but it is not going to be installed
                    

                    Guess you somehow managed to install a later version of the mysql client package which is blocking the mysql server version 5.5 now. Please try this:

                    sudo apt-get purge mysql-client-core-5.6
                    sudo apt-get autoremove
                    sudo apt-get autoclean
                    sudo apt-get install mysql-client-core-5.5
                    sudo apt-get install mysql-server
                    

                    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

                    fry_pF 1 Reply Last reply Reply Quote 0
                    • fry_pF
                      fry_p Moderator @Sebastian Roth
                      last edited by

                      @Sebastian-Roth I got this after entering the 1st command (purge):

                      fogadmin@FOGTEST:~$ sudo apt-get purge mysql-client-core-5.6
                      [sudo] password for fogadmin: 
                      Reading package lists... Done
                      Building dependency tree       
                      Reading state information... Done
                      Package 'mysql-client-core-5.6' is not installed, so not removed
                      

                      I tried the rest of the commands and they seemed to go through.
                      I somehow really borked this but I didn’t do anything out of the ordinary. I just ran the script and it failed at SQL again.

                      Like open source community computing? Why not do it for a good cause?
                      Use your computer/server for humanitarian projects when it is idle!
                      https://join.worldcommunitygrid.org?recruiterId=1026912

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

                        @fry_p Can you try:

                        sudo apt-get purge mysql-server* mysql-client*

                        It will remove all database application software, but the db should remain under /var/lib/mysql.

                        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
                        • S
                          Sebastian Roth Moderator
                          last edited by Sebastian Roth

                          dpkg -l | grep -e mysql -e maria …?

                          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

                          fry_pF 1 Reply Last reply Reply Quote 0
                          • fry_pF
                            fry_p Moderator @Sebastian Roth
                            last edited by fry_p

                            @Sebastian-Roth I ran

                            sudo apt-get purge mysql-server* mysql-client*
                            

                            at Tom’s suggestion then ran

                            sudo apt-get autoremove
                            

                            Ran my script once again and it worked, I’m now on 7695.

                            Thanks guys!
                            (P.S. If anyone is interested in my script, I just took a script I found and modified it to my liking and use cron to run it every night)

                            Like open source community computing? Why not do it for a good cause?
                            Use your computer/server for humanitarian projects when it is idle!
                            https://join.worldcommunitygrid.org?recruiterId=1026912

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

                              @fry_p Great to hear that you got things fixed and are back up running! 🙂

                              Personally I am not that fond of the idea of automatically upgrading every night. FOG trunk is under development and quite often we break things. It’s great for us as you will always be the first to find an issue and post in the forums. But you might find yourself being annoyed by this as well. Don’t get me wrong. You are more than welcome and we really appreciate people testing the very latest!!! I just hope you don’t get frustrated.

                              You’ll get to know FOG and how to debug and fix things very fast if you are going this way - that’s for sure. So there is a great opportunity in keeping up with the latest version as well. As I said most welcome! 🙂

                              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

                              fry_pF 1 Reply Last reply Reply Quote 0
                              • fry_pF
                                fry_p Moderator @Sebastian Roth
                                last edited by

                                @Sebastian-Roth For the sake of downtime, I am probably going to slow down the update rate, but I do enjoy helping the evolution of FOG. I was properly warned of the risks before I moved to Trunk, but being on the forefront is pretty cool. I guess I could be considered a tester of sorts. The performance jump from 1.2 to Trunk is also astounding. I am getting insane upload and download speeds without having changed any network equipment! Plus, my knowledge of Linux prior to being in charge of my FOG installation was 0. Now I can cruise through basic terminal work and scripting. Good Stuff!

                                Like open source community computing? Why not do it for a good cause?
                                Use your computer/server for humanitarian projects when it is idle!
                                https://join.worldcommunitygrid.org?recruiterId=1026912

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

                                  @fry_p said:

                                  I guess I could be considered a tester of sorts.

                                  You definitely are. @Moderators Can anyone please tag him as a tester!

                                  The performance jump from 1.2 to Trunk is also astounding. I am getting insane upload and download speeds without having changed any network equipment!

                                  That’s kind of odd from my point of view as the tools used to do the actual up- and download (udp-sender for multicast download and NFS for upload and unicast download) haven’t changed much in a while!

                                  Plus, my knowledge of Linux prior to being in charge of my FOG installation was 0. Now I can cruise through basic terminal work and scripting. Good Stuff!

                                  Absolutely great. I think FOG has pushed quite a few people to look into linux and get their hands dirty. That’s amazing and I love to see it!

                                  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

                                  Tom ElliottT JunkhackerJ 2 Replies Last reply Reply Quote 0
                                  • Tom ElliottT
                                    Tom Elliott @Sebastian Roth
                                    last edited by

                                    @Sebastian-Roth Added to testers.

                                    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
                                    • JunkhackerJ
                                      Junkhacker Developer @Sebastian Roth
                                      last edited by

                                      @Sebastian-Roth

                                      That’s kind of odd from my point of view as the tools used to do the actual up- and download (udp-sender for multicast download and NFS for upload and unicast download) haven’t changed much in a while!

                                      we’ve made changes to how compression/decompression is handled to better utilize the processing power available

                                      signature:
                                      Junkhacker
                                      We are here to help you. If you are unresponsive to our questions, don't expect us to be responsive to yours.

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

                                      165

                                      Online

                                      12.0k

                                      Users

                                      17.3k

                                      Topics

                                      155.2k

                                      Posts
                                      Copyright © 2012-2024 FOG Project