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/
st...@kannel.org s...@tolj.org
-------------------------------------------------------------------
