Here is the insert query which works perfectly fine on old system but
not on the new one
INSERT INTO send_sms (
sql_id, momt, sender, receiver, udhdata, msgdata, time, smsc_id,
service, account, id, sms_type, mclass, mwi, coding, compress, validity,
deferred, dlr_mask, dlr_url, pid, alt_dcs, rpi, charset, boxc_id, binfo,
meta_data, priority, foreign_id
) VALUES (
1, 'MT', 'UnicKlad', '306931234567', NULL,
'%ce%b1%ce%b2%ce%b3%ce%b4%ce%b5%ce%b6%ce%b7%ce%b8%ce%b9%ce%ba%ce%bb%ce%bc%ce%bd%ce%be%ce%bf%cf%80%cf%81%cf%83%cf%84%cf%85%cf%86%cf%87%cf%88%cf%89%0a%40%23!%24%25%5e%26*()+%5b%5d+%7b%7d+%27%3b+%3f+%3c%3e+%2f+%5c+%7c%3d+%2b+-+%e2%82%ac',
NULL, 'MYSMSC', NULL, 'account', NULL, 2, NULL, NULL, 2, NULL, 4320,
NULL, 19, 'http://url', NULL, NULL, NULL, 'utf-8', NULL, NULL, NULL,
NULL, NULL
);
On 4/7/24 12:39, Ruben Melikyan wrote:
Hi Dinos,
Please paste here your sql query which inserts unicode message to
SendTable.
Please provide full query
Best regards,
Ruben Melikyan
------------------------------------------------------------------------
*From:* Konstantinos Liadakis <kliada...@yuboto.com>
*Sent:* Thursday, July 4, 2024 11:44:39 AM
*To:* Ruben Melikyan <r...@mobbis.am>; users@kannel.org <users@kannel.org>
*Subject:* Re: unicode problem with sqlbox Revision: 62
Hellomy replies below to your questions
1. I can send normal sms with no problem, it is just unicode that i am
not able to send
2. MariaDB [kannel]> show variables like '%char%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| character_set_database | utf8mb4 |
| character_set_filesystem | binary |
| character_set_results | utf8mb4 |
| character_set_server | utf8mb4 |
| character_set_system | utf8mb3 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.002 sec)
MariaDB [kannel]> show variables like '%collation%';
+----------------------+--------------------+
| Variable_name | Value |
+----------------------+--------------------+
| collation_connection | utf8mb4_general_ci |
| collation_database | utf8mb4_general_ci |
| collation_server | utf8mb4_general_ci |
+----------------------+--------------------+
3 rows in set (0.001 sec)
3. I am sending message by making an insert to mysql
4. Yes
5. The table is created by sqlbox it self
MariaDB [kannel]> select * from sent_sms;
+--------+------+----------+--------------+---------+----------------------------------------------------------------------------------------------------------------+------------+--------------+---------+------------+------+----------+--------+------+--------+----------+----------+----------+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------+------+---------+------+---------+---------+-------+------------------------------------------------+----------+------------+
| sql_id | momt | sender | receiver | udhdata | msgdata |
time | smsc_id | service | account | id | sms_type |
mclass | mwi | coding | compress | validity | deferred | dlr_mask |
dlr_url | pid | alt_dcs | rpi | charset | boxc_id | binfo |
meta_data | priority | foreign_id |
+--------+------+----------+--------------+---------+----------------------------------------------------------------------------------------------------------------+------------+--------------+---------+------------+------+----------+--------+------+--------+----------+----------+----------+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------+------+---------+------+---------+---------+-------+------------------------------------------------+----------+------------+
I installed kannel from svn, and also sqlbox.
Today i did make clean in sqlbox and recompiled the one from addons
folder, but i is exactly the same version when doing svn info
I am sure if i install an older version everything will work....
Thank you for your efforts
Best regards
Dinos
On 4/7/24 07:24, Ruben Melikyan wrote:
Hi Dinos,
If so, I need more info:
1. if you send ASCII( not unicode message), what happens? Do you see
record in your table?
2. What are your DB settings ?
3. How do you send message? Please provide detailed description
with example.
4. Did you try to send both ASCII and UNICODE message using
SendTable? If no, refer to sqlbox user guide "Inserting MT
messages by SQL" section and try if it works.
5. Please also provide your SentTable structure
P.S. Assuming that you are using sources from Kannel.org, using
current stable version (1.4.5), did not change anything in sources
and had compiled sqlbox using sources located in original Addons folder.
Best regards,
Ruben Melikyan
------------------------------------------------------------------------
*From:* Konstantinos Liadakis <kliada...@yuboto.com>
<mailto:kliada...@yuboto.com>
*Sent:* Thursday, July 4, 2024 2:20:58 AM
*To:* Ruben Melikyan <r...@mobbis.am> <mailto:r...@mobbis.am>;
users@kannel.org <mailto:users@kannel.org> <users@kannel.org>
<mailto:users@kannel.org>
*Subject:* Re: unicode problem with sqlbox Revision: 62
Hello Ruben, and thank you for your reply.
The tables were created automatically from sqlbox like you propose.
In fact i have dropped the tables a few times but no change
Regards
Dinos
On 3/7/24 19:06, Ruben Melikyan wrote:
Hi,
Obviously you have problem with your mysql database tables.
You can leave table creation to sqlbox itself. This is the best way.
Just leave database empty and run kannel. If your kannel configured
properly, sqlbox will create tables automatically.
Referring to sqlbox documentation:
*Database Tables***
Sqlbox creates it's DB tables on the fly if the tables are not
present at that moment.
P.S. Kannel’s sqlbox saving SMS message incliding unicode in encoded
format.
*Best regards,*
*Ruben Melikyan*
*From:* users <users-boun...@kannel.org>
<mailto:users-boun...@kannel.org> *On Behalf Of *Konstantinos Liadakis
*Sent:* 03.07.2024 17:13
*To:* users@kannel.org <mailto:users@kannel.org>
*Subject:* unicode problem with sqlbox Revision: 62
Hello,
I am trying to send unicode using sqlbox but i am unable. I am
getting the following error
2024-07-03 12:53:37 [46054] [1] ERROR: MYSQL: You have an error in
your SQL syntax; check the manual that corresponds to your MariaDB
server version for the right syntax to use near '' at line 1
2024-07-03 12:53:37 [46054] [1] ERROR: MYSQL: You have an error in
your SQL syntax; check the manual that corresponds to your MariaDB
server version for the right syntax to use near ')' at line 1
2024-07-03 12:53:37 [46054] [1] ERROR: Could not charset process
message, dropping it!
I am using
Kannel bearerbox version `svn-r5335M'. Build `Apr 21 2024 15:23:40',
compiler `11.4.0'. System Linux, release 5.15.0-113-generic, version
#123-Ubuntu SMP Mon Jun 10 08:16:17 UTC 2024, machine x86_64.
Hostname kannel3.srv.example.com, IP 1.1.1.1 Libxml version 2.9.13.
Using OpenSSL 3.0.2 15 Mar 2022. Compiled with MySQL 8.0.36, using
MySQL 8.0.37. Using hiredis API 0.14.1 Using native malloc.
The sqlbox version below *does not work with unicode*
Working Copy Root Path: /usr/local/src/kannel/sqlbox
URL: https://svn.kannel.org/sqlbox/trunk
<https://svn.kannel.org/sqlbox/trunk>
Relative URL: ^/trunk
Repository Root: https://svn.kannel.org/sqlbox
<https://svn.kannel.org/sqlbox>
Revision: 62
Node Kind: directory
Schedule: normal
Last Changed Author: stolj
Last Changed Rev: 62
Last Changed Date: 2023-03-09 11:22:07 +0000 (Thu, 09 Mar 2023)
I am having an older instance where unicode from sqlbox *works* with
no problem
Path: .
Working Copy Root Path: /usr/local/src/kannel/sqlbox
URL: https://svn.kannel.org/sqlbox/trunk
<https://svn.kannel.org/sqlbox/trunk>
Relative URL: ^/trunk
Repository Root: https://svn.kannel.org/sqlbox
<https://svn.kannel.org/sqlbox>
Revision: 58
Node Kind: directory
Schedule: normal
Last Changed Author: rkluwen
Last Changed Rev: 58
Last Changed Date: 2017-07-12 23:38:55 +0300 (Wed, 12 Jul 2017)
I am using coding=2 and charset utf-8 and messages are url encoded.
In fact same query that works on old sqlbox does not work on the
newer one giving the charset error above
I tried applying the sqlbox patch but nothing changed. Maybe i am
missing something? When should the patch be applied?
Thank you in advance for your help
regards
Dinos
