SQLBOX time and foreign_id
Dear Kannel People I am using Bearer + SQLBOX with Oracle database. SENT_SMS table contains TIME and FOREIGN_ID fields but they are empty for sent messages with Momt='MT'. Why bearer/sqlbox dosent feel it ? For instance bearer_access log have FID number for sent SMSs. === Sent SMS [SMSC:tim] [SVC:] [ACT:] [BINF:] [FID:602c58ee]... === It will be very helpfull if time and foreign_id fields are filled -- Regards..
Invalid Memory Index
Dear All, While processing a outgoing sms list of around 600 I'm getting this error in logs. 2015-08-07 14:07:32 [8421] [7] ERROR: AT2[gsm2]: CMS ERROR: +CMS ERROR: 321 2015-08-07 14:07:32 [8421] [7] ERROR: AT2[gsm2]: CMS ERROR: Invalid memory index - don't worry, just memory fragmentation. (321) 2015-08-07 14:07:32 [8421] [7] DEBUG: AT2[gsm2]: failed to get message 45. What's causing this. How should I prevent this error. Thank you -- Regards, Pamod Amarakoon Confidentiality Notice: the information contained in this email and any attachments may be legally privileged and confidential. If you are not an intended recipient, you are hereby notified that any dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please notify the sender and permanently delete the e-mail and any attachments immediately. You should not retain, copy or use this e-mail or any attachments for any purpose, nor disclose all or any part of the contents to any other person. [image: eHealth Asia 2015] http://bit.ly/eha2015
Re: SQLBOX time and foreign_id
2015-08-07 16:16 GMT+03:00 Sergey Yudin ser...@centrcombank.com: Dear Kannel People I am using Bearer + SQLBOX with Oracle database. SENT_SMS table contains TIME and FOREIGN_ID fields but they are empty for sent messages with Momt='MT'. Why bearer/sqlbox dosent feel it ? foreign_id is the ID smsc gives you. time field is not empty if you filled it with some value. to track message you should use dlr_url field you can achieve this via various techniques: 1) trigger in Oracle 2) put something unique in dlr_url thus you can connect with incoming DLR message 3) you can use external http call via script update what you need For instance bearer_access log have FID number for sent SMSs. === Sent SMS [SMSC:tim] [SVC:] [ACT:] [BINF:] [FID:602c58ee]... === It will be very helpfull if time and foreign_id fields are filled -- Regards..
Re: SQLBOX time and foreign_id
Always copy list, so others would benefit from solution too. 2015-08-07 22:42 GMT+03:00 spameden spame...@gmail.com: 2015-08-07 22:41 GMT+03:00 spameden spame...@gmail.com: 2015-08-07 21:06 GMT+03:00 Sergey Yudin ser...@centrcombank.com: Can you give some tips about using charset field ? Provider wants UCS-2BE encoding and database in CP1251 encoding for this you need to use coding=2 and charset='utf-8' and also msgdata=urlencode(utf-8 encoded text) this way you'll get on the handset correct text. make sure to use latest kannel 1.4.4 (you can build it as well from SVN, SVN is production ready). About cp1251 i have no idea, since I'm always using UTF-8. But you can try replacing UTF-8 with CP1251 and encoding text in CP1251. Not sure if it'd work. -- Regards
