I redo the test but this time: - DLR was set to internat instead of mysql - removed dlr.php url in playsms
Fakesmsc received: *2010-05-03 18:37:33 [13379] [0] DEBUG: Got message 1: <+687xxxxxx +687yyyyyy text l\'e>* logs: *tail -f bearerbox.log sqlbox.log smsbox.log access.log > /tmp/test-2.log*: that is why you have logs generated like this ==> smsbox.log <== 2010-05-03 18:37:32 [13316] [2] DEBUG: HTTP: Creating HTTPClient for `192.168.0.41'. 2010-05-03 18:37:32 [13316] [2] DEBUG: HTTP: Created HTTPClient area 0xb39005f0. 2010-05-03 18:37:32 [13316] [3] INFO: smsbox: Got HTTP request </cgi-bin/sendsms> from <192.168.0.41> 2010-05-03 18:37:32 [13316] [3] INFO: sendsms used by <playsms> 2010-05-03 18:37:32 [13316] [3] INFO: sendsms sender:<playsms:+687xxxxxx> (192.168.0.41) to:<+687yyyyyy> msg:<l'e> 2010-05-03 18:37:32 [13316] [3] DEBUG: Stored UUID bb89c57b-9cdd-4809-a81a-8ea5964e9aaf 2010-05-03 18:37:32 [13316] [3] DEBUG: message length 3, sending 1 messages 2010-05-03 18:37:32 [13316] [3] DEBUG: Status: 202 Answer: <Sent.> 2010-05-03 18:37:32 [13316] [3] DEBUG: Delayed reply - wait for bearerbox ==> access.log <== 2010-05-03 18:37:32 send-SMS request added - sender:playsms:+687xxxxxx 192.168.0.41 target:+687yyyyyy request: *'l'e'* ==> smsbox.log <== ==> sqlbox.log <== 2010-05-03 18:37:32 [13307] [3] DEBUG: smsbox_to_bearerbox: sms received ==> bearerbox.log <== 2010-05-03 18:37:32 [13269] [15] DEBUG: boxc_receiver: sms received 2010-05-03 18:37:32 [13269] [15] DEBUG: send_msg: sending msg to box: <127.0.0.1> 2010-05-03 18:37:32 [13269] [6] DEBUG: smsc_fake: sending message to client ==> access.log <== 2010-05-03 18:37:32 Sent SMS [SMSC:Fake] [SVC:playsms] [ACT:kcn] [BINF:] [FID:] [META:] [from:+687783548] [to:+687yyyyyy] [flags:1:0:-1:-1:-1] [msg:4:*l\'e*] [udh:0:] ==> smsbox.log <== 2010-05-03 18:37:32 [13316] [0] DEBUG: Got ACK (0) of bb89c57b-9cdd-4809-a81a-8ea5964e9aaf 2010-05-03 18:37:32 [13316] [0] DEBUG: HTTP: Destroying HTTPClient area 0xb39005f0. 2010-05-03 18:37:32 [13316] [0] DEBUG: HTTP: Destroying HTTPClient for `192.168.0.41'. Regards, Emmanuel 2010/5/3 Nikos Balkanas <nbalka...@gmail.com> > Hi, > > I don't think so. Seems like an smsbox issue: > > smsbox log: > 2010-05-03 13:56:46 [7684] [3] INFO: sendsms sender:<playsms:+687xxxxxx> > (192.168.0.41) to:<+687yyyyyy> msg:<l'e> > Meanwhile these are tons of logs, most of them dupplicated and irrelevant. > Can you please repost only relevant portions? This time include relevant > access log from bb. I appreciate your effort to break up logs like that, but > it is very confusing. By relevant I don't mean DLRs. > > BR, > Nikos > > > ----- Original Message ----- > *From:* sangprabv <sangpr...@gmail.com> > *To:* Emmanuel CHANSON <emmanuelchan...@gmail.com> > *Cc:* users <users@kannel.org> > *Sent:* Monday, May 03, 2010 6:18 AM > *Subject:* Re: Quote and backslash issue > > This is more about SQLBox is trying to play safe. One tricky solution is > replace ' with ` when you inject MT. > > > > sangprabv > sangpr...@gmail.com > > > On May 3, 2010, at 10:04 AM, Emmanuel CHANSON wrote: > > Below the logs generated during a test done with fakesmsc: > > 2010-05-03 13:56:47 [7886] [0] DEBUG: Got message 2: <+687xxxxxx +687yyyyyy > text *l\'e*> > > bearerbox, smsbox, sqlbox .log > > ==> bearerbox.log <== > 2010-05-03 13:55:32 [7638] [6] DEBUG: column=source buffer_type=253 > max_length=0 length=40 > 2010-05-03 13:55:32 [7638] [6] DEBUG: column=destination buffer_type=253 > max_length=0 length=40 > 2010-05-03 13:55:32 [7638] [6] DEBUG: column=boxc buffer_type=253 > max_length=0 length=40 > 2010-05-03 13:55:32 [7638] [6] DEBUG: DLR[mysql]: created DLR message for > URL < > http://192.168.0.41/playsms/plugin/gateway/kannel/dlr.php?type=%d&slid=0&uid=12 > > > 2010-05-03 13:55:32 [7638] [6] DEBUG: removing DLR from database > 2010-05-03 13:55:32 [7638] [6] DEBUG: sql: DELETE FROM `dlr` WHERE `smsc`=? > AND `ts`=? LIMIT 1 > 2010-05-03 13:55:32 [7638] [16] DEBUG: send_msg: sending msg to box: > <127.0.0.1> > 2010-05-03 13:55:32 [7638] [16] DEBUG: boxc_sender: sent message to > <127.0.0.1> > 2010-05-03 13:55:32 [7638] [15] DEBUG: boxc_receiver: got ack > 2010-05-03 13:55:49 [7638] [15] DEBUG: boxc_receiver: heartbeat with load > value 0 received > > ==> smsbox.log <== > 2010-05-03 13:55:32 [7684] [8] DEBUG: data: 63 68 65 2f 32 2e 32 2e 31 34 > 20 28 46 65 64 6f che/2.2.14 (Fedo > 2010-05-03 13:55:32 [7684] [8] DEBUG: data: 72 61 29 0d 0a 58 2d 50 6f 77 > 65 72 65 64 2d 42 ra)..X-Powered-B > 2010-05-03 13:55:32 [7684] [8] DEBUG: data: 79 3a 20 50 48 50 2f 35 2e 33 > 2e 32 0d 0a 50 72 y: PHP/5.3.2..Pr > 2010-05-03 13:55:32 [7684] [8] DEBUG: data: 61 67 6d 61 3a 20 6e 6f 2d 63 > 61 63 68 65 0d 0a agma: no-cache.. > 2010-05-03 13:55:32 [7684] [8] DEBUG: data: 43 6f 6e 74 65 6e 74 2d 4c 65 > 6e 67 74 68 3a 20 Content-Length: > 2010-05-03 13:55:32 [7684] [8] DEBUG: data: 30 0d 0a 43 6f 6e 6e 65 63 74 > 69 6f 6e 3a 20 63 0..Connection: c > 2010-05-03 13:55:32 [7684] [8] DEBUG: data: 6c 6f 73 65 0d 0a 43 6f 6e 74 > 65 6e 74 2d 54 79 lose..Content-Ty > 2010-05-03 13:55:32 [7684] [8] DEBUG: data: 70 65 3a 20 74 65 78 74 2f 68 > 74 6d 6c 3b 20 63 pe: text/html; c > 2010-05-03 13:55:32 [7684] [8] DEBUG: data: 68 61 72 73 65 74 3d 55 54 46 > 2d 38 0d 0a 0d 0a harset=UTF-8.... > 2010-05-03 13:55:32 [7684] [8] DEBUG: Octet string dump ends. > > ==> sqlbox.log <== > 2010-05-03 13:47:18 [7675] [2] DEBUG: Thread 2 (sqlbox.c:bearerbox_to_sql) > maps to pid 7675. > 2010-05-03 13:47:19 [7675] [0] DEBUG: Started thread 3 (sqlbox.c:function) > 2010-05-03 13:47:19 [7675] [3] DEBUG: Thread 3 (sqlbox.c:function) maps to > pid 7675. > 2010-05-03 13:47:19 [7675] [3] INFO: Client connected from <127.0.0.1> > 2010-05-03 13:47:19 [7675] [3] DEBUG: Connecting to <127.0.0.1> > 2010-05-03 13:47:19 [7675] [3] INFO: Connected to bearerbox at localhost > port 13001. > 2010-05-03 13:47:19 [7675] [3] DEBUG: Started thread 4 > (sqlbox.c:bearerbox_to_smsbox) > 2010-05-03 13:47:19 [7675] [4] DEBUG: Thread 4 > (sqlbox.c:bearerbox_to_smsbox) maps to pid 7675. > 2010-05-03 13:47:46 [7675] [3] DEBUG: smsbox_to_bearerbox: sms received > 2010-05-03 13:55:07 [7675] [3] DEBUG: smsbox_to_bearerbox: sms received > > ==> smsbox.log <== > 2010-05-03 13:56:46 [7684] [2] DEBUG: HTTP: Creating HTTPClient for > `192.168.0.41'. > 2010-05-03 13:56:46 [7684] [2] DEBUG: HTTP: Created HTTPClient area > 0xb2f00568. > 2010-05-03 13:56:46 [7684] [3] INFO: smsbox: Got HTTP request > </cgi-bin/sendsms> from <192.168.0.41> > 2010-05-03 13:56:46 [7684] [3] INFO: sendsms used by <playsms> > 2010-05-03 13:56:46 [7684] [3] INFO: sendsms sender:<playsms:+687xxxxxx> > (192.168.0.41) to:<+687yyyyyy> msg:<l'e> > 2010-05-03 13:56:46 [7684] [3] DEBUG: Stored UUID > f28389a0-8bd3-431c-83ae-0a3c7e2afcca > 2010-05-03 13:56:46 [7684] [3] DEBUG: message length 3, sending 1 messages > 2010-05-03 13:56:46 [7684] [3] DEBUG: Status: 202 Answer: <Sent.> > 2010-05-03 13:56:46 [7684] [3] DEBUG: Delayed reply - wait for bearerbox > > ==> sqlbox.log <== > 2010-05-03 13:56:46 [7675] [3] DEBUG: smsbox_to_bearerbox: sms received > > ==> bearerbox.log <== > 2010-05-03 13:56:46 [7638] [15] DEBUG: boxc_receiver: sms received > 2010-05-03 13:56:46 [7638] [15] DEBUG: DLR[mysql]: Adding DLR smsc=Fake, > ts=f28389a0-8bd3-431c-83ae-0a3c7e2afcca, src=+687xxxxxx, dst=+687yyyyyy, > mask=31, boxc= > 2010-05-03 13:56:46 [7638] [15] DEBUG: adding DLR entry into database > 2010-05-03 13:56:46 [7638] [15] DEBUG: sql: INSERT INTO `dlr` (`smsc`, > `ts`, `source`, `destination`, `service`, `url`, `mask`, `boxc`, `status`) > VALUES (?, ?, ?, ?, ?, ?, ?, ?, 0) > 2010-05-03 13:56:46 [7638] [15] DEBUG: send_msg: sending msg to box: > <127.0.0.1> > 2010-05-03 13:56:46 [7638] [6] DEBUG: smsc_fake: sending message to client > 2010-05-03 13:56:46 [7638] [6] DEBUG: SMSC[Fake]: creating DLR message > 2010-05-03 13:56:46 [7638] [6] DEBUG: SMSC[Fake]: DLR = > http://192.168.0.41/playsms/plugin/gateway/kannel/dlr.php?type=%d&slid=0&uid=12 > 2010-05-03 13:56:46 [7638] [6] DEBUG: DLR[mysql]: Looking for DLR > smsc=Fake, ts=f28389a0-8bd3-431c-83ae-0a3c7e2afcca, dst=+687yyyyyy, type=1 > 2010-05-03 13:56:46 [7638] [16] DEBUG: send_msg: sending msg to box: > <127.0.0.1> > 2010-05-03 13:56:46 [7638] [16] DEBUG: boxc_sender: sent message to > <127.0.0.1> > > ==> smsbox.log <== > 2010-05-03 13:56:46 [7684] [0] DEBUG: Got ACK (0) of > f28389a0-8bd3-431c-83ae-0a3c7e2afcca > 2010-05-03 13:56:46 [7684] [0] DEBUG: HTTP: Destroying HTTPClient area > 0xb2f00568. > 2010-05-03 13:56:46 [7684] [0] DEBUG: HTTP: Destroying HTTPClient for > `192.168.0.41'. > > ==> bearerbox.log <== > 2010-05-03 13:56:46 [7638] [6] DEBUG: sql: SELECT `mask`, `service`, `url`, > `source`, `destination`, `boxc` FROM `dlr` WHERE `smsc`=? AND `ts`=? LIMIT 1 > 2010-05-03 13:56:46 [7638] [6] DEBUG: column=mask buffer_type=3 > max_length=0 length=10 > 2010-05-03 13:56:46 [7638] [6] DEBUG: column=service buffer_type=253 > max_length=0 length=40 > 2010-05-03 13:56:46 [7638] [6] DEBUG: column=url buffer_type=253 > max_length=0 length=255 > 2010-05-03 13:56:46 [7638] [6] DEBUG: column=source buffer_type=253 > max_length=0 length=40 > 2010-05-03 13:56:46 [7638] [6] DEBUG: column=destination buffer_type=253 > max_length=0 length=40 > 2010-05-03 13:56:46 [7638] [6] DEBUG: column=boxc buffer_type=253 > max_length=0 length=40 > 2010-05-03 13:56:46 [7638] [6] DEBUG: DLR[mysql]: created DLR message for > URL < > http://192.168.0.41/playsms/plugin/gateway/kannel/dlr.php?type=%d&slid=0&uid=12 > > > 2010-05-03 13:56:46 [7638] [6] DEBUG: removing DLR from database > 2010-05-03 13:56:46 [7638] [6] DEBUG: sql: DELETE FROM `dlr` WHERE `smsc`=? > AND `ts`=? LIMIT 1 > 2010-05-03 13:56:46 [7638] [16] DEBUG: send_msg: sending msg to box: > <127.0.0.1> > 2010-05-03 13:56:46 [7638] [16] DEBUG: boxc_sender: sent message to > <127.0.0.1> > > ==> smsbox.log <== > 2010-05-03 13:56:46 [7684] [4] INFO: Starting delivery report <playsms> > from <+687xxxxxx> > 2010-05-03 13:56:46 [7684] [9] DEBUG: Queue contains 0 pending requests. > 2010-05-03 13:56:46 [7684] [9] DEBUG: Parsing URL ` > http://192.168.0.41/playsms/plugin/gateway/kannel/dlr.php?type=8&slid=0&uid=12 > ': > 2010-05-03 13:56:46 [7684] [9] DEBUG: Scheme: http:// > 2010-05-03 13:56:46 [7684] [9] DEBUG: Host: 192.168.0.41 > 2010-05-03 13:56:46 [7684] [9] DEBUG: Port: 80 > 2010-05-03 13:56:46 [7684] [9] DEBUG: Username: (null) > 2010-05-03 13:56:46 [7684] [9] DEBUG: Password: (null) > 2010-05-03 13:56:46 [7684] [9] DEBUG: Path: > /playsms/plugin/gateway/kannel/dlr.php > 2010-05-03 13:56:46 [7684] [9] DEBUG: Query: type=8&slid=0&uid=12 > 2010-05-03 13:56:46 [7684] [9] DEBUG: Fragment: (null) > 2010-05-03 13:56:46 [7684] [9] DEBUG: Connecting nonblocking to > <192.168.0.41> > 2010-05-03 13:56:46 [7684] [9] DEBUG: HTTP: Opening connection to ` > 192.168.0.41:80' (fd=28). > 2010-05-03 13:56:46 [7684] [9] DEBUG: Socket connecting > 2010-05-03 13:56:46 [7684] [8] DEBUG: Get info about connecting socket > 2010-05-03 13:56:46 [7684] [8] DEBUG: HTTP: Sending request: > 2010-05-03 13:56:46 [7684] [8] DEBUG: Octet string at 0x8ccfe18: > 2010-05-03 13:56:46 [7684] [8] DEBUG: len: 153 > 2010-05-03 13:56:46 [7684] [8] DEBUG: size: 1024 > 2010-05-03 13:56:46 [7684] [8] DEBUG: immutable: 0 > 2010-05-03 13:56:46 [7684] [8] DEBUG: data: 47 45 54 20 2f 70 6c 61 79 73 > 6d 73 2f 70 6c 75 GET /playsms/plu > 2010-05-03 13:56:46 [7684] [8] DEBUG: data: 67 69 6e 2f 67 61 74 65 77 61 > 79 2f 6b 61 6e 6e gin/gateway/kann > 2010-05-03 13:56:46 [7684] [8] DEBUG: data: 65 6c 2f 64 6c 72 2e 70 68 70 > 3f 74 79 70 65 3d el/dlr.php?type= > 2010-05-03 13:56:46 [7684] [8] DEBUG: data: 38 26 73 6c 69 64 3d 30 26 75 > 69 64 3d 31 32 20 8&slid=0&uid=12 > 2010-05-03 13:56:46 [7684] [8] DEBUG: data: 48 54 54 50 2f 31 2e 31 0d 0a > 48 6f 73 74 3a 20 HTTP/1.1..Host: > 2010-05-03 13:56:46 [7684] [8] DEBUG: data: 31 39 32 2e 31 36 38 2e 30 2e > 34 31 0d 0a 43 6f 192.168.0.41..Co > 2010-05-03 13:56:46 [7684] [8] DEBUG: data: 6e 6e 65 63 74 69 6f 6e 3a 20 > 6b 65 65 70 2d 61 nnection: keep-a > 2010-05-03 13:56:46 [7684] [8] DEBUG: data: 6c 69 76 65 0d 0a 55 73 65 72 > 2d 41 67 65 6e 74 live..User-Agent > 2010-05-03 13:56:46 [7684] [8] DEBUG: data: 3a 20 4b 61 6e 6e 65 6c 2f 63 > 76 73 2d 32 30 31 : Kannel/cvs-201 > 2010-05-03 13:56:46 [7684] [8] DEBUG: data: 30 30 31 32 31 0d 0a 0d > 0a 00121.... > 2010-05-03 13:56:46 [7684] [8] DEBUG: Octet string dump ends. > > ==> bearerbox.log <== > 2010-05-03 13:56:46 [7638] [15] DEBUG: boxc_receiver: got ack > > ==> smsbox.log <== > 2010-05-03 13:56:46 [7684] [4] INFO: Starting delivery report <playsms> > from <+687xxxxxx> > 2010-05-03 13:56:46 [7684] [9] DEBUG: Queue contains 0 pending requests. > 2010-05-03 13:56:46 [7684] [9] DEBUG: Parsing URL ` > http://192.168.0.41/playsms/plugin/gateway/kannel/dlr.php?type=1&slid=0&uid=12 > ': > 2010-05-03 13:56:46 [7684] [9] DEBUG: Scheme: http:// > 2010-05-03 13:56:46 [7684] [9] DEBUG: Host: 192.168.0.41 > 2010-05-03 13:56:46 [7684] [9] DEBUG: Port: 80 > 2010-05-03 13:56:46 [7684] [9] DEBUG: Username: (null) > 2010-05-03 13:56:46 [7684] [9] DEBUG: Password: (null) > 2010-05-03 13:56:46 [7684] [9] DEBUG: Path: > /playsms/plugin/gateway/kannel/dlr.php > 2010-05-03 13:56:46 [7684] [9] DEBUG: Query: type=1&slid=0&uid=12 > 2010-05-03 13:56:46 [7684] [9] DEBUG: Fragment: (null) > 2010-05-03 13:56:46 [7684] [9] DEBUG: Connecting nonblocking to > <192.168.0.41> > 2010-05-03 13:56:46 [7684] [9] DEBUG: HTTP: Opening connection to ` > 192.168.0.41:80' (fd=29). > 2010-05-03 13:56:46 [7684] [9] DEBUG: Socket connecting > 2010-05-03 13:56:46 [7684] [8] DEBUG: Get info about connecting socket > 2010-05-03 13:56:46 [7684] [8] DEBUG: HTTP: Sending request: > 2010-05-03 13:56:46 [7684] [8] DEBUG: Octet string at 0x8ccfe18: > 2010-05-03 13:56:46 [7684] [8] DEBUG: len: 153 > 2010-05-03 13:56:46 [7684] [8] DEBUG: size: 1024 > 2010-05-03 13:56:46 [7684] [8] DEBUG: immutable: 0 > 2010-05-03 13:56:46 [7684] [8] DEBUG: data: 47 45 54 20 2f 70 6c 61 79 73 > 6d 73 2f 70 6c 75 GET /playsms/plu > 2010-05-03 13:56:46 [7684] [8] DEBUG: data: 67 69 6e 2f 67 61 74 65 77 61 > 79 2f 6b 61 6e 6e gin/gateway/kann > 2010-05-03 13:56:46 [7684] [8] DEBUG: data: 65 6c 2f 64 6c 72 2e 70 68 70 > 3f 74 79 70 65 3d el/dlr.php?type= > 2010-05-03 13:56:46 [7684] [8] DEBUG: data: 31 26 73 6c 69 64 3d 30 26 75 > 69 64 3d 31 32 20 1&slid=0&uid=12 > 2010-05-03 13:56:46 [7684] [8] DEBUG: data: 48 54 54 50 2f 31 2e 31 0d 0a > 48 6f 73 74 3a 20 HTTP/1.1..Host: > 2010-05-03 13:56:46 [7684] [8] DEBUG: data: 31 39 32 2e 31 36 38 2e 30 2e > 34 31 0d 0a 43 6f 192.168.0.41..Co > 2010-05-03 13:56:46 [7684] [8] DEBUG: data: 6e 6e 65 63 74 69 6f 6e 3a 20 > 6b 65 65 70 2d 61 nnection: keep-a > 2010-05-03 13:56:46 [7684] [8] DEBUG: data: 6c 69 76 65 0d 0a 55 73 65 72 > 2d 41 67 65 6e 74 live..User-Agent > 2010-05-03 13:56:46 [7684] [8] DEBUG: data: 3a 20 4b 61 6e 6e 65 6c 2f 63 > 76 73 2d 32 30 31 : Kannel/cvs-201 > 2010-05-03 13:56:46 [7684] [8] DEBUG: data: 30 30 31 32 31 0d 0a 0d > 0a 00121.... > 2010-05-03 13:56:46 [7684] [8] DEBUG: Octet string dump ends. > > ==> bearerbox.log <== > 2010-05-03 13:56:46 [7638] [15] DEBUG: boxc_receiver: got ack > > ==> smsbox.log <== > 2010-05-03 13:56:46 [7684] [8] DEBUG: HTTP: Status line: <HTTP/1.1 200 OK> > 2010-05-03 13:56:46 [7684] [8] DEBUG: HTTP: Received response: > 2010-05-03 13:56:46 [7684] [8] DEBUG: Octet string at 0x8cd6748: > 2010-05-03 13:56:46 [7684] [8] DEBUG: len: 192 > 2010-05-03 13:56:46 [7684] [8] DEBUG: size: 1024 > 2010-05-03 13:56:46 [7684] [8] DEBUG: immutable: 0 > 2010-05-03 13:56:46 [7684] [8] DEBUG: data: 44 61 74 65 3a 20 53 75 6e 2c > 20 30 32 20 4d 61 Date: Sun, 02 Ma > 2010-05-03 13:56:46 [7684] [8] DEBUG: data: 79 20 32 30 31 30 20 32 33 3a > 31 31 3a 35 38 20 y 2010 23:11:58 > 2010-05-03 13:56:46 [7684] [8] DEBUG: data: 47 4d 54 0d 0a 53 65 72 76 65 > 72 3a 20 41 70 61 GMT..Server: Apa > 2010-05-03 13:56:46 [7684] [8] DEBUG: data: 63 68 65 2f 32 2e 32 2e 31 34 > 20 28 46 65 64 6f che/2.2.14 (Fedo > 2010-05-03 13:56:46 [7684] [8] DEBUG: data: 72 61 29 0d 0a 58 2d 50 6f 77 > 65 72 65 64 2d 42 ra)..X-Powered-B > 2010-05-03 13:56:46 [7684] [8] DEBUG: data: 79 3a 20 50 48 50 2f 35 2e 33 > 2e 32 0d 0a 50 72 y: PHP/5.3.2..Pr > 2010-05-03 13:56:46 [7684] [8] DEBUG: data: 61 67 6d 61 3a 20 6e 6f 2d 63 > 61 63 68 65 0d 0a agma: no-cache.. > 2010-05-03 13:56:46 [7684] [8] DEBUG: data: 43 6f 6e 74 65 6e 74 2d 4c 65 > 6e 67 74 68 3a 20 Content-Length: > 2010-05-03 13:56:46 [7684] [8] DEBUG: data: 30 0d 0a 43 6f 6e 6e 65 63 74 > 69 6f 6e 3a 20 63 0..Connection: c > 2010-05-03 13:56:46 [7684] [8] DEBUG: data: 6c 6f 73 65 0d 0a 43 6f 6e 74 > 65 6e 74 2d 54 79 lose..Content-Ty > 2010-05-03 13:56:46 [7684] [8] DEBUG: data: 70 65 3a 20 74 65 78 74 2f 68 > 74 6d 6c 3b 20 63 pe: text/html; c > 2010-05-03 13:56:46 [7684] [8] DEBUG: data: 68 61 72 73 65 74 3d 55 54 46 > 2d 38 0d 0a 0d 0a harset=UTF-8.... > 2010-05-03 13:56:46 [7684] [8] DEBUG: Octet string dump ends. > 2010-05-03 13:56:46 [7684] [8] DEBUG: HTTP: Status line: <HTTP/1.1 200 OK> > 2010-05-03 13:56:46 [7684] [8] DEBUG: HTTP: Received response: > 2010-05-03 13:56:46 [7684] [8] DEBUG: Octet string at 0x8cd6748: > 2010-05-03 13:56:46 [7684] [8] DEBUG: len: 192 > 2010-05-03 13:56:46 [7684] [8] DEBUG: size: 1024 > 2010-05-03 13:56:46 [7684] [8] DEBUG: immutable: 0 > 2010-05-03 13:56:46 [7684] [8] DEBUG: data: 44 61 74 65 3a 20 53 75 6e 2c > 20 30 32 20 4d 61 Date: Sun, 02 Ma > 2010-05-03 13:56:46 [7684] [8] DEBUG: data: 79 20 32 30 31 30 20 32 33 3a > 31 31 3a 35 38 20 y 2010 23:11:58 > 2010-05-03 13:56:46 [7684] [8] DEBUG: data: 47 4d 54 0d 0a 53 65 72 76 65 > 72 3a 20 41 70 61 GMT..Server: Apa > 2010-05-03 13:56:47 [7684] [8] DEBUG: data: 63 68 65 2f 32 2e 32 2e 31 34 > 20 28 46 65 64 6f che/2.2.14 (Fedo > 2010-05-03 13:56:47 [7684] [8] DEBUG: data: 72 61 29 0d 0a 58 2d 50 6f 77 > 65 72 65 64 2d 42 ra)..X-Powered-B > 2010-05-03 13:56:47 [7684] [8] DEBUG: data: 79 3a 20 50 48 50 2f 35 2e 33 > 2e 32 0d 0a 50 72 y: PHP/5.3.2..Pr > 2010-05-03 13:56:47 [7684] [8] DEBUG: data: 61 67 6d 61 3a 20 6e 6f 2d 63 > 61 63 68 65 0d 0a agma: no-cache.. > 2010-05-03 13:56:47 [7684] [8] DEBUG: data: 43 6f 6e 74 65 6e 74 2d 4c 65 > 6e 67 74 68 3a 20 Content-Length: > 2010-05-03 13:56:47 [7684] [8] DEBUG: data: 30 0d 0a 43 6f 6e 6e 65 63 74 > 69 6f 6e 3a 20 63 0..Connection: c > 2010-05-03 13:56:47 [7684] [8] DEBUG: data: 6c 6f 73 65 0d 0a 43 6f 6e 74 > 65 6e 74 2d 54 79 lose..Content-Ty > 2010-05-03 13:56:47 [7684] [8] DEBUG: data: 70 65 3a 20 74 65 78 74 2f 68 > 74 6d 6c 3b 20 63 pe: text/html; c > 2010-05-03 13:56:47 [7684] [8] DEBUG: data: 68 61 72 73 65 74 3d 55 54 46 > 2d 38 0d 0a 0d 0a harset=UTF-8.... > 2010-05-03 13:56:47 [7684] [8] DEBUG: Octet string dump ends. > > ==> bearerbox.log <== > 2010-05-03 13:56:49 [7638] [15] DEBUG: boxc_receiver: heartbeat with load > value 0 received > 2010-05-03 13:56:53 [7638] [6] INFO: EOF from fakesmsc client. Closing > connection. > > > BR, > > Emmanuel > > 2010/5/1 Nikos Balkanas <nbalka...@gmail.com> > >> Hi, >> >> Please post relevant bb & smsbox logs at maximum detail. >> >> BR, >> Nikos >> >> ----- Original Message ----- >> *From:* Emmanuel CHANSON <emmanuelchan...@gmail.com> >> *To:* users <users@kannel.org> >> *Sent:* Saturday, May 01, 2010 4:06 AM >> *Subject:* Quote and backslash issue >> >> Hello everybody, >> >> This time I am faced to this issue: >> >> When sending a message including a quote " ' " I receive " \' " on my >> mobile. >> >> I use PlaySMS to send a MT and below the url used for the test was: >> >> >> /cgi-bin/sendsms?username=xxxxxx&password=xxxxxx&from=%2B687xxxxxx&to=%2B687xxxxxx&account=xxx&text=l%27e&dlr-mask=31&dlr-url=http%3A%2F%2F192.168.0.41%2Fplaysms%2Fplugin%2Fgateway%2Fkannel%2Fdlr.php%3Ftype%3D%25d%26slid%3D0%26uid%3D12&mclass=1 >> >> so " l'e " was the message in this case. ( &text=l%27e ). >> >> I have checked the logs: >> >> on smsbox.log: the quote is not modified >> *2010-05-01 11:52:03 [1724] [3] INFO: sendsms sender:<playsms:+687xxxxxx> >> (192.168.0.41) to:<+687xxxxxx> msg:<l'e>* >> >> on sqlbox the message is inserted correctly in mysql: >> *43* *MT* *+687xxxxxx* *+687xxxxxx* *[BLOB - 0o]* *l'e* *1272675123* * >> NULL* *playsms* *kcn* *NULL* *2* *1* *NULL* *0* *NULL* *NULL* *NULL* *31* >> *http://192.168.0.41/playsms/plugin/gateway/kannel/.<http://192.168.0.41/playsms/plugin/gateway/kannel/> >> ..* *NULL* *NULL* *NULL* *NULL* *N* >> on bearerbox.log: >> don't know how to find any clue for this message except the binary code >> >> I am using Kannel CVS + sqlbox ( bearerbox <-> sqlbox <-> smsbox ). >> >> magic quote are OFF in my php.ini. >> >> Did you ever see this? Is it bearerbox that add slash to any quote? >> >> Regards, >> >> -- >> Emmanuel >> >> > > > -- > Emmanuel > > CHANSON Emmanuel > Mobile Nouvelle-Calιdonie: +687.77.35.02 > > Mobile France: +33 (0) 6.68.03.89.56 > @email : emmanuelchan...@gmail.com > > > -- Emmanuel CHANSON Emmanuel Mobile Nouvelle-Calédonie: +687.77.35.02 Mobile France: +33 (0) 6.68.03.89.56 @email : emmanuelchan...@gmail.com
