Database Plugin Configuration for MySql

Step 1

Download the MyODBC database driver. You can download it from http://www.mysql.com/downloads/api-myodbc-2.50.html or from our server:

MyODBC 2.50.39 - 95/98/Me full setup (1.5M)
MyODBC 2.50.39 - NT/2000/XP full setup (1.5M)

Step 2

Install the downloaded MyODBC database driver by executing setup.exe. You need Winzip to unpack the downloaded file.

Step 3

Configure your ODBC data source. Go to Control Panel and then click on Administrative Tools and then click on Data Source (ODBC).

add new data source
Figure 1 - Add new data source

Click on User DSN Tab (by default it is on that) and click Add as shown in the figure above.

select the data source
Figure 2 - Select the data source

Scroll down and select the MySQL ODBC Driver.

select mysql odbc driver
Figure 3 - Select MySQL ODBC Driver

In the MySQL ODBC driver configuration enter the details as can be seen in the figure above(in the database name enter your database name) and after filling in all the proper fields click on the Test Data Source to check if you have properly configured your Database settings.

Step 4

Install the OZEKI SMS Server. You can read the installation instructions at the installation manual of the Ozeki SMS server.

Step 5

After the installation, activate the Database plugin:

install plugins
Figure 4 - Install plugins

Select Install plugins from the menu.

Database plugin
Figure 5 - Database plugin

Select Database from the combo-box and hit the Install button. Once the plugin is activated you can configure it.

Step 6

Configure the database connection in Ozeki SMS. You can do this by clicking on the Configure button at the plugin activation form.

build database connection
Figure 6 - Build database connection

On the Database Settings form, click on the Build database connection button. This will bring up the connection selection dialog.

select data source
Figure 7 - Select data source

On the connection tab, you can specify the ODBC datasource: mybuddy, and you can supply the login name and the password:

data source properties
Figure 8 - Data source properties

After finishing these settings make sure you test the connection by clicking on the Test Connection button located in the lower right hand corner of the form.

Press OK to finalize your settings.

Step 7

Once the database connections string has been built, make sure you place a checkmark in the checkboxes on the bottom of the Database Settings form to control the behaviour of the database plugin. You can decide to send and/or receive SMS messages. If you want to send messages using a database table you also have to specify the time period the SMS server uses to check the outgoing database table.

database settings
Figure 9 - Database settings

Step 8

If the connection is set you might want to verify the SQL templates used to access that database. These templates can be seen and modified if neccessary on the SQL templates tab of the Database Settings form.

sql templates
Figure 10 - SQL templates

Step 9

When the database plugin is configured, you can start the software by clicking on Start in the main window.

start the database plugin
Figure 11 - Start the database plugin

Step 10

You can check the database connection status once the application was started by clicking on the database connection item in the Plugins menu.

check the connection
Figure 12 - Check the connection

Step 11

If you want to see the SQL statements Ozeki SMS uses to find outgoing messages, please go to Plugins/Database Events. You can also see the SQL queries used to insert and modify the database records here.

database events
Figure 13 - Database events

More information