There is nothing magical in sqlbox. It sits between bearerbox and smsbox and it just records data in the database. Each message = 1 record in the table independetly if the message is outgoing sms (MT) , incoming sms (MO) or delivery report. It is nice and simple way to have a full history of communication.
So I do not need any extra dlr message handling - a record in the database if enough for me. But only on condition that it would be possible to recognize which dlr record corresponds to the record describing sent sms. On the other hand the method with dlr-url _requires_ the existence of the url if I want to avoid stupid log entries. What is more kannel unnecessarily runs the http client to make dlr-url fetch. It is waste of CPU time RAM usage etc. In case of sms receiving there is a "exec" entry (sms-service) which allows me to forget about http protocol and get all data directly with my shell script. This way I would not need any working http server (which takes next resourses) but dlr-url requires such server. > How it works is, once kannel receives a dlr, it matches against its > dlr database, if got a macth, it then calls your own dlr-url to > trigger your own application so you can reccord the status and do > whatever you want with it. If the dlr is for a final status, the > kannel deletes that dlr reccord. > > With sqlbox, I don't know how dlrs exactly works. Have you tried to > put in your dlr-url your own id only? does kannel complains that it is > not a valid url ? > > Regards > |-----------------------------------------------------------------------------------------------------------------| > Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier > celular y Nextel > en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via > SMS y GPRS online > Visitenos en www.perusms.NET www.smsglobal.com.mx y > www.pravcom.com > > > > 2010/9/16 dorian <doria...@o2.pl>: > >> Thanks a lot for reply. >> >> Using the sqlbox I see now the MT and DLR record in the database which >> has the same 'dlr_url' field with my id and it looks like the problem is >> solved. >> >> Anyway is it the only solution? >> >> The 'dlr_url' field contains the whole http link which for me is >> completely useless and is needlessly long as the only sms id is interesting. >> >> Next subject is that having database I do not need to fire up any http >> url when delivery report is sent back. It waste of CPU time only. >> So I am looking for something which could give me same/similar results >> in database without necessity of creating dlr http site Such site is >> completely useless for me. >> >> >> >> >>> you need to add your own different id to each of your messages in the >>> dlr-url you send with the message. >>> >>> >>> |-----------------------------------------------------------------------------------------------------------------| >>> Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier >>> celular y Nextel >>> en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via >>> SMS y GPRS online >>> Visitenos en www.perusms.NET www.smsglobal.com.mx y >>> www.pravcom.com >>> >>> >>> >>> 2010/9/16 dorian <doria...@o2.pl>: >>> >>> >>>> Let's assume that I am sending 3 sms'es (MTs) to switched off terminal. >>>> Next the terminal is switched on. >>>> Let's assume the only 2 of them are delivered. >>>> >>>> The (maybe stupid) question is: >>>> how to find out which dlr report refers to which sms sent? >>>> >>>> I cannot find a "key" which could be used to "bind" dlr report with sms >>>> as a result I don't know how to detect which sms has been discarded. >>>> >>>> I am using bearerbox-sqlbox-smsbox with CIMD2 smsc. >>>> >>>> >>>> Regards >>>> Dorian >>>> >>>> >>>> >>>> >>>> >>> >> > >