[Vmail-discuss] vmail forwarder problem

[Hakan Terzioglu]

Its same as user aliases, index restriction an sql scheme.
Just add domain_name to primary index. byb default only alias sets the
index.

I did it to forwards table by adding domain_name to primary index, to
solve my user alias problem.


On Wed, 2002-08-28 at 19:44, Donovan Craig wrote:
> Hi Again,
> 
> I just found out what the problem was:
> 
> Vmail-SQL does not like more than one domain alias..
> 
> Does anyone know of a fix for this ?
> 
> Thank's,
> 
> Donovan
> 
> On Wed, 28 Aug 2002 09:02:07 -0400
> Donovan Craig <donovan@snapfrozen.com> wrote:
> 
> > Hi Vmailers,
> > 
> > Firstly, up until this point I have had not problems what so ever with the vmail-sql package and have been running it successfully on over 70 domains.
> > 
> > However: recently, with only one domain, I have been experiencing the following problem which has totally stumped me:
> > 
> > -------%<---------exim_mainlog------------%<---------------
> > 
> > 2002-08-23 13:48:20 17i5Qp-0000eC-00 <= bounces-06f92b0011-jenny=domain.com.au@o.verticalresponse.com H=mkt4.verticalresponse.com [130.94.4.7] P=smtp S=27713
> > 2002-08-23 13:48:21 17i5Qr-0000eQ-00 <= bounces-06f92b0011-jenny=domain.com.au@o.verticalresponse.com U=amavis P=scanned-ok S=27915 id=E17i5Qp-0000eC-00@our.domain.net
> > 2002-08-23 13:48:21 17i5Qr-0000eQ-00 Failed to find user "user.com.au
> > user.com.au" from expanded string "${lookup mysql{select unix_user from domain left join domain_alias on domain_alias.domain_name = domain.domain_name where domain.domain_name = '$domain' or domain_alias.alias = '$domain'}{$value}fail}" from the virtual_localdelivery transport
> > 2002-08-23 13:48:21 17i5Qr-0000eQ-00 == jenny@domain.com.au T=virtual_localdelivery defer (-30): Failed to find user "user.com.au\nuser.com.au" from expanded string "${lookup mysql{select unix_user from domain left join domain_alias on domain_alias.domain_name = domain.domain_name where domain.domain_name = '$domain' or domain_alias.alias = '$domain'}{$value}fail}" from the virtual_localdelivery transport
> > 2002-08-23 13:48:21 17i5Qp-0000eC-00 => jenny <jenny@domain.com.au> D=amavis_director T=amavis
> > 2002-08-23 13:48:21 17i5Qp-0000eC-00 Completed
> > 
> > ---------------%<--------------------%<-------------------
> > 
> > Additional Information:
> > 
> > The problem only appears on the the domain 'domain.com.au'.
> > 
> > The problem only occurs on popboxes and not forwarders on the domain.
> > 
> > Everything was working fine then we added to domain aliases to the domain which seemed to cause the problem. Once we remove the domain aliases the problem goes away.
> > 
> > We have tried totally re-creating the domain and re-creating the domain aliases. However the problem comes back again when this is done.
> > 
> > The unix user that owns the domain is called 'domain.com.au' and owns around another 30 or so domains which work fine with domain aliases.
> > 
> > Any ideas ?
> > 
> > Thank's in advance,
> > 
> > Regards,
> > 
> > Donovan
> > 
> > 
> > 
> > S n a p f r o z e n  S o l u t i o n s
> > 
> > Phone: (03) 5961 5217
> > Fax: (03) 8660 2521
> > Web: http://www.snapfrozen.com.au
> > 
> > 
> > 
> > 
> > 
> > 
> > Disclaimer:
> > 
> > This email and any files transmitted with it are confidential and
> > intended solely for the use of the individual or entity to whom they are
> > addressed.
> > 
> > If you have received this email in error, please notify the
> > addressee by return email.
> > 
> > 
> > _______________________________________________
> > vmail-discuss mailing list
> > vmail-discuss@lists.beasts.org
> > http://lists.beasts.org/mailman/listinfo/vmail-discuss
> > 
> 
> 
> 
> S n a p f r o z e n  S o l u t i o n s
> 
> Phone: (03) 5961 5217
> Fax: (03) 8660 2521
> Web: http://www.snapfrozen.com.au
> 
> 
> 
> 
> 
> 
> Disclaimer:
> 
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they are
> addressed.
> 
> If you have received this email in error, please notify the
> addressee by return email.
> 
> 
> _______________________________________________
> vmail-discuss mailing list
> vmail-discuss@lists.beasts.org
> http://lists.beasts.org/mailman/listinfo/vmail-discuss
> 
--