-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Saturday 01 August 2009, Tino Donderwinkel wrote:
> >
> > On Friday 31 July 2009, Tino Donderwinkel wrote:
> > > I have a virtual_alias map setup that uses this mySQL query;
> > >
> > > SELECT rcpt FROM aliases WHERE alias = '%s' OR alias = (SELECT
amens Tino Donderwinkel
Verzonden: vrijdag 31 juli 2009 23:59
Aan: postfix-us...@cloud9.net
Onderwerp: mySQL Query not working
I have a virtual_alias map setup that uses this mySQL query;
SELECT rcpt FROM aliases WHERE alias = '%s' OR alias = (SELECT CONCAT('%u@',
alias_of) F
Willy De la Court a écrit :
> On Friday 31 July 2009, Tino Donderwinkel wrote:
>> I have a virtual_alias map setup that uses this mySQL query;
>>
>> SELECT rcpt FROM aliases WHERE alias = '%s' OR alias = (SELECT
>> CONCAT('%u@', alias_of) FROM domains WHERE domain = '%d')
>
> hmm I think the way t
On Friday 31 July 2009, Tino Donderwinkel wrote:
> I have a virtual_alias map setup that uses this mySQL query;
>
> SELECT rcpt FROM aliases WHERE alias = '%s' OR alias = (SELECT
> CONCAT('%u@', alias_of) FROM domains WHERE domain = '%d')
hmm I think the way the % vars are replaced is the problem,
I have a virtual_alias map setup that uses this mySQL query;
SELECT rcpt FROM aliases WHERE alias = '%s' OR alias = (SELECT CONCAT('%u@',
alias_of) FROM domains WHERE domain = '%d')
Postmap -q @domain.com mysql:/etc/postfix/aliases gives me NO results.
If I change the query to:
SELECT rcpt FROM
