RE: Help store DLR REPORTS
Dear , the group = dlr-db Is just used to store dlr till it returns from operator and once it return it will be deleted instantaneously . Its mainly advantage is persistence keep DLR till come from operator even if your kannel boxes restarted . Best Regards, Egypt M +20 (10) 3325373 | Tel +20 (50) 2528897 Saudi STC Mobile + 966 500 259791 -Original Message- From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf Of Carlos Massoglia Lillo Sent: Wednesday, December 21, 2011 8:11 PM To: mohamed keita Cc: users kannel Subject: Re: Help store DLR REPORTS 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
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: 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
Re: Help store DLR REPORTS
On Wed, 2011-12-21 at 10:21, Jorge Raimundo wrote: 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. You are right. Userguide could be improved but keep in mind that the Kannel project does not have money so everything is done when someone have enough time and goodwill to contribute code or documentation. -- Kind regards, Milan -- Arvanta, IT Securityhttp://www.arvanta.net Please do not send me e-mail containing HTML code or documents in proprietary format (word, excel, pps and so on)
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: Help store DLR REPORTS
On Wed, 2011-12-21 at 11:17, Jorge Raimundo wrote: 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. Well, sentence '*read the userguide carefully*' is there because it must be done that way if anyone want to understand it. And that is because is not complete or perfect. There are a lot of users questions on this mailing list from the people who are lazy to even read userguide once, at least. 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. Personally, I don't think the wiki with open access is good method for maintaining any documentation but it could be better than nothing. Best method to help (IMO) is to send patches for code or documentation to development mailing list where developers can review and (if all is ok) apply patches. -- Kind regards, Milan -- Arvanta, IT Securityhttp://www.arvanta.net Please do not send me e-mail containing HTML code or documents in proprietary format (word, excel, pps and so on)
Re: Help store DLR REPORTS
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
Help store DLR REPORTS
Hello I managed to send and receive sms through kannel . Now, I want to store delivery reports files in mysql . I set up my file kannel.conf then create my database, but I can not see datas.Here , is my configuration file kannel.conf: group = core admin-port = 13000 admin-password = status-password = admin-allow-ip = 127.0.0.1,192.168.2.12 smsbox-port= 13001 wdp-interface-name = * log-file = /var/log/kannel/bearerbox.log #box-deny-ip = *.*.*.* box-allow-ip = 127.0.0.1 # Configuration wapbox #group = wapbox #bearerbox-host = localhost #log-file = /var/log/kannel/wapbox.log #log-level=4 #Configuration smsbox group =smsbox bearerbox-host = localhost global-sender=13003 sendsms-port=13003 log-level=4 log-file=/var/log/kannel/smsbox.log # Configuration send-sms user(Parametres de connexion avec le navigateur) group= sendsms-user username=fyle password=fyle #concatenation=true # Configuration sms-service group=sms-service keyword=test text=ok c'est bon # Smsc (telephone portable) group = smsc smsc = at modemtype = samsung device =/dev/ttyACM0 log-level=1 host=192.168.2.12 #Configuration Modem Samsung group = modems id = samsung name = SAMSUNG Mobile USB Modem detect-string = samsung init-string = AT+CNMI=2,1,0,0,0 speed=9600 # Configuration connection mysql group = mysql-connection id = mydlr host = localhost username = root password = fyle database = kannel max-connections =1 # 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 field-boxc-id = boxc Thank 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
Re: Help store DLR REPORTS
On Tue, 2011-12-20 at 13:08, mohamed keita wrote: Hello I managed to send and receive sms through kannel . Now, I want to store delivery reports files in mysql . I set up my file kannel.conf then create my database, but I can not see datas. This is temporary storage for DLRs and not permanent. Read userguide section 'External delivery report (DLR) storage' carefully. Few hours ago I answered that question in _this_ mailing list. Did you read it? Here , is my configuration file kannel.conf: group = core admin-port = 13000 admin-password = status-password = admin-allow-ip = 127.0.0.1,192.168.2.12 smsbox-port= 13001 wdp-interface-name = * log-file = /var/log/kannel/bearerbox.log #box-deny-ip = *.*.*.* box-allow-ip = 127.0.0.1 # Configuration wapbox #group = wapbox #bearerbox-host = localhost #log-file = /var/log/kannel/wapbox.log #log-level=4 #Configuration smsbox group =smsbox bearerbox-host = localhost global-sender=13003 sendsms-port=13003 log-level=4 log-file=/var/log/kannel/smsbox.log # Configuration send-sms user(Parametres de connexion avec le navigateur) group= sendsms-user username=fyle password=fyle #concatenation=true # Configuration sms-service group=sms-service keyword=test text=ok c'est bon # Smsc (telephone portable) group = smsc smsc = at modemtype = samsung device =/dev/ttyACM0 log-level=1 host=192.168.2.12 #Configuration Modem Samsung group = modems id = samsung name = SAMSUNG Mobile USB Modem detect-string = samsung init-string = AT+CNMI=2,1,0,0,0 speed=9600 # Configuration connection mysql group = mysql-connection id = mydlr host = localhost username = root password = fyle database = kannel max-connections =1 # 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 field-boxc-id = boxc Thank 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 -- Kind regards, Milan -- Arvanta, IT Securityhttp://www.arvanta.net Please do not send me e-mail containing HTML code or documents in proprietary format (word, excel, pps and so on)