Re: dovecot username with domain

2023-09-19 Thread Tom Hendrikx via dovecot

On 19-09-2023 22:36, Dave McGuire wrote:

On 9/19/23 16:34, Michael Grant wrote:


Thanks, I was hoping for something less complicated.  I found
   auth_username_format %n
which drops the domain if supplied.  Unfortunately my imap username
isn't 'mgrant'.  Probably i could make this work if there was no other
way.  This forces me to have my IMAP password the same as my unix
password.

I probably should move to virtual users for everyone on my box but
that's not so easy.  I was hoping there was some way i could translate
individual users which would make this transition easier.


You could have virtual users with any username (matching the required 
format for 'New Outlook') and password in an SQL passdb + userdb, and a 
second backend for the system users (PAM probably) as a fallback.


The docs describe this precise scenario at: 
https://doc.dovecot.org/configuration_manual/authentication/multiple_authentication_databases/



Regards,
Tom
___
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-le...@dovecot.org


Re: dovecot username with domain

2023-09-19 Thread Dave McGuire

On 9/19/23 16:34, Michael Grant wrote:

   Heya mgrant, been a long time!


Very!  Will hit you off-list.


  :-)


   If you're using a database for authentication, you can do this sort of
translation past using stored functions in MySQL.  Queries look something
like this:

password_query = SELECT userid AS username, domain, password FROM mail_users
WHERE userid = addr_to_uname('%u') AND domain =
addr_to_domain_or_default('%u', 'domain.com')

...

Thanks, I was hoping for something less complicated.  I found
   auth_username_format %n
which drops the domain if supplied.  Unfortunately my imap username
isn't 'mgrant'.  Probably i could make this work if there was no other
way.  This forces me to have my IMAP password the same as my unix
password.

I probably should move to virtual users for everyone on my box but
that's not so easy.  I was hoping there was some way i could translate
individual users which would make this transition easier.


  You can use that technique, though, to implement any sort of 
translation table that you could build into an SQL query.  Just a 
suggestion.


   -Dave

--
Dave McGuire, AK4HZ
New Kensington, PA

___
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-le...@dovecot.org


Re: dovecot username with domain

2023-09-19 Thread Michael Grant via dovecot
>   Heya mgrant, been a long time!

Very!  Will hit you off-list.

>   If you're using a database for authentication, you can do this sort of
> translation past using stored functions in MySQL.  Queries look something
> like this:
> 
> password_query = SELECT userid AS username, domain, password FROM mail_users
> WHERE userid = addr_to_uname('%u') AND domain =
> addr_to_domain_or_default('%u', 'domain.com')
...

Thanks, I was hoping for something less complicated.  I found
  auth_username_format %n
which drops the domain if supplied.  Unfortunately my imap username
isn't 'mgrant'.  Probably i could make this work if there was no other
way.  This forces me to have my IMAP password the same as my unix
password.

I probably should move to virtual users for everyone on my box but
that's not so easy.  I was hoping there was some way i could translate
individual users which would make this transition easier.


signature.asc
Description: PGP signature
___
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-le...@dovecot.org


Re: dovecot username with domain

2023-09-19 Thread Dave McGuire

On 9/19/23 15:51, Michael Grant via dovecot wrote:

I've been using dovecot using system usernames (my unix uname as my
IMAP username).  But today I tried New Outlook which requires the imap
username match my email address.

Is there some way to tell dovecot that username@host is the same as uname?
(where username@host is an email address and uname is a unix login
which might be completely different).


  Heya mgrant, been a long time!

  If you're using a database for authentication, you can do this sort 
of translation past using stored functions in MySQL.  Queries look 
something like this:


password_query = SELECT userid AS username, domain, password FROM 
mail_users WHERE userid = addr_to_uname('%u') AND domain = 
addr_to_domain_or_default('%u', 'domain.com')


  One of the functions is something like this:


