Mailing List Archive: DBMail: users

dbmail-util

Index | Next | Previous | View Threaded

mysql.jorge at decimal

Mar 2, 2006, 5:16 PM

Post #1 of 12 (1957 views)
Permalink

dbmail-util

DecimalSorry me again,

I've noticed that the disk space still's the sabe after i deleted about 500 messages via IMAP.
There 500 messages should free up about 3/4 MB, after deleting and purge on the email client, i've runned:
dbmail-util -d -y
+
dbmail-util -p -y

And i still have the sabe space on disk, i was cheking logs if any email just arrived for other user but no.
Am i running dbmail-util fine?

Jorge

lnunez at enelserver

Mar 2, 2006, 5:20 PM

Post #2 of 12 (1889 views)
Permalink

Re: dbmail-util [In reply to]

Jorge Bastos wrote:
> Sorry me again,
>
> I've noticed that the disk space still's the sabe after i deleted
> about 500 messages via IMAP.
> There 500 messages should free up about 3/4 MB, after deleting and
> purge on the email client, i've runned:
> dbmail-util -d -y
> +
> dbmail-util -p -y
>
>
> And i still have the sabe space on disk, i was cheking logs if any
> email just arrived for other user but no.
> Am i running dbmail-util fine?
>
>
> Jorge
> ------------------------------------------------------------------------
>
> _______________________________________________
> Dbmail mailing list
> Dbmail[at]dbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
and ... the database is ???

Leonel

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

mysql.jorge at decimal

Mar 2, 2006, 5:46 PM

Post #3 of 12 (1885 views)
Permalink

Re: dbmail-util [In reply to]

MySQL

----- Original Message -----
From: "Leonel Nunez" <lnunez[at]enelserver.com>
To: "DBMail mailinglist" <dbmail[at]dbmail.org>
Sent: Friday, March 03, 2006 1:20 AM
Subject: Re: [Dbmail] dbmail-util

> Jorge Bastos wrote:
>> Sorry me again,
>>
>> I've noticed that the disk space still's the sabe after i deleted
>> about 500 messages via IMAP.
>> There 500 messages should free up about 3/4 MB, after deleting and
>> purge on the email client, i've runned:
>> dbmail-util -d -y
>> +
>> dbmail-util -p -y
>>
>>
>> And i still have the sabe space on disk, i was cheking logs if any
>> email just arrived for other user but no.
>> Am i running dbmail-util fine?
>>
>>
>> Jorge
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> Dbmail mailing list
>> Dbmail[at]dbmail.org
>> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>>
> and ... the database is ???
>
>
>
> Leonel
>
> _______________________________________________
> Dbmail mailing list
> Dbmail[at]dbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>

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

lnunez at enelserver

Mar 2, 2006, 5:54 PM

Post #4 of 12 (1885 views)
Permalink

Re: dbmail-util [In reply to]

Jorge Bastos wrote:
> MySQL
>
>
>

Sorry ..
I could put on the other mail that PostgreSQL needs vacuum to free
space
but MySQL I don't use it
sorry again

leonel

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

mike at mobrien

Mar 2, 2006, 7:58 PM

Post #5 of 12 (1882 views)
Permalink

dbmail-util [In reply to]

>re: "...after i deleted about 500 messages via IMAP..."

Hey Jorge:
Short Version: Run the util 3x.

Long Version:
For mail where deleted_flag=1 It's one, two three gone. Like this.
/usr/local/sbin/dbmail-util -a -y (result: status 2)
/usr/local/sbin/dbmail-util -a -y (result: status 3)
/usr/local/sbin/dbmail-util -a -y (result: "deleted, gone, bye bye")

best...
Mike

----- Original Message -----
From: "Jorge Bastos" <mysql.jorge[at]decimal.pt>
To: "DBMail mailinglist" <dbmail[at]dbmail.org>
Sent: Thursday, March 02, 2006 8:46 PM
Subject: Re: [Dbmail] dbmail-util

