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

Hi Gustavo,


Further to my last posting.  Performed following test.


On the routing mail server:-

xen11:~# nano /etc/perdition/perdition.conf
add and uncomment following lines;

connection_logging
connection_limit 1000
map_library /usr/lib/libperditiondb_mysql.so.0
map_library_opt "localhost:3306:db:table:user:password"
username_from_database
outgoing_server  127.0.0.1

bind_address 127.0.0.1
* end *


xen11:~# /etc/init.d/perdition restart
Stopped /usr/sbin/perdition.pop3 (pid 3972).
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:~# tail -f /var/log/syslog | grep perdition
Dec  3 16:56:46 xen11 perdition[3981]: Error loading certificate chain
file "/etc/perdition/perdition.cert"
Dec  3 16:56:46 xen11 perdition[3981]: Fatal error establishing SSL
context for listening
Dec  3 17:05:51 xen11 perdition[3972]: Exiting on signal 15
Dec  3 17:05:51 xen11 perdition[4004]: version=1.17, add_domain="",
authenticate_in=off, bind_address="127.0.0.1", capability="UIDL  USER",
client_server_specification=off,
config_file="/etc/perdition/perdition.conf", connection_limit=64,
connection_logging=on, connect_relog=300, debug=off,
domain_delimiter="@", explicit_domain="", group="nogroup",
inetd_mode=off, listen_port="110", log_facility="mail",
login_disabled=off, lower_case="",
map_library="/usr/lib/libperditiondb_mysql.so.0",
map_library_opt="localhost:3306:db:table:user:password",
no_bind_banner=off, no_daemon=off, no_lookup=off,
nodename="xen11.satimis.com", ok_line="You are so in",
outgoing_port="110", outgoing_server="127.0.0.1",
pid_file="/var/run/perdition.pop3/perdition.pop3.pid", protocol="POP3",
server_resp_line=off, strip_domain="", timeout=1800, username="nobody",
username_from_database=on, query_key="", quiet=off, ssl_mode="",
ssl_ca_file="", ssl_ca_path="/etc/perdition/perdition.ca/",
ssl_ca_accept_self_signed="off", ssl_cert_file="/et
Dec  3 17:05:51 xen11 perdition[4007]: Error loading certificate chain
file "/etc/perdition/perdition.crt.pem"
Dec  3 17:05:51 xen11 perdition[4007]: Fatal error establishing SSL
context for listening
Dec  3 17:05:51 xen11 perdition[4010]: version=1.17, add_domain="",
authenticate_in=off, bind_address="127.0.0.1", capability="IMAP4
IMAP4REV1", client_server_specification=off,
config_file="/etc/perdition/perdition.conf", connection_limit=64,
connection_logging=on, connect_relog=300, debug=off,
domain_delimiter="@", explicit_domain="", group="nogroup",
inetd_mode=off, listen_port="143", log_facility="mail",
login_disabled=off, lower_case="",
map_library="/usr/lib/libperditiondb_mysql.so.0",
map_library_opt="/etc/perdition_lookup.gdbm.db", no_bind_banner=off,
no_daemon=off, no_lookup=off, nodename="xen11.satimis.com",
ok_line="You are so in", outgoing_port="143",
outgoing_server="127.0.0.1",
pid_file="/var/run/perdition.imap4/perdition.imap4.pid",
protocol="IMAP4", server_resp_line=off, strip_domain="", timeout=1800,
username="nobody", username_from_database=on, query_key="'\d'",
quiet=off, ssl_mode="", ssl_ca_file="",
ssl_ca_path="/etc/perdition/perdition.ca/",
ssl_ca_accept_self_signed="off", ssl_cert_file=
Dec  3 17:05:51 xen11 perdition[4010]: Fatal error listening for
connections. Exiting.
Dec  3 17:05:51 xen11 perdition[4013]: Error loading certificate chain
file "/etc/perdition/perdition.crt.pem"
Dec  3 17:05:51 xen11 perdition[4013]: Fatal error establishing SSL
context for listening


hanging here.


B.R.
Stephen L







--- Stephen Liu <[email protected]> wrote:

