This is more about SQLBox is trying to play safe. One tricky solution is replace ' with ` when you inject MT.
sangprabv [email protected] 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 <[email protected]> > Hi, > > Please post relevant bb & smsbox logs at maximum detail. > > BR, > Nikos > ----- Original Message ----- > From: Emmanuel CHANSON > To: users > 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/... 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 : [email protected]
