Typical software engineering schedule. You spent 80% of time whilst doing 20% of the code.
From: Mike Nakos [mailto:[email protected]] Sent: Friday, 13 May, 2011 23:49 To: Tania Petsouka Cc: Rene Kluwen; [email protected] Subject: Re: sqlbox greek gsm-7 u welcome! After Rene last reply I was going to tell you to check if you are running ver 1.4 which doesn't do any url-decoding. Typical error. I guess you have installed debian package before you make the svn revision and after machine's reboot wrong version was running. In advance, please don't ask me how to provide @ character on sender address. I haven't examined it yet. I prohibit users to enter that character on sender's address, for the moment, in our production system. On 14/05/11 00:30, Tania Petsouka wrote: Oh My God... That's it. Wrong version! I spent 16 hours on it... Guys, you are really helpful, thank you so much. On Sat, May 14, 2011 at 12:03 AM, Rene Kluwen <[email protected]> wrote: Yes, it gives an info. I just now downloaded 1.5.0 as well to see if there are any differences. And it seems that url-decoding the msgdata field was introduced after that version. So try to use svn trunk revision. == Rene From: Tania Petsouka [mailto:[email protected]] Sent: Friday, 13 May, 2011 22:52 To: Rene Kluwen Cc: Mike Nakos; [email protected] Subject: Re: sqlbox greek gsm-7 I use Dev version, 1.5, - sqlbox included. If it gives an info.. On Fri, May 13, 2011 at 11:43 PM, Tania Petsouka <[email protected]> wrote: Last time, i copied it to be sure.. INSERT INTO send_sms (momt, sender, receiver, msgdata, sms_type, dlr_mask, coding) VALUES('MT', 'tan', '306937078135', '%00%10%12%13%14', 2, 31, 0); And i did it directly to the database.. On Fri, May 13, 2011 at 11:40 PM, Rene Kluwen <[email protected]> wrote: Could you display the insert statement that you are using? It must be similar to the one that Mike suggested. =-= Rene From: [email protected] [mailto:[email protected]] On Behalf Of Tania Petsouka Sent: Friday, 13 May, 2011 22:02 To: Mike Nakos Cc: [email protected] Subject: Re: sqlbox greek gsm-7 If i send url encoded chars like %00%10%12%13%14' from url , http request, there is no problem at all. The issue occurs only with sql box. So.. i tried to change table send_sms to utf8, no luck. I turned it back to latin. Did you change default settings of send_sms table? 2011/5/13 Tania Petsouka <[email protected]> I tried it, but i receive the exact string i insert to the database: %00%10%12%13%14. short_message: "%00%10%12%13%14" Obviously, i have wrong settings somewhere... but my config is like yours.. Have you got any idea? 2011/5/13 Mike Nakos <[email protected]> You are wrong when you put to DB value 0x00 because this indicates the end of the string. You see, null terminated string. You did also misunderstand the purpose of php hexdec() function. To make this function work you should use it this way: hexdec('00') But this is not the point. D O N ' T use chr() function. To correctly insert data to msgdata field and overcome the 0x00 (NULL problem - which is not kannel's problem) is this: INSERT INTO send_sms (momt, sender, receiver, msgdata, sms_type, dlr_mask, coding) VALUES('MT', 'mike', '3069112345', '%00%10%12%13%14', 2, 31, 0); And again, URL-ENCODE the characters Give it a shoot! On 13/05/11 11:35, Πετσούκα Τάνια wrote: It didn't work. i replace '@' with chr(hexdec( '%00' )) If i send a message with text " [email protected]" , I receive "user" . In kannel logs too : short_message: "user". I've tried to send all gsm charecters, but none turned to '@'. I guess it may be represented by two chars, like euro, but i have no idea. '0x00' is the null character, so kannel confuses somewhere and thinks that this is the end of the sms?? I was thinking that it might be SMSC's issue but it is not since logs from submit_sm give short_message: "user" . Mike, if you really send '@' , could you send me a db insert for a message with this symbol to try? (ps: your patch for concatenation works perfectly) ----- Original Message ----- From: "Mike Nakos" <[email protected]> To: "Πετσούκα Τάνια" <[email protected]> Cc: <[email protected]> Sent: Thursday, May 12, 2011 7:39 PM Subject: Re: sqlbox greek gsm-7 Hi again. %00 is the answer. All the alphabet is here: http://en.wikipedia.org/wiki/GSM_03.38 Best regards Mike Nakos On 12/05/11 14:08, Πετσούκα Τάνια wrote: Thank you Mike, i send greek properly using your settings. The only problem i came up with is symbol '@'. E.g : For greek letter Phi, Φ, i use : chr(hexdec( '0x12' )) ( or chr(hexdec( '%12') ) For greek letter Lamda, Λ, i use : chr(hexdec( '0x14' )) ( or chr(hexdec( '%14') ) For euro sign ¤ i use : chr(hexdec('0x1B')).chr(hexdec('0x65')) .....etc When it comes to '@' if i replace it to chr(hexdec( '0x00' )) according to gsm mapping, http://www.cardboardfish.com/support/bin/view/Main/GSMEncoding the message after this character disappears. I tried to replace it with chr(hexdec( '%40' )) , and i got 'i' in its position to the received message. So, do you know which is the proper way to send '@'? ----- Original Message ----- From: "Mike Nakos" <[email protected]> To: <[email protected]> Cc: <[email protected]> Sent: Wednesday, May 11, 2011 8:14 PM Subject: Re: Re: sqlbox greek gsm-7 Hello Tania. I use the below settings on my kannel.conf file group = smsc smsc = smpp smsc-id = <myprovider> host = <ip address> port = <smsc port> receive-port = <smsc port> smsc-username = <username> smsc-password = <password> source-addr-ton = 0 source-addr-npi = 1 dest-addr-ton = 1 #dest-addr-np = 1 bind-addr-ton = 0 bind-addr-npi = 1 system-type = "VMA" enquire-link-interval = 30 reconnect-delay = 10 throughput = 20 validityperiod = 1340 alt-charset = "UTF-8" I don't use alt_dcs and set charset field on sms_send table to UTF-8 also. Of course, any Greek character like Δ must be written %10 to msgdata field. Personally, I encode every single character to its gsm value. Always with % in front of it. DB field and table encoding is utf-8 also. Try these settings and follow the thread with title SMS from sqlbox - Problem when sending more that 160 char with greek letters on May 2011. I think this will help you. Best Regards Mike Nakos
smime.p7s
Description: S/MIME cryptographic signature
