pranavjo Absent Member.
Absent Member.
758 views

Issue with Command.sh - SSPR

I am trying to migrate data from SSPR LocalDB to Oracle, and as part of the same, I am following the instructions from the below URL. According to which I need to export data using the SSPR Command.sh utility.

https://www.netiq.com/documentation/...tml?view=print

But when I try and run ./Command.sh ExportResponses <filename> it ends up in an error,
(the following is part of the complete trace)
............
WARN , localdb.LocalDBFactory, error while initializing LocalDB instance: 5052 ERROR_PWMDB_UNAVAILABLE (error opening DB: Failed to start database '/var/opt/novell/tomcat7/webapps/sspr/WEB-INF/./LocalDB/derby-db' with class loader sun.misc.Launcher$AppClassLoader@f507d2, see the next exception for details.)
Exception in thread "main" password.pwm.util.localdb.LocalDBException: 5052 ERROR_PWMDB_UNAVAILABLE (error opening DB: Failed to start database '/var/opt/novell/tomcat7/webapps/sspr/WEB-INF/./LocalDB/derby-db' with class loader sun.misc.Launcher$AppClassLoader@f507d2, see the next exception for details.)
...........

The DB is available though, the application is running and using the same DB.

Also, in another environment, running the same does not give the the DB unavailable error (and I can successfully run ./Command.sh with other options), but when I try and export the DB, it throws another error.

WARN , config.ConfigurationReader, configuration settings have been modified since the file was saved by pwm
ERROR, stats.StatisticsManager, unable to write to pwmDB, will remain closed, error: cannot allow mutation operation; LocalDB is in read-only mode
WARN , pwm.PwmApplication, unable to add email to queue: 5039 ERROR_CLOSING
util.IntruderManager, error cleaning userStore: cannot allow mutation operation; LocalDB is in read-only mode

What is it that I am missing here?
0 Likes
2 Replies
Knowledge Partner
Knowledge Partner

Re: Issue with Command.sh - SSPR

Somehow you pasted your link in a way that does not actually work, so I
cannot review it.

Does it work any better if you first stop Apache Tomcat which is being
used to run Self Service Password Reset (SSPR)?


--
Good luck.

If you find this post helpful and are logged into the web interface,
show your appreciation and click on the star below.

If you want to send me a private message, please let me know in the
forum as I do not use the web interface often.
pranavjo Absent Member.
Absent Member.

Re: Issue with Command.sh - SSPR

Well, yes I checked sometime back and it seems to work when I stop tomcat. Strangely I have another environment where it works even when tomcat is running. This seems strange.
I am wondering what could be the difference.

But there is another issue now, when I run the command for export: ./Command.sh ExportResponses <filename>, it throws the following:

WARN , config.ConfigurationReader, configuration settings have been modified since the file was saved by pwm
ERROR, stats.StatisticsManager, unable to write to pwmDB, will remain closed, error: cannot allow mutation operation; LocalDB is in read-only mode
WARN , pwm.PwmApplication, unable to add email to queue: 5039 ERROR_CLOSING
searching 5xxxxx users for stored responses to write to /var/opt/novell/tomcat7/webapps/sspr/WEB-INF/LocalDBExp.txt....
Exception in thread "main" password.pwm.error.PwmUnrecoverableException: 5006 ERROR_RESPONSES_NORESPONSES (nmas account is disabled)
at password.pwm.util.operations.cr.NMASCrOperator.readResponseSet(NMASCrOperator.java:129)
at password.pwm.util.operations.CrService.readUserResponseSet(CrService.java:334)
at password.pwm.util.MainClass.handleExportResponses(MainClass.java:210)
at password.pwm.util.MainClass.main(MainClass.java:78)

(If this is in reference to NMAS extension option, it is enabled and NAMS save response is enabled.)

Posting the link again here:
https://www.netiq.com/documentation/sspr3/adminguide/data/b15m8ho3.html?view=print
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.