*** This is 2 posts combined into one which I had asked on linuxquestions.org and never got an answer ***
Hi,
In short I am trying to run a bash script which will then update a mysql database with the last login date/time & last IP for each mailbox.
I have searched google dead but still cant figure out what im doing wrong or if there is some issue with the centos 6 rpm's for dovecot.
--
- 1st i had the default dovecot in the centos 6 repo's which is version: 2.0.9
- I read that there was an issue with the script-login binary which was fixed in version 2.0.14, so i updated dovecot to version 2.2.7.
- This sadly did not fix my issue with the bash script excecuting.
In my /etc/dovecot/conf.d/10-master.conf i have the following service imap { executable = imap imap-postlogin }
service imap-postlogin { executable = script-login /var/www/lighttpd/mail-admin/scripts/lastLogin.sh }
But when i try login i still get the same error as with the previous version: directory
- Nov 27 14:44:36 dovecot: imap(MaIlBoX@DoMaIn.co.za): Error: net_connect_unix(/var/run/dovecot/imap-postlogin) failed: No such file or
- One thing i did notice on the one site was that someone had a ls of their /var/run/dovecot directory, and in there was a binary called imap-postlogin.
- But i dont have that binary anywhere on my server, with the old or new version of dovecot.
Please any help would be appreciated.
=====================================================
Ok well i tried a few other things and got it working a bit more. So the variables that i needed are now being set correctly etc, but im getting authentication errors now which I was not before.
my setup in 10-master.conf now looks like the following: service imap-postlogin { executable = script-login /var/www/lighttpd/mail-admin/scripts/lastLogin.sh unix_listener imap-postlogin { user = root } }
service imap { executable = imap imap-postlogin }
My lastLogin.sh bash script has the following in it for debugging echo "$(date +%Y.%m.%d-%H:%M:%S)"; echo "User: ${USER}" >> /tmp/tracking.log 2>&1; echo "Home: ${HOME}" >> /tmp/tracking.log 2>&1; echo "Client IP: ${IP}" >> /tmp/tracking.log 2>&1; echo "Server IP: ${LOCAL_IP}" >> /tmp/tracking.log 2>&1;
The output to my /tmp/tracker.log is the following User: user@domain.com Home: /var/spool/mail/domain.com/user Client IP: x.x.x.x Server IP: y.y.y.y
The Authentication Error I am getting now
dovecot: auth: Debug: Loading modules from directory:
/usr/lib64/dovecot/auth
dovecot: auth: Debug: Module loaded:
/usr/lib64/dovecot/auth/libdriver_mysql.so
dovecot: auth: Debug: Module loaded:
/usr/lib64/dovecot/auth/libdriver_pgsql.so
dovecot: auth: Debug: Module loaded:
/usr/lib64/dovecot/auth/libdriver_sqlite.so
dovecot: auth: Debug: Read auth token secret from
/var/run/dovecot//auth-token-secret.dat
dovecot: auth: Debug: auth client connected (pid=25865)
dovecot: auth: Debug: client in:
AUTH#0111#011PLAIN#011service=imap#011secured#011session=VPOQpNvsPwDELro2#011lip=X.X.X.X#011rip=Y.Y.
Y.Y#011lport=143#011rport=58175
dovecot: auth: Debug: client passdb out: CONT#0111#011
dovecot: auth: Debug: client in:
CONT#0111#011AHN1cHBvcnRAYmxhY2tsaXN0Ym94LmNvbQBzQHlAajFu (previous base64
data may contain sensitive data)
dovecot: auth-worker(25868): Debug: Loading modules from directory:
/usr/lib64/dovecot/auth
dovecot: auth-worker(25868): Debug: Module loaded:
/usr/lib64/dovecot/auth/libdriver_mysql.so
dovecot: auth-worker(25868): Debug: Module loaded:
/usr/lib64/dovecot/auth/libdriver_pgsql.so
dovecot: auth-worker(25868): Debug: Module loaded:
/usr/lib64/dovecot/auth/libdriver_sqlite.so
dovecot: auth-worker(25868): Debug: sql(user=user@domain.com,Y.Y.Y.Y):
query: SELECT CONCAT(mailboxes.local_part,'@',domains.fqdn) as user
,
mailboxes.password AS password
,'/var/spool/mail/domain.com/user' AS
userdb_home
, 8 AS userdb_uid
, 12 AS userdb_gid
FROM mailboxes
,
domains
WHERE mailboxes.local_part = 'user' AND mailboxes.active = 1 AND
mailboxes.domain_name = domains.fqdn AND domains.fqdn = 'domain.com' AND
domains.active = 1
dovecot: auth: Debug: client passdb out: OK#0111#011user=user@domain.com
dovecot: auth: Debug: master in:
REQUEST#0112408185857#01125865#0111#0117b2d33b66e121f24e5393e87c3ae855f#011session_pid=25870#011requ
est_auth_token
dovecot: auth-worker(25868): Debug: sql(user=user@domain.com,Y.Y.Y.Y):
SELECT '/var/spool/mail/domain.com/user' AS home
, 8 AS uid
, 12 AS gid
dovecot: auth: Debug: master userdb out:
USER#0112408185857#011user=user@domain.com#011home=/var/spool/mail/domain.com/user#011uid=8#011gid=12#011auth_token=505201029f52ca4318f4a283c1ad5449afd407d3
dovecot: imap-login: Login: user=<user=user@domain.com>, method=PLAIN,
rip=Y.Y.Y.Y, lip=X.X.X.X, mpid=25870, TLS, session=<VPOQpNvsPwDELro2>
dovecot: imap(user=user@domain.com): Debug: Effective uid=8, gid=12,
home=/var/spool/mail/domain.com/user
dovecot: imap(user=user@domain.com): Debug: Namespace inbox: type=private,
prefix=, sep=, inbox=yes, hidden=no, list=yes, subscriptions=yes
location=maildir:/var/spool/mail/domain.com/user
dovecot: imap(user=user@domain.com): Debug: maildir++:
root=/var/spool/mail/domain.com/user, index=, indexpvt=, control=,
inbox=/var/spool/mail/domain.com/user, alt=
-- View this message in context: http://dovecot.2317879.n4.nabble.com/Dovecot-imap-postlogin-failed-tp46436.h... Sent from the Dovecot mailing list archive at Nabble.com.