# chmod 0755 /usr/libexec/dovecot/imaplastlogin

    protocol imap {
        mail_drop_priv_before_exec=yes
        mail_executable = /usr/bin/TrackLastLogin.sh imap
        ...
    }

    protocol pop3 {
        mail_drop_priv_before_exec=yes
        mail_executable = /usr/bin/TrackLastLogin.sh pop3
        ...
    }

#!/bin/sh

# =========================================================
# Author:   Zhang Huangbin (michaelbibby@gmail.com)
# Date:     2009.07.28
# Purpose:  Track user last login date & ip address.
# =========================================================

# $USER -> login username
# $IP   -> remote ip address
# ${1}  -> mail protocol: imap, pop3

# Debug & Update to plain file.
# Note: user 'dovecot' should have write permission on this file.
#echo "$(date +%Y.%m.%d-%H:%M:%S), $USER, $IP, ${1})" >> /tmp/tracking.log

# ----------------------------------------------
# Update to MySQL database.
# ----------------------------------------------
#mysql -uvmailadmin -psecret_passwd vmail <<EOF
#UPDATE mailbox SET \
#   lastloginipv4="INET_ATON('$IP')", \
#   lastlogindate="NOW()", \
#   lastloginprotocol="${1}" \
#   WHERE username='$USER';
#EOF

# ----------------------------------------------
# Update to LDAP (OpenLDAP) directory server.
# ----------------------------------------------
# Convert username to LDAP dn.
# -c         continuous operation mode (do not stop on errors)
# -x            Simple authentication
# -H URI        Uniform Resource Identifier(s)
# -D binddn     Bind dn. Default is 'cn=vmailadmin,dc=iredmail,dc=org'
# -w bindpw     Bind password (for simple authentication)
if [ X"${USER}" != X"dump-capability" ]; then
    ldapmodify -c -x \
        -H ldap://127.0.0.1:389 \
        -D 'cn=vmailadmin,dc=iredmail,dc=org' \
        -w passwd <<EOF
dn: mail=${USER},ou=Users,domainName=$(echo ${USER} | awk -F'@' '{print $2}'),o=domains,dc=iredmail,dc=org
changetype: modify
replace: lastLoginDate
lastLoginDate: $(date +%Y%m%d%H%M%SZ)
-
replace: lastLoginIP
lastLoginIP: ${IP}
-
replace: lastLoginProtocol
lastLoginProtocol: ${1}
EOF

fi

# Execute IMAP process.
# RHEL/CentOS:
exec /usr/libexec/dovecot/imap $*
# Debian & Ubuntu:
#exec /usr/lib/dovecot/imap $*

exec /usr/libexec/dovecot/imap $*