Solved Fog Trunk Git 7645 update fails at SQL

[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

[Junkhacker]

@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

[Tom Elliott]

@Sebastian-Roth Added to testers.

[Sebastian Roth]

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

[fry_p]

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

[Sebastian Roth]

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

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

[Sebastian Roth]

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

[Tom Elliott]

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

[fry_p]

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

[Sebastian Roth]

@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

[fry_p]

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

[Tom Elliott]

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

[fry_p]

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

[fry_p]

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

[Tom Elliott]

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

[fry_p]

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

[Tom Elliott]

Please pull in the latest and reinstall.