So I have a remote SSL VPN system that I user called OpenVPN (AKA Adito) and I had lost my password so I couldn't log in.
I found the following page that describes howto access the DB at a low level, however I couldn't get the encpassword function to load.
I finally got a password to hash however I wanted to document what the hash is just in case someone has the same problem.
To set the password to "password" (sans quotes) use the following:
update users set password='X03vv707Wu+/vWXvv70d77+9J96477+9z5k=' where username='username';
commit;
I hope this will help out some people ;)