Mailing List Archive: DBMail: users

Re: Unable to delete folders (v. 2.3.5)

Index | Next | Previous | View Threaded

paul at nfg

Jan 9, 2009, 10:12 AM

Post #1 of 12 (1691 views)
Permalink

Re: Unable to delete folders (v. 2.3.5)

My BSD wrote:

> <http://www.gossamer-threads.com/lists/dbmail/users/24424>
>
> "Problem is she is not /deleting/ the folder, but renaming it. Revoking
> permission to rename folders will have all kinds of unwanted side-effects."
>
> I'm wondering if it may be a database permissions problem?
>
> All ideas and replies are gratefully welcomed.

Iirc, that response was about preventing users from deleting mailboxes
*and* preventing them from renaming mailboxes as well.

Whether and if that applies to your situation is impossible to tell just
from the error messages: the imap command(s) that triggers them at the
very least would be needed.

--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
DBmail [at] dbmail
https://mailman.fastxs.nl/mailman/listinfo/dbmail

paul at nfg

Jan 9, 2009, 2:43 PM

Post #2 of 12 (1604 views)
Permalink

Re: Unable to delete folders (v. 2.3.5) [In reply to]

My BSD wrote:
> On Fri, 09 Jan 2009 19:12:12 +0100
> Paul J Stevens <paul [at] nfg> wrote:
>
> ... <snip> ...
>> Whether and if that applies to your situation is impossible to tell just
>> from the error messages: the imap command(s) that triggers them at the
>> very least would be needed.
>>
>>
>
> Thank you Paul.
>
>>From a telnet Session:
> ---------------------------------------
> 05 DELETE "Rex/ZTrash"
> 05 NO DELETE failed
> ---------------------------------------
>
> Corresponding DBMail log entry:
> --------------------------------------------------------------------------------------------------
> Jan 9 16:07:01 okra dbmail/imap4d[18297]: [0x288671f0] Error:
> [db] db_get_mailbox_size(+1777): SQLException:
> --------------------------------------------------------------------------------------------------
>
> I also tried:
> --------------------------------------------------
> 06 DELETE "INBOX/Rex/ZTrash"
> 06 NO mailbox doesn't exists
> --------------------------------------------------

Both look ok to me in themselves. The log entry should probably be a
warning or info message, rather than error, but that's cosmetic.

The question remains: is there such a box or not? You're still way to
sparse with details here. Generally a level=511 trace will be helpful,

--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
DBmail [at] dbmail
https://mailman.fastxs.nl/mailman/listinfo/dbmail

michael.monnerie at is

Jan 11, 2009, 3:57 AM

Post #3 of 12 (1605 views)
Permalink

Re: Unable to delete folders (v. 2.3.5) [In reply to]

On Freitag 09 Januar 2009 My BSD wrote:
> All folders were copied in all four accounts, including some folders
> that were empty and had been forgotten and not used for years.
>
> When the unwanted folders are deleted, KMail sometimes complains that
> it can't be done but appears to do it anyway (Thunderbird never
> complains), however, the next time KMail or TB are invoked the
> deleted folders are back (some times unsubscribed).

Maybe something is wrong, did you try "dbmail-util -ay" to cleanup? If
that doesn't remove anything, at least you know in dbmail everything is
correct.

mfg zmi
--
// Michael Monnerie, Ing.BSc ----- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import"
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4
// Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4

Attachments:

signature.asc (0.19 KB)

mysql.jorge at decimal

Jan 11, 2009, 4:02 AM

Post #4 of 12 (1605 views)
Permalink

RE: Unable to delete folders (v. 2.3.5) [In reply to]

> > When the unwanted folders are deleted, KMail sometimes complains that
> > it can't be done but appears to do it anyway (Thunderbird never
> > complains), however, the next time KMail or TB are invoked the
> deleted
> > folders are back (some times unsubscribed).
>
> Maybe something is wrong, did you try "dbmail-util -ay" to cleanup? If
> that doesn't remove anything, at least you know in dbmail everything is
> correct.
>

Looking at dbmail-util, in last git the dbmail-util still doesn't delete all
data does it Paul?

http://dbmail.org/mantis/view.php?id=720

in the bug you assign it to 2.3.5 but in GIT I didn't saw any change to
dbmail-util.c.

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

paul at nfg

