I am sure most of you had a problem where you have thousands of mail going through your server but you cant pinpoint from which IP address they are coming from or from which authenticated smtp user of yours is the naughty one. This is because these information is not shown clearly in H-Sphere's mail logs. In this article you can find a tiny plugin for the qmail-spp system which you can use to pinpoint these information.

There are many guides on H-Sphere forums about how to use open_basedir and safe_mode however they usually include cumbersome settings and alterations on H-Sphere files which are not practical. Here you can find how I solved the problem, the simple way. (Updated for H-Sphere 3.1 or newer)

Probably we all had the problem where we increased the traffic limit for a plan sometime after having hundreds of users using the plan. If you do not increase the traffic limit for each user  then your users will pay usage fees even if their usage is between the old preset value and the new preset value.

So we must increase the  limits for all the users using our plans to match the plan limits set. But only if the user's preset limit is lower than the current plan limit. If a user set their limit very high, so they wont pay extra usage fees, we shouldnt lower their limits!

Below is the SQL command which will accomplish this task for the main plans, if you want to do it for one of your resellers, please change the reseller_id=1 to suit to the reseller ID in question.

update traffics set tt_size=float8(plan_value.value) from parent_child,accounts,plan_value where parent_child.child_type=121 and parent_child.account_id=accounts.id and traffics.id=parent_child.child_id and plan_value.plan_id=accounts.plan_id and plan_value.name='_FREE_UNITS_' and plan_value.type_id=121 and float8(traffics.tt_size)<float8(plan_value.value) and accounts.reseller_id=1;

After issuing the command above in your SQL server, you must restart your CP process!

This is the quick guide for enabling SSL on H-Sphere mail servers.