kannel + opensmppbox + mysql dlr (no sqlbox) != sms body message logging
Hi, people. How i can log sms messages body section in sql ? It seems that original sql table from the documentation just doesn't have such field. That's my sql table schema: CREATE TABLE dlr ( smsc varchar(40), ts varchar(40), destination varchar(40), source varchar(40), service varchar(40), url varchar(255), mask int(10), status int(10), boxc varchar(40) ) Like from original kannel documentation. It works fine but i'd like sms texts of the messages to be stored to. Is it possible? My configuration includes kannel + opensmppbox installed. No sqlbox included. Do i need this? What is sqlbox need for?
Re: kannel + opensmppbox + mysql dlr (no sqlbox) != sms body message logging
You can log sms message body section through sqlbox (msgdata in sent_sms table) for both MT and MO. dlr table is for DLR messages, they contain only delivery reports and msgdata in most cases cropped by your upstream SMSC operator. 2013/5/23 Вадим Бажов mas...@remort.net Hi, people. How i can log sms messages body section in sql ? It seems that original sql table from the documentation just doesn't have such field. That's my sql table schema: CREATE TABLE dlr ( smsc varchar(40), ts varchar(40), destination varchar(40), source varchar(40), service varchar(40), url varchar(255), mask int(10), status int(10), boxc varchar(40) ) Like from original kannel documentation. It works fine but i'd like sms texts of the messages to be stored to. Is it possible? My configuration includes kannel + opensmppbox installed. No sqlbox included. Do i need this? What is sqlbox need for?
Re: DLR with sqlbox
Ok, finally I got it working. There was a smsbox-route section missing. Now I'm routing the incoming messages to the sqlbox and I can see the DLR entries on the database :) My problem now is that the dlr_url is not being called. I could use the solution Carlos suggests (thank you Carlos), and it's still a possibility, but it would be better for me if I could use a url with a script of my own. I'm inserting this on the database: INSERT INTO send_sms( momt, sender, receiver, msgdata, sms_type, dlr_mask, dlr_url ) VALUES ('MT', 'MV', '+35191**7', 'Hello world', 2, 31, 'http%3A%2F%2Feasymessage.multivision.pt %2Fservices%2Fteste.php%3Ftype%3D%25d%26destination%3D%25d'); I do get the dlr entry on the database, but the url isn't accessed. Any ideas on what's wrong? Best regards, Jorge On Thu, Dec 22, 2011 at 5:01 PM, Carlos Massoglia Lillo carlos.massog...@mindfree.cl wrote: Jorge, If you insert directly into send_sms table, I think you must set an unique id in dlr_url. This because the same info you insert into send_sms is inserted into sent_sms, and to track DLR for messages, yu must compare dlr_url in rows with momt field set to DLR and the dlr_url. By example mysqlselect momt,receiver,dlr_mask,dlr_url from sent_sms where dlr_url='141b2de2'; +--+--+--+--+ | momt | receiver | dlr_mask | dlr_url | +--+--+--+--+ | MT | +569775 | 19 | 141b2de2 | | DLR | +569775 |1 | 141b2de2 | +--+--+--+--+ 2 rows in set (0.00 sec) As you see, setting dlr_url to a unique id for each message I can track the DLR for each one. Best regards, El jue, 22-12-2011 a las 15:20 +, Jorge Raimundo escribió: Hi all! I've installed smsbox and successfully sent an SMS using it, but I'm not being able to receive the DLR info. Right now the SMSC is rejecting my SMSes because I have no credits there and I am using this situation to test the DLR. I should have DLR information on the database that tells me that the SMSC is rejecting my messages. On the database I'm doing this: INSERT INTO send_sms( momt, sender, receiver, msgdata, sms_type, dlr_mask, dlr_url ) VALUES ( 'MT', 'MV', '+3519**67', 'Hello world', 2, 31, 'http%3A%2F% 2F**%2Fteste.php%3Fdestination%3D7%26type%3D%25d' ) On the smsc log I get the following: [2447] [6] DEBUG: SMPP PDU 0x7dde00 dump: [2447] [6] DEBUG: type_name: submit_sm_resp [2447] [6] DEBUG: command_id: 2147483652 = 0x8004 [2447] [6] DEBUG: command_status: 69 = 0x0045 [2447] [6] DEBUG: sequence_number: 252 = 0x00fc [2447] [6] DEBUG: message_id: NULL [2447] [6] DEBUG: SMPP PDU dump ends. [2447] [6] ERROR: SMPP[ROUTO]: SMSC returned error code 0x0045 (Submit failed) in response to submit_sm. [2447] [6] DEBUG: SMSC[ROUTO]: creating DLR message [2447] [6] DEBUG: SMSC[ROUTO]: DLR = http%3A%2F% 2Feasymessage.multivision.pt%2Fservices%2Fteste.php%3Fdestination%3D7% 26type%3D%25d [2447] [6] WARNING: smsbox_list empty! I'm getting command_status: 69 (SMSC returned error code 0x0045), this is the code used by my SMSC to tell me that the SMS was rejected, so this should translate to a status of 16 on dlr, but nothing was passed to my side. The sent_sms has no dlr data and the link I passed on dlr-url was not called... What's wrong in here? Best regards, Jorge -- Multivision Jorge Raimundo RAN Consultant | jorge.raimu...@multivision.pt . Rua António Albino Machado, Nº33, 2ºB. S. Domingos de Benfica, 1600 - 870 Lisboa Fixed PT: +351 21 155 20 53 | Mobile PT: +351 91 933 13 67 www.multivision.pt -- Carlos Massoglia Lillo Gerencia de Innovación y Desarrollo MindFree Ingeniería Limitada www.mindfree.cl -- [image: Multivision] *Jorge Raimundo * RAN Consultant | jorge.raimu...@multivision.pt . Rua António Albino Machado, Nº33, 2ºB. S. Domingos de Benfica, 1600 - 870 Lisboa Fixed PT: +351 21 155 20 53 | Mobile PT: +351 91 933 13 67 www.multivision.pt
Re: DLR with sqlbox
You need smsbox to do that. You need to use sqlbox between smsbox and bearerbox, sp sqlbox can log the traffic and smsbox hit the drl-url and/or the services. Regards, -- Alex Guerrieri On Jan 2, 2012, at 10:57, Jorge Raimundo jorge.raimu...@multivision.pt wrote: Ok, finally I got it working. There was a smsbox-route section missing. Now I'm routing the incoming messages to the sqlbox and I can see the DLR entries on the database :) My problem now is that the dlr_url is not being called. I could use the solution Carlos suggests (thank you Carlos), and it's still a possibility, but it would be better for me if I could use a url with a script of my own. I'm inserting this on the database: INSERT INTO send_sms( momt, sender, receiver, msgdata, sms_type, dlr_mask, dlr_url ) VALUES ('MT', 'MV', '+35191**7', 'Hello world', 2, 31, 'http%3A%2F%2Feasymessage.multivision.pt%2Fservices%2Fteste.php%3Ftype%3D%25d%26destination%3D%25d'); I do get the dlr entry on the database, but the url isn't accessed. Any ideas on what's wrong? Best regards, Jorge On Thu, Dec 22, 2011 at 5:01 PM, Carlos Massoglia Lillo carlos.massog...@mindfree.cl wrote: Jorge, If you insert directly into send_sms table, I think you must set an unique id in dlr_url. This because the same info you insert into send_sms is inserted into sent_sms, and to track DLR for messages, yu must compare dlr_url in rows with momt field set to DLR and the dlr_url. By example mysqlselect momt,receiver,dlr_mask,dlr_url from sent_sms where dlr_url='141b2de2'; +--+--+--+--+ | momt | receiver | dlr_mask | dlr_url | +--+--+--+--+ | MT | +569775 | 19 | 141b2de2 | | DLR | +569775 |1 | 141b2de2 | +--+--+--+--+ 2 rows in set (0.00 sec) As you see, setting dlr_url to a unique id for each message I can track the DLR for each one. Best regards, El jue, 22-12-2011 a las 15:20 +, Jorge Raimundo escribió: Hi all! I've installed smsbox and successfully sent an SMS using it, but I'm not being able to receive the DLR info. Right now the SMSC is rejecting my SMSes because I have no credits there and I am using this situation to test the DLR. I should have DLR information on the database that tells me that the SMSC is rejecting my messages. On the database I'm doing this: INSERT INTO send_sms( momt, sender, receiver, msgdata, sms_type, dlr_mask, dlr_url ) VALUES ( 'MT', 'MV', '+3519**67', 'Hello world', 2, 31, 'http%3A%2F% 2F**%2Fteste.php%3Fdestination%3D7%26type%3D%25d' ) On the smsc log I get the following: [2447] [6] DEBUG: SMPP PDU 0x7dde00 dump: [2447] [6] DEBUG: type_name: submit_sm_resp [2447] [6] DEBUG: command_id: 2147483652 = 0x8004 [2447] [6] DEBUG: command_status: 69 = 0x0045 [2447] [6] DEBUG: sequence_number: 252 = 0x00fc [2447] [6] DEBUG: message_id: NULL [2447] [6] DEBUG: SMPP PDU dump ends. [2447] [6] ERROR: SMPP[ROUTO]: SMSC returned error code 0x0045 (Submit failed) in response to submit_sm. [2447] [6] DEBUG: SMSC[ROUTO]: creating DLR message [2447] [6] DEBUG: SMSC[ROUTO]: DLR = http%3A%2F% 2Feasymessage.multivision.pt%2Fservices%2Fteste.php%3Fdestination%3D7% 26type%3D%25d [2447] [6] WARNING: smsbox_list empty! I'm getting command_status: 69 (SMSC returned error code 0x0045), this is the code used by my SMSC to tell me that the SMS was rejected, so this should translate to a status of 16 on dlr, but nothing was passed to my side. The sent_sms has no dlr data and the link I passed on dlr-url was not called... What's wrong in here? Best regards, Jorge -- Multivision Jorge Raimundo RAN Consultant | jorge.raimu...@multivision.pt . Rua António Albino Machado, Nº33, 2ºB. S. Domingos de Benfica, 1600 - 870 Lisboa Fixed PT: +351 21 155 20 53 | Mobile PT: +351 91 933 13 67 www.multivision.pt -- Carlos Massoglia Lillo Gerencia de Innovación y Desarrollo MindFree Ingeniería Limitada www.mindfree.cl -- Jorge Raimundo RAN Consultant | jorge.raimu...@multivision.pt . Rua António Albino Machado, Nº33, 2ºB. S. Domingos de Benfica, 1600 - 870 Lisboa Fixed PT: +351 21 155 20 53 | Mobile PT: +351 91 933 13 67 www.multivision.pt
Re: DLR with sqlbox
Thank you Alejandro. Is it possible that both sqlbox and smsbox receive the dlr? Is it possible to route a message to more than one box? Best regards, Jorge On Mon, Jan 2, 2012 at 4:21 PM, Alejandro Guerrieri alejandro.guerri...@gmail.com wrote: You need smsbox to do that. You need to use sqlbox between smsbox and bearerbox, sp sqlbox can log the traffic and smsbox hit the drl-url and/or the services. Regards, -- Alex Guerrieri On Jan 2, 2012, at 10:57, Jorge Raimundo jorge.raimu...@multivision.pt wrote: Ok, finally I got it working. There was a smsbox-route section missing. Now I'm routing the incoming messages to the sqlbox and I can see the DLR entries on the database :) My problem now is that the dlr_url is not being called. I could use the solution Carlos suggests (thank you Carlos), and it's still a possibility, but it would be better for me if I could use a url with a script of my own. I'm inserting this on the database: INSERT INTO send_sms( momt, sender, receiver, msgdata, sms_type, dlr_mask, dlr_url ) VALUES ('MT', 'MV', '+35191**7', 'Hello world', 2, 31, 'http%3A%2F%2Feasymessage.multivision.pt %2Fservices%2Fteste.php%3Ftype%3D%25d%26destination%3D%25d'); I do get the dlr entry on the database, but the url isn't accessed. Any ideas on what's wrong? Best regards, Jorge On Thu, Dec 22, 2011 at 5:01 PM, Carlos Massoglia Lillo carlos.massog...@mindfree.cl wrote: Jorge, If you insert directly into send_sms table, I think you must set an unique id in dlr_url. This because the same info you insert into send_sms is inserted into sent_sms, and to track DLR for messages, yu must compare dlr_url in rows with momt field set to DLR and the dlr_url. By example mysqlselect momt,receiver,dlr_mask,dlr_url from sent_sms where dlr_url='141b2de2'; +--+--+--+--+ | momt | receiver | dlr_mask | dlr_url | +--+--+--+--+ | MT | +569775 | 19 | 141b2de2 | | DLR | +569775 |1 | 141b2de2 | +--+--+--+--+ 2 rows in set (0.00 sec) As you see, setting dlr_url to a unique id for each message I can track the DLR for each one. Best regards, El jue, 22-12-2011 a las 15:20 +, Jorge Raimundo escribió: Hi all! I've installed smsbox and successfully sent an SMS using it, but I'm not being able to receive the DLR info. Right now the SMSC is rejecting my SMSes because I have no credits there and I am using this situation to test the DLR. I should have DLR information on the database that tells me that the SMSC is rejecting my messages. On the database I'm doing this: INSERT INTO send_sms( momt, sender, receiver, msgdata, sms_type, dlr_mask, dlr_url ) VALUES ( 'MT', 'MV', '+3519**67', 'Hello world', 2, 31, 'http%3A%2F% 2F**%2Fteste.php%3Fdestination%3D7%26type%3D%25d' ) On the smsc log I get the following: [2447] [6] DEBUG: SMPP PDU 0x7dde00 dump: [2447] [6] DEBUG: type_name: submit_sm_resp [2447] [6] DEBUG: command_id: 2147483652 = 0x8004 [2447] [6] DEBUG: command_status: 69 = 0x0045 [2447] [6] DEBUG: sequence_number: 252 = 0x00fc [2447] [6] DEBUG: message_id: NULL [2447] [6] DEBUG: SMPP PDU dump ends. [2447] [6] ERROR: SMPP[ROUTO]: SMSC returned error code 0x0045 (Submit failed) in response to submit_sm. [2447] [6] DEBUG: SMSC[ROUTO]: creating DLR message [2447] [6] DEBUG: SMSC[ROUTO]: DLR = http%3A%2F% 2Feasymessage.multivision.pt%2Fservices%2Fteste.php%3Fdestination%3D7% 26type%3D%25d [2447] [6] WARNING: smsbox_list empty! I'm getting command_status: 69 (SMSC returned error code 0x0045), this is the code used by my SMSC to tell me that the SMS was rejected, so this should translate to a status of 16 on dlr, but nothing was passed to my side. The sent_sms has no dlr data and the link I passed on dlr-url was not called... What's wrong in here? Best regards, Jorge -- Multivision Jorge Raimundo RAN Consultant | jorge.raimu...@multivision.pt . Rua António Albino Machado, Nº33, 2ºB. S. Domingos de Benfica, 1600 - 870 Lisboa Fixed PT: +351 21 155 20 53 | Mobile PT: +351 91 933 13 67 www.multivision.pt -- Carlos Massoglia Lillo Gerencia de Innovación y Desarrollo MindFree Ingeniería Limitada www.mindfree.cl -- [image: Multivision] *Jorge Raimundo * RAN Consultant | jorge.raimu...@multivision.pt . Rua António Albino Machado, Nº33, 2ºB. S. Domingos de Benfica, 1600 - 870 Lisboa Fixed PT: +351 21 155 20 53 | Mobile PT: +351 91 933 13 67 www.multivision.pt -- [image: Multivision] *Jorge Raimundo * RAN Consultant | jorge.raimu...@multivision.pt . Rua António Albino Machado, Nº33, 2ºB. S. Domingos de Benfica, 1600 - 870 Lisboa Fixed PT: +351 21 155 20 53 | Mobile PT: +351 91 933 13 67 www.multivision.pt
Re: DLR with sqlbox
No, afaik messages can only be routed to a single box. Regards, Alex On Mon, Jan 2, 2012 at 11:29 AM, Jorge Raimundo jorge.raimu...@multivision.pt wrote: Thank you Alejandro. Is it possible that both sqlbox and smsbox receive the dlr? Is it possible to route a message to more than one box? Best regards, Jorge On Mon, Jan 2, 2012 at 4:21 PM, Alejandro Guerrieri alejandro.guerri...@gmail.com wrote: You need smsbox to do that. You need to use sqlbox between smsbox and bearerbox, sp sqlbox can log the traffic and smsbox hit the drl-url and/or the services. Regards, -- Alex Guerrieri On Jan 2, 2012, at 10:57, Jorge Raimundo jorge.raimu...@multivision.pt wrote: Ok, finally I got it working. There was a smsbox-route section missing. Now I'm routing the incoming messages to the sqlbox and I can see the DLR entries on the database :) My problem now is that the dlr_url is not being called. I could use the solution Carlos suggests (thank you Carlos), and it's still a possibility, but it would be better for me if I could use a url with a script of my own. I'm inserting this on the database: INSERT INTO send_sms( momt, sender, receiver, msgdata, sms_type, dlr_mask, dlr_url ) VALUES ('MT', 'MV', '+35191**7', 'Hello world', 2, 31, 'http%3A%2F%2Feasymessage.multivision.pt %2Fservices%2Fteste.php%3Ftype%3D%25d%26destination%3D%25d'); I do get the dlr entry on the database, but the url isn't accessed. Any ideas on what's wrong? Best regards, Jorge On Thu, Dec 22, 2011 at 5:01 PM, Carlos Massoglia Lillo carlos.massog...@mindfree.cl wrote: Jorge, If you insert directly into send_sms table, I think you must set an unique id in dlr_url. This because the same info you insert into send_sms is inserted into sent_sms, and to track DLR for messages, yu must compare dlr_url in rows with momt field set to DLR and the dlr_url. By example mysqlselect momt,receiver,dlr_mask,dlr_url from sent_sms where dlr_url='141b2de2'; +--+--+--+--+ | momt | receiver | dlr_mask | dlr_url | +--+--+--+--+ | MT | +569775 | 19 | 141b2de2 | | DLR | +569775 |1 | 141b2de2 | +--+--+--+--+ 2 rows in set (0.00 sec) As you see, setting dlr_url to a unique id for each message I can track the DLR for each one. Best regards, El jue, 22-12-2011 a las 15:20 +, Jorge Raimundo escribió: Hi all! I've installed smsbox and successfully sent an SMS using it, but I'm not being able to receive the DLR info. Right now the SMSC is rejecting my SMSes because I have no credits there and I am using this situation to test the DLR. I should have DLR information on the database that tells me that the SMSC is rejecting my messages. On the database I'm doing this: INSERT INTO send_sms( momt, sender, receiver, msgdata, sms_type, dlr_mask, dlr_url ) VALUES ( 'MT', 'MV', '+3519**67', 'Hello world', 2, 31, 'http%3A%2F% 2F**%2Fteste.php%3Fdestination%3D7%26type%3D%25d' ) On the smsc log I get the following: [2447] [6] DEBUG: SMPP PDU 0x7dde00 dump: [2447] [6] DEBUG: type_name: submit_sm_resp [2447] [6] DEBUG: command_id: 2147483652 = 0x8004 [2447] [6] DEBUG: command_status: 69 = 0x0045 [2447] [6] DEBUG: sequence_number: 252 = 0x00fc [2447] [6] DEBUG: message_id: NULL [2447] [6] DEBUG: SMPP PDU dump ends. [2447] [6] ERROR: SMPP[ROUTO]: SMSC returned error code 0x0045 (Submit failed) in response to submit_sm. [2447] [6] DEBUG: SMSC[ROUTO]: creating DLR message [2447] [6] DEBUG: SMSC[ROUTO]: DLR = http%3A%2F% 2Feasymessage.multivision.pt%2Fservices%2Fteste.php%3Fdestination%3D7% 26type%3D%25d [2447] [6] WARNING: smsbox_list empty! I'm getting command_status: 69 (SMSC returned error code 0x0045), this is the code used by my SMSC to tell me that the SMS was rejected, so this should translate to a status of 16 on dlr, but nothing was passed to my side. The sent_sms has no dlr data and the link I passed on dlr-url was not called... What's wrong in here? Best regards, Jorge -- Multivision Jorge Raimundo RAN Consultant | jorge.raimu...@multivision.pt . Rua António Albino Machado, Nº33, 2ºB. S. Domingos de Benfica, 1600 - 870 Lisboa Fixed PT: +351 21 155 20 53 | Mobile PT: +351 91 933 13 67 www.multivision.pt -- Carlos Massoglia Lillo Gerencia de Innovación y Desarrollo MindFree Ingeniería Limitada www.mindfree.cl -- [image: Multivision] *Jorge Raimundo * RAN Consultant | jorge.raimu...@multivision.pt . Rua António Albino Machado, Nº33, 2ºB. S. Domingos de Benfica, 1600 - 870 Lisboa Fixed PT: +351 21 155 20 53 | Mobile PT: +351 91 933 13 67 www.multivision.pt -- [image: Multivision] *Jorge Raimundo * RAN Consultant | jorge.raimu...@multivision.pt . Rua António Albino Machado, Nº33,
Re: DLR with sqlbox
Jorge, If you insert directly into send_sms table, I think you must set an unique id in dlr_url. This because the same info you insert into send_sms is inserted into sent_sms, and to track DLR for messages, yu must compare dlr_url in rows with momt field set to DLR and the dlr_url. By example mysqlselect momt,receiver,dlr_mask,dlr_url from sent_sms where dlr_url='141b2de2'; +--+--+--+--+ | momt | receiver | dlr_mask | dlr_url | +--+--+--+--+ | MT | +569775 | 19 | 141b2de2 | | DLR | +569775 |1 | 141b2de2 | +--+--+--+--+ 2 rows in set (0.00 sec) As you see, setting dlr_url to a unique id for each message I can track the DLR for each one. Best regards, El jue, 22-12-2011 a las 15:20 +, Jorge Raimundo escribió: Hi all! I've installed smsbox and successfully sent an SMS using it, but I'm not being able to receive the DLR info. Right now the SMSC is rejecting my SMSes because I have no credits there and I am using this situation to test the DLR. I should have DLR information on the database that tells me that the SMSC is rejecting my messages. On the database I'm doing this: INSERT INTO send_sms( momt, sender, receiver, msgdata, sms_type, dlr_mask, dlr_url ) VALUES ( 'MT', 'MV', '+3519**67', 'Hello world', 2, 31, 'http%3A%2F% 2F**%2Fteste.php%3Fdestination%3D7%26type%3D%25d' ) On the smsc log I get the following: [2447] [6] DEBUG: SMPP PDU 0x7dde00 dump: [2447] [6] DEBUG: type_name: submit_sm_resp [2447] [6] DEBUG: command_id: 2147483652 = 0x8004 [2447] [6] DEBUG: command_status: 69 = 0x0045 [2447] [6] DEBUG: sequence_number: 252 = 0x00fc [2447] [6] DEBUG: message_id: NULL [2447] [6] DEBUG: SMPP PDU dump ends. [2447] [6] ERROR: SMPP[ROUTO]: SMSC returned error code 0x0045 (Submit failed) in response to submit_sm. [2447] [6] DEBUG: SMSC[ROUTO]: creating DLR message [2447] [6] DEBUG: SMSC[ROUTO]: DLR = http%3A%2F% 2Feasymessage.multivision.pt%2Fservices%2Fteste.php%3Fdestination%3D7% 26type%3D%25d [2447] [6] WARNING: smsbox_list empty! I'm getting command_status: 69 (SMSC returned error code 0x0045), this is the code used by my SMSC to tell me that the SMS was rejected, so this should translate to a status of 16 on dlr, but nothing was passed to my side. The sent_sms has no dlr data and the link I passed on dlr-url was not called... What's wrong in here? Best regards, Jorge -- Multivision Jorge Raimundo RAN Consultant | jorge.raimu...@multivision.pt . Rua António Albino Machado, Nº33, 2ºB. S. Domingos de Benfica, 1600 - 870 Lisboa Fixed PT: +351 21 155 20 53 | Mobile PT: +351 91 933 13 67 www.multivision.pt -- Carlos Massoglia Lillo Gerencia de Innovación y Desarrollo MindFree Ingeniería Limitada www.mindfree.cl
RE: DLR and sqlbox
Just use the dlrurl field to get an id. You can set it to any value that you like. Then, if you set dlrmask also, the id that is in the dlrurl field will be in the DLR record. == Rene -Original Message- From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf Of Diverse Sent: Friday, 19 August, 2011 08:35 To: Willy Mularto Cc: users@kannel.org Subject: Re: DLR and sqlbox Yes. I need to give your sms_id, which would then find it on DLR can implement the meta-data? How to do this? Willy Mularto пишет: There is no sms_id field name afaik, the one exist is smsc_id. Or do you mean you want to add a custom field? If yes, there will be 2 approaches here. You can modify the source code and it need programming skills or you can implement the meta-data feature. On Aug 18, 2011, at 8:38 PM, Diverse wrote: This is an example, it would be convenient to give sms_id through a separate field. Is it possible? Willy Mularto пишет: You missed dlr_mask field brother. Set it with Kannel's standard value. Please check the user-guide. It is your best friend actually :) On Aug 18, 2011, at 7:20 PM, Diverse wrote: I did this. Kannel 1.5 + sqlbox. MT INSERT INTO send_sms ( momt, sender, receiver, msgdata, sms_type ) VALUES ( ’MT’, ’1234’, ’1234567890’, ’Hello world’, 2 ); In which field should I specify my sms_id, what I would then been able to find it on the table DLR sent_sms. And how can I use sending messages through the base sqlbox, and link data from tables send_sms, sent_sms? Tell me please, through which field I can set my message number (sms_id), so after a write to send_sms I could find for this sms_id status (dlr) in sent_sms? Wendy William пишет: You need Kannel 1.5 which supports sqlbox. Then setup the dlr in kannel.conf, Kannel will automatically store to your created table. - Original Message From: Diverse dive...@mobilmir.ru To: users@kannel.org Sent: Thu, August 18, 2011 5:39:29 PM Subject: DLR and sqlbox And how can I use sending messages through the base sqlbox, and link data from tables send_sms, sent_sms? Tell me please, through which field I can set my message number (sms_id), so after a write to send_sms I could find for this sms_id status (dlr) in sent_sms? -- Willy Mularto F300HD+MR18DE (NLC1725) http://www.binbit.co.id/ -- Willy Mularto F300HD+MR18DE (NLC1725) http://www.binbit.co.id/ --
Re: DLR and sqlbox
Yes. I need to give your sms_id, which would then find it on DLR can implement the meta-data? How to do this? Willy Mularto пишет: There is no sms_id field name afaik, the one exist is smsc_id. Or do you mean you want to add a custom field? If yes, there will be 2 approaches here. You can modify the source code and it need programming skills or you can implement the meta-data feature. On Aug 18, 2011, at 8:38 PM, Diverse wrote: This is an example, it would be convenient to give sms_id through a separate field. Is it possible? Willy Mularto пишет: You missed dlr_mask field brother. Set it with Kannel's standard value. Please check the user-guide. It is your best friend actually :) On Aug 18, 2011, at 7:20 PM, Diverse wrote: I did this. Kannel 1.5 + sqlbox. MT INSERT INTO send_sms ( momt, sender, receiver, msgdata, sms_type ) VALUES ( ’MT’, ’1234’, ’1234567890’, ’Hello world’, 2 ); In which field should I specify my sms_id, what I would then been able to find it on the table DLR sent_sms. And how can I use sending messages through the base sqlbox, and link data from tables send_sms, sent_sms? Tell me please, through which field I can set my message number (sms_id), so after a write to send_sms I could find for this sms_id status (dlr) in sent_sms? Wendy William пишет: You need Kannel 1.5 which supports sqlbox. Then setup the dlr in kannel.conf, Kannel will automatically store to your created table. - Original Message From: Diverse dive...@mobilmir.ru To: users@kannel.org Sent: Thu, August 18, 2011 5:39:29 PM Subject: DLR and sqlbox And how can I use sending messages through the base sqlbox, and link data from tables send_sms, sent_sms? Tell me please, through which field I can set my message number (sms_id), so after a write to send_sms I could find for this sms_id status (dlr) in sent_sms? -- Willy Mularto F300HD+MR18DE (NLC1725) http://www.binbit.co.id/ -- Willy Mularto F300HD+MR18DE (NLC1725) http://www.binbit.co.id/ -- signature.asc Description: OpenPGP digital signature
DLR and sqlbox
And how can I use sending messages through the base sqlbox, and link data from tables send_sms, sent_sms? Tell me please, through which field I can set my message number (sms_id), so after a write to send_sms I could find for this sms_id status (dlr) in sent_sms? -- signature.asc Description: OpenPGP digital signature
Re: DLR and sqlbox
I did this. Kannel 1.5 + sqlbox. MT INSERT INTO send_sms ( momt, sender, receiver, msgdata, sms_type ) VALUES ( ’MT’, ’1234’, ’1234567890’, ’Hello world’, 2 ); In which field should I specify my sms_id, what I would then been able to find it on the table DLR sent_sms. And how can I use sending messages through the base sqlbox, and link data from tables send_sms, sent_sms? Tell me please, through which field I can set my message number (sms_id), so after a write to send_sms I could find for this sms_id status (dlr) in sent_sms? Wendy William пишет: You need Kannel 1.5 which supports sqlbox. Then setup the dlr in kannel.conf, Kannel will automatically store to your created table. - Original Message From: Diverse dive...@mobilmir.ru To: users@kannel.org Sent: Thu, August 18, 2011 5:39:29 PM Subject: DLR and sqlbox And how can I use sending messages through the base sqlbox, and link data from tables send_sms, sent_sms? Tell me please, through which field I can set my message number (sms_id), so after a write to send_sms I could find for this sms_id status (dlr) in sent_sms? -- -- С уважением, Александр Сухарев Системный администратор Цифроград Ставрополь тел: (9624) 40-06-66 e-mail: dive...@mobilmir.ru icq: 272375131 skype: undive...@skype.com jabber: dive...@jabber.ru signature.asc Description: OpenPGP digital signature
Re: DLR and sqlbox
AFAIK and CMIIW, SQLBox has been part of Kannel for long times ago. I already use it since Kannel 1.3.2..ehmm it's about 3 years ago at least I guess. On Aug 18, 2011, at 6:46 PM, Wendy William wrote: You need Kannel 1.5 which supports sqlbox. Then setup the dlr in kannel.conf, Kannel will automatically store to your created table. - Original Message From: Diverse dive...@mobilmir.ru To: users@kannel.org Sent: Thu, August 18, 2011 5:39:29 PM Subject: DLR and sqlbox And how can I use sending messages through the base sqlbox, and link data from tables send_sms, sent_sms? Tell me please, through which field I can set my message number (sms_id), so after a write to send_sms I could find for this sms_id status (dlr) in sent_sms? -- Willy Mularto F300HD+MR18DE (NLC1725) http://www.binbit.co.id/
Re: DLR and sqlbox
You missed dlr_mask field brother. Set it with Kannel's standard value. Please check the user-guide. It is your best friend actually :) On Aug 18, 2011, at 7:20 PM, Diverse wrote: I did this. Kannel 1.5 + sqlbox. MT INSERT INTO send_sms ( momt, sender, receiver, msgdata, sms_type ) VALUES ( ’MT’, ’1234’, ’1234567890’, ’Hello world’, 2 ); In which field should I specify my sms_id, what I would then been able to find it on the table DLR sent_sms. And how can I use sending messages through the base sqlbox, and link data from tables send_sms, sent_sms? Tell me please, through which field I can set my message number (sms_id), so after a write to send_sms I could find for this sms_id status (dlr) in sent_sms? Wendy William пишет: You need Kannel 1.5 which supports sqlbox. Then setup the dlr in kannel.conf, Kannel will automatically store to your created table. - Original Message From: Diverse dive...@mobilmir.ru To: users@kannel.org Sent: Thu, August 18, 2011 5:39:29 PM Subject: DLR and sqlbox And how can I use sending messages through the base sqlbox, and link data from tables send_sms, sent_sms? Tell me please, through which field I can set my message number (sms_id), so after a write to send_sms I could find for this sms_id status (dlr) in sent_sms? -- -- С уважением, Александр Сухарев Системный администратор Цифроград Ставрополь тел: (9624) 40-06-66 e-mail: dive...@mobilmir.ru icq: 272375131 skype: undive...@skype.com jabber: dive...@jabber.ru Willy Mularto F300HD+MR18DE (NLC1725) http://www.binbit.co.id/
Re: DLR and sqlbox
This is an example, it would be convenient to give sms_id through a separate field. Is it possible? Willy Mularto пишет: You missed dlr_mask field brother. Set it with Kannel's standard value. Please check the user-guide. It is your best friend actually :) On Aug 18, 2011, at 7:20 PM, Diverse wrote: I did this. Kannel 1.5 + sqlbox. MT INSERT INTO send_sms ( momt, sender, receiver, msgdata, sms_type ) VALUES ( ’MT’, ’1234’, ’1234567890’, ’Hello world’, 2 ); In which field should I specify my sms_id, what I would then been able to find it on the table DLR sent_sms. And how can I use sending messages through the base sqlbox, and link data from tables send_sms, sent_sms? Tell me please, through which field I can set my message number (sms_id), so after a write to send_sms I could find for this sms_id status (dlr) in sent_sms? Wendy William пишет: You need Kannel 1.5 which supports sqlbox. Then setup the dlr in kannel.conf, Kannel will automatically store to your created table. - Original Message From: Diverse dive...@mobilmir.ru To: users@kannel.org Sent: Thu, August 18, 2011 5:39:29 PM Subject: DLR and sqlbox And how can I use sending messages through the base sqlbox, and link data from tables send_sms, sent_sms? Tell me please, through which field I can set my message number (sms_id), so after a write to send_sms I could find for this sms_id status (dlr) in sent_sms? -- -- С уважением, Александр Сухарев Системный администратор Цифроград Ставрополь тел: (9624) 40-06-66 e-mail: dive...@mobilmir.ru icq: 272375131 skype: undive...@skype.com jabber: dive...@jabber.ru Willy Mularto F300HD+MR18DE (NLC1725) http://www.binbit.co.id/ -- С уважением, Александр Сухарев Системный администратор Цифроград Ставрополь тел: (9624) 40-06-66 e-mail: dive...@mobilmir.ru icq: 272375131 skype: undive...@skype.com jabber: dive...@jabber.ru signature.asc Description: OpenPGP digital signature
Re: DLR and sqlbox
There is no sms_id field name afaik, the one exist is smsc_id. Or do you mean you want to add a custom field? If yes, there will be 2 approaches here. You can modify the source code and it need programming skills or you can implement the meta-data feature. On Aug 18, 2011, at 8:38 PM, Diverse wrote: This is an example, it would be convenient to give sms_id through a separate field. Is it possible? Willy Mularto пишет: You missed dlr_mask field brother. Set it with Kannel's standard value. Please check the user-guide. It is your best friend actually :) On Aug 18, 2011, at 7:20 PM, Diverse wrote: I did this. Kannel 1.5 + sqlbox. MT INSERT INTO send_sms ( momt, sender, receiver, msgdata, sms_type ) VALUES ( ’MT’, ’1234’, ’1234567890’, ’Hello world’, 2 ); In which field should I specify my sms_id, what I would then been able to find it on the table DLR sent_sms. And how can I use sending messages through the base sqlbox, and link data from tables send_sms, sent_sms? Tell me please, through which field I can set my message number (sms_id), so after a write to send_sms I could find for this sms_id status (dlr) in sent_sms? Wendy William пишет: You need Kannel 1.5 which supports sqlbox. Then setup the dlr in kannel.conf, Kannel will automatically store to your created table. - Original Message From: Diverse dive...@mobilmir.ru To: users@kannel.org Sent: Thu, August 18, 2011 5:39:29 PM Subject: DLR and sqlbox And how can I use sending messages through the base sqlbox, and link data from tables send_sms, sent_sms? Tell me please, through which field I can set my message number (sms_id), so after a write to send_sms I could find for this sms_id status (dlr) in sent_sms? -- -- С уважением, Александр Сухарев Системный администратор Цифроград Ставрополь тел: (9624) 40-06-66 e-mail: dive...@mobilmir.ru icq: 272375131 skype: undive...@skype.com jabber: dive...@jabber.ru Willy Mularto F300HD+MR18DE (NLC1725) http://www.binbit.co.id/ -- С уважением, Александр Сухарев Системный администратор Цифроград Ставрополь тел: (9624) 40-06-66 e-mail: dive...@mobilmir.ru icq: 272375131 skype: undive...@skype.com jabber: dive...@jabber.ru Willy Mularto F300HD+MR18DE (NLC1725) http://www.binbit.co.id/
Re: DLR and sqlbox
create a column called sql_id and make it primary key and auto_increment. CREATE TABLE IF NOT EXISTS `send_sms` ( `sql_id` bigint(20) NOT NULL auto_increment, `momt` enum('MO','MT') default NULL, `sender` varchar(20) default NULL, `receiver` varchar(20) default NULL, `udhdata` blob, `msgdata` text character set utf8 collate utf8_swedish_ci, `time` bigint(20) default NULL, `smsc_id` varchar(255) default NULL, `service` varchar(255) default NULL, `account` varchar(255) default NULL, `id` bigint(20) default NULL, `sms_type` bigint(20) default NULL, `mclass` bigint(20) default NULL, `mwi` bigint(20) default NULL, `coding` bigint(20) default NULL, `compress` bigint(20) default NULL, `validity` bigint(20) default NULL, `deferred` bigint(20) default NULL, `dlr_mask` bigint(20) default NULL, `dlr_url` varchar(255) default NULL, `pid` bigint(20) default NULL, `alt_dcs` bigint(20) default NULL, `rpi` bigint(20) default NULL, `charset` varchar(255) default NULL, `boxc_id` varchar(255) default NULL, `binfo` varchar(255) default NULL, `meta_data` text, PRIMARY KEY (`sql_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=359 ; That is my send_sms table /Andreas 18 aug 2011 kl. 15:38 skrev Diverse: This is an example, it would be convenient to give sms_id through a separate field. Is it possible? Willy Mularto пишет: You missed dlr_mask field brother. Set it with Kannel's standard value. Please check the user-guide. It is your best friend actually :) On Aug 18, 2011, at 7:20 PM, Diverse wrote: I did this. Kannel 1.5 + sqlbox. MT INSERT INTO send_sms ( momt, sender, receiver, msgdata, sms_type ) VALUES ( ’MT’, ’1234’, ’1234567890’, ’Hello world’, 2 ); In which field should I specify my sms_id, what I would then been able to find it on the table DLR sent_sms. And how can I use sending messages through the base sqlbox, and link data from tables send_sms, sent_sms? Tell me please, through which field I can set my message number (sms_id), so after a write to send_sms I could find for this sms_id status (dlr) in sent_sms? Wendy William пишет: You need Kannel 1.5 which supports sqlbox. Then setup the dlr in kannel.conf, Kannel will automatically store to your created table. - Original Message From: Diverse dive...@mobilmir.ru To: users@kannel.org Sent: Thu, August 18, 2011 5:39:29 PM Subject: DLR and sqlbox And how can I use sending messages through the base sqlbox, and link data from tables send_sms, sent_sms? Tell me please, through which field I can set my message number (sms_id), so after a write to send_sms I could find for this sms_id status (dlr) in sent_sms? -- -- С уважением, Александр Сухарев Системный администратор Цифроград Ставрополь тел: (9624) 40-06-66 e-mail: dive...@mobilmir.ru icq: 272375131 skype: undive...@skype.com jabber: dive...@jabber.ru Willy Mularto F300HD+MR18DE (NLC1725) http://www.binbit.co.id/ -- С уважением, Александр Сухарев Системный администратор Цифроград Ставрополь тел: (9624) 40-06-66 e-mail: dive...@mobilmir.ru icq: 272375131 skype: undive...@skype.com jabber: dive...@jabber.ru
Re: Questions regarding MySQL dlr and sqlbox
Hello, Would really appreciate some inputs / more information. Pointers to the documentation / posts will also help. Thanks, Sindu - Original Message From: Sindu R riss.regis...@yahoo.com To: users@kannel.org Sent: Wed, 13 January, 2010 3:20:58 PM Subject: Questions regarding MySQL dlr and sqlbox Hi, I have been learning to use Kannel for MT and MO messages and have successfully managed to get it working. My initial configuration was using dlr-storage = internal and have now switched to using MySQL dlr. Though the configuration works fine, I have some basic questions in this regard. 1) What is the basic difference in using dlr-storage = internal and dlr-storage = mysql? I understand that in the first case, dlrs are stored in the memory and in the second case, mysql db is used.. However, since this is used internally by Kannel and the entries are finally deleted from the table, can anyone help me understand how using mysql for dlr storage will be helpful. In a typical app scenario, what benefit will using mysql dlr provide over using internal dlr storage? 2) Though my understanding was initially incorrect, I now understand that in order to store the dlrs, I need to have my own table and the dlr-url should handle the requirement of adding / updating the dlr information in my custom table as per my app requirement. I just recently came across sqlbox and was wondering if using sqlbox would simplify managing sent messages and delivery reports. a) I understand that it can be used for MT messages by adding the messages to be sent to the send_sms table and once sent will be moved to the sent_sms table. Will these messages continue to remain in the sent_sms table? b) Will sqlbox also help in handling MO messages and delivery reports? Will the delivery reports also get stored in any table or would we need to handle this in code as when not using sqlbox? c) If sqlbox handles delivery reports as well, what is the significance of the dlr-url when using sqlbox? It would be really great if someone could answer these queries. Thanks, Sindu The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/ The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/
Re: Questions regarding MySQL dlr and sqlbox
1 and 2, you have answered your own question ;) 2.a, 2.b, 2.c SQLBox Store all MO, MT, and DLR in sent_sms table (it doesn't delete it from that table). Do not use SQLBox with current CVS and stable version. It still incompatible. Willy sangpr...@gmail.com On Jan 15, 2010, at 9:22 AM, Sindu R wrote: Hello, Would really appreciate some inputs / more information. Pointers to the documentation / posts will also help. Thanks, Sindu - Original Message From: Sindu R riss.regis...@yahoo.com To: users@kannel.org Sent: Wed, 13 January, 2010 3:20:58 PM Subject: Questions regarding MySQL dlr and sqlbox Hi, I have been learning to use Kannel for MT and MO messages and have successfully managed to get it working. My initial configuration was using dlr-storage = internal and have now switched to using MySQL dlr. Though the configuration works fine, I have some basic questions in this regard. 1) What is the basic difference in using dlr-storage = internal and dlr-storage = mysql? I understand that in the first case, dlrs are stored in the memory and in the second case, mysql db is used.. However, since this is used internally by Kannel and the entries are finally deleted from the table, can anyone help me understand how using mysql for dlr storage will be helpful. In a typical app scenario, what benefit will using mysql dlr provide over using internal dlr storage? 2) Though my understanding was initially incorrect, I now understand that in order to store the dlrs, I need to have my own table and the dlr-url should handle the requirement of adding / updating the dlr information in my custom table as per my app requirement. I just recently came across sqlbox and was wondering if using sqlbox would simplify managing sent messages and delivery reports. a) I understand that it can be used for MT messages by adding the messages to be sent to the send_sms table and once sent will be moved to the sent_sms table. Will these messages continue to remain in the sent_sms table? b) Will sqlbox also help in handling MO messages and delivery reports? Will the delivery reports also get stored in any table or would we need to handle this in code as when not using sqlbox? c) If sqlbox handles delivery reports as well, what is the significance of the dlr-url when using sqlbox? It would be really great if someone could answer these queries. Thanks, Sindu The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/ The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/
Re: Questions regarding MySQL dlr and sqlbox
Thanks for responding Willy. With regard to (1), if sqlbox is not being used, what is the benefit of using mysql dlr over using internal dlr? With which version is sqlbox compatible? Thanks, Sindu - Original Message From: Willy Mularto sangpr...@gmail.com To: Sindu R riss.regis...@yahoo.com Cc: users@kannel.org Sent: Fri, 15 January, 2010 8:44:01 AM Subject: Re: Questions regarding MySQL dlr and sqlbox 1 and 2, you have answered your own question ;) 2.a, 2.b, 2.c SQLBox Store all MO, MT, and DLR in sent_sms table (it doesn't delete it from that table). Do not use SQLBox with current CVS and stable version. It still incompatible. Willy sangpr...@gmail.com On Jan 15, 2010, at 9:22 AM, Sindu R wrote: Hello, Would really appreciate some inputs / more information. Pointers to the documentation / posts will also help. Thanks, Sindu - Original Message From: Sindu R riss.regis...@yahoo.com To: users@kannel.org Sent: Wed, 13 January, 2010 3:20:58 PM Subject: Questions regarding MySQL dlr and sqlbox Hi, I have been learning to use Kannel for MT and MO messages and have successfully managed to get it working. My initial configuration was using dlr-storage = internal and have now switched to using MySQL dlr. Though the configuration works fine, I have some basic questions in this regard. 1) What is the basic difference in using dlr-storage = internal and dlr-storage = mysql? I understand that in the first case, dlrs are stored in the memory and in the second case, mysql db is used.. However, since this is used internally by Kannel and the entries are finally deleted from the table, can anyone help me understand how using mysql for dlr storage will be helpful. In a typical app scenario, what benefit will using mysql dlr provide over using internal dlr storage? 2) Though my understanding was initially incorrect, I now understand that in order to store the dlrs, I need to have my own table and the dlr-url should handle the requirement of adding / updating the dlr information in my custom table as per my app requirement. I just recently came across sqlbox and was wondering if using sqlbox would simplify managing sent messages and delivery reports. a) I understand that it can be used for MT messages by adding the messages to be sent to the send_sms table and once sent will be moved to the sent_sms table. Will these messages continue to remain in the sent_sms table? b) Will sqlbox also help in handling MO messages and delivery reports? Will the delivery reports also get stored in any table or would we need to handle this in code as when not using sqlbox? c) If sqlbox handles delivery reports as well, what is the significance of the dlr-url when using sqlbox? It would be really great if someone could answer these queries. Thanks, Sindu The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/ The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/ The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/
Questions regarding MySQL dlr and sqlbox
Hi, I have been learning to use Kannel for MT and MO messages and have successfully managed to get it working. My initial configuration was using dlr-storage = internal and have now switched to using MySQL dlr. Though the configuration works fine, I have some basic questions in this regard. 1) What is the basic difference in using dlr-storage = internal and dlr-storage = mysql? I understand that in the first case, dlrs are stored in the memory and in the second case, mysql db is used.. However, since this is used internally by Kannel and the entries are finally deleted from the table, can anyone help me understand how using mysql for dlr storage will be helpful. In a typical app scenario, what benefit will using mysql dlr provide over using internal dlr storage? 2) Though my understanding was initially incorrect, I now understand that in order to store the dlrs, I need to have my own table and the dlr-url should handle the requirement of adding / updating the dlr information in my custom table as per my app requirement. I just recently came across sqlbox and was wondering if using sqlbox would simplify managing sent messages and delivery reports. a) I understand that it can be used for MT messages by adding the messages to be sent to the send_sms table and once sent will be moved to the sent_sms table. Will these messages continue to remain in the sent_sms table? b) Will sqlbox also help in handling MO messages and delivery reports? Will the delivery reports also get stored in any table or would we need to handle this in code as when not using sqlbox? c) If sqlbox handles delivery reports as well, what is the significance of the dlr-url when using sqlbox? It would be really great if someone could answer these queries. Thanks, Sindu The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/