Ozeki NG SMS Gateway logo OZEKI NG SMS Gateway
"The World's most reliable SMS gateway software!"

OZEKI NG SMS Gateway - Product Guide

MySQL Script Contents | SearchAccess

Home > Product Manual > Examples and Solutions > SQL SMS Gateway > PostgreSQL script

 


Contact Us!
If you wish to get further information, do not hesitate to contact us!

E-mail: info@ozekisms.com

If you have a technical question, please submit a support request on-line.

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.



create an ozeki sms database



Create the  ozekisms database. Right-click Databases, then left-click New Database.

fill in the name and the encoding field



Fill in the Name and the Encoding field, and click OK.

select the ozekisms database



Select the ozekisms database, and click the SQL icon for creating tables.

execute query



Copy the following text into the window, and click "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)
);


create a user



You have to create a user. It will be named "sqluser" and its password will be abc123.

new login role

select the ozekisms



Select the ozekisms database and click the SQL icon for grant rights.

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.

install odbc driver





When you are finished, you have to install Odbc driver for PostgreSQL.
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;


Dig deeper!
People who read this also read...





Next page: Access
Copyright © 2000- - Ozeki Ltd | info@ozeki.hu
Home > Product Manual > Examples and Solutions > SQL SMS Gateway > PostgreSQL script
Legal | Privacy | Terms of use | 2285
3.237.200.21 | 92.118.27.157 | Login