Changing a user’s password in OpenX 2.8

The user management of OpenX is a little confusing if you are used to other systems. There is a blog-post about the user system on the OpenX-blog giving a good overview.

One aspect that they seem to have forgotten is dat users may want to change their password. A “I forgot my password” link is provided, but other than that there is no way to change your password.

If for some reason the password-recovery is not an option, it is possible to change the password directly in the database. The password is md5-hashed, so you can use a query like this:

UPDATE ox_users SET password=MD5('password') WHERE username='johndoe';

Obviously, you will need to change “password” to whatever you want to set the password to, and the username to the user you want to change.

This entry was posted in Web. Bookmark the permalink. Post a comment or leave a trackback: Trackback URL.

One Comment

  1. Bèr Kessels
    Posted 30 November 2011 at 10:52 | Permalink

    Eew. Unsalted passwords. Not very secure.

Post a Comment

Your email is never published nor shared. Required fields are marked *

You may use these HTML tags and attributes <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>