This page demonstrates the MySQL addressbook type available in
Ozeki NG SMS Gateway. Please read this description page and follow the screen
shots to learn the various types and their functions.
In this example I login as user admin to Ozeki NG SMS
Gateway. To be able to configure the addressbook, click on the respective
user (Figure 1).
Figure 1 - Click on the user
Click on Configure and select Advanced tab on the
configuration pane (Figure 2).
Figure 2 - Select Advanced tab
In the section called Addressbook, specify the
Type of Addressbook.
SQL Addressbook
You can select SQL Addressbook type on Advanced
tab (Figure 3). In this case contacts will be stored and uploaded from an SQL
database.
Figure 3 - SQL addressbook
To configure the addressbook, click on Configure and on
Addressbook configuration. On Connection information tab you can
specify the Connection string with which the system connects to the
database (Figure 4).
Figure 4 - Connection string
MySQL also requires Odbc as Connection string type, which can also
be selected on Connection information tab (Figure 5).
Figure 5 - Connection string type
First you need to create database tables:
MySQL
You can connect to MySQL with this connection string: