alexalmazan.com

Plesk Spamassassin permits the establishment of ‘personal settings’ for individual configured mail users. Problems arise as the default configure ‘required_score’ value for calssifying spam defaults to ‘7’. This is a quick means of changing the score for all hosted mail users from 7.00 to 4.00:

Get to the SQL CLI as the Plesk admin user and inspect the current established settings

[root@server1 log]# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa

Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7578332 to server version: 4.0.18-Max

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select * from spamfilter_preferences where preference='required_score';

This should display all user settings. You may have to issue something similar to the following query to get those with a score of 4.00 or higher

mysql> select * from spamfilter_preferences where preference='required_score'&& value != '4.00';

Use an update statement to change the values in the database table

mysql>  update spamfilter_preferences set value='4.00' where value='7.00';

It is also adviseable to set spamassassin to reject messages tagged as spam. To do so, issue the following via the SQL cli.

mysql>update spamfilter set reject_spam='true' where reject_spam='false';

Once this is all in place, you must use ‘mchk’ to re-issue the .qmail files

[root@server1 log]#/usr/local/psa/admin/bin/mchk --with-spam

Once this is finished, issue

[root@server1 log]#service qmail restart && service psa-spamassassin restart && service xinetd restart && service courier-imap restart 

The scores should now be at the value selected.

To install on your site an application written in Ruby:

1. On your Home page, select the domain name you need, then, under Hosting, click Setup.

2. Select the CGI and FastCGI check boxes, and click OK.

3. Connect to your FTP account, change to the httpdocs directory.

4. Upload the application files to the httpdocs/ directory.

5. Create a file with name .htaccess in this directory, open it with a text editor of your choice and add the following lines into the file:

RewriteEngine On
RewriteRule ^$ /public/index.html [L]
RewriteCond %{REQUEST_URI} !^/public
RewriteRule ^(.*)$ /public/$1 [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule ^(.*)$ public/dispatch.fcgi/$1 [QSA,L]

6. Save the file.

7. Remove the file public/.htaccess

8. Open the file public/dispatch.fcgi with a text editor and put the following lines there

#!/usr/bin/ruby

9. Save the file.

Now the web application will be accessible at the following URL: http://yourdomain.com/.

Two methods for rebuilding the qmail queue.

First stop Qmail

# /etc/init.d/qmail stop

or

service qmail stop

# cd /var/qmail/queue
# rm -rf info intd local mess remote todo

Create the necessary directories

# mkdir mess
# for i in `seq 0 22`; do
# mkdir mess/$i
# done
# cp -r mess info
# cp -r mess intd
# cp -r mess local
# cp -r mess remote
# cp -r mess todo

assign nexessary attributes

# chmod -R 750 mess todo
# chown -R qmailq:qmail mess todo
# chmod -R 700 info intd local remote
# chown -R qmailq:qmail intd
# chown -R qmails:qmail info local remote

Finally start Qmail

# /etc/init.d/qmail start

or

service qmail start

Here is the alternate method

http://kb.swsoft.com/en/252

Provided is a means of reducing the Time to Live for Plesk DNS services

mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa

Then at the MySQL prompt enter:

INSERT INTO misc VALUES ('SOA_TTL','300');

That will make any new zones created have a TTL of 300. If you then want to re-write all your current DNS zones with the new TTL, you can run this command:

mysql -Ns -uadmin -p`cat /etc/psa/.psa.shadow` -D psa -e 'select name from domains' | awk '{print "/usr/local/psa/admin/sbin/dnsmng update " $1 }' | sh

This will take a few minutes to complete in most cases. Once complete, your domains will have a TTL of 300