CMDBuild Forum

Openmaint Installation Guide for Debian (Here)

Installing openMAINT

 

Install Java

Once connected to server open a new terminal and type sudo apt-get update this will ensure Linux repositories are fully updated ready for install. Java 8, this is not in the repository so we need to add it and then update again to be able to install. Type the following command into the terminal

$ sudo nano /etc/apt/sources.list.d/java-8-debian.list

This will create a new document type the following two lines and save

deb http://ppa.launchpad.net/webupd8team/java/ubuntu trusty main

deb-src http://ppa.launchpad.net/webupd8team/java/ubuntu trusty main

save the document and exit back to root

We now need to import the GPG key on your system for validate packages before installing can be done. Type the following commands

$ sudo apt-key adv –keyserver keyserver.ubuntu.com –recv-keys EEA14886

$ sudo apt-get install oracle-java8-installer

$ sudo apt-get install oracle-java8-set-default

Install Tomcat 7

We have to install Tomcat 7 over 8 as has greater stability, type the following into the terminal

$ sudo apt-get install tomcat7 tomcat7-admin

This will install Tomcat web server and the administration program



 

Configure Tomcat 7

Run performance tweaks on Tomcat installation above to improve performance

https://blog.layer4.fr/2013/09/03/installing-tomcat-7-on-debianubuntu/

Stop the tomcat7 service as we will be editing configuration files

$ sudo /etc/init.d/tomcat7 stop

Change tomcat 7 user and security settings now service has stopped

$ sudo nano /etc/tomcat7/tomcat-users.xml
 
add in-between <tomcat-users> … </tomcat-users>
 
<role rolename=”manager”/>
<role rolename=”manager-gui”/>
 
Create username and password for tomcat 
 
<user username=”admin” password=”admin” roles=”manager-gui, manager”/>
 
CTRL-O to save
CTRL-X to exit
 
$ sudo nano /etc/default/tomcat7

uncomment JAVA_HOME and change to JAVA_HOME=/usr/lib/jvm/java-8-oracle – this will ensure Tomcat7 uses the newly installed Java8

uncomment the “TOMCAT6_SECURITY=no”

uncomment the “LOGFILE_DAYS=14” line to keep logfiles to: /var/log/tomcat7



 

Install PostgreSQL and PostGIS

PostgreSQL 9.4 is the database openMAINT will use and PostGIS is for geo-reference. We need to add the repository to Linux before install 

$ sudo add-apt-repository "deb https://apt.postgresql.org/pub/repos/apt/ jessie-pgdg main"

$ wget --quiet -O - https://postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -

Once the above commands have been ran we can update Linux

$ sudo apt-get update

And finally install

$ sudo apt-get install postgresql-9.4 pgadmin3

Configure PostgreSQL

We have to change the super user password; follow commands below
Log in using $ sudo -u postgres psql template1
Once logged in run the below code
 
$ ALTER USER postgres WITH PASSWORD 'INSERT_PW_HERE'; 
 
The password entered must be remembered and kept secure
 
Exit out of PostgreSQL using $ \q
 
Open pgAdmin from menu
 
Create a new server and add details as shown below
 
null
Enter password created in last step and click OK
 
Create a new database by right clicking on Databases and choosing New Database enter the following details
null
Click OK
The database has now been install and needs to be configured before use to ensure Geo-referencing works.
Ensure the database is clicked and highlighted and from the main menu in pgAdmin click Plugins -> PSQL Console. A new terminal window will open add the following lines of code. Changing PostGIS directory and database name.
# CREATE schema gis;
# SET SEARCH_PATH TO gis, public, shark;
# \i ${POSTGIS_DIR}/postgis.sql
# \i ${POSTGIS_DIR}/spatial_ref_sys.sql 
# ALTER DATABASE ${DB_NAME} SET search_path="$user", shark, public, gis;
/q to exit
 
The system is now setup and configured for the installation of OpenMaint
 
 



 

Install openMAINT WAR

Download

http://www.openmaint.org/en/download/download
Click download from sourceforge
Once downloaded extract in downloads folder

Database restore

In pgAdmin right click on the newly created database and choose restore, and choose from the following database in openMAINT folder 
Demo, Empty, GIS or use a database you have saved before

