- Ozeki 10
- Ozeki NG SMS Gateway
- Ozeki 10 SMS gateway
- SMS protocol converters
- SMS router
- Message Server 6
- SMS Wall
- IP SMS Gateway
- Android SMS
- Excel SMS
- Bulk Messenger
- Cluster Software
- Developer tools
Database Plugin Configuration for MySql
Configure your ODBC data source. Go to Control Panel and then click on Administrative Tools and then click on Data Source (ODBC)
Click on User DSN Tab (by default it is on that) and click Add as shown in the figure above.
Scroll down and select the 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.
Install the OZEKI SMS Server. You can read the installation instructions at the installation manual.
After the installation, activate the Database plugin :
Select Install plugins from the menu
Select Database from the combo-box and hit the Install button. Once the plugin is activated you can configure it.
Configure the database connection in Ozeki SMS. You can do this by clicking on the Configure button at the plugin activation form.
On the Database Settings form, click on the Build database connection button. This will bring up the connection selection dialog.
On the connection tab, you can specify the ODBC datasource: mybuddy, and you can supply the login name and the password:
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.
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.
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.
When the database plugin is configured, you can start the software by clicking on Start in the main window.
You can check the database connection status once the application was started by clicking on the database connection item in the Plugins menu.
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.