CRM and ERP
2.3.8. MySQL Datasource in Sequoia ERP
Download the MySQL
JDBC driver which is compatible with your version of MySQL, and copy it into
framework/entity/lib/jdbc.
Go to your Sequoia ERP and make the following changes to a file called
framework/entity/config/entityengine.xml:
- Change the
"datasource-name" attribute under the
to "localmysql" - Look for
further down - Change the
"jdbc-uri" under "localmysql" to
"jdbc:mysql://127.0.0.1/sequoia?autoReconnect=true"
- Change the
"jdbc-username" to "sequoia"
- Change the
"jdbc-password" to the password you chose above
Stop Sequoia ERP. Reload the seed data
into the new MySQL database by typing the following command from the Sequoia
ERP directory:
$ java -jar ofbiz.jar
–install