How to define a fallback smsc?
Hello all! We have a customer that owns a restaurant and he usually sends SMSs every morning informing his customers of his dishes for the day. Problem occurs when the SMS takes too long to be delivered and misses the useful delivery period (e.g. when it is delivered only when the customer has already lunched). I'd like to have some kind of fallback plan that uses another smsc when the current one isn't delivering. To be more precise, we were getting the following messages in the smsc.log: SMPP[*]: Not ACKED message found, will retransmit. SENT90sec. ago, SEQ12345, DST123123456789 I'd like to be able to use an alternative smsc when I get this kind of log lines. Is it possible? Best regards, Jorge
DLR status of 8 (even if it goes well)
Hi all. I have a configuration like this: ┌- smsbox - sqlbox - bearerbox -┐ | | └---(dlr)--┘ I insert a message directly on the sqlbox's sent_sms table with the boxc_id of the smsbox, then it is sent by bearerbox which routes the dlr incoming message to smsbox. The smsbox then uses the dlr_url to register the dlr info and passes it to the sqlbox. With this configuration I have three rows containing dlr info per message. On the dlr table of kannel: ┌---┬-┬---┬┬---┬ ---┬--┬┬┐ | smsc | ts | destination | source | service | url | mask | status | boxc | ├---┼-┼---┼┼---┼---┼--┼┼┤ | ROUTO | -00-00 00:00:00 | +35191**7 %2B351919331367 | MV | | http://..http://easymessage.multivision.pt/services/teste.p.| 31 |0 | SMSBOX | └---┴-┴---┴┴---┴---┴--┴┴┘ On sqlbox's sent_sms table I have this ┌┬--┬┬--┬--┬-┬--┬-┬ --┬-┬--┬-┬-┬┬ - - - | sql_id | momt | sender | receiver | msgdata | udhdata | time | smsc_id | service | ... | dlr_mask | dlr_url | ... |boxc_id | ├┼--┼┼--┼--┼- ┼--┼-┼--┼-┼--┼-┼-┼┼ - - - | 33 | DLR | MV | 35191... | ACK%2F | [BLOB] | 13...| * | tester | ... | 8| http:...| ... |SMSBOX | └┴--┴┴--┴--┴-┴--┴-┴--┴-┴--┴-┴- ┴┴ - - - On my simple test table that records the info passed on the dlr url I have this ┌-┬-┬--┐ | ts | destination | type | ├-┼-┼--┤ | 2012-01-06 11:23:15 | 91**7 | 8| └-┴-┴--┘ All these records regard to the same message. So, my question is: if I recieved the SMS successfully having dlr status of 0 on kannel's dlr table and showing as well delivered on my provider's dashboard, why is it that I have a dlr status of 8 (smsc submit) on the other two tables, instead of 1 (delivery success)? The smsc log has this for the submit_sm_resp: SMPP PDU 0x7dddf0 dump: type_name: submit_sm_resp command_id: 2147483652 = 0x8004 command_status: 0 = 0x sequence_number: 12 = 0x000c message_id: 817456359 SMPP PDU dump ends. Best regards, Jorge -- [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: DCS problem
I used smsbox to check how would be a query inserted by smsbox on sqlbox. The result is: INSERT INTO send_sms ( sql_id, momt, sender, receiver, udhdata, msgdata, time, smsc_id, service, account, sms_type, mclass, mwi, coding, compress, validity, deferred, dlr_mask, dlr_url, pid, alt_dcs, rpi, charset, boxc_id, binfo, meta_data ) VALUES ( NULL, 'MT', 'MV', '35191**7', NULL, 'Hello+world', 1325675923, NULL, 'tester', NULL, 2, NULL, NULL, 0, NULL, NULL, NULL, 31, ' http://my_domain/services/teste.php?type=%ddestination=91**7', NULL, NULL, NULL, NULL, 'SMSBOX', NULL, NULL); With this query the message is sent and received properly. So the problem was that MySQL had 0 as a default value for the unspecified columns, since this query specifies them all including those that are meant to be NULL, this worked fine. I changed my table to have NULL as a default value and I reinserted the query I was using yesterday: INSERT INTO send_sms( momt, sender, receiver, msgdata, sms_type, dlr_mask, dlr_url) VALUES ('MT', 'MV', '+3519**67', 'Hello world', 2, 31, ' http://my_domain/services/teste.php?type=%ddestination=91**7'); and it worked fine. Best regards, Jorge On Tue, Jan 3, 2012 at 4:33 PM, Jorge Raimundo jorge.raimu...@multivision.pt wrote: Hi all! I'm using sqlbox to send messages via SMPP, but I'm getting a very strange problem. I've decided to use smsbox to handle the DLR via the dlr_url. So let me see if I can explain all the situations occurring. *1st insertion on the database:* INSERT INTO send_sms( momt, sender, receiver, msgdata, sms_type, dlr_mask, dlr_url) VALUES ('MT', 'MV', '+3519**67', 'Hello world', 2, 31, ' http://my_domain/services/teste.php?type=%d%destination=91**7'); As you can see, the URL has an error (it should have type=%ddestination instead of type=%d%destination). This ended up in having a DLR with the status of 8 (!?) not properly registered by the php script since the url is malformed. *2nd insertion on the database:* INSERT INTO send_sms( momt, sender, receiver, msgdata, sms_type, dlr_mask, dlr_url) VALUES ('MT', 'MV', '+3519**67', 'Hello world', 2, 31, ' http://my_domain/services/teste.php?type=%ddestination=91**7'); This ended up in having a DLR with the status of 16 properly registered by my php script (yes, it works with the dlr_url not encoded). At this point I contacted the support of my provider to know why they where rejecting my messages. They told me that the messages where being sent with DCS=216. They told me to set DCS to 1 if I'm sending 7-bit messages or DCS to 3 or 0 if I'm submitting ISO (8-bit message). In fact on the smsc log I have this: data_coding: 216 = 0x00d8 *3rd insertion on the database:* Wondering why the change on the dlr_url gave different DLR status, I made the following INSERT INTO send_sms( momt, sender, receiver, msgdata, sms_type, dlr_mask, dlr_url) VALUES ('MT', 'MV', '+3519**67', 'Hello world', 2, 31, '7'); This ended up in having a DLR with the status of 0. Yes, I received the message, but... the text was this: 䡥汬漠睯牬搀 The smsc log still gives: data_coding: 216 = 0x00d8 *4th insertion on the database:* Testing what would happen if I passed a URL encoded dlr_url 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%2Fmy_domain%2Fservices%2Fteste.php%3Ftype%3D%25d%26destination%3D91**7'); This ended up in having a DLR with the status of 0. I received the same text: 䡥汬漠睯牬搀 The smsc log still gives: data_coding: 216 = 0x00d8 The smsbox complains that: ERROR: URL http%3A%2F%2Fmy_domain%2Fservices%2Fteste.php%3Ftype%3D%25d%26destination%3D91**7 doesn't start with `http://' nor `https://' ERROR: Couldn't send request to http%3A%2F%2Fmy_domain%2Fservices%2Fteste.php%3Ftype%3D%25d%26destination%3D91**7 *Summarizing:* I don't know what's happening here. Different values of the dlr_url cause different SMSC reactions to the request. The DCS value is strange and I'm getting Chinese characters when I should receive a Hello world. Anyone could, please, point out what I am missing here? -- [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: Error installation sqlbox
You have to insert the messages directly on the send_sms table, the sql box will generate the message and pass it to the sent_sms. So, you insert on the send_sms and sqlbox will process it and pass it to the sent_sms. At the end you'll have an empty send_sms and the sent_sms will have your message. Check http://www.blogalex.com/wp-content/uploads/2008/11/userguide.html#AEN478 Best regrads, Jorge On Sat, Dec 31, 2011 at 6:47 PM, Bui Duong The buiduong...@gmail.comwrote: thanks! but I am install http://www.the-stagg.co.uk/?p=11 and viiew file config attach Khi Con Đặt Hết Tâm Hồn Vào Đó, Đó Là Thứ Tuyệt Vời Nhất ! !(^-^)! Information Technology: Network Manager, Design Website, PC's Trouble's... Name: Bùi Dương Thế Email: buiduong...@gmail.com Skype: buiduongthe Phone: 0976570931 On 1 January 2012 00:40, mohamed keita keita1...@hotmail.fr wrote: Hello. I managed to install sqlbox with the command ./configure - with-kannel-dir = / etc / kannel . / etc / kannel is the installation folder of kannel. Now i have one problem, configuring sqlbox. Here is my sqlbox configuration file. I managed to boot sqlbox but i have nothing in sent_sms and send_sms tables. group = sqlbox id = sqlbox-db smsbox-id = sqlbox #global-sender = bearerbox-host = localhost bearerbox-port = 13001 smsbox-port = 13008 sql-log-table = sent_sms sql-insert-table = send_sms log-file = /var/log/kannel/sqlbox.log log-level = 0 # Configuration connection mysql group = mysql-connection id = sqlbox-db host = localhost username = root password = fyle database = kannel max-connections =2 is that the bearerbox-host must be identical to the smsbox-port in core group? thanks in advance. -- [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: Sqlbox doesn't save any sms into mysql tables
You have to insert the messages directly on the send_sms table, the sql box will generate the message and pass it to the sent_sms. So, you insert on the send_sms and sqlbox will process it and pass it to the sent_sms. At the end you'll have an empty send_sms and the sent_sms will have your message. Checkhttp://www.blogalex.com/wp-content/uploads/2008/11/userguide.html#AEN478 Best regrads, Jorge On Sun, Jan 1, 2012 at 7:12 PM, Suranga Ranjith sura.btac...@gmail.comwrote: Hi All, I setup kannel gw with sqlbox. somhow it creates 2 tables (send_sms sent_sms), but no sms within that tables at anytime. How can I resolve this? #sqlbox.conf group = sqlbox id = sqlbox-db smsbox-id = sqlbox bearerbox-host = localhost bearerbox-port = 13001 smsbox-port = 13005 smsbox-port-ssl = false sql-log-table = sent_sms sql-insert-table = send_sms log-file = /var/log/kannel/kannel-sqlbox.log log-level = 0 group = mysql-connection id = sqlbox-db host = localhost username = root password = root database = kannel Thank you! -- [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
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
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: Help store DLR REPORTS
Hi! I've set up sqlbox with success because I need to send bulk SMS. I've tested to send an SMS via sqlbox with success, but I don't see on the sent_sms table any info regarding the delivery report (dlr) except the mask and the url. Could you please enlighten me on how to have dlr info with sqlbox? Best regards, Jorge On Wed, Dec 21, 2011 at 6:10 PM, Carlos Massoglia Lillo carlos.massog...@mindfree.cl wrote: You can use SQLBOX. It has two tables sent_sms and send_sms. In sent_sms table are saved the DLR automatically. best regards, El mié, 21-12-2011 a las 13:43 +0100, mohamed keita escribió: Hello I read the documentation(user documentation) on dlr. I uninstalled and recompiled kannel with - with-mysql. Then I update my core group by adding dlr-storage = mysql. I added the following lines to my configuration lines. # Configuration connection mysql group = mysql-connection id = mydlr host = localhost username = root password = fyle database = kannel max-connections =2 # Groupe dlr-db(stocker les informations sur les sms envoyés) group = dlr-db id = mydlr 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 but i have no datas in my database. I have no data in my database. I field-boxc-id = boxc -- 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: Sending SMS to multiple destinations via SMPP
Thanks for your answers. I've compiled sqlbox and it's working. Best regards, Jorge On Wed, Dec 21, 2011 at 2:03 PM, ha...@aeon.pk ha...@aeon.pk wrote: You can use SQLBOX in raw form, or some 3rd party application behind kannel for bulk messaging. On Wed, Dec 21, 2011 at 3:45 PM, Jorge Raimundo jorge.raimu...@multivision.pt wrote: Hi all! I've successfully managed to send an SMS via SMPP using kannel, but the reason why I started using SMPP in the first place is because I was told it is the best way to send large amounts of messages. I want to send a bulk SMS with the same text to, let's say, 3000 destinations. Do I need to make 3000 http requests to the kannel smsbox? If not, how is it done? And how is dlr going to address these messages? Best regards, Jorge -- [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: Help store DLR REPORTS
Hi! On Tue, Dec 20, 2011 at 1:00 PM, Milan P. Stanic m...@arvanta.net wrote: This is temporary storage for DLRs and not permanent. Read userguide section 'External delivery report (DLR) storage' carefully. I'm sorry, but I can't find on the userguide's section *External delivery report (DLR) storage* any mention that this is a temporary storage. Here's the text: Delivery reports are supported by default internally, which means all DLRs are stored in the memory of the bearerbox process. This is problematic if bearerbox crashes or you take the process down in a controlled way, but there are still DLRs open. Therefore you may use external DLR storage places, i.e. a MySQL database. The rest of the section is about specific configurations on the different types of databases and the configuration groups needed on the config file. Maybe the paragraph above should be revised to make the temporary storage clear and avoid such confusions. Best regards, Jorge [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
Sending SMS to multiple destinations via SMPP
Hi all! I've successfully managed to send an SMS via SMPP using kannel, but the reason why I started using SMPP in the first place is because I was told it is the best way to send large amounts of messages. I want to send a bulk SMS with the same text to, let's say, 3000 destinations. Do I need to make 3000 http requests to the kannel smsbox? If not, how is it done? And how is dlr going to address these messages? Best regards, Jorge -- [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: Help store DLR REPORTS
Yes, I know, please don't get me wrong. In fact I'm really pleased and surprised by the amount and quality of the documentation available. What I said before was just to say that *read the userguide carefully* doesn't always apply as a useful answer. In my case I managed to download, compile, configure and send an SMS using the userguide. Only when I reached the point of handling DLR and bulk messages I needed extra help from the mailing list. This is already very good. If you allow me to give a suggestion, I would recommend to have the documentation also in a wiki where users could edit, change, correct and improve the documentation. If this was possible, I would gladly have edited the wiki to include these little changes I've found necessary on the DLR sections. Best regards, Joreg [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-mask not on the url
Hi! Thanks for your reply. On Mon, Dec 19, 2011 at 6:51 PM, Milan P. Stanic m...@arvanta.net wrote: In URL as userguide tells, not in config file. Well, then the user guide should be more explicit on that. When you say *IFyou specify dlr-mask on the URL * you're giving the reader the feeling that there might be another way to specify the dlr-mask. It should read *To enable the reports you must specify dlr-mask and dlr-url on the URL you pass on to kannel*. But this leaves me with another question: The userguide describes a process that needs a server-side script (dlr-url) that processes the report info, but then I do not know what is the purpose of having the mysql-connection and dlr-db groups. I've sent a message and the table defined on the dlr-db remains empty. My configuration for these groups is below: *group = mysql-connection id = mydlr host = localhost username = kannel password = kannel database = kannel max-connections = 1 group = dlr-db id = mydlr 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* I am clearly missing something here. Could you enlighten me, please? Best regards, Jorge -- [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-mask not on the url
Hi Milan! Thanks for your reply! It got clearer now. You can set 'dlr-url' in sendsms-user block/section but you must specify dlr-mask as CGI parameter, if you want DLR at all, of course. Or, you can set both (dlr-url and dlr-mask) as CGI parameters. If I want to set dynamic parameters, like my own message ID, then it must be a CGI parameter, correct? How can I pass the message's destination number to the dlr-url? Can I do something like dlr-url= http://www.xyz.com/cgi/dlr.php?myId=123456type=%ddestination=%d ? Will kannel be able to know what to insert in the second parameter? Best regards, Jorge -- [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-mask not on the url
Great! Thanks a lot for your support. Best regards, Jorge -- [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: Message Queued - 0: Accepted for delivery
Check the smsc log (in your case */var/log/kannel/smsc.log*). On Mon, Dec 19, 2011 at 6:16 AM, Modus - WAP/SMS-Gateway s...@quito.oksigeno.com wrote: ** I have this problem: When I send a message I got 0: Accepted for delivery but the message still Queued. Any sugestion? Below more info: ###0: Accepted for delivery ###Kannel bearerbox version `1.4.3'. Build `Apr 6 2010 13:16:08', compiler `4.4.3'. System Linux, release 2.6.32-21-generic-pae, version #32-Ubuntu SMP Fri Apr 16 09:39:35 UTC 2010, machine i686. Hostname quito, IP 127.0.1.1. Libxml version 2.7.6. Using OpenSSL 0.9.8k 25 Mar 2009. Compiled with MySQL 5.1.41, using MySQL 5.1.41. Using native malloc. Status: running, uptime 0d 0h 2m 3s WDP: received 0 (0 queued), sent 0 (0 queued) SMS: received 0 (0 queued), sent 0 (0 queued), store size -1 SMS: inbound (0.00,0.00,0.00) msg/sec, outbound (0.00,0.00,0.00) msg/sec DLR: 0 queued, using internal storage Box connections: smsbox:sql-app, IP 127.0.0.1 (0 queued), (on-line 0d 0h 2m 2s) SMSC connections: *smsc-Modus*AT2[smsc-Modus] (online 120s, rcvd 0, sent 0, failed 0, queued 0 msgs) ###MY Conf File # # Sample configuration file for Kannel bearerbox on Debian. # See the documentation for explanations of fields. # # HTTP administration is disabled by default. Make sure you set the # password if you enable it. #group = core #admin-port = 13000 #admin-password = smpp07 #admin-deny-ip = *.*.*.* #admin-allow-ip = #wapbox-port = 13002 #wdp-interface-name = * #log-file = /var/log/kannel/bearerbox.log #box-deny-ip = *.*.*.* #box-allow-ip = 127.0.0.1 #group = wapbox #bearerbox-host = localhost #log-file = /var/log/kannel/wapbox.log group = core admin-port = 13000 smsbox-port = 13001 admin-password = smpp07 status-password = smpp07 log-file = /var/log/kannel/bearerbox.log log-level = 0 box-deny-ip = *.*.*.* box-allow-ip = 127.0.0.1 group = smsc smsc = at smsc-id = smsc-Modus modemtype = huawei_e220_00 device = /dev/ttyUSB0 sms-center = +5939589 my-number = +5939541 sim-buffering = true connect-allow-ip = 127.0.0.1 log-file = /var/log/kannel/smsc.log validityperiod = 167 keepalive = 50 group = modems id = huawei_e220_00 name = Huawei E220 detect-string = huawei init-string = AT+CNMI=2,1,2,2,0 message-storage = sm speed = 460800 group = smsbox bearerbox-host = localhost sendsms-port = 13013 global-sender = 13013 smsbox-id = sql-app sendsms-chars = 0123456789 +- log-file = /var/log/kannel/smsbox.log log-level = 0 access-log = /var/log/kannel/access.log group = sendsms-user username = smpp password = smpp07 concatenation = true max-messages = 3 group = sms-service keyword = default get-url = http://quito/kannel/recievesms.php?sender=%ptext=%b; accept-x-kannel-headers = true max-messages = 3 concatenation = true catch-all = true Thanks in advance! -- [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
Can't send sms - FAILED Send SMS
Hi all. I'm trying to send sms but it fails and I can't figure out why. Via web I go to http://192.168.0.6:13013/cgi-bin/sendsms?username=testerpassword=foobarto=003519**67text=Hellofrom=MV On the smsbox I get: *INFO: smsbox: Got HTTP request /cgi-bin/sendsms from 192.168.0.134 INFO: sendsms used by tester INFO: sendsms sender:tester:MV (192.168.0.134) to:003519**67 msg:Hello DEBUG: Stored UUID eb7775c3-18fb-4ff1-9280-abee7dc3464e DEBUG: message length 5, sending 1 messages DEBUG: Status: 202 Answer: Sent. DEBUG: Delayed reply - wait for bearerbox DEBUG: Got ACK (0) of eb7775c3-18fb-4ff1-9280-abee7dc3464e DEBUG: HTTP: Resetting HTTPClient for `192.168.0.134'. DEBUG: Timeout for fd:24 appears. DEBUG: HTTP: Destroying HTTPClient area 0x7848b0. DEBUG: HTTP: Destroying HTTPClient for `192.168.0.134'.* On the bearerbox I get: *DEBUG: Thread 9 (gw/bb_boxc.c:boxc_sender) maps to pid 5042. DEBUG: Started thread 9 (gw/bb_boxc.c:boxc_sender) DEBUG: boxc_receiver: got boxc_id SMSBOX from 127.0.0.1 DEBUG: boxc_receiver: sms received DEBUG: send_msg: sending msg to boxc: SMSBOX DEBUG: HTTP: Creating HTTPClient for `192.168.0.134'. DEBUG: HTTP: Created HTTPClient area 0x7dba70.* On the access log I get: *send-SMS request added - sender:tester:MV 192.168.0.134 target:003519**67 request: 'Hello' FAILED Send SMS [SMSC:SMSC] [SVC:tester] [ACT:] [BINF:] [FID:] [META:] [from:MV] [to:003519**67] [flags:-1:0:-1:-1:-1] [msg:5:Hello] [udh:0:]* My configuration file has this: *# Config file for kannel group = core admin-port = 13000 admin-password = f00bar log-file = /var/log/kannel/kannel.log log-level = 1 access-log = /var/log/kannel/access.log dlr-storage = mysql smsbox-port = 13003 group = smsc smsc = smpp smsc-id = SMSC host = *** port = smsc-username = *** smsc-password = *** system-type = VMA log-file = /var/log/kannel/smsc.log log-level = 1 group = smsbox smsbox-id = SMSBOX bearerbox-host = localhost sendsms-port = 13013 log-file = /var/log/kannel/smsbox.log log-level = 1 access-log = /var/log/kannel/access.log sms-length = 160 group = sendsms-user username = tester password = foobar group = sms-service keyword = default text = No service specified group = mysql-connection id = mydlr host = localhost username = *** password = *** database = *** max-connections = 1 group = dlr-db id = mydlr 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* How can I find out what's going wrong? Best regards, -- [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: Can't send sms - FAILED Send SMS
Thank you for your replies! In fact I had an unnoticed error message in the smsc log: *ERROR: SMPP[ROUTO]: SMSC returned error code 0x000b (Invalid Destination Address) in response to submit_sm.* Changing the url from: http://192.168.0.6:13013/cgi-bin/sendsms?username=testerpassword=foobarto=003519**67text=Hellofrom=MV to http://192.168.0.6:13013/cgi-bin/sendsms?username=testerpassword=foobarto=+3519**67text=Hellofrom=MV Solved the problem. Best regards, Jorge P.S.: *Does your operator allow alphanumeric masking for your LA?* I was not sure, but I wanted to test. In fact it does. Anyway, I also tried to send with simple numbers on it and it didn't work due to the incorrect from address. On Mon, Dec 19, 2011 at 5:04 PM, ha...@aeon.pk ha...@aeon.pk wrote: Check following: - Does your operator allow alphanumeric masking for your LA? - Are your TON/NPI settings matching the ones given by the operator? Is 00351xx the right format for recipient numbers? Try sending to 351xx (00 is attached by SMSC itself, depending upon TON/NPI settings). Regards, On Mon, Dec 19, 2011 at 7:48 PM, Jorge Raimundo jorge.raimu...@multivision.pt wrote: Hi all. I'm trying to send sms but it fails and I can't figure out why. Via web I go to http://192.168.0.6:13013/cgi-bin/sendsms?username=testerpassword=foobarto=003519**67text=Hellofrom=MV On the smsbox I get: *INFO: smsbox: Got HTTP request /cgi-bin/sendsms from 192.168.0.134 INFO: sendsms used by tester INFO: sendsms sender:tester:MV (192.168.0.134) to:003519**67 msg:Hello DEBUG: Stored UUID eb7775c3-18fb-4ff1-9280-abee7dc3464e DEBUG: message length 5, sending 1 messages DEBUG: Status: 202 Answer: Sent. DEBUG: Delayed reply - wait for bearerbox DEBUG: Got ACK (0) of eb7775c3-18fb-4ff1-9280-abee7dc3464e DEBUG: HTTP: Resetting HTTPClient for `192.168.0.134'. DEBUG: Timeout for fd:24 appears. DEBUG: HTTP: Destroying HTTPClient area 0x7848b0. DEBUG: HTTP: Destroying HTTPClient for `192.168.0.134'.* On the bearerbox I get: *DEBUG: Thread 9 (gw/bb_boxc.c:boxc_sender) maps to pid 5042. DEBUG: Started thread 9 (gw/bb_boxc.c:boxc_sender) DEBUG: boxc_receiver: got boxc_id SMSBOX from 127.0.0.1 DEBUG: boxc_receiver: sms received DEBUG: send_msg: sending msg to boxc: SMSBOX DEBUG: HTTP: Creating HTTPClient for `192.168.0.134'. DEBUG: HTTP: Created HTTPClient area 0x7dba70.* On the access log I get: *send-SMS request added - sender:tester:MV 192.168.0.134 target:003519**67 request: 'Hello' FAILED Send SMS [SMSC:SMSC] [SVC:tester] [ACT:] [BINF:] [FID:] [META:] [from:MV] [to:003519**67] [flags:-1:0:-1:-1:-1] [msg:5:Hello] [udh:0:] * My configuration file has this: *# Config file for kannel group = core admin-port = 13000 admin-password = f00bar log-file = /var/log/kannel/kannel.log log-level = 1 access-log = /var/log/kannel/access.log dlr-storage = mysql smsbox-port = 13003 group = smsc smsc = smpp smsc-id = SMSC host = *** port = smsc-username = *** smsc-password = *** system-type = VMA log-file = /var/log/kannel/smsc.log log-level = 1 group = smsbox smsbox-id = SMSBOX bearerbox-host = localhost sendsms-port = 13013 log-file = /var/log/kannel/smsbox.log log-level = 1 access-log = /var/log/kannel/access.log sms-length = 160 group = sendsms-user username = tester password = foobar group = sms-service keyword = default text = No service specified group = mysql-connection id = mydlr host = localhost username = *** password = *** database = *** max-connections = 1 group = dlr-db id = mydlr 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* How can I find out what's going wrong? Best regards, -- [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
dlr-mask not on the url
Hi all! I'm reading the Userguide Chapter 10 that talks about SMS Delivery reports. In a given paragraph I find this: *If you specify *dlr-mask *on the URL you pass on to Kannel you also need to specify *dlr-url*.* If I understood correctly, there is the possibility to specify the *dlr-mask * somewhere else than the URL. If so, where is it? I've tried to insert it in any of the groups I have on the *kannel.conf*file, but the bearerbox always ends on PANIC saying that the *dlr-mask* directive shouldn't be there. If I can't place it on the *kannel.conf* file, where should it be? Best regards, Jorge -- [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
Noob general doubt - Just want to send messages via smpp
Hi all! In my company we've started working with a SMSC provider in order to send a large amount of messages on a regular basis. The provider stated that for a large amount of messages it is preferable to send them using the SMPP protocol, so basically we must have an application that works as an external short message entity (ESME) that connects to their SMSC. I've downloaded kannel from svn and managed to compile it successfully, but now I'm a bit lost without knowing how to pull this of. What do I need to configure and how do I use kannel to send messages in this particular case. Thanks for your time. Best regards, Jorge -- [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