How to reset password for Web UI?

The Web UI uses SQLite database in /opt/qlproxy/var/db/qlproxy.sqlite (for version < 5.0) and /opt/websafety/var/db/config.sqlite (for version 5.0+) to store user names and passwords. By default there is only one user root with password Passw0rd. This user is marked as superuser, i.e. it can logon not only to Web UI but also to the administrative UI in as explained Admin UI for Squid and Web Safety.

To reset the password of root user, login to the console using ssh, download the /opt/websafety/var/db/config.sqlite, open it in any SQLite database management program (like for example SQLite Expert) and replace the salted password in the auth_user table to the following:

pbkdf2_sha256$12000$j2rtYY1S1III$XqtCVaft/qdQTIwTp8ifRDvJG42XEdFja5jV86U8RkM=

Please ensure all other fields look like indicated on the following screenshot. Upload modified database back into /opt/websafety/var/ and restart Apache. The try logging it again.

../../_images/root_user.png