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

OZEKI NG SMS Gateway - Product Guide

MSSQL 2012/2014 Contents | SearchImport messages

Home > Product Manual > Installation Guide > Installation Steps > System database > MySQL configuration

SMS Gateway Home

 


Automated phone calls?
Ozeki Phone System XE VoIP PBX software is an advanced PBX built for automated voice calls and 2 way SMS messaging. It has outstanding APIs for software developers. It can be used for:

Phone calls from SQL
Phone calls from HTTP
Voice and SMS applications

Callcenter developers
If you are working on telephone solutions, please check out the Ozeki VoIP SIP SDK.
It can be used to create VoIP client and server software.

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.

If you wish to use MySQL as the system database please configure the following SQL templates in the Server preferences form:

The database connection type, you should choose is:

Odbc

The database connection string you should use is:

Driver={MySQL ODBC 5.1 Driver};Server=127.0.0.1;Database=ozekisms;User=ozeki;Password=abc123;Option=4;

Create

CREATE TABLE IF NOT EXISTS $tablename (`messageid` VARCHAR(60) NOT NULL,
`createdate` DATETIME NULL,`serializedmessage` TEXT NULL,PRIMARY KEY(`messageid`));

Load index

SELECT messageid FROM $tablename

Load

SELECT messageid,serializedmessage FROM $tablename WHERE messageid IN ($idlist)

Save

INSERT INTO $tablename (messageid,createdate,serializedmessage) values ('$messageid',now(),'$serializedmessage')

Delete

DELETE FROM $tablename WHERE messageid IN ($idlist)

Move

INSERT INTO $tablename (messageid,createdate,serializedmessage) SELECT messageid,
createdate,serializedmessage FROM $sourcetable WHERE messageid IN ($idlist)

Find old

SELECT messageid FROM $tablename WHERE createdate<DATEADD(now(), INTERVAL -$maxage SECOND)

Delete old

DELETE FROM $tablename WHERE createdate<DATEADD(now(), INTERVAL -$maxage SECOND)

More information





Next page: Import messages
Copyright © 2000- - Ozeki Ltd | info@ozeki.hu
Home > Product Manual > Installation Guide > Installation Steps > System database > MySQL configuration
Legal | Privacy policy | Terms of use
Page: 2894 | Login | 18.206.187.81