Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: DBMail: users

Data corruption when moving/copying messages to DBMail mailboxes

 

 

DBMail users RSS feed   Index | Next | Previous | View Threaded


miles at atmos

May 11, 2008, 4:52 AM

Post #1 of 5 (62 views)
Permalink
Data corruption when moving/copying messages to DBMail mailboxes

Hi folks,

When I copy messages from Thunderbird mbox-folders to the IMAP folders in
DBMail, the first messages are copied OK, but after a few messages, the messages
in the destination folder get corrupted, losing everything, and the date is set
to the current date and time. Headers disappear, the body consists of a few
characters, attachments are not copied, etc. In short, a complete catastrophy.

Another peculiarity is, that DBMail IMAP seems to forget that I have logged in
after a while, requiring password repeatedly.

I have set up a DBMail server thus:

DBMail 2.2.10 with dbmail-imapd and MySQL (5.0.51b) backend, my-medium.cnf,
using InnoDB.

OS: Slackware 12.1

MySQL-configuration after dbmal.conf

Best regards,

Peter Milesson


dbmail.conf

[DBMAIL]
driver = mysql
authdriver = sql
host = localhost
sqlport =
sqlsocket = /var/run/mysql/mysql.sock
user = dbmail
pass = <mypassword>
db = dbmail
table_prefix = dbmail_
encoding = utf8
default_msg_encoding = utf8
#postmaster = DBMAIL-MAILER
sendmail = /usr/sbin/sendmail
TRACE_SYSLOG = 3
TRACE_STDERR = 1
EFFECTIVE_USER = nobody
EFFECTIVE_GROUP = nogroup
BINDIP = *
NCHILDREN = 2
MAXCHILDREN = 10
MINSPARECHILDREN = 2
MAXSPARECHILDREN = 4
MAXCONNECTS = 10000
MAX_ERRORS = 500
TIMEOUT = 300
login_timeout = 60
RESOLVE_IP = no
logfile = /var/log/dbmail.log
errorlog = /var/log/dbmail.err
pid_directory = /var/run
state_directory = /var/run
#library_directory = /usr/lib/dbmail

[SMTP]

[LMTP]
PORT = 24

[POP]
PORT = 110
POP_BEFORE_SMTP = no

[IMAP]
PORT = 143
TIMEOUT = 4000
IMAP_BEFORE_SMTP = no
# idle_timeout = 30
# capability = IMAP4 IMAP4rev1 AUTH=LOGIN ACL NAMESPACE CHILDREN SORT QUOTA
THREAD=ORDEREDSUBJECT UNSELECT IDLE

[SIEVE]
PORT = 2000

[LDAP]
[DELIVERY]
SIEVE = yes
SUBADDRESS = yes
SIEVE_VACATION = yes
SIEVE_NOTIFY = yes
SIEVE_DEBUG = no
AUTO_NOTIFY = no
AUTO_REPLY = no
#AUTO_NOTIFY_SUBJECT =
#AUTO_NOTIFY_SENDER =
suppress_duplicates = yes
# end of configuration file




MySQL-configuration is this for the DBMail database:

Connection id: 14
Current database: dbmail
Current user: root[at]localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.0.51b-log Source distribution
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: utf8
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: /var/run/mysql/mysql.sock
Uptime: 39 min 45 sec


_______________________________________________
DBmail mailing list
DBmail[at]dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail


paul at nfg

May 11, 2008, 12:36 PM

Post #2 of 5 (55 views)
Permalink
Re: Data corruption when moving/copying messages to DBMail mailboxes [In reply to]

Peter,

Please file seperate bugreports for both issues in the tracker - with
level=5 logs if possible. They help a lot in tracking down problems, and
show that you care to have it fixed.

Your config looks ok, btw.

thanks,

