upgrading from 1.5.0 to 1.5.1 fails at backup

[Wayne Workman]

@hanz You could fix this the hard way by moving to something like Debian 9, or wait for us to try to help more. I’m at work right now and can’t focus on this. FWIW, Debian historically has had the least amount of problems with FOG.

[Sebastian Roth]

@Wayne-Workman Looking through the logs I found this:

Apr 10 02:17:55 Fedora27Workstation systemd[1]: Started MariaDB 10.2 database server.
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'BY ''' at line 1
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'BY ''' at line 1

[Sebastian Roth]

I was on the wrong track I suppose. Wayne is right, the PHP fpm seems to be the issue: FCGI: attempt to connect to 127.0.0.1:9000

@Wayne-Workman Can you check /var/ log/php-fpm/error.log

[Hanz]

@sebastian-roth Indeed this is from installer error log file

Apr 10 11:25:31 fog-server systemd[1]: Starting The PHP FastCGI Process Manager$
Apr 10 11:25:31 fog-server systemd[1]: Started The PHP FastCGI Process Manager.
--2018-04-10 11:25:33--  http://x.x.x.x//fog//maintenance/backup_db.php
Connecting to x.x.x.x:80... connected.
HTTP request sent, awaiting response... 503 Service Unavailable
2018-04-10 11:25:33 ERROR 503: Service Unavailable.

php-fpm/error.log

[10-Apr-2018 11:43:21] NOTICE: Terminating ...
[10-Apr-2018 11:43:21] NOTICE: exiting, bye-bye!
[10-Apr-2018 11:43:50] NOTICE: fpm is running, pid 20233
[10-Apr-2018 11:43:50] NOTICE: ready to handle connections
[10-Apr-2018 11:43:50] NOTICE: systemd monitor interval set to 10000ms

[Tom Elliott]

What’s in /var/log/php-fpm/www-error.log, or very similar?

[Hanz]

@tom-elliott

/var/log/php-fpm/error.log

[10-Apr-2018 11:43:21] NOTICE: Terminating ...
[10-Apr-2018 11:43:21] NOTICE: exiting, bye-bye!
[10-Apr-2018 11:43:50] NOTICE: fpm is running, pid 20233
[10-Apr-2018 11:43:50] NOTICE: ready to handle connections
[10-Apr-2018 11:43:50] NOTICE: systemd monitor interval set to 10000ms

[Tom Elliott]

@hanz no it will start with www

[Hanz]

@tom-elliott none in that directory…

[bcs@fog-server php-fpm]$ ls
error.log           error.log-20180325  error.log-20180408
error.log-20180318  error.log-20180401

[Wayne Workman]

@hanz Run this, it’ll find all files begining with www
find / -type f -name www*

[Tom Elliott]

This is now fixed. Please just run git pull and you will be able to install. I don’t know if this will work for arch based installs quite yet though.

[Wayne Workman]

@tom-elliott I manually started the installation tests just now.