#1 2016-10-13 04:47:24

rav
Member
Registered: 2016-10-13

Admin password encryption

Lost the root password, i see it is in the rs_user table in some encrypted for. Can someone help me on the type of encryption so i can manually encrypt a word and update the database. Any help is appreciated.

Offline

#2 2016-10-13 06:29:15

Arno Mittelbach
datenwerke
Registered: 2012-02-14

Re: Admin password encryption

Hi Rav,

welcome to the RS forum. The easiest to recover the login is probably to temporarily disable authentication. For this locate the reportserver.properties file. If you used the installer the file should be in

INSTALL_DIR/apps/reportserver/reportserver-conf/

If you used the manual installation it is either in

/opt/reportserver

or in

C:\Program Files\reportserver

There change

  rs.authenticator.pams = net.datenwerke.rs.authenticator.service.pam.UserPasswordPAMAuthoritative

into

  rs.authenticator.pams = net.datenwerke.rs.authenticator.service.pam.EveryoneIsRootPAM

After making this change you need to restart ReportServer. This will bypass authentication and login with the "root" user and you can then simply set a new password via the user manager.

Hope this helps.

Regards,
Arno

Offline

#3 2016-10-15 20:53:48

rav
Member
Registered: 2016-10-13

Re: Admin password encryption

Thanks a bunch, this fixed my issue. In general what kind of encryption is done? i see it is not md5 or md5hash or with salt.

Offline

#4 2016-11-02 12:06:40

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Admin password encryption

Hello rav,

the mechanism used is PBKDF2WithHmacSHA1 (PDKDF2 with HMAC-SHA1) with a random salt value generated with SHA1PRNG (RFC 2104 HMAC).

Regards,
Eduardo

Offline

#5 2021-02-26 20:07:25

telpochyaotl
Member
Registered: 2021-02-17

Re: Admin password encryption

Hello all! Playing with this setting to understand how to recover from lost root's password. Indeed setting EveryoneIsRootPAM works to login as root, but I can't change root's password because the form wants the old password.... Am I missing some other way or setting?

Thanks!

Offline

#6 2021-03-04 13:04:57

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Admin password encryption

Hi telpochyaotl,

you can change root's password in the administration area -> users section.

Regards,
Eduardo

Offline

Board footer

Powered by FluxBB