SMS for Linux: SMS - SQL gateway
Installation instructions for MySql database

Download the following files:

Perl Database Modules DBI-1.19.tar.gz
  Msql-Mysql-modules-1.2219.tar.gz
Sql create table definitions createdb.sql
Sms - Sql gateway sms2sql.pl

Create the database tables in the MySql database

echo "create database ozekisms" | mysql mysql
cat createdb.sql | mysql ozekisms

Install the perl modules for DB connection

tar -xzvf DBI-1.19.tar.gz
cd DBI-1.19
perl Makefile.PL
make
make test
make install

cd .. tar -xzvf Msql-Mysql-modules-1.2219.tar.gz
cd Msql-Mysql-modules-1.2219
perl Makefile.PL
make
make test
make install

Start the sms - sql gateway

./sms2sql.pl &

Receive SMS messages

select * from ozekismsin;

Send SMS messages

insert into ozekismsout (receiver,msg,status) values ('+36209937723','test','send')

If you need any kind of help, concact us! (sms@ozeki.hu

 

More information