Need help for opensmpp and SQLBox

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*

Best regards.


------
loyc Cossou


[image: Mailtrack]
<https://mailtrack.io?utm_source=gmail&utm_medium=signature&utm_campaign=signaturevirality5&>
Sender
notified by
Mailtrack
<https://mailtrack.io?utm_source=gmail&utm_medium=signature&utm_campaign=signaturevirality5&>
18/02/19
à 09:17:09