Libraries

Copy libraries across to tomcat7 to do this we must rename “6.0 higher” to “6” in folder found below
 /home/osboxes/downloads/openmaint-1.1-2.4.2/extras/tomcat-libs/
Simply type the following to copy a required file from openmaint folder to Tomcat7
Sudo cp /home/osboxes/Downloads/openmaint-1.1-2.4.2/extras/tomcat-libs/6/postgresql-9.4.1207.jar /usr/share/tomcat7/lib

Download JDBC  (9.4.1212.jar) from ww.jdbc.postgresql.org/download.html

And as above copy to the tomcat7 lib folder

 

Sudo cp /home/osboxes/Downloads/postgresql-9.4.1212.jar /usr/share/tomcat7/lib
 

 



 

WAR files

Rename the two war files in openMAINT folder to openmaint and shark
Ensure the tomcat server is stopped
Move both war files to tomcat webapps folder
Sudo cp /home/osboxes/Downloads/openmaint-1.1-2.4.2/openmaint.war /var/lib/tomcat7/webapps/
Sudo cp /home/osboxes/Downloads/openmaint-1.1-2.4.2/shark.war /var/lib/tomcat7/webapps/
Start tomcat7 
This will automatically deploy the war files after a few minutes they should both be fully deployed. 
Log in to localhost:8080/manager to ensure both shark and openmaint are running, if all okay
log in to localhost:8080/openmaint
All being well the system should now be up and running and a few setup pages will now need to be completed
 
 
 
 
 
 



 

Setup openMAINT

The 1st one you simply choose a language and click next
null
Next step is the database screen this will connect to the newly installed and created user in postgresql
null
Choose database existing
Enter name as openmaint (If this is what you used above)
Database connection properties are as follows
Host: Localhost
Port: 5432
Super User: postgres
Password: Admin ß depends what was given in setup
Click test connection, if successful click finish and then click ok, you will now be ready to log in, using either admin admin or demouser
null
The system is now configured and simply needs a user name and password to be chosen for the super user (site admin)

 

 



 

Shark configuration

Stop the Tomcat7 service

Edit (/var/lib/tomcat7/webapps/cmdbuild-shark/META-INF/context.xml) per the manual. I change the URL to represent my database name. I don't change any other value. Screenshot: http://i.imgur.com/2Rw7g3D.png

Edit (/var/lib/tomcat7/webapps/cmdbuild-shark/conf/Shark.conf) per the manual. I change the org.cmdbuild.ws.url setting to equal my CMDBuild site address. I leave the usename and password as they were. I don't change anything else. Screenshot: http://i.imgur.com/cjkWEou.png

Edit (/var/lib/tomcat7/webapps/cmdbuild/WEB-INF/conf/auth.conf). I remove the comment from the line: serviceusers.prigileged=workflow. Screenshot: http://i.imgur.com/SAgIV0H.png

Start the Tomcat Server using sudo /etc/init.d/tomcat7 start.

Log in and enable the Workflow server and change URL to the Shark deployment. Do not change the username or password.

Create a new user named "workflow" if not already created with the password "changeme". This matches the default values for username and password in the Shark.conf file 

Change the owner of the Shark schema in the DB to the shark user. In case previously owned by the postgres user. Make sure Workflow user is only tied to one user group in the users model of OpenMAINT

Alfresco Document Management

If you require document management use the following online guides
Next step is install and connecting Alfresco used for document management

Use WordPress guides

http://dl.alfresco.com/release/community/build-3370/alfresco-community-3.4.d-installer-linux-x64.bin

https://kickingtech.wordpress.com/2014/05/26/alfresco-community-edition-4-2-step-by-step-manual-installation/

Hi.  I am following through this guide and thanks for that :)  The only thing is the pictures from your post are not showing up and there is not enough information to know where to go next.  From the pgAdmin portion on.  Anyway to get them?  Thanks
Did you find a solution for this as I am having the same issue?
I'm stuck since the pictures won't load.
 
Previously Garry wrote:
Hi.  I am following through this guide and thanks for that :)  The only thing is the pictures from your post are not showing up and there is not enough information to know where to go next.  From the pgAdmin portion on.  Anyway to get them?  Thanks