Re: Need help for opensmpp and SQLBox

Am 18.02.19 09:20, schrieb Loyc Cossou:
> Hi,
>
> It's now been 2 weeks that I am struggling with this configuration.
>
> I am trying to connect OpenSMPPBox to SqlBix so all the messages are
> sent via SQLBox and the DLRs and Logs are available in the database.
>
> Kannel is working fine  as I am able to send SMS.
> SQLBox is also working fine as all the messages I insert in the SEND_SMS
> table are being sent and moved to SENT_SMS.
> And all my clients are able to connect via SMPP and send SMS.
>
> The configuration is like OpenSmppBox and SQLBox are all connected to
> bearearBox, but I need this openSMPP --> SQLBox --> Kannel.
>
> Bellow is my configuration files. Can you please advise on how to modify
> it so i have opensmppbox connected to sqlbox connected to Bearerbox?
> openSMPP --> SQLBox --> Kannel
>
>
> *# Default kannel configuration file*
> *group = core*
> *admin-port = 13000*
> *admin-password = adminuser*
> *status-password = adminpass*
> *admin-deny-ip = "*.*.*.*"*
> *admin-allow-ip = "*.*.*.*"*
> *smsbox-port = 13001*
> *box-allow-ip = "*.*.*.*"*
> *wdp-interface-name = "*"*
> *log-file = "/etc/kannel/log/bearerbox.log"*
> *log-level = 0*
> *dlr-storage = mysql*
> *smsbox-max-pending = 5000*
> *sms-resend-freq = 5*
> *sms-resend-retry = 5*
> *store-location = "/etc/kannel/log/kannel-insms-tmp"*
>
> *# SMSBOX SETUP*
> *group = smsbox*
> *smsbox-id = mysmsbox*
> *bearerbox-host = localhost*
> *sendsms-port = 13013*
> *global-sender = Connectify*
> *log-file = "/etc/kannel/log/smsbox.log"*
> *log-level = 1*
> *access-log = "/etc/kannel/log/Mo_sendSMSRequests.access"*
> *reply-couldnotfetch = "Aucune correspondance pour votre requete"*
> *reply-couldnotrepresent = "Le resultat ne peut etre transmis via SMS"*
> *reply-requestfailed = "Une erreur temporaire est survenue... Veuillez
> ressayer plus tard"*
> *reply-emptymessage = "Aucune correspondance pour votre requete"*
> *http-request-retry = 1*
> *http-queue-delay = 5*
> *max-pending-requests = 5000*
> *#sms-length = 160*
> *#mo-recode = true*
>
> *group = smsbox-route*
> *smsbox-id = mysmsbox*
> *smsc-id = favoriteSMSC*
>
> *# SMSC CONNECTIONS*
> *group = smsc*
> *smsc = smpp*
> *smsc-id = MoovBjSoneb*
> *preferred-smsc-id = MoovBjSoneb*
> *denied-smsc-id = favoriteSMSC*
> *interface-version = 34*
> *host = xxxx*
> *port = 2775*
> *smsc-username = aa*
> *smsc-password = bb*
> *system-type = smpp*
> *address-range = ""*
> *dest-addr-ton = 1*
> *dest-addr-npi = 1*
> *bind-addr-ton = 1*
> *bind-addr-npi = 1*
> *#msg-id-type = 0x00*
> *transceiver-mode = yes*
> *source-addr-autodetect = yes*
> *
> *
> *# SMSC CONNECTIONS*
> *group = smsc*
> *smsc = smpp*
> *smsc-id = favoriteSMSC*
> *preferred-smsc-id = favoriteSMSC*
> *denied-smsc-id = MoovBjSoneb*
> *interface-version = 34*
> *host = xxxx*
> *port = 2775*
> *smsc-username = cc*
> *smsc-password = dd*
> *system-type = smpp*
> *address-range = ""*
> *dest-addr-ton = 1*
> *dest-addr-npi = 1*
> *bind-addr-ton = 1*
> *bind-addr-npi = 1*
> *msg-id-type = 0x00*
> *transceiver-mode = yes*
> *source-addr-autodetect = yes*
>
> *group = sendsms-user*
> *username = my*
> *password = god*
> *max-messages = 7*
> *concatenation = true*
> *forced-smsc = favoriteSMSC*
> *
> *
> *# mysql connection*
> *group = mysql-connection*
> *id = mydlr*
> *host = something.amazonaws.com <http://something.amazonaws.com>*
> *username = theuser*
> *password = thepass*
> *database = thedb*
> *max-connections = 1*
> *
> *
> *# DLR table structure*
> *group = dlr-db*
> *id = mydlr*
> *table = dlr*
> *field-smsc = smsc*
> *field-timestamp = ts*
> *field-destination = destination*
> *field-source = source*
> *field-service = service*
> *field-url = url*
> *field-mask = mask*
> *field-status = status*
> *field-boxc-id = boxc*
> *
> *
>
> *
> *
> *
> *
> *====SQLBox Conf ====*
> *#SqlBox*
> *group = sqlbox*
> *id = sqlbox-db*
> *smsbox-id = public_ctf*
> *bearerbox-host = localhost*
> *bearerbox-port = 13001*
> *smsbox-port = 130013*
> *smsbox-port-ssl = false*
> *sql-log-table = sent_sms*
> *sql-insert-table = send_sms*
> *log-file = "/etc/kannel/log/sqlbox.log"*
> *log-level = 0*
>
> *# mysql connection*
> *group = mysql-connection*
> *id = sqlbox-db*
> *host = something.amazonaws.com <http://something.amazonaws.com>*
> *port = 3306*
> *username = theuser*
> *password = thepass*
> *database = aSQLBoxDb*
> *max-connections = 1*
> *
> *
> *
> *
>
> *======== Opensmppbox.conf ======*
> *
> *
> *group = core*
> *dlr-storage = mysql*
>
> *#OpenSmppBox*
> *group = opensmppbox*
> *opensmppbox-id = smppboxA*
> *opensmppbox-port = 8990*
> *bearerbox-host = localhost*
> *bearerbox-port = 13001*
> *#bearerbox-port = 13013*
> *our-system-id = public_ctf*
> *smpp-logins = /etc/kannel/utilisateurs.txt*
> *use-systemid-as-smsboxid = true*
> *route-to-smsc = favoriteSMSC*
> *source-addr-ton = 1*
> *source-addr-npi = 1*
> *dest-addr-ton = 1*
> *dest-addr-npi = 1*
> *log-file = /etc/kannel/log/opensmppbox.log*
> *log-level = 0*
>
> *# mysql connection*
> *group = mysql-connection*
> *id = mydlr*
> *host = something.amazonaws.com <http://something.amazonaws.com>*
> *username = theuser*
> *password = thedb*
> *database = thesmppdb*
> *max-connections = 1*
>
> *# DLR table structure*
> *group = dlr-db*
> *id = mydlr*
> *table = dlr*
> *field-smsc = smsc*
> *field-timestamp = ts*
> *field-destination = destination*
> *field-source = source*
> *field-service = service*
> *field-url = url*
> *field-mask = mask*
> *field-status = status*
> *field-boxc-id = boxc*

what you have here is basically this:

   opensmppbox <-
   smsbox <------|-> bearerbox
   sqlbox <------

the port 13001 of bearerbox is the "smsbox application" port, and your 
opensmppbox and sqlbox (along with smsbox) conntect to it.

Kannel sqlbox needs to places in the middle, so you get:

  opensmppbox <-
                |-> sqlbox <-> bearerbox
  smsbox <------

so you need to define

   group = sqlbox
   bearerbox-host = localhost
   bearerbox-port = 13001
   smsbox-port = 13002
   ...

and then connect smsbox and opensmppbox to port 13002.


-- 
Best Regards,
Stipe Tolj

-------------------------------------------------------------------
Düsseldorf, NRW, Germany

Kannel Foundation                 tolj.org system architecture
http://www.kannel.org/            http://www.tolj.org/

[email protected]                  [email protected]
-------------------------------------------------------------------