dbmail3 - question about imap-capabilities

hi, a question about IMAP-capabilities

this is the default banner
OK [CAPABILITY IMAP4rev1 AUTH=LOGIN AUTH=CRAM-MD5 STARTTLS ID] dbmail 3.0.0 ready

this is in the "dbmail.conf" of the package
capability = IMAP4 IMAP4rev1 AUTH=LOGIN ACL RIGHTS=texk NAMESPACE CHILDREN SORT QUOTA THREAD=ORDEREDSUBJECT
UNSELECT IDLE

am i right that the capabilities of the default config are supported
and this is not only a abstract example?

--

-- 

Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofmühlgasse 17
CTO / software-development / cms-solutions
p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
icq: 154546673, http://www.thelounge.net/

http://www.thelounge.net/signature.asc.what.htm

_______________________________________________
DBmail mailing list
DBmail <at> dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

problem with unique-kyes

hi

trying to make a dbmail-upgrade on a snapshoted backup-machine
show duplicate keys in "dbmail_envelope"

am i right that it would be the best remove this records
on the 2.2 live-server, add the unique_key and remove
this lines form 2_2-3.0.sql after that?

this records are generally strange for me 
_________________

mysql> ALTER TABLE dbmail_envelope ADD UNIQUE KEY physmessage_id_2 (physmessage_id);
ERROR 1062 (23000): Duplicate entry '404219' for key 'physmessage_id_2'

mysql> select * from dbmail_envelope where physmessage_id='404219' limit 3;
+----------------+--------+---------------------------------------------------------------------------------------------------+
| physmessage_id | id     | envelope
           |
+----------------+--------+---------------------------------------------------------------------------------------------------+
|         404219 | 407718 | ("Thu, 01 Jan 1970 00:00:00 +0000" NIL NIL NIL NIL NIL NIL NIL NIL
"<1259405894.19903.1 <at> (none)>") |
|         404219 | 408487 | ("Thu, 01 Jan 1970 00:00:00 +0000" NIL NIL NIL NIL NIL NIL NIL NIL NIL)
           |
|         404219 | 409588 | ("Thu, 01 Jan 1970 00:00:00 +0000" NIL NIL NIL NIL NIL NIL NIL NIL NIL)
           |
+----------------+--------+---------------------------------------------------------------------------------------------------+
3 rows in set (0.00 sec)

mysql> select count(*) from dbmail_envelope where physmessage_id='404219';

Re: dbmail3 - question about imap-capabilities

On 02/01/2012 01:04 PM, Reindl Harald wrote:
> hi, a question about IMAP-capabilities
> 
> this is the default banner OK [CAPABILITY IMAP4rev1 AUTH=LOGIN
> AUTH=CRAM-MD5 STARTTLS ID] dbmail 3.0.0 ready

It's de pre-auth banner.

> 
> this is in the "dbmail.conf" of the package capability = IMAP4
> IMAP4rev1 AUTH=LOGIN ACL RIGHTS=texk NAMESPACE CHILDREN SORT QUOTA
> THREAD=ORDEREDSUBJECT UNSELECT IDLE

After authentication the AUTH= capabilities are removed and the other
ones in the capability string are added.

Testing against my dogfood server:

~> nc myhost imap
* OK [CAPABILITY IMAP4rev1 AUTH=LOGIN STARTTLS ID] dbmail 3.0.0 ready
x login testuser1 test
x OK [CAPABILITY IMAP4rev1 ACL RIGHTS=texk NAMESPACE CHILDREN SORT
QUOTA THREAD=ORDEREDSUBJECT UNSELECT IDLE STARTTLS ID] User testuser1
authenticated
x logout
* BYE
x OK LOGOUT completed

So my server doesn't support AUTH=CRAM-MD5 because I use LDAP.

Re: dbmail3 - question about imap-capabilities

Am 01.02.2012 14:56, schrieb Paul J Stevens:
> On 02/01/2012 01:04 PM, Reindl Harald wrote:
>> hi, a question about IMAP-capabilities
>>
>> this is the default banner OK [CAPABILITY IMAP4rev1 AUTH=LOGIN
>> AUTH=CRAM-MD5 STARTTLS ID] dbmail 3.0.0 ready
> 
> It's de pre-auth banner.
> 
>>
>> this is in the "dbmail.conf" of the package capability = IMAP4
>> IMAP4rev1 AUTH=LOGIN ACL RIGHTS=texk NAMESPACE CHILDREN SORT QUOTA
>> THREAD=ORDEREDSUBJECT UNSELECT IDLE
> 
> After authentication the AUTH= capabilities are removed and the other
> ones in the capability string are added.
> 
> Testing against my dogfood server:
> 
> ~> nc myhost imap
> * OK [CAPABILITY IMAP4rev1 AUTH=LOGIN STARTTLS ID] dbmail 3.0.0 ready
> x login testuser1 test
> x OK [CAPABILITY IMAP4rev1 ACL RIGHTS=texk NAMESPACE CHILDREN SORT
> QUOTA THREAD=ORDEREDSUBJECT UNSELECT IDLE STARTTLS ID] User testuser1
> authenticated
> x logout
> * BYE
> x OK LOGOUT completed
> 

