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 <satimis(a)yahoo.com> wrote:
--- Gustavo Luiz Duarte <gustavold(a)gmail.com> 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 satimis(a)satimis.com 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],
username=satimis(a)satimis.com
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 = "satimis(a)satimis.com" AND (enabled=1)
Dec 3 16:27:40 xen11 authdaemond: authmysql: sysusername=<null>,
sysuserid=5000, sysgroupid=5000, homedir=/var/spool/mail/virtual,
address=satimis(a)satimis.com, 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,
address=satimis(a)satimis.com, fullname=Stephen,
maildir=/var/spool/mail/virtual/Stephen/, quota=<null>,
options=<null>
Dec 3 16:27:40 xen11 imapd: LOGIN, user=satimis(a)satimis.com,
ip=[::ffff:192.168.0.211], protocol=IMAP
Dec 3 16:28:14 xen11 imapd: DISCONNECTED, user=satimis(a)satimis.com,
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: satimis(a)satimis.com
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,
address=satimis(a)satimis.com, 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,
address=satimis(a)satimis.com, fullname=Stephen,
maildir=/var/spool/mail/virtual/Stephen/, quota=<null>,
options=<null>
Dec 3 17:02:13 xen11 imapd: LOGIN, user=satimis(a)satimis.com,
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, user=satimis(a)satimis.com,
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
<satimis(a)yahoo.com>
wrote:
--- Gustavo Luiz Duarte <gustavold(a)gmail.com> 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 satimis(a)satimis.com 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],
username=satimis(a)satimis.com
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 = "satimis(a)satimis.com" 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,
user=satimis(a)satimis.com,
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 <satimis(a)yahoo.com>
wrote:
> >
> > --- Gustavo Luiz Duarte <gustavold(a)gmail.com> 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 satimis(a)satimis.com 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],
> >> > username=satimis(a)satimis.com
> >> > 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 = "satimis(a)satimis.com" 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,
> >> user=satimis(a)satimis.com,
> >> > 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
> >> >> <gustavold(a)gmail.com> wrote:
> >> >> > On Wed, Dec 3, 2008 at 15:27, Stephen Liu
<satimis(a)yahoo.com>
>> >> >> wrote:
>> >> >> >>
>> >> >> >> --- Gustavo Luiz Duarte <gustavold(a)gmail.com>
wrote:
>> >> >> >>
>> >> >> >>> On Wed, Dec 3, 2008 at 12:05, Stephen Liu
>> <satimis(a)yahoo.com>
>> >> >> 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
<gustavold(a)gmail.com> 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
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
> >> <satimis(a)yahoo.com>
> >> >> >>> 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
>> >> >> >>> >> > Perdition-users(a)vergenet.net
>> >> >> >>> >> >
http://lists.vergenet.net/listinfo/perdition-users
>> >> >>> >> >
>> >> >>> >>
>> >> >>> >
>> >> >>> >
>> >> >>> > Send instant messages to your online friends
>> >> >>>
http://uk.messenger.yahoo.com
>> >> >>> > ______________________________________________
>> >> >>> > Perdition-users mailing list
>> >> >>> > Perdition-users(a)vergenet.net
>> >> >>> >
http://lists.vergenet.net/listinfo/perdition-users
>> >> >>> >
>> >> >>>
>> >> >>
>> >> >>
>> >> >> Send instant messages to your online friends
>> >>
http://uk.messenger.yahoo.com
>> >> >> ______________________________________________
>> >> >> Perdition-users mailing list
>> >> >> Perdition-users(a)vergenet.net
>> >> >>
http://lists.vergenet.net/listinfo/perdition-users
>> >> >>
>> >> >
>> >>
>> >
>> >
>> > Send instant messages to your online friends
>>
http://uk.messenger.yahoo.com
>> > ______________________________________________
>> > Perdition-users mailing list
>> > Perdition-users(a)vergenet.net
>> >
http://lists.vergenet.net/listinfo/perdition-users
>> >
>>
>
>
> Send instant messages to your online friends
http://uk.messenger.yahoo.com
______________________________________________
Perdition-users mailing list
Perdition-users(a)vergenet.net
http://lists.vergenet.net/listinfo/perdition-users
Send instant messages to your online friends
http://uk.messenger.yahoo.com
______________________________________________
Perdition-users mailing list
Perdition-users(a)vergenet.net
http://lists.vergenet.net/listinfo/perdition-users
Send instant messages to your online friends
http://uk.messenger.yahoo.com
______________________________________________
Perdition-users mailing list
Perdition-users(a)vergenet.net
http://lists.vergenet.net/listinfo/perdition-users
Send instant messages to your online friends
http://uk.messenger.yahoo.com