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