DELIMITER ?
CREATE FUNCTION addr_to_domain_or_default (userid VARCHAR(255), 
default_domain VARCHAR(255)) RETURNS VARCHAR(255) DETERMINISTIC

BEGIN
DECLARE at_pos INT;
DECLARE addr_out VARCHAR(255);

SELECT LOCATE('@', userid) INTO at_pos;
IF at_pos = 0 THEN
  CASE userid
WHEN 'user1' THEN SET addr_out = 'domain1.com';
WHEN 'user2' THEN SET addr_out = 'domain2.com';
ELSE SET addr_out = default_domain;
  END CASE;
ELSE
  SELECT SUBSTRING(userid, at_pos + 1) INTO addr_out;
END IF;

RETURN addr_out;

END ?
DELIMITER ;
--

  This isn't exactly the functionality you want, but it illustrates the 
kinds of translations that can easy be done on the database side.  I've 
been using a scheme like this for many years with great results.


-Dave

--
Dave McGuire, AK4HZ
New Kensington, PA

___
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-le...@dovecot.org


dovecot username with domain

2023-09-19 Thread Michael Grant via dovecot
I've been using dovecot using system usernames (my unix uname as my
IMAP username).  But today I tried New Outlook which requires the imap
username match my email address.  

Is there some way to tell dovecot that username@host is the same as uname?
(where username@host is an email address and uname is a unix login
which might be completely different).

Michael Grant


signature.asc
Description: PGP signature
___
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-le...@dovecot.org


Re: New Dovecot release?

2023-09-19 Thread Taavi Ansper via dovecot

Hi

After running from backports the issue still seems to be there unfortunately 
for me.

If it is a kernel issue we are running this on Xen Paravirtualized VM.

6.1.0-0.deb11.11-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.38-4~bpo11+1 
(2023-08-08) x86_64 GNU/Linux

Taavi Ansper
taavi.ans...@cyber.ee

On 19.09.23 17:12, Elisamuel Resto wrote:

Hello,

I had reported it a while back in April on this list and Aki is correct — it is 
due to recent kernels. The change that was committed to Git resolved the issue 
for me with kernel version 6.1.12 on Gentoo.

For reference, Aki had stated it was fixed in main and provided this: 
https://github.com/dovecot/core/compare/f359c6ee179aad5e077711c188fc8422106cbead%5E..d93c31d51b05d43eaa6eeef9cdc0f7a4157f7d0e.patch


Regards,
Elisamuel Resto


On Sep 19, 2023, at 02:54, Aki Tuomi via dovecot  wrote:



On 19/09/2023 10:33 EEST Taavi Ansper via dovecot  wrote:


Hi

When will there be a new dovecot release. The 2.3.21 version borked our users 
with large amount of folders (i think over 255 folders)

doveadm(REDACTED_USER): Error: /proc/self/status is larger than expected

I can't find the debian bug report (or was it mentioned in this same mailing 
list), but somebody else has mentioned the same issue.

I hope this gets fixed in the next version.

--
Taavi Ansper
taavi.ans...@cyber.ee


Hi!

This is actually caused by very recent kernels, if I remember correctly. Can you 
let me known the distro & kernel you are using and source of your packages? 
This is actually fixed for 2.4 already in

https://github.com/dovecot/core/commit/218a79a48bb0e5d2be44bb46c51836fd406b0c50.patch

Aki
___
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-le...@dovecot.org

___
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-le...@dovecot.org

___
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-le...@dovecot.org


Re: New Dovecot release?

2023-09-19 Thread Elisamuel Resto
Hello,

I had reported it a while back in April on this list and Aki is correct — it is 
due to recent kernels. The change that was committed to Git resolved the issue 
for me with kernel version 6.1.12 on Gentoo.

For reference, Aki had stated it was fixed in main and provided this: 
https://github.com/dovecot/core/compare/f359c6ee179aad5e077711c188fc8422106cbead%5E..d93c31d51b05d43eaa6eeef9cdc0f7a4157f7d0e.patch


Regards,
Elisamuel Resto

