Setup PostgreSQL for storing call records

In this chapter you can learn how to configure the Ozeki Phone System to be able to store call records using a PostgreSQL database server. You will be provided with the installation steps, the configuration details such as the database connection string, database connection type, and with the recommended database table layout.

To be able to store calling information to a PostgreSQL database, you need to configure the Call reporter SQL API in the Ozeki Phone System in the following way.

As the PostgreSQL database requires Open DataBase Connectivity (ODBC), select Odbc in the Connection string type dropdown menu. The Odbc driver for PostgreSQL can be available at the following webpage: http://pgfoundry.org/projects/psqlodbc/.

Odbc

Replace the default database connection string with the one for the PostgreSQL database in the Connection string template:

DRIVER={PostgreSQL};SERVER=YourServerIP;port=5432;DATABASE= YourDatabaseName;UID=YourUsername;PWD=YourPassword

Modify the variables in the connection string according to your needs.

In the following figure you can see the SQL templates tab of the Call reporting API. Here, you need to provide the SQL queries that will store the main changes of the calls (e.g. when a call started, forwarded or finished).

specifying sql queries
Figure 1 - Specifying the SQL queries

After the Call Reporter SQL API has been configured in the Ozeki Phone System, the only thing left to do is to create the database tables for Call Reporter SQL API. We recommend you to use the following table layout: 

CREATE TABLE `ozpbxcalls` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `starttime` datetime DEFAULT NULL,
  `source` varchar(150) DEFAULT NULL,
  `callerid` varchar(150) DEFAULT NULL,
  `dialed` varchar(150) DEFAULT NULL,
  `destination` varchar(150) DEFAULT NULL,
  `duration` int(10) DEFAULT NULL,
  `callstate` varchar(150) DEFAULT NULL,
  `recordurl` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`id`)
)

If you have any questions or need assistance, please contact us at info@ozekiphone.com.

Dig deeper!
People who read this also read...

More information