SMS gateways

Here we consider some of the most popular SMS gates such as Twilio, Nexmo and SMSTraffic and tell about its correct setup. Also this document describes on how to use SMPP with Navixy.

All settings for SMS gateway are located in the ‘sms_gates’ table of ‘google’ database. Main settings are in JSON format. Navixy system can work with several sms gates simultaneously.

Another database table that identifies which sms gate corresponds to a dealer is ‘sms_gates_to_dealers’ table.

Database ‘table sms_gates’ has some rows of major interest for us: type, provider, params, enabled. These rows will be added and updated. You can type in mysql monitor

> describe google.sms_gates;
> describe google.sms_gates_to_dealer.

to see details:

mysql> describe sms_gates;
+--------------+---------------------+------+-----+---------+----------------+
| Field        | Type                | Null | Key | Default | Extra          |
+--------------+---------------------+------+-----+---------+----------------+
| id           | int(11) unsigned    | NO   | PRI | NULL    | auto_increment |
| owner_id     | int(11)             | YES  |     | 1       |                |
| label        | varchar(255)        | YES  |     |         |                |
| type         | varchar(32)         | NO   |     | NULL    |                |
| provider     | varchar(32)         | NO   |     | NULL    |                |
| params       | text                | NO   |     | NULL    |                |
| enabled      | tinyint(4) unsigned | NO   |     | 1       |                |
| class_filter | varchar(255)        | NO   |     | *       |                |
+--------------+---------------------+------+-----+---------+----------------+

What these rows mean

  • id – is an identifier of the SMS gate. While you are adding new sms gate this value is being incremented if this field is empty
  • owner_id – points to a dealer’s id (table ‘dealer_id’)
  • label – is the name of the SMS gate
  • type – may be transmitter, transceiver, or receiver
  • provider – name of your sms provider
  • params – main settings in JSON. The ‘params’ is described below for some well-known providers.
  • enabled – may be 0 or 1 (0 is disabled, 1 is enabled)
  • class_filter – indicates what type of messages this gate can process. Possible values are notifications (in case gateway works only with notifications), commands (if gateway processes only commands), asterisk(*) (by default, this means that gateway can work either with notifications or with commands). Also it is possible to add minus sign(-) to the value (-notification or -command) to revoke the right

If you have more questions please contact our support team

Contacts

USA: +1 858 815 9045

Mexico: +52 334 1642158

UK: +44 808 1641499

Germany: +49 1573 5988250

Russia: +7 495 223 0427

Log in

Login

[clean-login]

CLOSE
Register

[clean-login-register]

CLOSE
Loading...