openCRX Server Installer v2.6.0

Download the Installers Tomcat EJB (openMDX) and openCRX Server
View Documentation
openCRX Wiki

These installers create an openCRX instance running on Tomcat 6 (extended by the Apache's OpenEJB) and HSQLDB. The installation comes with a preconfigured HSQLDB database. It contains data which is created when working through the guide openCRX Manual Installation Tomcat.

You can start and stop openCRX using the corresponding shortcuts/launchers. After starting openCRX you can login using any browser. Valid URLs are:

Application	URL
openCRX/Core	http://localhost:<TOMCAT_PORT>/opencrx-core-CRX/
openCRX/Store	http://localhost:<TOMCAT_PORT>/opencrx-store-CRX/Store.jsp

The following accounts are preconfigured:

User	Password
guest	guest
admin-Standard	admin-Standard
admin-Root	admin-Root

Troubleshooting

If you are not able to login then try the following:

• Open an command shell
• cd to ${installdir}/bin
• Start openCRX with opencrx.bat START on Windows platforms or
  start openCRX with ./opencrx.sh START on Linux platforms
• Check the console output for errors

WorkflowController

Here is how to start the workflow controller:

• Login as admin-Root
• Select Administration then the menu entry Wizards > openCRX Workflow Controller.
• This activates and opens the WorkflowController servlet.
• Turn on / Turn off allows to activate and deactivate openCRX background services.
• see also information available in the openCRX Admin Guide (Startup configuration in web.xml)

Configure your own database

Very detailed instructions for migrating from HSQLDB to another DMBS are available at http://sourceforge.net/apps/trac/opencrx/wiki/Sdk26.FromHSQLDBToOtherDB. Here is the short version for configuring the database connector:

• Setup your database (guides are available here).
• Adapt the database connector to your database (connection URL, username, password, etc.) by opening the file ${installdir}/apache-tomcat-6/conf/openejb.xml and editing the following section:

  <Resource id="jdbc_opencrx_CRX" type="DataSource">
     JdbcDriver org.hsqldb.jdbcDriver
     JdbcUrl jdbc:hsqldb:hsql://127.0.0.1:9001/CRX_2_6
     UserName sa
     Password manager99
     JtaManaged true
  </Resource>
  

• Adapt the openCRX launch script (${installdir}/bin/opencrx.bat or ${installdir}/bin/opencrx.sh) accordingly; you might have to disable the START and STOP commands for the HSQLDB database.
• Copy the JDBC driver matching your DBMS/version to ${installdir}/apache-tomcat-6/lib.
• Either copy your HSQLDB database to your new database with CopyDB or initialize/populate your new/empty database following the relevant steps of the guide openCRX Manual Installation Tomcat.

SQL scripts to create a new openCRX database (tables, views, etc.) from scratch are included in the openCRX SDK. Download the openCRX SDK Installer and install the openCRX SDK. Scripts for all the supported database management systems (HSQLDB, MySQL, PostgreSQL, MS SQL, IBM DB/2, and Oracle) are contained in the directory <SDK_Install_Dir>\opencrx-x.x.x\core\src\sql.