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

 


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 | Terms of use | 2894
3.226.248.180 | 92.118.27.157 | Login