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 > > -- Alejandro Guerrieri Magicom http://www.magicom-bcn.net/
