Mailing List Archive: DBMail: dev

Messages without headers apearing

Index | Next | Previous | View Threaded

mysql.jorge at decimal

Jul 16, 2009, 8:35 AM

Post #1 of 9 (1477 views)
Permalink

Messages without headers apearing

Paul,

I think there's a problem with messages without headers, and may exist
something that is generating them.

First:

Yesterday I had no problematic messages when running "dbmail-util -b", not I
have 49.

Going to fix them by running dbmail-util -by, and will check again in the
end of the day/tomorrow.

And something that is related for sure, in SquirrelMail, I have messages
without headers, check the attach picture.

Messages are not viewable either in msoutlook 2007 or RoundCube.

Check the this image:

http://neotrix.decimal.pt/dbmail/no%20header.jpg

---

lira:~# dbmail-util -b

Choosing dry-run mode. No changes will be made at this time.

Checking DBMAIL for rfcsize field...

Ok. Found [49] missing rfcsize values.

Checking DBMAIL for cached envelopes...

Ok. Found [49] missing envelope values.

Checking DBMAIL for cached header values...

Ok. Found [49] un-cached physmessages.

Maintenance done. Errors were found but not fixed.

Run again with the '-y' option to repair the errors.

lira:~#

ml at kiewel-online

Jul 16, 2009, 9:30 AM

Post #2 of 9 (1400 views)
Permalink

Re: Messages without headers apearing [In reply to]

Jorge,

Jorge Bastos schrieb:
> Paul,
>
> I think there's a problem with messages without headers, and may exist
> something that is generating them.
>
> First:
>
> Yesterday I had no problematic messages when running "dbmail-util --b",
> not I have 49.
>
> Going to fix them by running dbmail-util --by, and will check again in
> the end of the day/tomorrow.
>
>
>
> And something that is related for sure, in SquirrelMail, I have messages
> without headers, check the attach picture.

I have had the same behavior while migrating vom 2.2 to 2.3.6. Jonathen
sent me a sql script for fixing.

Uwe
_______________________________________________
Dbmail-dev mailing list
Dbmail-dev [at] dbmail
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev

mysql.jorge at decimal

Jul 16, 2009, 9:52 AM

Post #3 of 9 (1403 views)
Permalink

Re: Messages without headers apearing [In reply to]

Hum... good!
Can you provide that?
I don't have the emails from Tuesday/Wednesday.

One thing, this is for emails that already existed or for new one's? I think
the problem is only for emails before the migration...am I correct?

Jorge,

> -----Original Message-----
> From: dbmail-dev-bounces [at] dbmail [mailto:dbmail-dev-
> bounces [at] dbmail] On Behalf Of Uwe Kiewel
> Sent: quinta-feira, 16 de Julho de 2009 17:30
> To: DBMAIL Developers Mailinglist
> Subject: Re: [Dbmail-dev] Messages without headers apearing
>
> Jorge,
>
> Jorge Bastos schrieb:
> > Paul,
> >
> > I think there's a problem with messages without headers, and may
> exist
> > something that is generating them.
> >
> > First:
> >
> > Yesterday I had no problematic messages when running "dbmail-util --
> b",
> > not I have 49.
> >
> > Going to fix them by running dbmail-util --by, and will check again
> in
> > the end of the day/tomorrow.
> >
> >
> >
> > And something that is related for sure, in SquirrelMail, I have
> messages
> > without headers, check the attach picture.
>
> I have had the same behavior while migrating vom 2.2 to 2.3.6. Jonathen
> sent me a sql script for fixing.
>
> Uwe
> _______________________________________________
> Dbmail-dev mailing list
> Dbmail-dev [at] dbmail
> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev

_______________________________________________
Dbmail-dev mailing list
Dbmail-dev [at] dbmail
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev

ml at kiewel-online

Jul 16, 2009, 10:21 AM

Post #4 of 9 (1402 views)
Permalink

Re: Messages without headers apearing [In reply to]

Jorge Bastos schrieb:
> Hum... good!
> Can you provide that?

Let me see... but I can't promisse.

> I don't have the emails from Tuesday/Wednesday.
>
> One thing, this is for emails that already existed or for new one's? I think
> the problem is only for emails before the migration...am I correct?

I my case - yes.

