Results 1 to 10 of 11

Thread: cbpolicyd - no such table: amavis_rules)

Hybrid View

  1. #1
    Join Date
    Jul 2008
    Posts
    30
    Rep Power
    7

    Default cbpolicyd - no such table: amavis_rules)

    Hello friends.


    I'm using cbpolicyd, however the settings Amavis Seasons specific giving the following error as soon as I click save.


    Array ([0] => HY000 [1] => 1 [2] => no such table: amavis_rules)


    What can I do to resolve?


    Thank you!

  2. #2
    Join Date
    May 2007
    Location
    Zimbra
    Posts
    1,285
    Rep Power
    10

    Default

    You fail to note your version of ZCS, but there are some significant fixes to cbpolicyd in ZCS 8.0.4.
    Quanah Gibson-Mount
    Server Architect
    Zimbra, Inc
    --------------------
    Zimbra :: the leader in open source messaging and collaboration

  3. #3
    Join Date
    Jul 2008
    Posts
    30
    Rep Power
    7

    Default

    My version of Zimbra is 8.0.3


    Do not leave any patch fix before?

  4. #4
    Join Date
    May 2007
    Location
    Zimbra
    Posts
    1,285
    Rep Power
    10

    Default

    You can create the amavis DB via sqlite using the database schema in /opt/zimbra/cbpolicyd/share/database/amavis.tsql
    Quanah Gibson-Mount
    Server Architect
    Zimbra, Inc
    --------------------
    Zimbra :: the leader in open source messaging and collaboration

  5. #5
    Join Date
    May 2007
    Location
    Zimbra
    Posts
    1,285
    Rep Power
    10

    Default

    I found that this particular issue is still present in 8.0.4 as well. I've fixed the cbpolicyd intialization script to correctly add amavis & accounting schema on fresh installs, and will work on getting that fixed for upgrades in 8.0.5
    Quanah Gibson-Mount
    Server Architect
    Zimbra, Inc
    --------------------
    Zimbra :: the leader in open source messaging and collaboration

  6. #6
    Join Date
    Jul 2008
    Posts
    30
    Rep Power
    7

    Default

    Could you pass me how can I fix this error?

Similar Threads

  1. cbpolicyd
    By uxbod in forum Administrators
    Replies: 4
    Last Post: 04-20-2013, 07:42 PM
  2. cbpolicyd on zimbra 8
    By thesubmitter in forum Administrators
    Replies: 0
    Last Post: 11-09-2012, 03:58 PM
  3. cbpolicyd on zimbra 8
    By thesubmitter in forum Installation
    Replies: 0
    Last Post: 11-09-2012, 03:58 PM
  4. Zimbra and CBPolicyd
    By ualex in forum Administrators
    Replies: 3
    Last Post: 03-13-2012, 02:22 AM
  5. Cbpolicyd error in ZMMTA.cf - 6.0 B2
    By cem in forum Installation
    Replies: 1
    Last Post: 07-14-2009, 07:58 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •