View Single Post
  #5   (View Single Post)  
Old 24th November 2008
satimis satimis is offline
Port Guard
 
Join Date: May 2008
Posts: 27
Default

Quote:
Originally Posted by deemon View Post
bind9 is in FreeBSD base system, you don't need to install anything from ports to set it up.
Hi deemon,


Thanks for your advice.


Still I can't resolve if I install BIND9 on a guest of Xen box, only a base OS, BIND9 and some other required packages. Do I need to forward any port to it?


If the local IP of this guest is 192.168.0.201 then on other guests (mail server) I'll edit /etc/resolv.conf
Code:
nameserver   192.168.0.201
Nothing else. Can it work?


Quote:
So basically you have one mail gateway that has to route mail for different domains to different guest systems with IP addresses from private address space.
For that you have to set up virtual transports on the gateway. Check out transport_maps and relay_domains tables.
You'll just need to add smtp:YOURGUESTIP (or YOURGUESTHOSTNAME) as transports for your domains and mail will be routed to that IP/HOSTNAME.
On the same mail server I don't have any problem.

/etc/postfix/mysql_transport.cf
Code:
user=mail 
password=apassword 
dbname=maildb 
table=backups 
select_field=transport 
where_field=domain 
hosts=127.0.0.1 
additional_conditions = and enabled = 1

mysql> SHOW tables;
Code:
+------------------+
| Tables_in_maildb |
+------------------+
| aliases          |
| domains          |
| users            |
...
...

mysql> SELECT * from domains;
Code:
+------+-----------------------+-----------+---------+
| 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 |
.....
....

mysql> SELECT * from users;
Code:
+------------------------------+---------------+------+------+-------------------------+-------------------+---------+-----------------+----------------+---------------+-------+------------+----------------+
| id                           | name          | uid  | gid  | home                    | maildir           | enabled | change_password | clear          | crypt         | quota | procmailrc | spamassassinrc |
+------------------------------+---------------+------+------+-------------------------+-------------------+---------+-----------------+----------------+---------------+-------+------------+----------------+
| root@localhost               | root          | 5000 | 5000 | /var/spool/mail/virtual | root/             |       1 |               1 | passwd1        | sdtrusfX0Jj66 |       |            |                |
| satimis@satimis.com          | Satimis       | 5000 | 5000 | /var/spool/mail/virtual | Satimis/          |       1 |               1 | passwd2    | sdtrusfX0Jj66 |       |            |                |
| lms@satimis.com              | lmsoomn       | 5000 | 5000 | /var/spool/mail/virtual | LMS/              |       1 |               1 |passwd3         | sdtrusfX0Jj66 |       |            |                |
| albert@satimis.com           | Albert Conong | 5000 | 5000 | /var/spool/mail/virtual | Albert/           |       1 |               1 | passwd4      | sdtrusfX0Jj66 |       |            |                |
| lms@satimis.dnsalias.com     | lmsoomn       | 5000 | 5000 | /var/spool/mail/virtual | dnsalias/LMS/     |       1 |               1 | passwd5 | sdtrusfX0Jj66 |       |            |                |
| satimis@satimis.dnsalias.com | Satimis       | 5000 | 5000 | /var/spool/mail/virtual | dnsalias/Satimis/ |       1 |               1 | passwd6 | sdtrusfX0Jj66 |       |            |                |
| satimis@satimis.changeip.net | Satimis       | 5000 | 5000 | /var/spool/mail/virtual | changeip/Satimis/ |       1 |               1 | passwd7 | sdtrusfX0Jj66 |       |            |                |
| lms@satimis.changeip.net     | lmsoomn       | 5000 | 5000 | /var/spool/mail/virtual | changeip/LMS/     |       1 |               1 | passwd8 | sdtrusfX0Jj66 |       |            |                |
.......

IF;

1)
domain "satimis.dnsalias.com" is on MailServerB
local IP=192.168.111.301
directory of user "satimis@satimis.dnsalias.com" = /home/Satimis
directory fo user "lms@satimis.dnsalias.com" = /home/LMS
etc.


2)
domain "satimis.changeip.net" is on MailServerC
local IP=192,168.111.302
directory of user "satimis@satimis.changeip.net" = /home/Satimis
directory of user "lms@satimis.changeip.net" = /home LMS
etc.

3)
etc.


Then how to edit those 2 MySQL files? Any further file needs to create? TIA


I think I'll make MailServerA, the current running mail server, for routing ONLY.


B.R.
satimis
Reply With Quote