Uwe
_______________________________________________
Dbmail-dev mailing list
Dbmail-dev [at] dbmail
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev

ml at kiewel-online

Jul 17, 2009, 4:12 AM

Post #5 of 9 (1388 views)
Permalink

Re: Messages without headers apearing [In reply to]

On Thu, July 16, 2009 7:21 pm, Uwe Kiewel wrote:
> Jorge Bastos schrieb:
>> Hum... good!
>> Can you provide that?
>
> Let me see... but I can't promisse.

Sorry, not found. It's because I have auto-delete enabled in my thundebird
for mails older than 30 days...

Uwe

@Jonathan: Do you have the script/the mail kept in you sent folder?

_______________________________________________
Dbmail-dev mailing list
Dbmail-dev [at] dbmail
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev

mysql.jorge at decimal

Jul 17, 2009, 4:16 AM

Post #6 of 9 (1389 views)
Permalink

Re: Messages without headers apearing [In reply to]

> @Jonathan: Do you have the script/the mail kept in you sent folder?
>
Uwe,
Thanks for the effort!

Jon, can you provide that?

Yesterday I had some problematic messages,
I fixed it by running dbmail-util -by, and today I have more messages again:
What can be creating this problem?

lira:~# dbmail-util -b
Choosing dry-run mode. No changes will be made at this time.

Checking DBMAIL for rfcsize field...
Ok. Found [20] missing rfcsize values.

Checking DBMAIL for cached envelopes...
Ok. Found [20] missing envelope values.

Checking DBMAIL for cached header values...
Ok. Found [20] un-cached physmessages.

Maintenance done. Errors were found but not fixed.
Run again with the '-y' option to repair the errors.
lira:~#

_______________________________________________
Dbmail-dev mailing list
Dbmail-dev [at] dbmail
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev

vulture at netvulture

Jul 17, 2009, 10:32 AM

Post #7 of 9 (1388 views)
Permalink

Re: Messages without headers apearing [In reply to]

Jorge Bastos wrote:
>> @Jonathan: Do you have the script/the mail kept in you sent folder?
>>
>>
I'm not sure what is needed. The script for Uwe was based upon his
current database schema and i'm not sure what version level that script
took him to.

Send me offlist a mysqldump -d of your database, and the version number
of dbmail you are trying to run on it.

-Jon

--
Scanned for viruses and dangerous content by MailScanner

_______________________________________________
Dbmail-dev mailing list
Dbmail-dev [at] dbmail
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev

mysql.jorge at decimal

Jul 17, 2009, 12:15 PM

Post #8 of 9 (1378 views)
Permalink

Re: Messages without headers apearing [In reply to]

> Send me offlist a mysqldump -d of your database, and the version number
> of dbmail you are trying to run on it.

There's an useful info I think, this only happens after I clean up the DB.
The /etc/cron.daily/check_mail script has:
--
#!/bin/bash
/usr/local/sbin/dbmail-util -d -y
/usr/local/sbin/dbmail-util -p -y
/usr/local/sbin/dbmail-util -ty
--

Check below:

lira:~# dbmail-util -b
Choosing dry-run mode. No changes will be made at this time.

Checking DBMAIL for rfcsize field...
Ok. Found [20] missing rfcsize values.

Checking DBMAIL for cached envelopes...
Ok. Found [20] missing envelope values.

Checking DBMAIL for cached header values...
Ok. Found [20] un-cached physmessages.

Maintenance done. Errors were found but not fixed.
Run again with the '-y' option to repair the errors.
lira:~# dbmail-util -by

Repairing DBMAIL for rfcsize field...
Ok. Found [0] missing rfcsize values.
Repairing DBMAIL for cached envelopes...
Ok. Found [0] missing envelope values.
Repairing DBMAIL for cached header values...
Ok. Found [0] un-cached physmessages.
Maintenance done. Errors were found and fixed.
We suggest running dbmail-util again to confirm that all errors were
repaired.
lira:~# dbmail-util -b
Choosing dry-run mode. No changes will be made at this time.

Checking DBMAIL for rfcsize field...
Ok. Found [20] missing rfcsize values.

Checking DBMAIL for cached envelopes...
Ok. Found [20] missing envelope values.

