Unable to migrate from LocalDB to ExternalDB

[Pier]

Hi All,

I'm trying to export response from PWM v1.7.1 b1232 , because I have to import them on a new PWM server with the latest version and using an external DB. This is the error when I try the Command.sh ExportResponses.

bash Command.sh ExportResponses /tmp/response.out

PWM Command Line - v1.7.1 b1232

2019-01-22 09:11:52, WARN , config.ConfigurationReader, configuration settings have been modified since the file was saved by pwm

2019-01-22 09:11:52, DEBUG, pwm.PwmApplication, successfully initialized default console log4j config at log level TRACE

2019-01-22 09:11:52, DEBUG, pwm.PwmApplication, successfully initialized default file log4j config at log level INFO

2019-01-22 09:11:52, TRACE, pwm.PwmApplication, setting log level to TRACE because mode is not RUNNING.

2019-01-22 09:11:52, DEBUG, pwm.PwmApplication, using localDB path /srv/tomcat/webapps/pwm/WEB-INF/LocalDB

2019-01-22 09:11:52, DEBUG, localdb.LocalDBFactory, initializing password.pwm.util.localdb.Berkeley_LocalDB localDBProvider instance

2019-01-22 09:11:52, TRACE, localdb.Berkeley_LocalDB, begin initialization

2019-01-22 09:11:52, TRACE, localdb.Berkeley_LocalDB, beginning open of db environment (5.0.84)

2019-01-22 09:11:52, TRACE, localdb.Berkeley_LocalDB, opening environment with config: allowCreate=true

cacheSize=0

txnNoSync=false

txnWriteNoSync=false

{je.log.fileMax=10000000, je.maxMemory=10000000, je.env.isTransactional=true, je.env.isReadOnly=true, je.cleaner.minUtilization=70}

2019-01-22 09:12:01, TRACE, localdb.Berkeley_LocalDB, db environment open

2019-01-22 09:12:01, TRACE, localdb.Berkeley_LocalDB, database 'PWM_META' open

2019-01-22 09:12:01, TRACE, localdb.Berkeley_LocalDB, database 'SHAREDHISTORY_META' open

2019-01-22 09:12:01, TRACE, localdb.Berkeley_LocalDB, database 'SHAREDHISTORY_WORDS' open

2019-01-22 09:12:01, TRACE, localdb.Berkeley_LocalDB, database 'WORDLIST_META' open

2019-01-22 09:12:01, TRACE, localdb.Berkeley_LocalDB, database 'WORDLIST_WORDS' open

2019-01-22 09:12:01, TRACE, localdb.Berkeley_LocalDB, database 'SEEDLIST_META' open

2019-01-22 09:12:01, TRACE, localdb.Berkeley_LocalDB, database 'SEEDLIST_WORDS' open

2019-01-22 09:12:01, TRACE, localdb.Berkeley_LocalDB, database 'PWM_STATS' open

2019-01-22 09:12:01, TRACE, localdb.Berkeley_LocalDB, database 'EVENTLOG_EVENTS' open

2019-01-22 09:12:01, TRACE, localdb.Berkeley_LocalDB, database 'EMAIL_QUEUE' open

2019-01-22 09:12:01, TRACE, localdb.Berkeley_LocalDB, database 'SMS_QUEUE' open

2019-01-22 09:12:01, TRACE, localdb.Berkeley_LocalDB, database 'RESPONSE_STORAGE' open

2019-01-22 09:12:01, TRACE, localdb.Berkeley_LocalDB, database 'TOKENS' open

2019-01-22 09:12:01, TRACE, localdb.Berkeley_LocalDB, database 'INTRUDER_USER' open

2019-01-22 09:12:01, TRACE, localdb.Berkeley_LocalDB, database 'INTRUDER_ADDRESS' open

2019-01-22 09:12:01, TRACE, localdb.Berkeley_LocalDB, database 'AUDIT_EVENTS' open

