Which version of SQLBOX and KAnnel installed? Did you install them via a repository or via truck then compile?
Regards On Mon, Feb 18, 2019 at 11:21 AM Loyc Cossou <[email protected]> wrote: > 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 >
