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 < ing_christian2...@yahoo.fr> wrote: > yes i use kannel as smpp client. So please what must i do to solve this > issue ? > > *Christian N'GOLE* > > > > <http://www.smseco.com> > > General Manager WEB PLURIEL > > > Abidjan - Cocody > > *Adresse* : 27 BP 1222 Abj 27 > > *Email* : supp...@smseco.com > > *Tel* : +225 22 42 89 62 > > *Cel* : +225 07 74 97 97 > > *Site Web* : www.smseco.com > > > --- En date de : *Jeu 15.7.10, brett skinner <tatty.dishcl...@gmail.com>*a > écrit : > > > De: brett skinner <tatty.dishcl...@gmail.com> > Objet: Re: Mysql Timestamp issue > À: "N'Golé Christian" <ing_christian2...@yahoo.fr> > Cc: users@kannel.org > 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 < > ing_christian2...@yahoo.fr<http://mc/compose?to=ing_christian2...@yahoo.fr> > > 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. >> >> >> > >