2019-01-22 09:12:01, TRACE, localdb.Berkeley_LocalDB, database 'TEMP' open

2019-01-22 09:12:01, TRACE, localdb.LocalDBFactory, db init completed for password.pwm.util.localdb.Berkeley_LocalDB

2019-01-22 09:12:01, TRACE, localdb.LocalDBFactory, clearing TEMP db

2019-01-22 09:12:01, INFO , localdb.LocalDBFactory, LocalDB open in 9s, db size: 115.86 MB at /srv/tomcat/webapps/pwm/WEB-INF/LocalDB, 10.45 GB free

2019-01-22 09:12:01, TRACE, pwm.PwmApplication, skipping localDBLogger due to read-only mode

2019-01-22 09:12:01, INFO , pwm.PwmApplication, initializing pwm

2019-01-22 09:12:01, INFO , pwm.PwmApplication, loaded configuration:

  pwm.publishStats.enable=false

  2019-01-22 09:12:01, INFO , pwm.PwmApplication, loaded pwm global password policy: PwmPasswordPolicy: {MinimumLowerCase=0, MinimumSpecial=0, MaximumUpperCase=0, MaximumNumeric=0, MaximumOldChars=0, EnableWordlist=true, MinimumLifetime=0, RegExMatch=, MinimumUnique=0, MinimumNonAlpha=0, DisallowedAttributes=[cn, givenName, sn], DisallowCurrent=true, MinimumStrength=0, AllowNumeric=true, ChangeMessage=, MinimumAlpha=0, MaximumLowerCase=0, AllowSpecial=true, ADComplexity=true, MaximumLength=64, MaximumRepeat=0, AllowFirstCharNumeric=true, MinimumLength=2, MaximumSequentialRepeat=0, AllowLastCharSpecial=true, MinimumNumeric=0, MaximumAlpha=0, RegExNoMatch=, MaximumNonAlpha=0, MaximumSpecial=0, MinimumUpperCase=0, AllowFirstCharSpecial=true, DisallowedValues=[password, test], AllowLastCharNumeric=true}

2019-01-22 09:12:01, TRACE, pwm.PwmApplication, retrieved instanceID B5B847560D51CD2C from localDB

2019-01-22 09:12:01, INFO , pwm.PwmApplication, using 'B5B847560D51CD2C' for instance's ID (instanceID)

2019-01-22 09:12:01, DEBUG, pwm.PwmApplication, this pwm instance first installed on Tue Nov 17 15:43:09 CET 2015

2019-01-22 09:12:01, INFO , pwm.PwmApplication, environment info: java.vm.vendor=Oracle Corporation, java.vm.version=24.65-b04, java.vm.name=OpenJDK 64-Bit Server VM, java.home=/usr/lib64/jvm/java-1.7.0-openjdk-1.7.0/jre, memmax=1037959168, threads=11, ldapChai API version: 0.6.5, b852

2019-01-22 09:12:02, INFO , pwm.PwmApplication, debug info:, memfree=17415832, memallocd=43491328, memmax=1037959168, threads=11

2019-01-22 09:12:02, DEBUG, pwm.PwmApplication, initializing service password.pwm.wordlist.SharedHistoryManager

2019-01-22 09:12:02, DEBUG, pwm.PwmApplication, initialization of service password.pwm.wordlist.SharedHistoryManager has completed successfully

2019-01-22 09:12:02, DEBUG, pwm.PwmApplication, initializing service password.pwm.util.db.DatabaseAccessor

2019-01-22 09:12:02, DEBUG, db.DatabaseAccessor, skipping database connection open, no connection parameters configured

2019-01-22 09:12:02, DEBUG, wordlist.SharedHistoryManager, starting up in background thread

2019-01-22 09:12:02, TRACE, wordlist.SharedHistoryManager, checking version number stored in pwmDB

2019-01-22 09:12:02, DEBUG, pwm.PwmApplication, initialization of service password.pwm.util.db.DatabaseAccessor has completed successfully

