Hi, my system was working fine before I've changed the system backup hour. After I noticed that the list of domain was empty and the same happend in the list of email. All server services was active. Checking the database, I noticed that the server table was empty!!! In the server table I insert the new field following the similar configuration server, and I see again all service and all email! Everything seems OK but When I tried to add new account ftp or new account mysql or new account email they don't seem to work. In the control panel I see the list of new account but they don't work. I check the db table (ftp_user or web_database_user) and all it's ok, the new account is insert in to the tables. I put the ispcontrol in debug mode, I see only this messagges : 2017-03-28 13:11 server1.XXXXX.it Debug Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock 2017-03-28 13:11 server1.XXXXX.it Debug Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'. Who could help me? Thanks in advaced my system: debian_version: 8.7 ISPconfig : ISPConfig 3.1.2 ##### SERVER ##### IP-address (as per hostname): ***.***.***.*** IP-address(es) (as per ifconfig): ***.***.***.***, ***.***.***.*** [WARN] ip addresses from hostname differ from ifconfig output. Please check your ip settings. [INFO] ISPConfig is installed. ##### ISPCONFIG ##### ISPConfig version is 3.1.2 ##### VERSION CHECK ##### [INFO] php (cli) version is 5.6.30-0+deb8u1 [INFO] php-cgi (used for cgi php in default vhost!) is version 5.6.30-0+deb8u1 ##### PORT CHECK ##### ##### MAIL SERVER CHECK ##### ##### RUNNING SERVER PROCESSES ##### [INFO] I found the following web server(s): Apache 2 (PID 5803) [INFO] I found the following mail server(s): Postfix (PID 1271) [INFO] I found the following pop3 server(s): Dovecot (PID 616) [INFO] I found the following imap server(s): Unknown process (init) (PID 1) [INFO] I found the following ftp server(s): PureFTP (PID 20427) ##### LISTENING PORTS ##### (only () Local (Address) [anywhere]:21 (20427/pure-ftpd) ***.***.***.***:53 (605/named) ***.***.***.***:53 (605/named) [localhost]:53 (605/named) [anywhere]:41525 (582/rpc.statd) [anywhere]:22 (606/sshd) [anywhere]:25 (1271/master) [localhost]:953 (605/named) [anywhere]:993 (1/init) [anywhere]:995 (616/dovecot) [localhost]:10023 (730/postgrey.pid) [localhost]:10024 (13356/amavisd-new) [localhost]:10025 (1271/master) [localhost]:10026 (13356/amavisd-new) [localhost]:3306 (939/mysqld) [localhost]:10027 (1271/master) [anywhere]:587 (1271/master) [localhost]:11211 (603/memcached) [anywhere]:110 (616/dovecot) [anywhere]:143 (1/init) [anywhere]:111 (553/rpcbind) [anywhere]:465 (1271/master) *:*:*:*::*:21 (20427/pure-ftpd) *:*:*:*::*:53 (605/named) *:*:*:*::*:22 (606/sshd) *:*:*:*::*:25 (1271/master) *:*:*:*::*:953 (605/named) *:*:*:*::*:443 (5803/apache2) *:*:*:*::*:993 (1/init) *:*:*:*::*:995 (616/dovecot) *:*:*:*::*:46214 (582/rpc.statd) *:*:*:*::*:10023 (730/postgrey.pid) *:*:*:*::*:10024 (13356/amavisd-new) *:*:*:*::*:10026 (13356/amavisd-new) *:*:*:*::*:587 (1271/master) [localhost]10 (616/dovecot) [localhost]43 (1/init) [localhost]11 (553/rpcbind) *:*:*:*::*:8080 (5803/apache2) *:*:*:*::*:80 (5803/apache2) *:*:*:*::*:8081 (5803/apache2) *:*:*:*::*:465 (1271/master) ##### IPTABLES ##### Chain INPUT (policy ACCEPT) target prot opt source destination fail2ban-postfix-sasl tcp -- [anywhere]/0 [anywhere]/0 multiport dports 25 fail2ban-dovecot-pop3imap tcp -- [anywhere]/0 [anywhere]/0 multiport dports 110,995,143,993 fail2ban-pureftpd tcp -- [anywhere]/0 [anywhere]/0 multiport dports 21 fail2ban-ssh 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 fail2ban-dovecot-pop3imap (1 references) target prot opt source destination RETURN all -- [anywhere]/0 [anywhere]/0 Chain fail2ban-postfix-sasl (1 references) target prot opt source destination RETURN all -- [anywhere]/0 [anywhere]/0 Chain fail2ban-pureftpd (1 references) target prot opt source destination RETURN all -- [anywhere]/0 [anywhere]/0 Chain fail2ban-ssh (1 references) target prot opt source destination REJECT all -- ***.***.***.*** [anywhere]/0 reject-with icmp-port-unreachable REJECT all -- ***.***.***.*** [anywhere]/0 reject-with icmp-port-unreachable RETURN all -- [anywhere]/0 [anywhere]/0
If yu updated ISPConfig on this server anytime before this issue, then there should be a backup of the table available in /var/backup/. You can use the sql file that you find there, search for the insert statement of the server table and use that to recreate the missing server record of your server with the exact values that are correct for this system. It is important that the server_id is the same.
Hi, I don't updated the ISPConfig, I haven't a backup in /var/backup/. Certainly The server_id is 1, it was only one and I don't modify it. what could I do? Thanks