Jan 11, 2009, 1:11 PM

Post #5 of 12 (1600 views)
Permalink

Re: Unable to delete folders (v. 2.3.5) [In reply to]

My BSD wrote:
> On Fri, 09 Jan 2009 23:43:30 +0100
> Paul J Stevens <paul [at] nfg> wrote:
>
> ... <snip> ...
>> Both look ok to me in themselves. The log entry should probably be a
>> warning or info message, rather than error, but that's cosmetic.
>>
>> The question remains: is there such a box or not? You're still way to
>> sparse with details here. Generally a level=511 trace will be helpful,
>>
>
> Thank you again Paul.
>
> The folder "Rex/ZTrash" exists.
>
> Not sure what a "level=511 trace" is.

in dbmail.conf(5) set:

#
# Logging via stderr/log file and syslog
#
# Logging is broken up into 8 logging levels and each level can be
indivually turned on or off.
# The Stderr/log file logs all entries to stderr or the log file.
# Syslog logging uses the facility mail and the logging level of the
event for logging.
# Syslog can then be configured to log data according to the levels.
#
# Set the log level to the sum of the values next to the levels you want
to record.
# 1 = Emergency
# 2 = Alert
# 4 = Critical
# 8 = Error
# 16 = Warning
# 32 = Notice
# 64 = Info
# 128 = Debug
# 256 = Database -> Logs at debug level
#
# Examples: 0 = Nothing
# 31 = Emergency + Alert + Critical + Error + Warning
# 511 = Everything
#
FILE_LOGGING_LEVELS = 7
#
SYSLOG_LOGGING_LEVELS = 31

--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
DBmail [at] dbmail
https://mailman.fastxs.nl/mailman/listinfo/dbmail

paul at nfg

Jan 11, 2009, 1:17 PM

Post #6 of 12 (1598 views)
Permalink

Re: Unable to delete folders (v. 2.3.5) [In reply to]

Jorge Bastos wrote:
> Looking at dbmail-util, in last git the dbmail-util still doesn't delete all
> data does it Paul?
>
> http://dbmail.org/mantis/view.php?id=720
>
> in the bug you assign it to 2.3.5 but in GIT I didn't saw any change to
> dbmail-util.c.

That's a very minor bug, in my opinion. And highly unlikely to be
related to My's problem with simply deleting empty folders.

--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
DBmail [at] dbmail
https://mailman.fastxs.nl/mailman/listinfo/dbmail

paul at nfg

Jan 11, 2009, 1:22 PM

Post #7 of 12 (1601 views)
Permalink

Re: Unable to delete folders (v. 2.3.5) [In reply to]

My BSD wrote:
> On Sun, 11 Jan 2009 09:23:09 -0500
> My BSD <MyBSD [at] comcast> wrote:
>
>> ... <snip> ...
>
> One more piece to the puzzle:
>
> Created a MySQL database and was able to delete folders without incident.
>
> It then seems that the problem has to do with the Postgresql database?

Ok, that's very useful. I'll run my own tests against 2.3.5. My main
development has lingered on mysql too long. I'll switch to postgresql
and sqlite again and keep you posted.

In general, if you can provide a FILE_LOGGING_LEVELS=511 logfile that
would provide us with steps-to-reproduce, any problem you encounter will
be easier to track down and fix.

--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
DBmail [at] dbmail
https://mailman.fastxs.nl/mailman/listinfo/dbmail

mysql.jorge at decimal

Jan 11, 2009, 1:23 PM

Post #8 of 12 (1602 views)
Permalink

RE: Unable to delete folders (v. 2.3.5) [In reply to]

Yes Paul, nothing related.
Well the problem is that, the server may get full, unless a script is
running with the SQL code to delete what is not being deleted by
dbmail-util.

In my case, I was about getting out of space when I noticed that dbmail-util
wasn't deleting everything.

