Re: [Postfixadmin-devel] Unable to display mailboxes.

[<me...@td...>]

HI David,

Sorry I did not see this until after I sent my previous message.

On Wed, 29 Apr 2009, David Goodwin wrote:

> David Goodwin wrote :
>>>>
>>>> Hmm. Would it be possible for me to get a DB dump?
>>>>
>>>> (Specifically the alias and mailbox tables)
>>>
>>> Sure. I have attached 3 tables, mailbox, alias, and quota.
>>>
>>> I did a little more investigation and found that if I set $CONF['used_quotas']
>>> to no then the mailbox data shows up. If I reset it to yes then the mailbox
>>> data goes away.
>>
>> Ah. That's interesting.
>
>
> Right, I can replicate this - but (as before) I don't use quotas or
> dovecot.
>
> In list-virtual.php there's a query that reads somewhat like :
>
> "SELECT $table_mailbox.*, $table_vacation.active AS v_active,
> $table_quota.current FROM $table_mailbox
>    LEFT JOIN $table_vacation ON $table_mailbox.username=$table_vacation.email
>    LEFT JOIN $table_quota ON $table_mailbox.username=$table_quota.username
>    WHERE $table_mailbox.domain='$fDomain'
>    AND $table_quota.path='quota/storage'
>        ORDER BY $table_mailbox.username
>        LIMIT $page_size
>        OFFSET $fDisplay"
>
> If you remove the 'AND $table_quota.path='quota/storage' it will work
> as expected.

Cool except that under my current config, I am getting a different error.
pfa does not seem to like the $table_quota.current entry above.

When I sent the first message, I did not realize just how different the
old style and new style dovecot quotas were. :(

I modified the above query as per your suggestion above and I also changed
$table_quota.current to $table_quota.username and now I get Quota used 0/50.
I think I am wrong with what I did though. If I increase the the bytes value
in the quota table and refresh pfa, I would expect the number 0 in 0/50 to get
larger to reflect what I added to the db but it still says 0/50. Do you have
any idea what I need to set the query above to to get things working?

>
> Unfortunately your quota table has no information within it, so I
> can't tell whether the above is 'valid' or not.

The dump I sent in my previous message contains 1 line of data that was
inserted by dovecot. Does this help or do you need more data?

> Does this help?

The fact that you are willing to help me is a big help but we are not quite
there yet. :) I appreciate your time.

Regards,

-- 
Tom			me...@td...		Spamtrap address	 		me...@td...