Configuring the Database Profile
Configuring the Database Profile
Note: Before you Begin
- Make sure you are on a machine that has access to the following items:
- Apache Maven 3.0.5
- Your Maven Nexus server
- Subversion
- Your staging or production database
Liquibase configuration is tied to Elastic Path's Maven configuration settings. Therefore, you must modify the Maven settings.xml file.
- In your home directory, create a .m2 directory.
- With SVN, checkout the settings.xml used by the developers into your .m2 directory.
- With a text editor, open settings.xml.
- Scroll down to <activeProfiles> and uncomment the appropriate -dev-db profile for your production database. Be sure to comment out all other available database profiles.
- Add the following bit of XML under <profiles>:
<profile> <id>YOUR_DATABASE_PROFILE</id> <properties> <epdb.schemaname>COMMERCEDB</epdb.schemaname> <epdb.username>ep</epdb.username> <epdb.password>ep</epdb.password> <epdb.host>127.0.0.1</epdb.host> <epdb.port>YOUR_DATABASE_PORT</epdb.port> </properties> </profile>
Note: Oracle Database ProfileIf you are using Oracle 11g, use the following profile instead and replace epdb.databasename with the name of your database:
<profile> <id>oracle-dev-db</id> <properties> <epdb.databasename>orcl</epdb.databasename> <epdb.schemaname>COMMERCEDB</epdb.schemaname> <epdb.password>ep</epdb.password> <epdb.host>127.0.0.1</epdb.host> <epdb.port>1521</epdb.port> </properties> </profile>
Note: Default settingsElastic Path 6.13.0 uses the following database profile values by default:
Schema Name COMMERCEDB Username
ep
Password
ep
Host 127.0.0.1 All default database settings are defined in the Elastic Path grandparent POM. You may override any setting by adding the new value in your settings.xml database profile.
- Replace the id property with your production database's -dev-db profile. For example, mysql-dev-db
- Replace the epdb.schemaname property with the name of your database schema.
- Replace the epdb.username and epdb.password properties with an account that has permission to access your database.
- Replace the epdb.host and epdb.port properties with your database server's IP and port numbers.