> -----Original Message-----
> From: dbmail-bounces [at] dbmail [mailto:dbmail-bounces [at] dbmail] On
> Behalf Of Paul Stevens
> Sent: domingo, 11 de Janeiro de 2009 21:17
> To: DBMail mailinglist
> Subject: Re: [Dbmail] Unable to delete folders (v. 2.3.5)
>
> Jorge Bastos wrote:
> > Looking at dbmail-util, in last git the dbmail-util still doesn't
> delete all
> > data does it Paul?
> >
> > http://dbmail.org/mantis/view.php?id=720
> >
> > in the bug you assign it to 2.3.5 but in GIT I didn't saw any change
> to
> > dbmail-util.c.
>
> That's a very minor bug, in my opinion. And highly unlikely to be
> related to My's problem with simply deleting empty folders.
>
>
> --
> ________________________________________________________________
> Paul Stevens paul at nfg.nl
> NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
> The Netherlands________________________________http://www.nfg.nl
> _______________________________________________
> DBmail mailing list
> DBmail [at] dbmail
> https://mailman.fastxs.nl/mailman/listinfo/dbmail

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

paul at nfg

Jan 11, 2009, 1:45 PM

Post #9 of 12 (1602 views)
Permalink

Re: Unable to delete folders (v. 2.3.5) [In reply to]

Jorge Bastos wrote:
> Yes Paul, nothing related.
> Well the problem is that, the server may get full, unless a script is
> running with the SQL code to delete what is not being deleted by
> dbmail-util.
>
> In my case, I was about getting out of space when I noticed that dbmail-util
> wasn't deleting everything.

I understand perfectly that you are have this problem. But simply
shouting 'me-too' whenever someone else has a another problem, is not
going to get either fixed.

Adding a bigger disk is definitely the cheaper solution from my perspective.

Now if someone with the coding skills would supply me with a patch to
fix your problem I'll gladly read it, and merge it if possible.

--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
DBmail [at] dbmail
https://mailman.fastxs.nl/mailman/listinfo/dbmail

mysql.jorge at decimal

Jan 11, 2009, 1:53 PM

Post #10 of 12 (1601 views)
Permalink

RE: Unable to delete folders (v. 2.3.5) [In reply to]

> I understand perfectly that you are have this problem. But simply
> shouting 'me-too' whenever someone else has a another problem, is not
> going to get either fixed.

Paul, I never talked with that perpective, was just a reminder, don't get me
wrong.

>
> Adding a bigger disk is definitely the cheaper solution from my
> perspective.

Well, it's a 250GB RAID1.

>
> Now if someone with the coding skills would supply me with a patch to
> fix your problem I'll gladly read it, and merge it if possible.
>

I understand you Paul, believe me that I do.
I'm not a C coder, but I always can give it a try.
If I can't, I'll wait of course.

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

paul at nfg

Jan 12, 2009, 11:21 AM

Post #11 of 12 (1588 views)
Permalink

Re: Unable to delete folders (v. 2.3.5) [In reply to]

My BSD wrote:
> On Sun, 11 Jan 2009 22:22:05 +0100
> Paul Stevens <paul [at] nfg> wrote:
>
>> My BSD wrote:
>>> On Sun, 11 Jan 2009 09:23:09 -0500
>>> My BSD <MyBSD [at] comcast> wrote:
>>>
>>>> ... <snip> ...
>>> One more piece to the puzzle:
>>>
>>> Created a MySQL database and was able to delete folders without incident.

I fixed this problem in my tree on the train today.
--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
DBmail [at] dbmail
https://mailman.fastxs.nl/mailman/listinfo/dbmail

paul at nfg

Jan 13, 2009, 3:20 AM

Post #12 of 12 (1589 views)
Permalink

Re: Unable to delete folders (v. 2.3.5) [In reply to]

Pushed now.

My BSD wrote:
> On Mon, 12 Jan 2009 20:21:22 +0100
> Paul Stevens <paul [at] nfg> wrote:
>
>> My BSD wrote:
>>> On Sun, 11 Jan 2009 22:22:05 +0100
>>> Paul Stevens <paul [at] nfg> wrote:
>>>
>>>> My BSD wrote:
>>>>> On Sun, 11 Jan 2009 09:23:09 -0500
>>>>> My BSD <MyBSD [at] comcast> wrote:
>>>>>
>>>>>> ... <snip> ...
>>>>> One more piece to the puzzle:
>>>>>
>>>>> Created a MySQL database and was able to delete folders without incident.
>> I fixed this problem in my tree on the train today.
>
> Great!
>
> Don't see it in your public Git repository though?
>
> My best regards.
>

--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
DBmail [at] dbmail
https://mailman.fastxs.nl/mailman/listinfo/dbmail

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads