Recover or reset admin password

[djp...@gmail.com]

I have lost or mis-set the admin password used to access the configuration utility and so I now cannot access it.

Is there a way to recover or reset the password? I have access to the database but the stored password is encrypted (obviously).

Any help would be appreciated.

[Samuli Järvelä]

You could use the lost password plugin: http://code.google.com/p/mollify/wiki/LostPasswordPlugin

[wouter.d...@gmail.com]

But what if the mail adres is not set?

I cant open the database either. Its encrypted. Anyone know how to open it?

[Samuli Järvelä]

What do you mean "its encrypted", how exactly are you trying to open it? And what db are you talking about?

All databases have internal structure on the db files, and you are not supposed to open them directly. Instead, you use a database tool, like "phpMyAdmin" (http://www.phpmyadmin.net/home_page/index.php) for MySQL (or the command line tool https://dev.mysql.com/doc/refman/5.5/en/mysql.html), phpSQLiteAdmin (http://phpsqliteadmin.sourceforge.net/) for SQLite and so on, which you can use for running the SQL commands yourself.

So find the correct database tool, and run command like

    update user set email="YOUR_EMAIL" where user_id="USER_ID"

where of course you have to dig out the correct user id from the user table.

[wouter.d...@gmail.com]

Sorry for not being clear enough.

Im talking about db.file, the sqlite database which is used by mollify. When I open it with SqliteManager it asks for a password.
Sqllite manager (ff addon) says:

SQLiteManager: Error in opening file db.file - either the file is encrypted or corrupt
Exception Name: NS_ERROR_FILE_CORRUPTED
Exception Message: Component returned failure code: 0x8052000b (NS_ERROR_FILE_CORRUPTED) [mozIStorageService.openUnsharedDatabase]

Thats why I think its encrypted.
 

[Samuli Järvelä]

Actually the error says "corrupted", not "encrypted". Sure both means that it is not readable, but in "encrypted" it is intentional and possible to decrypt.

Usually "corrupted" means that it is not actually sqlite db file or it is from different SQLite version (https://code.google.com/p/sqlite-manager/wiki/FAQ#I_get_an_error_while_trying_to_open/connect_to_an_sqlite_db_file), I suspect the latter.

[wouter.d...@gmail.com]

Well, the exception says corrupted but the more friendly message says 'encrypted or corrupt'. I know the difference between encrypted and corrupt.

Working with the sqlite2 driver solved it.