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
How can we save SMS in readable format in MySQL instead of urlencoded hex?
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
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 '''
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
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
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]
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
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