Update fog using only https

[lebrun78]

I have a problem running install

* Changing permissions on apache log files....................OK
* Backing up database.........................................Failed
* Updating Database...........................................OK
* Update fogstorage database password.........................Failed!

It seems to have conflits in the /opt/fog/.fogsettings file :

cat /opt//fog/.fogsettings
## Start of FOG Settings
## Created by the FOG Installer
## Find more information about this file in the FOG Project wiki:
##     https://wiki.fogproject.org/wiki/index.php?title=.fogsettings
## Version: 1.5.7.93
## Install time: ven. 06 déc. 2019 04:11:04 EST
ipaddress='148.60.4.2'
copybackold='0'
interface='ens3'
submask='255.255.248.0'
hostname='cosinus.istic.univ-rennes1.fr'
routeraddress='# No router address added'
plainrouter=''
dnsaddress='# No dns added'
username='fogproject'
password='1rstpasscoded'
osid='1'
osname='Redhat'
dodhcp='N'
bldhcp='0'
dhcpd='dhcpd'
blexports='1'
installtype='N'
snmysqluser='fogmaster'
snmysqlpass='my_original_pass_still_working_with_root'
snmysqlhost='localhost'
installlang='0'
storageLocation='/images'
fogupdateloaded=1
docroot='/var/www/html/'
webroot='/fog/'
caCreated='yes'
httpproto='https'
startrange=''
endrange=''
bootfilename='undionly.kpxe'
packages='bc curl dhcp-server gcc gcc-c++ genisoimage gzip httpd lftp m4 make mod_ssl mtools mysql mysql-server net-tools nfs-utils php php-bcmath php-cli php-common php-fpm php-gd php-json php-ldap php-mbstring php-mysqlnd php-process syslinux tar tftp-server unzip vsftpd wget xinetd xz-devel'
noTftpBuild=''
notpxedefaultfile=''
sslpath='/opt/fog/snapins/ssl/'
backupPath='/home/'
armsupport=''
php_ver=''
php_verAdds=''
sslprivkey='/opt/fog/snapins/ssl//.srvprivate.key'
## End of FOG Settings
mysqldbname='fog'
snmysqluser='fogstorage'
snmysqlpass='a crypted password '

[lebrun78]

I have commented on the last two
lines of the/opt/fog/. fogsettings file and the installation works

[Sebastian Roth]

@lebrun78 said in Update fog using only https:

Update fogstorage database password…Failed!

Can you please post the logs you find in /opt/fogprojectgit/bin/error_logs/ here. Would be interesting to see if this is something we can fix.

[lebrun78]

@Sebastian-Roth said in Update fog using only https:

/opt/fogprojectgit/bin/error_logs/

logs are very large, how could I send it ?

[Sebastian Roth]

@lebrun78 Upload to a file share and post a link here maybe.

[lebrun78]

Here is the links!

https://filesender.renater.fr/?s=download&token=1556680b-9c1e-50af-5516-f42c06770b84

fog_error_1.5.7.100.log is the last install log with the 2 last lines of the .fogsettings deleted.
fog_error_1.5.7.93.log has generated mysql count error

Arnaud

[Sebastian Roth]

@lebrun78 said in Update fog using only https:

fog_error_1.5.7.93.log has generated mysql count error

Unfortunately it seems like this log is overwritten by the second run you made after removing the last two lines from the settings file (/opt/fog/.fogsettings). Do you remember the exact “count error” you got in the error log? I have looked through the script code but I can’t figure out how some count error could happen at this stage.

Do you have FOG installed on a VM server with snapshots where you can roll back by any chance?

[lebrun78]

Unfortunately, our test server is a VM but I haven’t done any snapshot before install.

[Sebastian Roth]

@lebrun78 Nevermind. Though it would have been really great to get some more information on why this has failed. I have put in a huge amount of time to test these changes I have made on the installer scripts on DB setup and hope this is not something several peope run into.

Can you please run ls -al /home/fogDBbackups/ and post output here. Maybe I can try to follow the versions you used and figure out what could go wrong.

[Sebastian Roth]

@lebrun78 bump…

[kamburta]

@Tom-Elliott said in Update fog using only https:

If you’ve already installed FOG using the parameters, you simply need to run:

./installfog.sh -y to upgrade. The other parameters were stored in the configuration file.

Good afternoon Tom,
Is it possible to transform an installation from https to http?

[kamburta]

@kamburta
Tom,
Sorry to take your time, you can convert from https to http by changing the information in /opt/fog/.fogsettings and running the installation again.