Re: [AMaViS-user] setup amavisd-new 2.6.3 - MySql

[Brad White]

I think the @lookup_sql_dsn should be:

@lookup_sql_dsn = (['DBI:mysql:database=amavis_db;host=127.0.0.1;port=3306',  
'batandbart', 'sion222']);



On 6/15/09 1:41 PM, "troxlinux"  wrote:

Hi list , I am installing amavisd-new with mysql, but when restarting
the daemon it shows me this error:

Starting virus-scanner (amavisd-new):Error in config file
"/etc/amavisd.conf": syntax error at /etc/amavisd.conf line 120, near
"' ORDER BY users.priority DESC';"

in the examples of amavisd-new with mysql this similar to as me I put
it in amavisd.conf


@lookup_sql_dsn =( ['DBI:mysql:amavisd_db:localhost', 'batandbart', 'sion222'],
# $timestamp_fmt_mysql = 1; # if using MySQL *and* msgs.time_iso is TIMESTAMP;
#   defaults to 0, which is good for non-MySQL or if msgs.time_iso is CHAR(16)
$sql_select_policy = 'SELECT *,users.id FROM users,policy'.
 ' WHERE (users.policy_id=policy.id) AND (users.email IN (%k))'.
 ' ORDER BY users.priority DESC';

$sql_select_white_black_list = 'SELECT wb FROM wblist,mailaddr'.
   ' WHERE (wblist.rid=?) AND (wblist.sid=mailaddr.id)'.
   '   AND (mailaddr.email IN (%k))'.
   ' ORDER BY mailaddr.priority DESC';

any idea?

regardss


--
rickygm

http://gnuforever.homelinux.com

--
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects
___
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user
 AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
 AMaViS-HowTos:http://www.amavis.org/howto/


--
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
___
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net 
https://lists.sourceforge.net/lists/listinfo/amavis-user 
 AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 
 AMaViS-HowTos:http://www.amavis.org/howto/ 

[AMaViS-user] Telling amavis something bad happened

[Brad White]

Is there a way, perhaps in amavis::custom that I could run a custom test of
my own, and if that test fails tell amavis to leave that message in the
postfix deferred queue?  I essentially need to know how to communicate the
failure to amavis.

Thanks for any advice.

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net 
https://lists.sourceforge.net/lists/listinfo/amavis-user 
 AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 
 AMaViS-HowTos:http://www.amavis.org/howto/ 

Re: [AMaViS-user] Using RelayCountry with amavis?

[Brad White]

I think that amavis handles all header re-writing and ignores any such
directives in the spamassassin config files.  This info is in the amavis FAQ
btw.  So, if you ran your message through spamassassin by hand you would
likely see the "X-Spam-Relay-Countries" header added to your message, but it
would not be there if the email passed through amavis.  This is normal
behavior I believe.


On 10/3/08 9:03 AM, "Per olof Ljungmark" <[EMAIL PROTECTED]> wrote:

> Brad White wrote:
>> It doesn't show up in the amavis generated log entries on my system, but it
>> is definitely working.  I does show up when I run a spamassasin -D --lint:
>> 
>> [14432] dbg: plugin: loading Mail::SpamAssassin::Plugin::RelayCountry from
>> @INC
>> 
>> I have the plugin enabled via the init.pre file in my spamassasin directory:
>> 
>> # RelayCountry - add metadata for Bayes learning, marking the countries
>> # a message was relayed through
>> #
>> # Note: This requires the IP::Country::Fast Perl module
>> #
>> loadplugin Mail::SpamAssassin::Plugin::RelayCountry
>> 
>> 
>> You also need the extra configuration in your spamassassin local.cf file,
>> something like:
>> 
>> ifplugin Mail::SpamAssassin::Plugin::RelayCountry
>> header RELAY_CN X-Relay-Countries =~ /\bCN\b/
>> describe RELAY_CN Relayed through China
>> score RELAY_CN 1.0
>> header RELAY_KR X-Relay-Countries =~ /\bKR\b/
>> describe RELAY_KR Relayed through Korea
>> score RELAY_KR 1.0
>> header RELAY_RU X-Relay-Countries =~ /\bRU\b/
>> describe RELAY_RU Relayed through Russia
>> score RELAY_RU 1.0
>> header RELAY_US X-Relay-Countries =~ /\bUS\b/
>> describe RELAY_US Relayed through United States
>> score RELAY_US 0.001
>> header RELAY_PL X-Relay-Countries =~ /\bPL\b/
>> describe RELAY_PL Relayed through Poland
>> score RELAY_PL 0.001
>> endif # Mail::SpamAssassin::Plugin::RelayCountry
>> 
>> This definitely works for me on my installation.
> 
> Yes you're right, it does not show up until you turn on a higher debug
> level, thanks!
> 
> Also, the docs say "Also for 3.1.0, you can apply a patch [WWW]
> http://bugzilla.spamassassin.org/show_bug.cgi?id=3815 which will allow
> you to add a separate MIME header that shows all the message's relay
> countries, independent of the rules."
> 
>add_header all Relay-Country _RELAYCOUNTRY_
> 
> this again I don't see, is there amavisd-tweaking involved here?
> 
> 
>> On 10/3/08 5:08 AM, "Per olof Ljungmark" <[EMAIL PROTECTED]> wrote:
>> 
>>> Hi,
>>> 
>>> I am fiddling with Mail::SpamAssassin::Plugin::RelayCountry in our
>>> Spamassassin config, and it seems to load ok from init.pre:
>>> spamassain -D --lint:
>>> [85215] dbg: plugin: loading Mail::SpamAssassin::Plugin::RelayCountry
>>> from @INC
>>> 
>>> However, it does not show up when I start amavisd:
>>> 
>>> amavis[85275]: extra modules loaded after daemonizing:
>>> Mail/DomainKeys/Header.pm, Mail/DomainKeys/Key.pm,
>>> Mail/DomainKeys/Key/Public.pm, Mail/DomainKeys/Message.pm,
>>> Mail/DomainKeys/Policy.pm, Mail/DomainKeys/Signature.pm,
>>> Mail/SpamAssassin/Plugin/DomainKeys.pm, Mail/SpamAssassin/Plugin/PDFInfo.pm
>>> 
>>> Anyone on the list using this plugin that can give me a hint here? Using
>>> latest stable release.
>>> 
>>> Thanks,
>>> 
>>> --per
>>> 
>>> -
>>> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
>>> Build the coolest Linux based applications with Moblin SDK & win great
>>> prizes
>>> Grand prize is a trip for two to an Open Source event anywhere in the world
>>> http://moblin-contest.org/redirect.php?banner_id=100&url=/
>>> ___
>>> AMaViS-user mailing list
>>> AMaViS-user@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/amavis-user
>>>  AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
>>>  AMaViS-HowTos:http://www.amavis.org/howto/
>> 


-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net 
https://lists.sourceforge.net/lists/listinfo/amavis-user 
 AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 
 AMaViS-HowTos:http://www.amavis.org/howto/