Hi Jon,
Thanks for your advice.
--- Jonathan Feally <[EMAIL PROTECTED]> wrote:
> DBMail currently runs on only one database. Thus all email for your 3
>
> domains would be in one database on one server. The number of
> front-end
> servers (dbmail-imapd) can be as many as you like - all accessing the
>
> MySQL/PostGres db over the network.
There is only ONE database here running on Guest01, the routing mail
server. In fact this is a full function mail server running postfix
virtual. All domains are on /etc/postfix/mysql_domains.cf
mysql> SHOW tables;
+------------------+
| Tables_in_maildb |
+------------------+
| aliases |
| domains |
| 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 | satimis.com | virtual: | 1 |
| 4 | satimis.dnsalias.com | virtual: | 1 |
| 5 | satimis.changeip.net | virtual: | 1 |
+------+-----------------------+-----------+---------+
5 rows in set (0.00 sec)
All incoming mails are delivered to respective directories on Guest01,
Guest01:~# ls -l /var/spool/mail/virtual/
total 20
drwxr-sr-x 5 virtual virtual 4096 2008-11-20 15:07 Albert
drwxr-sr-x 4 root virtual 4096 2008-11-21 15:30 changeip
drwxr-sr-x 4 root virtual 4096 2008-11-21 11:17 dnsalias
drwxr-sr-x 9 virtual virtual 4096 2008-11-22 15:34 LMS
drwxr-sr-x 9 virtual virtual 4096 2008-11-22 15:29 Stephen
Later I created other 3 mail servers on the Xen box also running
postfix on Debian Etch. This is a TEST. Added 'transport' on the
database;
and adjusting /etc/postfix/main.cf
mysql> SHOW tables;
+------------------+
| Tables_in_maildb |
+------------------+
| aliases |
| domains |
| transport |
| users |
+------------------+
4 rows in set (0.00 sec)
It becomes the present situations.
Guest02 - for satimis.com
Guest03 - for satimis.changeip.net
Guest04 - for domain satimis.dnsalias.com
All incoming mails pointing at same external IP are delivered to
respective mail servers based on domain. Mail clients, Evolution, on
local network, Intranet, can send/receive mails via their own mail
server. The settings on mail clients can be either "server:local IP"
or "server.servername/hostname". It works nicely.
Now my problem is how can remote mail clients send/receive mails from
their servers on the Xen box. For sending mail maybe they can use the
routing mail server, Guest01. About how about receiving mail? There
is only ONE external IP connected to the Xen box.
TIA
B.R.
Stephen
> Now you could run 3 databases, 3
> front-ends, each separated out to handle each domain, but you will
> only
> be replacing your current IMAP with dbmail.
>
> This leaves you with 2 options besides the all on one server.
>
> Option 1
> Put each domain on a different port number and map those port numbers
> to
> each of the boxes on your firewall. Clients would then need to be
> configured to use a hostname and port number, where the hostname on
> the
> inside looks up to the IP of the server they need, and the hostname
> on
> the outside looks up to your public IP (thus all outside hostnames
> would
> have the same IP).
>
> Option 2
> Run an imap proxy server that can understand from a small database or
> by
> domain name which users are on what imap servers.
> http://www.imapproxy.org or http://www.vergenet.net/linux/perdition/
> would be a good place to start. This will let you use your current
> IMAP
> servers as if they were all one from the outside. You could also
> move
> to dbmail as one instance per domain, but the imap proxy part is
> really
> what you need to run multiple backends merged as one front-end.
>
> -Jon
>
> Stephen Liu wrote:
> > Hi folks,
> >
> >
> > Can dbmail help me.?
> >
> >
> > 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
> > Couier IMAP 4.1.1
> > etc.
> >
> >
> > Host - Debian Etch Workstation
> > Guest01 - mail server for routing 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 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 dbmail help me out? If YES Please shed me some light how to
> start?
> > Where can I find relevant document on its setup to solve my
> problem.
> >
> > TIA
> >
> >
> > B.R.
> > Stephen L
> >
> > Send instant messages to your online friends
> http://uk.messenger.yahoo.com
> > _______________________________________________
> > DBmail mailing list
> > [email protected]
> > https://mailman.fastxs.nl/mailman/listinfo/dbmail
> >
> >
>
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
> _______________________________________________
> DBmail mailing list
> [email protected]
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
Send instant messages to your online friends http://uk.messenger.yahoo.com
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
