Enterprise Portal - Reset Password in Secure storage

[Former Member]

Hi there,

I have a problem this morninf with our production portal system

The password had expired so I am trying to run the command:

brconnect -u / -c -l E -f chpass -o SAPSR3DB -password password

but getting the results:

BR0801I BRCONNECT 7.20 (28)

BR0280I BRCONNECT time stamp: 2013-09-12 09.25.50
BR0828I Changing password for database user SAPSR3DB ...

BR0280I BRCONNECT time stamp: 2013-09-12 09.25.50
BR0829I Password changed successfully in database for user SAPSR3DB

BR0280I BRCONNECT time stamp: 2013-09-12 09.25.50
BR1525I Setting password for database user SAPSR3DB in secure storage /usr/sap/EPP/SYS/global/security/data/SecStore.properties ...
BR0278E Command output of '/usr/sap/EPP/SYS/exe/run/brtools -f printpwd -U /tmp/filesg3p9r | /oracle/EPP/11203/jdk/bin/java -classpath /usr/sap/EPP/SYS/global/sltools/sharedlib/launcher.jar com.sap.engine.offline.OfflineToolStart com.sap.inst.secstore.AdjustSecureStoreFS /usr/sap/EPP/SYS/global/sltools/sharedlib:/usr/sap/EPP/SYS/global/security/lib/tools -sidSource EPP -sidTarget EPP -sec /usr/sap/EPP/SYS/global/security/data/SecStore.properties -key /usr/sap/EPP/SYS/global/security/data/SecStore.key -dbUser SAPSR3DB -useStdin -nomask':
Exception in thread "main" java.lang.NoClassDefFoundError: com/sap/engine/offline/OfflineToolStart
BR0280I BRCONNECT time stamp: 2013-09-12 09.25.50
BR0279E Return code from '/usr/sap/EPP/SYS/exe/run/brtools -f printpwd -U /tmp/filesg3p9r | /oracle/EPP/11203/jdk/bin/java -classpath /usr/sap/EPP/SYS/global/sltools/sharedlib/launcher.jar com.sap.engine.offline.OfflineToolStart com.sap.inst.secstore.AdjustSecureStoreFS /usr/sap/EPP/SYS/global/sltools/sharedlib:/usr/sap/EPP/SYS/global/security/lib/tools -sidSource EPP -sidTarget EPP -sec /usr/sap/EPP/SYS/global/security/data/SecStore.properties -key /usr/sap/EPP/SYS/global/security/data/SecStore.key -dbUser SAPSR3DB -useStdin -nomask': 1
BR1527E Setting password for database user SAPSR3DB in secure storage /usr/sap/EPP/SYS/global/security/data/SecStore.properties failed
BR0832E Changing password for user SAPSR3DB failed

BR0280I BRCONNECT time stamp: 2013-09-12 09.25.50
BR0804I BRCONNECT terminated with errors

Andy ideas anybody?? Help

Andy

[sunny_pahuja2 · Accepted solution]

Hello,

Could you please check point 2. Changing the password of the SAP Java schema in SAP note 1764043 and make sure that you have taken steps accordingly?

Thanks

Sunny

[Former Member · Accepted solution]

Hi there, thanks for replying.

Just tried what was suggested in step 2 and got:

BR0280I BRCONNECT time stamp: 2013-09-12 12.01.24
BR0279E Return code from '/usr/sap/EPP/SYS/exe/run/brtools -f printpwd -U /tmp/files8xncm | /opt/IBMJava2-amd64-142/bin/java -classpath /usr/sap/EPP/SYS/global/sltools/sharedlib/launcher.jar com.sap.engine.offline.OfflineToolStart com.sap.inst.secstore.AdjustSecureStoreFS /usr/sap/EPP/SYS/global/sltools/sharedlib:/usr/sap/EPP/SYS/global/security/lib/tools -sidSource EPP -sidTarget EPP -sec /usr/sap/EPP/SYS/global/security/data/SecStore.properties -key /usr/sap/EPP/SYS/global/security/data/SecStore.key -dbUser SAPSR3DB -useStdin -nomask': 1
BR1527E Setting password for database user SAPSR3DB in secure storage /usr/sap/EPP/SYS/global/security/data/SecStore.properties failed
BR0832E Changing password for user SAPSR3DB failed

BR0280I BRCONNECT time stamp: 2013-09-12 12.01.24
BR0804I BRCONNECT terminated with errors

[sunny_pahuja2 · Accepted solution]

What is the release of your system ?

Thanks

Sunny

[former_member188883 · Accepted solution]

Hi Andy,

Please check whether user SAPSR3DB is locked or not ?

SQL> select username, account_status from dba_users;

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi ,

Just use the brtools to update the password and then change in the secure store.

You can use the below commands to create sec store. as per attchment in note 1592575  - Error while accessing secure store - Invalid encryption key

Test

java -classpath tc_sec_secstorefs.jar;exception.jar;iaik_jce.jar;logging.jar com.sap.security.core.server.secstorefs.SecStoreFS help

Creation

java -classpath tc_sec_secstorefs.jar;exception.jar;iaik_jce.jar;logging.jar com.sap.security.core.server.secstorefs.SecStoreFS create -s <SID> -f Sec.properties -k sec.key -noenc

Inserting content

admin/user/<SID>

java -classpath tc_sec_secstorefs.jar;exception.jar;iaik_jce.jar;logging.jar com.sap.security.core.server.secstorefs.SecStoreFS insert -s <SID> -f Sec.properties -k sec.key admin/user/<SID> <admin_user>

admin/password/<SID>

java -classpath tc_sec_secstorefs.jar;exception.jar;iaik_jce.jar;logging.jar com.sap.security.core.server.secstorefs.SecStoreFS insert -s <SID> -f Sec.properties -k sec.key admin/password/<SID> <password>

admin/port/<SID>

java -classpath tc_sec_secstorefs.jar;exception.jar;iaik_jce.jar;logging.jar com.sap.security.core.server.secstorefs.SecStoreFS insert -s <SID> -f Sec.properties -k sec.key admin/port/<SID> <port>

admin/host/<SID>

java -classpath tc_sec_secstorefs.jar;exception.jar;iaik_jce.jar;logging.jar com.sap.security.core.server.secstorefs.SecStoreFS insert -s <SID> -f Sec.properties -k sec.key admin/host/<SID> <hosname>

Testing the insert SQL Connect info into SecureStore

java -classpath tc_sec_secstorefs.jar;exception.jar;iaik_jce.jar;logging.jar;opensqlsta.jar;jdbc20.jar com.sap.sql.connect.OpenSQLConnectInfo usage

Inserting SQL Connect info into SecureStore

java -classpath tc_sec_secstorefs.jar;exception.jar;iaik_jce.jar;logging.jar;opensqlsta.jar;jdbc20.jar com.sap.sql.connect.OpenSQLConnectInfo create_dr.jdbc/pool/<SID> <Database Driver Class> <Database URL> <Database user password SID> Sec.properties Sec.key

Thanks

Rishi Abrol

[Former Member · Accepted solution]

Thanks for all the replies.

I have managed to fix it now.

I had to reset the password using the configtool and not brconnect.

Thanks

Andy