Solved

Lost oxadmin password

Posted on 2011-02-26
4
1,743 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 Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

If you have a server on collocation with the super-fast CPU, that doesn't mean that you get it running at full power. Here is a preamble. When doing inventory of Linux servers, that I'm administering, I've found that some of them are running on l…
As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

758 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

21 Experts available now in Live!

Get 1:1 Help Now