User Tools

Site Tools


reference:view_password_change_history

Database query to view password change history

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)