[SOLVED] After upgrade, no finish task for new,edit, remove sites or apps.

Ebrc · Aug 29, 2019

Dear,
After updating to the latest version, it does not finish creating, modifying or deleting websites or apps "instacion_task"
upgrade to git-stable, but nothing.
you do not finish creating the sites, create the entry in the DB, but do not create the web folder.
my logs
tail /var/log/ispconfig/ispconfig.log

Wed Aug 28 19:56:02 -03 2019 Jobs next run is 2019-08-29 03:00:00
Wed Aug 28 19:56:02 -03 2019 Date compare of 1567040400 and 1567032961 is -1
Wed Aug 28 19:56:02 -03 2019 run job (cronjob_letsencrypt) done.
Wed Aug 28 19:56:02 -03 2019 29.08.2019-00: 56 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_cron_lock
Wed Aug 28 19:56:02 -03 2019 finished.

tail /var/log/ispconfig/ispconfig.log
29.08.2019-01: 07 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_cron_lock
29.08.2019-01: 08 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_cron_lock

Debian 9.9
Click to expand...

root@server:/usr/local/ispconfig/server/lib/classes/cron.d# tail /var/log/apache2/error.log
[Thu Aug 29 08:29:25.829857 2019] [fcgid:warn] [pid 14011] [client 186.0.177.177:40318] mod_fcgid: stderr: PHP Warning: Undefined property wb of class app in /usr/local/ispconfig/interface/lib/app.inc.php on line 81, referer: https://patagoniatracker.com.ar:8080/index.php
Click to expand...

root@server:/usr/local/ispconfig/server/lib/classes/cron.d# cat htf_report.txt | more

##### SERVER #####
IP-address (as per hostname): ***.***.***.***
[WARN] could not determine server's ip address by ifconfig
[INFO] ISPConfig is installed.

##### ISPCONFIG #####
ISPConfig version is 3.1dev

##### VERSION CHECK #####

[INFO] php (cli) version is 5.6.40-10+0~20190807.18+debian9~1.gbp5642bf

##### PORT CHECK #####

##### MAIL SERVER CHECK #####

##### RUNNING SERVER PROCESSES #####

[INFO] I found the following web server(s):
Apache 2 (PID 1534)
[INFO] I found the following mail server(s):
Unknown process (smtpd) (PID 1389)
[INFO] I found the following pop3 server(s):
Dovecot (PID 1312)
[INFO] I found the following imap server(s):
Dovecot (PID 1312)
[INFO] I found the following ftp server(s):
PureFTP (PID 1876)

