Ozeki NG SMS Gateway

MySQL Script | Access

PostgreSQL create table script

Introduction

To create an SQL SMS Gateway with Ozeki NG, you can use a PostgreSQL database, which can be accessed using an ADO or ODBC driver. All you have to do is create two database tables (in the ozekisms database): ozekimessagein and ozekimessageout. (The tables can have additional columns.) Ozeki NG - SMS Gateway will insert incoming messages into the ozekimessagein table. If you want to send a message, you should insert a record into the ozekimessageout table. The SMS Server periodically checks this table for messages to send.

Creating the database and the tables

Start pgAdmin: Start menu -> All Programs -> PostgreSQL 8.2 -> pgAdmin III. Right-click PostgreSQL Database Server 8.2, and left-click Connect. Then, fill in the password field and connect.

Figure 2 - Fill in the Name and the Encoding field

Figure 3 - Creating Tables

Figure 4 - Execute query

CREATE TABLE ozekimessagein
(
  id serial,
  sender varchar(30),
  receiver varchar(30),
  msg varchar(1024),
  senttime varchar(100),
  receivedtime varchar(100),
  operator varchar(100),
  msgtype varchar(160)
);

CREATE TABLE ozekimessageout
(
  id serial,
  sender varchar(30),
  receiver varchar(30),
  msg varchar(1024),
  senttime varchar(100),
  receivedtime varchar(100),
  status varchar(20),
  operator varchar(100),
  msgtype varchar(160)
);

Figure 5 - Create a user

Figure 6 - Creating a Login Role

Figure 7 - Enter the Role Name and Password

Figure 8 - Execute query

Copy the following text into the window, and click "Execute query":

grant select,update,insert,delete on ozekimessagein to sqluser;
grant select,update,insert,delete on ozekimessageout to sqluser;
grant update on ozekimessagein_id_seq to sqluser;
grant update on ozekimessageout_id_seq to sqluser;

We need the last 2 rows to access the serial ids.

Figure 9 - Grant rights

In Ozeki NG the connection string type will be "Odbc" and the connection string will be:

DRIVER={PostgreSQL Unicode};Server=localhost;Database=ozekisms;uid=sqluser;Password=abc123;

More information

• Database Link Management
• MySQL SMS Script
• PostgreSQL SMS Script
• Access SMS
• Oracle SMS Script
• SMS Recipient list
• Appendix
• Feature list of Ozeki NG SMS Gateway
• FAQ of the Ozeki NG SMS Gateway

MySQL Script | Access