Hippo CMS 11 Installation with MySQL with GIT

In this tutorial we are going to install and run Hippo CMS version 11. This tutorial is made with Ubuntu 16.04 and requires default knowledge of the operating system.

Initial setup

Lets start with installing the dependencies which are Java 8 and Maven.

1 2	sudo apt-get install openjdk-8-jdk sudo apt-get install maven

Create hippo project with this command

mvn org.apache.maven.plugins:maven-archetype-plugin:2.4:generate \

-DarchetypeRepository=https://maven.onehippo.com/maven2 \

-DarchetypeGroupId=org.onehippo.cms7 \

-DarchetypeArtifactId=hippo-project-archetype \

-DarchetypeVersion=4.2.3

This will ask all kinds of questions that you’ll find the answer from https://www.onehippo.org/11/trails/getting-started/creating-a-project.html.

For this tutorial you can just click enter and the default will be applied.

Adding GIT to project

Now it’s good time to setup git since we have the basic project files on myhippoproject -folder.

git init myhippofolder

cd myhippofolder

git status

git add --all

git commit -m "Initial commit"

Add MySQL

To add MySQL into the project we need to create the actual database for it.

1 2	sudo apt-get install mysql-server Remember to add a root password

echo "CREATE DATABASE myhippoproject;" | mysql -u root -p

echo "CREATE USER 'hippouser'@'localhost' IDENTIFIED BY 'hippouserpassword';" | mysql -u root -p

echo "GRANT ALL PRIVILEGES ON myhippoproject.* TO 'hippouser'@'localhost';" | mysql -u root -p

echo "FLUSH PRIVILEGES;" | mysql -u root -p

Hippo CMS MySQL configuration

Hippo CMS configuration isn’t the best in the world and it’s quite complex and hard to follow. Finding a certain line from the configuration files can be very hard to pay attention when doing this.

First add Resource to conf/context.xml. Notice username, password and url which configure your MySQL credentials for Hippo.

<?xml version='1.0' encoding='utf-8'?>

...

<Resource

name="jdbc/repositoryDS" auth="Container" type="javax.sql.DataSource"

maxTotal="20" maxIdle="10" minIdle="2" initialSize="2" maxWaitMillis="10000"

testWhileIdle="true" testOnBorrow="false" validationQuery="select 1"

timeBetweenEvictionRunsMillis="10000"

minEvictableIdleTimeMillis="60000"

username="hippouser" password="hippouserpassword"

driverClassName="com.mysql.jdbc.Driver"

url="jdbc:mysql://localhost:3306/myhippoproject?autoReconnect=true&characterEncoding=utf8" />

</Context>

Then add conf/repository.xml, the file contains a lot of stuff and mostly unnecessary things for us to know right know, so I’ll just add the file here. Most importantly it represents the place for content to be put on to and it’s configuration.

100

101

102

103

104

105

106

107

108

109

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE Repository

PUBLIC "-//The Apache Software Foundation//DTD Jackrabbit 2.6//EN"

"http://jackrabbit.apache.org/dtd/repository-2.6.dtd">

</DataSource>

</DataSources>

</FileSystem>

</Security>

</FileSystem>

</PersistenceManager>

</SearchIndex>

</Workspace>

</FileSystem>

</PersistenceManager>

</Versioning>

</Journal>

</Cluster>

</DataStore>

</Repository>

Finally we need to modify our pom.xml file to know about our just created repository.xml and MySQL scheme. So do the following changes in pom.xml:

From pom.xml find this:

...

</systemProperties>

</container>

Inside <systemProperties> add:

<repo.config>file:${project.basedir}/conf/repository.xml</repo.config>

And right after the </systemProperties> and just before </container> add this:

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

<classpath>extra</classpath>

</dependency>

</dependencies>

and at the end of the file before </project> add this:

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

<scope>provided</scope>

</dependency>

</dependencies>

Before rushing to the next step you should commit your changes:

1 2	git add --all git commit -m "Add MySQL configuration"

Build & Run

Now lets build our project.

1	mvn clean verify

This downloads some assets and creates the runnable java files. Now we need to create .gitignore file because the created files shouldn’t go to version control. So create .gitignore and add the following in there. Also commit the file in git.

1	/target/

1 2	git add .gitignore git commit -m "Add .gitignore"

Now we are ready to run the project with this command:

1	mvn -Pcargo.run -Drepo.bootstrap=true

The -Drepo.bootsrap=true is there to ensure that we are creating the system from scratch. If you don’t want to do this after the initial setup, you can just omit it.

Try it out

You should now be able to go and see hippo working.

1	http://localhost:8080/cms or http://localhost:8080/site

Happy Hippo CMS:ing!