##### LISTENING PORTS #####
(only ()
Local (Address)
[anywhere]:995 (1312/dovecot)
[localhost]:10023 (816/postgrey)
[localhost]:10024 (1916/amavisd-new)
[anywhere]:25672 (1612/beam.smp)
[localhost]:10025 (1812/master)
[localhost]:10026 (1916/amavisd-new)
[localhost]:10027 (1812/master)
[anywhere]:587 (1812/master)
[localhost]:6379 (1295/redis-server)
[localhost]:11211 (1057/memcached)
[anywhere]:110 (1312/dovecot)
[anywhere]:143 (1312/dovecot)
[anywhere]:465 (1812/master)
[anywhere]:4369 (1260/epmd)
***.***.***.***:53 (918/named)
[anywhere]:21 (1876/pure-ftpd)
***.***.***.***:53 (918/named)
[localhost]:53 (918/named)
[anywhere]:22 (1236/sshd)
[anywhere]:25 (1389/smtpd)
[localhost]:953 (918/named)
[anywhere]:1723 (924/pptpd)
[anywhere]:993 (1312/dovecot)

*:*:*:*::*:995 (1312/dovecot)

*:*:*:*::*:10023 (816/postgrey)

*:*:*:*::*:10026 (1916/amavisd-new)
*:*:*:*::*:3306 (1444/mysqld)

*:*:*:*::*:587 (1812/master)

[localhost]10 (1312/dovecot)

[localhost]43 (1312/dovecot)

*:*:*:*::*:80 (1534/apache2)
*:*:*:*::*:8080 (1534/apache2)

*:*:*:*::*:465 (1812/master)
*:*:*:*::*:4369 (1260/epmd)
*:*:*:*::*:8081 (1534/apache2)

*:*:*:*::*:21 (1876/pure-ftpd)
*:*:*:*::*:53 (918/named)

*:*:*:*::*:25 (1389/smtpd)
*:*:*:*::*:953 (918/named)

*:*:*:*::*:443 (1534/apache2)

*:*:*:*::*:993 (1312/dovecot)

##### IPTABLES #####
Chain INPUT (policy ACCEPT)
target prot opt source destination
f2b-postfix-sasl tcp -- [anywhere]/0 [anywhere]/0 multiport dports 25
f2b-pureftpd tcp -- [anywhere]/0 [anywhere]/0 multiport dports 21
f2b-sshd tcp -- [anywhere]/0 [anywhere]/0 multiport dports 22

Chain FORWARD (policy ACCEPT)
target prot opt source destination

Chain OUTPUT (policy ACCEPT)
target prot opt source destination

Chain f2b-postfix-sasl (1 references)
target prot opt source destination
REJECT all -- ***.***.***.*** [anywhere]/0 reject-with icmp-port-unreachable

RETURN all -- [anywhere]/0 [anywhere]/0

Chain f2b-pureftpd (1 references)
target prot opt source destination
RETURN all -- [anywhere]/0 [anywhere]/0

Chain f2b-sshd (1 references)
target prot opt source destination
REJECT all -- ***.***.***.*** [anywhere]/0 reject-with icmp-port-unreachable

RETURN all -- [anywhere]/0 [anywhere]/0
Click to expand...

thanks in advance

ps: no button for donation?

Taleman · Aug 29, 2019

After updating to the latest version
Click to expand...

Latest version of ISPConfig? Or the Operating system? Or something else?

ISPConfig version is 3.1dev
Click to expand...

You are running the development version. Some breakage is expected witht that. You should have used the released stable version if you want ISPConfig that works properly.

INFO] php (cli) version is 5.6.40-10+0~
Click to expand...

If your Operating System is Debian version 9.9, how come your PHP is version 5.6? Debian 9 has 7.0 PHP. If the default PHP has changed, ISPConfig is not supported on that setup. Change default PHP back to what Debian 9 comes with.

ps: no button for donation?
Click to expand...

https://www.howtoforge.com/subscription/

till · Aug 29, 2019

Taleman said: ↑

You are running the development version. Some breakage is expected witht that. You should have used the released stable version if you want ISPConfig that works properly.
Click to expand...

That's ok in this case, I asked him to update to 3.1dev as he originally posted in a thread which required an update ti 3.1dev as fix. The current 3.1dev version is ok.

Ebrc · Aug 30, 2019

You are running the development version. Some breakage is expected witht that. You should have used the released stable version if you want ISPConfig that works properly.
That's ok in this case, I asked him to update to 3.1dev as he originally posted in a thread which required an update ti 3.1dev as fix. The current 3.1dev version is ok.
Click to expand...

Latest version of ISPConfig? Or the Operating system? Or something else?
Click to expand...

After update debian&ispconfig

If your Operating System is Debian version 9.9, how come your PHP is version 5.6? Debian 9 has 7.0 PHP. If the default PHP has changed, ISPConfig is not supported on that setup. Change default PHP back to what Debian 9 comes with.
Click to expand...

Change for 7

root@server:~# php -v
PHP 7.0.33-10+0~20190807.18+debian9~1.gbp5452d8 (cli) (built: Aug 7 2019 19:47:15) ( NTS )

same results, do not finish creating sites, edit or delete websites or apps.

Logs

root@server:~# /usr/local/ispconfig/server/server.sh
Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
finished.
Click to expand...

30.08.2019-03:46 - DEBUG - Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'.
30.08.2019-03:46 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
Click to expand...

