Re: [Dbmail-dev] [DBMail 0000338]: The header indication is broken in some MUA. some MUA.

2006-05-03 Thread Paul J Stevens
[EMAIL PROTECTED] wrote: > -- > sayler - 03-May-06 19:21 > -- > Does this mean that queries to return a specific header (as opposed to the > whole header sect

Re: [Dbmail-dev] [DBMail 0000338]: The header indication is brokenin some MUA. some MUA.

2006-05-03 Thread Paul J Stevens
The thing is the postgres tables are already TEXT, so there's not issue. The create_tables mysql however used varchar(255) and the code truncates. This was done to limit storage, but breaks u7 encoding. So now I'm switching mysql to text like postgres. For 2.1.x users running the mysql driver, and

Re: [Dbmail-dev] [DBMail 0000338]: The header indication is broken in some MUA. some MUA.

2006-05-03 Thread Matthew Sayler
On Wed, May 03, 2006 at 10:45:56AM -0700, Kevin wrote: > >If only that were legal. Maximum width for varchar is 255. > > Is this a limit of mysql? I don't think pgsql has such a limit, and > oracle might be 2000. Yes. MySQL silently promotes VARCHAR(N) for N>255 to TEXT. Matt

[Dbmail-dev] Re: [DBMail 0000338]: The header indication is broken in some MUA. some MUA.

2006-05-03 Thread Thomas Mueller
Kevin wrote: >> If only that were legal. Maximum width for varchar is 255. > > Is this a limit of mysql? I don't think pgsql has such a limit, and > oracle might be 2000. Pg limit is 1 GB (data, so UTF-8 worst case is 500 MB), Oracle 9i has 4000 Byte. Thomas

Re: [Dbmail-dev] [DBMail 0000338]: The header indication is broken in some MUA. some MUA.

2006-05-03 Thread Kevin
If only that were legal. Maximum width for varchar is 255. Is this a limit of mysql? I don't think pgsql has such a limit, and oracle might be 2000. Kevin

[Dbmail-dev] [DBMail 0000338]: The header indication is broken in some MUA. some MUA.

2006-05-03 Thread bugtrack
A NOTE has been added to this issue. == http://dbmail.org/mantis/view.php?id=338 == Reported By:ryo Assigned To:paul =

RE: [Dbmail-dev] [DBMail 0000338]: The header indication is brokenin some MUA. some MUA.

2006-05-03 Thread Larry Rosenman
Paul J Stevens wrote: > Martin Furter wrote: >> >> Hello >> >> RFC2822 section 2.1.1 "Line Length Limits" specifies a maximum of 998 >> characters per line (excluding trailing CRLF). >> >> So changing the column to VARCHAR(998) seems more appropriate. > > If only that were legal. Maximum width

Re: [Dbmail-dev] [DBMail 0000338]: The header indication is broken in some MUA. some MUA.

2006-05-03 Thread Paul J Stevens
Martin Furter wrote: > > Hello > > RFC2822 section 2.1.1 "Line Length Limits" specifies a maximum of 998 > characters per line (excluding trailing CRLF). > > So changing the column to VARCHAR(998) seems more appropriate. If only that were legal. Maximum width for varchar is 255. -- __

Re: [Dbmail-dev] SHA Passwords?

2006-05-03 Thread Kevin Baker
--- Aaron Stone <[EMAIL PROTECTED]> wrote: > On Tue, 2006-05-02 at 17:29 -0700, Kevin Baker wrote: > > Does DBMail support "SHA" passwords? > > > > My current app uses SHA, but I can switch to MD5 if I > need to. > > SHA is not supported. I'm not sure what would be needed > other than a > GPL-

Re: [Dbmail-dev] SHA Passwords?

2006-05-03 Thread Aaron Stone
On Tue, 2006-05-02 at 17:29 -0700, Kevin Baker wrote: > Does DBMail support "SHA" passwords? > > My current app uses SHA, but I can switch to MD5 if I need to. SHA is not supported. I'm not sure what would be needed other than a GPL-compatible SHA library, though.We'd have to expand the length of

[Dbmail-dev] SHA Passwords?

2006-05-03 Thread Kevin Baker
Does DBMail support "SHA" passwords? My current app uses SHA, but I can switch to MD5 if I need to. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

[Dbmail-dev] dbmail add user sql

2006-05-03 Thread Kevin Baker
So I am writing a small Java api to add / edit /remove / list users in DBMail. I tailed the mysql logs for the inserts. So far it looks like: // INSERT USER INSERT INTO dbmail_users (userid,passwd,client_idnr,maxmail_size,encryption_type, last_login) VALUES ('[userid]','[password]',WHAT IS