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.

System database

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)






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 | 34.231.21.83