but when kannel look for dlrsuch this : DEBUG: sql: SELECT mask, service, url, source, destination, boxc FROM kannel_dlrs WHERE smsc='voodosms' AND ts='10';
It could get wrong value because all dlrs from this smsc have the same ts value. So my script gets wrong parameters so. You see or i'm wrong ? Christian N'GOLE General Manager WEB PLURIEL Abidjan - CocodyAdresse : 27 BP 1222 Abj 27Email : [email protected] : +225 22 42 89 62Cel : +225 07 74 97 97Site Web : www.smseco.com --- En date de : Jeu 15.7.10, brett skinner <[email protected]> a écrit : De: brett skinner <[email protected]> Objet: Re: Mysql Timestamp issue À: "N'Golé Christian" <[email protected]> Date: Jeudi 15 juillet 2010, 11h19 No it is for Kannel use only. If you want to do extra processing on DLR then do it through script that handles the HTTP post to the specified URL. On Thu, Jul 15, 2010 at 11:18 AM, N'Golé Christian <[email protected]> wrote: yes i know that ! so if i understand this value is not important for dlrs managing ? Christian N'GOLE General Manager WEB PLURIEL Abidjan - Cocody Adresse : 27 BP 1222 Abj 27Email : [email protected] Tel : +225 22 42 89 62Cel : +225 07 74 97 97 Site Web : www.smseco.com --- En date de : Jeu 15.7.10, brett skinner <[email protected]> a écrit : De: brett skinner <[email protected]> Objet: Re: Mysql Timestamp issue À: "N'Golé Christian" <[email protected]> Cc: [email protected] Date: Jeudi 15 juillet 2010, 11h15 Firstly that table is for use by Kannel as a storage so that you do not lose any DLR if the box goes down. If you want more information for DLRs when sending sms you need to append the dlr-url parameter to the end of the URL that you are using. Also make sure that you are using the dlr-mask parameter. In that URL you can specify what information you would like posted back. Please see the user guide for details. Regards, On Thu, Jul 15, 2010 at 11:11 AM, N'Golé Christian <[email protected]> wrote: yes i use kannel as smpp client. So please what must i do to solve this issue ? Christian N'GOLE General Manager WEB PLURIEL Abidjan - Cocody Adresse : 27 BP 1222 Abj 27Email : [email protected] Tel : +225 22 42 89 62Cel : +225 07 74 97 97 Site Web : www.smseco.com --- En date de : Jeu 15.7.10, brett skinner <[email protected]> a écrit : De: brett skinner <[email protected]> Objet: Re: Mysql Timestamp issue À: "N'Golé Christian" <[email protected]> Cc: [email protected] Date: Jeudi 15 juillet 2010, 11h02 Hi Are you using SMPP? If so then the ts field although it would seem is a timestamp but it acutally maps to the unique ID provided by the SMSC for that message. I asked this question a little while ago and that was the answer I got and it seems to be correct from my testing. The group can correct me if I am wrong. Regards, On Thu, Jul 15, 2010 at 10:43 AM, N'Golé Christian <[email protected]> wrote: Heemmo Group, I still have problem with mysql ts value. when kannel gets dlrs from my smsc the field ts has the same value. 2010-07-14 06:32:42 [31512] [10] DEBUG: DLR[mysql]: Looking for DLR smsc=vodoosms, ts=10, dst=22507484497, type=1 2010-07-14 06:32:42 [31512] [10] DEBUG: sql: SELECT mask, service, url, source, destination, boxc FROM kannel_dlrs WHERE smsc='vodoosms' AND ts='10'; I contacted my smsc but he told me that this is kannel issue. Please i need help.
