*** 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:
- Nov 27 14:44:36 dovecot: imap(MaIlBoX at DoMaIn.co.za): Error:
net_connect_unix(/var/run/dovecot/imap-postlogin) failed: No such file or
directory
- 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 at 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 at 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 at 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 at 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 at
domain.com#011home=/var/spool/mail/domain.com/user#011uid=8#011gid=12#011auth_token=505201029f52ca4318f4a283c1ad5449afd407d3
dovecot: imap-login: Login: user=<user=user at domain.com>, method=PLAIN,
rip=Y.Y.Y.Y, lip=X.X.X.X, mpid=25870, TLS, session=<VPOQpNvsPwDELro2>
dovecot: imap(user=user at domain.com): Debug: Effective uid=8, gid=12,
home=/var/spool/mail/domain.com/user
dovecot: imap(user=user at 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 at 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.html
Sent from the Dovecot mailing list archive at Nabble.com.
