I deleted a server from ispconfig by mistake. How can I restore the entry? I simply hit the red garbage pail for the wrong server. Yes, I do feel like a moron.
ISPConfig creates nightly backups when you use a recent version, these include a backup of the whole database, they are in the folder /var/backup/ispconfig/. You could e.g. create a new database with phpmyadmin, restore the ispconfig database sql dump from the backup there, then export the deleted server record (it is in the table named "server") as sql, and then run this sql query in your dbispconfig database.
Thanks. I downloaded the backup .sql file, opened it as text, searched for the server name in the `server` table entry, and copied the INSERT INTO `server` entry for the server. Then connected to the existing ispconfig db in the terminal and ran the INSERT INTO `server` command. Seems to have worked. I can see the server listed, sites, mail etc. But the propagating changes dialog is stuck with the message "The following changes are not yet populated to all servers:" and 134 changes. Dovecot won't start either with the message "Can't open file /etc/postfix/smtpd.key" When I deleted the server, did I simply delete the entry for the server or were there other tables affected?
The dovecot problem appears to have been caused by the '<' character in these lines in /etc/dovecot/dovecot.conf: Code: ssl_cert = </etc/postfix/smtpd.cert ssl_key = </etc/postfix/smtpd.key ssl_dh = </etc/dovecot/dh.pem Removing the < let dovecot start. The suggestion was here: https://dovecot.org/mailman3/archiv....org/thread/ABIRMK7RQRHE5P7BCKQCYFWAF6OQ3XJA/ Unfortunately, when the email client tries to connect, I see this error: Code: pop3-login: Error: Failed to initialize SSL server context: Can't load SSL certificate (ssl_cert setting): There is no valid PEM certificate.
Does this server use Debian 13 and Dovecot 2.4? If not, the dovecot ssl lines must include <. According to Have you checked if /etc/postfix/smtpd.key exists as a symlink? Did you maybe try to change the SSL cert of the mail server?
It's definitely Ubuntu 24.04.4 LTS. And with those unmatched < in dovecot.conf, dovecot won't start. /etc/postfix/smtpd.key exists as a symlink, though it points to the mail server of one of the hosted sites, not to the server or the FQDN of the server. The symlink was created in April of last year. Code: 54 Apr 23 2025 smtpd.key -> /root/.acme.sh/mail.hosted.net/mail.hosted.key . . . 48 Mar 3 02:29 smtpd.cert -> /usr/local/ispconfig/interface/ssl/ispserver.crt The client can pop mail using either the server's mailserver or the hosted site's but cannot send mail without SSL. It complains: Code: Outgoing server (SMTP) error. The server responded: TLS not available due to local problem. Thanks very much for your help. Especially appreciated since I created this problem through inattention.
Then the < must be in place. The reason it does not start is not the <, it seems dovecot is not able to read the SSL cert or key, which you changed to point to a site. It is geneally ok that you use an ssl site cert and key, but something must be wrong there.
