Update to dovecot > inbox empty, squirrelmail SQL problem

T

Tim

Verified User
Joined
Oct 8, 2003
Messages
115
Hi all,

we updated today to dovecot, because a lot of IMAP problems with uw-imapd.

1. Some mailboxes from users seems to be empty, some aren't empty
2. Squirrelmail gives a SQL error, but not with all the accounts / pop3
3. some of the horde imap folders, wich are in /home/username/{domain}/mail, are gone since the dovecot export!
4. some accounts has a quota problem:

Mail.log:
Oct 1 16:35:52 srv01 dovecot[3729]: IMAP({POP3_ACCOUNT}): write_full(/home/{USERNAME}/imap/{DOMAIN}/info/Maildir/dovecot-uidlist.lock) failed: Disk quota exceeded

mail.err:
Couldn't init INBOX: Can't sync mailbox: Messages keep getting expunged


but de quota isn't exceeded!
 
Last edited:
Oke, i started ./build todovecot 3 times and now some accounts are filled again. Weird...
 
Hello,

As the error you've posted states:

failed: Disk quota exceeded

Meaning the user doesn't have any more space on his account.
Either incrase his limit or get him to clear out some files.

To check his system quotas from disk, type:
Code: 
quota -v [b]username[/b]
where username is the name of the user you're checking.

Note that during the transfer the original emails are not deleted until you decide to, thus they'll be doubling their email usage temporarily. Just something to keep in mind when converting.

John
 
Where is the quote-max coming from? I think from DA? In DA there's by my test user still 50MB available, but still we got a quote problem in the logs.

And how is it possible to get the IMAP folders back? They're still on the server

quota output:

Disk quotas for user {username} (uid 1008):
Filesystem blocks quota limit grace files quota limit grace
/dev/sda1 969180* 366592 366592 16080 0 0

seems more used than limit...
 
Last edited:
Tim said:
Where is the quote-max coming from? I think from DA? In DA there's by my test user still 50MB available, but still we got a quote problem in the logs.

And how is it possible to get the IMAP folders back? They're still on the server

quota output:

Disk quotas for user {username} (uid 1008):
Filesystem blocks quota limit grace files quota limit grace
/dev/sda1 969180* 366592 366592 16080 0 0

seems more used than limit...
Click to expand...

The quota was set up with the package that was selected when you set up the account, in this case 50MB. The data that shows up in the interface is not live it is done at around midnight (at least on my machine).

The little * means that it will no longer let you add data under that username.
 
There are right now a lot of quota problems but it seems to be right. Quota = quota, right? ;)
 
Last edited:
Hello,

To increase the limit, go to:
Admin Level -> Show All Users -> username -> modify User username and set a higher limit, or unlimited.

