Admin Guide

You do not need to be root to do these routine tasks.

Create a new account:

$ kicsadmin newaccount

You will be prompted for a login name to use for the new account, the domain name (use "loginname.kics.bc.ca" if it's a nonprofit account and they don't have their own domain name), and how much they wanted to pay for their membership fee (for nonprofit accounts only), technical/admin email addresses, and a billing phone number for the billing database.

Do not add accounts unless the signup form has been submitted.

Add a subdomain to an existing account:

$ kicsadmin newsubdomain foobar.existingdomain.com

The account that controls existingdomain.com will get a directory called foobar.existingdomain.com and http://foobar.existingdomain.com will show whatever they put in there.

Add a domain name to an existing account:

$ kicsadmin newaliasdomain

You will be prompted for the old and new domain names. The new domain name will behave exactly the same as the existing domain name.

Create a database for the foobar account:

$ kicsadmin newdatabase foobar

Create another database for the foobar account called foobar_example:

$ kicsadmin newdatabase foobar_example

Some people want multiple databases to prevent different pieces of canned software from conflicting with one another. Every subsequent database in the foobar account is called foobar_something, so it's easy for admins and scripts to tell which databases belong to which user.

The foobar_example database will use the same mysql username and password as the main foobar database.

Find out why a message was rejected by the spam filter:

Find the message in "rejected messages" log. The last 400 megabytes of /var/loq/filter will give you about a month and a half of logs and each line should include the sender and recipient address.

$ tail -c400000000 /var/log/qfilter | grep firepro | grep vodafone
Tue May 11 06:12:51 2010 qfilter-badcontent: 31 dukasy7137@vodafone.it score=19.9 to fireprotech@ingenioussoftware.net_

"score=19.9" means the message was rejected because it exceeded the spam score threshold (which is 6.1 as determined by /var/qmail/filter/qfilter-badcontent).

$ tail -c400000000 /var/log/qfilter | grep sk2.ca | grep snosuit
Thu Jun 3 10:08:39 2010 qfilter-badcontent: 31 Received: from unknown (HELO crosslake.net) (204.72.181.7) chris@snosuit.com dealz to scarlet@sk2.ca_

This message was rejected because it matched a phrase blacklisted in /var/qmail/control/badcontent, in this case "dealz".

In general, the format is

{timestamp} {filter-program} {reject-code} {received-line} {sender} {offending-phrase} to {recipient}

Add an email address to the spam filter's whitelist:

1. Log in to pie.tomclegg.net
2. Edit /etc/spamassassin/local.cf -- add a line like "whitelist_from ciscocanada@techsoup.org" or "whitelist_to tom@tomclegg.net" (see existing examples in that file)
3. Notify spamassassin that the config has changed: sudo svc -h /service/spamd
4. Check its log file to make sure it restarted itself correctly: tail -f /service/spamd/log/main/current