Re: Need help for opensmpp and SQLBox

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
>>
>