Dear Group:
I am wondering whether group members didn't understood my query or are occupied..?! J In the mean time, I have decided to try ID field of send_sms and sent_sms table since I am injecting message by INSERT, and have tried removing commented code in SqlBox_mysql.c to move ID from send_sms to snet_sms but the field is not being copied from send_sms to sent_sms. I have also read in some post of DEC 2008 by Mr. Alejandro Guerrieri that sqlbox code would be patched for this. Does somebody has any clue about the discussed issue or any development on this front.?? Regards, Bharat From: Bharat Vasant [mailto:bha...@charteredinfo.com] Sent: Thursday, July 02, 2009 4:02 PM To: 'users@kannel.org' Subject: SQL Box and DLR Best Practice Importance: High 1. I am able to test Kannel + SQL Box and DLR. 2. Also I understand that I have to provide my own generated MsgID(uuid) in DLRUrl and on receiving DLR, my script will query for SMS record with MsgID(uuid) and update the DLR status. 3. To send the SMS, I have script which inserts SMS in SQLBox table send_sms which finally gets moved to sent_sms. 4. My question is do I need my separate tables to store MsgID(uuid) as noted in step 2 above ? If yes; this will Involve Injecting SMS in 2 tables. One - MyOwnSMS table and Two - SQLBox send_sms table; which seems the be bit of overhead for server at high throughput. 5. In other words, I am wondering, can I use existing tables of SQLBox (say table sent_sms) to store MsgID(uuid) and update the same using DLRurl on receipt of delivery report. i.e. Is there any field in tables send_sms and sent_sms which may be used for storing MsgID(uuid) generated by our submit script, and the field gets carried from send_sms to sent_sms automatically ? or is it recommended to edit the SQL box code to achieve this rather than having separate table as discussed in above point ? or having separate table will not be much of overhead ?! 6. I hope many users here are using Kannel at very high load conditions and would be able to share their experience with me. Bharat
