July 26, 2021

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: https://www.techmion.com/ 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 *

close

Ad Blocker Detected!

VEDANT EXPLAINS
We've noticed that you are using an ad blocker. Advertising helps fund our server cost and keep it truly independent. It helps to build our content creator team. So please disable your ad blocker, and help us to keep providing you with free- great content - for free. Thank you for your support.

Refresh