This post explains how to reset an application user’s password for an SQLite database. There is only one P6 user per SQLite database, so if the user gets “Invalid Username or Password” and cannot remember the password, this solution can be used to reset the password.
Connecting SQLite Database
1. To connect to the SQLite database, the Command-Line Shell For SQLite is required. Download the Command Line Shell For SQLite from http://www.sqlite.org/download.html
2. You may also want to connect to the database using a GUI. Go to http://sqlitebrowser.org to download. When using the GUI, you can just type the “update” statement noted below in the Execute SQL tab to run.
Reset Application User’s Password
1. Extract sqlite3.exe from your download (Example: sqlite-tools-win32-x86-3130000.zip).
2. Cut/paste sqlite.3.exe into the directory containing your SQLite database. (Example: C:\Users\username\Documents\).
3. Double-click sqlite3.exe to open command prompt.
4. Type the following command to connect to the P6 database
.open PPMDBSQLite.db ### (or use whatever file name is present on your system)
5. Run the following command to reset the password to a null (blank) password:
update users set passwd = null where user_name = '[application username]';
If you are unsure of the username, run the following query first to obtain it:
select user_name from users;
6. After running the update to null the password, select “write changes” at the top to apply the update. (For GUI only, not command line).
7. If you would like to define a new password other than null, after logging in, go to Edit > User Preferences > Password tab.