On 03/21/2012 09:07 PM, [email protected] wrote:

---------------------------------------------------------------------------------
Qmailtoaster is sponsored by Vickers Consulting Group
(www.vickersconsulting.com)
     Vickers Consulting Group offers Qmailtoaster support and
installations.
       If you need professional help with your setup, contact them today!
---------------------------------------------------------------------------------
      Please visit qmailtoaster.com for the latest news, updates, and
packages.

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




After entering the mysql database server software enter the following
commands:

mysql>  use vpopmail;
mysql>  update dir_control set cur_users = 0 where domain = 'mydomain.com'

---------------------------------------------------------------------------------

Hey you sql experts out there, would it be possible to query the number of user accounts in the domain (using a count function of some sort?) and set this value to what it should be (as opposed to 0)? I'm assuming that this field is a running total of the number of accounts in the domain, which could be incorrect. In any case, I'd like to have something which can be scripted to fix this value properly, so I can include it somewhere in qtp-newmodel.

TIA.


--
-Eric 'shubes'


---------------------------------------------------------------------------------
Qmailtoaster is sponsored by Vickers Consulting Group 
(www.vickersconsulting.com)
   Vickers Consulting Group offers Qmailtoaster support and installations.
     If you need professional help with your setup, contact them today!
---------------------------------------------------------------------------------
    Please visit qmailtoaster.com for the latest news, updates, and packages.
To unsubscribe, e-mail: [email protected]
    For additional commands, e-mail: [email protected]


Reply via email to