Re: [exim] How can i expand a mysql query ?

Top Page
Delete this message
Reply to this message
Author: John Burnham
Date:  
To: exim-users
Subject: Re: [exim] How can i expand a mysql query ?
> spam_delivery:
>   driver = appendfile
>   envelope_to_add
>   return_path_add
>   mode = 0600
>   maildir_format = true
>   create_directory = true
>   directory = ${lookup mysql{select smtp from users,domains \
>         where localpart = '${quote_mysql:$local_part}' \
>         and domain = '${quote_mysql:$domain}' \
>         and users.domain_id = domains.domain_id}}

>
> The result look like /var/mail/domain/user/Maildir but i need
> it like this /var/mail/domain/user/Maildir/.spambox.
>
>
> Can somebody help me append "/.spambox" to the lookup result
> without modifying the mysql tables?
>

Modify the sql so you have select concat(smtp,'/.spambox') instead of just
select smtp in there would be my initial suggestion.
HTH.
John