search for: vmailadmin

...... ??? lastlogin = mysql:/etc/dovecot/dovecot-last-login.conf ... } protocol imap { ??? mail_plugins = $mail_plugins ... last_login ... } protocol pop3 { ??? mail_plugins = $mail_plugins last_login ... } And dovecot-last-login.conf: connect = host=127.0.0.1 port=3306 dbname=vmail user=vmailadmin password=xxxxxxxxxxxxxxxxxx map { ??? pattern = shared/last-login/$user/$domain ??? table = last_login ??? value_field = last_login ??? value_type = uint ??? fields { ??????? username = $user ??????? domain = $domain ?????? rip = $rip ??? } } And the table criated in mysql: CREATE TA...

...s why the document mentions the difference. > You're free to use any database on your own mail server. > > ---- > Zhang Huangbin, founder of iRedMail project: https://www.iredmail.org/ What I did: #$ cat dovecot-last-login.conf connect = host=127.0.0.1 port=3306 dbname=vmail user=vmailadmin password=xxxxxxxxxxxxxxx map { ??? pattern = shared/last-login/$user/$domain/$rip/$service ??? table = last_login ??? value_field = last_login ??? value_type = uint ??? fields { ??????? username = $user ??????? domain = $domain ??????? rip = $rip ??????? proto = $service ??? } } -----...

On 15/08/2017 08:18, voytek at sbt.net.au wrote: > I've also dumped MySQL 'vmail' and imported database, created user vmail, > vmailadmin > > Aug 15 08:05:31 auth-worker(9763): Error: mysql(127.0.0.1): Connect failed > to database (vmail): Access denied for user 'vmail'@'localhost' (using > password: YES) - waiting for 1 seconds before retry Forget looking at dovecot at teh moment, your problem maybe mys...

...gt; <br> </div> <div> } </div> <div> <br> </div> <div> And dovecot-last-login.conf: </div> <div> <br> </div> <div> connect = host=127.0.0.1 port=3306 dbname=vmail user=vmailadmin </div> <div> password=xxxxxxxxxxxxxxxxxx </div> <div> <br> </div> <div> map { </div> <div> pattern = shared/last-login/$user/$domain </div> <div> table = last_login </di...

.../mysql to new server on Centos 7/dovecot 2.2.31 (65cde28)/mariadb I've dumped on oldserver 'dovecot.conf' and used it on newserver doveconf -n > dovecot.conf also, transferred /etc/doveconf/*.conf I've also dumped MySQL 'vmail' and imported database, created user vmail, vmailadmin dumb question: should the password hash from oldserver work 'as is' on newserver..? (different machine, different SQL..) I've tried 'as is', then, attepmted to change both "default_pass_scheme" and 'password=' values, but, no luck postfixadmin works, I can l...

> On 20 Jun 2019, at 11:36, Adrian Minta via dovecot <dovecot at dovecot.org> wrote: > > this seems to work very well: > > https://docs.iredmail.org/track.user.last.login.html This is cool, but I have a question: > For MySQL/MariaDB backends, we create the sql table in database vmail. Would this interfere with or confuse postfixadmin? I use that so that users can

...commands used to create PostgreSQL table: ########### CREATE TABLE last_login ( username VARCHAR(255) NOT NULL, last_login INT DEFAULT NULL, PRIMARY KEY (username) ); ########### File /etc/dovecot/dovecot-last-login.conf: ########### connect = host=127.0.0.1 port=5432 dbname=vmail user=vmailadmin password=<password> map { pattern = shared/last-login/$user table = last_login value_field = last_login value_type = uint fields { username = $user } } ##############

...rack user last login data (ip address, login date, etc) with dovecot, followed dovecot tutorial[1], and it now works with IMAP, but failed with POP3. i don't know why. My script: ---- LDAP_URI='ldap://127.0.0.1:389' LDAP_BASEDN='o=domains,dc=iredmail,dc=org' BIND_DN='cn=vmailadmin,dc=iredmail,dc=org' BIND_PW='plain_passwd' if [ X"${USER}" != X"dump-capability" ]; then ldapmodify -c -x \ -H "${LDAP_URI}" \ -D "${BIND_DN}" \ -w "${BIND_PW}" <<EOF dn: mail=${USER},ou=Users,domai...