Luntbuild - Installation Guide

You do not need servlet container or application server to run Luntbuild. Luntbuild comes with build-in servlet conatainer based on Jetty, a 100% Java HTTP Server and Servlet Container. Standalone Luntbuild launcher accepts three arguments:

Standalone Luntbuild stopper accepts two arguments:

You can run standalone Luntbuild launcher from the command line:

> cd <luntbuild-install-dir>
> bin/luntbuild.sh localhost 8888

or alternatively

> cd <luntbuild-install-dir>
> java -jar luntbuild-standalone.jar localhost 8888

To stop the standalone Luntbuild, you can use:

> cd <luntbuild-install-dir>
> bin/stop-luntbuild.sh localhost 8889

or alternatively

> cd <luntbuild-install-dir>
> java -cp luntbuild-standalone.jar com.luntsys.luntbuild.StandaloneStopper localhost 8889

While we sure you have several options, we suggest the excellent Java Service Wrapper to run standalone Luntbuild. You'll get a clean, cross-platform way to start/stop/restart your services. On Unix, you'll get an init-style script, and on Windows you'll be able to integrate your app as a system service if you like.

It is very good idea to backup Luntbuild data so they can be restored in case they get corrupted. The backup strategy might depend on the type of the database you are using.

The database independent way to backup Luntbuild data is to use Export function in Administration tab. Unfortunately there is currently not an automated way to create a backup, it has to be created by login as Luntbuild administrator and perform Export.

In case your Luntbuild installation uses HSQLDB database (default) the database data is stored in <luntbuild install>/db directory. It is highly recommended to backup this directory on regular basis, if you do not want to use Export method mentioned above.

If you are using an external database (MySql, PostgreSql), please use the database backup/restore procedure, if you do not want to use Export method above.

Luntbuild uses HSQL DB as default database running inside Luntbuild (in process mode). Additional in process (embedded) database supported by Luntbuild is H2. Luntbuild also supports following external (client/server mode) databases:

For external (client/server mode) databases, you will have create initial Luntbuild database by executing SQL scripts in appropriate db/... subdirectories.

Database definitions and data are located in the db directory of the Luntbuild installation.

HSQL DB uses db/luntbuild.script to define DB layout. Following files are also used, see HSQL DB documentation:

H2 embedded database uses luntbuild-h2-data* files located in db directory.

Sometimes, it is useful to look at the data in the DB to find out issues. Following are the steps to run a SQL client to examine data in the HSQL DB:

@java -classpath ../lib/hsqldb.jar org.hsqldb.Server -database <db path>

<db path> should be replaced with your path to Luntbuild DB. For example, if you are installing Luntbuild in D:\luntbuild, you should specify <db path> as D:\luntbuild\db\luntbuild.

If you are using Eclipse you can use DB plugin Quantum DB and the set the connection:

	Note
	Many Luntbuild tables contain binary data which can not be displayed through the client, for example, if you run command "select * from LB_BUILD", nothing will be displayed. You should only specify non-binary columns here, for example, "select LB_ID, LB_NAME from LB_BUILD", etc.

MySql database can be used as persistent storage for Luntbuild. The best way to configure Luntbuild to use MySql is to use Luntbuild installer, select MySql from Database install page, and fill appropriate database attributes. Alternatively you can configure <app-server>/webapps/WEB-INF/jdbc.properties for MySql (see jdbc.mysql.properties in the same directory):

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/luntbuild
jdbc.username=luntbuild
jdbc.password=luntbuild
hibernate.dialect=org.hibernate.dialect.MySQLDialect

Then you have to create Luntbuild database as follows:

> cd <luntbuild-install>
mysql> grant all on luntbuild.* to sa@localhost.localdomain identified by 'mypassword';
mysql> drop database luntbuild;
mysql> create database luntbuild;
mysql> use luntbuild;
mysql> source db/mysql/luntbuild.sql;

To manage MySql consider using free version of SQLyog. If you are using Eclipse you can use DB plugin Quantum DB and set the connection:

PostgreSQL database can be used as persistent storage for Luntbuild. The best way to configure Luntbuild to use PostgreSQL is to use Luntbuild installer, select PostgreSQL from Database install page, and fill appropriate database attributes. Alternatively you can configure <app-server>/webapps/WEB-INF/jdbc.properties for PostgreSQL (see jdbc.postgresql.properties in the same directory):

