Dear List, I'm using latest KanneI and SQLBox SVN (Kannel version `svn-r5149'), compiled and configured to bearerbox-sqlbox-smsbox. Tested some MTs. All MTs sent OUT and all DLR received at the bearerbox level (attached the excel sheet of check and count total data on access log and MySql sent_sms table). But found some weird situation where not all DLR were inserted on sent_sms table. I have checked my smsbox & access log and found no error.
Your help will be appreciated !!
sql_id,momt,sender,receiver,udhdata,msgdata,time,smsc_id,service,account,id,sms_type,mclass,mwi,coding,compress,validity,deferred,dlr_mask,dlr_url,pid,alt_dcs,rpi,charset,boxc_id,binfo,meta_data,foreign_id 96,MT,STANBIC,255653258608,NULL,Message+(+10+),NULL,testuser,NULL,testuser8,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,31,43,NULL,NULL,NULL,NULL,sqlbox,NULL,NULL,11 97,DLR,STANBIC,255653258608,NULL,id%3A3fc7a057-d47b-4ff3-9b3c-ce512548cceb+sub%3A001+dlvrd%3A001+submit+date%3A1508260814+done+date%3A1508260814+stat%3ADELIVRD+err%3A000+text%3AMessage+(+10+),1440576868,testuser,NULL,testuser8,NULL,3,NULL,NULL,NULL,NULL,NULL,NULL,1,43,NULL,NULL,NULL,NULL,sqlbox,NULL,?orig_msg?dlr_mask=31&?smpp?dlr_err=%03%00%00&,3fc7a057-d47b-4ff3-9b3c-ce512548cceb 98,MT,STANBIC,255653258608,NULL,Message+(+20+),NULL,testuser,NULL,testuser8,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,31,44,NULL,NULL,NULL,NULL,sqlbox,NULL,NULL,12 99,MT,STANBIC,255653258608,NULL,Message+(+30+),NULL,testuser,NULL,testuser8,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,31,45,NULL,NULL,NULL,NULL,sqlbox,NULL,NULL,13 100,DLR,STANBIC,255653258608,NULL,ACK%2F,1440576885,testuser,NULL,NULL,NULL,3,NULL,NULL,NULL,NULL,NULL,NULL,8,45,NULL,NULL,NULL,NULL,sqlbox,NULL,?smpp_resp?,9f54196b-04e5-446c-8542-bfd788b2c26e 101,DLR,STANBIC,255653258608,NULL,id%3A9f54196b-04e5-446c-8542-bfd788b2c26e+sub%3A001+dlvrd%3A001+submit+date%3A1508260814+done+date%3A1508260814+stat%3ADELIVRD+err%3A000+text%3AMessage+(+30+),1440576889,testuser,NULL,testuser8,NULL,3,NULL,NULL,NULL,NULL,NULL,NULL,1,45,NULL,NULL,NULL,NULL,sqlbox,NULL,?orig_msg?dlr_mask=31&?smpp?dlr_err=%03%00%00&,9f54196b-04e5-446c-8542-bfd788b2c26e
access-log.xls
Description: MS-Excel spreadsheet
kannel.conf
Description: Binary data
