Lost oxadmin password

[G0dSmack72]

Is there a way that I can reset a lost oxadmin password? Any help would be much appreciated.

[G0dSmack72]

Fixed my own issue. used openssl to generate a new encrypted password and then replaced it in the mysql db. all is working now.

[quantum]

explanation

Could you please explain how you exactly do this.
How you generate this encrypted password ? ( openssl ? )
Which value will be replaced ?
Where I find it in the database ?

The way to disable the context-authentication isn't really professionell.

Thanks a Lot

[Martin Heiland]

Losing passwords isn't professional as well Disabling context authentication only applies to the admindaemon, not the the groupware.

However, those passwords are base64 encoded strings of SHA1. You might generate a new password in SHA1, base64encode it and put it to the database.

Greetings

[quantum]

It is really impressive how fast i get an answer here. Great praise !!

If you give a group of customers the possibility to administrate themselv, it unfortunately happens many times.

But one singe question still remains.
Where I find the right value in the database ?

[Martin Heiland]

Thats the "user" table at the groupware database:

mysql> SELECT userPassword FROM user WHERE cid=1 and id=2;
+------------------------------+
| userPassword                 |
+------------------------------+
| 5en6G6MezRroT3XKqkdPOmY/BfQ= | 
+------------------------------+

Please make sure that you update the correct password and make backups of the original ones.

Greetings

[quantum]

This is really helpful.
Thank you for your efforts!