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

Sequoia ERP is now ready to use.