upgrading from 1.5.0 to 1.5.1 fails at backup

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