RE: sqlbox: save SMS in readable format

2014-04-26 Thread mozzee
Thank, but unhex is not showing the message properly. Perhaps spameden is right, its related to encoding and chart-set. All my SMS are in Arabic and when I try to unhex its appears like G'J 3(*HF #F' 9(/'DHG'( 'D2F'*J EF ,F2H1 AJDJ(J' #F' F-( ('(' H E'E' H #.*J H F'1H*H

sqlbox: save SMS in readable format

2014-04-24 Thread mozzee
How can we save SMS in readable format in MySQL instead of urlencoded hex?

store SMS into MySQL with original text

2014-04-23 Thread mozzee
Hi, I want to store SMS with its original text into the database instead of the default encoded format. I am using UTF-8 charset due to the Arabic language requirement and all messages are ending up like msgdata:06470627064A002006330628062A064806460020062306460627002006390628062F

sqlbox MySQL error

2012-12-05 Thread mozzee
I have installed kannel 1.5.0 with sqlbox. It works fine but sometime I see following error in the sqlbox log 2012-12-05 15:33:16 [25488] [4] ERROR: MYSQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '''

Re: sqlbox MySQL error

2012-12-05 Thread mozzee
OK, I updated to `svn-r5011' and so far it looks good From: spameden Sent: 06 December 2012 1:16 AM To: Moazzam Ali Cc: users@kannel.org Subject: Re: sqlbox MySQL error Compile and install latest from the trunk it should work just fine - do not use .tar.gz Do not forget to compile and

saltbox MySQL insert error

2012-09-17 Thread mozzee
I am facing an issue with my sqlbox. Sometime sqlbox log showing the following error 2012-09-18 00:47:45 [18824] [4] ERROR: MYSQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''' at line 1 I am using

message coding and %c

2012-07-31 Thread mozzee
I am facing an issue with the message encoding. I want to pass message coding to my get-url but 2012-07-31 13:06:51 Receive SMS [SMSC:XX] [SVC:] [ACT:51025] [BINF:] [FID:] [META:?smpp?] [from:] [to:] [flags:-1:2:-1:0:-1]

Re: message coding and %c

2012-07-31 Thread mozzee
seems mo-recode = true was causing this issue. I have disabled it and now correct encoding is coming in the get-url From: moz...@gmail.com Sent: 31 July 2012 4:05 PM To: users@kannel.org Subject: message coding and %c I am facing an issue with the message encoding. I want to pass

Re: how to remove + from receiving short-code

2012-07-26 Thread mozzee
using %P and %p results like does not remove + from the receiver part e-g access.log; [from:218922526xxx] [to:+21855xxx] smsbox; 2012-07-26 12:21:51 [6300] [4] INFO: Starting to service Test from 51025 from 218922526xxx to :+21855xxx it remove + from the sender but not from the receiver I