Re: [Dbmail] upgrade 1.2 -> 2.x

2003-12-29 Thread Christian G. Warden
On Mon, Dec 29, 2003 at 09:21:41PM +0200, Igor Olemskoi wrote: > How to upgrade 1.2 -> 2.x? > The size of mailboxes in MySQL is 1.7GB. I posted a sql script to upgrade a few months ago. Check the archives, or I can send it to you. I'm not sure if anyone other than myself used it since Ilja relea

Re: [Dbmail] upgrade 1.2 -> 2.x

2003-12-29 Thread Brian Blood
On 12/29/2003 1:21 PM, "Igor Olemskoi" <[EMAIL PROTECTED]> wrote: > How to upgrade 1.2 -> 2.x? > The size of mailboxes in MySQL is 1.7GB. The db structure in 2.x is still a moving target if I'm not mistaken. You might want to wait until at least a beta of 2.x before moving any production dbs to

[Dbmail] upgrade 1.2 -> 2.x

2003-12-29 Thread Igor Olemskoi
Hi, How to upgrade 1.2 -> 2.x? The size of mailboxes in MySQL is 1.7GB. Best regards, Igor.

RE: [Dbmail] internal_date from messages / wrong date

2003-12-29 Thread Matt Dickinson
Networking wrote: > Strange > > Since 2003-12-28 23:59 (using "select internal_date from messages;") > my internal_date field is stamping messages at 2004-12-29!! I've got the same problem too! Matt

[Dbmail] internal_date from messages / wrong date

2003-12-29 Thread Networking
Strange Since 2003-12-28 23:59 (using "select internal_date from messages;") my internal_date field is stamping messages at 2004-12-29!! I didn't notice it on my mozilla client, but my Outlook users are going bonkers. dbmail v1.2.1 / mysql 4.0.14 (using innodb) / gentoo linux --Sample

[Dbmail] Re: dbmail, 8-bit encoding

2003-12-29 Thread Sergey V. Spiridonov
Sergey V. Spiridonov wrote: Dbmail needs to fetch messages, convert them to the encoding of the search string, and then search. This statement is probably wrong. Anyway, the question is still here. Is it good to store messages in original encoding, or is it better to convert all texts to the

[Dbmail] Re: dbmail, 8-bit encoding

2003-12-29 Thread Sergey V. Spiridonov
Micah wrote: dbmail 1.2, with latin1 encoding. Oh, I see. The problem is that unicode does not include all necessary characters. Hopefully latin1 does. I'll give it a try. To dbmail developers: Storing messages in DBMS without converting them to the database encoding is not nice, because it

Re: [Dbmail] Re: dbmail, 8-bit encoding

2003-12-29 Thread Micah
dbmail 1.2, with latin1 encoding. I'm using postfix to inject messages, with the command: dbmail-smtp -d ${recipient} I'm not familiar with the dbmail-smtp command line switches, and just used the -d switch as suggested in the docs. Always worked great. Perhaps someone else can compare to the

[Dbmail] Re: dbmail, 8-bit encoding

2003-12-29 Thread Sergey V. Spiridonov
Micah wrote: If you're referring to your last post, Yes, I was referring to my last post. > I received it, and I use dbmail. What encoding do you use for the database? I use unicode and when I try to insert my message with $ cat | dbmail-smtp -u the message is not inserted, and I got

Re: [Dbmail] Re: dbmail, 8-bit encoding

2003-12-29 Thread Micah
If you're referring to your last post, I received it, and I use dbmail. HTH On Sun December 28 2003 12:24 pm, Sergey V. Spiridonov wrote: > Funny, since dbmail developers also use dbmail for their mailboxes, they > probably did not receive my bug report (it also contains non-UNICODE > character