If you want to update the disk usage now (as it's done nightly), in ssh as root type:
Code: 
echo "action=tally&value=all" >> /usr/local/directadmin/data/task.queue
then wait about 10 minutes to see the results. (roughly, it depends on how many users you have)

John
 
As i said, it's the real quota right now. That's oke, we shall she in the next few days how it go's with the users.

But I still have a problem with the IMAP folders. How can we get them back?
 
You mean the Maildir folders? The "./build todovecot" tool should be transferring the mbox imap folders over to the Maildir folders. If not, I couldn't say, I'd need more information on the current conditions of what's sitting where, any errors the conversion is throwing (/var/log/directadmin/errortaskq.log)

John
 
Log output:

Code: 
2007:10:01-04:20:01: Reset All has started
2007:10:01-04:20:02: Reset All has finished
2007:10:01-15:51:01: service dovecot wasn't running, starting it
2007:10:01-15:51:01: Error starting service dovecot : uid 0 gid 0 : /etc/init.d/dovecot start                           >>/dev/null 2>>/dev/null

2007:10:01-15:51:11: service dovecot didn't start, re-starting it
2007:10:01-15:51:12: Error restarting service dovecot : uid 0 gid 0 : /etc/init.d/dovecot restart                           >>/dev/null 2>>/dev/null

2007:10:01-15:52:01: service dovecot wasn't running, starting it
2007:10:01-15:52:01: Error starting service dovecot : uid 0 gid 0 : /etc/init.d/dovecot start                           >>/dev/null 2>>/dev/null

2007:10:01-15:52:11: service dovecot didn't start, re-starting it
2007:10:01-15:52:12: Error restarting service dovecot : uid 0 gid 0 : /etc/init.d/dovecot restart                           >>/dev/null 2>>/dev/null

2007:10:01-15:52:42: Cannot find /etc/virtual/[domain].nl/passwd .. account might be suspended.  Attempting to reada the suspended file.
2007:10:01-15:53:01: service dovecot wasn't running, starting it
2007:10:01-15:53:01: Error starting service dovecot : uid 0 gid 0 : /etc/init.d/dovecot start                           >>/dev/null 2>>/dev/null

2007:10:01-15:53:11: service dovecot didn't start, re-starting it
2007:10:01-15:53:12: Error restarting service dovecot : uid 0 gid 0 : /etc/init.d/dovecot restart                           >>/dev/null 2>>/dev/null

2007:10:01-15:54:01: service dovecot wasn't running, starting it
2007:10:01-15:54:01: Error starting service dovecot : uid 0 gid 0 : /etc/init.d/dovecot start                           >>/dev/null 2>>/dev/null

2007:10:01-15:54:11: service dovecot didn't start, re-starting it
2007:10:01-15:54:12: Error restarting service dovecot : uid 0 gid 0 : /etc/init.d/dovecot restart                           >>/dev/null 2>>/dev/null

2007:10:01-15:54:14: Cannot find /etc/virtual/[domain].nl/passwd .. account might be suspended.  Attempting to reada the suspended file.
2007:10:01-15:55:01: service dovecot wasn't running, starting it
2007:10:01-15:55:02: Error starting service dovecot : uid 0 gid 0 : /etc/init.d/dovecot start                           >>/dev/null 2>>/dev/null

2007:10:01-15:55:12: service dovecot didn't start, re-starting it
2007:10:01-15:55:13: Error restarting service dovecot : uid 0 gid 0 : /etc/init.d/dovecot restart                           >>/dev/null 2>>/dev/null

2007:10:01-15:56:01: service dovecot wasn't running, starting it
2007:10:01-15:56:01: Error starting service dovecot : uid 0 gid 0 : /etc/init.d/dovecot start                           >>/dev/null 2>>/dev/null

2007:10:01-15:56:11: service dovecot didn't start, re-starting it
2007:10:01-15:56:12: Error restarting service dovecot : uid 0 gid 0 : /etc/init.d/dovecot restart                           >>/dev/null 2>>/dev/null

2007:10:01-15:57:01: service dovecot wasn't running, starting it
2007:10:01-15:57:01: Error starting service dovecot : uid 0 gid 0 : /etc/init.d/dovecot start                           >>/dev/null 2>>/dev/null

2007:10:01-15:57:11: service dovecot didn't start, re-starting it
2007:10:01-15:57:12: Error restarting service dovecot : uid 0 gid 0 : /etc/init.d/dovecot restart                           >>/dev/null 2>>/dev/null

2007:10:01-15:58:01: service dovecot wasn't running, starting it
2007:10:01-15:58:01: Error starting service dovecot : uid 0 gid 0 : /etc/init.d/dovecot start                           >>/dev/null 2>>/dev/null

2007:10:01-15:58:05: service dovecot wasn't running, starting it
2007:10:01-17:01:33: Cannot find /etc/virtual/[domain].nl/passwd .. account might be suspended.  Attempting to reada the suspended file.
2007:10:01-17:03:33: Cannot find /etc/virtual/[domain].nl/passwd .. account might be suspended.  Attempting to reada the suspended file.
2007:10:01-19:16:56: Cannot find /etc/virtual/[domain].nl/passwd .. account might be suspended.  Attempting to reada the suspended file.
2007:10:01-19:18:59: Cannot find /etc/virtual/[domain].nl/passwd .. account might be suspended.  Attempting to reada the suspended file.

that's all i found. Nothing weird, right?

I got today a lot of call's from our clients, mailboxes are full (DA email size) but horde etc. doesn't display them...

Please, how is it possible that some accounts seems to be empty by POP3/Horde/etc. and thtat Direct Admin say's there's a lot of mail in MB's.
 
Last edited:
I'll still having problems with a lot of e-mail accounts.

- DA Says there's XX / XXX MB used for mail.
- I emptied for a email virtual pop3 user, the inbox with DA but still XX MB used!
- now do i have a Maildir user, wich DA says XXX MB used, but horde etc, doesn't show any mail. If i take a look in the Maildir/cur/ dir I see a lot of files like : 1191330230.H285401P29428.servername.domain.tld:2,S

Can somebody please tell me how we fix al those problems?

Errors found in mail.err:

Couldn't init INBOX: Can't sync mailbox: Messages keep getting expunge

and also write_full / failed: Disk quota exceeded

but quota -v on that user:

Filesystem blocks quota limit grace files quota limit grace
/dev/sda1 705640 3072000 3072000 4279 0 0

stil lenough available!
 
Last edited:
Hello,

I've googled that error, but really didn't turn up much information. This is the closest I found:
- When we open the mail-hash, we check that no messages have been expunged
- from mailbox which haven't also been removed from the hash. If they have,
- we rebuild the thread tree. Otherwise we add the new messages to the hash
- and then send the results to client.
Click to expand...
Which basically means that even with the error, there shouldn't be any noticeable problems, dovecot would fix itself and move on.

So, if the account is working properly, then you can ignore the error.

There is a disk quota that exim enforces in /etc/virtual/domain.com/quota, but if that's the case, then it would only be showing up in /var/log/exim/mainlog. I'm not too sure about that case... maybe sure the actual disk isn't full, as that can also cause problems.

John
 
ok for that error...

but still, i dont get any answer to my other questions.

- Imap virtual folders, who are in de /mail/ dir but nog in Maildir (like horde!)
- all the mail isnt vissible anymore in pop3/horde etc., but in DA (Mail MB's!) and in de Maildir does i see the mail.
 
Hello,

the "mail" folder in the email user's folder is for the old mbox vm-pop3d.
The Maildir folder in the email user's folder is for dovecot.

To see if the mail is there, check:
Maildir/new/* or Maildir/cur/*
as that's where the data from mail is placed during the conversion.

if it's not there, try the conversion.. if it is but you can't see it, the possibly dovecot isn't running yet.

Type the following code... you should get a similar output if dovecot is running:
Code: 
[root@server root]# [b]telnet localhost 110[/b]
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
+OK Dovecot DA ready.
[b]QUIT[/b]
+OK Logging out
Connection closed by foreign host.
[root@server root]#
If you see:
+OK POP3 Welcome to vm-pop3d 1.1.7f-T6-DA
Then dovecot isn't running.

If you continue to have troubles, you can always send us your info to support at directadmin.com and we can take a look to see what the problem is for you. Be sure to inclue the IP, and users/emails/passwords to test and debug the problem.

John
 
Code: 
srv01:/home/mourik# telnet localhost 110
Trying 127.0.0.1...
Connected to localhost.localdomain.
Escape character is '^]'.
+OK Dovecot DA ready.
QUIT
+OK Logging out
Connection closed by foreign host.

dovecot is running.


In /home/username/mail/domain.tld/ I see all the POP3 users, with the old mail.

when i login with a username, i still don't see any mail.
well, I looked for the Maildir...

/home/username/Maildir/

i see:

cur/
new/
subscriptions/
tmp/
and 4 .INBOX files

_BUT_ not any users anymore! and all those file's are empty.

So how do i convert the virtual POP3 users?

And at least, how do i convert the virtual IMAP folders? I see them as a file in /home/username/mail/ but not anymare in /home/username/Maildir/
 
With DA I emptyied some inbox', but still says it there's XXMB used.
is that the _old_ /mail/* dir?
 
Site owners (server users) email is stored in /home/USERNAME/Maildir/* in the cur and new directories.

Virtual users (email users set up by the site user) are stored in /home/USERNAME/imap/*.

Jeff
 
Oke, but how do we export the old mail to the new location? Without losing mail at the new location.

Because, some users see there old mail and some users not.
 
Do you mean from mbox to Maildir (Dovecot)? That should have been done by the todovecot build argument. You can run it again, but it'll move any email in the old boxes to the new ones, even if the email is already there.

Or you can find (I believe it's somewhere in these forums) a script that'll work for individual mailboxes.

Jeff
 
You must log in or register to reply here.
Back
Top