Domain delimiter question

Hi,

I'm using perdition as a POP3 and IMAP proxy for about 1 year.
At this time I have 2 perdition servers as standalone proxies with one 
mailserver backend behind them.
There was never a problem with this type of setup.

Now I'm planing to split my mailserver backend in 2 ore more different 
servers. So I'm able to scaling out my server environment
more flexible in the future.

I'm trying to use mysql popmap for all of my hosted domains (about 6.000).
My idea was to store all domains and the information of their 
backendservers in a mysql database.

My database scheme looks like this:

Domain           Server                   Port
domain1.com   192.168.1.10       NULL
domain2.com   192.168.1.11       NULL
domain3.com   192.168.1.10       NULL
domain4.com   192.168.1.11       NULL
... and so on.

With this setup I'm able to define for each domain a different backend 
server, which will be very
practical for future scaling etc.

The only problem I have is:
All my users are using different logintypes. Some of them are using for 
example
"[email protected]" as username. Other users are using "user%domain1.com"
as username.

So I have two different domain delimiters to search for (@ and %).
To change this on the user site is not possible. There are about 25.000 
users.

I must find a way to filter the domain from the full username based on 
the domain delimiter.

My current query key is:
query_key \\d

My map library options are:
map_library_opt 
"mysqlserver:3306:dbname:dbtable:dbuser:dbpass:server:domain:port"

Some of you have any idea how I can solve my problem? Is there a way to 
use 2 domain delimiters?

Many thanks and regards
Urban

P.s. sorry for my poor english.








______________________________________________
Perdition-users mailing list
[email protected]
http://lists.vergenet.net/listinfo/perdition-users