Page Comparison

We provide a ready-to-use installation package, which can be found herehttps://github.com/qcadoo/mes/releases/latest. Download the .zip file and unzip it. Locating the unzipped files in any folders, with white spaces in their names, may cause problems at the start up.

Configure the database

Open qcadoo/qcadoo/db.properties and set the properties:

• dbDriverClass - name of the driver class (org.postgresql.Driver for PostgreSQL)
• dbJdbcUrl - database's URL as: jdbc:postgresql[://host:port/]:[database_name] where the host name (either the IP address or a literal name) and the port number are optional, ie. you can use jdbc:postgresql:mes, jdbc:postgresql://localhost/mes or jdbc:postgresql://localhost:5432/mes
• dbUsername - database's user
• dbPassword - database's password
• hibernateDialect - database's dialect (org.hibernate.dialect.PostgreSQLDialect for PostgreSQL)

This is the sample db.properties file:

dbDriverClass=org.postgresql.Driver
dbJdbcUrl=jdbc:postgresql:mes
dbUsername=postgres
dbPassword=postgres123
hibernateDialect=org.hibernate.dialect.PostgreSQLDialect

Start the application

Before first run, You have to restore clean database schema that We provide with qcadoo MES package (mes-application/webapps/ROOT/WEB-INF/classes/schema/demo_db_en.sql). This is one of the conditions for qcadoo MES to work nice & smooth 

All You have to do is to restore this dump using the following command in BASH (assuming, You have installed postgreSQL as the user postgres, and created database mes with password postgres123):

psql -U postgres mes < path/to/schema/demo_db_en.sql

So, now You are ready to run! Open terminal and type ./bin/startup.sh