Hi, That's what we (are supposed to) do : Our application is collection SMS, store them in a mysql db, then send them to kannel via http cgi. Dlr_url is sent with the cgi send command. The main pb is when kannel discard dlrs in the mysql db, as far as the Id may be repeated (on account of the 0-255 range values) when an ack is comming, we may have for exemple : If Total sms sending = 1020 we've got 4 identical sms id (1020/255), so kannel is selecting one ID : "SELECT mask, service, url, source, destination, boxc FROM dlr WHERE smsc='OSIRIS2' AND ts='123';" Which row in the dlr table kannel is returning ? In the dlr-url we put the sms id from our app DB (which is absolutely unique) : "DEBUG: DLR[mysql]: created DLR message for URL <http://localhost/combox/dlr.php?idenvoi=1744062&statut=%d> "
We can't be sure that the 123 kannel's sms id is the same sms with 1744062 identifer ! The only two ways we have would be : 1/ Changing the kannel's SQL statement from : SELECT mask, service, url, source, destination, boxc FROM dlr WHERE smsc='OSIRIS2' AND ts='123'; To SELECT mask, service, url, source, destination, boxc FROM dlr WHERE smsc='OSIRIS2' AND ts='123' AND destination='xxx'; If you know where in kannel please let us know it would be kind from you... 2/ Find why the id are not increasing more than 255. (that would be the better thing) Is it the SIM card or the modem itself? From Kannel ? As we just saw in the Wavecom guide, it is generated by the modem...It is cyclic on one byte (0 follows 255). Marco -----Message d'origine----- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Catalin Trifu Envoyé : samedi 9 avril 2005 12:37 À : users@kannel.org Objet : Re: RE : SMS ID back to 0 after 255 Hi, Try using dlr-url and dlr-mask and see what u get from kannel. Either way, as Alejandro pointed out in an above post it's better to let the dlr table on mysql in peace and let kannel discard dlrs. It's better in my opinion to store things on your application side and let kannel do it's job as it should; separate kannel's job, which is to be a gateway from the application which can do whatever you want it to do. Catalin JML wrote: > Thanks for your interest in our pb... > (Unfortunately !) the mysql field is set to varchar250 > How is the SMS Id generated ? > Is it by the modem/sim card or by Kannel ? > > Here is the log above. > As you can see, a 123 ID is given (<-- +CMGS: 123 ??). > A Dlr is inserted in mysql with ts=123, and when ack :got > STATUS-REPORT for message <123>: SO Kannel is doing : Looking for DLR > smsc=OSIRIS2, ts=123, dst=+33663730513, type=1 > But the SQL select syntax is : > SELECT mask, service, url, source, destination, boxc FROM dlr WHERE > smsc='OSIRIS2' AND ts='123'; > > The pb is that when id = 255, next one =0 ! > When mass sending, we have got a lot of sdame sms id !! > > What about changing the select SQL syntax in adding the phone number ? > Do you know where i can get it (Kannel 1.3.2). > > > Please any help would be very appreciated ... > Marco > > > 2005-04-08 18:34:51 [6243] [10] DEBUG: boxc_receiver: sms received > 2005-04-08 18:34:51 [6243] [10] DEBUG: send_msg: sending msg to box: > <127.0.0.1> 2005-04-08 18:34:53 [6243] [8] DEBUG: AT2[OSIRIS2]: --> > AT+CSQ^M 2005-04-08 18:34:53 [6243] [8] DEBUG: AT2[OSIRIS2]: <-- +CSQ: > 11,0 2005-04-08 18:34:53 [6243] [8] DEBUG: AT2[OSIRIS2]: <-- OK > 2005-04-08 18:34:53 [6243] [8] DEBUG: AT2[OSIRIS2]: --> AT+CPMS?^M > 2005-04-08 18:34:53 [6243] [8] DEBUG: AT2[OSIRIS2]: <-- +CPMS: > "SM",0,30,"SM",0,30 > 2005-04-08 18:34:53 [6243] [8] DEBUG: AT2[OSIRIS2]: <-- OK > 2005-04-08 18:34:53 [6243] [8] DEBUG: AT2[OSIRIS2]: TP-Validity-Period: > 24.0 hours > 2005-04-08 18:34:53 [6243] [8] DEBUG: Lock CNMA > 2005-04-08 18:34:53 [6243] [8] DEBUG: AT2[OSIRIS2]: --> AT+CMGS=18^M > 2005-04-08 18:34:53 [6243] [8] DEBUG: AT2[OSIRIS2]: <-- > > 2005-04-08 18:34:53 [6243] [8] DEBUG: AT2[OSIRIS2]: send command status: > 1 > 2005-04-08 18:34:53 [6243] [8] DEBUG: AT2[OSIRIS2]: --> > 0031000B913366730315F30000A704F4F29C0E > 2005-04-08 18:34:53 [6243] [8] DEBUG: AT2[OSIRIS2]: --> ^Z > 2005-04-08 18:34:54 [6243] [7] DEBUG: AT2[OSIRIS1]: --> AT+CSQ^M > 2005-04-08 18:34:54 [6243] [7] DEBUG: AT2[OSIRIS1]: <-- +CSQ: 6,3 > 2005-04-08 18:34:54 [6243] [7] DEBUG: AT2[OSIRIS1]: <-- OK > 2005-04-08 18:34:54 [6243] [7] DEBUG: AT2[OSIRIS1]: --> AT+CPMS?^M > 2005-04-08 18:34:54 [6243] [7] DEBUG: AT2[OSIRIS1]: <-- +CPMS: > "SM",0,30,"SM",0,30 > 2005-04-08 18:34:54 [6243] [7] DEBUG: AT2[OSIRIS1]: <-- OK > 2005-04-08 18:34:56 [6243] [8] DEBUG: AT2[OSIRIS2]: <-- > > 2005-04-08 18:34:56 [6243] [8] DEBUG: AT2[OSIRIS2]: <-- +CMGS: 123 > 2005-04-08 18:34:56 [6243] [8] DEBUG: AT2[OSIRIS2]: <-- OK > 2005-04-08 18:34:56 [6243] [8] DEBUG: AT2[OSIRIS2]: send command status: > 0 > 2005-04-08 18:34:56 [6243] [8] DEBUG: DLR[mysql]: Adding DLR > smsc=OSIRIS2, ts=123, src=JM, dst=+33xxxxxxx, mask=31, boxc= > 2005-04-08 18:34:56 [6243] [8] DEBUG: sql: INSERT INTO dlr (smsc, ts, > source, destination, service, url, mask, boxc, status) VALUES blabla > 2005-04-08 18:34:56 [6243] [8] DEBUG: SMSC[OSIRIS2]: creating DLR > message > 2005-04-08 18:34:56 [6243] [8] DEBUG: SMSC[OSIRIS2]: DLR = > http://localhost/combox/dlr.php?idenvoi=1744062&statut=%d > 2005-04-08 18:34:56 [6243] [1] DEBUG: Dumping 1 messages and 0 acks to > store > 2005-04-08 18:34:56 [6243] [11] DEBUG: send_msg: sending msg to box: > <127.0.0.1> > 2005-04-08 18:34:56 [6243] [11] DEBUG: boxc_sender: sent message to > <127.0.0.1> > 2005-04-08 18:34:56 [6243] [10] DEBUG: boxc_receiver: got ack > 2005-04-08 18:35:00 [6243] [7] DEBUG: AT2[OSIRIS1]: --> AT+CSQ^M > 2005-04-08 18:35:00 [6243] [7] DEBUG: AT2[OSIRIS1]: <-- +CSQ: 6,3 > 2005-04-08 18:35:00 [6243] [7] DEBUG: AT2[OSIRIS1]: <-- OK > 2005-04-08 18:35:00 [6243] [7] DEBUG: AT2[OSIRIS1]: --> AT+CPMS?^M > 2005-04-08 18:35:00 [6243] [7] DEBUG: AT2[OSIRIS1]: <-- +CPMS: > "SM",0,30,"SM",0,30 > 2005-04-08 18:35:00 [6243] [7] DEBUG: AT2[OSIRIS1]: <-- OK > 2005-04-08 18:35:00 [6243] [10] DEBUG: boxc_receiver: heartbeat with > load value 0 received > 2005-04-08 18:35:02 [6243] [8] DEBUG: AT2[OSIRIS2]: --> AT+CSQ^M > 2005-04-08 18:35:02 [6243] [8] DEBUG: AT2[OSIRIS2]: <-- +CSQ: 8,4 > 2005-04-08 18:35:02 [6243] [8] DEBUG: AT2[OSIRIS2]: <-- OK > 2005-04-08 18:35:02 [6243] [8] DEBUG: AT2[OSIRIS2]: --> AT+CPMS?^M > 2005-04-08 18:35:02 [6243] [8] DEBUG: AT2[OSIRIS2]: <-- +CPMS: > "SM",0,30,"SM",0,30 > 2005-04-08 18:35:02 [6243] [8] DEBUG: AT2[OSIRIS2]: <-- OK > 2005-04-08 18:35:03 [6243] [8] DEBUG: AT2[OSIRIS2]: <-- +CDS: 25 > 2005-04-08 18:35:03 [6243] [8] DEBUG: AT2[OSIRIS2]: <-- > 00067B0B913366730315F3504080814365805040808143958000 > 2005-04-08 18:35:03 [6243] [8] DEBUG: AT2[OSIRIS2]: got STATUS-REPORT > for message <123>: > 2005-04-08 18:35:03 [6243] [8] DEBUG: AT2[OSIRIS2]: Numeric receiver > (international) <+33663730513> > 2005-04-08 18:35:03 [6243] [8] DEBUG: DLR[mysql]: Looking for DLR > smsc=OSIRIS2, ts=123, dst=+33663730513, type=1 > 2005-04-08 18:35:03 [6243] [8] DEBUG: sql: SELECT mask, service, url, > source, destination, boxc FROM dlr WHERE smsc='OSIRIS2' AND ts='123'; > 2005-04-08 18:35:03 [6243] [8] DEBUG: Found entry, row[0]=31, > row[1]=username, > row[2]=http://localhost/combox/dlr.php?idenvoi=1744062&statut=%d, > row[3]=JM, row[4]=+336xxxxxx row[5]= > 2005-04-08 18:35:03 [6243] [8] DEBUG: DLR[mysql]: created DLR message > for URL <http://localhost/combox/dlr.php?idenvoi=1744062&statut=%d> > 2005-04-08 18:35:03 [6243] [8] DEBUG: removing DLR from database > 2005-04-08 18:35:03 [6243] [8] DEBUG: sql: DELETE FROM dlr WHERE > smsc='OSIRIS2' AND ts='123' LIMIT 1; > 2005-04-08 18:35:03 [6243] [8] DEBUG: AT2[OSIRIS2]: --> AT+CNMA^M > 2005-04-08 18:35:03 [6243] [11] DEBUG: send_msg: sending msg to box: > <127.0.0.1> > 2005-04-08 18:35:03 [6243] [11] DEBUG: boxc_sender: sent message to > <127.0.0.1> > 2005-04-08 18:35:03 [6243] [10] DEBUG: boxc_receiver: got ack > 2005-04-08 18:35:03 [6243] [8] DEBUG: AT2[OSIRIS2]: <-- OK > 2005-04-08 18:35:06 [6243] [7] DEBUG: AT2[OSIRIS1]: --> AT+CSQ^M > 2005-04-08 18:35:06 [6243] [7] DEBUG: AT2[OSIRIS1]: <-- +CSQ: 5,5 > 2005-04-08 18:35:06 [6243] [7] DEBUG: AT2[OSIRIS1]: <-- OK > 2005-04-08 18:35:06 [6243] [7] DEBUG: AT2[OSIRIS1]: --> AT+CPMS?^M > 2005-04-08 18:35:06 [6243] [7] DEBUG: AT2[OSIRIS1]: <-- +CPMS: > "SM",0,30,"SM",0,30 > 2005-04-08 18:35:06 [6243] [7] DEBUG: AT2[OSIRIS1]: <-- OK > 2005-04-08 18:35:08 [6243] [8] DEBUG: AT2[OSIRIS2]: --> AT+CSQ^M > 2005-04-08 18:35:08 [6243] [8] DEBUG: AT2[OSIRIS2]: <-- +CSQ: 6,0 > 2005-04-08 18:35:08 [6243] [8] DEBUG: AT2[OSIRIS2]: <-- OK > 2005-04-08 18:35:08 [6243] [8] DEBUG: AT2[OSIRIS2]: --> AT+CPMS?^M > 2005-04-08 18:35:08 [6243] [8] DEBUG: AT2[OSIRIS2]: <-- +CPMS: > "SM",0,30,"SM",0,30 > 2005-04-08 18:35:08 [6243] [8] DEBUG: AT2[OSIRIS2]: <-- OK > -----Message d'origine----- > De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la > part de Alejandro Guerrieri > Envoyé : vendredi 8 avril 2005 18:12 > À : users@kannel.org > Objet : Re: SMS ID back to 0 after 255 > > > Maybe you are using a "tinyint unsigned" data type for the field on > the mysql database? That could explain that kind of behaviour... > > Regards, > > On Apr 8, 2005 12:46 PM, JMLacroix <[EMAIL PROTECTED]> wrote: > >>Hi all >> >>Using mysql dlr with Wavecom GSM Modem. >>no Idea about why the SMS Id is going back to 0 after 255. >> >>Is it a Sim Card origin ? >>Marco >> >> > > >
