Hi, I have kannel 4.4.
I have downloaded the sources and complied. Thanks. Le lun. 18 févr. 2019 à 09:53, Web Min <[email protected]> a écrit : > 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 >> >
