Setup FoxPro
for logging PBX events
In this chapter you can learn how to log PBX events of Ozeki Phone System XE using a FoxPro 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 FoxPro database.
If you would like to save the PBX events with FoxPro database server, follow this detailed guide.
During the configuration you have the chances to use OleDb or Odbc connection types.
In case of the OleDb connection you need to choose OleDb type:
Connection string for OleDb connection:
If you use Odbc connection type, you need to select Odbc connection type:
Connection string for Odbc driver:
The 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 FoxPro 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 I AUTOINC NEXTVALUE 1 STEP 1 PRIMARY KEY,
Time T NOT NULL,
Thread I NOT NULL,
LogLevel C(20) NOT NULL,
Logger C(255) NOT NULL,
Message N NOT NULL)
If you have any questions or need assistance, please contact us at info@ozekiphone.com.
Dig deeper!
People who read this also read...