Setup PostgreSQL for authenticating extensions

In this chapter you can learn how to authenticate SIP extensions using a PostgreSQL database server with your Ozeki Phone System. You can see the installation steps, the database connection string, the database connection type and the recommended database table layout for PostgreSQL database.

After you have followed this guide, you will be able to authenticate SIP extensions with PostgreSQL database server.

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.

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

specifying connection string for postgresql database
Figure 1 - Specifying the connection string for the PostgreSQL database

The following figure shows the SQL queries that allow you to verify if a SIP account is available or not in your database.

sql queries for authenticating
Figure 2 - SQL queries for authenticating

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

-- -----------------------------------------------------
-- Table `OzekiPBX`.`ozpbxusers`
-- -----------------------------------------------------
CREATE TABLE ozpbxusers
(
    authname varchar(45) PRIMARY KEY,
    username varchar(45) NOT NULL,
    password varchar(45) 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...

More information