Peter Milesson wrote:
> Hi folks,
>
> When I copy messages from Thunderbird mbox-folders to the IMAP folders in
> DBMail, the first messages are copied OK, but after a few messages, the messages
> in the destination folder get corrupted, losing everything, and the date is set
> to the current date and time. Headers disappear, the body consists of a few
> characters, attachments are not copied, etc. In short, a complete catastrophy.
>
> Another peculiarity is, that DBMail IMAP seems to forget that I have logged in
> after a while, requiring password repeatedly.
>
> I have set up a DBMail server thus:
>
> DBMail 2.2.10 with dbmail-imapd and MySQL (5.0.51b) backend, my-medium.cnf,
> using InnoDB.
>
> OS: Slackware 12.1
>
> MySQL-configuration after dbmal.conf
>
> Best regards,
>
> Peter Milesson
>
>
> dbmail.conf
>
> [DBMAIL]
> driver = mysql
> authdriver = sql
> host = localhost
> sqlport =
> sqlsocket = /var/run/mysql/mysql.sock
> user = dbmail
> pass = <mypassword>
> db = dbmail
> table_prefix = dbmail_
> encoding = utf8
> default_msg_encoding = utf8
> #postmaster = DBMAIL-MAILER
> sendmail = /usr/sbin/sendmail
> TRACE_SYSLOG = 3
> TRACE_STDERR = 1
> EFFECTIVE_USER = nobody
> EFFECTIVE_GROUP = nogroup
> BINDIP = *
> NCHILDREN = 2
> MAXCHILDREN = 10
> MINSPARECHILDREN = 2
> MAXSPARECHILDREN = 4
> MAXCONNECTS = 10000
> MAX_ERRORS = 500
> TIMEOUT = 300
> login_timeout = 60
> RESOLVE_IP = no
> logfile = /var/log/dbmail.log
> errorlog = /var/log/dbmail.err
> pid_directory = /var/run
> state_directory = /var/run
> #library_directory = /usr/lib/dbmail
>
> [SMTP]
>
> [LMTP]
> PORT = 24
>
> [POP]
> PORT = 110
> POP_BEFORE_SMTP = no
>
> [IMAP]
> PORT = 143
> TIMEOUT = 4000
> IMAP_BEFORE_SMTP = no
> # idle_timeout = 30
> # capability = IMAP4 IMAP4rev1 AUTH=LOGIN ACL NAMESPACE CHILDREN SORT QUOTA
> THREAD=ORDEREDSUBJECT UNSELECT IDLE
>
> [SIEVE]
> PORT = 2000
>
> [LDAP]
> [DELIVERY]
> SIEVE = yes
> SUBADDRESS = yes
> SIEVE_VACATION = yes
> SIEVE_NOTIFY = yes
> SIEVE_DEBUG = no
> AUTO_NOTIFY = no
> AUTO_REPLY = no
> #AUTO_NOTIFY_SUBJECT =
> #AUTO_NOTIFY_SENDER =
> suppress_duplicates = yes
> # end of configuration file
>
>
>
>
> MySQL-configuration is this for the DBMail database:
>
> Connection id: 14
> Current database: dbmail
> Current user: root[at]localhost
> SSL: Not in use
> Current pager: stdout
> Using outfile: ''
> Using delimiter: ;
> Server version: 5.0.51b-log Source distribution
> Protocol version: 10
> Connection: Localhost via UNIX socket
> Server characterset: latin1
> Db characterset: utf8
> Client characterset: latin1
> Conn. characterset: latin1
> UNIX socket: /var/run/mysql/mysql.sock
> Uptime: 39 min 45 sec
>
>
> _______________________________________________
> DBmail mailing list
> DBmail[at]dbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>


--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
DBmail[at]dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail


miles at atmos

May 11, 2008, 1:58 PM

Post #3 of 5 (55 views)
Permalink
Re: Data corruption when moving/copying messages to DBMail mailboxes [In reply to]

Paul J Stevens <paul <at> nfg.nl> writes:

>
> Peter,
>
> Please file seperate bugreports for both issues in the tracker - with
> level=5 logs if possible. They help a lot in tracking down problems, and
> show that you care to have it fixed.
>
> Your config looks ok, btw.
>
> thanks,
>
> Peter Milesson wrote:

Hi Paul,

Ok, I'll manage to do that in a couple of days (pretty busy right now). I have
seen this issue in another place when I googled around, but that was before it
hit myself. I'm not sure I can repeat the connection loss (only Windows XP),
but the corruption is there 100%. I have tried two different computers as
clients, one with Czech Windows XP Pro, and one with Czech Windows 2000 Pro.
Both had Thunderbird 2.0.0.14 Czech installed. It seems to me that there is
a buffer overflow lurking somewhere, as this doesn't happen when you move/copy
messages one by one.

Thanks for your interest,

Peter


_______________________________________________
DBmail mailing list
DBmail[at]dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail


paul at nfg

May 12, 2008, 2:11 AM

Post #4 of 5 (49 views)
Permalink
Re: Re: Data corruption when moving/copying messages to DBMail mailboxes [In reply to]

Peter,

I see you filed the bug reports. But why are you filing them both twice?

Peter Milesson wrote:
> Paul J Stevens <paul <at> nfg.nl> writes:
>
>> Peter,
>>
>> Please file seperate bugreports for both issues in the tracker - with
>> level=5 logs if possible. They help a lot in tracking down problems, and
>> show that you care to have it fixed.
>>
>> Your config looks ok, btw.
>>
>> thanks,
>>
>> Peter Milesson wrote:
>
> Hi Paul,
>
> Ok, I'll manage to do that in a couple of days (pretty busy right now). I have
> seen this issue in another place when I googled around, but that was before it
> hit myself. I'm not sure I can repeat the connection loss (only Windows XP),
> but the corruption is there 100%. I have tried two different computers as
> clients, one with Czech Windows XP Pro, and one with Czech Windows 2000 Pro.
> Both had Thunderbird 2.0.0.14 Czech installed. It seems to me that there is
> a buffer overflow lurking somewhere, as this doesn't happen when you move/copy
> messages one by one.
>
> Thanks for your interest,
>
> Peter
>
>
> _______________________________________________
> DBmail mailing list
> DBmail[at]dbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>


--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
DBmail[at]dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail


miles at atmos

May 12, 2008, 7:03 AM

Post #5 of 5 (44 views)
Permalink
Re: Data corruption when moving/copying messages to DBMail mailboxes [In reply to]

Paul J Stevens <paul <at> nfg.nl> writes:

>
>
> Peter,
>
> I see you filed the bug reports. But why are you filing them both twice?
>
> Peter Milesson wrote:

Hi Paul,

I'm sorry, but for both reports Firefox got stuck and nothing at all happened
for several minutes. I also had got a subconscious feeling that Thunderbird was
at fault regarding the problems with DBMail. I have scanned the Mozilla
Bugzilla, and there seems to be lot's of quite serious bugs concerning the IMAP
interface, though they tend to keep them dangling...

BTW, the two, three latest versions of both Thunderbird and Firefox seem to be
quite a bit more unstable than previously.

Thank you for your help,

Peter


_______________________________________________
DBmail mailing list
DBmail[at]dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail

DBMail users RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact lists@gossamer-threads.com
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.