> MySQL
>
>
>
> ----- Original Message -----
> From: "Leonel Nunez" <lnunez[at]enelserver.com>
> To: "DBMail mailinglist" <dbmail[at]dbmail.org>
> Sent: Friday, March 03, 2006 1:20 AM
> Subject: Re: [Dbmail] dbmail-util
>
>
>> Jorge Bastos wrote:
>>> Sorry me again,
>>> I've noticed that the disk space still's the sabe after i deleted about
>>> 500 messages via IMAP.
>>> There 500 messages should free up about 3/4 MB, after deleting and purge
>>> on the email client, i've runned:
>>> dbmail-util -d -y
>>> +
>>> dbmail-util -p -y
>>> And i still have the sabe space on disk, i was cheking logs if any
>>> email just arrived for other user but no.
>>> Am i running dbmail-util fine?
>>> Jorge
>>> ------------------------------------------------------------------------
>>>
>>> _______________________________________________
>>> Dbmail mailing list
>>> Dbmail[at]dbmail.org
>>> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>>>
>> and ... the database is ???
>>
>>
>>
>> Leonel
>>
>> _______________________________________________
>> Dbmail mailing list
>> Dbmail[at]dbmail.org
>> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>>
>
> _______________________________________________
> Dbmail mailing list
> Dbmail[at]dbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>

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

myzamri at gmail

Mar 2, 2006, 8:52 PM

Post #6 of 12 (1893 views)
Permalink

Re: dbmail-util [In reply to]

On 3/3/06, M. J. [Mike] OBrien <mike[at]mobrien.com> wrote:
>
> >re: "...after i deleted about 500 messages via IMAP..."
>
> Hey Jorge:
> Short Version: Run the util 3x.
>
> Long Version:
> For mail where deleted_flag=1 It's one, two three gone. Like this.
> /usr/local/sbin/dbmail-util -a -y (result: status 2)
> /usr/local/sbin/dbmail-util -a -y (result: status 3)
> /usr/local/sbin/dbmail-util -a -y (result: "deleted, gone, bye bye")

Oh well. I never knew this. I should make a script to loop it three times.
:)

cheers,
~zamri

best...
> Mike
>
>
>
>
>
>
> ----- Original Message -----
> From: "Jorge Bastos" <mysql.jorge[at]decimal.pt>
> To: "DBMail mailinglist" <dbmail[at]dbmail.org>
> Sent: Thursday, March 02, 2006 8:46 PM
> Subject: Re: [Dbmail] dbmail-util
>
>
> > MySQL
> >
> >
> >
> > ----- Original Message -----
> > From: "Leonel Nunez" <lnunez[at]enelserver.com>
> > To: "DBMail mailinglist" <dbmail[at]dbmail.org>
> > Sent: Friday, March 03, 2006 1:20 AM
> > Subject: Re: [Dbmail] dbmail-util
> >
> >
> >> Jorge Bastos wrote:
> >>> Sorry me again,
> >>> I've noticed that the disk space still's the sabe after i deleted
> about
> >>> 500 messages via IMAP.
> >>> There 500 messages should free up about 3/4 MB, after deleting and
> purge
> >>> on the email client, i've runned:
> >>> dbmail-util -d -y
> >>> +
> >>> dbmail-util -p -y
> >>> And i still have the sabe space on disk, i was cheking logs if any
> >>> email just arrived for other user but no.
> >>> Am i running dbmail-util fine?
> >>> Jorge
> >>>
> ------------------------------------------------------------------------
> >>>
> >>> _______________________________________________
> >>> Dbmail mailing list
> >>> Dbmail[at]dbmail.org
> >>> https://mailman.fastxs.nl/mailman/listinfo/dbmail
> >>>
> >> and ... the database is ???
> >>
> >>
> >>
> >> Leonel
> >>
> >> _______________________________________________
> >> Dbmail mailing list
> >> Dbmail[at]dbmail.org
> >> https://mailman.fastxs.nl/mailman/listinfo/dbmail
> >>
> >
> > _______________________________________________
> > Dbmail mailing list
> > Dbmail[at]dbmail.org
> > https://mailman.fastxs.nl/mailman/listinfo/dbmail
> >
>
> _______________________________________________
> Dbmail mailing list
> Dbmail[at]dbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>

