Solved

Lost oxadmin password

Posted on 2011-02-26
4
1,809 Views
1 Endorsement
Last Modified: 2012-05-11
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?
1
Comment
Question by:roncioiu
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 12

Expert Comment

by:larsrohr
ID: 34990467
Does this help:
How to reset the password for mailadmin | Open-Xchange Support Database
http://sdb.open-xchange.com/node/54
0
 

Author Comment

by:roncioiu
ID: 34990486
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
 
LVL 12

Accepted Solution

by:
larsrohr earned 500 total points
ID: 34990584
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
 

Author Comment

by:roncioiu
ID: 34991125
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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Linux users are sometimes dumbfounded by the severe lack of documentation on a topic. Sometimes, the documentation is copious, but other times, you end up with some obscure "it varies depending on your distribution" over and over when searching for …
Creating and Managing Databases with phpMyAdmin in cPanel.
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question