|--> Fabian Santiago, le 14/10/2013 15:48, a dit :
> Are you saying that QMT by default uses
>
> "1st QMT build vpopmail with disable-users-big-dir" (and that this 
> contributes to the cause of the problem)
>
> or are you saying that re-building the vpopmail package with this option 
> will solve the problem? Thanks. I have seen this happen myself numerous 
> times with my QMT server.

1st, it's a fact
QMT uses vpopmail with disable-users-big-dir
and vpopmail with disable-users-big-dir causes this problem

2nd/4th it's vpopmail coding error
increase no, decrease yes
subtract without evaluating operands knowing the minimum value is 0
(or 1 if postmaster count as user)

3rd it's vqadmin outdated coding and error
but without vpopmail errors, it becomes a fact without any annoyance

it's firmly vpopmail coding errors

workarounds

rebuild vpopmail
pro solves the problem
con you know what you have, you don't know whath you'll get
con what's about QMT, have to check everything
con it's not as simple for everybody

change mysql settings
set sql-mode in my.cnf with NO_UNSIGNED_SUBTRACTION
pro solves the problem, return -1 instead of maximum integer value
con what's about other coding using unsigned integer

as Eric says, give high number to cur_users
pro solves the problem for a while, till you reach 0
con to do for each domain

bash script in crontab
read domains tables, count users, update dir_control
pro gives real count of accounts
con have to write the script, add it to crontab and monitor it

change cur_users type to medium integer
pro solves the problem
pro to do only once per server
con change basic vpopmail table layout

xaf









---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to