pykolab smtp access policy

[Brady, Mike]

On 2014-04-30 06:41, Thomas Spuhler wrote:
> On Saturday, December 21, 2013 04:44:47 PM you wrote:
>> It looks like some unconfigured caching stuff. You find some generic 
>> cache db user settings in
>> kolab.conf
>> 
>> Afaik it shouldn't be causing any errors. Maybe there's a way to 
>> disable SMTP policy cache or
>> configure caching right.
>> > Am 21.12.2013 um 16:23 schrieb Thomas Spuhler <thomas.spuhler at btspuhler.com>:
>> >> On Saturday, December 21, 2013 11:19:32 AM Christian Hügel wrote:
>> >> Hi,
>> >>
>> >> i get a bunch of errors in /var/log/kolab/pykolab.log
>> >>
>> >> 2013-12-19 20:21:00,520 pykolab.smtp_access_policy ERROR Operational
>> >> Error in caching: (OperationalError) (1045, "Access denied for user
>> >> 'user'@'localhost' (using password: YES)") None None
>> >> 2013-12-19 20:21:26,476 pykolab.smtp_access_policy ERROR Operational
>> >> Error in caching: (OperationalError) (1045, "Access denied for user
>> >> 'user'@'localhost' (using password: YES)") None None
>> >> 2013-12-20 03:01:00,682 pykolab.smtp_access_policy ERROR Operational
>> >> Error in caching: (OperationalError) (1045, "Access denied for user
>> >> 'user'@'localhost' (using password: YES)") None None
>> >> 2013-12-20 12:50:23,829 pykolab.smtp_access_policy ERROR Operational
>> >> Error in caching: (OperationalError) (1045, "Access denied for user
>> >> 'user'@'localhost' (using password: YES)") None None
>> >> 2013-12-20 22:33:52,822 pykolab.smtp_access_policy ERROR Operational
>> >> Error in caching: (OperationalError) (1045, "Access denied for user
>> >> 'user'@'localhost' (using password: YES)") None None
>> >> 2013-12-20 22:34:37,323 pykolab.smtp_access_policy ERROR Operational
>> >> Error in caching: (OperationalError) (1045, "Access denied for user
>> >> 'user'@'localhost' (using password: YES)") None None
>> >>
>> >> Does anyone know where these errors come from?
>> >>
>> >> Thank you.
>> >>
>> >> Christian
>> >> _______________________________________________
>> >> users mailing list
>> >> users at lists.kolab.org
>> >> https://lists.kolab.org/mailman/listinfo/users
>> >
>> > I have the same errors in my log. Would help if we could fix this.
> 
> Any progress on this?
> 
> _______________________________________________
> users mailing list
> users at lists.kolab.org
> https://lists.kolab.org/mailman/listinfo/users

This has come up on the list multiple times.  I also logged a bug 
https://issues.kolab.org/show_bug.cgi?id=2920.  The easy resolution is 
to disable the cache by commenting out the cache_uri line.  It works 
fine with out it.

The underlying code uses sqlalchemy, so the cache_uri string needs to be 
one that sqlalchemy supports and then the appropriate database needs to 
be setup.  If there is documentation for this I couldn't find it.

If you are on a 3.1 system (don't know about 3.2) you probably also want 
to comment out all but the address_search_attrs line in the 
kolab_smtp_access_policy section of kolab.conf as well.  With the 
sender_header and xsender_header set to true you will get invalid 
headers that some systems will reject (including amavisd on your 
system).

Regards

Mike