Contact us LoginLIVE DEMOFREE TRIAL

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 225 46 88

Mexico: +52 558 526 11 25

UK: +44 203 807 64 62

Russia: +7 495 128 35 56

We use сookies to improve our website, products and related services, analyze site traffic, and serve targeted advertisements. If you continue to use our services, you consent to our use of сookies. Read more

Log in