Ramblings from MostlyChris

Suppose you would like to send a copy of an incoming email to another account while the email still goes to the original account. You can do this by modifying the .qmail file of the original recipient and adding an entry that looks like the following:

On a Plesk server, a full .qmail file with the above changes looks like this:

Keep in mind that if you do this on a Plesk server, these changes will be overwritten with mchk or upgrades so you will have to take measures to deal with this. I set the files immutable so they can't be changed by Plesk. This causes its own problems so you will have to decide if it is worth it.

If you need to change the TTLs on all domains in Plesk at once, you can massage the database with the following command:

Substitute the TTL values for what you need. Since the flat files are still used by named to provide DNS resolution, those will need to be updated as well. This command will do the trick:

I had occassion to run across the following question recently:

"Plesk was just upgraded to version 9.2.x and all domains now have an overuse policy set to not allow overuse. I can manually change this to allow overuse, but is there a way to do this through the database so I don't have to do it a domain at a time?".

The answer is yes, sort of. Plesk provides a 'domain_pref' utility that allows the setting of many of the parameters related to domain preferences. This allows one to change parameters for domains using the command line instead of logging into the interface. It works on one domain at a time, so some scripting foo is necessary in order to accomplish this on multiple domains.

In regards to the overuse policy, this handy little one-liner will allow the updating of all domains to a specific overuse policy.

There are three options available for the overuse policy.

• Block: Do not allow overuse
• Notify: Allow overuse and notify the domain administrator when overuse has occurred.
• Normal: Allow overuse with no notification.

The script above does the following things:
1. Connects to the Plesk database and selects a list of all domains from the 'domains' table.
2. Runs the 'domain_pref' CLI and sets the overuse policy to 'block'.

It has also come to my attention that the clients will have to have their overuse policy set as well.

As always, BACK UP the psa database before doing anything with the CLI.

There are times when you may need to migrate many IP addresses in Plesk. You could either do this by hand, one domain at a time or you can modify the database by hand which will save countless years of your life.

I will assume you have logged into mysql and have selected the psa database. After logging in, get a listing of IP addresses. Make sure that you have read the new IP addresses into Plesk by first logging into the control panel and performing a "Reread IP".

You will see a list of id numbers in the first column followed by the addresses in the second column. Perform the modification of the component_id table.

Then update the hosting table.

Finally, update the forwarding table if necessary.

Once this is done, check the IP section in Plesk and everything should be moved.

First, copy the smtp_psa file.

Edit the newly copied file and replace the first line. Replace 'service smtp' with 'service submission'

Restart xinetd.d

Check that port 587 is listening on the server