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 > � : [email protected] > 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 >> >> > > >