root@server:~# tail -f /var/log/ispconfig/cron.log
Thu Aug 29 20:00:12 -03 2019 Date compare of 1567126800 and 1567119611 is -1
Thu Aug 29 20:00:12 -03 2019 run job (cronjob_letsencrypt) done.
Thu Aug 29 20:00:12 -03 2019 #!/usr/bin/php -q
Thu Aug 29 20:00:12 -03 2019
Thu Aug 29 20:00:12 -03 2019 ##### SCRIPT FINISHED #####
Thu Aug 29 20:00:12 -03 2019 Results can be found in htf_report.txt
Thu Aug 29 20:00:12 -03 2019 To view results use your favourite text editor or type 'cat htf_report.txt | more' on the server console.
Thu Aug 29 20:00:12 -03 2019
Thu Aug 29 20:00:12 -03 2019 If you want to see the non-anonymized output start the script with --debug as parameter (php -q htf-common-issues.php --debug).
Thu Aug 29 20:00:12 -03 2019
Click to expand...

DB>dbispconfig>server>update = 259
DB>dbispconfig>sys_datalog>datalog_id = 252

Ok, the problem is fixed.
In the ISPConfig-3.1.14p2.tar.gz Installation Archive in the ispconfig3_install\install\sql\incremental directory, I manually ran upd_0087.sgl Missing DB changes added and everything works ok (adding new pages, etc.)
Click to expand...

??

till · Aug 30, 2019

Seems as if you modified something in your database manually, maybe you deleted records from sys_datalog ?

Ebrc · Aug 30, 2019

never, is the first time I see that data. How can I synchronize them?

till · Aug 30, 2019

Change the value in the field 'updated' in the server table to the highest datalog_id of the sys_datalog table.

Ebrc · Aug 30, 2019

Keep everything the same.

Is that numbering normal? Server_id = 0,1 ? datalog_id = 252,189 ...

till · Aug 30, 2019

Yes, that's ok.

Ebrc · Aug 30, 2019

Ok, I have no idea what else could be happening.
I look forward to your help.
Thank you very much for your time.

till · Aug 30, 2019

Please see post #7, I described there what you should do to get it in sync again. You have to alter the value in the updated column of the server table to 252 and your system will start to write updates to disk again.

Ebrc · Aug 30, 2019

Yes !

Server id 0,1 ?

till · Aug 30, 2019

That's ok now. When you add or edit something, it will be created in the filesystem again. and don't forget to activate the cronjob again in case you commented it out for debugging purposes.

Ebrc · Aug 30, 2019

No work, no logs, no folders create or deleted.

root@server:/var/www/clients/client0# /usr/local/ispconfig/server/server.sh
Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock

30.08.2019-18:01 - DEBUG - Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'.
30.08.2019-18:01 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
finished.
Click to expand...

root@server:/var/www/clients/client0# tail -f /var/log/ispconfig/ispconfig.log
30.08.2019-17:59 - DEBUG - Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'.
30.08.2019-17:59 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
30.08.2019-18:00 - DEBUG - Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'.
30.08.2019-18:00 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
30.08.2019-18:00 - DEBUG - Mail storage [email protected]: 3960
30.08.2019-18:00 - DEBUG - Mail storage [email protected]: 1095980
30.08.2019-18:01 - DEBUG - Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'.
30.08.2019-18:01 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
30.08.2019-18:01 - DEBUG - Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'.
30.08.2019-18:01 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
Click to expand...

root@server:/var/www/clients/client0# tail -f /var/log/ispconfig/cron.log
Fri Aug 30 13:04:03 -03 2019 Date compare of 1567213200 and 1567181042 is -1
Fri Aug 30 13:04:03 -03 2019 run job (cronjob_letsencrypt) done.
Fri Aug 30 13:04:03 -03 2019 #!/usr/bin/php -q
Fri Aug 30 13:04:03 -03 2019
Fri Aug 30 13:04:03 -03 2019 ##### SCRIPT FINISHED #####
Fri Aug 30 13:04:03 -03 2019 Results can be found in htf_report.txt
Fri Aug 30 13:04:03 -03 2019 To view results use your favourite text editor or type 'cat htf_report.txt | more' on the server console.
Fri Aug 30 13:04:03 -03 2019
Fri Aug 30 13:04:03 -03 2019 If you want to see the non-anonymized output start the script with --debug as parameter (php -q htf-common-issues.php --debug).
Fri Aug 30 13:04:03 -03 2019
Click to expand...

