The 'user line in vdominfo seems invalid on my install as well, but my
server is cranking along without issue. When I run vdominfo on my server,
I get 68 domains that say 0 users, 3 that say 2147483646 users, and one
that says users:
# vdominfo | egrep '^users' | sort | uniq -c
68 users: 0
3 users: 2147483646
1 users: 2147483647
On Wed, Jan 17, 2018 at 11:37 PM, Olaf <[email protected]> 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 [email protected] -r" does not increase
> the number of cur_users. It's at "0". In "vdeluser [email protected]", 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 [email protected] -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 [email protected]
> [root@mail ~]# /home/vpopmail/bin/vdominfo domain.com
> domain: domain.com
> uid: 89
> gid: 89
> dir: /home/vpopmail/domains/domain.com
> users: 2147483647 <(214)%20748-3647>
>
> 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
> <(214)%20748-3647>, 0, 3, 0, 0, 0, 61, 61, 61, 0, 2, 4, 0, 0, 0, '')
> 1126 Quit
>
>
