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
"user(a)domain1.com" 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.