Existing user: Login
New user: Request a demo

Orderly Telecoms Limited. 3rd Floor 86-90 Paul Street, London, EC2A 4NE
+44 (0)333 543 2107
info@orderlyq.com
Awards
Blog

install-database

OrderlyStats SE - Installation

This page describes the installation process of a Database Engine

FREE INSTALLATION SUPPORT is available for OrderlyStats - so if you get stuck just give us a call or, write in .

OrderlyStats SE is designed to work with either PostgreSQL, or MySQL. Both are open source databases, and both are suitable for small-scale installations, so choose whichever database you are most comfortable with.

PostgreSQL is recommended for larger call centres (greater than 100 agents), or multi-site installations where different sites may be in different time zones (as MySQL does not have adequate time zone support).

Some installations of Asterisk already have a running instance of the MySQL server (e.g. Trixbox). It's safe to use this instance of MySQL for OrderlyStats too (as OrderlyStats will use its own database on the server in this case).

The following installation instructions are for MySQL. You can also switch to instructions for PostgreSQL.
Most Linux distributions have a MySQL package, so we'll use that. You'll need version 4.0 or above - you should get the latest version available for your distribution.

1. MySQL Instructions

Most Linux distributions have a MySQL package, so we'll use that. You'll need version 4.0 or above - you should get the latest version available for your distribution.

YUM-based distributions Including Trixbox, Ubuntu, RedHat/CentOS:

Log in as root, and do a yum update if necessary.

Then issue the following commands

> yum search mysql

This will show you the list of available MySQL packages. To install MySQL, type

> yum install mysql-server

Once MySQL is installed, enter the following commands to start it, and make sure it gets started on system startup:

> chkconfig mysqld on
> service mysqld start

Next we have to configure MySQL for use with OrderlyStats. OrderlyStats uses JDBC to connect to MySQL, which requires a TCP/IP connection. This means that we have to enable TCP/IP.

To do this, we need to edit the MySQL configuration file, my.cnf. The location of this file varies by distribution (on Debian it's in /etc/mysql), but you can find it with

> locate my.cnf

To enable TCP/IP connections, edit my.cnf and find the line that says bind-address = 127.0.0.1. If you're installing OrderlyStats SE on the same machine as MySQL, you can leave this as is. If you're going to access MySQL from other IP addresses, then comment out this line, so MySQL will listen on external IP addresses too, like this: #bind-address = 127.0.0.1

After this step, restart MySQL with /etc/init.d/mysql restart, and check MySQL is listening with telnet localhost 3306

If all is well, you should see the following:

> telnet localhost 3306
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.

There may be some more characters on the screen - that's OK, we're looking for the "Connected to localhost" message above.

Hit CTRL+] and type quit to exit telnet.