Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Lost oxadmin password

Posted on 2011-02-26
4
Medium Priority
?
1,918 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 2000 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

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
I have written articles previously comparing SARDU and YUMI.  I also included a couple of lines about Easy2boot (easy2boot.com).  I have now been using, and enjoying easy2boot as my sole multiboot utility for some years and realize that it deserves …
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

579 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