dbmail-util problem

Ok, maybe I'm doing something wrong, but the help message
isn't helping 
if I am.  When I run dbmail-util against the database I get
the 
following.  Please note that I cannot purge the messages
that have the 
"DELETE" status set.  I need this to work as I'm
preparing to upgrade to 
a more recent version of the application.  I don't want to
migrate the 
database if can be cleaned out first.

rootfenris:/var/lib/mysql# dbmail-util -d
Opening connection to database...
Opening connection to authentication...
Ok. Connected.

Counting messages with DELETE status...
Ok. Found [60426] messages with DELETE status.

Maintenance done. No errors found.
rootfenris:/var/lib/mysql# dbmail-util -p
Opening connection to database...
Opening connection to authentication...
Ok. Connected.

Counting messages with PURGE status...
Ok. Found [0] messages with PURGE status.

Maintenance done. No errors found.

_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

This is a rtfm-faq 

add the -y switch or else dbmail-util will run in dry-run
no-act mode.

Curtis Maurand wrote:
> Ok, maybe I'm doing something wrong, but the help
message isn't helping
> if I am.  When I run dbmail-util against the database I
get the
> following.  Please note that I cannot purge the
messages that have the
> "DELETE" status set.  I need this to work as
I'm preparing to upgrade to
> a more recent version of the application.  I don't want
to migrate the
> database if can be cleaned out first.
> 
> rootfenris:/var/lib/mysql# dbmail-util -d
> Opening connection to database...
> Opening connection to authentication...
> Ok. Connected.
> 
> Counting messages with DELETE status...
> Ok. Found [60426] messages with DELETE status.
> 
> Maintenance done. No errors found.
> rootfenris:/var/lib/mysql# dbmail-util -p
> Opening connection to database...
> Opening connection to authentication...
> Ok. Connected.
> 
> Counting messages with PURGE status...
> Ok. Found [0] messages with PURGE status.
> 
> Maintenance done. No errors found.
> 
> _______________________________________________
> DBmail mailing list
> DBmaildbmail.org
> htt
ps://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
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

curtismaurand.com wrote:
> 
>> This is a rtfm-faq 
>>
>> add the -y switch or else
> dbmail-util will run in dry-run no-act mode.
> 
> yes, well, as you
> read in my post to Aaron when you run the command as:
> 
> dbmail-util -d -y or dbmail-util -p -y it doesn't work.
 It only
> works if you run the command as:

That sounds like a bug to me.

> 
> dbmail-util -dy or dbmail-util
> -py
> 
> And I did read the man page which does not make clear
that
> the flag has to be concatenated with the previous flag
in order to
> work.    The docs read like the -y would be an
automatic
> answer as an automatic "yes" to a
confirmation prompt.  And
> considering that there were 60,000 messages that needed
to be processed, I
> should have been presented with a confirmation prompt
60,000 times if the
> documentation were written properly.

That's an idea. Aaron?

> 
> from the man page
> -y     Perform all proposed actions, "yes to
> all" (synonymous with -r).
> 
> from the help page.
> -y        perform all proposed
> actions, as though yes to all
> 
> The prompts returning from the
> dbmail-util don't make it clear that it would perform
the action if given
> the flag and the flag should work even if its not part
of the first flag
> string like all my other Linux utilities.

I've never been too happy with the whole util setup. I don't
know any tool that
does no-act by default. This is a faq for precisely that
reason.

-- 
 
____________________________________________________________
____
  Paul Stevens                                      paul at
nfg.nl
  NET FACILITIES GROUP                     GPG/PGP:
1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail