Re: Issue of DLR - URL with opensmppbox kannel

Provide your sqlbox.conf please

On Thu, Feb 13, 2020, 4:32 PM Umair Baig <[email protected]> wrote:

> Hello All,
>
> I have configured opensmppbox and I am trying to submit sms using mysql as
> dlr storage.
> When I receive sms it gets delivered but dlr does not get inserted into
> dlr table instead I get an error message in opensmppbox logs saying the
> below.
>
> 2020-02-13 19:21:14 [15724] [2] ERROR: MYSQL: mysql_stmt_execute() failed:
> `Data truncated for column 'url' at row 1'
> 2020-02-13 19:21:14 [15724] [2] ERROR: DLR: MYSQL: Error while adding dlr
> entry for DST<+9177XXXXXX>
>
> I am not sure why url data is not coming when sms is being received and
> field dlr-url in the log file is always empty.
>
> my opensmppbox conf
>
> #configuration
> group = core
> dlr-storage = mysql
>
> ###################################
> group = mysql-connection
> id = dlr-db
> host = 127.0.0.1
> port = 3303
> username = opensmppbox
> password = "XXXXX"
> database = new_sms
> max-connections = 20
>
> ###################################
> group = dlr-db
> id = dlr-db
> 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
> ###################################
>
> group = opensmppbox
> bearerbox-host = 127.0.0.1
> bearerbox-port = 13001
> opensmppbox-id = smppbox1
> opensmppbox-port = 2775
> log-file = /usr/opensmppbox.log
> log-level = 0
> our-system-id =smpp
> use-systemid-as-smsboxid = true
> route-to-smsc = Test001
> # New accounts
> smpp-logins = /usr/smpplogin.txt
>
> *Thanks & Regards,*
>
>
> *UMAIR BAIG*
> *Sr.Manager*
> *Buzz: +91- 7738857063*
> *On Desk: 022-22007840*
> *SKYPE-ID -umair.baig2893*
>
>   <http://mobilogi.com/>
>
>