On 13.09.2010 19:29 Victor Duchovni wrote:
On Mon, Sep 13, 2010 at 07:23:41PM +0200, Valentin Gjorgjioski wrote:
Have tried this
SELECT destination FROM view_aliases WHERE '%s' like
concat('%%',email,'%%') and '%...@%d' not in (select email from view_users);
Postmap does a single lookup with
On Mon, Sep 13, 2010 at 07:23:41PM +0200, Valentin Gjorgjioski wrote:
> Have tried this
> SELECT destination FROM view_aliases WHERE '%s' like
> concat('%%',email,'%%') and '%...@%d' not in (select email from view_users);
Postmap does a single lookup with the literal key you supply. Virtual
alia
On 13.09.2010 18:59 Victor Duchovni wrote:
On Mon, Sep 13, 2010 at 06:52:49PM +0200, ??
wrote:
/etc/postfix/mysql-virtual-alias-maps.cf
Important line:
query = SELECT destination FROM view_aliases WHERE '%s' like
concat('%%',email,'%%') and '%s' not in (select
On Mon, Sep 13, 2010 at 07:12:14PM +0200, Valentin Gjorgjioski wrote:
> On 13.09.2010 18:59 Victor Duchovni wrote:
>> On Mon, Sep 13, 2010 at 06:52:49PM +0200,
>> ?? wrote:
>>
>>> /etc/postfix/mysql-virtual-alias-maps.cf
>>> Important line:
>>> query = SELECT des
On 13.09.2010 18:59 Victor Duchovni wrote:
On Mon, Sep 13, 2010 at 06:52:49PM +0200, ??
wrote:
/etc/postfix/mysql-virtual-alias-maps.cf
Important line:
query = SELECT destination FROM view_aliases WHERE '%s' like
concat('%%',email,'%%') and '%s' not in (select
On Mon, Sep 13, 2010 at 06:52:49PM +0200, ??
wrote:
> /etc/postfix/mysql-virtual-alias-maps.cf
> Important line:
> query = SELECT destination FROM view_aliases WHERE '%s' like
> concat('%%',email,'%%') and '%s' not in (select email from
> view_users);
Think about
Today I did tried to implement one catch-all email per domain.
Actually it seems to me that I hit some bug which is most probably
very unlikely ... but still I want to share this experience and maybe
someone will point out where my problem lies.
postconf -n
Important lines:
virtual_alias_map
