- 论坛徽章:
- 0
|
091230 11:59:28 4 Connect vpopmail@localhost on
4 Init DB vpopmail
4 Query select pw_name, pw_passwd, pw_uid, pw_gid, pw_gecos, pw_dir, pw_shell , pw_clear_passwd from vpopmail where pw_name = "user" and pw_domain = "test.com"
4 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 = 'test.com'
4 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 ( 'test.com', 6, 0, 3, 0, 0, 0, 61, 61, 61, 0, 2, 4, 0, 0, 0, '')
4 Query select pw_name, pw_passwd, pw_uid, pw_gid, pw_gecos, pw_dir, pw_shell , pw_clear_passwd from vpopmail where pw_name = "user" and pw_domain = "test.com"
4 Query insert into vpopmail ( pw_name, pw_domain, pw_passwd, pw_uid, pw_gid, pw_gecos, pw_dir, pw_shell , pw_clear_passwd ) values ( "user", "test.com", "$1$4Swiv5o8$iXKWtMm6xxXoFjztAP.FV/", 0, 0, "user", "/home/vpopmail/domains/test.com/user", "NOQUOTA" ,"user" )
4 Query select pw_name, pw_passwd, pw_uid, pw_gid, pw_gecos, pw_dir, pw_shell , pw_clear_passwd from vpopmail where pw_name = "user" and pw_domain = "test.com"
4 Query update vpopmail set pw_shell = "52428800S" where pw_name = "user" and pw_domain = "test.com"
4 Query replace into lastauth set user='user', domain='test.com', remote_ip='0.0.0.0', timestamp=1262145568
4 Quit
以上是新增加一个用户 user@test.com的 数据库的debug信息
下面是界面登录 mysql debug的信息:
091230 12:01:06 5 Connect vpopmail@localhost on vpopmail
5 Query set autocommit=1
5 Query SELECT * FROM vpopmail WHERE pw_name='user@test.com'
5 Quit |
|