Trying to install Kannel 1.4.4 from official site.
1. ./configure - ok
2. make - got error "unknown type name YYLTYPE"
found in google, that it is something similar Yacc or Bison parser.
Currently bison 2:3.0.3 is installed.
I don't know much about this (better to say I don't know anything about
yacc).
Need help.
On 01/23/2016 01:13 AM, spameden wrote:
2016-01-22 19:54 GMT+03:00 Deins <notabenaaba...@gmail.com
<mailto:notabenaaba...@gmail.com>>:
1) I use Kannel 1.4.3 from Debian repo. I will try to install
latest stable version if nothing helps.
2) All tables in my database already was utf8, but to be sure I'm
executed:
ALTER TABLE send_sms CONVERT TO CHARACTER SET utf8;
...
3) yes, it is
4) coding=2, charset=utf8
5) now I have "empty square" characters on my phone.
As I said before you need to use latest version from SVN or version
1.4.4 (which is stable and released), althrough SVN version is
considered to be production ready and have most of the bugs fixed. You
need to use SVN version of sqlbox as well as kannel.
In version 1.4.3 and 1.5.0 (previous DEV version) there was a bug
related to UCS-2 characters conversion which was fixed 2 years ago or
so, so just use SVN version it's best and it's not hard to compile.
On 01/22/2016 06:30 PM, spameden wrote:
To get proper cyrillic or any UCS-2 text on your handset:
1) Make sure you use latest kannel version from SVN (compile it
yourself)
2) execute in MySQL:
ALTER table send_sms charset=utf8
ALTER table sent_sms charset=utf8
ALTER table dlr charset=utf8
So all your tables will be in utf8 encoding.
3) When you insert text into send_sms table you need to make sure
text is in UTF-8 encoding and urlencoded.
4) set coding=2 and charset='utf8', NOTE: each MT will be limited
to 70 symbols. If you use concatenated MT each part will be
limited to 69 symbols.
5) This way you'll get proper text on your handset.
About msgdata field in sent_sms table: text is double urlencoded,
I think it's either a bug in kannel or feature (?). Text is
urlencoded to avoid all hassle to deal with many encodings out
there, because for every encoding you'd need proper escaping,
this way kannel deals with escaping. If you really need to
preserve original text (AS IS) you need to modify kannel's source
code as well as sqlbox, which can be tricky OR as a workaround
you can have another table where you INSERT your text as well and
save it for billing purposes (e.g. billing table)
Generally speaking: both send_sms and sent_sms tables are kinda
temporary tables (at least I keep only 24 hours records there so
kannel operates quickly, because it still depends on MySQL answer).
You can set a TRIGGER on sent_sms table and get updated your
other billing table.
2016-01-22 14:08 GMT+03:00 Deins <notabenaaba...@gmail.com
<mailto:notabenaaba...@gmail.com>>:
I need to send sms with a cyrillic symbols. I write sql query
with a field coding=2.
In the send_sms table I see right value of the msgdata field.
But in sent_sms table all characters transforms into
3F3F3F.... string. How to deal with it?