Dinos
Try this
INSERT INTO send_sms
(
`momt`,
`sender`,
`receiver`,
`msgdata`,
`time`,
`service`,
`sms_type`,
`coding`,
`charset`,
`dlr_mask`
)
VALUES (
'MT',
'UnicKlad',
'306931234567',
'%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',
UNIX_TIMESTAMP(),
'sqlbox',
'2',
'2',
'utf-8',
'19'
);
If you inserting unicode message via sql query, parameters coding and charset
are relevant.
For Unicode you should use coding =2, charset = utf-8 . For ASCII you should
use coding =0, charset = NULL
P.S. I had removed parameters related to delivery, you should add this later if
you have callback service
Below is the result of above mentioned query
[cid:[email protected]]
Best regards,
Ruben Melikyan
From: Konstantinos Liadakis <[email protected]>
Sent: 04.07.2024 13:43
To: Ruben Melikyan <[email protected]>; [email protected]
Subject: Re: unicode problem with sqlbox Revision: 62
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 <[email protected]><mailto:[email protected]>
Sent: Thursday, July 4, 2024 11:44:39 AM
To: Ruben Melikyan <[email protected]><mailto:[email protected]>;
[email protected]<mailto:[email protected]>
<[email protected]><mailto:[email protected]>
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 <[email protected]><mailto:[email protected]>
Sent: Thursday, July 4, 2024 2:20:58 AM
To: Ruben Melikyan <[email protected]><mailto:[email protected]>;
[email protected]<mailto:[email protected]>
<[email protected]><mailto:[email protected]>
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 <[email protected]><mailto:[email protected]> On
Behalf Of Konstantinos Liadakis
Sent: 03.07.2024 17:13
To: [email protected]<mailto:[email protected]>
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
Relative URL: ^/trunk
Repository Root: 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
Relative URL: ^/trunk
Repository Root: 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
