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

Last revisionBoth sides next revision
reference:view_password_change_history [2015/02/03 09:50] – created paulreference:view_password_change_history [2015/02/03 09:52] paul
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 by 127.0.0.1