thx

till · Aug 30, 2019

The steps to test this are:

1) ensure that the server.sh cronjob has been commented out.
2) add a new website.
3) run server.sh on the shell and post the result.

without adding a new website or without commenting out server.sh cronjob, the result you posted must be like this.

Ebrc · Aug 30, 2019

1) ensure that the server.sh cronjob has been commented out.
OK
2) add a new website.
OK
3) run server.sh on the shell and post the result.
root@server:/var/www/clients/client0# /usr/local/ispconfig/server/server.sh
Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock

30.08.2019-18:14 - DEBUG - Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'.
30.08.2019-18:14 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
finished.

till · Aug 30, 2019

Is the number in sys_datalog table higher now?

Ebrc · Aug 30, 2019

No, = 252

till · Aug 30, 2019

Ok, then you probably have an issue in your mysql config which prevents or prevented the use of the mysql commandline tools like 'mysql' command or 'mysqldump' which caused database structure upgrade failures.

From which ISPConfig version did you originally upgrade?

Ebrc · Aug 31, 2019

3.1.14
but I'm not sure it could have been one before.

MySQL

MariaDB [(none)]> status
--------------
mysql Ver 15.1 Distrib 10.1.38-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

Connection id: 5989
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server: MariaDB
Server version: 10.1.38-MariaDB-0+deb9u1 Debian 9.8
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: utf8mb4
Conn. characterset: utf8mb4
UNIX socket: /var/run/mysqld/mysqld.sock
Uptime: 10 hours 31 min 24 sec

Threads: 12 Questions: 181041 Slow queries: 0 Opens: 354 Flush tables: 1 Open tables: 348 Queries per second avg: 4.778
Click to expand...

Passwords OK

The config file location is:

/usr/local/ispconfig/interface/lib/config.inc.php
ISPConfig 3 Server
The config file location is:

/usr/local/ispconfig/server/lib/config.inc.php
The MySQL root password that is used to create new MySQL databases only is stored in the file:

/usr/local/ispconfig/server/lib/mysql_clientdb.conf
Click to expand...

While browsing a site that doesn't work, I throw this.

Unknown column 'php_fpm_chroot' in 'field list'

Log in or Sign up

[SOLVED] After upgrade, no finish task for new,edit, remove sites or apps.

Ebrc New Member

Taleman Well-Known Member HowtoForge Supporter

till Super Moderator Staff Member ISPConfig Developer

Ebrc New Member

till Super Moderator Staff Member ISPConfig Developer

Ebrc New Member

till Super Moderator Staff Member ISPConfig Developer

Ebrc New Member

till Super Moderator Staff Member ISPConfig Developer

Ebrc New Member

till Super Moderator Staff Member ISPConfig Developer

Ebrc New Member

till Super Moderator Staff Member ISPConfig Developer

Ebrc New Member

till Super Moderator Staff Member ISPConfig Developer

Ebrc New Member

till Super Moderator Staff Member ISPConfig Developer

Ebrc New Member

till Super Moderator Staff Member ISPConfig Developer

Ebrc New Member

Share This Page

Log in or Sign up

[SOLVED] After upgrade, no finish task for new,edit, remove sites or apps.

Ebrc New Member

Taleman Well-Known Member HowtoForge Supporter

till Super Moderator Staff Member ISPConfig Developer

Ebrc New Member

till Super Moderator Staff Member ISPConfig Developer

Ebrc New Member

till Super Moderator Staff Member ISPConfig Developer

Ebrc New Member

till Super Moderator Staff Member ISPConfig Developer

Ebrc New Member

till Super Moderator Staff Member ISPConfig Developer

Ebrc New Member

till Super Moderator Staff Member ISPConfig Developer

Ebrc New Member

till Super Moderator Staff Member ISPConfig Developer

Ebrc New Member

till Super Moderator Staff Member ISPConfig Developer

Ebrc New Member

till Super Moderator Staff Member ISPConfig Developer

Ebrc New Member

Share This Page

Useful Searches