> 
> --- Gustavo Luiz Duarte <[email protected]> wrote:
> 
> > Well, it worked. Now your courier imap is rejecting the user/pass
> you
> > supplied.
> 
> 
> Hi Gustavo,
> 
> 
> Yes, it works.  I must use the password on the user.table of MySQL
> maildb, NOT the password to login the mail server.
> 
> 
> 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-SHA1 IDLE ACL ACL2=UNION STARTTLS] Courier-IMAP ready.
> Copyright 1998-2005 Double Precision, Inc.  See COPYING for
> distribution information.
> tag OK LOGIN Ok.
> 
> 
> xen11:~# tail /var/log/mail.log
> Dec  3 16:27:40 xen11 imapd: LOGIN: ip=[::ffff:192.168.0.211],
> command=LOGIN
> Dec  3 16:27:40 xen11 imapd: LOGIN: ip=[::ffff:192.168.0.211],
> [email protected]
> Dec  3 16:27:40 xen11 imapd: LOGIN: ip=[::ffff:192.168.0.211],
> password=mypasswd
> Dec  3 16:27:40 xen11 authdaemond: received auth request,
> service=imap,
> authtype=login
> Dec  3 16:27:40 xen11 authdaemond: authmysql: trying this module
> Dec  3 16:27:40 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 16:27:40 xen11 authdaemond: authmysql: sysusername=<null>,
> sysuserid=5000, sysgroupid=5000, homedir=/var/spool/mail/virtual,
> [email protected], fullname=Stephen,
> maildir=/var/spool/mail/virtual/Stephen/, quota=<null>,
> options=<null>
> Dec  3 16:27:40 xen11 authdaemond: Authenticated: sysusername=<null>,
> sysuserid=5000, sysgroupid=5000, homedir=/var/spool/mail/virtual,
> [email protected], fullname=Stephen,
> maildir=/var/spool/mail/virtual/Stephen/, quota=<null>,
> options=<null>
> Dec  3 16:27:40 xen11 imapd: LOGIN, [email protected],
> ip=[::ffff:192.168.0.211], protocol=IMAP
> Dec  3 16:28:14 xen11 imapd: DISCONNECTED, [email protected],
> ip=[::ffff:192.168.0.211], headers=0, body=0, rcvd=0, sent=18,
> time=34
> 
> 
> With the same password on Evolution I can send mails but can't
> receive
> mails.
> 
> 
> IMAPrev1
> Server: xen11.satimis.com
> username: [email protected]
> 
> 
> Error while Scanning folders in "IMAP server xen11.satimis.com".
> Failed sending command to IMAP server xen11.satimis.com: Interrupted
> system call
> 
> 
> xen11:~# tail /var/log/mail.log
> Dec  3 17:02:13 xen11 authdaemond: authmysql: sysusername=<null>,
> sysuserid=5000, sysgroupid=5000, homedir=/var/spool/mail/virtual,
> [email protected], fullname=Stephen,
> maildir=/var/spool/mail/virtual/Stephen/, quota=<null>,
> options=<null>
> Dec  3 17:02:13 xen11 authdaemond: Authenticated: sysusername=<null>,
> sysuserid=5000, sysgroupid=5000, homedir=/var/spool/mail/virtual,
> [email protected], fullname=Stephen,
> maildir=/var/spool/mail/virtual/Stephen/, quota=<null>,
> options=<null>
> Dec  3 17:02:13 xen11 imapd: LOGIN, [email protected],
> ip=[::ffff:192.168.0.110], protocol=IMAP
> Dec  3 17:03:25 xen11 postfix/anvil[3590]: statistics: max connection
> rate 1/60s for (smtp:220.232.213.178) at Dec  3 16:57:27
> Dec  3 17:03:25 xen11 postfix/anvil[3590]: statistics: max connection
> count 1 for (smtp:220.232.213.178) at Dec  3 16:57:27
> Dec  3 17:03:25 xen11 postfix/anvil[3590]: statistics: max cache size
> 1
> at Dec  3 16:57:27
> Dec  3 17:05:44 xen11 imapd: DISCONNECTED, [email protected],
> ip=[::ffff:192.168.0.110], headers=6318, body=0, rcvd=7778,
> sent=61498,
> time=211
> Dec  3 17:05:52 xen11 imapd: Connection, ip=[::ffff:192.168.0.110]
> Dec  3 17:05:52 xen11 imapd: LOGIN: ip=[::ffff:192.168.0.110],
> command=CAPABILITY
> Dec  3 17:06:14 xen11 imapd: Disconnected, ip=[::ffff:192.168.0.110],
> time=22
> 
> 
> A further question, on remote PC how can remote mail client find the
> server-xen11.satimis.com?  Use the external IP of the routing mail
> server?
> 
> 
> B.R.
> Stephen
> 
>  
> > 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
> > >
> > 
> 
> 
> 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