Maybe you did not catch how my system is designed: I used the following implementation:
PlaySMS to insert MT -> smsbox -> sqlbox -> bearerbox -> fakesmsc On sqlbox side the quote is escaped (maybe mysql config issue or sqlbox). And using "tail -f" it generates the log from each module when they are triggered, but you don't like this, it seems for me better to understand the call flow I thought. Regards, Emmanuel 2010/5/4 Nikos Balkanas <nbalka...@gmail.com> > So what is the entry from access-log? It is listed under smsbox logs. Is > it smsbox or sqlbox? It is not escaped. > > In the future please label your logs correctly, so that we do not waiste > our time. > > BR, > Nikos > > ----- Original Message ----- > *From:* Emmanuel CHANSON <emmanuelchan...@gmail.com> > *To:* Nikos Balkanas <nbalka...@gmail.com> > *Cc:* users <users@kannel.org> > *Sent:* Monday, May 03, 2010 2:23 PM > *Subject:* Re: Quote and backslash issue > > I have run the test without sqlbox and the quote is not escaped this time > so something is wrong on this. > I have see with Alex and I need to investiguate further... > > Thanks Nikos, > > Emmanuel > > 2010/5/3 Nikos Balkanas <nbalka...@gmail.com> > >> Hi, >> Β >> You needn't disable DLRs. Just skip from posted logs. >> Β >> It is clear. Somewhere between smsbox and bearerbox the quote is escaped. >> And shouldn't. >> Β >> PleaseΒ run the same test with fakesmsc client instead of smsbox and see >> if problem persists. >> Β >> BR, >> Nikos >> >> ----- Original Message ----- >> *From:* Emmanuel CHANSON <emmanuelchan...@gmail.com> >> *To:* users <users@kannel.org> >> *Sent:* Monday, May 03, 2010 10:43 AM >> *Subject:* Re: Quote and backslash issue >> >> 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 >>> Ξ’Β >>> >>> [...snip...] >>> >>> -- >>> 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 > > -- Emmanuel CHANSON Emmanuel Mobile Nouvelle-Calédonie: +687.77.35.02 Mobile France: +33 (0) 6.68.03.89.56 @email : emmanuelchan...@gmail.com