Migrating PWM With External Database

[Lee Wiscovitch]

So we currently have a PWM 1.9.1 instance up and running, using an external MySQL DB. Working fine, but we did it all by hand and now I'm ansiblizing it.

So far I've got the os, tomcat, and pwm installation sorted out, but not I'm on the configuration of it.

Reading around, is it really just as simple as copying over the PwmConfiguration.xml file from the current running instance to the new one, and just updating path/url that may have changed?

I'm not super familiar with how it works, so I wanted to ask first. Another way to ask, is if I copy/edit the PwmConfiguration.xml file and put it on my test instance, it won't do anything to the database that could cause it to stop working or lose data right? I'm thinking it would just startup and connect, but not sure if there are some tasks it does that could blow up the db.

[Jason Rivard]

Hopefully these statements answer your question:

- All of PWM configuration is in the PwmConfiguration.xml.

- The database has only user records data such as c/r answers.

- PWM will never remove data in DB.  

- During startup PWM will create table schema in DB if it doesn't already exist.

Also for automating management of the xml file, the current branch lets you set this property in the config file:

<property key="storePlaintextValues">true</property>

When this is the case, no values will be encrypted in the config file, making things easier to automate.

Cheers.

[Lee Wiscovitch]

Perfect, that answers all my initial questions? Running into a different issue now, but will make a new thread. Thanx again!