If you lost your ISPConfig 3 administrator password, you can reset it with the following SQL query. UPDATE sys_user SET passwort = md5('admin') WHERE username = 'admin'; The SQL query sets the password to "admin" for the user "admin", it has to be executed in the ISPConfig mysql database, e.g. with phpmyadmin. If you dont ... Read more
When you reorganize the structure of a website, you might want to redirect requests to files in a old folder to a new one without loosing the pagerank. In this example, I will redirect all requests from directory "olddir" to directory "newdir", so that requests like http://www.yourdomain.tld/olddir/page.htm get redirected to http://www.yourdomain.tld/newdir/page.htm without loosing the Google pagerank ... Read more
A copy of a incoming email can be sent to a second email address by adding a cc command to the "Custom Rules" field of the mailbox in ISPConfig. ISPConfig supports sieve as well as maildrop filter rules. The rule language depends on the LDA / POP3 / IMAP-Daemon that you use on your server. ... Read more
The following guide shows how to disable and remove mysql replication from two or more mysql servers. These steps can be used for master/slave and master/master mysql setups. The following SQL commands have to be be executed in phpmyadmin or with the mysql commandline program. It is just important that you are logged in as ... Read more
The following guide describes the steps to add DNS records that route emails from a domain managed in ISPConfig 3 to google apps / gmail. The guide assumes that you have already setup the dns zone for your domain in ispconfig. Login to ISPConfig, click on the DNS module icon in the upper navigation bar, ... Read more
The command below enables a stricter SPAM handling for postfix on ISPConfig 3 servers. In Detail: Reject sender hostnames with invalid syntax Reject sender hostnames that are no fully qualified domains (e.g. reject "server1" but allow server1.domain.tld) Reject sender domains that have no DNS records Check sender IP addresses against realtime blacklists. First make a ... Read more
As of ISPConfig 3.0.4, the text of the welcome email message that is sent to new email accounts is stored in the folder /usr/local/ispconfig/server/conf/mail/. The message has this format: ------------------------------------------------------------------------ From: ISPConfig <postmaster@localhost.localdomain> Subject: Welcome to your new email account. Welcome to your new email account. Your webmaster. ------------------------------------------------------------------------ The first line starts with "From: ... Read more
You might see the error: postfix/master[5309]: fatal: 0.0.0.0:smtps: Servname not supported for ai_socktype On a OpenSuSE server when you enable smtps in postfix master.cf file. The reason for the error is that the definition of the smtps port in /etc/services is missing. Solution Edit the /etc/services file vi /etc/services and add the following lines: smtps ... Read more
To create new SSL certificates for the dovecot pop3 and imap server on Ubuntu, follow these steps: Make a backup copy of the old key and certificate file sudo cp /etc/ssl/private/dovecot.key /etc/ssl/private/dovecot.key.old sudo cp /etc/ssl/certs/dovecot.pem /etc/ssl/certs/dovecot.pem.old Create the new key file openssl genrsa -out /etc/ssl/private/dovecot.key 1024 Create the new certificate file, valid for 2 years ... Read more
If you use a mailserver wil very low ram (< 500 MB) and a slow CPU then it might be nescessary to disable the spam- and antivirus filter functions in ISPConfig 3 as amavisd and clamav might be too heavy for your server hardware. The steps to disable clamav and amavisd are: Edit postfix main.cf ... Read more