Continuum on MySQL
(from Tomasz Pik and Renaud Maussion)
Continuum 1.1-beta-2 on MySQL
1)Change in context file (continuum.xml) the jdbc connexion like this:
| Code Block |
|---|
<Context path="/continuum"
docBase="${catalina.home}/../build/continuum/continuum.war">
<Resource name="jdbc/users" auth="Container" type="javax.sql.DataSource"
username="continuum" password="continuum" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/users?autoReconnect=true"/>
<Resource name="jdbc/continuum" auth="Container" type="javax.sql.DataSource"
username="continuum" password="continuum" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/continuum?autoReconnect=true"/>
<Resource name="mail/Session" auth="Container"
type="javax.mail.Session"
mail.smtp.host="localhost"/>
</Context>
|
Add the JDBC Driver type 4 for MySQL.
2) In MySQL, add two database users and continuum with grants:
CREATE DATABASE `continuum` ;
CREATE DATABASE `users`;
add grant for continuum's user.
3) configure datasource if you use tomcat for users database
Continuum 1.1-alpha-1 on MySQL
Due to problems with creating tables on first Continuum execution 1219 one table for 'continuum' database should be created manually:
| No Format |
|---|
CREATE TABLE `PROJECT` ( `ID` INTEGER NOT NULL, `ARTIFACT_ID` VARCHAR(256) BINARY NULL, `BUILD_NUMBER` INTEGER NOT NULL, `CHECKOUT_RESULT_SCMRESULT_ID_OID` BIGINT NULL, `DESCRIPTION` VARCHAR(8192) BINARY NULL, `EXECUTOR_ID` VARCHAR(256) BINARY NULL, `GROUP_ID` VARCHAR(256) BINARY NULL, `LATEST_BUILD_ID` INTEGER NOT NULL, `MODEL_ENCODING` VARCHAR(256) BINARY NULL, `NAME` VARCHAR(256) BINARY NULL, `OLD_STATE` INTEGER NOT NULL, `PARENT_PROJECTDEPENDENCY_ID_OID` BIGINT NULL, `PROJECT_GROUP_ID_OID` INTEGER NOT NULL, `SCM_PASSWORD` VARCHAR(256) BINARY NULL, `SCM_TAG` VARCHAR(256) BINARY NULL, `SCM_URL` VARCHAR(256) BINARY NULL, `SCM_USE_CACHE` BIT NOT NULL DEFAULT 0, `SCM_USERNAME` VARCHAR(256) BINARY NULL, `PROJECTSTATE` INTEGER NOT NULL, `URL` VARCHAR(256) BINARY NULL, `VERSION` VARCHAR(256) BINARY NULL, `WORKING_DIRECTORY` VARCHAR(256) BINARY NULL, `PROJECTS_INTEGER_IDX` INTEGER NULL, PRIMARY KEY (`ID`) ) ENGINE=INNODB; |