AtMail and SpamDB - Error in apache2 error.log

[TRANCEMANIAC]

Hi @ all,

we have a Ubuntu 8.04 LTS with Plesk 9.2.1 installed.
As webmail we use "AtMail 1.02".

We've check the "/var/log/apache2/error.log" and there a many entries like this

SQL Error = (select SpamEmail from SpamDB_j where Account=?)DB Error: no such table - select SpamEmail from SpamDB_j where Account='[email protected]' [nativecode=1146 ** Table 'atmail.SpamDB_j' doesn't exist]
SQL Error = (select SpamEmail from SpamDB_e where Account=?)DB Error: no such table - select SpamEmail from SpamDB_e where Account='[email protected]' [nativecode=1146 ** Table 'atmail.SpamDB_e' doesn't exist]

Ok i understand, that the tables not exist, but the question is: "How can we fix it?"

There are only the following tables in the DB atmail:

atmail (210)

* AbookGroup_a
* AbookGroup_b
* AbookGroup_c
* AbookGroup_d
* AbookGroup_e
* AbookGroup_f
* AbookGroup_g
* AbookGroup_h
* AbookGroup_i
* AbookGroup_j
* AbookGroup_k
* AbookGroup_l
* AbookGroup_m
* AbookGroup_n
* AbookGroup_o
* AbookGroup_other
* AbookGroup_p
* AbookGroup_q
* AbookGroup_r
* AbookGroup_s
* AbookGroup_shared
* AbookGroup_t
* AbookGroup_u
* AbookGroup_v
* AbookGroup_w
* AbookGroup_x
* AbookGroup_y
* AbookGroup_z
* AbookPermissions
* Abook_a
* Abook_b
* Abook_c
* Abook_d
* Abook_e
* Abook_f
* Abook_g
* Abook_h
* Abook_i
* Abook_j
* Abook_k
* Abook_l
* Abook_m
* Abook_n
* Abook_o
* Abook_other
* Abook_p
* Abook_q
* Abook_r
* Abook_s
* Abook_shared
* Abook_t
* Abook_u
* Abook_v
* Abook_w
* Abook_x
* Abook_y
* Abook_z
* Accounts
* Domains
* EmailDatabase_a
* EmailDatabase_b
* EmailDatabase_c
* EmailDatabase_d
* EmailDatabase_e
* EmailDatabase_f
* EmailDatabase_g
* EmailDatabase_h
* EmailDatabase_i
* EmailDatabase_j
* EmailDatabase_k
* EmailDatabase_l
* EmailDatabase_m
* EmailDatabase_n
* EmailDatabase_o
* EmailDatabase_other
* EmailDatabase_p
* EmailDatabase_q
* EmailDatabase_r
* EmailDatabase_s
* EmailDatabase_t
* EmailDatabase_u
* EmailDatabase_v
* EmailDatabase_w
* EmailDatabase_x
* EmailDatabase_y
* EmailDatabase_z
* EmailMessage_a
* EmailMessage_b
* EmailMessage_c
* EmailMessage_d
* EmailMessage_e
* EmailMessage_f
* EmailMessage_g
* EmailMessage_h
* EmailMessage_i
* EmailMessage_j
* EmailMessage_k
* EmailMessage_l
* EmailMessage_m
* EmailMessage_n
* EmailMessage_o
* EmailMessage_other
* EmailMessage_p
* EmailMessage_q
* EmailMessage_r
* EmailMessage_Reply
* EmailMessage_s
* EmailMessage_t
* EmailMessage_u
* EmailMessage_v
* EmailMessage_w
* EmailMessage_x
* EmailMessage_y
* EmailMessage_z
* EmailUIDL_a
* EmailUIDL_b
* EmailUIDL_c
* EmailUIDL_d
* EmailUIDL_e
* EmailUIDL_f
* EmailUIDL_g
* EmailUIDL_h
* EmailUIDL_i
* EmailUIDL_j
* EmailUIDL_k
* EmailUIDL_l
* EmailUIDL_m
* EmailUIDL_n
* EmailUIDL_o
* EmailUIDL_other
* EmailUIDL_p
* EmailUIDL_q
* EmailUIDL_r
* EmailUIDL_s
* EmailUIDL_t
* EmailUIDL_u
* EmailUIDL_v
* EmailUIDL_w
* EmailUIDL_x
* EmailUIDL_y
* EmailUIDL_z
* Filter
* Folders
* Groups
* Log_Error
* Log_Login
* Log_RecvMail
* Log_SendMail
* Log_SMS
* Log_Spam
* Log_Virus
* MailSort_a
* MailSort_b
* MailSort_c
* MailSort_d
* MailSort_e
* MailSort_f
* MailSort_g
* MailSort_h
* MailSort_i
* MailSort_j
* MailSort_k
* MailSort_l
* MailSort_m
* MailSort_n
* MailSort_o
* MailSort_other
* MailSort_p
* MailSort_q
* MailSort_r
* MailSort_s
* MailSort_t
* MailSort_u
* MailSort_v
* MailSort_w
* MailSort_x
* MailSort_y
* MailSort_z
* MailThreads
* SpellCheck
* UserPermissions
* Users
* UserSession
* UserSettings_a
* UserSettings_b
* UserSettings_c
* UserSettings_d
* UserSettings_e
* UserSettings_f
* UserSettings_g
* UserSettings_h
* UserSettings_i
* UserSettings_j
* UserSettings_k
* UserSettings_l
* UserSettings_m
* UserSettings_n
* UserSettings_o
* UserSettings_other
* UserSettings_p
* UserSettings_q
* UserSettings_r
* UserSettings_s
* UserSettings_t
* UserSettings_u
* UserSettings_v
* UserSettings_w
* UserSettings_x
* UserSettings_y
* UserSettings_z

The effect is that the spamdirectory in the webmailer is not working.

Hope somebody can help.

Geetings,

TRANCEY

 

[TRANCEMANIAC]

Solved: AtMail and SpamDB - Error in apache2 error.log

I solved it by my self.

On Unbuntu you can reinstall the SpamAssasin on commandline to fix the problem.

aptitude reinstall psa-spamassassin

After this the spamfolder in AtMail is working right.


TRANCEY

 

[m0rpheu5]

i have the same problem, and i have spamassassin installed, and my plesk license doesn´t have support for spamassassin, if i install the psa-spamassassin, won´t get error with my spamassassin already installed?

Thanks

 

[m0rpheu5]

don´t work for me, i remove the psa-spamassassin, and install it again using yum remove and yum install, and nothing changes.

SQL Error = (select SpamEmail from SpamDB_m where Account=?)DB Error: no such ta ble - select SpamEmail from SpamDB_m where Account='[email protected]' [na tivecode=1146 ** Table 'atmail.SpamDB_m' doesn't exist]
SQL Error = (select SpamEmail from SpamDB_m where Account=?)DB Error: no such ta ble - select SpamEmail from SpamDB_m where Account='[email protected]' [na tivecode=1146 ** Table 'atmail.SpamDB_m' doesn't exist]


what i need to do to fix this?

Thanks

 

[IgorG]

You can try to create this missing table with:

CREATE TABLE SpamDB_m (SpamEmail varchar(64) DEFAULT '' NOT NULL, Account varchar(64) DEFAULT '' NOT NULL, KEY iSpamEmail (SpamEmail));

But I'm not sure that it will help. Another possible reason can be fact that installed version of atmail did not fit to you OS.
You can check it with

rpm -qa | grep atmail

and compare OS of this package with output of:

cat /etc/redhat-release

Please install correct version of psa-atmail package if it is different. It will help.

 

[humpy]

same problem

Hi,
I am experiencing the same problem,
[root@vps01 ~]# rpm -qa | grep atmail
psa-atmail-1.02-cos5.build95101209.05
[root@vps01 ~]# cat /etc/redhat-release
CentOS release 5.5 (Final)

is that correct versions?
thanks
w.

 

[IgorG]

Yes, according to http://64.131.90.31/PSA_9.5.4/dist-rpm-CentOS-5-i386/opt/atmail/ it is correct version for latest Plesk version 9.5.4

 

[humpy]

thank you..
would you have any suggestions for fixing the error in my case then please?

 

[humpy]

also, randomly emails being opened in atmail in random accounts simply show as totally blank... any suggestions to fix THAT problem as well?

 

[humpy]

Ignore the blank email querstion, that was found to be from OOM error. Howevr, despite having correct version of Atmail and OS together , and also after reinstaling both psa-spamassasin and atmail in hopes of fixing the problem, I am still getting the errors...

SQL Error = (select SpamEmail from SpamDB_a where Account=?)DB Error: no such table - select SpamEmail from SpamDB_a where Account='[email protected]' [nativecode=1146 ** Table 'atmail.SpamDB_a' doesn't exist]
SQL Error = (select SpamEmail from SpamDB_r where Account=?)DB Error: no such table - select SpamEmail from SpamDB_r where Account='[email protected]' [nativecode=1146 ** Table 'atmail.SpamDB_r' doesn't exist]
SQL Error = (select SpamEmail from SpamDB_r where Account=?)DB Error: no such table - select SpamEmail from SpamDB_r where Account='[email protected]' [nativecode=1146 ** Table 'atmail.SpamDB_r' doesn't exist]

 

[IgorG]

Try to fix it with attached file and following command:

m

ysql -uatmail -p`cat /etc/psa-webmail/atmail/.atmail.shadow` atmail < db.mysql

 

[humpy]

that seems to have fixed things!
cheers

 

[humpy]

Sorry, I was mistaken on the OOM issue causing blank emails. I have no longer any memory issues, but random emails in Atmail simply show as blank. About 1-2 a day... If i use mail2web.com to access the account, the emails showing as blank viewable. Go back to Atmail again.. they still open as totally blank...

It is always the same email that is blank each time too, when returning and logging into ATMAil.. once a random email opens as blank, it forever after opens as blank..( it is not simply every an "every 10th email opened" type thing )

The emails that stay blank however, ARE random in that its there is no pattern to who the email is sent from, it is a total lottery which one wont work..

Correct version Atmail for the OS too.