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

Reply via email to