which pop3d and imap daemons work with mysql?

[T Halter]

I've installed sendmail+MySQL on a redhat (kernel 2.4.18-27.7).
Which pop3d and imap daemons will work with this setup?
Does it require a new procmail install?  I read something about procmail+mysql installed above.  Is that a required step?

I know through sendmail -bt that the linking to the maps is working for the virtuser table.  I'm not sure it is working for the aliases table.  If I insert a simple alias such as root > myuser and I do a /map aliases root, I get this output:

ADDRESS TEST MODE (ruleset 3 NOT automatically invoked)
Enter <ruleset> <address>
> /map aliases root
map_lookup: aliases (root) no match (68)
>

Can you setup global domain addresses with it?  If I do a global in the virtuser table, and I test it, I get the following:
ADDRESS TEST MODE (ruleset 3 NOT automatically invoked)
Enter <ruleset> <address>
> /map aliases root
map_lookup: aliases (root) no match (68)
> /map virtuser @test6.tomtesting.com         
map_lookup: virtuser (@test6.tomtesting.com) returns tom (0)
> /map virtuser tom@test6.tomtesting.com
map_lookup: virtuser (tom@test6.tomtesting.com) no match (68)

Obligatory Output (hostname changed to protect the innocent):
[root@mybox pop3d]# sendmail -bp -d27.4
/var/spool/mqueue is empty
                Total requests: 0
[root@mybox pop3d]# sendmail -bp -d28.4
/var/spool/mqueue is empty
                Total requests: 0
[root@mybox pop3d]# sendmail -bp -d37.4 
setdefaults: DefUser=mailnull, DefUid=47, DefGid=47
inittimeouts(<NULL>)
fileclass(/etc/mail/relay-domains, fmt=%s)
setoption SevenBitInput (7)=False
setoption AliasWait (a)=10
setoption MinFreeBlocks (b)=100
setoption BlankSub (B)=.
setoption HoldExpensive (c)=False
setoption DeliveryMode (d)=background
setoption TempFileMode (F)=0600
setoption HelpFile (H)=/etc/mail/helpfile
setoption SendMimeErrors (j)=True
setoption ForwardPath (J)=$z/.forward.$w+$h:$z/.forward+$h:$z/.forward.$w:$z/.forward
setoption ConnectionCacheSize (k)=2
setoption ConnectionCacheTimeout (K)=5m
setoption UseErrorsTo (l)=False
setoption LogLevel (L)=9
setoption CheckAliases (n)=False
setoption OldStyleHeaders (o)=True
setoption DaemonPortOptions (O)=Name=MTA
Daemon MTA flags:
setoption DaemonPortOptions (O)=Port=587, Name=MSA, M=E
Daemon MSA flags: <NOETRN>
setoption PrivacyOptions (p)=authwarnings
setoption QueueDirectory (Q)=/var/spool/mqueue
setoption Timeout (r).queuereturn=5d
settimeout(queuereturn = 5d)
setoption Timeout (r).queuewarn=4h
settimeout(queuewarn = 4h)
setoption SuperSafe (s)=True
setoption StatusFile (S)=/etc/mail/statistics
setoption SmtpGreetingMessage (0x90)=$j Sendmail $v/$Z; $b
setoption UnixFromLine (0x91)=From $g $d
setoption OperatorChars (0x92)=.:%@!^/[]+
setoption MaxHeadersLength (0xaa)=32768
/var/spool/mqueue is empty
                Total requests: 0
[root@mybox pop3d]# sendmail -bp -d38.20
/var/spool/mqueue is empty
                Total requests: 0
[root@mybox pop3d]# sendmail -bp -d39.20
/var/spool/mqueue is empty
                Total requests: 0

Any assistance with this would be greatly appreciated.

T. Halter
SysAd
VSN

[Kev Green]

Hi,

Try using cyrus-imapd, and pam-mysql to allow you to authenticate IMAP/POP users via mysql.

You've missed some debug output from the above as it doesn't include all of the relevant debug flags.

Also note that you can run all of the debug flags at the same time by doing eg.

sendmail -bp -d39.20,38.20,...

With all of the debugging flags you want to use at once.

K.

[Alexander Newald]

courier can auth to mysql be default and works well for me

[Nicolas Sigal]

a nice pop3 is a tpop3d, this supports mysql, ssl and is very flexible to configure your querys..

[GG]

qmail + mysql is awailable on this link:
http://www.softagency.co.jp/mysql/qmail.en.html

mysql + imap is here:
http://www.softagency.co.jp/mysql/pro/imap.html