How to install an Autoreply Database User

Autoreply Database Users are the perfect solution for generating any message depending on the incoming message. These messages are generated from a database. Here you will see how to install and configure an Autoreply Database User from Ozeki SMS Gateway.

What is Ozeki SMS Gateway?

Ozeki SMS Gateway is a high-performance software platform that allows you to send and receive SMS messages using various communication protocols such as SMPP, HTTP, UCP, CIMD, and more. It acts as a bridge between your applications (like CRM systems, websites, or databases) and mobile networks, enabling automated and reliable SMS messaging.

How to install an Autoreply Database User (Quick Steps)

  1. Open the Control Panel
  2. Create a new database connection
  3. Select your database type
  4. Configure and enable the database connection
  5. Go to the SMS Gateway dashboard
  6. Install the Autoreply Database user
  7. Link to the database connection
  8. Edit and enable the autoreply script

How to install an Autoreply Database User (Video tutorial)

In this video, you will learn how to install and configure an Autoreply Database User in the Ozeki SMS Gateway. This user automatically responds to incoming SMS messages based on data retrieved from a connected SQL database. The tutorial shows you how to set up a database connection, install the Autoreply Database User, and write the SQL query that generates replies. By the end of the video, you'll be able to create a smart auto-response system that dynamically replies to messages using your database content - ideal for support bots, information services, or automated replies.

Step 1 - Open Control Panel

Launch Ozeki SMS Gateway and press the Start menu on the bottom left, then go to the Control Panel where you can manage connections and system settings (Figure 1).

Open Control Panel
Figure 1 - Open Control Panel

Step 2 - Create new application connection

Click on Create new connection, then click on Application on the right side to start setting up a new database connection (Figure 2).

Create new application connection
Figure 2 - Create new application connection

Step 3 - Select database

From the available options, choose Database as the type of application connection (Figure 3).

Select database
Figure 3 - Select database

Step 4 - Select SQL queries datbase connection

Select SQL queries to configure a connection that uses SQL queries to retrieve data from your database (Figure 4).

Select SQL queries datbase connection
Figure 4 - Select SQL queries datbase connection

Step 5 - Select database type

Choose the MySQL type of database (Figure 5).

Select database type
Figure 5 - Select database type

Step 6 - Configure database connection

Enter the necessary details: Server, Port, Database, UserID, Password. Save the configuration (Figure 6).

Configure database connection
Figure 6 - Configure database connection

Step 7 - Enable database connection

Activate the connection by enabling it. This makes the database ready for use in auto-reply functions (Figure 7).

Enable database connection
Figure 7 - Enable database connection

Step 8 - Open SMS Gateway

Return to the SMS Gateway dashboard to configure users and messaging features (Figure 8).

Open SMS Gateway
Figure 8 - Open SMS Gateway

Step 9 - Add new user/application

Click on Add new user/application to create a new user that will handle the auto-reply functionality (Figure 9).

Add new user/application
Figure 9 - Add new user/application

Step 10 - Install Autoreply database

From the list of user types, select Autoreply database and click Install to proceed (Figure 10).

Install Autoreply database
Figure 10 - Install Autoreply database

Step 11 - Select database connection

Choose the Database connection you created earlier for use with this Autoreply Database User (Figure 11).

Select database connection
Figure 11 - Select database connection

Step 12 - Configure autoreply script

In the Autoreply script tab, you will see the auto-response script pre-written (Figure 12).

Configure autoreply script
Figure 12 - Configure autoreply script

Step 13 - Create autoreply database connection

Finish the setup by saving the configuration. The Autoreply user is now linked to your database (Figure 13).

Create autoreply database connection
Figure 13 - Create autoreply database connection

Step 14 - Enable autoreply database connection

Enable the user so it can start receiving and replying to messages automatically based on the SQL query (Figure 14).

Enable autoreply database connection
Figure 14 - Enable autoreply database connection

More information