#1  
Old 30th December 2005, 18:58
deflin deflin is offline
Junior Member
 
Join Date: Sep 2005
Location: Netherlands
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default mail.policy

I'm still having problems to get my new mailserver working...
Now I'm getting errors about mail.policy in my logfiles. Since I can't receive mail (DNS is ok) I can't test my previous error...
Can anybody help me?

Dec 30 18:46:54 localhost amavis[1257]: (01257-02) lookup_sql: 1146, Table 'mail.policy' doesn't exist
Dec 30 18:46:54 localhost amavis[1257]: (01257-02) TROUBLE in check_mail: creating_partsdir FAILED: DBD::mysql::st execute failed: Table 'mail.policy' doesn't exist at (eval 38) line 238, <GEN11> line 8.
Dec 30 18:46:54 localhost amavis[1257]: (01257-02) PRESERVING EVIDENCE in /var/lib/amavis/amavis-20051230T184654-01257
Dec 30 18:46:54 localhost postfix/smtp[1294]: 7BB006E00C: to=<postmaster@oranga.nl>, relay=127.0.0.1[127.0.0.1], delay=56776, status=deferred (host 127.0.0.1[127.0.0.1] said: 451 4.5.0 Error in processing, id=01257-02, creating_partsdir FAILED: DBD::mysql::st execute failed: Table 'mail.policy' doesn't exist at (eval 38) line 238, <GEN11> line 8. (in reply to end of DATA command))
Dec 30 18:46:54 localhost amavis[1258]: (01258-02) lookup_sql: 1146, Table 'mail.policy' doesn't exist
Dec 30 18:46:54 localhost amavis[1258]: (01258-02) TROUBLE in check_mail: creating_partsdir FAILED: DBD::mysql::st execute failed: Table 'mail.policy' doesn't exist at (eval 38) line 238, <GEN11> line 8.
Dec 30 18:46:54 localhost amavis[1258]: (01258-02) PRESERVING EVIDENCE in /var/lib/amavis/amavis-20051230T184654-01258
Dec 30 18:46:54 localhost postfix/smtp[1275]: 348E16E012: to=<deflin@oranga.local>, relay=127.0.0.1[127.0.0.1], delay=1636, status=deferred (host 127.0.0.1[127.0.0.1] said: 451 4.5.0 Error in processing, id=01258-02, creating_partsdir FAILED: DBD::mysql::st execute failed: Table 'mail.policy' doesn't exist at (eval 38) line 238, <GEN11> line 8. (in reply to end of DATA command))
__________________
Assumption is the mother off all fuckups..
Reply With Quote
Sponsored Links
  #2  
Old 30th December 2005, 19:16
deflin deflin is offline
Junior Member
 
Join Date: Sep 2005
Location: Netherlands
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default

never mind. I think there was some kind of typo in my amavisd.conf. I copied the one in the howto (Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAssassin, ClamAV), restarted amavis and now it works :-)
__________________
Assumption is the mother off all fuckups..
Reply With Quote
  #3  
Old 20th March 2007, 16:43
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
 
Default

I've just got this email with the solution:

Quote:
Hi,

After reading for more than 2 days, I found what's missing from the standard
amavisd.conf, that's why amavisd writes to the logs:
"Table 'mail.policy' not found."

There are some forum's about this, nobody knows what's the problem.
I don't want to register to the forum, just let you know the problem.
Bye
I love your tutorials.
(http://www.howtoforge.com/forums/arc...hp/t-1877.html)


@lookup_sql_dsn =
( ['DBI:mysql:database=mail;host=127.0.0.1;port=3306' , 'mail_admin',
'mail_admin_password'] );



This is the missing line:

$sql_select_policy = 'SELECT "Y" as local FROM domains WHERE
CONCAT("@",domain) IN (%k)';
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
-ERR Maildir: No such file or directory deflin HOWTO-Related Questions 4 30th December 2005 23:47


All times are GMT +2. The time now is 02:32.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.