Strange problem in backup.

Discussion in 'Installation/Configuration' started by maxlinux, Aug 12, 2019.

  1. maxlinux

    maxlinux New Member

    I have installed ispconfig3 (the last one available) on an oragepi pc2 (it's like a raspberrypi3, and the operating system is Armbian (ubuntu 18.04).
    The hard drive is a 120GB ssd

    The server is directly connected to the internet with fixed IP and domain name.
    I have followed this tutorial for installation: https://www.howtoforge.com/tutorial...sl-pureftpd-bind-postfix-doveot-and-ispconfig

    Ispconfig3 has started working correctly from the first moment, but I have realized that it cannot make the backup in /var/backup. In fact, not even the folder existed after installation.
    So I created /var/backup as root with 750 permissions and scheduled backups to all my websites hosted on this small server.

    The problem is that no backups are created.

    I have looked in the logs, but I have not found anything, apart from that "Show ISPC cron log" and "System Messages - Log" are stopped 6 days ago, so I suppose that for some reason Cron tasks are not executed in ispconfig

    I tried to put in Clients/client/Limits/Cron jobs Limits

    Max number jobs: 10
    Full cron

    But this has not worked.

    Anyone have a solution?
     
  2. Taleman

    Taleman Well-Known Member HowtoForge Supporter

  3. maxlinux

    maxlinux New Member

    Hi Taleman, tnx to answer

    here the system infos:
    ------------------------
    root@video:~# wget -q -O htf-common-issues.php "http://gitplace.net/pixcept/ispconfig-tools/raw/stable/htf-common-issues.php" && php -q htf-common-issues.php

    root@video:~# cat htf_report.txt

    ##### 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 7.2.19-0ubuntu***.***.***.***

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


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


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

    [INFO] I found the following web server(s):
    Apache 2 (PID 2744)
    [INFO] I found the following mail server(s):
    Postfix (PID 2019)
    [INFO] I found the following pop3 server(s):
    Dovecot (PID 1511)
    [INFO] I found the following imap server(s):
    Dovecot (PID 1511)
    [INFO] I found the following ftp server(s):
    PureFTP (PID 1604)

    ##### LISTENING PORTS #####
    (only ()
    Local (Address)
    [anywhere]:995 (1511/dovecot)
    [localhost]:10023 (1226/postgrey)
    [localhost]:10025 (2019/master)
    [localhost]:10027 (2019/master)
    [anywhere]:587 (2019/master)
    [localhost]:11211 (894/memcached)
    [localhost]:6379 (964/redis-server)
    [anywhere]:110 (1511/dovecot)
    [anywhere]:143 (1511/dovecot)
    [anywhere]:465 (2019/master)
    [anywhere]:21 (1604/pure-ftpd)
    ***.***.***.***:53 (887/named)
    [localhost]:53 (887/named)
    ***.***.***.***:53 (506/systemd-resolve)
    [anywhere]:22 (963/sshd)
    ***.***.***.***:3478 (1581/turnserver)
    ***.***.***.***:3478 (1581/turnserver)
    ***.***.***.***:3478 (1581/turnserver)
    ***.***.***.***:3478 (1581/turnserver)
    [localhost]:3478 (1581/turnserver)
    [localhost]:3478 (1581/turnserver)
    [localhost]:3478 (1581/turnserver)
    [localhost]:3478 (1581/turnserver)
    ***.***.***.***:3479 (1581/turnserver)
    ***.***.***.***:3479 (1581/turnserver)
    ***.***.***.***:3479 (1581/turnserver)
    ***.***.***.***:3479 (1581/turnserver)
    [localhost]:3479 (1581/turnserver)
    [localhost]:3479 (1581/turnserver)
    [localhost]:3479 (1581/turnserver)
    [localhost]:3479 (1581/turnserver)
    [anywhere]:25 (2019/master)
    [localhost]:953 (887/named)
    [anywhere]:993 (1511/dovecot)
    *:*:*:*::*:995 (1511/dovecot)
    *:*:*:*::*:10023 (1226/postgrey)
    *:*:*:*::*:3306 (1249/mysqld)
    *:*:*:*::*:587 (2019/master)
    *:*:*:*::*:6379 (964/redis-server)
    [localhost]10 (1511/dovecot)
    [localhost]43 (1511/dovecot)
    *:*:*:*::*:8080 (2744/apache2)
    *:*:*:*::*:80 (2744/apache2)
    *:*:*:*::*:8081 (2744/apache2)
    *:*:*:*::*:465 (2019/master)
    *:*:*:*::*:21 (1604/pure-ftpd)
    *:*:*:*::*:53 (887/named)
    *:*:*:*::*:22 (963/sshd)
    *:*:*:*::*:3478 (1581/turnserver)
    *:*:*:*::*:3478 (1581/turnserver)
    *:*:*:*::*:3478 (1581/turnserver)
    *:*:*:*::*:3478 (1581/turnserver)
    *:*:*:*::*:3479 (1581/turnserver)
    *:*:*:*::*:3479 (1581/turnserver)
    *:*:*:*::*:3479 (1581/turnserver)
    *:*:*:*::*:3479 (1581/turnserver)
    *:*:*:*::*:25 (2019/master)
    *:*:*:*::*:953 (887/named)
    *:*:*:*::*:443 (2744/apache2)
    *:*:*:*::*:993 (1511/dovecot)




    ##### IPTABLES #####
    Chain INPUT (policy ACCEPT)
    target prot opt source destination

    Chain FORWARD (policy ACCEPT)
    target prot opt source destination

    Chain OUTPUT (policy ACCEPT)
    target prot opt source destination
    -------------------------

    and here after comment the server.sh crontab line and set to debug ispconfig

    ------------------
    root@video:~# /usr/local/ispconfig/server/server.sh


    12.08.2019-14:53 - DEBUG - Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'.
    12.08.2019-14:53 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    finished.
    root@video:~#

    ------------------
     
  4. maxlinux

    maxlinux New Member

    oh yes I've installed coturn server too in order to help NexcloudTalk... Nextcloud is installed like a normal php site like wordpress or phpbb3 in a domain created using ispconfig. No modification to ISPconfig was make for nextcloud.
     
  5. maxlinux

    maxlinux New Member

    I have walked the steps and the instigation of "coturn" has nothing to do.
    The cron system stopped working on August 6 (the day I installed ispConfig) and I installed coturn on August 8.
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    Do an ISPConfig update to 3.1.14p2 using ispconfig_update.sh command and then delete the content of the sys_cron table in the ISPConfig database. Then ensure that sudo command is installed and working on your server and that the zip and unzip commands are available as well.
     
  7. maxlinux

    maxlinux New Member

    ah!! during the update appear this warning:

    dbispconfig.aps_instances
    note : The storage engine for the table doesn't support repair
    dbispconfig.aps_instances_settings
    note : The storage engine for the table doesn't support repair
    dbispconfig.aps_packages
    note : The storage engine for the table doesn't support repair
    dbispconfig.aps_settings
    note : The storage engine for the table doesn't support repair
    dbispconfig.attempts_login
    note : The storage engine for the table doesn't support repair
    dbispconfig.client
    note : The storage engine for the table doesn't support repair
    dbispconfig.client_circle
    note : The storage engine for the table doesn't support repair
    dbispconfig.client_message_template
    note : The storage engine for the table doesn't support repair
    dbispconfig.client_template
    note : The storage engine for the table doesn't support repair
    dbispconfig.client_template_assigned
    note : The storage engine for the table doesn't support repair
    dbispconfig.country
    note : The storage engine for the table doesn't support repair
    dbispconfig.cron
    note : The storage engine for the table doesn't support repair
    dbispconfig.directive_snippets
    note : The storage engine for the table doesn't support repair
    dbispconfig.dns_rr
    note : The storage engine for the table doesn't support repair
    dbispconfig.dns_slave
    note : The storage engine for the table doesn't support repair
    dbispconfig.dns_soa
    note : The storage engine for the table doesn't support repair
    dbispconfig.dns_ssl_ca
    note : The storage engine for the table doesn't support repair
    dbispconfig.dns_template
    note : The storage engine for the table doesn't support repair
    dbispconfig.domain
    note : The storage engine for the table doesn't support repair
    dbispconfig.firewall
    note : The storage engine for the table doesn't support repair
    dbispconfig.ftp_traffic
    note : The storage engine for the table doesn't support repair
    dbispconfig.ftp_user
    note : The storage engine for the table doesn't support repair
    dbispconfig.help_faq
    note : The storage engine for the table doesn't support repair
    dbispconfig.help_faq_sections
    note : The storage engine for the table doesn't support repair
    dbispconfig.iptables
    note : The storage engine for the table doesn't support repair
    dbispconfig.mail_access
    note : The storage engine for the table doesn't support repair
    dbispconfig.mail_backup
    note : The storage engine for the table doesn't support repair
    dbispconfig.mail_content_filter
    note : The storage engine for the table doesn't support repair
    dbispconfig.mail_domain
    note : The storage engine for the table doesn't support repair
    dbispconfig.mail_forwarding
    note : The storage engine for the table doesn't support repair
    dbispconfig.mail_get
    note : The storage engine for the table doesn't support repair
    dbispconfig.mail_mailinglist
    note : The storage engine for the table doesn't support repair
    dbispconfig.mail_relay_recipient
    note : The storage engine for the table doesn't support repair
    dbispconfig.mail_traffic
    note : The storage engine for the table doesn't support repair
    dbispconfig.mail_transport
    note : The storage engine for the table doesn't support repair
    dbispconfig.mail_user
    note : The storage engine for the table doesn't support repair
    dbispconfig.mail_user_filter
    note : The storage engine for the table doesn't support repair
    dbispconfig.monitor_data
    note : The storage engine for the table doesn't support repair
    dbispconfig.openvz_ip
    note : The storage engine for the table doesn't support repair
    dbispconfig.openvz_ostemplate
    note : The storage engine for the table doesn't support repair
    dbispconfig.openvz_template
    note : The storage engine for the table doesn't support repair
    dbispconfig.openvz_traffic
    note : The storage engine for the table doesn't support repair
    dbispconfig.openvz_vm
    note : The storage engine for the table doesn't support repair
    dbispconfig.remote_session
    note : The storage engine for the table doesn't support repair
    dbispconfig.remote_user
    note : The storage engine for the table doesn't support repair
    dbispconfig.server
    note : The storage engine for the table doesn't support repair
    dbispconfig.server_ip
    note : The storage engine for the table doesn't support repair
    dbispconfig.server_ip_map
    note : The storage engine for the table doesn't support repair
    dbispconfig.server_php
    note : The storage engine for the table doesn't support repair
    dbispconfig.shell_user
    note : The storage engine for the table doesn't support repair
    dbispconfig.software_package
    note : The storage engine for the table doesn't support repair
    dbispconfig.software_repo
    note : The storage engine for the table doesn't support repair
    dbispconfig.software_update
    note : The storage engine for the table doesn't support repair
    dbispconfig.software_update_inst
    note : The storage engine for the table doesn't support repair
    dbispconfig.spamfilter_policy
    note : The storage engine for the table doesn't support repair
    dbispconfig.spamfilter_users
    note : The storage engine for the table doesn't support repair
    dbispconfig.spamfilter_wblist
    note : The storage engine for the table doesn't support repair
    dbispconfig.support_message
    note : The storage engine for the table doesn't support repair
    dbispconfig.sys_config
    note : The storage engine for the table doesn't support repair
    dbispconfig.sys_cron
    note : The storage engine for the table doesn't support repair
    dbispconfig.sys_datalog
    note : The storage engine for the table doesn't support repair
    dbispconfig.sys_dbsync
    note : The storage engine for the table doesn't support repair
    dbispconfig.sys_filesync
    note : The storage engine for the table doesn't support repair
    dbispconfig.sys_group
    note : The storage engine for the table doesn't support repair
    dbispconfig.sys_ini
    note : The storage engine for the table doesn't support repair
    dbispconfig.sys_log
    note : The storage engine for the table doesn't support repair
    dbispconfig.sys_remoteaction
    note : The storage engine for the table doesn't support repair
    dbispconfig.sys_session
    note : The storage engine for the table doesn't support repair
    dbispconfig.sys_theme
    note : The storage engine for the table doesn't support repair
    dbispconfig.sys_user
    note : The storage engine for the table doesn't support repair
    dbispconfig.web_backup
    note : The storage engine for the table doesn't support repair
    dbispconfig.web_database
    note : The storage engine for the table doesn't support repair
    dbispconfig.web_database_user
    note : The storage engine for the table doesn't support repair
    dbispconfig.web_domain
    note : The storage engine for the table doesn't support repair
    dbispconfig.web_folder
    note : The storage engine for the table doesn't support repair
    dbispconfig.web_folder_user
    note : The storage engine for the table doesn't support repair
    dbispconfig.web_traffic
    note : The storage engine for the table doesn't support repair
    dbispconfig.webdav_user
    note : The storage engine for the table doesn't support repair
    dbispconfig.xmpp_domain
    note : The storage engine for the table doesn't support repair
    dbispconfig.xmpp_user
    note : The storage engine for the table doesn't support repair
    Press enter to continue or CTRL-C to cancel the installation ..^C

    Then tring to select the sys_cron table using phpmyadmin rise this error in the screenshot
    Screenshot_2019-08-13_13-10-12.png

    here better image for debug
    2Screenshot_2019-08-13_13-16-47.png


    and finally in the console I have this error:
    -----------------
    Updating Crontab
    Restarting services ...
    Job for amavis.service failed because the control process exited with error code.
    See "systemctl status amavis.service" and "journalctl -xe" for details.
    Update finished.
    ---------------------------------

    Edit... ok the amavis servide wont astart for the name of server. I will fix it now
    Starting amavisd: The value of variable $myhostname is "video", but should have been a fully qualified domain name; perhaps uname(3) did not provide such. You must explicitly assign a FQDN of this host to variable $myhostname

    OK changed the hostname in /etc/hosts and /etc/hostname a la debian way, nos amavis is running.


    Now remain the problem in the database to solve.
     
  8. till

    till Super Moderator Staff Member ISPConfig Developer

    That's a bug in phpmyadmin, google for the error message and follow the instructions that you find there.
     
  9. maxlinux

    maxlinux New Member

    ok the phpmyadmin bug is now fixed and the ispConfig and system Os are upgraded to the last version.
    tnx.
    Tomorrow I will see if the backups of the sites will be done.
    So far, ispConfig has created a backup copy of itself in /var/backup during the software upgrade.
     
  10. maxlinux

    maxlinux New Member

    The backup still resists to work.
    This morning the backup copy had not yet been executed, and looking at the sys_cron table, I see that everything has been executed at a certain time, but the backup never.

    I will wait to 13.15 as indicated in the Next_run column.... why 13.15?

    Screenshot_2019-08-14_08-03-21.png

    Screenshot_2019-08-14_08-04-45.png

    Screenshot_2019-08-14_08-12-48.png

    Any idea?

    Below the report

    ---------------------------------------------------
    root@video:~# cat htf_report.txt

    ##### 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.1.14p2


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

    [INFO] php (cli) version is 7.2.19-0ubuntu***.***.***.***

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


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


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

    [INFO] I found the following web server(s):
    Apache 2 (PID 1771)
    [INFO] I found the following mail server(s):
    Unknown process (smtpd) (PID 6323)
    [INFO] I found the following pop3 server(s):
    Dovecot (PID 23556)
    [INFO] I found the following imap server(s):
    Dovecot (PID 23556)
    [INFO] I found the following ftp server(s):
    PureFTP (PID 23606)

    ##### LISTENING PORTS #####
    (only ()
    Local (Address)
    [anywhere]:995 (23556/dovecot)
    [localhost]:10023 (1226/postgrey)
    [localhost]:10024 (21486/amavisd-new)
    [localhost]:10025 (23529/master)
    [localhost]:10026 (21486/amavisd-new)
    [localhost]:10027 (23529/master)
    [anywhere]:587 (23529/master)
    [localhost]:11211 (894/memcached)
    [localhost]:6379 (964/redis-server)
    [anywhere]:110 (23556/dovecot)
    [anywhere]:143 (23556/dovecot)
    [anywhere]:465 (23529/master)
    ***.***.***.***:53 (23613/named)
    [localhost]:53 (23613/named)
    [anywhere]:21 (23606/pure-ftpd)
    ***.***.***.***:53 (506/systemd-resolve)
    [anywhere]:22 (963/sshd)
    ***.***.***.***:3478 (1581/turnserver)
    ***.***.***.***:3478 (1581/turnserver)
    ***.***.***.***:3478 (1581/turnserver)
    ***.***.***.***:3478 (1581/turnserver)
    [localhost]:3478 (1581/turnserver)
    [localhost]:3478 (1581/turnserver)
    [localhost]:3478 (1581/turnserver)
    [localhost]:3478 (1581/turnserver)
    ***.***.***.***:3479 (1581/turnserver)
    ***.***.***.***:3479 (1581/turnserver)
    ***.***.***.***:3479 (1581/turnserver)
    ***.***.***.***:3479 (1581/turnserver)
    [localhost]:3479 (1581/turnserver)
    [localhost]:3479 (1581/turnserver)
    [localhost]:3479 (1581/turnserver)
    [localhost]:3479 (1581/turnserver)
    [localhost]:953 (23613/named)
    [anywhere]:25 (6323/smtpd)
    [anywhere]:993 (23556/dovecot)
    *:*:*:*::*:995 (23556/dovecot)
    *:*:*:*::*:10023 (1226/postgrey)
    *:*:*:*::*:10024 (21486/amavisd-new)
    *:*:*:*::*:3306 (6791/mysqld)
    *:*:*:*::*:10026 (21486/amavisd-new)
    *:*:*:*::*:587 (23529/master)
    *:*:*:*::*:6379 (964/redis-server)
    [localhost]10 (23556/dovecot)
    [localhost]43 (23556/dovecot)
    *:*:*:*::*:8080 (1771/apache2)
    *:*:*:*::*:80 (1771/apache2)
    *:*:*:*::*:8081 (1771/apache2)
    *:*:*:*::*:465 (23529/master)
    *:*:*:*::*:53 (23613/named)
    *:*:*:*::*:21 (23606/pure-ftpd)
    *:*:*:*::*:22 (963/sshd)
    *:*:*:*::*:3478 (1581/turnserver)
    *:*:*:*::*:3478 (1581/turnserver)
    *:*:*:*::*:3478 (1581/turnserver)
    *:*:*:*::*:3478 (1581/turnserver)
    *:*:*:*::*:3479 (1581/turnserver)
    *:*:*:*::*:3479 (1581/turnserver)
    *:*:*:*::*:3479 (1581/turnserver)
    *:*:*:*::*:3479 (1581/turnserver)
    *:*:*:*::*:953 (23613/named)
    *:*:*:*::*:25 (6323/smtpd)
    *:*:*:*::*:443 (1771/apache2)
    *:*:*:*::*:993 (23556/dovecot)




    ##### IPTABLES #####
    Chain INPUT (policy ACCEPT)
    target prot opt source destination
    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-sshd (1 references)
    target prot opt source destination
    RETURN all -- [anywhere]/0 [anywhere]/0



    root@video:~#
     
  11. till

    till Super Moderator Staff Member ISPConfig Developer

    Probably that's the time you reset the table. Feel free to edit the time there manually.
     
  12. maxlinux

    maxlinux New Member

    Perfect!! all is working now!! TNX to all for the help
     

Share This Page