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 To: Emmanuel CHANSON Cc: users 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 [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]