> On Sep 19, 2023, at 02:54, Aki Tuomi via dovecot  wrote:
> 
>> 
>> On 19/09/2023 10:33 EEST Taavi Ansper via dovecot  
>> wrote:
>> 
>> 
>> Hi
>> 
>> When will there be a new dovecot release. The 2.3.21 version borked our 
>> users with large amount of folders (i think over 255 folders)
>> 
>> doveadm(REDACTED_USER): Error: /proc/self/status is larger than expected
>> 
>> I can't find the debian bug report (or was it mentioned in this same mailing 
>> list), but somebody else has mentioned the same issue.
>> 
>> I hope this gets fixed in the next version.
>> 
>> --
>> Taavi Ansper
>> taavi.ans...@cyber.ee
> 
> Hi!
> 
> This is actually caused by very recent kernels, if I remember correctly. Can 
> you let me known the distro & kernel you are using and source of your 
> packages? This is actually fixed for 2.4 already in
> 
> https://github.com/dovecot/core/commit/218a79a48bb0e5d2be44bb46c51836fd406b0c50.patch
> 
> Aki
> ___
> dovecot mailing list -- dovecot@dovecot.org
> To unsubscribe send an email to dovecot-le...@dovecot.org
___
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-le...@dovecot.org


Re: How to use http api doveadm to manage acl permissions

2023-09-19 Thread Aki Tuomi via dovecot


> On 19/09/2023 15:30 EEST cyril.lecl...@mantiq.com wrote:
> 
>  
> hi, 
> 
> yes i alredy executed but nothing with "acl" name or "permissions" so how i 
> can find the good command ?
> 
> thank you

Maybe you did something wrong, because I was able to get these.

Aki

{"command":"aclGet", "parameters":[
{"name":"allUsers","type":"boolean"},
{"name":"socketPath","type":"string"},
{"name":"user","type":"string"},
{"name":"transFlags","type":"integer"},
{"name":"userFile","type":"string"},
{"name":"matchMe","type":"boolean"},
{"name":"mailbox","type":"string"}
]},
{"command":"aclRights", "parameters":[
{"name":"allUsers","type":"boolean"},
{"name":"socketPath","type":"string"},
{"name":"user","type":"string"},
{"name":"transFlags","type":"integer"},
{"name":"userFile","type":"string"},
{"name":"mailbox","type":"string"}
]},
{"command":"aclSet", "parameters":[
{"name":"allUsers","type":"boolean"},
{"name":"socketPath","type":"string"},
{"name":"user","type":"string"},
{"name":"transFlags","type":"integer"},
{"name":"userFile","type":"string"},
{"name":"mailbox","type":"string"},
{"name":"id","type":"string"},
{"name":"right","type":"array"}
]},
{"command":"aclAdd", "parameters":[
{"name":"allUsers","type":"boolean"},
{"name":"socketPath","type":"string"},
{"name":"user","type":"string"},
{"name":"transFlags","type":"integer"},
{"name":"userFile","type":"string"},
{"name":"mailbox","type":"string"},
{"name":"id","type":"string"},
{"name":"right","type":"array"}
]},
{"command":"aclRemove", "parameters":[
{"name":"allUsers","type":"boolean"},
{"name":"socketPath","type":"string"},
{"name":"user","type":"string"},
{"name":"transFlags","type":"integer"},
{"name":"userFile","type":"string"},
{"name":"mailbox","type":"string"},
{"name":"id","type":"string"},
{"name":"right","type":"array"}
]},
{"command":"aclDelete", "parameters":[
{"name":"allUsers","type":"boolean"},
{"name":"socketPath","type":"string"},
{"name":"user","type":"string"},
{"name":"transFlags","type":"integer"},
{"name":"userFile","type":"string"},
{"name":"mailbox","type":"string"},
{"name":"id","type":"string"}
]},
{"command":"aclRecalc", "parameters":[
{"name":"allUsers","type":"boolean"},
{"name":"socketPath","type":"string"},
{"name":"user","type":"string"},
{"name":"transFlags","type":"integer"},
{"name":"userFile","type":"string"}
]},
{"command":"aclDebug", "parameters":[
{"name":"allUsers","type":"boolean"},
{"name":"socketPath","type":"string"},
{"name":"user","type":"string"},
{"name":"transFlags","type":"integer"},
{"name":"userFile","type":"string"},
{"name":"mailbox","type":"string"}
]}
___
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-le...@dovecot.org


