Slow MailScanner

[Dhawal Doshy]

Jay Chandler wrote:
> Dhawal Doshy wrote:
>> Jay Chandler wrote:
>>> Dhawal Doshy wrote:
>>>> [snippetry]
>>>>
>>>> For the caching nameserver a low-end box with a gig (or 2) ram 
>>>> thrown in and good connectivity would be great. You could also 
>>>> simply install the caching-nameserver RPM if you are on redhat/centos..
>>>>
>>>> - dhawal
>>> Very interesting. Should the caching nameserver be run on the 
>>> mailservers themselves, or on a different box, and the sole 
>>> nameserver entry for this box would be the caching box?
>>
>> if you can afford a separate server as mentioned above.. great!! else 
>> run a local cache with say 100MB size.
>>
>>> Building the MySQL server up now...
>>
>> cool.. give extra attention to the 'bayes_sql_override_username' 
>> parameter.. that is where most users get stuck. The old jiscmail link 
>> no longer works.. use this one instead:
>> http://article.gmane.org/gmane.mail.virus.mailscanner/29437
>>
>> - dhawal
> Funny you should mention that!
> 
> Followed the Wiki precisely, but got this error:
> 
> [99745] dbg: bayes: using username: root
> [99745] dbg: bayes: database connection established
> [99745] dbg: bayes: found bayes db version 3
> [99745] dbg: bayes: unable to initialize database for root user, aborting!
> 
> I haven't yet found a fix.  The root user has a password assigned 
> (particularly from remote machines!) that I haven't put into the 
> config.  If you can point me to a fix I'll gladly update the wiki.
> 

 From TFL.. http://article.gmane.org/gmane.mail.virus.mailscanner/29437

mysql> SELECT id, username, spam_count, ham_count, token_count FROM 
bayes_vars;
+----+----------+------------+-----------+-------------+
| id | username | spam_count | ham_count | token_count |
+----+----------+------------+-----------+-------------+
|  2 | root     |     190707 |    168166 |      124113 |
|  3 | apache   |          0 |         0 |           0 |
+----+----------+------------+-----------+-------------+
2 rows in set (0.02 sec)

Maybe you'll also see a postfix line there.. use the one which has the 
most tokens.