in this case i have to checkout the openSMPP as well. in past there was issue with openSMPP for sending DLR back. for which i have to ask a 3rd party for applying a patch.(i really dont know what they did)
if i touch the kannel that means i have to get everything new again. what i will do is i will get latest SVN and install on test machine. and see that. but first i will defiantly try to checkout only sqlbox. Thanks On Sun, Apr 7, 2013 at 9:50 AM, spameden <[email protected]> wrote: > Forgot to mention, when I had the same problem as you, reinstalling sqlbox > didn't help to me, I had to checkout kannel as well, because there was a > bug. > > > 2013/4/7 spameden <[email protected]> > >> 1. Why don't you want to checkout latest revision? There were plenty of >> bugs fixed lately. >> >> 2. There was an error in the kannel uploaded on the site (version 1.5.0) >> related to the encoding giving out exactly behavior you're getting. >> >> 3. No, you don't need to encode special way either, just a simple >> urlencode procedure. >> >> 4. SQLBox might work with old kannel, but I don't recommend doing so, >> better compile latest kannel and sqlbox, it's not that hard. >> >> >> 2013/4/7 Ali Kashif <[email protected]> >> >>> >>> 1. Using kennel 1.5, checkedout around mid of 2012 or bit late >>> 2. I am inserting 'utf-8' ( without quots, lowercase) >>> 3. Sure I will remove mo-recode >>> 4. Yes . I am using php standard function urlencode();. Do I need some >>> other way to encode data before inserting into sqlbox? >>> >>> >>> My question is if I checkout only sqlbox now, will that work with >>> previously downloaded kennel 1.5 and opensmpp >>> >>> >>> >>> >>> On Sunday, April 7, 2013, spameden wrote: >>> >>>> 1. What's the version of kannel you're using? >>>> >>>> answering before you did - use latest from SVN (not from releases page, >>>> i.e. compile yourself from latest revision!) >>>> >>>> 2. charset should be 'utf-8', exactly like that >>>> >>>> 3. no need to use mo-recode option, it works without it. >>>> >>>> 4. how do you urlencode via standard php function? >>>> >>>> >>>> 2013/4/7 Ali Kashif <[email protected]> >>>> >>>>> I am Trying to insert MT message in sqlbox send_sms table, with >>>>> >>>>> msgdata = urlencoed data >>>>> coding =2 >>>>> charset= UTF-8 >>>>> >>>>> MYSQL : table , Database and msgData field is UTF-8 >>>>> >>>>> >>>>> and in my kannel configuration i have added >>>>> >>>>> mo-recode=true >>>>> >>>>> >>>>> (even though i am not sure why should i add this but this thread says .. >>>>> http://comments.gmane.org/gmane.comp.mobile.kannel.user/20630) >>>>> >>>>> >>>>> but end user is receiving BOXES in message >>>>> >>>>> >>>>> I can send a perfect message using kannel using sendsms >>>>> >>>>> >>>>> cgi-bin/sendsms?username=USER&password=12345&coding=2&charset=UTF-8&from=123&to=+XXXXXXXXXXXX&text=%C2%BFABC%E2%82%AC%40%21%26%25%C2%A7%3F%3F%C2%A1wxyz%C3%A4%C3%B6%C3%B1%C3%BC%C3%A0%3F%C3%9F%C3%A6%C3%86%7B%7D%5B%5D%28%2912345 >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> i have gone through many articles and mailinglist but so far no solution . >>>>> >>>>> i have found these 2 links >>>>> >>>>> >>>>> https://build.opensuse.org/package/view_file?file=sqlbox-r45-encoding-fix.diff&package=sqlbox&project=home%3Acrt0solutions%3Akannel >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> http://www.kannel.org/pipermail/devel/2010-August/003892.html >>>>> >>>>> >>>>> i am really not sure about the DIFF patch and really dont know how to >>>>> apply that, on the other hand the second like seems promising but i dont >>>>> know what the results will be for my case (Arabic and French Messages) >>>>> >>>>> >>>>> so can anyone suggest me some solution for this ? >>>>> >>>>> Thanks >>>>> >>>>> Ali >>>>> >>>>> >>>> >> >
