<html><head></head><body><div class="ydpeb21b9acyahoo-style-wrap" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif; font-size: 13px;"><div></div>
<div dir="ltr" data-setdir="false"><div><div dir="ltr" data-setdir="false"> <div><div dir="ltr" data-setdir="false"><span>Dear Aki</span></div><div dir="ltr" data-setdir="false"><span><br></span></div><div dir="ltr" data-setdir="false"><span><br></span></div><div dir="ltr" data-setdir="false"><span>Below for output, it is normal?</span></div><div dir="ltr" data-setdir="false"><span><br></span></div><div dir="ltr" data-setdir="false"><span>[root@cnt8-testing dovecot]# doveadm user <span><span style="color: rgb(0, 0, 0); font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">email@testing.com</span></span> </span><br></div><div><br></div><div>doveadm user email@testing.com</div><div>field value</div><div>uid 89</div><div>gid 89</div><div>home /home/vpopmail/domains/2/6/x/testing.com/email</div><div>mail maildir:~/Maildir:INDEX=/home/vpopmail/domains/2/6/x/testing.com/email</div><div>quota_rule *:bytes=19922944</div><div>last_login_key last-login/email@testing.com/testing.com///0</div><div><br></div></div><br></div><div><br></div></div><br></div><div><br></div>
</div><div id="yahoo_quoted_4888879514" class="yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
Aki Tuomi (<aki.tuomi@open-xchange.com>) 在 2021年3月2日星期二 下午10:47:39 [GMT+8] 寫道：
</div>
<div><br></div>
<div><br></div>
<div><div id="yiv8430298754"><div>Did you try <br clear="none"><br clear="none">doveadm user account<br clear="none"><br clear="none">to see that last_login_key appears in output in correct form?<br clear="none"><br clear="none">Aki<br clear="none"><br clear="none"><div class="yiv8430298754yqt6295287261" id="yiv8430298754yqtfd61535"><div class="yiv8430298754gmail_quote">On March 2, 2021 2:44:43 PM UTC, Henry <hl1723@yahoo.com.hk> wrote:<blockquote class="yiv8430298754gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex;">
<div class="yiv8430298754ydp68902e63yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;"><div></div>
<div dir="ltr">Dear Aki,</div><div dir="ltr"><br clear="none"></div><div dir="ltr"> <div><div dir="ltr" style="color:rgb(38, 40, 42);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;"><span>I try it as your recommend but s</span>till no luck, same error</div><div dir="ltr" style="color:rgb(38, 40, 42);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;"><br clear="none"></div><div dir="ltr" style="color:rgb(38, 40, 42);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;">Error: Failed to expand plugin setting last_login_key = 'last-login/%u/%d/%r/%l/%a': Unknown variable '%a'<br clear="none"></div><div dir="ltr" style="color:rgb(38, 40, 42);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;"><br clear="none"></div><div dir="ltr" style="color:rgb(38, 40, 42);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;">If I remark <span style="color:rgb(0, 0, 0);"> #last_login_key = last-login/%u/%d/%r/%l/%a at plugin , error as below</span></div><div dir="ltr" style="color:rgb(38, 40, 42);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;"><span style="color:rgb(0, 0, 0);"><br clear="none"></span></div><div dir="ltr" style="color:rgb(38, 40, 42);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;">Error: last_login_dict: Failed to write value: dict-server returned failure: sql dict set: Invalid/unmapped key: shared/last-login/<br clear="none"></div><div dir="ltr" style="color:rgb(38, 40, 42);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;"><br clear="none"></div><div dir="ltr" style="color:rgb(38, 40, 42);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;"><br clear="none"></div><div dir="ltr" style="color:rgb(38, 40, 42);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;"><span>There is any error in my configuration? thanks for your help.</span><br clear="none"></div><div dir="ltr" style="color:rgb(38, 40, 42);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;"><br clear="none"></div><div dir="ltr" style="color:rgb(38, 40, 42);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;"><br clear="none"></div><div dir="ltr" style="color:rgb(38, 40, 42);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;">## dovecot.conf</div><div dir="ltr" style="color:rgb(38, 40, 42);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;">userdb {<br clear="none"></div><div dir="ltr" style="color:rgb(38, 40, 42);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;"><div> driver = prefetch</div><div>}</div><div>userdb {</div><div> args = /etc/dovecot/dovecot-sql.conf.ext</div><div> driver = sql</div><div>}</div><div>plugin {<br clear="none"></div><div> quota = maildir:User quota<br clear="none"></div><div> last_login_dict = proxy::lastlogin<br clear="none"></div><div> last_login_key = last-login/%u/%d/%r/%l/%a</div><div> quota_status_success = DUNNO<br clear="none"></div><div> quota_status_nouser = DUNNO</div><div> quota_status_overquota = "552 5.2.2 Mailbox is full"</div><div>}</div><div dir="ltr"><div>dict {</div><div> lastlogin = mysql:/etc/dovecot/dovecot-last-login.conf<br clear="none"></div><div>}</div><div><br clear="none"></div></div></div><div dir="ltr" style="color:rgb(38, 40, 42);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;"><br clear="none"></div><div dir="ltr" style="color:rgb(38, 40, 42);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;">## <span style="color:rgb(0, 0, 0);">dovecot-sql.conf.ext</span></div><div style="color:rgb(38, 40, 42);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;">password_query = SELECT CONCAT(pw_name, '@', pw_domain) AS user,pw_passwd AS password, concat('*:backend=', pw_shell) as \<br clear="none"></div><div style="color:rgb(38, 40, 42);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;">userdb_quota_rule, 89 AS userdb_uid, 89 AS userdb_gid, pw_dir AS userdb_home ,'last-login/%u/%d/%r/%l/%a' AS last_login_key FROM vpopmail LEFT JOIN limits ON vpopmail.pw_domain = \</div><div style="color:rgb(38, 40, 42);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;">limits.domain WHERE pw_name = '%n' AND pw_domain='%d' AND (( '%s' = 'smtp' AND (pw_gid & 2048)<>2048 AND COALESCE(disable_smtp,0)!=1) OR \</div><div style="color:rgb(38, 40, 42);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;">('%s' = 'pop3' AND (pw_gid & 2)<>2 AND COALESCE(disable_pop,0) != 1 ) OR ('%s' = 'imap' AND ('%r'='127.0.0.1') AND \</div><div style="color:rgb(38, 40, 42);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;">(pw_gid & 4)<>4 AND COALESCE(disable_webmail,0)!=1) OR ('%s' = 'imap' AND ('%r'!='127.0.0.1') AND (pw_gid & 8)<>8 AND COALESCE(disable_imap,0)!=1));</div><div style="color:rgb(38, 40, 42);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;"><br clear="none"></div><div style="color:rgb(38, 40, 42);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;">user_query = \<br clear="none"></div><div style="color:rgb(38, 40, 42);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;"> SELECT pw_dir AS home, \</div><div style="color:rgb(38, 40, 42);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;"> 89 AS uid, \</div><div style="color:rgb(38, 40, 42);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;"> 89 AS gid, \</div><div style="color:rgb(38, 40, 42);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;"> CONCAT('*:bytes=', REPLACE(SUBSTRING_INDEX(pw_shell, 'S', 1), 'NOQUOTA', '0')) AS quota_rule, \</div><div style="color:rgb(38, 40, 42);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;"> 'last-login/%u/%d/%r/%l/%a' AS last_login_key \</div><div style="color:rgb(38, 40, 42);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;"> FROM vpopmail \</div><div style="color:rgb(38, 40, 42);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;"> WHERE pw_name = '%n' AND pw_domain = '%d' \</div><div style="color:rgb(38, 40, 42);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;"> AND ('%a'!='995' or !(pw_gid & 2)) \</div><div style="color:rgb(38, 40, 42);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;"> AND ('%r'!='[WEBMAIL-IP]' or !(pw_gid & 4)) \</div><div style="color:rgb(38, 40, 42);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;"> AND ('%r'='[WEBMAIL-IP]' or '%a'!='993' or !(pw_gid & 8))</div><div style="color:rgb(38, 40, 42);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;"><br clear="none"></div></div><br clear="none"></div><div dir="ltr"><span>#</span></div><div dir="ltr"><span><br clear="none"></span></div><div dir="ltr"><span><br clear="none"></span></div><div dir="ltr"><br clear="none"></div><div><br clear="none"></div>
</div><div class="yiv8430298754ydp76593e3yahoo_quoted" id="yiv8430298754ydp76593e3yahoo_quoted_5403208811">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
Henry (<hl1723@yahoo.com.hk>) 在 2021年2月28日星期日 下午05:24:45 [GMT+8] 寫道：
</div>
<div><br clear="none"></div>
<div><br clear="none"></div>
<div><div id="yiv8430298754ydp76593e3yiv5546016181"><div><div class="yiv8430298754ydp76593e3yiv5546016181ydp3fb2ea29yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;"><div></div>
<div dir="ltr"><div><div dir="ltr">Dear Aka</div><div dir="ltr"><br clear="none"></div><div dir="ltr">Still no luck, same error</div><div dir="ltr">Error: Failed to expand plugin setting last_login_key = 'last-login/%u/%d/%r/%l/%a': Unknown variable '%a'<br clear="none"></div><div dir="ltr"><br clear="none"></div><div dir="ltr">If I remark <span><span style="color:rgb(0, 0, 0);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;"> #last_login_key = last-login/%u/%d/%r/%l/%a at <span><span style="color:rgb(0, 0, 0);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;">plugin , error as below</span></span></span></span></div><div dir="ltr">Error: last_login_dict: Failed to write value: dict-server returned failure: sql dict set: Invalid/unmapped key: shared/last-login/<br clear="none"></div><div dir="ltr"><br clear="none"></div><div dir="ltr"><br clear="none"></div><div dir="ltr"><br clear="none"></div><div dir="ltr">#dovecot.conf</div><div dir="ltr">userdb {<br clear="none"></div><div dir="ltr"><div> driver = prefetch</div><div>}</div><div>userdb {</div><div> args = /etc/dovecot/dovecot-sql.conf.ext</div><div> driver = sql</div><div>}</div><div>plugin {<br clear="none"></div><div> quota = maildir:User quota<br clear="none"></div><div> last_login_dict = proxy::lastlogin<br clear="none"></div><div> last_login_key = last-login/%u/%d/%r/%l/%a</div><div> quota_status_success = DUNNO<br clear="none"></div><div> quota_status_nouser = DUNNO</div><div> quota_status_overquota = "552 5.2.2 Mailbox is full"</div><div>}</div><div dir="ltr"><div><div>dict {</div><div> lastlogin = mysql:/etc/dovecot/dovecot-last-login.conf<br clear="none"></div><div>}</div><div><br clear="none"></div></div></div></div><div dir="ltr"><br clear="none"></div><div dir="ltr"># <span><span style="color:rgb(0, 0, 0);font-family:Helvetica Neue, Helvetica, Arial, sans-serif;">dovecot-sql.conf.ext</span></span></div><div>password_query = SELECT CONCAT(pw_name, '@', pw_domain) AS user,pw_passwd AS password, concat('*:backend=', pw_shell) as \<br clear="none"></div><div>userdb_quota_rule, 89 AS userdb_uid, 89 AS userdb_gid, pw_dir AS userdb_home ,'last-login/%u/%d/%r/%l/%a' AS last_login_key FROM vpopmail LEFT JOIN limits ON vpopmail.pw_domain = \</div><div>limits.domain WHERE pw_name = '%n' AND pw_domain='%d' AND (( '%s' = 'smtp' AND (pw_gid & 2048)<>2048 AND COALESCE(disable_smtp,0)!=1) OR \</div><div>('%s' = 'pop3' AND (pw_gid & 2)<>2 AND COALESCE(disable_pop,0) != 1 ) OR ('%s' = 'imap' AND ('%r'='127.0.0.1') AND \</div><div>(pw_gid & 4)<>4 AND COALESCE(disable_webmail,0)!=1) OR ('%s' = 'imap' AND ('%r'!='127.0.0.1') AND (pw_gid & 8)<>8 AND COALESCE(disable_imap,0)!=1));</div><div><br clear="none"></div><div>user_query = \<br clear="none"></div><div> SELECT pw_dir AS home, \</div><div> 89 AS uid, \</div><div> 89 AS gid, \</div><div> CONCAT('*:bytes=', REPLACE(SUBSTRING_INDEX(pw_shell, 'S', 1), 'NOQUOTA', '0')) AS quota_rule, \</div><div> 'last-login/%u/%d/%r/%l/%a' AS last_login_key \</div><div> FROM vpopmail \</div><div> WHERE pw_name = '%n' AND pw_domain = '%d' \</div><div> AND ('%a'!='995' or !(pw_gid & 2)) \</div><div> AND ('%r'!='[WEBMAIL-IP]' or !(pw_gid & 4)) \</div><div> AND ('%r'='[WEBMAIL-IP]' or '%a'!='993' or !(pw_gid & 8))</div><div><br clear="none"></div></div><br clear="none"></div><div><br clear="none"></div>
</div><div class="yiv8430298754ydp76593e3yiv5546016181yahoo_quoted" id="yiv8430298754ydp76593e3yiv5546016181yahoo_quoted_5243056057">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
Aki Tuomi (<aki.tuomi@open-xchange.com>) 在 2021年2月28日星期日 下午04:55:04 [GMT+8] 寫道：
</div>
<div><br clear="none"></div>
<div><br clear="none"></div>
<div class="yiv8430298754ydp76593e3yiv5546016181yqt3342082331" id="yiv8430298754ydp76593e3yiv5546016181yqt42991"><div><div dir="ltr">You need to put it in the sql query. SELECT ..., 'last-login/%u/%d/%r/%l/%a' AS last_login_key<br clear="none"><br clear="none">Aki <br clear="none"><div class="yiv8430298754ydp76593e3yiv5546016181yqt1992455784" id="yiv8430298754ydp76593e3yiv5546016181yqtfd69321"><br clear="none">On February 28, 2021 8:12:39 AM UTC, Henry <<a rel="nofollow noopener noreferrer" shape="rect" ymailto="mailto:hl1723@yahoo.com.hk" target="_blank" href="mailto:hl1723@yahoo.com.hk">hl1723@yahoo.com.hk</a>> wrote:<br clear="none">> current config as below:<br clear="none">>userdb { driver = prefetch}userdb { args =<br clear="none">>/etc/dovecot/dovecot-sql.conf.ext driver = sql}plugin { quota =<br clear="none">>maildir:User quota<br clear="none">> last_login_dict = proxy::lastlogin<br clear="none">> last_login_key = last-login/%u/%d/%r/%l/%a quota_status_success<br clear="none">>= DUNNO<br clear="none">> quota_status_nouser = DUNNO quota_status_overquota = "552 5.2.2<br clear="none">>Mailbox is full"}<br clear="none">>###<br clear="none">>If I changed as below no help,still no pass the Variable to<br clear="none">>last_loginuserdb { driver = prefetch}userdb { args =<br clear="none">>/etc/dovecot/dovecot-sql.conf.ext driver = sql}userdb { driver =<br clear="none">>static args = last_login_key=last-login/%u/%d/%r/%l/%a}<br clear="none">>###If I changed as below will trouble ,cannot restart dovecotuserdb { <br clear="none">>driver = prefetch}userdb { args =<br clear="none">>/etc/dovecot/dovecot-sql.conf.ext last_login_key=last-login/%u/%d/%r/%l/%a <br clear="none">>driver = sql}<br clear="none">><br clear="none">><br clear="none">><br clear="none">><br clear="none">><br clear="none">>Aki Tuomi (<<a rel="nofollow noopener noreferrer" shape="rect" ymailto="mailto:aki.tuomi@open-xchange.com" target="_blank" href="mailto:aki.tuomi@open-xchange.com">aki.tuomi@open-xchange.com</a>>) 在 2021年2月28日星期日 下午03:56:09<br clear="none">>[GMT+8] 寫道： <br clear="none">> <br clear="none">> It goes into the arguments section...<br clear="none">><br clear="none">>Not having your config, I have to guess, but e.g.<br clear="none">><br clear="none">>userdb {<br clear="none">> driver = static<br clear="none">> args = last_login_key=last-login/%u/%d/%r/%l/%a<br clear="none">>}<br clear="none">><br clear="none">>And similarly with other drivers, depending what you use. <br clear="none">><br clear="none">>Aki<br clear="none">><br clear="none">>> On 28/02/2021 09:53 Henry <<a rel="nofollow noopener noreferrer" shape="rect" ymailto="mailto:hl1723@yahoo.com.hk" target="_blank" href="mailto:hl1723@yahoo.com.hk">hl1723@yahoo.com.hk</a>> wrote:<br clear="none">>> <br clear="none">>> <br clear="none">>> <br clear="none">>> Dear Aka,<br clear="none">>> <br clear="none">>> If in userdb, set<br clear="none">>> <br clear="none">>> last_login_key=last-login/%u/%d/%r/%l/%a<br clear="none">>> <br clear="none">>> then cannot restart dovecot the error below :<br clear="none">>> <br clear="none">>> master: Error: Error reading configuration: Error in configuration<br clear="none">>file /etc/dovecot/dovecot.conf line 45: Unknown setting: userdb {<br clear="none">>last_login_key<br clear="none">>> <br clear="none">>> #<br clear="none">>> If in userdb, set<br clear="none">>> default_fields = last_login_key = last-login/%u/%d/%r/%l/%a<br clear="none">>> Error:<br clear="none">>> auth: Fatal: Invalid userdb template last_login_key =<br clear="none">>last-login/%u/%d/%r/%l/%a - key must not be empty<br clear="none">>> <br clear="none">>> <br clear="none">>> what is my wrongs about? thanks<br clear="none">>> <br clear="none">>> <br clear="none">>> Aki Tuomi (<<a rel="nofollow noopener noreferrer" shape="rect" ymailto="mailto:aki.tuomi@open-xchange.com" target="_blank" href="mailto:aki.tuomi@open-xchange.com">aki.tuomi@open-xchange.com</a>>) 在 2021年2月28日星期日 下午02:56:51<br clear="none">>[GMT+8] 寫道：<br clear="none">>> <br clear="none">>> <br clear="none">>> In your userdb, set <br clear="none">>> <br clear="none">>> last_login_key=last-login/%u/%d/%r/%l/%a<br clear="none">>> <br clear="none">>> Then it will expand into what you want, and will be imported into<br clear="none">>user's environment.<br clear="none">>> <br clear="none">>> Aki<br clear="none">>> <br clear="none">>> <br clear="none">>> > On 28/02/2021 05:57 Henry <<a rel="nofollow noopener noreferrer" shape="rect" ymailto="mailto:hl1723@yahoo.com.hk" target="_blank" href="mailto:hl1723@yahoo.com.hk">hl1723@yahoo.com.hk</a>> wrote:<br clear="none">>> > <br clear="none">>> > <br clear="none">>> > like capture local_port, I using %a will got below error<br clear="none">>> > <br clear="none">>> > Error: Failed to expand plugin setting last_login_key =<br clear="none">>'last-login/%u/%d/%r/%l/%a': Unknown variable '%a'<br clear="none">>> > <br clear="none">>> > <br clear="none">>> > If I using any of $local_port ,'$local_port', "$local_port",<br clear="none">>`$local_port`<br clear="none">>> > <br clear="none">>> > I got the database update as $local_port ,'$local_port',<br clear="none">>"$local_port", `$local_port` at the field column record.<br clear="none">>> > <br clear="none">>> > <br clear="none">>> > <br clear="none">>> > Henry (<<a rel="nofollow noopener noreferrer" shape="rect" ymailto="mailto:hl1723@yahoo.com.hk" target="_blank" href="mailto:hl1723@yahoo.com.hk">hl1723@yahoo.com.hk</a>>) 在 2021年2月27日星期六 下午10:57:27 [GMT+8]<br clear="none">>寫道：<br clear="none">>> > <br clear="none">>> > <br clear="none">>> > I already try using other variables , I found it only support "Mail<br clear="none">>service user variables", no support "Login variables" and<br clear="none">>"Authentication variables"<br clear="none">>> > <br clear="none">>> > below the error when I try to using "Login variables" and<br clear="none">>"Authentication variables"<br clear="none">>> > <br clear="none">>> > Error: Failed to expand plugin setting last_login_key =<br clear="none">>'last-login/%u/%d/%r/%l/%k': Unknown variable '%k'<br clear="none">>> > Error: Failed to expand plugin setting last_login_key =<br clear="none">>'last-login/%u/%d/%r/%l/%b': Unknown variable '%b'<br clear="none">>> > Error: Failed to expand plugin setting last_login_key =<br clear="none">>'last-login/%u/%d/%r/%l/%m': Unknown variable '%m'<br clear="none">>> > <br clear="none">>> > I using centos 8 and dovecot-2.3.13-2.x86_64,<br clear="none">>> > <br clear="none">>> > <br clear="none">>> > thanks<br clear="none">>> > <br clear="none">>> > Aki Tuomi (<<a rel="nofollow noopener noreferrer" shape="rect" ymailto="mailto:aki.tuomi@open-xchange.com" target="_blank" href="mailto:aki.tuomi@open-xchange.com">aki.tuomi@open-xchange.com</a>>) 在 2021年2月27日星期六 下午07:32:38<br clear="none">>[GMT+8] 寫道：<br clear="none">>> > <br clear="none">>> > <br clear="none">>> > last_login supports some of the variables. <br clear="none">>> > <br clear="none">>> > <br clear="none">>> > Mail service and mail user variables are supported. <br clear="none">>> > <br clear="none">>> > You can try export the auth variables as userdb variables and use<br clear="none">>$variablename. <br clear="none">>> > <br clear="none">>> > Aki<br clear="none">>> > <br clear="none">>> > <br clear="none">>> > On 27 February 2021 7.29.10 EET, Henry <<a rel="nofollow noopener noreferrer" shape="rect" ymailto="mailto:hl1723@yahoo.com.hk" target="_blank" href="mailto:hl1723@yahoo.com.hk">hl1723@yahoo.com.hk</a>> wrote:<br clear="none">>> > > <br clear="none">>> > >Anyone know then last_login plugins do support standard auth<br clear="none">>variables<br clear="none">>> > >in var-expand?like %k %a variables.<br clear="none">>> > >I need logging other fields such as port 143 or 993, and tls 1.1<br clear="none">>or tls<br clear="none">>> > >1.3, client hostname,<br clear="none">>> > >any patch for this? thanks<br clear="none">>> > ><br clear="none">>> ><br clear="none">>><a rel="nofollow noopener noreferrer" shape="rect" target="_blank" href="https://doc.dovecot.org/configuration_manual/config_file/config_variables/">https://doc.dovecot.org/configuration_manual/config_file/config_variables/</a><br clear="none">>> > > Henry (<<a rel="nofollow noopener noreferrer" shape="rect" ymailto="mailto:hl1723@yahoo.com.hk" target="_blank" href="mailto:hl1723@yahoo.com.hk">hl1723@yahoo.com.hk</a>>) 在 2021年2月19日星期五 下午12:15:10 [GMT+8]<br clear="none">>寫道： <br clear="none">>> > > <br clear="none">>> > >but I need logging other fields such as port 143 or 993, and tls<br clear="none">>1.1 or<br clear="none">>> > >tls 1.3, client hostname, what should I do it ?<br clear="none">>> ><br clear="none">>><a rel="nofollow noopener noreferrer" shape="rect" target="_blank" href="https://doc.dovecot.org/configuration_manual/config_file/config_variables/">https://doc.dovecot.org/configuration_manual/config_file/config_variables/</a><br clear="none">>> > ><br clear="none">>> > >Aki Tuomi (<<a rel="nofollow noopener noreferrer" shape="rect" ymailto="mailto:aki.tuomi@open-xchange.com" target="_blank" href="mailto:aki.tuomi@open-xchange.com">aki.tuomi@open-xchange.com</a>>) 在 2021年2月18日星期四<br clear="none">>下午03:04:10<br clear="none">>> > >[GMT+8] 寫道： <br clear="none">>> > > <br clear="none">>> > > <br clear="none">>> > >> On 18/02/2021 08:57 Henry <<a rel="nofollow noopener noreferrer" shape="rect" ymailto="mailto:hl1723@yahoo.com.hk" target="_blank" href="mailto:hl1723@yahoo.com.hk">hl1723@yahoo.com.hk</a>> wrote:<br clear="none">>> > >> <br clear="none">>> > >> <br clear="none">>> > >> <br clear="none">>> > >> <br clear="none">>> > >> Anyone kwon the last-login plugins can using Authentication<br clear="none">>variables<br clear="none">>> > >such as %m mechanism, %a local_port .<br clear="none">>> > >> we want to record this in DB, thanks<br clear="none">>> > ><br clear="none">>> > >You can use this syntax to add further fields for last_login<br clear="none">>plugin.<br clear="none">>> > ><br clear="none">>> > > map {<br clear="none">>> > > pattern = shared/last-login/$user/$domain<br clear="none">>> > > table = last_login<br clear="none">>> > > value_field = last_login<br clear="none">>> > > value_type = uint<br clear="none">>> > ><br clear="none">>> > > fields {<br clear="none">>> > > username = $user<br clear="none">>> > > domain = $domain<br clear="none">>> > > rip = $rip<br clear="none">>> > > }<br clear="none">>> > >} <br clear="none">>> > ><br clear="none">>> > >Aki<br clear="none">>> > <br clear="none">>> > > <br clear="none">>> > <br clear="none">>> > -- <br clear="none">>> > Sent from my Android device with K-9 Mail. Please excuse my<br clear="none">>brevity.<br clear="none">>> ><br clear="none">> <br clear="none"></div></div></div></div>
</div>
</div></div></div></div>
</div>
</div></blockquote></div></div></div></div></div>
</div>
</div></body></html>