Hi Nik,
Thanks for replying.
Fortunatly my new client accepted that he had to use Thunderbird and
that gave me time to investigate and fix the issue.
It turned out that the main issue was with mysql locking, I had not
noticed that clearing out deleted entries was not working so there were
over 46000 messages to purge and then delete and I had to manually do
this in small increments as dbmail-util just errored out, fortunatly it
left the sql in the log so I was comfortable with doing this manually.
Although I had both the [DBMAIL] and [IMAP] TRACE_LEVEL=5 there was no
indication that the error came from the database. As I have been having
difficulty receiving some emails via thunderbird and successful access
via Squirrelmail and Outlook (full version which alas worked well) and
the thunderbird faq's seem to say that the folders need compacting I
thought that the errors may have been due to this rather than dbmail.
It would have been helpful to have had any errors reported in the log,
it would have saved me days of misguided searching.
My guess is that due to the large amount of undeleted items in the
database, each client stressed the server in different ways causing
different results between users and clients.
Alas I had been unable to compile 2.0.4 and also had problems with the
daily snapshots.
On a positive note, I have this morning successfully compiled the
dbmail_2_0_branch from svn and will test this afternoon and intend to
install this weekend if all goes well.
Thanks,
Alan
Nik Lam wrote:
Hi Alan,
I'm replying to a relatively old post, but are you still having trouble
with this? If so, have you been able to try dbmail 2.0.4?
I currently don't have any OE users on my
FBSD5.4/dbmail2.0.4/mysql4.1.11 setup and have had no problems with it,
but I'm insterested in any problems that might occur with this client.
Regards,
Nik
Alan Hicks wrote:
Hi,
I'm having an issue that appeared to start yesterday with all current
users of Outlook Express not able to retrieve any messages. Users of
Outlook Thunderbird and Squirrelmail are unafected.
Outlook Express barfs with the following message:
Header download for the 'Sophos' folder did not complete. Could not
download new messages from the IMAP server. Account:
'mail.haven-green.co.uk', Server: 'mail.haven-green.co.uk', Protocol:
IMAP, Server Response: 'The server did not respond to this IMAP command
before the connection was terminated.', Port: 143, Secure(SSL): No,
Error Number: 0x800C006F
I'm running the latest version dbmail-2.0.3 that compiles on FreeBSD
5.4. The mysql server is 4.1.12.
The mysql server does not appear to have any locks while this is going
on and the server processes have reduced to idle 0%; yes it's a
lightly loaded server at times.
Also the various dbmail-util options show that the data does not
appear to be currupted.
IMAP Tracelevel=5
Jul 26 14:06:30 ligeti dbmail/imap4d[79375]: PerformChildTask():
incoming connection from [212.159.43.244 (alanhicks.plus.com)]
Jul 26 14:06:30 ligeti dbmail/imap4d[79375]: COMMAND: [0isg CAPABILITY]
Jul 26 14:06:30 ligeti dbmail/imap4d[79375]: COMMAND: [i4pu LOGIN
"Username" "Password"]
Jul 26 14:06:30 ligeti dbmail/imap4d[79375]: _ic_login(): user (id:1,
name Username) tries login
Jul 26 14:06:30 ligeti dbmail/imap4d[79375]: _ic_login(): user (id 1,
name Username) login accepted @ 2005-07-26 14:06:30
Jul 26 14:06:30 ligeti dbmail/imap4d[79375]: COMMAND: [xsz7 SELECT
"INBOX"]
Jul 26 14:06:31 ligeti dbmail/imap4d[79375]: dbmysql.c,db_get_result:
result is null
Jul 26 14:06:31 ligeti dbmail/imap4d[79375]: COMMAND: [r5hf UID FETCH
1:* (BODY.PEEK[HEADER.FIELDS (References X-Ref X-Priority
X-MSMail-Priority X-MSOESRec Newsgroups)] ENVELOPE RFC822.SIZE UID FLAGS
INTERNALDATE)]
Jul 26 14:06:31 ligeti dbmail/imap4d[79375]: dbmysql.c,db_free_result:
Trying to free result set that is already NULL!
Jul 26 14:06:31 ligeti dbmail/imap4d[79375]: db_add_mime_children():
unexpected end of data
Jul 26 14:06:31 ligeti dbmail/imap4d[79375]: db_start_msg(): error
adding MIME-children
Jul 26 14:06:31 ligeti dbmail/imap4d[79375]: db_fetch_headers():
succesfully recovered erroneous message 428338
Jul 26 14:09:22 ligeti dbmail/imap4d[79376]: PerformChildTask():
incoming connection from [212.159.43.244 (alanhicks.plus.com)]
Jul 26 14:09:22 ligeti dbmail/imap4d[79376]: COMMAND: [vtk7 CAPABILITY]
Jul 26 14:09:23 ligeti dbmail/imap4d[79376]: COMMAND: [4ycn LOGIN
"Username" "Password"]
Jul 26 14:09:23 ligeti dbmail/imap4d[79376]: _ic_login(): user (id:1,
name Username) tries login
Jul 26 14:09:23 ligeti dbmail/imap4d[79376]: _ic_login(): user (id 1,
name Username) login accepted @ 2005-07-26 14:09:23
Jul 26 14:09:23 ligeti dbmail/imap4d[79376]: COMMAND: [l5e1 STATUS
"INBOX" (MESSAGES UNSEEN)]
Jul 26 14:09:23 ligeti dbmail/imap4d[79376]: COMMAND: [ZZZZ LOGOUT]
Jul 26 14:09:23 ligeti dbmail/imap4d[79376]: _ic_logout(): user (id:1)
logging out @ [2005-07-26 14:09:23]
Jul 26 14:09:23 ligeti dbmail/imap4d[79376]: IMAPClientHandler():
Closing connection for client from IP [212.159.43.244]
Jul 26 14:09:23 ligeti dbmail/imap4d[79381]: PerformChildTask():
incoming connection from [212.159.43.244 (alanhicks.plus.com)]
Jul 26 14:09:23 ligeti dbmail/imap4d[79381]: COMMAND: [rbq1 CAPABILITY]
Jul 26 14:09:23 ligeti dbmail/imap4d[79381]: COMMAND: [bh9f LOGIN
"Username" "Password"]
Jul 26 14:09:23 ligeti dbmail/imap4d[79381]: _ic_login(): user (id:1,
name Username) tries login
Jul 26 14:09:23 ligeti dbmail/imap4d[79381]: _ic_login(): user (id 1,
name Username) login accepted @ 2005-07-26 14:09:23
Jul 26 14:09:23 ligeti dbmail/imap4d[79381]: COMMAND: [naa0 SELECT
"PO/Sophos"]
Jul 26 14:09:23 ligeti dbmail/imap4d[79381]: dbmysql.c,db_get_result:
result is null
Jul 26 14:09:23 ligeti dbmail/imap4d[79381]: COMMAND: [9mzh UID FETCH
1:* (BODY.PEEK[HEADER.FIELDS (References X-Ref X-Priority
X-MSMail-Priority X-MSOESRec Newsgroups)] ENVELOPE RFC822.SIZE UID FLAGS
INTERNALDATE)]
Jul 26 14:09:23 ligeti dbmail/imap4d[79381]: dbmysql.c,db_free_result:
Trying to free result set that is already NULL!
Thanks for any help.
Alan
_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://twister.fastxs.net/mailman/listinfo/dbmail-dev
_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://twister.fastxs.net/mailman/listinfo/dbmail-dev