Checking DBMAIL for cached header values...
Ok. Found [20] un-cached physmessages.

Maintenance done. Errors were found but not fixed.
Run again with the '-y' option to repair the errors.
lira:~# /etc/cron.daily/check_mail

Setting DELETE status for deleted messages...
Ok. Messages set for deletion.
Re-calculating used quota for all users...
Ok. Used quota updated for all users.

Maintenance done. No errors found.

Deleting messages with DELETE status...
Ok. Messages deleted.

Maintenance done. No errors found.

Repairing DBMAIL messageblocks integrity...
Ok. Found [0] unconnected messageblks.

Repairing DBMAIL physmessage integrity...
Ok. Found [5489] unconnected physmessagesOk. Orphaned physmessages deleted.

Repairing DBMAIL mimeparts integrity...
Ok. Found [14758] unconnected mimepartsOk. Orphaned mimeparts deleted.

Repairing DBMAIL message integrity...
Ok. Found [0] unconnected messages.

Repairing DBMAIL mailbox integrity...
Ok. Found [0] unconnected mailboxes.

Maintenance done. No errors found.
lira:~# dbmail-util -b
Choosing dry-run mode. No changes will be made at this time.

Checking DBMAIL for rfcsize field...
Ok. Found [13] missing rfcsize values.

Checking DBMAIL for cached envelopes...
Ok. Found [13] missing envelope values.

Checking DBMAIL for cached header values...
Ok. Found [13] un-cached physmessages.

Maintenance done. Errors were found but not fixed.
Run again with the '-y' option to repair the errors.
lira:~#

_______________________________________________
Dbmail-dev mailing list
Dbmail-dev [at] dbmail
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev

mysql.jorge at decimal

Jul 17, 2009, 12:52 PM

Post #9 of 9 (1387 views)
Permalink

Re: Messages without headers apearing [In reply to]

Sorry, I pasted two times the same thing... the correct is:

lira:~# dbmail-util -b
Choosing dry-run mode. No changes will be made at this time.

Checking DBMAIL for rfcsize field...
Ok. Found [20] missing rfcsize values.

Checking DBMAIL for cached envelopes...
Ok. Found [20] missing envelope values.

Checking DBMAIL for cached header values...
Ok. Found [20] un-cached physmessages.

Maintenance done. Errors were found but not fixed.
Run again with the '-y' option to repair the errors.
lira:~# dbmail-util -by

Repairing DBMAIL for rfcsize field...
Ok. Found [0] missing rfcsize values.
Repairing DBMAIL for cached envelopes...
Ok. Found [0] missing envelope values.
Repairing DBMAIL for cached header values...
Ok. Found [0] un-cached physmessages.
Maintenance done. Errors were found and fixed.
We suggest running dbmail-util again to confirm that all errors were
repaired.

lira:~# /etc/cron.daily/check_mail

Setting DELETE status for deleted messages...
Ok. Messages set for deletion.
Re-calculating used quota for all users...
Ok. Used quota updated for all users.

Maintenance done. No errors found.

Deleting messages with DELETE status...
Ok. Messages deleted.

Maintenance done. No errors found.

Repairing DBMAIL messageblocks integrity...
Ok. Found [0] unconnected messageblks.

Repairing DBMAIL physmessage integrity...
Ok. Found [5489] unconnected physmessagesOk. Orphaned physmessages deleted.

Repairing DBMAIL mimeparts integrity...
Ok. Found [14758] unconnected mimepartsOk. Orphaned mimeparts deleted.

Repairing DBMAIL message integrity...
Ok. Found [0] unconnected messages.

Repairing DBMAIL mailbox integrity...
Ok. Found [0] unconnected mailboxes.

Maintenance done. No errors found.
lira:~# dbmail-util -b
Choosing dry-run mode. No changes will be made at this time.

Checking DBMAIL for rfcsize field...
Ok. Found [13] missing rfcsize values.

Checking DBMAIL for cached envelopes...
Ok. Found [13] missing envelope values.

Checking DBMAIL for cached header values...
Ok. Found [13] un-cached physmessages.

Maintenance done. Errors were found but not fixed.
Run again with the '-y' option to repair the errors.
lira:~#

_______________________________________________
Dbmail-dev mailing list
Dbmail-dev [at] dbmail
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads