Hello,
Im a bit confused about the problem with users not shown in qmailadmin. I thought the case was if one was once using cdb, and upgraded to 5x of vpopmail, then users would not show. I however, am not using cdb. I have mysql setup for auth, and am using vpopmail 5.2.1. I am getting similar problem with no users being listed, however it seams since I've recompiled vpopmail, newly created domains have this error, and older domains do not. I did verify that all users created are listed in the vpopmail table. I do not see any differences between domains that DO list mailboxes, and new domains that don't. New users created in domains that do list users do not list in qmailadmin. I do not have a vpasswd file anywhere on the system othen than ~vpopmail/bin/vpasswd. the qmailadmin binary is vpopmail.vchkpw with setuid and setgid (default make install-strip modes). I have tried qmailadmin 1.04 and 1.02 with identical results. I doubt it matters, but /home/vpopmail is a symlink to /home/vpopmail-5.2.1. If anyone can spread some insight that would be great! Thanks. Below is a bunch of info: Mysql table structure: mysql> show tables; +--------------------+ | Tables_in_vpopmail | +--------------------+ | dir_control | | lastauth | | relay | | vpopmail | +--------------------+ mysql> describe vpopmail; +-----------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+--------------+------+-----+---------+-------+ | pw_name | varchar(32) | | PRI | | | | pw_domain | varchar(223) | | PRI | | | | pw_passwd | varchar(255) | | | | | | pw_uid | int(11) | YES | | NULL | | | pw_gid | int(11) | YES | | NULL | | | pw_gecos | varchar(255) | YES | | NULL | | | pw_dir | varchar(255) | YES | | NULL | | | pw_shell | varchar(255) | YES | | NULL | | | pw_clear_passwd | varchar(16) | YES | | NULL | | +-----------------+--------------+------+-----+---------+-------+ mysql> describe dir_control; +--------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+---------+-------+ | domain | varchar(255) | | PRI | | | | cur_users | int(11) | YES | | NULL | | | level_cur | int(11) | YES | | NULL | | | level_max | int(11) | YES | | NULL | | | level_start0 | int(11) | YES | | NULL | | | level_start1 | int(11) | YES | | NULL | | | level_start2 | int(11) | YES | | NULL | | | level_end0 | int(11) | YES | | NULL | | | level_end1 | int(11) | YES | | NULL | | | level_end2 | int(11) | YES | | NULL | | | level_mod0 | int(11) | YES | | NULL | | | level_mod1 | int(11) | YES | | NULL | | | level_mod2 | int(11) | YES | | NULL | | | level_index0 | int(11) | YES | | NULL | | | level_index1 | int(11) | YES | | NULL | | | level_index2 | int(11) | YES | | NULL | | | the_dir | varchar(255) | YES | | NULL | | +--------------+--------------+------+-----+---------+-------+ mysql> describe lastauth; +-----------+--------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+--------------+------+-----+---------------------+-------+ | user | varchar(32) | | PRI | | | | domain | varchar(223) | | PRI | | | | remote_ip | varchar(18) | | | | | | timestamp | datetime | | | 0000-00-00 00:00:00 | | +-----------+--------------+------+-----+---------------------+-------+ mysql> describe relay; +-----------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+----------+------+-----+---------+-------+ | ip_addr | char(18) | | PRI | | | | timestamp | char(12) | YES | | NULL | | | name | char(65) | YES | | NULL | | +-----------+----------+------+-----+---------+-------+ Here are my vpopmail-5.2.1 configure options: ./configure \ --enable-mysql=y --enable-roaming-users=y \ --enable-logging=v --enable-relay-clear-minutes=60 \ --enable-defaultquota=1000000000 --enable-default-domain=domain.com \ --enable-ip-alias-domains=n --enable-passwd=n \ --enable-mysql-replication=n --enable-clear-passwd=y \ --enable-learn-passwords=y --enable-md5-passwords=n \ --enable-valias=n and my qmailadmin options: ./configure --enable-user-index=Y --enable-htmldir=/www/htdocs \ --enable-cgibindir=/www/cgi-bin Path Info: qmail: /var/qmail vpopmail: /home/vpopmail System Info: Redhat Linux 7.x (x86)
