search for: last_login_dict

Hello, I get last_login_dict: Failed to write value: dict-server returned failure: sql dict: commit failed randomly in the logs: --- ???????1 mailserver dovecot: imap(test-email-bb at exemple.com) <NtiT9H2SFIVcuGID> [xxx.xxx.xxx.xxx]: Error: last_login_dict: Failed to write value: dict-server returned failure: sql dict:...

Hi, I have a Dovecot test installation with MySQL userbase and authentication where I am trying to setup last_login plugin with SQL dictionary I read http://wiki2.dovecot.org/Plugins/LastLogin and I addes this to my configuration plugin { last_login_dict = sql:/etc/dovecot/dovecot-sql.conf.ext } mail_plugins = $mail_plugins stats protocol imap { mail_plugins = $mail_plugins imap_stats last_login } When I log in with IMAP I get this error: Error: last_login_dict: dict_init(sql:/etc/dovecot/dovecot-sql.conf.ext) failed: Unknown dict module: sql...

Hi, after upgrading my database I kept on getting those errors. It seems like later versions of databases have strict mode enabled by default and it must either be disabled or change the dovecot database schema. Besides the password, would anyone know what other fields must be changed to the dovecot schema and have a default value? Is there any other dovecot schema for strict mode? Lefteris

Hello, is it possible to use Last Login Plugin with mysql instead of redis ? http://wiki2.dovecot.org/Plugins/LastLogin .-- Best regards, Adrian Minta

...is global mail_plugins). mail_plugins = $mail_plugins last_login # Maximum number of IMAP connections allowed for a user from each IP address. # NOTE: The username is compared case-sensitively. #mail_max_userip_connections = 10 } 90-plugins.conf plugin { #setting_name = value #last_login_dict = proxy::lastlogin last_login_dict = proxy:dict:lastlogin zlib_save = gz zlib_save_level = 6 } dovecot-ldap-dict.conf.ext: uri = ldap://ldap.internal bind_dn = cn=Manager,dc=mail,dc=com password = XXXX tls = no debug = 1 map { pattern = last-login/$user filter = (&(mail=%{user})(ob...

...would be very helpful. Even a local sqlite database would do. >> >> The documentation for the plugin seems very scarce. >> >> > you could touch a file in the postlogin script You can use lastlogin plugin to write to a file too. It's not just database. plugin { ?? last_login_dict = file:/somewhere/lastlogin } Aki -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 488 bytes Desc: OpenPGP digital signature URL: <https://dovecot.org/pipermail/dovecot/attachments/20201020/4e023f8b/attach...

...ons allowed for a user from each IP > > address. > > # NOTE: The username is compared case-sensitively. > > #mail_max_userip_connections = 10 > > } > > > > > > > > 90-plugins.conf > > plugin { > > #setting_name = value > > #last_login_dict = proxy::lastlogin > > last_login_dict = proxy:dict:lastlogin > > zlib_save = gz > > zlib_save_level = 6 > > } > > > > > > dovecot-ldap-dict.conf.ext: > > uri = ldap://ldap.internal > > bind_dn = cn=Manager,dc=mail,dc=com > > passwor...

...last_login ??? value_type = uint ??? fields { ??????? username = $user ??????? domain = $domain ??????? rip = $rip ??????? proto = $service ??? } } ------------------------------------------------------ dovecot.conf: plugin { ... ... ??? # Track last login time on imap and pop3 ??? last_login_dict = proxy::lastlogin ??? last_login_key = last-login/%u/%d/%r/%s } Result on mysql: mysql> select * from last_login where username = 'julio at xxx.com.br'; +------------------+------------+------------+---------------+-------+ | username???????? | domain???? | last_login | rip??????????...

Hi, I'm configuring Last_Login plugin whith Mysql back end and all works fine. I just wonder to track besides time_stamp, user and domain, the remote IP and proto (imap or pop3) I tried in dovecot.conf: plugin { ... ... ??? # Track last login time on imap and pop3 ??? last_login_dict = proxy::lastlogin ??? last_login_key = last-login/%u/%d/%r } dict { ... ??? 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...

...st_login > > # Maximum number of IMAP connections allowed for a user from each IP > address. > # NOTE: The username is compared case-sensitively. > #mail_max_userip_connections = 10 > } > > > > 90-plugins.conf > plugin { > #setting_name = value > #last_login_dict = proxy::lastlogin > last_login_dict = proxy:dict:lastlogin > zlib_save = gz > zlib_save_level = 6 > } > > > dovecot-ldap-dict.conf.ext: > uri = ldap://ldap.internal > bind_dn = cn=Manager,dc=mail,dc=com > password = XXXX > tls = no > debug = 1 > > ma...

...7099): Error: sql dict: commit failed: Unknown column 'username' in 'field list' Apr 28 17:18:15 ohio dovecot: imap(user at example.com): Error: dict-client: server returned failure: 1493414295 (reply took 0.026 secs) Apr 28 17:18:15 ohio dovecot: imap(user at example.com): Error: last_login_dict: Failed to write value for user user at example.com and my configuration: # 2.2.29.1 (e0b76e3): /usr/local/etc/dovecot/dovecot.conf # Pigeonhole version 0.4.18 (29cc74d) # OS: FreeBSD 10.3-RELEASE-p18 amd64 auth_default_realm = example.com auth_mechanisms = plain login cram-md5 auth_realms = ex...

