Lost oxadmin password

Hello Everyone,

I setup a open exchange server a good 8 months ago and I forgot the oxadmin password. I know there is a way to reset the password as I have done it once before, however I have no clue where I wrote down how to do it.  I have full access to the linux server, could someone tell help?
roncioiuAsked:
Who is Participating?
 
larsrohrConnect With a Mentor Commented:
Oh, well, worth a shot.
Here's some further advice, more apropos:

http://www.open-xchange.com/forum/showthread.php?1798-Lost-oxadmin-password
Looks like you can replace the userPassword in the "user" table -- easiest if you have another known password in that table, so you can just copy that one.

Otherwise, you can create a new SHA1 password and base64 encode it.  Online tools can be used for this, or I think the following should work using openssl:
echo -n "newpassword" | openssl dgst -sha1 -binary | openssl base64


0
 
larsrohrCommented:
Does this help:
How to reset the password for mailadmin | Open-Xchange Support Database
http://sdb.open-xchange.com/node/54
0
 
roncioiuAuthor Commented:
No, I do not have it setup to use ldap , it is using the mysql database for authentication and for the user database. It was one of the first links I saw googling as well ;)

Thanks though.
0
 
roncioiuAuthor Commented:
I had come across that page as well and just wasn't sure what to do in mysql (hardly a db guru), but with a little poking around I managed to figure it out. Of course your CLI quip helped as that was one of the reasons I did not follow that links advice to begin with. So here is what I did for any others that might need it in the future:

1- #  /etc/init.d/mysql stop
2- #  /etc/init.d/mysql start --skip-grant-tables --user=root
3- #  mysql -u root     (or mysql -u root -p   in case a password is needed)
4- >  use oxdatabase_6;  ( open exchange database)
5- # In another shell I used larsrohr's command echo -n "newpassword" | openssl dgst -sha1 -binary | openssl base64
6- copy into buffer the output
7- back in the mysql shell >  UPDATE user SET userPassword=('newhashhere') WHERE cid=1 and id=2;
8- >  FLUSH PRIVILEGES;
9- >  quit


After that I was able to log in again.

Thank You!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.