Fog Trunk Git 7645 update fails at SQL


  • Testers

    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


  • Developer

    @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


  • Senior Developer

    @Sebastian-Roth Added to testers.


  • Developer

    @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!


  • Testers

    @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!


  • Developer

    @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! :-)


  • Testers

    @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)


  • Developer

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


  • Senior Developer

    @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.


  • Testers

    @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.


  • Developer

    @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
    

  • Testers

    @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.
    

  • Senior Developer

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


  • Testers

    @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?


  • Testers

    @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.


  • Senior Developer

    @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?


  • Testers

    @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.


  • Senior Developer

    Please pull in the latest and reinstall.


Log in to reply
 

444
Online

39.3k
Users

11.0k
Topics

104.6k
Posts

Looks like your connection to FOG Project was lost, please wait while we try to reconnect.