Hello, I'm running dovecot 2.2 and trying to do last login tracking. I am using a MySQL database. When a user logs in I get this in the log: 2018-04-07 16:55:14 imap(user at example.com)<54415><BmevY0hpMN5/AAAB>: Error: last_login_dict: Failed to write value for user user at example.com: dict-server returned failure: sql dict: commit failed: Field 'name' doesn't have a default value (reply took 0.018 secs (0.000 in dict wait, 0.009 in other ioloops, 0.001 in locks, async-id reply 0.000 secs ago, started on dict-server...

...lbutlr via dovecot escreveu: > On 24 Jun 2019, at 08:25, J?lio Covolato via dovecot <dovecot at dovecot.org> wrote: >> #$ cat dovecot-last-login.conf > [ ? ] > >> dovecot.conf: >> >> plugin { >> # Track last login time on imap and pop3 >> last_login_dict = proxy::lastlogin >> last_login_key = last-login/%u/%d/%r/%s >> } > Thank you, that is very clear. > > Where is the file dovecot-last-login.conf referenced in the dovecot.conf? Or it is enabled by virtue of being in conf.d/? Sory, forgot this: dovecot.conf: dict { ???...

...login of a user but it looks like Dict always want to add a new record into my last_login table instead of updating the existing record for a specific user. Here is the error message from Dovecot: May 19 12:45:14-mbox1 dovecot: imap(user at domain.tld)<51915><if6KTzuJMZ25D+Vc>: Error: last_login_dict: Failed to write value: dict-server returned failure: sql dict: commit failed: ERROR: duplicate key value violates unique constraint "last_logins_pkey" It looks like Dict with PostgreSQL does not support UPDATEing an already existing record in the table. Or am I missing something? or it...

...t; Mar 31 11:15:21 ob dovecot: dict: Error: DETAIL: Key (username)=(postmaster at a.io) already exists. Mar 31 11:15:21 ob dovecot: imap(postmaster at a.io): Error: dict-client: server returned failure: 1554023721 (reply took 0.012 secs) Mar 31 11:15:21 ob dovecot: imap(postmaster at a.io): Error: last_login_dict: Failed to write value for user postmaster at a.io Mar 31 11:15:21 ob dovecot: imap(postmaster at a.io): Logged out in=70 out=732 ################## My Dovecot config: ################### protocol imap { mail_plugins = ... last_login ... } protocol pop3 { mail_plugins = ... last_logi...

...l,session) VALUES (1605350938,'xxxx',x.x.x.x','imap','jLFs5A609cdSN4Wh') ON DUPLICATE KEY UPDATE last_login=1605350938 How can I modify the configuration? conf.d/95-last_login.conf: dict { ??? lastlogin = mysql:/etc/dovecot/dovecot-last-login.conf.ext } plugin { ??? last_login_dict = proxy::lastlogin ??? last_login_key = last-login/%u/%r/%s/%{session} } protocol imap { ??? mail_plugins = $mail_plugins last_login } protocol pop3 { ??? mail_plugins = $mail_plugins last_login } dovecot-last-login.conf.ext: connect = host=/var/lib/mysql/mysql.sock dbname=dovecot user=xxx passwo...

...} mailbox Junk { special_use = \Junk } mailbox Sent { special_use = \Sent } mailbox "Sent Messages" { special_use = \Sent } mailbox Trash { special_use = \Trash } prefix = } passdb { args = /etc/dovecot/dovecot-sql.conf.ext driver = sql } plugin { last_login_dict = proxy::lastlogin last_login_key = last-login/%u mail_replica = tcp:imapb01.litmail.dk:12345 quota = maildir:User quota quota_clone_dict = proxy::quotaclone quota_grace = 10%% quota_status_nouser = DUNNO quota_status_overquota = 552 5.2.2 Mailbox is full quota_status_success = DUNN...

...> > special_use = \Sent > > } > > mailbox Trash { > > special_use = \Trash > > } > > prefix = > > } > > passdb { > > args = /etc/dovecot/dovecot-sql.conf.ext > > driver = sql > > } > > plugin { > > last_login_dict = proxy::lastlogin > > last_login_key = last-login/%u > > mail_replica = tcp:imapb01.litmail.dk:12345 > > quota = maildir:User quota > > quota_clone_dict = proxy::quotaclone > > quota_grace = 10%% > > quota_status_nouser = DUNNO > > quota_stat...

...database. Here's the log lines: 2018-04-10 10:43:34 imap-login: Info: Login: user=<user at domain.com>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, mpid=75934, TLS, session=<db0EjH9pOix/AAAB> 2018-04-10 10:43:34 imap(user at domain.com)<75934><db0EjH9pOix/AAAB>: Error: last_login_dict: Failed to write value for user user at domain.com: dict-server returned failure: sql dict: commit failed: Field 'name' doesn't have a default value (reply took 0.013 secs (0.000 in dict wait, 0.012 in other ioloops, 0.000 in locks, async-id reply 0.002 secs ago, started on dict-server...

> On 15/03/2023 13:12 EET Dejan <me at dejanstrbac.com> wrote: > > > > lmtp_save_to_detail_mailbox = yes > > Plus-delivery conflicts with existing, reserved files such as > "subscriptions": > > Message for kim+subscriptions@ results in: > > lmtp(kim@***.com)<14493><SK7sEvaHEWSdOAAAvAYmHA>: Error: >