User Tools

Site Tools


reference:view_password_change_history

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
reference:view_password_change_history [2015/02/03 09:50]
paul created
reference:view_password_change_history [2018/11/14 10:45] (current)
Line 1: Line 1:
-select username,​updateuser,​updatetime from settingaudit inner join users.users on keyfield=usernumber::​varchar where tablename='​users. +======Database query to view password change history====== 
-usersettings'​ and keyfield2='​mainpassword'​ order by updatetime desc;+ 
 +At a command prompt in the VPOP3 directory run 
 + 
 +  psql 
 +   
 +(The password is '​vpop3pass'​) 
 + 
 +Then, type 
 + 
 +  ​select username,​updateuser,​updatetime from settingaudit inner join users.users on  
 +  ​keyfield=usernumber::​varchar where tablename='​users.usersettings'​ and  
 +  ​keyfield2='​mainpassword'​ order by updatetime desc; 
 + 
 +N.B. VPOP3 does not need to be stopped while you do this 
reference/view_password_change_history.txt · Last modified: 2018/11/14 10:45 (external edit)