Differences

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

--- reference:view_password_change_history [2015/02/03 09:50] – created paul
+++ reference:view_password_change_history [2018/11/14 10:45] (current) – external edit 127.0.0.1
@@ 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

PSCS Wiki