How To Install kannel-sqlbox on Ubuntu 18.04

In this tutorial we learn how to install kannel-sqlbox on Ubuntu 18.04. kannel-sqlbox is SQL helper application for Kannel WAP and SMS gateway

Introduction

In this tutorial we learn how to install kannel-sqlbox on Ubuntu 18.04.

What is kannel-sqlbox

kannel-sqlbox is:

Kannel is a gateway for connecting WAP (Wireless Application Protocol) phones to the Internet. It also works as an SMS/SMPP gateway, for providing SMS based services for GSM phones.

Sqlbox is a special Kannel box that sits between bearerbox and smsbox and uses a database queue to store and forward messages.

Messages are queued on a configurable table (defaults to send_sms) and moved to another table (defaults to sent_sms) afterwards.

You can also manually insert messages into the send_sms table and they will be sent and moved to the sent_sms table as well. This allows for fast and easy injection of large amounts of messages into Kannel.

There are three methods to install kannel-sqlbox on Ubuntu 18.04. We can use apt-get, apt and aptitude. In the following sections we will describe each method. You can choose one of them.

Install kannel-sqlbox Using apt-get

Update apt database with apt-get using the following command.

sudo apt-get update

After updating apt database, We can install kannel-sqlbox using apt-get by running the following command:

sudo apt-get -y install kannel-sqlbox

Install kannel-sqlbox Using apt

Update apt database with apt using the following command.

sudo apt update

After updating apt database, We can install kannel-sqlbox using apt by running the following command:

sudo apt -y install kannel-sqlbox

Install kannel-sqlbox Using aptitude

If you want to follow this method, you might need to install aptitude first since aptitude is usually not installed by default on Ubuntu. Update apt database with aptitude using the following command.

sudo aptitude update

After updating apt database, We can install kannel-sqlbox using aptitude by running the following command:

sudo aptitude -y install kannel-sqlbox

How To Uninstall kannel-sqlbox on Ubuntu 18.04

To uninstall only the kannel-sqlbox package we can use the following command:

sudo apt-get remove kannel-sqlbox

Uninstall kannel-sqlbox And Its Dependencies

To uninstall kannel-sqlbox and its dependencies that are no longer needed by Ubuntu 18.04, we can use the command below:

sudo apt-get -y autoremove kannel-sqlbox

Remove kannel-sqlbox Configurations and Data

To remove kannel-sqlbox configuration and data from Ubuntu 18.04 we can use the following command:

sudo apt-get -y purge kannel-sqlbox

Remove kannel-sqlbox configuration, data, and all of its dependencies

We can use the following command to remove kannel-sqlbox configurations, data and all of its dependencies, we can use the following command:

sudo apt-get -y autoremove --purge kannel-sqlbox

References

Summary

In this tutorial we learn how to install kannel-sqlbox package on Ubuntu 18.04 using different package management tools: apt, apt-get and aptitude.