Re: Routing solution on mail servers with all domain pointing at the same externel IP

Hi Stephen,

The URL I sent you has information about using mysql as lookup library:
http://www.vergenet.net/linux/perdition/perditiondb.5.shtml

The table you've shown doesn't have information about the
hostnames/localIPs. Where is it? In the transport table?

I've never used mysql to do it, so I don't know  the details and how
flexible it is. Maybe you'll need to create a view in your database
for the perdition lookup with the domain as key and the localIP as
value.

Unfortunately I don't have any example. But the two URLs I sent you
have all information you need. In particular, look at --query_key
option and mysql database access library.


[]'s
Gustavo Duarte

On Tue, Dec 2, 2008 at 01:04, Stephen Liu <[email protected]> wrote:
>
> --- Gustavo Luiz Duarte <[email protected]> wrote:
>
>> Yes, you can use perdition. Install perdition on Guest01 and
>> configure
>> it to access other hosts according to the domain.
>>
>> Here you can find information about configuring perdition:
>> http://www.vergenet.net/linux/perdition/perdition.8.shtml
>>
>> Here you can find information about configuring the domain/localIP
>> mapping:
>> http://www.vergenet.net/linux/perdition/perditiondb.5.shtml
>>
>> As it seems you have a small servers configuration, I recommend you
>> to
>> use GDBM (perdition default) or Berkeley DB method for the
>> domain/localIP mapping.
>>
>>
>> I hope it can be helpful, ask if you have any difficulty.
>>
>> []'s
>
>
> Hi Gustavo,
>
>
> Thanks for your advice and URLs.
>
>
> A small database is running on Guest01, the mail server for routing,
> with following tables created.
>
>
> mysql> SHOW tables;
> +------------------+
> | Tables_in_maildb |
> +------------------+
> | aliases          |
> | domains          |
> | transport        |
> | users            |
> +------------------+
> 4 rows in set (0.00 sec)
>
>
> mysql> SELECT * from domains
>    -> ;
> +------+-----------------------+-----------+---------+
> | pkid | domain                | transport | enabled |
> +------+-----------------------+-----------+---------+
> |    1 | localhost             | virtual:  |       1 |
> |    2 | localhost.localdomain | virtual:  |       1 |
> |    3 | domain01.com           | virtual:  |       1 |
> |    4 | domain02.com  | virtual:  |       1 |
> |    5 | domain03.com  | virtual:  |       1 |
> +------+-----------------------+-----------+---------+
> 5 rows in set (0.00 sec)
>
>
> All incoming mails arriving on Guest01 are redistributed to the
> respective mail servers according to domains.
>
>
> I found following document on Internet;
>
> Perdition
> https://we.riseup.net/debian/perdition
>
> POP3/IMAP Proxy Perdition mit MySQL backend
> http://www.mth-solutions.de/howtos/postfix_und_co/perdition
>
>
> Are they relevant for my application?  An example will be easier for me
> to understand configuring perdition.  TIA
>
>
> B.R.
> Stephen L
>
>
>
>> On Mon, Dec 1, 2008 at 10:11, Stephen Liu <[email protected]> wrote:
>> > Hi folks,
>> >
>> >
>> > I'm searching around for a solution to solve my problem as
>> mentioned
>> > hereinbelow;
>> >
>> >
>> > I have a Xen box (a virtualizaion box) with following setup:-
>> >
>> >
>> > MTA - Postfix 2.3.8
>> > Database - MySQL 5.0.32 (running on Guest01)
>> > Courier IMAP 4.1.1
>> > etc.
>> >
>> >
>> > Host - Debian Etch Workstation
>> > Guest01 - mail server for routing and running postfix virtual
>> > Guest02 - mail server, hostname01. localIP_01, domain01
>> > Guest03 - mail server, hostname02, localIP_02, domain02
>> > Guest04 - mail server, hostname03, localIP_03, domain03
>> > etc.
>> >
>> > all mail servers running postfix on Debian Etch.
>> >
>> > single (one) external IP with all ports forwarded to Guest01 except
>> > port 53 which is forwarded to the DNS server, also running on a
>> guest
>> > of the Xen box.
>> >
>> >
>> > Guest01 routes all incoming mails, which are pointing at same
>> external
>> > IP, according to their domains to respective mail servers.  All
>> > outgoing mails are sent via the routing mail server, Guest01, to
>> > Internet.
>> >
>> >
>> > The system is working nicely on Intranet.  Mail client, Evolution,
>> on
>> > workstations connected to local network, the Intranet, can
>> send/receive
>> > mails on mail servers.  Server settings on mail client work on
>> either
>> > local IP or on hostname.
>> >
>> >
>> > My problem is if the workstation is on remote site, not on local
>> > network, with one external IP how can the remote mail client find
>> the
>> > mail server which it needs to connect.
>> >
>> >
>> > Can perdition help me out?  If YES Please shed me some light how to
>> > start?
>> >
>> >
>> > Shall I follow;
>> > perdition: Mail Retrieval Proxy,
>> > http://www.vergenet.net/linux/perdition/perdition_paper/html/
>> > ???
>> >
>> >
>> > Any other relevant document for installation and config of
>> perdition
>> > for reference to solve my problem?
>> >
>> >
>> > TIA
>> >
>> >
>> > B.R.
>> > Stephen L
>> >
>> >
>> > Send instant messages to your online friends
>> http://uk.messenger.yahoo.com
>> > ______________________________________________
>> > Perdition-users mailing list
>> > [email protected]
>> > http://lists.vergenet.net/listinfo/perdition-users
>> >
>>
>
>
> Send instant messages to your online friends http://uk.messenger.yahoo.com
> ______________________________________________
> Perdition-users mailing list
> [email protected]
> http://lists.vergenet.net/listinfo/perdition-users
>
______________________________________________
Perdition-users mailing list
[email protected]
http://lists.vergenet.net/listinfo/perdition-users