how to reset password on Instiki?

Question

I have an install of Instiki that I recently upgraded from v0.13 to v0.16.6. I need to reset the password, but can find no means of doing so. Does anyone have a solution for this?

Answer 1

Maybe this will help - From the Instiki FAQ:

Q: Okay, so I forgot my password. Is there any way to recover it? I’ve got physical access to the box it’s on. (Actually it’s installed on my iPod Shuffle!) Someone please help.

A: (0.10.2 and prior) rename the latest snapshot to a .gz, gunzip it, then look through it for password. Ugly but worked for me.

A: (0.11.0) Login to the db for your system and look at the contents of the “system” table. For sqlite3 (the default), ”sqlite3 db/production.db.sqlite3” and then ”.dump system”. I actually had the issue when upgrading that there were no rows in that table, so I inserted one manually. ”insert into “system” VALUES (1, ‘password’);”