jesse at kci

Mar 3, 2006, 9:01 AM

Post #7 of 12 (1892 views)
Permalink

Re: dbmail-util [In reply to]

> For mail where deleted_flag=1 It's one, two three gone. Like this.
> /usr/local/sbin/dbmail-util -a -y (result: status 2)
> /usr/local/sbin/dbmail-util -a -y (result: status 3)
> /usr/local/sbin/dbmail-util -a -y (result: "deleted, gone, bye
> bye")

dbmail-util doesn't change mail that's status 1 to status 2, that's what
happens when your pop3 client DELEtes a message or imap EXPUNGEs. Once
a message is already status 2, dbmail-util will roll it to status 3 in
one run and actually delete it out on the next.

> Oh well. I never knew this. I should make a script to loop it three
> times. :)

Usually just run it nightly, and it'll delete the previous day's mail,
while changing all the status 2 from today to status 3 (thereby giving
you a recovery window if it's really important to un-delete a message).

--
Jesse Norell - jesse[at]kci.net
Kentec Communications, Inc.

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

mysql.jorge at decimal

Mar 3, 2006, 9:10 AM

Post #8 of 12 (1888 views)
Permalink

Re: dbmail-util [In reply to]

Hum..
Is there any problem to do this with the imapd+pop3d running?

----- Original Message -----
From: "Jesse Norell" <jesse[at]kci.net>
To: "DBMail mailinglist" <dbmail[at]dbmail.org>
Sent: Friday, March 03, 2006 5:01 PM
Subject: Re: [Dbmail] dbmail-util

>
>> For mail where deleted_flag=1 It's one, two three gone. Like this.
>> /usr/local/sbin/dbmail-util -a -y (result: status 2)
>> /usr/local/sbin/dbmail-util -a -y (result: status 3)
>> /usr/local/sbin/dbmail-util -a -y (result: "deleted, gone, bye
>> bye")
>
> dbmail-util doesn't change mail that's status 1 to status 2, that's what
> happens when your pop3 client DELEtes a message or imap EXPUNGEs. Once
> a message is already status 2, dbmail-util will roll it to status 3 in
> one run and actually delete it out on the next.
>
>> Oh well. I never knew this. I should make a script to loop it three
>> times. :)
>
> Usually just run it nightly, and it'll delete the previous day's mail,
> while changing all the status 2 from today to status 3 (thereby giving
> you a recovery window if it's really important to un-delete a message).
>
>
>
> --
> Jesse Norell - jesse[at]kci.net
> Kentec Communications, Inc.
>
> _______________________________________________
> Dbmail mailing list
> Dbmail[at]dbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>

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

jesse at kci

Mar 3, 2006, 9:20 AM

Post #9 of 12 (1885 views)
Permalink

Re: dbmail-util [In reply to]

On Fri, 2006-03-03 at 17:10 +0000, Jorge Bastos wrote:
> Hum..
> Is there any problem to do this with the imapd+pop3d running?

No, none at all. An rdbms backend makes that sort of thing very
simple/straightforward. Usually if you have very much mail coming
in/out a day you schedule dbmail-util to be in off-hours so the disk
activity doesn't affect many users, but on small sites that's probably
not even a necessary consideration.

> ----- Original Message -----
> From: "Jesse Norell" <jesse[at]kci.net>
> To: "DBMail mailinglist" <dbmail[at]dbmail.org>
> Sent: Friday, March 03, 2006 5:01 PM
> Subject: Re: [Dbmail] dbmail-util
>
>
> >
> >> For mail where deleted_flag=1 It's one, two three gone. Like this.
> >> /usr/local/sbin/dbmail-util -a -y (result: status 2)
> >> /usr/local/sbin/dbmail-util -a -y (result: status 3)
> >> /usr/local/sbin/dbmail-util -a -y (result: "deleted, gone, bye
> >> bye")
> >
> > dbmail-util doesn't change mail that's status 1 to status 2, that's what
> > happens when your pop3 client DELEtes a message or imap EXPUNGEs. Once
> > a message is already status 2, dbmail-util will roll it to status 3 in
> > one run and actually delete it out on the next.
> >
> >> Oh well. I never knew this. I should make a script to loop it three
> >> times. :)
> >
> > Usually just run it nightly, and it'll delete the previous day's mail,
> > while changing all the status 2 from today to status 3 (thereby giving
> > you a recovery window if it's really important to un-delete a message).
> >
> >
> >
> > --
> > Jesse Norell - jesse[at]kci.net
> > Kentec Communications, Inc.
> >
> > _______________________________________________
> > Dbmail mailing list
> > Dbmail[at]dbmail.org
> > https://mailman.fastxs.nl/mailman/listinfo/dbmail
> >
>
> _______________________________________________
> Dbmail mailing list
> Dbmail[at]dbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
--
Jesse Norell - jesse[at]kci.net
Kentec Communications, Inc.

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

mike at mobrien

Mar 3, 2006, 1:45 PM

Post #10 of 12 (1873 views)
Permalink

Re: dbmail-util [In reply to]

However marked to dbmail_messages.deleted_flag 1; dbmail_messages.status
2 -- and there are many possibilities for databases evolving thru from
DBMail version 1.2.11 thru 2.0.3 and 2.0.9 -- dbmail-util.8 All messages
that are set for deletion will be marked for final deletion (status 3). All
message that are marked for final deletion will be cleared from the
database. The integrity check will check for unconnected messageblocks,
unconnected messages and unconnected mailboxes.

The point is that the utility does not delete the messages in one swoop

which explains why the original poster has " 500 messages deleteed via
IMAP... after " i've runned dbmail-util -d -y [sic] "\

best...
Mike

----- Original Message -----
From: "Jesse Norell" <jesse[at]kci.net>
To: "DBMail mailinglist" <dbmail[at]dbmail.org>
Sent: Friday, March 03, 2006 12:01 PM
Subject: Re: [Dbmail] dbmail-util

>
>> For mail where deleted_flag=1 It's one, two three gone. Like this.
>> /usr/local/sbin/dbmail-util -a -y (result: status 2)
>> /usr/local/sbin/dbmail-util -a -y (result: status 3)
>> /usr/local/sbin/dbmail-util -a -y (result: "deleted, gone, bye
>> bye")
>
> dbmail-util doesn't change mail that's status 1 to status 2, that's what
> happens when your pop3 client DELEtes a message or imap EXPUNGEs. Once
> a message is already status 2, dbmail-util will roll it to status 3 in
> one run and actually delete it out on the next.
>
>> Oh well. I never knew this. I should make a script to loop it three
>> times. :)
>
> Usually just run it nightly, and it'll delete the previous day's mail,
> while changing all the status 2 from today to status 3 (thereby giving
> you a recovery window if it's really important to un-delete a message).
>
>
>
> --
> Jesse Norell - jesse[at]kci.net
> Kentec Communications, Inc.
>
> _______________________________________________
> Dbmail mailing list
> Dbmail[at]dbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>

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

ml at kiewel-online

Jan 20, 2009, 1:09 AM

Post #11 of 12 (974 views)
Permalink

Re: dbmail-util [In reply to]

The 7crewz wrote:
> Hello to all,
> What is the best time to run dbmail-util ?

At that time, you expect the lowest load at your server.

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

fxp at corp

Jan 20, 2009, 1:10 AM

Post #12 of 12 (970 views)
Permalink

Re: dbmail-util [In reply to]

When system doesn`t keep high load, 4:30 a.m. for example.
Use cron, Luke.

The 7crewz пишет:
> Hello to all,
> What is the best time to run dbmail-util ?
> Sent from 7crewz BlackBerry® wireless device via Vodafone-Celcom Mobile.
> ------------------------------------------------------------------------
>
> _______________________________________________
> DBmail mailing list
> DBmail[at]dbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>

--
С уважением,
Юртайкин Андрей
системный администратор,
ЗАО "ИСКРАТЕЛЕКОМ"
тел.: +7 495 287 45 45, доб. 070
fxp[at]corp.iskratelecom.ru, http://www.iskratelecom.ru

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

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact lists@gossamer-threads.com