MySQL and local_domains_maps

    Awesome ..... that's what I need.

    I was checking amavisd.conf-default and found an example
on setting 
up to another table, postfix_domains ..... that's pretty
similar to my 
real situation here.

    Last doubt ..... after configuring things
(lookup_sql_dsn and 
sql_select_policy), how my local_domains_maps would
have to be 
configured ?? Or can i leave it undef ???


Mark Martinec escreveu:
> Leonardo,
>
>   
>>     Is it possible to have local_domains_maps variable
stored in MySQL
>> database ? I wanna host several domains and dont
want to alter some
>> external file for having all domains listed ..... i
already does that
>> with read_hash, but i would like to have it fetch
from MySQL ......
>>     is this possible ?
>>     
>
> Yes, there is a field users.local for that purpose.
> In its absence the default behavious is just fine:
> if a domain (or specific user( is listed in table
'users',
> then it defaults to local='Y'; if not listed, it is not
local.
>
> So: just list all your domains in table 'users' (one
record for
> each domain), and the rest will take care of itself.
>
>   Mark
>
>
------------------------------------------------------------
-------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the
chance to share your
> opinions on IT & business topics through brief
surveys - and earn cash
> http://www.techsay.com/default.
php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> AMaViS-user mailing list
> AMaViS-userlists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/amavis-user

> AMaViS-FAQ:http://www.amav
is.org/amavis-faq.php3
> AMaViS-HowTos:http://www.amavis.org/ho
wto/
>
>   

-- 


	Atenciosamente / Sincerily,
	Leonardo Rodrigues
	Solutti Tecnologia
	http://www.solutti.com.br

	Minha armadilha de SPAM, NÃO mandem email
	gertrudessolutti.com.br
	My SPAMTRAP, do not email it





------------------------------------------------------------
-------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the
chance to share your
opinions on IT & business topics through brief surveys -
and earn cash
http://www.techsay.com/default.
php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
AMaViS-user mailing list
AMaViS-userlists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user

AMaViS-FAQ:http://www.amav
is.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/ho
wto/

Leonardo,

> I was checking amavisd.conf-default and found an
example on setting
> up to another table, postfix_domains ..... that's
pretty similar
> to my real situation here.

Placing records for each domain into table 'users' is
cleaner
and simplest. Prepend domains with a dot if you want
subdomains
to be implied as well.

There are some workarounds with replacing a SELECT with a
more
complicated clause to look up into an UNION of two tables
for those
that can afford the straightforward solution, but is not for
the
faint at heart 

>     Last doubt ..... after configuring things
(lookup_sql_dsn and
> sql_select_policy), how my local_domains_maps would
have to be
> configured ?? Or can i leave it undef ???

Yes, you may leave local_domains_maps as empty list:

  local_domains_maps = ();

bacause SQL and LDAP lookups are automatically included
into the local_domains_maps list at a later stage.

  Mark

------------------------------------------------------------
-------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the
chance to share your
opinions on IT & business topics through brief surveys -
and earn cash
http://www.techsay.com/default.
php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
AMaViS-user mailing list
AMaViS-userlists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user

AMaViS-FAQ:http://www.amav
is.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/ho
wto/