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

    Solved Fog Trunk Git 7645 update fails at SQL

    FOG Problems
    4
    18
    3172
    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.
    • fry_p
      fry_p Moderator last edited by fry_p

      Hi Guys,
      Please see the error below:

      	apache2 php5 php5-json php5-gd php5-cli php5-curl mysql-server mysql-client tftpd-hpa tftp-hpa nfs-kernel-server vsftpd net-tools wget xinetd sysv-rc-conf tar gzip build-essential cpp gcc g++ m4 htmldoc lftp openssh-server php-gettext php5-mcrypt php5-mysqlnd curl libc6 libcurl3 zlib1g php5-fpm libapache2-mod-php5
      
      
       * Skipping package: apache2...................................(Already Installed)
       * Skipping package: php5......................................(Already Installed)
       * Skipping package: php5-json.................................(Already Installed)
       * Skipping package: php5-gd...................................(Already Installed)
       * Skipping package: php5-cli..................................(Already Installed)
       * Skipping package: php5-curl.................................(Already Installed)
       * Installing package: mysql-server............................Failed!
       * Restarting Apache httpd web server apache2                                   AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this message
      

      I am running on Git 7645 trying for the last few days to update to the latest. Please let me know if you would like other logs.

      Thanks,
      Paul

      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
      • Junkhacker
        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
        • Tom Elliott
          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
          • 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 Elliott Junkhacker 2 Replies Last reply Reply Quote 0
            • fry_p
              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 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_p 1 Reply Last reply Reply Quote 0
                • fry_p
                  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 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_p 1 Reply Last reply Reply Quote 0
                    • Tom Elliott
                      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
                      • fry_p
                        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 Elliott 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_p 1 Reply Last reply Reply Quote 0
                          • fry_p
                            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
                            • Tom Elliott
                              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_p 1 Reply Last reply Reply Quote 0
                              • fry_p
                                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 Elliott 1 Reply Last reply Reply Quote 0
                                • fry_p
                                  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
                                  • Tom Elliott
                                    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_p 2 Replies Last reply Reply Quote 0
                                    • fry_p
                                      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 Elliott 1 Reply Last reply Reply Quote 1
                                      • Tom Elliott
                                        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_p 1 Reply Last reply Reply Quote 0
                                        • 1 / 1
                                        • First post
                                          Last post

                                        58
                                        Online

                                        10.4k
                                        Users

                                        16.4k
                                        Topics

                                        150.7k
                                        Posts

                                        Copyright © 2012-2023 FOG Project