Vertabelo In-House Installation Guide

This installation guide covers installation of Vertabelo In-House edition on your computer.

Requirements

You'll need the following software:

  • Linux based system (e.g., Ubuntu/Debian) (ubuntu.com),
  • PostgreSQL database at least version 9.1 (postgresql.org),
  • Oracle Java JDK 32-bit edition at least version 6 (oracle.com).

PostgreSQL setup

Vertabelo uses PostgreSQL as its data store.

Installation

On Debian/Ubuntu system call:
sudo apt-get install postgresql postgresql-client

On Redhat/Fedora/CentOS follow these instructions: PostgreSQL on Fedora.

Setup

Check if PostgreSQL parameter max_prepared_transactions is greater than 0 (100 for example). Here is how you can do it:

  1. Switch to root account:
    su -
    
  2. Open file /etc/postgresql/9.1/main/postgresql.conf (on Debian/Ubuntu note the version number in the path) or /var/lib/pgsql/data/postgresql.conf(on Redhat/Fedora/CentOS).
  3. Find max_prepared_transactions parameter, and change it:
    max_prepared_transactions = 100 
    
  4. Save the file and exit your text editor.
  5. Restart PostgreSQL to apply the changes.
    service postgresql stop
    service postgresql start
    

Database instance

Now it's time to create a database where Vertabelo will store your models.

  1. Switch to root account
    su - 
    
  2. Switch to postgres account
    sudo su - postgres
    
  3. Run PostgreSQL command line client:
    psql
    
  4. Create a database user with password vertabelo. You should pick a more secure password in production environment.
    create user vertabelo with password 'vertabelo';
    
  5. Create a database instance
    create database vertabelo owner vertabelo encoding 'utf-8';
    
  6. Done.

Java setup

Vertabelo uses Oracle JDK version Java 6 or greater. Other Java versions will not work. Make sure that JAVA_HOME environment variable point to the correct Java. Simply call:

$JAVA_HOME/bin/java -version
You should get similar output:
java version "1.6.0_35"
Java(TM) SE Runtime Environment (build 1.6.0_35-b10)
Java HotSpot(TM) Server VM (build 20.10-b01, mixed mode)
If the JAVA_HOME variable is not set, point it to your JDK installation directory. For example:
export JAVA_HOME=/usr/local/jdk1.7.0_60

Vertabelo installation

  1. Unpack the zip archive.
    unzip Vertabelo-1.10.zip
    cd Vertabelo-1.10
    
  2. Launch setup utility:
    ./setup.sh 
    
    You'll be asked a few questions. Press ENTER if you accept the default value.
  3. General questions:
    • Company name - name of your company or team. This name will idenfify this Vertabelo installation.
    • Application URL - URL of this application, without the trailing slash. This URL is used in outgoing email as the prefix for notifications.
    • Administrator name - name of the person who will manage Vertabelo. If in doubt put your name here.
    • Administrator email - email of the person who will manage Vertabelo. System messages will be sent to this email. This email will also be administrator login.
  4. Database connection parameters. If PostgreSQL is installed on your computer and you followed instructions in PostgreSQL setup section, simply accept the default values.
    • Database server name - host name or IP address of PostgreSQL. Press ENTER if PostgreSQL is installed on your computer.
    • Database server port number - port number of PostgreSQL. See above.
    • Database user name - database user who is the owner of Vertabelo database
    • Database user password - password of the user described above
    Setup will try to connect to the database. If it fails for any reason, an appropriate message will be shown and you'll be able to alter parameters.
  5. Vertabelo sends some messages via email. You'll need to configure a SMTP server. Default configuration uses SMTP server on your computer. It is a rare to have one installed. Ask your company administrator for address.
    • SMTP server name - host name or IP address of SMTP server
    • SMTP server port - port number of SMTP server
  6. Setup utility will pour initial data to the database. If everything will be OK you'll get login and password:
    Updating administrator account:
        login: admin@example.com
     password: 123123132123
    
  7. Done.

Vertabelo starting and stopping

Starting Vertabelo:

  1. Run the start script:
    ./start.sh
    
    Output will looks like this:
    Waiting for Vertabelo to start ..........................
    11:03:46,130 INFO  [ServerImpl] JBoss (Microcontainer) [5.1.0.GA (build: SVNTag=JBoss_5_1_0_GA date=200905221053)] Started in 30s:707ms
    
    Vertabelo is ready.
    Launch Chrome and visit: http://localhost:8010/
    
  2. Application is available here http://localhost:8010

Stopping Vertabelo:

  1. Run the stop script:
    ./stop.sh
    
  2. Done

Advanced deployment

If you have any problem with deployment in Apache or another HTTP server contact us at contact@vertabelo.com.

Rafał Strzaliński July 16, 2013
 
 

Try our online database modeler. No registration. No commitments.

 
 
Tags
 
Subscribe to our newsletter

If you find this article useful, join our weekly newsletter to be notified about the latest posts.