Setup Sybase (SQL Anywhere)
for logging PBX events

In this chapter you can learn how to log PBX events of Ozeki Phone System XE using a Sybase (SQL Anywhere) 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 Sybase (SQL Anywhere) database.

If you would like to save the PBX events with Sybase (SQL Anywhere) database server, follow this detailed guide.

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

OleDb

You should use the next database connection string:

Provider=ASAProv.90;UID=MyUsername;PWD=MyPassword;DatabaseFile=DatabaseFileLocationOnYourComputer.db;
EngineName=Yourdbenginename;Start=YourDatabaseBinaryLocation.exe -c 32M;AutoStop=Yes

The previous database connection string have 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 Sybase (SQL Anywhere) 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: 

-- -----------------------------------------------------
-- Table `OzekiPBX`.`ozpbxlog`
-- -----------------------------------------------------
CREATE TABLE "ozpbxlog" (
  "id" integer NOT NULL DEFAULT autoincrement,
  "Time" datetime NOT NULL,
  "Thread" integer NOT NULL,
  "LogLevel" varchar(20) NOT NULL,
  "Logger" varchar(255) NOT NULL,
  "Message" text NOT NULL,
  PRIMARY KEY ("id")
)

go 
commit work 
go

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

People who read this also read...

More information