#1  
Old 17th April 2009, 11:20
andypl andypl is offline
Member
 
Join Date: Mar 2006
Location: Radom, Poland
Posts: 93
Thanks: 1
Thanked 1 Time in 1 Post
Default Quota postfix bug

Something led me to check the quote with postfix and proves to be a problem with the size of the maildrop in quote MySQL database.

Set the size of 2M account and sent you some big file.
In the postfix log I have this:

status = deferred (temporary failure. Command output: WARN: quota string'2097152 'not parseable maildrop: maildir over quota.)

The problem is in this database.
Quota is store in INT should be a VARCHAR, and this value should be 2097152 instead 2097152S

Last edited by andypl; 17th April 2009 at 11:31.
Reply With Quote
Sponsored Links
  #2  
Old 17th April 2009, 22:07
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 36,380
Thanks: 833
Thanked 5,479 Times in 4,313 Posts
Default

Take a look at the config files that ispconfig uses, the S is concatenated automatically in the sql query and shall not be in the database, so the int value is absolutely correct as it should be.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 18th April 2009, 11:54
andypl andypl is offline
Member
 
Join Date: Mar 2006
Location: Radom, Poland
Posts: 93
Thanks: 1
Thanked 1 Time in 1 Post
Default

But the error is in the logs:

status = deferred (temporary failure. Command output: WARN: quota string '2097152' not parseable maildrop: maildir over quota.)

If you would value of S in a maildrop is sent by mail with the information correctly.
Maildrop need to correct parameter checking quota.
Reply With Quote
  #4  
Old 18th April 2009, 17:59
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 36,380
Thanks: 833
Thanked 5,479 Times in 4,313 Posts
Default

Pleaseake a look at your courier config files, maybe the concat part is missing there in your setup.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 20th April 2009, 22:15
andypl andypl is offline
Member
 
Join Date: Mar 2006
Location: Radom, Poland
Posts: 93
Thanks: 1
Thanked 1 Time in 1 Post
Default

this is my config

authmysqlrc:

MYSQL_SERVER localhost
MYSQL_USERNAME ispconfig
MYSQL_PASSWORD xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
MYSQL_PORT 0
MYSQL_DATABASE dbispconfig
MYSQL_USER_TABLE mail_user
MYSQL_CRYPT_PWFIELD password
#MYSQL_CLEAR_PWFIELD password
MYSQL_UID_FIELD uid
MYSQL_GID_FIELD gid
MYSQL_LOGIN_FIELD email
MYSQL_HOME_FIELD homedir
MYSQL_MAILDIR_FIELD maildir
#MYSQL_NAME_FIELD
MYSQL_QUOTA_FIELD quota
MYSQL_QUOTA_FIELD concat(quota,'S')
#MYSQL_WHERE_CLAUSE access='y'
MYSQL_AUXOPTIONS_FIELD concat('disableimap=',disableimap,',disablepop3=', disablepop3)

maildrop:

/usr/bin/maildrop
Reply With Quote
  #6  
Old 21st April 2009, 19:14
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 36,380
Thanks: 833
Thanked 5,479 Times in 4,313 Posts
Default

Please comment out the line

MYSQL_QUOTA_FIELD quota

so that there is only the line:

MYSQL_QUOTA_FIELD concat(quota,'S')

which concatenates the S to the value of the filed and then restart the courier authdaemon.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #7  
Old 22nd April 2009, 12:34
andypl andypl is offline
Member
 
Join Date: Mar 2006
Location: Radom, Poland
Posts: 93
Thanks: 1
Thanked 1 Time in 1 Post
 
Default

Now works correctly.
Thx
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Undelivered Mail Returned to Sender Error202 General 5 7th May 2009 11:14
localhost postfix/master: fatal: bind 127.0.0.1 port 125: Permission denied g18c Installation/Configuration 4 24th March 2009 17:39
Help configure Postfix to use alt port 465 or 587 BoloMarkIII Installation/Configuration 10 16th March 2009 17:57
Centos 4.4 32bit Hangs, High Server load 3cwired_com Server Operation 11 16th November 2006 15:47
Verify email setup meekish Installation/Configuration 28 27th October 2006 15:36


All times are GMT +2. The time now is 14:26.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.