Welcome page
Ozeki 10
Ozeki NG SMS Gateway
Message Server 6
SMS Wall
IP SMS Gateway
SMPP Installation
UCP Installation for Windows
Android SMS
Excel SMS
Bulk Messenger
Developer tools

SMS sending over the Internet: UCP/Emi2 - SQL gateway

General overview:

This application can be used to send and receive SMS messages. The software uses the UCP/Emi2 protocol to communicate with the SMS Service Center (SMSC) of the GSM provider. The incoming messages are stored by the application in a database (e.g.: MySql,PostgresSql, Sybase,etc...) table. If we would like to send an SMS all we have to do is create a record in another database table.


- Only one process is activated
- it handles status reports
- can be run by any user account, no administrator privileges are need,
- runs as a daemon
- creates a log file

The package contains the following components:

ucp.pl The main application, that communicates with the service provider and the local database server.
ucp_conf.pl A configuration text file, which contains all the information needed to connect to the SMSC and the database
smstables.sql The database table definition for MySql database servers

Installation instructions:

The installation is very simple procedure. As a first step, download the ucp.pl and then ucp_conf.pl scripts. After this you must create the database table definitions with the help of the smstables.sql file.

Before you start the application, you must modify the ucp_conf.pl file to reflect the settings of your system. You must set the following parameters:
(db_name, db_user, db_password, remote_host, remote_port).
The logfile-t and the pidfile-t should be specified with a fully qualified path, especially if the ucp script is executed by crontab or other system service.

To start the application issue the following command:
ucp.pl start ucp_conf.pl

To stop:
ucp.pl stop ucp_conf.pl

To restart:
ucp.pl restart ucp_conf.pl

The application can be ran in debug mode. In this case the logging is displayed on the screen. in this case use the following command to start the application
ucp.pl start ucp_conf.pl -d
to stop the program, when is running in debug mode press CTRL-C.


After the application is configured and started, please take a look at the log file. In the log file, you can see wether the connection to the SMSC was successful. Once the connection is working, you can send a message by issuing the following SQL statement:

"insert into ozekismsout (sender,receiver,msg,status) values ('0036209937723','0036203105366','test sms','send');"

Important! Do not use the + sign at the phone numbers, because the ucp server at the service provider can`t handle these numbers. Numbers may contain only digits.

if you look at your log file, you will see a notice when the messge is sent. In addition to this the status of the database record is changed to 'sent' to let you know, that the message is transmitted.


Copyright © 2000- - Ozeki Ltd | info@ozeki.hu | Tel: +36 1 371 0150
Home > Products > SMS > IP SMS Gateway > UCP
Legal | Privacy policy | Terms of use
Page: 264 | Login |