Re: [Dbmail] deleted messages included in maxmail total

2002-08-06 Thread Bret Baptist
On Monday 05 August 2002 04:32 pm, Dave Logan wrote: > I think that what Bret is saying (from a technical aspect) > is that the quotacheck shouldn't count messages with a status > of "002" because this means they're deleted. > I agree, but I thought this had been fixed already > davel I am run

[Dbmail] Strange POP behaviour

2002-08-06 Thread Philip Warner
We have about 600 users and for some reason, some of them (less than 10) have certain messages that are continuously sent to them via POP (never deleted). Looking at the database for one such offending message: message_idnr | 3634 mailbox_idnr | 1157 messagesize | 6010 seen_flag | 0 ans

Re: [Dbmail] Strange POP behaviour

2002-08-06 Thread Jeff Brenton
PW> As far as I can tell from the logs, they are only using POP. PW> I'd be interested to know if anyone else has these problems, or has any PW> insight into likely causes. Certain clients (Outlook is a good example) do not delete messages until ALL messages are received, so an error with a late

[Dbmail] unique_id not unique?

2002-08-06 Thread Philip Warner
Further investigations of my undead-pop-message problem has revealed somthing that confuses me: the unique_id field in the messages table is not unique. Should they be? Philip Warner| __---_ Albatross

Re: [Dbmail] unique_id not unique?

2002-08-06 Thread Philip Warner
At 18:05 6/08/2002 +1000, Philip Warner wrote: Further investigations of my undead-pop-message problem has revealed somthing that confuses me: the unique_id field in the messages table is not unique. Should they be? Looking at the code in pipe.c, it uses the current time to build the ID;

Re: [Dbmail] unique_id not unique?

2002-08-06 Thread Blake
I'm no SQL expert, but isn't that what database sequences are for? Philip Warner wrote: At 18:05 6/08/2002 +1000, Philip Warner wrote: Looking at the code in pipe.c, it uses the current time to build the ID; several messages were received within a second of each other - hence the non-unique I

Re: [Dbmail] unique_id not unique?

2002-08-06 Thread
yes they should, what version are you running? In RC3 it can (however, in very seldom cases) happen that the unique_id is not unique. Best regards, Eelco Philip Warner heeft op dinsdag, 6 aug 2002 om 10:05 (Europe/Amsterdam) het volgende geschreven: Further investigations of my undead-po

Re: [Dbmail] unique_id not unique?

2002-08-06 Thread Philip Warner
At 01:36 6/08/2002 -0700, Blake wrote: I'm no SQL expert, but isn't that what database sequences are for? Yes, but the code in pipe.c is at a lower level - I think. One solution would be to use the DB to allocate a number (eg. db_get_unique_id). Or, depending on how pipe.c is used (eg. as lo

Re: [Dbmail] unique_id not unique?

2002-08-06 Thread
No, it is not possible to use a sequence. The unique id field should have a fixed size. But i'm sure Roel fixed this about 2 months ago.. it's weird that the pipe.c in CVS seems not being fixed. I'll look into it. Best regards, Eelco Philip Warner heeft op dinsdag, 6 aug 2002 om 10:56 (Eur

Re: [Dbmail] unique_id not unique?

2002-08-06 Thread Philip Warner
At 11:02 6/08/2002 +0200, Eelco van Beek - IC&S wrote: No, it is not possible to use a sequence. The unique id field should have a fixed size. But i'm sure Roel fixed this about 2 months ago.. it's weird that the pipe.c in CVS seems not being fixed. I'll look into it. Thanks! Do you think

Re: [Dbmail] Strange POP behaviour

2002-08-06 Thread Bret Baptist
I am also seeing this behavour. I am running the CVS from August 15th, 2002. The only solution that I have found is to remove the user then add them back right away. I think the non-unique ids are coming from the uni-one-convertor. All the users that I have seen it on, thier mail was from

Re: [Dbmail] unique_id not unique?

2002-08-06 Thread Bret Baptist
On Tuesday 06 August 2002 04:02 am, Eelco van Beek - IC&S wrote: > No, it is not possible to use a sequence. The unique id field should > have a fixed size. > > But i'm sure Roel fixed this about 2 months ago.. it's weird that the > pipe.c in CVS seems not being fixed. > > I'll look into it. > > Be

Re: [Dbmail] Strange POP behaviour

2002-08-06 Thread Philip Warner
At 08:16 6/08/2002 -0500, Bret Baptist wrote: I am also seeing this behavour. I am running the CVS from August 15th, 2002. The only solution that I have found is to remove the user then add them back right away. You are correct; the conversion was done using the uni-one-converter, and as far

Re: [Dbmail] unique_id not unique?

2002-08-06 Thread Philip Warner
At 08:19 6/08/2002 -0500, Bret Baptist wrote: On Tuesday 06 August 2002 04:02 am, Eelco van Beek - IC&S wrote: > No, it is not possible to use a sequence. The unique id field should > have a fixed size. > > But i'm sure Roel fixed this about 2 months ago.. it's weird that the > pipe.c in CVS seem

[Dbmail] Bad From address information and folder question...

2002-08-06 Thread Craig Coles
I am using IMP as my web-mail MUA and see that the From address is always bad when displaying the list of mail. When the mail message is opened everything seems to be fine. I've included a small pic of the problem. I've set the debug level to 5 and included the section of syslog for the display