Procedure
When the MashZone NextGen User Repository is your LDAP Directory, the default administrator account (Administrator user) is disabled.
Make sure this database is supported by MashZone NextGen. See Additional MashZone NextGen System and Software Requirements for details.
If you want MashZone NextGen to support international characters in meta-data for artifacts, set the character encoding to UTF8 when you create the database. See documentation for your database for specific instructions.
It is a best practice to require passwords for every database account that can access the MashZone NextGen Repository.
When you initialize the PostGres database that will host the MashZone NextGen Repository, you may need to specifically set the locale used by the database to ensure case-insensitive sorting.
createDBTables.txt for MetaData and the default User Repository
createSnapsTables.sql for Snapshots
createSchedulerTables.sql for Scheduler
There are also scripts to drop the corresponding MashZone NextGen Repository tables in these folders, if needed.
The configuration would now look like:
... <bean id="scheduler" > <property name="applicationContextSchedulerContextKey"> <value>applicationContext</value> </property> <property name="quartzProperties"> <props> <prop key="org.quartz.scheduler.instanceId">AUTO</prop> <prop key="org.quartz.jobStore.class"> org.quartz.impl .jdbcjobstore.JobStoreTX</prop> <prop key="org.quartz.jobStore.tablePrefix">QRTZ_</prop> <prop key="org.quartz.jobStore.driverDelegateClass"> org.quartz .impl.jdbcjobstore.PostgreSQLDelegate</prop> <prop key="org.quartz.jobStore.dataSource">schedulerDS</prop> ... </props> </property> </bean> ...
<property name="jdoProperties"> ... <map> ... <entry key="javax.jdo.mapping.Schema" value="public"/> <entry key="datanucleus.identifier.case" value="LowerCase"/> ... </map> </property>
name="MashzoneNextGenRepository" auth="Container" type="javax.sql.DataSource" maxTotal="200" maxIdle="30" maxWaitMillis="10000" username="app" password="app" driverClassName="org.postgresql.Driver" url="jdbc:postgresql://host-name:port/databasename" />
If needed, update optional properties. See Tomcat Datasource Properties for a complete list of optional properties and information on defaults.
Some common properties you may need to set include:
validationQuery = select 1
Common tuning properties for connections pools. See Tuning the MashZone NextGen Repository Connection Pool.
If the MashZone NextGen Server does not start up successfully, see Troubleshooting Connections to the MashZone NextGen Repository for suggestions.
If the MashZone NextGen Server wedoes not start up successfully, see Troubleshooting Connections to the MashZone NextGen Repository for suggestions.