Setup Amazon SimpleDB
for logging PBX events

In this chapter you can learn how to log PBX events of Ozeki Phone System XE using an Amazon SimpleDB database server. In this guide you can see the installation steps, the database connection string, the database connection type and the recommended database table layout for Amazon SimpleDB database.

If you would like to save the PBX events with Amazon SimpleDB database server, follow this detailed guide.

During the configuration you should choose the following database connection type:

Odbc

You should use the next database connection string:

Access Key=your_access_key;Secret Access Key=your_secret_access_key

The previous database connection string has to be modified to match your database.

The connection string and the connection type should be entered on the Database Logging SQL API configuration form.


Figure 5 - Specifying the connection string for the Amazon SimpleDB database

In the following figure you can see the SQL templates tab of the Database logging API. Here, you need to provide the SQL queries that will store PBX events.


Figure 6 - Specifying the SQL queries for storing PBX events

After the Database Logging SQL API has been configured in the Ozeki Phone System XE, you need to create the database tables for Database Logging SQL API. Use the following table layout:

  • ozpbxlog table
Name Type
id int (primary key, auto increment)
Time datetime
Thread int
LogLevel varchar(20)
Logger varchar(255)
Message text

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