Re:
Hi
Do you test postlogin ?
https://doc.dovecot.org/2.3/admin_manual/post_login_scripting/
https://www.lemat.priv.pl/index.php?m=page&pg_id=170
W dniu 30.09.2024 o 15:49, Maciej Polewczyński via dovecot pisze:
When using the last_login plugin I noticed that the IP address
information is not updated. If there is no entry in the sql database
for a given user, the first time the login date and time information
and the IP address will be saved. Each subsequent login only updates
the date and time. The IP address remains unchanged.
Example configuration for pop3 service:
map {
pattern = shared/last-login/pop3/$user/$rip
table = last_login
value_field = last_pop3_access
value_type = uint
fields {
userid = $user
last_pop3_ip = $rip
}
}
This is translated into the following sql command:
INSERT INTO last_login (last_pop3_access,userid,last_pop3_ip) VALUES
(1727691183673,'test','1.2.3.4') ON DUPLICATE KEY UPDATE
last_pop3_access=1727691183673
You can see that after "ON DUPLICATE KEY" only the time is updated.
Is there any way to influence the behavior of the plugin and the sql
query so that the IP address is also updated? I'm using Dovecot v2.3.4
--
Maciej Miłaszewski
Starszy Administrator Systemowy
IQ PL Sp. z o.o.
ul. Geodetów 16, 80-298 Gdańsk
NIP 5832736211
KRS 007725,
www.iq.pl
Sąd rejestrowy: Sąd Rejonowy w Gdańsku VII Wydział KRS, kapitał zakładowy:
140.000 PLN
Dział pomocy: https://www.iq.pl/pomoc
Informacja dotycząca przetwarzania danych osobowych:
https://www.iq.pl/obowiazek-informacyjny
OpenPGP_signature.asc
Description: OpenPGP digital signature
___
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-le...@dovecot.org
Re: last_login plugin does not update IP
Yes, I use this to policy delegation. My problem could be solved this way.
The official documentation suggests that you can update more than just
the time using the last_login plugin. If that's not possible, I suggest
changing the documentation or fixing the plugin.
W dniu 30.09.2024 o 16:10, Maciej Milaszewski via dovecot pisze:
Hi
Do you test postlogin ?
https://doc.dovecot.org/2.3/admin_manual/post_login_scripting/
https://www.lemat.priv.pl/index.php?m=page&pg_id=170
W dniu 30.09.2024 o 15:49, Maciej Polewczyński via dovecot pisze:
When using the last_login plugin I noticed that the IP address
information is not updated. If there is no entry in the sql database
for a given user, the first time the login date and time information
and the IP address will be saved. Each subsequent login only updates
the date and time. The IP address remains unchanged.
Example configuration for pop3 service:
map {
pattern = shared/last-login/pop3/$user/$rip
table = last_login
value_field = last_pop3_access
value_type = uint
fields {
userid = $user
last_pop3_ip = $rip
}
}
This is translated into the following sql command:
INSERT INTO last_login (last_pop3_access,userid,last_pop3_ip) VALUES
(1727691183673,'test','1.2.3.4') ON DUPLICATE KEY UPDATE
last_pop3_access=1727691183673
You can see that after "ON DUPLICATE KEY" only the time is updated.
Is there any way to influence the behavior of the plugin and the sql
query so that the IP address is also updated? I'm using Dovecot v2.3.4
___
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-le...@dovecot.org
--
Best regards,
Maciej Polewczyński
Do or do not. There is no try.
Chief postman at cyber_Folks
mobile: +48 608-527-002
street Wierzbięcice 1B, 61-569 Poznań. Building D, floor VIII
___
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-le...@dovecot.org
last_login plugin does not update IP
When using the last_login plugin I noticed that the IP address
information is not updated. If there is no entry in the sql database for
a given user, the first time the login date and time information and the
IP address will be saved. Each subsequent login only updates the date
and time. The IP address remains unchanged.
Example configuration for pop3 service:
map {
pattern = shared/last-login/pop3/$user/$rip
table = last_login
value_field = last_pop3_access
value_type = uint
fields {
userid = $user
last_pop3_ip = $rip
}
}
This is translated into the following sql command:
INSERT INTO last_login (last_pop3_access,userid,last_pop3_ip) VALUES
(1727691183673,'test','1.2.3.4') ON DUPLICATE KEY UPDATE
last_pop3_access=1727691183673
You can see that after "ON DUPLICATE KEY" only the time is updated.
Is there any way to influence the behavior of the plugin and the sql
query so that the IP address is also updated? I'm using Dovecot v2.3.4
--
Best regards,
Maciej Polewczyński
Do or do not. There is no try.
___
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-le...@dovecot.org
Namespace for seperate Storage of Archive
Hi everyone,
I would like to move the "Archives" Folder for every user from my default
storage to another storage in the backend, while maintaining the current
frontend view of the IMAP Mailboxstructure.
Because I didn't manage to get it to work properly on my production server, I
made a separate Testserver.
My problem is, that I don't know what to put in the "prefix" section of the
Namespace, so that the Archive Folder is on the same folder/mailbox hierarchy
level as the ones in the default namespace (Sent Messages, Drafts ...).
I have read the Namespace RFC (rfc2342) and there is one example which uses the
Tilde ~ Character as the Namespace prefix - put the rfc doesn't address the
tilde, it only has it in one of the examples (Example 5.4).
Because ~ often means 'base folder' I thought this would work. But it doesn't.
The Thunderbird client shows:
Rootdir/Sent
but
Rootdir/~/Archive
I am aware I can solve this with symlinks, but I would like to do it properly
with namespaces.
Could you please tell me what I am missing?
In case this is an Thunderbird Issue, could you please point out, what I don't
understand?
Thank you!
Kind Regards
Christian
dovecot --version
2.3.19.1 (9b53102964)
dovecot -n
# 2.3.19.1 (9b53102964): /etc/dovecot/dovecot.conf
# Pigeonhole version 0.5.19 (4eae2f79)
# OS: Linux 6.1.0-25-amd64 x86_64 Debian 12.7
# Hostname: mailserver.lan
auth_debug = yes
auth_mechanisms = plain login
auth_verbose = yes
debug_log_path = /var/log/dovecot/debug.log
disable_plaintext_auth = no
info_log_path = /var/log/dovecot/info.log
log_path = /var/log/dovecot/error_or_warn.log
mail_gid = user
mail_home = /mnt/mails/%u
mail_location = maildir:~/Maildir
mail_uid = user
namespace archivns {
inbox = no
location = maildir:/mnt/mails2/%u
mailbox Archive {
auto = subscribe
special_use = \Archive
}
prefix = ~/
separator = /
}
namespace inbox {
inbox = yes
location =
mailbox Drafts {
auto = subscribe
special_use = \Drafts
}
mailbox Junk {
auto = subscribe
special_use = \Junk
}
mailbox Sent {
auto = subscribe
special_use = \Sent
}
mailbox "Sent Messages" {
special_use = \Sent
}
mailbox Trash {
auto = subscribe
special_use = \Trash
}
prefix =
separator = /
}
passdb {
args = /etc/dovecot/passwd
driver = passwd-file
}
protocols = imap
service imap-login {
inet_listener imap {
port = 143
}
}
ssl = no
userdb {
args = /etc/dovecot/passwd
driver = passwd-file
}
___
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-le...@dovecot.org
Namespace for seperate Storage of Archive
Hi everyone,
I found the Solution myself. The key was to simply create an unnamed
mailbox directive so that the namespace prefix directly results into an
mailbox that Thunderbirds shows as the Archive.
Thanks everbody on the dovecot team for making such a brilliant Software!
Greetings!
Christian
namespace inbox {
inbox = yes
location =
mailbox Drafts {
auto = subscribe
special_use = \Drafts
}
mailbox Junk {
auto = subscribe
special_use = \Junk
}
mailbox Sent {
auto = subscribe
special_use = \Sent
}
mailbox "Sent Messages" {
special_use = \Sent
}
mailbox Trash {
auto = subscribe
special_use = \Trash
}
prefix =
separator = /
}
namespace archivns {
prefix = Archive/<--- this is the Name which now appears at the same
Level then Sent/Draft/...
location = maildir:/mnt/mails2/%u
separator = /
mailbox {<--- here a name is omitted
auto = subscribe
special_use = \Archive
}
}
___
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-le...@dovecot.org
Re: Namespace for seperate Storage of Archive
Hi everyone,
I found the Solution myself. The key was to simply create an unnamed
mailbox directive so that the namespace prefix directly results into an
mailbox that Thunderbirds shows as the Archive.
Thanks everbody on the dovecot team for making such a brilliant Software!
Greetings!
Christian
namespace inbox {
inbox = yes
location =
mailbox Drafts {
auto = subscribe
special_use = \Drafts
}
mailbox Junk {
auto = subscribe
special_use = \Junk
}
mailbox Sent {
auto = subscribe
special_use = \Sent
}
mailbox "Sent Messages" {
special_use = \Sent
}
mailbox Trash {
auto = subscribe
special_use = \Trash
}
prefix =
separator = /
}
namespace archivns {
prefix = Archive/<--- this is the Name which now appears at the same Level
then Sent/Draft/...
location = maildir:/mnt/mails2/%u
separator = /
mailbox {<--- here a name is omitted
auto = subscribe
special_use = \Archive
}
}
___
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-le...@dovecot.org