jdbc.driverClassName=org.postgresql.Driver
jdbc.url=jdbc:postgresql://localhost:5432/luntbuild
jdbc.username=luntbuild
jdbc.password=luntbuild
hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect

Then you have to create Luntbuild database as follows:

> psql  -h localhost -p 5432 postgres "admin"
postgres=# CREATE USER luntbuild;
postgres=# ALTER USER luntbuild PASSWORD 'luntbuild';
postgres=# CREATE DATABASE luntbuild WITH OWNER luntbuild;
postgres=# source luntbuild/db/postgresql/luntbuild.sql;

I use free pgAdminIII that comes with Postgres installation to manage Postgres database. If you are using Eclipse you can use DB plugin Quantum DB and set the connection:

SqlServer including Express (free) edition is now supported. I use free SQL Server Management Studio Express for database management.

The best way to configure Luntbuild to use SqlServer is to use Luntbuild installer, select SqlServer from Database install page, and fill appropriate database attributes. Alternatively you can configure <app-server>/webapps/WEB-INF/jdbc.properties for SqlServer (see jdbc.sqlserver.properties in the same directory):

jdbc.driverClassName=net.sourceforge.jtds.jdbc.Driver
jdbc.url=jdbc:jtds:sqlserver://localhost:1525/luntbuild
hibernate.dialect=org.hibernate.dialect.SQLServerDialect
jdbc.username=sa
password=your password

If you are using Eclipse you can use DB plugin Quantum DB and set the connection:

Luntbuild has been tested with Oracle 10g. You can use Oracle Enterprise Manager to manage the database. Enterprise manager is available http://<oracle-machine>:1158/em/console/logon/logon.

The best way to configure Luntbuild to use Oracle is to use Luntbuild installer, select Oracle from Database install page, and fill appropriate database attributes. Alternatively you can configure <app-server>/webapps/WEB-INF/jdbc.properties for Oracle (see jdbc.oracle.properties in the same directory):

jdbc.driverClassName=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc:oracle:thin:@localhost:1521:luntbuild
hibernate.dialect=org.hibernate.dialect.OracleDialect
jdbc.username=sa
jdbc.password=your password

If you are using Eclipse you can use DB plugin Quantum DB and set the connection:

Hibernate does not officially supports Derby. Embedded version of Derby fails to work with Hibernate and Luntbuild (caused by incompatibilities with BLOB data type). Client/Server version of Derby was tested with Hibernate/Luntbuild and it is working as expected.

If you are using Eclipse you can download and install Apache Derby plugin.

The best way to configure Luntbuild to use Derby is to use Luntbuild installer, select Derby Client from Database install page, and fill appropriate database attributes. Alternatively you can configure <app-server>/webapps/WEB-INF/jdbc.properties for Derby (see jdbc.derby-cs.properties in the same directory):

jdbc.driverClassName=org.apache.derby.jdbc.ClientDriver
jdbc.url=jdbc:derby://localhost:1527/luntbuild
hibernate.dialect=org.hibernate.dialect.DerbyDialect
jdbc.username=luntbuild
jdbc.password=luntbuild

If you are using Eclipse you can use DB plugin Quantum DB and set the connection:

H2 is database written in Java, available in both embedded and client/server mode. Based on performance comparison H2 is very fast and performs well with Luntbuild in both embedded and client/server mode. H2 comes with web client management console.

The best way to configure Luntbuild to use H2 is to use Luntbuild installer, select H2 Embedded or H2 Client from Database install page, and fill appropriate database attributes. Alternatively you can configure <app-server>/webapps/WEB-INF/jdbc.properties for H2 (see jdbc.h2-embedded.properties or jdbc.h2-cs.properties in the same directory):

jdbc.driverClassName=org.h2.Driver
jdbc.url=jdbc:h2:tcp://localhost:9092/luntbuild or ${h2Url}
hibernate.dialect=org.hibernate.dialect.HSQLDialect
jdbc.username=sa
jdbc.password=

If you are using Eclipse you can use DB plugin Quantum DB and set the connection:

The only supported way of updating Luntbuild database is to: