Hello...
MYSQL_DOMAIN_PSA = select MYSQL_DOMAIN_ID from MYSQL_DOMAIN_TABLE \
where MYSQL_DOMAIN_NAME='${quote_mysql:$domain}'
MYSQL_USER = SELECT DISTINCT MYSQL_DOMAIN_ID FROM MYSQL_AUTHTABLE \
WHERE MYSQL_DOMAIN_ID LIKE '$MYSQL_DOMAIN_PSA ?????@#$@#$' AND \
MYSQL_USERNAMEFIELD LIKE '${quote_mysql:$local_part}'
# Check if user is a real user in mysql database
virtual_local_user:
domains = ${lookup mysql {MYSQL_USER}{$value}}
driver = smartuser
transport = virtual_delivery
How can i parse MYSQL_DOMAIN_PSA result to the MYSQL_USER query ?
Should work something like this:
selecet dom_id from domains where mysql_domain_name='${quote_mysql:
$domain}'
Result: dom_id=52
and than:
MYSQL_USER = SELECT DISTINCT MYSQL_DOMAIN_ID FROM MYSQL_AUTHTABLE \
WHERE MYSQL_DOMAIN_ID LIKE '52' AND \
MYSQL_USERNAMEFIELD LIKE '${quote_mysql:$local_part}'
2 - Second
What option to set to refuse "rcpt to" if user dosent exist ?
Thanks
Abaddon
========================================================================
Easy and free access to your email anywhere!
http://www.starten.net/mail
========================================================================