Re: dbmail3 - question about imap-capabilities

On 02/01/2012 03:01 PM, Reindl Harald wrote:
> 
> 
> Am 01.02.2012 14:56, schrieb Paul J Stevens:
>> On 02/01/2012 01:04 PM, Reindl Harald wrote:
>>> hi, a question about IMAP-capabilities
>>> 
>>> this is the default banner OK [CAPABILITY IMAP4rev1 AUTH=LOGIN 
>>> AUTH=CRAM-MD5 STARTTLS ID] dbmail 3.0.0 ready
>> 
>> It's de pre-auth banner.
>> 
>>> 
>>> this is in the "dbmail.conf" of the package capability = IMAP4 
>>> IMAP4rev1 AUTH=LOGIN ACL RIGHTS=texk NAMESPACE CHILDREN SORT
>>> QUOTA THREAD=ORDEREDSUBJECT UNSELECT IDLE
>> 
>> After authentication the AUTH= capabilities are removed and the
>> other ones in the capability string are added.
>> 
>> Testing against my dogfood server:
>> 
>> ~> nc myhost imap * OK [CAPABILITY IMAP4rev1 AUTH=LOGIN STARTTLS
>> ID] dbmail 3.0.0 ready x login testuser1 test x OK [CAPABILITY
>> IMAP4rev1 ACL RIGHTS=texk NAMESPACE CHILDREN SORT QUOTA
>> THREAD=ORDEREDSUBJECT UNSELECT IDLE STARTTLS ID] User testuser1 
>> authenticated x logout * BYE x OK LOGOUT completed
>> 
>> So my server doesn't support AUTH=CRAM-MD5 because I use LDAP.

Re: dbmail3 - question about imap-capabilities

Am 01.02.2012 16:04, schrieb Paul J Stevens:
>>> in the "dbmail.conf" of the package capability = IMAP4 
>>>> IMAP4rev1 AUTH=LOGIN ACL RIGHTS=texk NAMESPACE CHILDREN SORT
>>>> QUOTA THREAD=ORDEREDSUBJECT UNSELECT IDLE
>>>
>>> After authentication the AUTH= capabilities are removed and the
>>> other ones in the capability string are added.
>>>
>> hm - this is bad
> 
> are you sure?

pretty sure

AFAIK the sense of providing the capabilities in the greeting
is that clients who do understand this doe snot need to
request them exlicitly from the server

>> the "pre-auth banner" should display exactly the same as really 
>> supported - we had a pitfall with dovecot-2.0 as proxy in front of
>> dbmail where dovecot ignored the capability setting in 
>> "dovecot.conf" and spittet out his own in the greeting screen
> 
>> resulted in iPhones were no longer able to check mails because they
>> are reading the banner and after that working with the capabilities
>> from it
> 
> iPhone has a broken IMAP client? That is news!

Re: dbmail3 - question about imap-capabilities

On 02/01/2012 04:14 PM, Reindl Harald wrote:

> on our setup this is not a problem because dovecot as proxy provides
> the configured capabilities in the login-greeting and the client
> never sees dbmail itself, but my intention was to make a short alert
> for users with dbmail-imapd directly on the wire and possible
> problems with more or less broken clients

THe current CAPABILITY response was specifically modelled after dovecot,
since Timo is generally totally on top of these things.

Please provide a typical capabilities scenario that would work for you.

But again: some confirmation that this really is a problem is needed
before I start fixing things that may not be broken.

Anyone with an iPhone willing to help us test this?

--

-- 
________________________________________________________________
Paul J Stevens        pjstevns  <at>  gmail, twitter, skype, linkedin

  * Premium Hosting Services and Web Application Consultancy *

           www.nfg.nl/info <at> nfg.nl/+31.85.877.99.97
________________________________________________________________

Re: dbmail3 - question about imap-capabilities

On 02/01/2012 05:26 PM, Paul J Stevens wrote:
> THe current CAPABILITY response was specifically modelled after dovecot,
> since Timo is generally totally on top of these things.

.... based on an older dovecot version

--

-- 
________________________________________________________________
Paul J Stevens        pjstevns  <at>  gmail, twitter, skype, linkedin

  * Premium Hosting Services and Web Application Consultancy *

           www.nfg.nl/info <at> nfg.nl/+31.85.877.99.97
________________________________________________________________

Re: dbmail3 - question about imap-capabilities

On Feb 1, 2012, at 4:14 PM, Reindl Harald wrote:

> AFAIK the sense of providing the capabilities in the greeting
> is that clients who do understand this doe snot need to
> request them exlicitly from the server

YMMV, but updating the capability after authentication seems kosher:

"A server MAY send capabilities automatically, by using the
CAPABILITY response code in the initial PREAUTH or OK responses,
and by sending an updated CAPABILITY response code in the tagged
OK response as part of a successful authentication."

http://tools.ietf.org/html/rfc3501#section-7.2.1

Note the "updated CAPABILITY response code".

On the other hand, the IMAP specification was never a model of clarity.

Re: dbmail3 - question about imap-capabilities

> Anyone with an iPhone willing to help us test this?

Got every single iPhone model here as well as around 20 different Android devices,
what exactly needs to be tested? IMAP access to latest dbmail 3?

Greetings,
Daniel