• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

AtMail and SpamDB - Error in apache2 error.log

T

TRANCEMANIAC

Guest
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

Code: 
SQL Error = (select SpamEmail from SpamDB_j where Account=?)DB Error: no such table - select SpamEmail from SpamDB_j where Account='mailname@domain.ltd' [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='mailname@domain.ltd' [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:
Code: 
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
 
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.

Code: 
aptitude reinstall psa-spamassassin

After this the spamfolder in AtMail is working right.


TRANCEY
 
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
 
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='moisesdias@radiomais.am' [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='moisesdias@radiomais.am' [na tivecode=1146 ** Table 'atmail.SpamDB_m' doesn't exist]


what i need to do to fix this?

Thanks
 
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));
Click to expand...

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
Click to expand...

and compare OS of this package with output of:

cat /etc/redhat-release
Click to expand...

Please install correct version of psa-atmail package if it is different. It will help.
 
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.
 
thank you..
would you have any suggestions for fixing the error in my case then please?
 
also, randomly emails being opened in atmail in random accounts simply show as totally blank... any suggestions to fix THAT problem as well?
 
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='aileen@drewinternational.com.au' [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='royg@otechaustralia.com.au' [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='royg@otechaustralia.com.au' [nativecode=1146 ** Table 'atmail.SpamDB_r' doesn't exist]
 
Try to fix it with attached file and following command:

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

Attachments

  • db.zip
    312 bytes · Views: 32
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.
 
You must log in or register to reply here.

Similar threads

M
Issue Outgoing Mail Control is always 0
Replies
1
Views
371
MarketPC
M
V
Resolved RoundCube error : Oops... something went wrong!
Replies
3
Views
6K
Peter Debik
P
M
Issue Plesk Update 18.0.34 to 18.0.57 Database 'psa' not found
Replies
10
Views
3K
musa.sc
M
T
Question Error when trying to change IP to dedicated
Replies
1
Views
1K
scsa20
scsa20
Ehud
Question Possible BUG / Has Plesk CHANGED the Plesk Fire Wall data base configuration, and if so, what is the new one?
Replies
2
Views
1K
Ehud
Ehud
Back
Top