Re: How to use http api doveadm to manage acl permissions

2023-09-19 Thread cyril . leclerc
hi, 

yes i alredy executed but nothing with "acl" name or "permissions" so how i can 
find the good command ?

thank you
___
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-le...@dovecot.org


Re: New Dovecot release?

2023-09-19 Thread Taavi Ansper via dovecot

Hi

I am using: 5.10.0-25-amd64 #1 SMP Debian 5.10.191-1 (2023-08-16) x86_64 on 
Debian 11 Bullseye

ii  debian-dovecot-auto-keyring2010.01.30   all 
 GnuPG archive keys of the Automatic Dovecot Debian repository
ii  dovecot-core   2:2.3.21-1+debian11  amd64   
 secure POP3/IMAP server - core files
ii  dovecot-dev2:2.3.21-1+debian11  amd64   
 secure POP3/IMAP server - header files
ii  dovecot-imapd  2:2.3.21-1+debian11  amd64   
 secure POP3/IMAP server - IMAP daemon
ii  dovecot-lmtpd  2:2.3.21-1+debian11  amd64   
 secure POP3/IMAP server - LMTP server
ii  dovecot-managesieved   2:2.3.21-1+debian11  amd64   
 secure POP3/IMAP server - ManageSieve server
ii  dovecot-sieve  2:2.3.21-1+debian11  amd64   
 secure POP3/IMAP server - Sieve filters support


Taavi Ansper
taavi.ans...@cyber.ee
+372 5905 2861

On 19.09.23 10:49, Aki Tuomi via dovecot wrote:

On 19/09/2023 10:33 EEST Taavi Ansper via dovecot  wrote:

  
Hi


When will there be a new dovecot release. The 2.3.21 version borked our users 
with large amount of folders (i think over 255 folders)

doveadm(REDACTED_USER): Error: /proc/self/status is larger than expected

I can't find the debian bug report (or was it mentioned in this same mailing 
list), but somebody else has mentioned the same issue.

I hope this gets fixed in the next version.

--
Taavi Ansper
taavi.ans...@cyber.ee


Hi!

This is actually caused by very recent kernels, if I remember correctly. Can you 
let me known the distro & kernel you are using and source of your packages? 
This is actually fixed for 2.4 already in

https://github.com/dovecot/core/commit/218a79a48bb0e5d2be44bb46c51836fd406b0c50.patch

Aki
___
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-le...@dovecot.org

___
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-le...@dovecot.org


Re: New Dovecot release?

2023-09-19 Thread Aki Tuomi via dovecot
> On 19/09/2023 10:33 EEST Taavi Ansper via dovecot  wrote:
> 
>  
> Hi
> 
> When will there be a new dovecot release. The 2.3.21 version borked our users 
> with large amount of folders (i think over 255 folders)
> 
> doveadm(REDACTED_USER): Error: /proc/self/status is larger than expected
> 
> I can't find the debian bug report (or was it mentioned in this same mailing 
> list), but somebody else has mentioned the same issue.
> 
> I hope this gets fixed in the next version.
> 
> -- 
> Taavi Ansper
> taavi.ans...@cyber.ee

Hi!

This is actually caused by very recent kernels, if I remember correctly. Can 
you let me known the distro & kernel you are using and source of your packages? 
This is actually fixed for 2.4 already in

https://github.com/dovecot/core/commit/218a79a48bb0e5d2be44bb46c51836fd406b0c50.patch

Aki
___
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-le...@dovecot.org