I can use "... set cur_users = 100 ..." ? Then I can remove 100 accounts .
Dne 18.1.2018 v 14:24 Eric Broch napsal(a):
echo "update dir_control set cur_users = 0 where domain =
'domain.com'" | mysql -u root -p vpopmail
I'm not sure why ./vadduser doesn't increment 'cur_users', and I'm not
sure why ./vdeluser does. I do know that when decrementing users that
'cur_users=147483647'.
Fix by above command.
On 1/18/2018 12:37 AM, Olaf wrote:
Hello
I have a new installation of qmailtoaster on the centos 7 system
I found a problem with vpopmail in the mysql database vpopmail in the
dir_control table.
when the user's input via "vadduser t...@domain.com -r" does not
increase the number of cur_users. It's at "0". In "vdeluser
t...@domain.com", the user deletes and writes value to cur_users.
vadduser with mysql table dir_control does not communicate.
Example:
[root@mail ~]# /home/vpopmail/bin/vadddomain domain.com
Please enter password for postmaster:
enter password again:
[root@mail ~]# /home/vpopmail/bin/vdominfo domain.com
domain: domain.com
uid: 89
gid: 89
dir: /home/vpopmail/domains/domain.com
users: 0
[root@mail ~]# /home/vpopmail/bin/vadduser t...@domain.com -r
Random password: .l9X4fdE
[root@mail ~]# /home/vpopmail/bin/vdominfo domain.com
domain: domain.com
uid: 89
gid: 89
dir: /home/vpopmail/domains/domain.com
users: 0
[root@mail ~]# /home/vpopmail/bin/vdeluser t...@domain.com
[root@mail ~]# /home/vpopmail/bin/vdominfo domain.com
domain: domain.com
uid: 89
gid: 89
dir: /home/vpopmail/domains/domain.com
users: 2147483647
Log mysql:
180117 21:33:53 1123 Connect vpopmail@localhost as anonymous on
1123 Init DB vpopmail
1123 Query select pw_name, pw_passwd, pw_uid, pw_gid,
pw_gecos, pw_dir, pw_shell , pw_clear_passwd from `domain_com` where
pw_name = "test"
1123 Query select pw_name, pw_passwd, pw_uid, pw_gid,
pw_gecos, pw_dir, pw_shell , pw_clear_passwd from `domain_com` where
pw_name = "test"
1123 Query select pw_name, pw_passwd, pw_uid, pw_gid,
pw_gecos, pw_dir, pw_shell , pw_clear_passwd from `domain_com` where
pw_name = "test"
1123 Query insert into `domain_com` ( pw_name, pw_passwd,
pw_uid, pw_gid, pw_gecos, pw_dir, pw_shell , pw_clear_passwd ) values
( "test", "$1$GrtB.BbO$h/IDnzopzqwwTvjhjVtls1", 0, 0, "test",
"/home/vpopmail/domains/domain.com/test", "NOQUOTA" ,".l9X4fdE" )
1123 Query select pw_name, pw_passwd, pw_uid, pw_gid,
pw_gecos, pw_dir, pw_shell , pw_clear_passwd from `domain_com` where
pw_name = "test"
1123 Query update `domain_com` set pw_shell =
"41943040S,4000C" where pw_name = "test"
1123 Query replace into lastauth set user='test',
domain='domain.com', remote_ip='0.0.0.0', timestamp=1516221233
1123 Quit
180117 21:34:00 1124 Connect vpopmail@localhost as anonymous on
1124 Init DB vpopmail
1124 Query select 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 from dir_control where domain =
'domain.com'
1124 Query replace into dir_control ( 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 )
values ( 'domain.com', 0, 0, 3, 0, 0, 0, 61, 61, 61, 0, 2, 4, 0, 0,
0, '')
1124 Quit
180117 21:34:17 1125 Connect vpopmail@localhost as anonymous on
1125 Init DB vpopmail
1125 Query select pw_name, pw_passwd, pw_uid, pw_gid,
pw_gecos, pw_dir, pw_shell , pw_clear_passwd from `domain_com` where
pw_name = "test"
1125 Query select valias_line from valias where alias =
'default' and domain = 'domain.com'
1125 Query delete from `domain_com` where pw_name = "test"
1125 Query delete from lastauth where user = 'test' and
domain = 'domain.com'
1125 Query select 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 from dir_control where domain =
'domain.com'
1125 Query replace into dir_control ( 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 )
values ( 'domain.com', 18446744073709551615, 0, 3, 0, 0, 0, 61, 61,
61, 0, 2, 4, 0, 0, 0, '')
1125 Quit
180117 21:34:21 1126 Connect vpopmail@localhost as anonymous on
1126 Init DB vpopmail
1126 Query select 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 from dir_control where domain =
'domain.com'
1126 Query replace into dir_control ( 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 )
values ( 'domain.com', 2147483647, 0, 3, 0, 0, 0, 61, 61, 61, 0, 2,
4, 0, 0, 0, '')
1126 Quit
--
Eric Broch
White Horse Technical Consulting (WHTC)
