Solved

Lost oxadmin password

Posted on 2011-02-26
4
1,761 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
  • 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Fine Tune your automatic Updates for Ubuntu / Debian
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

920 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now