2019-01-22 09:12:02, DEBUG, pwm.PwmApplication, initializing service password.pwm.health.HealthMonitor

2019-01-22 09:12:02, TRACE, wordlist.SharedHistoryManager, existing db version matches current db version db=(version=2_100000, caseSensitive=false)  pwm=(version=2_100000, caseSensitive=false)

2019-01-22 09:12:02, TRACE, wordlist.SharedHistoryManager, oldest timestamp loaded from pwmDB, age is 9d:38m

2019-01-22 09:12:02, DEBUG, localdb.LocalDBAdaptor, performed real size lookup of 0 for SHAREDHISTORY_WORDS: 4ms, cached

2019-01-22 09:12:02, INFO , wordlist.SharedHistoryManager, open with 0 words (7ms), maxAgeMs=28d, oldestEntry=9d:38m

2019-01-22 09:12:02, DEBUG, wordlist.SharedHistoryManager, scheduling cleaner task to run once every 1d

2019-01-22 09:12:02, DEBUG, pwm.PwmApplication, initialization of service password.pwm.health.HealthMonitor has completed successfully

2019-01-22 09:12:02, DEBUG, pwm.PwmApplication, initializing service password.pwm.event.AuditManager

2019-01-22 09:12:02, TRACE, localdb.LocalDBStoredQueue, loaded for db AUDIT_EVENTS; headPosition=ZZZYXX, tailPosition=ZZZYXW, size=2

2019-01-22 09:12:02, FATAL, pwm.PwmApplication, unexpected error instantiating service class 'password.pwm.event.AuditManager', pwm cannot load, error: cannot allow mutation operation; LocalDB is in read-only mode

Exception in thread "main" java.lang.IllegalStateException: unexpected error instantiating service class 'password.pwm.event.AuditManager', pwm cannot load, error: cannot allow mutation operation; LocalDB is in read-only mode

        at password.pwm.PwmApplication.initialize(PwmApplication.java:363)

        at password.pwm.PwmApplication.<init>(PwmApplication.java:130)

        at password.pwm.util.MainClass.loadPwmApplication(MainClass.java:353)

        at password.pwm.util.MainClass.handleExportResponses(MainClass.java:186)

        at password.pwm.util.MainClass.main(MainClass.java:78)

Caused by: java.lang.IllegalStateException: cannot allow mutation operation; LocalDB is in read-only mode

        at password.pwm.util.localdb.Berkeley_LocalDB.preCheck(Berkeley_LocalDB.java:350)

        at password.pwm.util.localdb.Berkeley_LocalDB.put(Berkeley_LocalDB.java:244)

        at password.pwm.util.localdb.LocalDBAdaptor.put(LocalDBAdaptor.java:156)

        at password.pwm.util.localdb.LocalDBStoredQueue$InternalQueue.repair(LocalDBStoredQueue.java:789)

        at password.pwm.util.localdb.LocalDBStoredQueue$InternalQueue.init(LocalDBStoredQueue.java:501)

        at password.pwm.util.localdb.LocalDBStoredQueue$InternalQueue.<init>(LocalDBStoredQueue.java:479)

        at password.pwm.util.localdb.LocalDBStoredQueue$InternalQueue.<init>(LocalDBStoredQueue.java:451)

        at password.pwm.util.localdb.LocalDBStoredQueue.<init>(LocalDBStoredQueue.java:57)

        at password.pwm.util.localdb.LocalDBStoredQueue.createPwmDBStoredQueue(LocalDBStoredQueue.java:62)

        at password.pwm.event.AuditManager.init(AuditManager.java:89)

        at password.pwm.PwmApplication.initialize(PwmApplication.java:356)

        ... 4 more

I've also tried to backup LocalDB and PwmConfiguration.xml and restore them on an updated version of PWM, but i'm still getting error exporting response for moving them into an external DB.

Do you know how I can export the response in a safe way?
Thanks in advance.