|
From: Christian B. <pos...@cb...> - 2011-01-05 21:41:14
|
Hello, Am Mittwoch, 5. Januar 2011 schrieb J4: > On 01/05/2011 04:11 PM, Greg C wrote: > > On Wed, Jan 5, 2011 at 12:36 AM, JKL <ju...@kl...> wrote: > >> $CONF['admin_email'] = > >> 'pos...@ch...d'; > >> $CONF['vacation_domain'] = > >> 'autoreply.change-this-to-your.domain.tld'; > >> $CONF['user_footer_link'] = > >> "http://change-this-to-your.domain.tld/main"; > >> $CONF['footer_text'] = 'Return to change-this-to-your.domain.tld'; > >> $CONF['footer_link'] = 'http://change-this-to-your.domain.tld'; What about changing that settings? ;-) > >> $CONF['new_quota_table'] = 'YES'; Did you read the comment above that setting while changing it? ;-) > After following the document and making some changes: > Jan 5 16:39:23 logout dovecot: dict: sql dict: commit failed: > Unknown column 'bytes' in 'field list' > I know that I have to add a new columns into the quota table, as > noted in the Wiki so I dropped the old quota table and created this > one as per wiki (for v2): 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 ;-) > 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... > | Grants for mailuser@localhost > | GRANT USAGE ON *.* TO 'xxxxx'@'localhost' IDENTIFIED BY ... > | GRANT SELECT ON `xxxxxx`.* TO 'xxxxx'@'localhost' > | GRANT UPDATE ON `xxxxx`.`quota` TO 'xxxx'@'localhost' > However, these messages are logged for dovecot: > Jan 5 17:18:25 logout dovecot: dict: sql dict: commit > failed: INSERT command denied to user 'mailuser'@'localhost' for > table 'quota' > > A bit weird. What did I misplace? Do you see any INSERT permissions in the GRANT quoted above? I don't ;-) 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 -- Look at Debian... its stable, works on a variety of platforms.... and development is racing along at the speed of a turtle with 3 broken legs. [Joseph M. Gaffney in opensuse] |
