October 14, 2019

How to install kannel addons SqlBox

Open Terminal

Go to the directory where is your gateway.

Then type

#cd addons

#cd sqlbox

Then just run the command as given below:-

# ./configure

# make

# make install

Congrats sqlbox has been installed.

Now you need to create sqlbox configuration file in /etc/kannel directory

create sqlbox.conf file in the /etc/kannel directory

Copy and paste the sqlbox.conf file as follows:-

Sqlbox.conf

group = sqlbox

id = mydlr

smsbox-id = sqlbox

#global-sender = “”

bearerbox-host = 127.0.0.1

bearerbox-port = 13001

smsbox-port = 13006

smsbox-port-ssl = false

sql-log-table = sent_sms

sql-insert-table = send_sms

log-file = “/etc/kannel/kannel-sqlbox.log”

log-level = 0

#ssl-client-certkey-file = “”

#ssl-server-cert-file = “”

#ssl-server-key-file = “”

#ssl-trusted-ca-file = “”

# Database connection examples. Please uncomment as needed

# Example MYSQL Connection

group = mysql-connection

id = mydlr

host = localhost

username = root                //database username

#password = 121123

password = 12345             //database password

#database = test

database =sms      //database table name

max-connections = 10

group = dlr-db

id = mydlr

table = dlr        //change as per your database table

field-smsc = smsc

field-timestamp = ts

field-source=source

field-destination = destination

field-service = service

field-url = url

field-mask = mask

field-status = status

field-boxc-id = boxc

Now start the sqlbox by the following command:-

# /usr/local/sbin/sqlbox -v 0 /etc/kannel/sqlbox

Vedant Singh

Linux System Administrator | Entrepreneur | Founder Techmion. I have started my career as a Linux system Administrator after that quit my job to start something new that excites me and started a Tech Company in order to provide the best technology to my clients. My Company website link: Technology at its best For Bulk, SMS-Marketing follows the link : https://www.pingsms.in/

View all posts by Vedant Singh →

Leave a Reply

Your email address will not be published. Required fields are marked *