I have installed sendmail 8.10.1 with patch from Paul Khavine and procmail
 3.13 with patch. Sendmail is up and running with mysql. I have compiled
qpopper-mysql with:
./configure  --enable-servermode --enable-shy --enable-specialauth
--enable-temp-drop-dir=/var/spool/mail/.pop --disable-check-pw-max
--enable-fast-update --prefix=/usr --disable-hash-dir-check
--enable-standalone --enable-mysql --enable-log-login-mysql
--with-mysqllibpath=/usr/lib/mysql
--with-mysqlincludepath=/usr/include/mysql
--with-mysqlconbfig=/etc/mysql-popper.conf


I have mail in /var/spool/mail/jfaubin with permission 1777 for the tests
I have a symbolic link /var/mail /var/spool/mail

 I telnet localhost 110

 Connected to localhost.localdomain.
 Escape...

 +OK ready
   user jfaubin
   pass password


      The System must return:

    +ok jfaubin has 0 visible messages (0 hidden) in 0 octets.

    I include message from my syslog:

     Aug 23 23:53:52 jfsrv01 popper[30289]: popper: Server: first fork();
   child=30290;
   > exiting [main.c:374]
   > Aug 23 23:53:52 jfsrv01 popper[30290]: popper: Server: child of first
   fork();
   > pid=30290 [main.c:379]
   > Aug 23 23:53:52 jfsrv01 popper[30291]: popper: Server: child of second
   > fork(); pid=30291 [main.c:409]
   > Aug 23 23:53:52 jfsrv01 popper[30291]: calling chdir() [main.c:422]
   > Aug 23 23:53:52 jfsrv01 popper[30291]: closing file descs 1024 to 0
   [main.c:444]
   > Aug 23 23:53:52 jfsrv01 popper[30291]: opened stream socket; sockfd =
   4
   > [main.c:481]
   > Aug 23 23:53:52 jfsrv01 popper[30291]: set stream socket options;
   sockfd
   > = 4 [main.c:498]
   > Aug 23 23:53:52 jfsrv01 popper[30291]: did bind on stream socket;
   sockfd
   > = 4 [main.c:521]
   > Aug 23 23:53:52 jfsrv01 popper[30291]: popper: Server: listening on
   0.0.0.0:110
   > [main.c:529]
   > Aug 23 23:53:52 jfsrv01 popper[30291]: listening using socket fd 4
   [main.c:533]
   > Aug 23 23:53:52 jfsrv01 popper[30291]: set fd 4 non-blocking (0x802)
   [main.c:547]
   > Aug 23 23:53:52 jfsrv01 popper[30290]: popper: Server: second fork();
   child=30291;
   > exiting [main.c:404]
   > Aug 23 23:53:59 jfsrv01 popper[30291]: accept=6; sockfd=4; clilen=16;
   cli_addr=127.0.0.1:38222
   > [main.c:607]
   > Aug 23 23:53:59 jfsrv01 popper[30291]: new connection; fd=6
   [main.c:894]
   > Aug 23 23:53:59 jfsrv01 popper[30291]: forked() for new connection;
   pid=30294
   > [main.c:969]
   > Aug 23 23:53:59 jfsrv01 popper[30294]: new child for connection
   [main.c:903]
   > Aug 23 23:53:59 jfsrv01 popper[30294]: newsockfd (6) flags: 0x2
   [main.c:924]
   > Aug 23 23:53:59 jfsrv01 /usr/sbin/popper[30294]: Debugging turned on
   (-d)
   > [pop_init.c:708]
   > Aug 23 23:53:59 jfsrv01 /usr/sbin/popper[30294]: timeout = 600 (-T)
   [pop_init.c:860]
   > Aug 23 23:53:59 jfsrv01 /usr/sbin/popper[30294]: (v4.0.3-mysql-0.1)
   Servicing
   > request from "localhost" at 127.0.0.1 [pop_init.c:1152]
   > Aug 23 23:53:59 jfsrv01 /usr/sbin/popper[30294]: before TLS;
   tls_support==0
   > [popper.c:194]
   > Aug 23 23:53:59 jfsrv01 /usr/sbin/popper[30294]: Skipped TLS Init
   [popper.c:219]
   > Aug 23 23:53:59 jfsrv01 /usr/sbin/popper[30294]: (v4.0.3-mysql-0.1)
   Intro
   > [popper.c:261]
   > Aug 23 23:53:59 jfsrv01 /usr/sbin/popper[30294]: +OK ready
   [popper.c:269]
   > Aug 23 23:53:59 jfsrv01 /usr/sbin/popper[30294]: Qpopper ready for
   input
   > from (null) at localhost [127.0.0.1] [popper.c:306]
   > Aug 23 23:54:04 jfsrv01 /usr/sbin/popper[30294]: Received (12): "user
   jfaubin"
   > [pop_get_command.c:105]
   > Aug 23 23:54:04 jfsrv01 /usr/sbin/popper[30294]: home via mysql (9):
   '/var/mail'
   > [pop_user.c:404]
   > Aug 23 23:54:04 jfsrv01 /usr/sbin/popper[30294]: +OK Password required
   > for jfaubin. [pop_user.c:625]
   > Aug 23 23:54:04 jfsrv01 /usr/sbin/popper[30294]: user returned 1;
   CurrentState
   > now auth2 [popper.c:350]
   > Aug 23 23:54:04 jfsrv01 /usr/sbin/popper[30294]: Qpopper ready for
   input
   > from jfaubin at localhost [127.0.0.1] [popper.c:306]
   > Aug 23 23:54:11 jfsrv01 /usr/sbin/popper[30294]: Received: "pass
   xxxxxxxxx"
   > [pop_get_command.c:96]
   > Aug 23 23:54:11 jfsrv01 /usr/sbin/popper[30294]: ...built: (39)
   '/var/mail/'
   > [genpath.c:158]
   > Aug 23 23:54:11 jfsrv01 /usr/sbin/popper[30294]: genpath Spool (1)
   [hash:
   > 0; home: NULL] for user 0?^]@0?^]@8?^]@8?^]@@?^]@@?^]@H?^]@H?^]@P?^]
   @P?^]@X?^]@X?^]@`?^]@`?^]@h?^]@h?^]@p?^]@p?^]@x?^]@x?^]@\200?^]@\200?^]
   @\210?^]@\210?^]@\220?^]@\220?^]@\230?^]@\
   > 230?^]@ ?^]@ ?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?
   ^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@
   > returning /var/mail/0?^]@0?^]@8?^]@8?^]@@?^]@@?^]@H?^]@H?^]@P?^]@P?^]
   @X?^]@X?^]@`?^]@`?^]@h?^]@h?^]@p?^]@p?^]@x?^]@x?^]@\200?^]
   > @\200?^]@\210?^]@\210?^]@\220?^]@\220?^]@\230?^]@\230?^]@ ?^]@ ?^]@?^]
   @?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]
   @?^]@?^]@?^]@
   > [genpath.c:229]
   > Aug 23 23:54:11 jfsrv01 /usr/sbin/popper[30294]: ...built: (65)
   '/var/spool/mail/.pop/'
   > [genpath.c:158]
   > Aug 23 23:54:11 jfsrv01 /usr/sbin/popper[30294]: genpath .pop (2)
   [hash:
   > 0; home: NULL] for user 0?^]@0?^]@8?^]@8?^]@@?^]@@?^]@H?^]@H?^]@P?^]
   @P?^]@X?^]@X?^]@`?^]@`?^]@h?^]@h?^]@p?^]@p?^]@x?^]@x?^]@\200?^]@\200?^]
   @\210?^]@\210?^]@\220?^]@\220?^]@\230?^]@\2
   > 30?^]@ ?^]@ ?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?
   ^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@
   > returning /var/spool/mail/.pop/.0?^]@0?^]@8?^]@8?^]@@?^]@@?^]@H?^]@H?
   ^]@P?^]@P?^]@X?^]@X?^]@`?^]@`?^]@h?^]@h?^]@p?^]@p?^]@x?^]@x
   > ?^]@\200?^]@\200?^]@\210?^]@\210?^]@\220?^]@\220?^]@\230?^]@\230?^]@ ?
   ^]@
   > ?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?
   ^]@?^]@?^]@?^]@?^]@?^]@.pop
   > [genpath.c:229]
   > Aug 23 23:54:11 jfsrv01 /usr/sbin/popper[30294]: Temporary maildrop
   name:
   > '/var/spool/mail/.pop/.0?^]@0?^]@8?^]@8?^]@@?^]@@?^]@H?^]@H?^]@P?^]@P?
   ^]@X?^]@X?^]@`?^]@`?^]@h?^]@h?^]@p?^]@p?^]@x?^]@x?^]@\200?^]@\200?^]
   @\210?^]@\210?^]@\220?^]@\220?^]@\230?^]@\2
   > 30?^]@ ?^]@ ?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?
   ^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@.pop'
   > [pop_dropcopy.c:1255]
   > Aug 23 23:54:11 jfsrv01 /usr/sbin/popper[30294]: uid = 8, gid = 12,
   euid
   > = 8, egid = 12 [pop_dropcopy.c:1481]
   > Aug 23 23:54:11 jfsrv01 /usr/sbin/popper[30294]: Opened temp drop
   /var/spool/mail/.pop/.0?^]@0?^]@8?^]@8?^]@@?^]@@?^]@H?^]@H?^]@P?^]@P?^]
   @X?^]@X?^]@`?^]@`?^]@h?^]@h?^]@p?^]@p?^]@x?^]@x?^]@\200?^]@\200?^]@\210?
   ^]@\210?^]@\220?^]@\220?^]@\230?^]@\230?^]@
   > ?^
   > ]@ ?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]
   @?^]@?^]@?^]@?^]@?^]@?^]@.pop
   > (4) [pop_dropcopy.c:1501]
   > Aug 23 23:54:11 jfsrv01 /usr/sbin/popper[30294]: Set p->drop to stream
   > for 4 [pop_dropcopy.c:1585]
   > Aug 23 23:54:11 jfsrv01 /usr/sbin/popper[30294]: Getting mail lock
   [pop_dropcopy.c:1625]
   > Aug 23 23:54:11 jfsrv01 /usr/sbin/popper[30294]: successfully opened
   (exclusive)
   > lock /var/mail/0?^]@0?^]@8?^]@8?^]@@?^]@@?^]@H?^]@H?^]@P?^]@P?^]@X?^]
   @X?^]@`?^]@`?^]@h?^]@h?^]@p?^]@p?^]@x?^]@x?^]@\200?^]@\200?^]@\210?^]
   @\210?^]@\220?^]@\220?^]@\230?^]@\23
   > 0?^]@ ?^]@ ?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]
   @?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@.lock
   > [maillock.c:477]
   > Aug 23 23:54:11 jfsrv01 /usr/sbin/popper[30294]: maillock() on file
   /var/mail/0?^]@0?^]@8?^]@8?^]@@?^]@@?^]@H?^]@H?^]@P?^]@P?^]@X?^]@X?^]@`?
   ^]@`?^]@h?^]@h?^]@p?^]@p?^]@x?^]@x?^]@\200?^]@\200?^]@\210?^]@\210?^]
   @\220?^]@\220?^]@\230?^]@\230?^]@
   > ?^]@ ?^]@?^
   > ]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]
   @?^]@?^]@?^]@?^]@
   > (/var/mail/0?^]@0?^]@8?^]@8?^]@@?^]@@?^]@H?^]@H?^]@P?^]@P?^]@X?^]@X?^]
   @`?^]@`?^]@h?^]@h?^]@p?^]@p?^]@x?^]@x?^]@\200?^]@\200?^]@\210?^]@\210?^]
   @\220
   > ?^]@\220?^]@\230?^]@\230?^]@ ?^]@ ?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]
   @?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@.lock)
   > [pop_dropcopy.c:1631] returning 0 (1 attempt(s)) [maillock.c:549]
   > Aug 23 23:54:11 jfsrv01 /usr/sbin/popper[30294]: Unable to open
   maildrop
   > /var/mail/0?^]@0?^]@8?^]@8?^]@@?^]@@?^]@H?^]@H?^]@P?^]@P?^]@X?^]@X?^]
   @`?^]@`?^]@h?^]@h?^]@p?^]@p?^]@x?^]@x?^]@\200?^]@\200?^]@\210?^]@\210?^]
   @\220?^]@\220?^]@\230?^]@\230?^]@
   > ?^]@ ?^
   > ]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]
   @?^]@?^]@?^]@?^]@?^]@:
   > No such file or directory (2) [pop_dropcopy.c:1740]
   > Aug 23 23:54:11 jfsrv01 /usr/sbin/popper[30294]: ...built: (65)
   '/var/spool/mail/.pop/'
   > [genpath.c:158]
   > Aug 23 23:54:11 jfsrv01 /usr/sbin/popper[30294]: genpath .cache (6)
   [hash:
   > 0; home: NULL] for user 0?^]@0?^]@8?^]@8?^]@@?^]@@?^]@H?^]@H?^]@P?^]
   @P?^]@X?^]@X?^]@`?^]@`?^]@h?^]@h?^]@p?^]@p?^]@x?^]@x?^]@\200?^]@\200?^]
   @\210?^]@\210?^]@\220?^]@\220?^]@\230?^]@
   > \230?^]@ ?^]@ ?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]
   @?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@
   > returning /var/spool/mail/.pop/.0?^]@0?^]@8?^]@8?^]@@?^]@@?^]@H?^]@H?
   ^]@P?^]@P?^]@X?^]@X?^]@`?^]@`?^]@h?^]@h?^]@p?^]@p?^]@x?^]
   > @x?^]@\200?^]@\200?^]@\210?^]@\210?^]@\220?^]@\220?^]@\230?^]@\230?^]@
   > ?^]@ ?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?
   ^]@?^]@?^]@?^]@?^]@?^]@?^]@.cache
   > [genpath.c:229]
   > Aug 23 23:54:11 jfsrv01 /usr/sbin/popper[30294]: Unlinked cache file
   /var/spool/mail/.pop/.0?^]@0?^]@8?^]@8?^]@@?^]@@?^]@H?^]@H?^]@P?^]@P?^]
   @X?^]@X?^]@`?^]@`?^]@h?^]@h?^]@p?^]@p?^]@x?^]@x?^]@\200?^]@\200?^]@\210?
   ^]@\210?^]@\220?^]@\220?^]@\230?^]@\230?^]@
   >  ?^]@ ?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]
   @?^]@?^]@?^]@?^]@?^]@?^]@?^]@.cache
   > [pop_cache.c:453]
   > Aug 23 23:54:11 jfsrv01 /usr/sbin/popper[30294]: Temp drop contains 0
   (0
   > visible) messages in 0 octets [pop_dropcopy.c:1790]
   > Aug 23 23:54:11 jfsrv01 /usr/sbin/popper[30294]: mailunlock() called
   [pop_dropcopy.c:1807]
   > for /var/mail/0?^]@0?^]@8?^]@8?^]@@?^]@@?^]@H?^]@H?^]@P?^]@P?^]@X?^]
   @X?^]@`?^]@`?^]@h?^]@h?^]@p?^]@p?^]@x?^]@x?^]@\200?^]@\200?^]@\210?^]
   @\210?^]@\220?^]@\220?^]@\2
   > 30?^]@\230?^]@ ?^]@ ?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?
   ^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@.lock
   > [maillock.c:579]
   > Aug 23 23:54:11 jfsrv01 /usr/sbin/popper[30294]: +OK jfaubin has 0
   visible
   > messages (0 hidden) in 0 octets. [pop_pass.c:1551]
   > Aug 23 23:54:11 jfsrv01 /usr/sbin/popper[30294]: pass returned 1;
   CurrentState
   > now trans [popper.c:350]
   > Aug 23 23:54:11 jfsrv01 /usr/sbin/popper[30294]: Qpopper ready for
   input
   > from jfaubin at localhost [127.0.0.1] [popper.c:306]
   > Aug 23 23:54:26 jfsrv01 /usr/sbin/popper[30294]: Received (4): "quit"
   [pop_get_command.c:105]
   > Aug 23 23:54:26 jfsrv01 /usr/sbin/popper[30294]: Performing maildrop
   update...
   > [pop_updt.c:292]
   > Aug 23 23:54:26 jfsrv01 /usr/sbin/popper[30294]: Checking to see if
   all
   > messages were deleted [pop_updt.c:293]
   > Aug 23 23:54:26 jfsrv01 /usr/sbin/popper[30294]: ...built: (65)
   '/var/spool/mail/.pop/'
   > [genpath.c:158]
   > Aug 23 23:54:26 jfsrv01 /usr/sbin/popper[30294]: genpath .cache (6)
   [hash:
   > 0; home: NULL] for user 0?^]@0?^]@8?^]@8?^]@@?^]@@?^]@H?^]@H?^]@P?^]
   @P?^]@X?^]@X?^]@`?^]@`?^]@h?^]@h?^]@p?^]@p?^]@x?^]@x?^]@\200?^]@\200?^]
   @\210?^]@\210?^]@\220?^]@\220?^]@\230?^]@
   > \230?^]@ ?^]@ ?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]
   @?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@
   > returning /var/spool/mail/.pop/.0?^]@0?^]@8?^]@8?^]@@?^]@@?^]@H?^]@H?
   ^]@P?^]@P?^]@X?^]@X?^]@`?^]@`?^]@h?^]@h?^]@p?^]@p?^]@x?^]
   > @x?^]@\200?^]@\200?^]@\210?^]@\210?^]@\220?^]@\220?^]@\230?^]@\230?^]@
   > ?^]@ ?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?
   ^]@?^]@?^]@?^]@?^]@?^]@?^]@.cache
   > [genpath.c:229]
   > Aug 23 23:54:26 jfsrv01 /usr/sbin/popper[30294]: Unlinked cache file
   /var/spool/mail/.pop/.0?^]@0?^]@8?^]@8?^]@@?^]@@?^]@H?^]@H?^]@P?^]@P?^]
   @X?^]@X?^]@`?^]@`?^]@h?^]@h?^]@p?^]@p?^]@x?^]@x?^]@\200?^]@\200?^]@\210?
   ^]@\210?^]@\220?^]@\220?^]@\230?^]@\230?^]@
   >  ?^]@ ?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]
   @?^]@?^]@?^]@?^]@?^]@?^]@?^]@.cache
   > [pop_cache.c:453]
   > Aug 23 23:54:26 jfsrv01 /usr/sbin/popper[30294]: Truncated
   [pop_updt.c:332]
   > temp drop (4) [pop_updt.c:159]
   > Aug 23 23:54:26 jfsrv01 /usr/sbin/popper[30294]: Non-server mode and
   all
   > msgs deleted; truncated temp drop (4) [pop_updt.c:333]
   > Aug 23 23:54:26 jfsrv01 /usr/sbin/popper[30294]: Unlinked
   [pop_updt.c:335]
   > temp drop (/var/spool/mail/.pop/.0?^]@0?^]@8?^]@8?^]@@?^]@@?^]@H?^]@H?
   ^]@P?^]@P?^]@X?^]@X?^]@`?^]@`?^]@h?^]@h?^]@p?^]@p?^]@x?^]@x?^]@\200?^]
   @\200?^]@\210?^]@\210?^]@\220?^]@\220?^]
   > @\230?^]@\230?^]@ ?^]@ ?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]
   @?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@?^]@.pop)
   > [pop_updt.c:145]
   > Aug 23 23:54:26 jfsrv01 /usr/sbin/popper[30294]: quit returned 1;
   CurrentState
   > now halt [popper.c:350]
   > Aug 23 23:54:26 jfsrv01 /usr/sbin/popper[30294]: +OK Pop server at
   jfsrv01.c-r-i-a.com
   > signing off. [popper.c:374]
   > Aug 23 23:54:26 jfsrv01 /usr/sbin/popper[30294]: (v4.0.3-mysql-0.1)
   Ending
   > request from "jfaubin" at (localhost) 127.0.0.1 [popper.c:391]
   > Aug 23 23:54:26 jfsrv01 popper[30294]: exiting after Qpopper returned
   [main.c:949]
   >

   Thanks!

    Jean-Francois Aubin
    [EMAIL PROTECTED]
    [EMAIL PROTECTED]





Reply via email to