Re: Re: [SPAM] How to fix wrong values in dom_89 row

Alessio Cecchi <[email protected]> Wed, 17 Oct 2012 08:42:18 +0200
Newsgroups gmane.mail.vpopmail
Message-ID <[email protected]>
Il 16/10/2012 23:37, Eric Shubert ha scritto:
> On 10/16/2012 08:36 AM, Alessio Cecchi wrote:
>> Hi,
>>
>> after some "bad" migration my vpopmail "dir_control" table have some
>> problems and need to be fixed but I don't know how.
>>
>> I'm hosting, on this installation, 1000 domains so the cur_users value
>> should be 1000, right?
>>
>> mysql> select * from dir_control where domain='dom_89';
>> +--------+-----------+-----------+-----------+--------------+--------------+--------------+------------+------------+------------+------------+------------+------------+--------------+--------------+--------------+---------+ 
>>
>>
>> | domain | cur_users | level_cur | level_max | level_start0 |
>> level_start1 | level_start2 | level_end0 | level_end1 | level_end2 |
>> level_mod0 | level_mod1 | level_mod2 | level_index0 | level_index1 |
>> level_index2 | the_dir |
>> +--------+-----------+-----------+-----------+--------------+--------------+--------------+------------+------------+------------+------------+------------+------------+--------------+--------------+--------------+---------+ 
>>
>>
>> | dom_89 |       189 |         1 |         0 |            0 | 0
>> |            0 |          0 |          0 |          0 | 0
>> |          0 |          0 |            0 |            0 |            0 |
>> 0/      |
>> +--------+-----------+-----------+-----------+--------------+--------------+--------------+------------+------------+------------+------------+------------+------------+--------------+--------------+--------------+---------+ 
>>
>>
>> 1 row in set (0.00 sec)
>>
>>
>> view as CSV:
>> "dom_89";"189";"1";"0";"0";"0";"0";"0";"0";"0";"0";"0";"0";"0";"0";"0";"0/" 
>>
>>
>> Moreover, why the_dir is set to 0/?
>>
>> Can some vpopmail's tool rebuild this data? Or where I can found
>> information about each fields and correct lines by hand?
>>
>> Thanks
>>
>
> What are the config options you used to build vpopmail?
>

Hi Eric,

I'm using vpopmail  5.4.33 build with:

./configure --enable-valias=y --enable-mysql-limits 
--enable-auth-module=mysql --enable-logging=p --enable-maildrop 
--enable-mysql-replication --enable-onchange-script

Thanks

-- 
Alessio Cecchi is:
@ ILS -> http://www.linux.it/~alessice/
on LinkedIn -> http://www.linkedin.com/in/alessice
Assistenza Sistemi GNU/Linux -> http://www.cecchi.biz/
@ PLUG -> ex-Presidente, adesso senatore a vita, http://www.prato.linux.it


!DSPAM:507e534d34171024249207!