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

Well, it worked. Now your courier imap is rejecting the user/pass you supplied.

On Thu, Dec 4, 2008 at 01:17, Stephen Liu <[email protected]> wrote:
>
> --- Gustavo Luiz Duarte <[email protected]> wrote:
>
>> I suppose IMAP4_FLAGS="-m /etc/perdition_lookup.gdbm.db --query_key
>> '\d '  "
>
>
> Edit /etc/default/perdition
>
> xen11:~# cat /etc/default/perdition | grep IMAP4_FLAGS
> # by POP3_FLAGS, POP3S_FLAGS, IMAP4_FLAGS or IMAP4S_FLAGS
> IMAP4_FLAGS="-m /etc/perdition_lookup.gdbm.db --query_key '\d' "
>
>
> xen11:~# /etc/init.d/perdition restart
> Stopped /usr/sbin/perdition.pop3 (pid 3458).
> No /usr/sbin/perdition.pop3s found running; none killed.
> No /usr/sbin/perdition.imap4 found running; none killed.
> No /usr/sbin/perdition.imaps found running; none killed.
> Starting /usr/sbin/perdition.pop3...
> Starting /usr/sbin/perdition.pop3s...
> Starting /usr/sbin/perdition.imap4...
> Starting /usr/sbin/perdition.imaps...
>
>
> xen11:~# echo "tag login [email protected] mypasswd" | nc
> xen11.satimis.com 143
> * OK [CAPABILITY IMAP4rev1 UIDPLUS CHILDREN NAMESPACE
> THREAD=ORDEREDSUBJECT THREAD=REFERENCES SORT QUOTA AUTH=CRAM-MD5
> AUTH=CRAM-SHA1IDLE ACL ACL2=UNION STARTTLS] Courier-IMAP ready.
> Copyright 1998-2005 Double Precision, Inc.  See COPYING for
> distribution information.
> tag NO Login failed.
>
> hanging here.
>
>
> xen11:~# tail /var/log/mail.log
> Dec  3 15:58:01 xen11 imapd: LOGIN: ip=[::ffff:192.168.0.211],
> [email protected]
> Dec  3 15:58:01 xen11 imapd: LOGIN: ip=[::ffff:192.168.0.211],
> password=mypasswd
> Dec  3 15:58:01 xen11 authdaemond: received auth request, service=imap,
> authtype=login
> Dec  3 15:58:01 xen11 authdaemond: authmysql: trying this module
> Dec  3 15:58:01 xen11 authdaemond: SQL query: SELECT id, "", clear,
> uid, gid, home, concat(home,'/',maildir), "", name, "" FROM usersWHERE
> id = "[email protected]" AND (enabled=1)
> Dec  3 15:58:01 xen11 authdaemond: supplied password does not match
> clearpasswd
> Dec  3 15:58:01 xen11 authdaemond: authmysql: REJECT - try next module
> Dec  3 15:58:01 xen11 authdaemond: FAIL, all modules rejected
> Dec  3 15:58:01 xen11 imapd: LOGIN FAILED, [email protected],
> ip=[::ffff:192.168.0.211]
> Dec  3 15:58:21 xen11 imapd: Disconnected, ip=[::ffff:192.168.0.211],
> time=20
>
>
> Still fail
>
>
> B.R.
> Stephen L
>
>
>
>
>
>>
>> On Thu, Dec 4, 2008 at 00:30, Stephen Liu <[email protected]> wrote:
>> >
>> > --- Gustavo Luiz Duarte <[email protected]> wrote:
>> >
>> >> You are not supplying the necessary options: -m and --query_key.
>> >> You can set it by command line parameter or in
>> >> /etc/perdition/perdition.conf (maybe /etc/defaults too)
>> >
>> >
>> > Hi Gustavo,
>> >
>> >
>> > Please advise how to set them on /etc/default/perdition.
>> >
>> >
>> > cat /etc/default/perdition
>> >
>>
> ######################################################################
>> > # /etc/sysconfig/perdition (RPM based systems)
>> > # /etc/default/perdition   (Debian)
>> > #
>> > # Run time configuration parameters for perdition
>> >
>>
> ######################################################################
>> >
>> > # Run perdition
>> > # Set to "yes" to run perdition
>> > # Set to any other value to not run perdition
>> > RUN_PERDITION=yes
>> >
>> > # Command line parameters to pass to perdition when run in any
>> mode.
>> > # This is in addition to any mode specific flags.
>> > # That is, it is in addtion to any command line options supplied
>> > # by POP3_FLAGS, POP3S_FLAGS, IMAP4_FLAGS or IMAP4S_FLAGS
>> > #FLAGS=
>> >
>> > # Run an instance of perdition in POP3 mode
>> > # Set to "yes" to run this instance of perdition
>> > # Set to any other valye to not run this instance of perdition
>> > POP3=yes
>> >
>> > #Command line parameters to pass to perdition when run in POP3 mode
>> > POP3_FLAGS=
>> >
>> > # Run an instance of perdition in POP3S mode
>> > # Set to "yes" to run this instance of perdition
>> > # Set to any other valye to not run this instance of perdition
>> > POP3S=yes
>> >
>> > #Command line parameters to pass to perdition when run in POP3S
>> mode
>> > POP3S_FLAGS=
>> >
>> > # Run an instance of perdition in IMAP4 mode
>> > # Set to "yes" to run this instance of perdition
>> > # Set to any other valye to not run this instance of perdition
>> > IMAP4=yes
>> >
>> > #Command line parameters to pass to perdition when run in IMAP4
>> mode
>> > IMAP4_FLAGS=
>> >
>> > # Run an instance of perdition in IMAP4S mode
>> > # Set to "yes" to run this instance of perdition
>> > # Set to any other valye to not run this instance of perdition
>> > IMAP4S=yes
>> >
>> > #Command line parameters to pass to perdition when run in IMAP4S
>> mode
>> > IMAP4S_FLAGS=
>> > * end *
>> >
>> >
>> > TIA
>> >
>> >
>> >
>> > B.R.
>> > Stephen L
>> >
>> >
>> >
>> >
>> >> >> For some reason I was thinking about the hints I gave you and
>> >> >> realized
>> >> >> I made a mistake. I forgot to mention that your client needs to
>> >> use
>> >> >> the domain while authenticating. So the test would be:
>> >> >>
>> >> >> $ echo "tag login username@domain password" | nc perdition_host
>> >> 143
>> >> >>
>> >> >> Without the domain (as I had written) perdition cannot resolve
>> >> which
>> >> >> server to connect.
>> >> >
>> >> >
>> >> > Tried again.
>> >> >
>> >> >
>> >> > xen11:~# /etc/init.d/perdition restart
>> >> > Stopped /usr/sbin/perdition.pop3 (pid 2878).
>> >> > No /usr/sbin/perdition.pop3s found running; none killed.
>> >> > No /usr/sbin/perdition.imap4 found running; none killed.
>> >> > No /usr/sbin/perdition.imaps found running; none killed.
>> >> > /usr/sbin/perdition.pop3 already running.
>> >> > Starting /usr/sbin/perdition.pop3s...
>> >> > Starting /usr/sbin/perdition.imap4...
>> >> > Starting /usr/sbin/perdition.imaps...
>> >> >
>> >> >
>> >> > xen11:~# echo "tag login [email protected] x10satimis" | nc
>> >> > xen11.satimis.com 143
>> >> > * OK [CAPABILITY IMAP4rev1 UIDPLUS CHILDREN NAMESPACE
>> >> > THREAD=ORDEREDSUBJECT THREAD=REFERENCES SORT QUOTA AUTH=CRAM-MD5
>> >> > AUTH=CRAM-SHA1 IDLE ACL ACL2=UNION STARTTLS] Courier-IMAP ready.
>> >> > Copyright 1998-2005 Double Precision, Inc.  See COPYING for
>> >> > distribution information.
>> >> > tag NO Login failed.
>> >> >
>> >> >
>> >> > Hanging here.  I have to exit it manually with [Ctrl]+c
>> >> >
>> >> >
>> >> > xen11:~# tail /var/log/mail.log
>> >> > Dec  3 14:37:01 xen11 imapd: LOGIN: ip=[::ffff:192.168.0.211],
>> >> > [email protected]
>> >> > Dec  3 14:37:01 xen11 imapd: LOGIN: ip=[::ffff:192.168.0.211],
>> >> > password=mypasswd
>> >> > Dec  3 14:37:01 xen11 authdaemond: received auth request,
>> >> service=imap,
>> >> > authtype=login
>> >> > Dec  3 14:37:01 xen11 authdaemond: authmysql: trying this module
>> >> > Dec  3 14:37:01 xen11 authdaemond: SQL query: SELECT id, "",
>> clear,
>> >> > uid, gid, home, concat(home,'/',maildir), "", name, "" FROM
>> users
>> >> WHERE
>> >> > id = "[email protected]" AND (enabled=1)
>> >> > Dec  3 14:37:01 xen11 authdaemond: supplied password does not
>> match
>> >> > clearpasswd
>> >> > Dec  3 14:37:01 xen11 authdaemond: authmysql: REJECT - try next
>> >> module
>> >> > Dec  3 14:37:01 xen11 authdaemond: FAIL, all modules rejected
>> >> > Dec  3 14:37:02 xen11 imapd: LOGIN FAILED,
>> >> [email protected],
>> >> > ip=[::ffff:192.168.0.211]
>> >> > Dec  3 14:37:20 xen11 imapd: Disconnected,
>> >> ip=[::ffff:192.168.0.211],
>> >> > time=19
>> >> >
>> >> >
>> >> > Still fail.
>> >> >
>> >> >
>> >> > B.R.
>> >> > Stephen L
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >> On Wed, Dec 3, 2008 at 15:49, Gustavo Luiz Duarte
>> >> >> <[email protected]> wrote:
>> >> >> > On Wed, Dec 3, 2008 at 15:27, Stephen Liu <[email protected]>
>> >> >> wrote:
>> >> >> >>
>> >> >> >> --- Gustavo Luiz Duarte <[email protected]> wrote:
>> >> >> >>
>> >> >> >>> On Wed, Dec 3, 2008 at 12:05, Stephen Liu
>> <[email protected]>
>> >> >> wrote:
>> >> >> >>> > Hi Gustavo,
>> >> >> >>> >
>> >> >> >>> >
>> >> >> >>> > I'll make 2 tests;
>> >> >> >>> >
>> >> >> >>> >
>> >> >> >>> > 1)
>> >> >> >>> > test1 - USING TEXT FILE
>> >> >> >>> >
>> >> >> >>> >
>> >> >> >>> > 2)
>> >> >> >>> > test2 - USING MYSQL
>> >> >> >>> >
>> >> >> >>> >
>> >> >> >>> > I have cloned an image of the routing mail server for
>> test2.
>> >> >> Now
>> >> >> >>> > proceed test1 first.
>> >> >> >>> >
>> >> >> >>> >
>> >> >> >>> > --- Gustavo Luiz Duarte <[email protected]> wrote:
>> >> >> >>> >
>> >> >> >>> >> Hi Stephen,
>> >> >> >>> >>
>> >> >> >>> >> You could use the transport table if the string "smtp:"
>> >> wasn't
>> >> >> >>> there.
>> >> >> >>> >> Do you really want to use mysql for the lookup? If you
>> have
>> >> >> only 3
>> >> >> >>> >> domain you could use a text file.
>> >> >> >>> >>
>> >> >> >>> >> USING TEXT FILE:
>> >> >> >>> >> $ cat << END > /etc/perdition_lookup.txt
>> >> >> >>> >> satimis.dnsalias.com:192.168.0.209
>> >> >> >>> >> satimis.changeip.net:192.168.0.208
>> >> >> >>> >> satimis.com:192.168.0.210
>> >> >> >>> >> END
>> >> >> >>> >>
>> >> >> >>> >> $ makegdbm /etc/perdition_lookup.gdbm.db <
>> >> >> >>> /etc/perdition_lookup.txt
>> >> >> >>> >>
>> >> >> >>> >> $ perdition -m /etc/perdition_lookup.gdbm.db --query_key
>> >> "\d"
>> >> >> >>> >
>> >> >> >>> >
>> >> >> >>> > Package installed - perdition-mysql
>> >> >> >>> >
>> >> >> >>> >
>> >> >> >>> > # apt-cache policy perdition-mysql
>> >> >> >>> > perdition-mysql:
>> >> >> >>> >  Installed: 1.17-7etch1
>> >> >> >>> >  Candidate: 1.17-7etch1
>> >> >> >>> >  Version table:
>> >> >> >>> >  *** 1.17-7etch1 0
>> >> >> >>> >        500 http://ftp.au.debian.org etch/main Packages
>> >> >> >>> >        500 http://security.debian.org stable/updates/main
>> >> >> Packages
>> >> >> >>> >        100 /var/lib/dpkg/status
>> >> >> >>> >
>> >> >> >>> >
>> >> >> >>> > # cat << END > /etc/perdition_lookup.txt
>> >> >> >>> >> satimis.dnsalias.com:192.168.0.209
>> >> >> >>> >> satimis.changeip.net:192.168.0.208
>> >> >> >>> >> satimis.com:192.168.0.210
>> >> >> >>> >> END
>> >> >> >>> >
>> >> >> >>> >
>> >> >> >>> > # which makegdbm
>> >> >> >>> > /usr/bin/makegdbm
>> >> >> >>> >
>> >> >> >>> >
>> >> >> >>> > # which perdition
>> >> >> >>> > /usr/sbin/perdition
>> >> >> >>> >
>> >> >> >>> >
>> >> >> >>> > # makegdbm /etc/perdition_lookup.gdbm.db <
>> >> >> >>> /etc/perdition_lookup.txt
>> >> >> >>> >
>> >> >> >>> > # perdition -m /etc/perdition_lookup.gdbm.db --query_key
>> >> "\d"
>> >> >> >>> > both without complaint
>> >> >> >>> >
>> >> >> >>> >
>> >> >> >>> > Now I haven't figured out how to test perdition.  There
>> are
>> >> 2
>> >> >> >>> databases
>> >> >> >>> > running on this routing mail server, MySQL maildb and
>> >> >> >>> > perdition_lookup.gdbm.db.  Do I need to stop MySQL maildb
>> to
>> >> >> test
>> >> >> >>> > perdition?  How can the remote mail clients connect their
>> >> mail
>> >> >> >>> servers?
>> >> >> >>> >  What server settings shall I use?  Please shed me some
>> >> light.
>> >> >> TIA
>> >> >> >>>
>> >> >> >>> No need for stopping you MySQL.
>> >> >> >>>
>> >> >> >>> If everything is wright (I haven't tested, I can have
>> skipped
>> >> >> >>> something), you can point your mail clients to the hostname
>> >> where
>> >> >> >>> perdition is installed and use it normally.
>> >> >> >>
>> >> >> >>
>> >> >> >> Sorry I can't resolve how can the mail client (Evolution)
>> find
>> >> its
>> >> >> >> server over Internet with following settings;
>> >> >> >
>> >> >> > The mail client doesn't know wich server to use. It always
>> use
>> >> the
>> >> >> > routing server. The routing server redirects it to the
>> correct
>> >> imap
>> >> >> > server. Make sure your are using the right protocol imap4 or
>> >> >> imap4s.
>> >> >> >
>> >> >> >>
>> >> >> >> Server Type: IMAP
>> >> >> >>
>> >> >> >> Server : xen11.satimis.com (hostname of the routing mail
>> server
>> >> >> where
>> >> >> >> perdition is running
>> >> >> >>
>> >> >> >> User: satimis
>> >> >> >>
>> >> >> >>
>> >> >> >> satimis is user of satimis.com, satimis.changeip.net and
>> >> >> >> satimis.dnsalias.com as well as user of the routing mail
>> >> server,
>> >> >> >> xen11.satimis.com
>> >> >> >>
>> >> >> >>
>> >> >> >> I tried it without success.
>> >> >> >>
>> >> >> >>
>> >> >> >>> Note that perdition's default protocol is pop3. To use imap
>> >> suply
>> >> >> the
>> >> >> >>> option -P IMAP4
>> >> >> >>
>> >> >> >>
>> >> >> >> xen11:~# /etc/init.d/perdition start
>> >> >> >> /usr/sbin/perdition.pop3 already running.
>> >> >> >> Starting /usr/sbin/perdition.pop3s...
>> >> >> >> Starting /usr/sbin/perdition.imap4...
>> >> >> >> Starting /usr/sbin/perdition.imaps...
>> >> >> >
>> >> >> > How are you configuring perdition? Have you modified your
>> >> >> > /etc/init.d/perdition script to contain the correct
>> parameters?
>> >> >> >
>> >> >> >>
>> >> >> >>
>> >> >> >> xen11:~# hostname
>> >> >> >> xen11.satimis.com
>> >> >> >>
>> >> >> >>
>> >> >> >> pop3 is already running.  I have to manually run
>> >> >> /etc/init.d/perdition
>> >> >> >> to start pop3s, imap4 and imaps
>> >> >> >>
>> >> >> >>
>> >> >> >>> You can use nc to test it:
>> >> >> >>> $ echo "tag login username password" | nc perdition_host
>> 143
>> >> >> >>> In username and password you use valid username and
>> password
>> >> for
>> >> >> your
>> >> >> >>> real imap server.
>> >> >> >>
>> >> >> >>
>> >> >> >> I suppose running above command on the routing mail server
>> >> where
>> >> >> >> perdition is installed.
>> >> >> >>
>> >> >> >>
>> >> >> >> # echo "tag login satimis mypassword" | nc xen11.satimis.com
>> >> 143
>> >> >> >> * OK [CAPABILITY IMAP4rev1 UIDPLUS CHILDREN NAMESPACE
>> >> >> >> THREAD=ORDEREDSUBJECT THREAD=REFERENCES SORT QUOTA
>> >> AUTH=CRAM-MD5
>> >> >> >> AUTH=CRAM-SHA1 IDLE ACL ACL2=UNION STARTTLS] Courier-IMAP
>> >> ready.
>> >> >> >> Copyright 1998-2005 Double Precision, Inc.  See COPYING
>> >> >> fordistribution
>> >> >> >> information.
>> >> >> >> tag NO Login failed.
>> >> >> >>
>> >> >> >>
>> >> >> >>> For pop3:
>> >> >> >>> $ echo -e "user username\npass password | nc perdition_host
>> >> 110
>> >> >> >>
>> >> >> >> xen11:~# echo -e "user satimis\npass x11satimis | nc
>> >> >> xen11.satimis.com
>> >> >> >> 110
>> >> >> >>>
>> >> >> >> waiting for input
>> >> >> >
>> >> >> > You can look at perdition logs to find information about what
>> is
>> >> >> going on.
>> >> >> >
>> >> >> >>
>> >> >> >>
>> >> >> >>> No special configuration is need for your pop/imap servers.
>> >> Just
>> >> >> >>> assure that they are listening on standard ports.
>> >> >> >>
>> >> >> >>
>> >> >> >> I have only ONE external IP.  All ports are forwarded to the
>> >> >> routing
>> >> >> >> mail server except port 53.
>> >> >> >>
>> >> >> >>
>> >> >> >> B.R.
>> >> >> >> Stephen L
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >> >>> []'s
>> >> >> >>> Gustavo Duarte
>> >> >> >>>
>> >> >> >>> >
>> >> >> >>> >
>> >> >> >>> > B.R.
>> >> >> >>> > Stephen
>> >> >> >>> >
>> >> >> >>> >
>> >> >> >>> >
>> >> >> >>> >
>> >> >> >>> >
>> >> >> >>> >
>> >> >> >>> >
>> >> >> >>> >>
>> >> >> >>> >> USING MYSQL:
>> >> >> >>> >> You have some alternatives:
>> >> >> >>> >> 1. Continue with your tblPerdition and populate it, so
>> that
>> >> >> user
>> >> >> >>> >> column has the domain, hostname column has the localIP
>> and
>> >> >> port
>> >> >> >>> >> column
>> >> >> >>> >> you leave empty (supposing your real pop/imap servers
>> >> listen
>> >> >> to
>> >> >> >>> >> standard ports).
>> >> >> >>> >>
>> >> >> >>> >> Then you would do (supposing you have mysql perdition
>> >> library
>> >> >> in
>> >> >> >>> >> /usr/lib):
>> >> >> >>> >>
>> >> >> >>> >> perdition -M /usr/lib/libperditiondb_mysql.so.0
>> --query_key
>> >> >> "\d"
>> >> >> >>> -m
>> >> >> >>> >>
>> >> >>
>> "<dbhost>:<dbport>:dbPerdition:tblPerdition:perdition:perdition"
>> >> >> >>> >>
>> >> >> >>> >> (substituting <dbhost> and <dbport> by you db hostname
>> and
>> >> >> port)
>> >> >> >>> >>
>> >> >> >>> >>
>> >> >> >>> >> 2. Modify your transport table so that the string smtp
>> and
>> >> >> localIP
>> >> >> >>> >> are
>> >> >> >>> >> in diferent columns. Then you create a view
>> concatenating
>> >> them
>> >> >> for
>> >> >> >>> >> the
>> >> >> >>> >> postfix query. A bit more complicated but easier to
>> >> maintain
>> >> >> when
>> >> >> >>> you
>> >> >> >>> >> have lots of domains and servers.
>> >> >> >>> >>
>> >> >> >>> >> []'s
>> >> >> >>> >> Gustavo Duarte
>> >> >> >>> >>
>> >> >> >>> >> On Wed, Dec 3, 2008 at 02:28, Stephen Liu
>> >> <[email protected]>
>> >> >> >>> wrote:
>> >> >> >>> >> > Hi Gustavo,
>> >> >> >>> >> >
>> >> >> >>> >> >
>> >> >> >>> >> >> The URL I sent you has information about using mysql
>> as
>> >> >> lookup
>> >> >> >>> >> >> library:
>> >> >> >>> >> >>
>> >> http://www.vergenet.net/linux/perdition/perditiondb.5.shtml
>> >> >> >>> >> >
>> >> >> >>> >> >
>> >> >> >>> >> > I suppose you're referring to following section;
>> >> >> >>> >> >
>> >> >> >>> >> >
>> >> >> >>> >> > MYSQL
>> >> >> >>> >> > This map library can be used by specifying the full
>> path
>> >> to
>> >> >> the
>> >> >> >>> >> library
>> >> >> >>> >> > using the -M|--map_library command line option or
>> >> >> configuration
>> >> >> >>> >> file
>> >> >> >>> >> > option.
>> >> >> >>> >> >
>> >> >> >>> >> > E.g.
>> >> >> >>> >> > perdition -M /usr/lib/libperditiondb_mysql.so.0
>> >> >> >>> >> > ......
>> >> >> >>> >> >
>> >> >> >>> >> >
>> >> >> >>> >> > I'll start from there.
>> >> >> >>> >> >
>> >> >> >>> >> >
>> >> >> >>> >> > I suppose the name of this database is "dbPerdition"
>> to
>> >> be
>> >> >> >>> created
>> >> >> >>> >> on
>> >> >> >>> >> > MySQL
>> >> >> >>> >> >
>> >> >> >>> >> >
>> >> >> >>> >> > mysql> create database dbPerdition;
>> >> >> >>> >> >
>> >> >> >>> >> >
>> >> >> >>> >> > mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
>> >> >> >>> >> >    -> ON dbPerdition.* TO 'perdition' IDENTIFIED by
>> >> >> 'perdition';
>> >> >> >>> >> >
>> >> >> >>> >> > the 1st "perdition" on above second line is "database
>> >> user".
>> >> >> >>> The
>> >> >> >>> >> 2nd
>> >> >> >>> >> > "perdition" is "database password".
>> >> >> >>> >> >
>> >> >> >>> >> >
>> >> >> >>> >> > mysql> CREATE TABLE `tblPerdition` (
>> >> >> >>> >> >    -> `user` varchar(128), null '' default '',
>> >> >> >>> >> >    -> `servername` varchar(255) null '' default '',
>> >> >> >>> >> >    -> `port` varchar(8) YES NULL,
>> >> >> >>> >> >    -> PRIMARY KEY (`user`),
>> >> >> >>> >> >    -> ) ;
>> >> >> >>> >> >
>> >> >> >>> >> >
>> >> >> >>> >> > Afterwards I'll edit data on 'tblPerdition" table.
>> >> >> >>> >> >
>> >> >> >>> >> >
>> >> >> >>> >> >> The table you've shown doesn't have information about
>> >> the
>> >> >> >>> >> >> hostnames/localIPs. Where is it? In the transport
>> table?
>> >> >> >>> >> >
>> >> >> >>> >> >
>> >> >> >>> >> > Yes.
>> >> >> >>> >> >
>> >> >> >>> >> > mysql> SELECT * from transport;
>> >> >> >>> >> >
>> >> >> >>> >>
>> >> >> >>> >
>> >> >> >>>
>> >> >> >>
>> >> >>
>> >> >
>> >>
>> >
>>
> +------+----------------------+--------------------+-----------+---------+
>> >> >> >>> >> > | pkid | domain               | hostname           |
>> >> >> transport |
>> >> >> >>> >> > enabled |
>> >> >> >>> >> >
>> >> >> >>> >>
>> >> >> >>> >
>> >> >> >>>
>> >> >> >>
>> >> >>
>> >> >
>> >>
>> >
>>
> +------+----------------------+--------------------+-----------+---------+
>> >> >> >>> >> > |    1 | satimis.dnsalias.com | smtp:192.168.0.209 |
>> :[]
>> >> >>   |
>> >> >> >>> >> > 1 |
>> >> >> >>> >> > |    2 | satimis.changeip.net | smtp:192.168.0.208 |
>> :[]
>> >> >>   |
>> >> >> >>> >> > 1 |
>> >> >> >>> >> > |    3 | satimis.com          | smtp:192.168.0.210 |
>> :[]
>> >> >>   |
>> >> >> >>> >> > 1 |
>> >> >> >>> >> >
>> >> >> >>> >>
>> >> >> >>> >
>> >> >> >>>
>> >> >> >>
>> >> >>
>> >> >
>> >>
>> >
>>
> +------+----------------------+--------------------+-----------+---------+
>> >> >> >>> >> > 3 rows in set (0.00 sec)
>> >> >> >>> >> >
>> >> >> >>> >> >
>> >> >> >>> >> > # cat /etc/postfix/mysql_transport_maps.cf
>> >> >> >>> >> > user=mail
>> >> >> >>> >> > password=mypassword
>> >> >> >>> >> > dbname=maildb
>> >> >> >>> >> > table=transport
>> >> >> >>> >> > select_field=hostname
>> >> >> >>> >> > where_field=domain
>> >> >> >>> >> > hosts=127.0.0.1
>> >> >> >>> >> > additional_conditions = and enabled = 1
>> >> >> >>> >> > * end *
>> >> >> >>> >> >
>> >> >> >>> >> >
>> >> >> >>> >> >> 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.
>> >> >> >>> >> >
>> >> >> >>> >> >
>> >> >> >>> >> > Whether you meant "--query_key FORMAT[,FORMAT...]:"
>> on;
>> >> >> >>> >> >
>> >> >> >>> >> >
>> http://www.vergenet.net/linux/perdition/perdition.8.shtml
>> >> >> >>> >> >
>> >> >> >>> >> >
>> >> >> >>> >> > Thanks
>> >> >> >>> >> >
>> >> >> >>> >> >
>> >> >> >>> >> > 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
>> >> >> >>> >
>> >> >> >>>
>> >> >> >>
>> >> >> >>
>> >> >> >> 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
>> >> >
>> >>
>> >
>> >
>> > 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