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

Discussion in 'Installation/Configuration' started by Ebrc, Aug 29, 2019.

  1. Ebrc

    Ebrc New Member HowtoForge Supporter

    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
    thanks in advance

    ps: no button for donation?
     
    Last edited: Aug 29, 2019
  2. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Latest version of ISPConfig? Or the Operating system? Or something else?
    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.
    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.
    https://www.howtoforge.com/subscription/
     
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  4. Ebrc

    Ebrc New Member HowtoForge Supporter

    :)
    After update debian&ispconfig
    Change for 7

    [email protected]:~# 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
    :confused:

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

    ??
     
    Last edited: Aug 30, 2019
  5. till

    till Super Moderator Staff Member ISPConfig Developer

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

    Ebrc New Member HowtoForge Supporter

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

    till Super Moderator Staff Member ISPConfig Developer

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

    Ebrc New Member HowtoForge Supporter

    Keep everything the same.
    upload_2019-8-30_8-51-56.png
    Is that numbering normal? Server_id = 0,1 ? datalog_id = 252,189 ...
     
  9. till

    till Super Moderator Staff Member ISPConfig Developer

    Yes, that's ok.
     
  10. Ebrc

    Ebrc New Member HowtoForge Supporter

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

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  12. Ebrc

    Ebrc New Member HowtoForge Supporter

    Yes !
    upload_2019-8-30_12-51-11.png

    upload_2019-8-30_12-52-34.png
    upload_2019-8-30_12-52-48.png

    Server id 0,1 ?
     
  13. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  14. Ebrc

    Ebrc New Member HowtoForge Supporter

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

    thx
     
  15. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  16. Ebrc

    Ebrc New Member HowtoForge Supporter

    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.
    [email protected]:/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.
     
  17. till

    till Super Moderator Staff Member ISPConfig Developer

    Is the number in sys_datalog table higher now?
     
  18. Ebrc

    Ebrc New Member HowtoForge Supporter

    No, = 252
     
  19. till

    till Super Moderator Staff Member ISPConfig Developer

    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?
     
  20. Ebrc

    Ebrc New Member HowtoForge Supporter

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

    MySQL

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

    Unknown column 'php_fpm_chroot' in 'field list'
     
    Last edited: Aug 31, 2019

Share This Page