Re: [Postfixadmin-devel] Postfixadmin and dovecot v1.2.15 configuration woes:

[J4 <ju...@kl...>]

On 01/05/2011 10:41 PM, Christian Boltz wrote:
> What about changing that settings? ;-)
>>>> $CONF['new_quota_table'] = 'YES';
> Did you read the comment above that setting while changing it? ;-)
Now I understand.  It actually wants me to create a table called
quota2.  It has taken days for this penny to drop, and I see that there
is already a quota2 table.

I have added these grants:
 SHOW GRANTS FOR 'mailuser'@'localhost';
+-----------------------------------------------------------------------------------------------------------------+
| Grants for
mailuser@localhost                                                                                  
|
+-----------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'xxxxx'@'localhost' IDENTIFIED BY PASSWORD
'*11111111111111111111' |
| GRANT SELECT ON `xxxxx`.* TO
'xxxxx'@'localhost'                                                        |
| GRANT INSERT, UPDATE ON `xxxxx`.`quota` TO
'xxxxx'@'localhost'                                          |
| GRANT UPDATE ON `xxxxx`.`quota2` TO
'xxxxx'@'localhost'                                                 |
+-----------------------------------------------------------------------------------------------------------------+
> Oh well - one more time where I have to say "Please read the 
> postfixadmin documentation first - and don't trust external HOWTOs etc. 
> too much" (not meant to sound selfish, but it's true ;-)
Nor strangely self-serving, but really good advice. 

People will gravitate to the external manuals because they simply want
the sever to work.  If I had not run into so many problems, and had to
work this out in a painful fashion, then I would have even less
understanding than had I followed the tutorials and had a working set-up
immediately.
>> mysql> describe quota;
>> +----------+--------------+------+-----+---------+-------+
>> | Field    | Type         | Null | Key | Default | Extra |
>> +----------+--------------+------+-----+---------+-------+
>> | username | varchar(255) | NO   | PRI | NULL    |       |
>> | bytes    | bigint(20)   | NO   |     | 0       |       |
>> | messages | int(11)      | NO   |     | 0       |       |
>> +----------+--------------+------+-----+---------+-------+
> If you read the postfixadmin documentation, you'll see that we already 
> have a table with exactly those columns - however it's named "quota2" 
> because we keep the old-style "quota" table for backward compatibility.
>
> Please change your config to use the quota2 instead of the quota 
> table...
[SNIP]
> Do you see any INSERT permissions in the GRANT quoted above? I don't ;-)
INSERT added as noted above.  Thank-you for noticing this.
>
> BTW: If you have anything that should be added or changed in 
> DOVECOT.txt, please send us the changes (as patch would be best, but the 
> edited file will do also).
>
>
> Regards,
>
> Christian Boltz