Provide your sqlbox.conf please On Thu, Feb 13, 2020, 4:32 PM Umair Baig <um...@mobilogi.com> 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/> > >