Re: unicode problem with sqlbox Revision: 62
Kyriacos/Netsmart <[email protected]> Fri, 5 Jul 2024 11:50:55 +0300
| Newsgroups | gmane.comp.mobile.kannel.user |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format. --------------Yj0dib8XUOEhdAeGeJ99TOfn Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Hi, Did you upgrade both kannel and the DB server/version at once? If you set the new kannel instance to write to the old DB, or the old kannel to the new DB what happens? Kyriacos On 04/07/2024 12:42 pm, Konstantinos Liadakis wrote: > > 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]> >> *Sent:* Thursday, July 4, 2024 11:44:39 AM >> *To:* Ruben Melikyan <[email protected]>; [email protected] <[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 >>>> <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 >>>> -- Kyriacos Sakkas Netsmart Tel: + 357 22 452565 Fax: + 357 22 452566 Email:[email protected] http://www.netsmart.com.cy Taking Business to a New Level! ** Confidentiality Notice: The information contained in this email message may be privileged, confidential and protected from disclosure. If you are not the intended recipient, any dissemination, distribution, or copying of this email message is strictly prohibited. If you think that you have received this email message in error, please email the sender [email protected] ** --------------Yj0dib8XUOEhdAeGeJ99TOfn Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit <!DOCTYPE html> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> </head> <body> Hi,<br> <br> Did you upgrade both kannel and the DB server/version at once? If you set the new kannel instance to write to the old DB, or the old kannel to the new DB what happens?<br> <br> Kyriacos<br> <br> <div class="moz-cite-prefix">On 04/07/2024 12:42 pm, Konstantinos Liadakis wrote:<br> </div> <blockquote type="cite" cite="mid:[email protected]"> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <p>Here is the insert query which works perfectly fine on old system but not on the new one</p> <p>INSERT INTO send_sms (<br> 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<br> ) VALUES (<br> 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, '<a class="moz-txt-link-freetext" href="http://url" moz-do-not-send="true">http://url</a>', NULL, NULL, NULL, 'utf-8', NULL, NULL, NULL, NULL, NULL<br> );<br> </p> <div class="moz-cite-prefix">On 4/7/24 12:39, Ruben Melikyan wrote:<br> </div> <blockquote type="cite" cite="mid:PAVP195MB2233468ACB1C400AE4026FBDDFDE2@PAVP195MB2233.EURP195.PROD.OUTLOOK.COM"> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <div> <div dir="ltr"> <div dir="ltr">Hi Dinos,</div> <div dir="ltr">Please paste here your sql query which inserts unicode message to SendTable. </div> <div dir="ltr"><br> </div> <div dir="ltr">Please provide full query</div> </div> </div> <div id="ms-outlook-mobile-signature"> <div><br> </div> <div dir="ltr"> <div dir="ltr">Best regards,</div> <div dir="ltr">Ruben Melikyan</div> </div> </div> <hr style="display:inline-block;width:98%" tabindex="-1"> <div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" face="Calibri, sans-serif" color="#000000"><b>From:</b> Konstantinos Liadakis <a class="moz-txt-link-rfc2396E" href="mailto:[email protected]" moz-do-not-send="true"><[email protected]></a><br> <b>Sent:</b> Thursday, July 4, 2024 11:44:39 AM<br> <b>To:</b> Ruben Melikyan <a class="moz-txt-link-rfc2396E" href="mailto:[email protected]" moz-do-not-send="true"><[email protected]></a>; <a class="moz-txt-link-abbreviated moz-txt-link-freetext" href="mailto:[email protected]" moz-do-not-send="true">[email protected]</a> <a class="moz-txt-link-rfc2396E" href="mailto:[email protected]" moz-do-not-send="true"><[email protected]></a><br> <b>Subject:</b> Re: unicode problem with sqlbox Revision: 62</font> <div> </div> </div> <div> <p>Hellomy replies below to your questions</p> <p>1. I can send normal sms with no problem, it is just unicode that i am not able to send</p> <p>2. MariaDB [kannel]> show variables like '%char%';<br> +--------------------------+----------------------------+<br> | Variable_name | Value |<br> +--------------------------+----------------------------+<br> | character_set_client | utf8mb4 |<br> | character_set_connection | utf8mb4 |<br> | character_set_database | utf8mb4 |<br> | character_set_filesystem | binary |<br> | character_set_results | utf8mb4 |<br> | character_set_server | utf8mb4 |<br> | character_set_system | utf8mb3 |<br> | character_sets_dir | /usr/share/mysql/charsets/ |<br> +--------------------------+----------------------------+<br> 8 rows in set (0.002 sec)<br> <br> MariaDB [kannel]> show variables like '%collation%';<br> +----------------------+--------------------+<br> | Variable_name | Value |<br> +----------------------+--------------------+<br> | collation_connection | utf8mb4_general_ci |<br> | collation_database | utf8mb4_general_ci |<br> | collation_server | utf8mb4_general_ci |<br> +----------------------+--------------------+<br> 3 rows in set (0.001 sec)</p> <p><br> </p> <p>3. I am sending message by making an insert to mysql</p> <p>4. Yes</p> <p>5. The table is created by sqlbox it self</p> <p>MariaDB [kannel]> select * from sent_sms;<br> +--------+------+----------+--------------+---------+----------------------------------------------------------------------------------------------------------------+------------+--------------+---------+------------+------+----------+--------+------+--------+----------+----------+----------+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------+------+---------+------+---------+---------+-------+------------------------------------------------+----------+------------+<br> | 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 |<br> +--------+------+----------+--------------+---------+----------------------------------------------------------------------------------------------------------------+------------+--------------+---------+------------+------+----------+--------+------+--------+----------+----------+----------+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------+------+---------+------+---------+---------+-------+------------------------------------------------+----------+------------+<br> </p> <p>I installed kannel from svn, and also sqlbox.</p> <p>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</p> <p>I am sure if i install an older version everything will work....</p> <p>Thank you for your efforts</p> <p>Best regards</p> <p>Dinos<br> </p> <div class="x_moz-cite-prefix">On 4/7/24 07:24, Ruben Melikyan wrote:<br> </div> <blockquote type="cite"> <div> <div dir="ltr"> <div dir="ltr">Hi Dinos,</div> <div dir="ltr">If so, I need more info:</div> <div dir="ltr"> <ol data-editing-info="{"orderedStyleType":1,"unorderedStyleType":1}" style="margin-top:0px; margin-bottom:0px"> <li style="list-style-type:"1. ""><span>if you send ASCII( not unicode message), what happens? Do you see record in your table?</span></li> <li style="list-style-type:"2. ""><span>What are your DB settings ?<span></span></span></li> <li style="list-style-type:"3. ""><span>How do you send message? Please provide detailed description with example.<span></span></span></li> <li style="list-style-type:"4. ""><span>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.</span></li> <li style="list-style-type:"5. "; font-size:inherit"><span style="font-size:inherit">Please also provide your SentTable structure</span></li> </ol> </div> <div dir="ltr"><span></span></div> <div dir="ltr"><br> </div> <div dir="ltr">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.</div> </div> </div> <div id="x_ms-outlook-mobile-signature"> <div><br> </div> <div dir="ltr"> <div dir="ltr">Best regards,</div> <div dir="ltr">Ruben Melikyan</div> </div> </div> <hr tabindex="-1" style="display:inline-block; width:98%"> <div id="x_divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" face="Calibri, sans-serif" color="#000000"><b>From:</b> Konstantinos Liadakis <a class="x_moz-txt-link-rfc2396E" href="mailto:[email protected]" moz-do-not-send="true"><[email protected]></a><br> <b>Sent:</b> Thursday, July 4, 2024 2:20:58 AM<br> <b>To:</b> Ruben Melikyan <a class="x_moz-txt-link-rfc2396E" href="mailto:[email protected]" moz-do-not-send="true"> <[email protected]></a>; <a class="x_moz-txt-link-abbreviated moz-txt-link-freetext" href="mailto:[email protected]" moz-do-not-send="true"> [email protected]</a> <a class="x_moz-txt-link-rfc2396E" href="mailto:[email protected]" moz-do-not-send="true"> <[email protected]></a><br> <b>Subject:</b> Re: unicode problem with sqlbox Revision: 62</font> <div> </div> </div> <div> <p>Hello Ruben, and thank you for your reply.</p> <p>The tables were created automatically from sqlbox like you propose. In fact i have dropped the tables a few times but no change</p> <p>Regards</p> <p>Dinos<br> </p> <div class="x_x_moz-cite-prefix">On 3/7/24 19:06, Ruben Melikyan wrote:<br> </div> <blockquote type="cite"> <meta name="Generator" content="Microsoft Word 15 (filtered medium)"> <style>@font-face {font-family:"Cambria Math"}@font-face {font-family:Calibri}p.x_x_MsoNormal, li.x_x_MsoNormal, div.x_x_MsoNormal {margin:0in; font-size:11.0pt; font-family:"Calibri",sans-serif}a:link, span.x_x_MsoHyperlink {color:blue; text-decoration:underline}span.x_x_EmailStyle21 {font-family:"Calibri",sans-serif; color:windowtext}.x_x_MsoChpDefault {font-size:10.0pt}</style> <div class="x_x_WordSection1"> <p class="x_x_MsoNormal"><a name="x_x__Hlk120024655" moz-do-not-send="true"><span lang="EN-GB">Hi,</span></a></p> <p class="x_x_MsoNormal"><span style=""><span lang="EN-GB">Obviously you have problem with your mysql database tables.</span></span></p> <p class="x_x_MsoNormal"><span style=""><span lang="EN-GB">You can leave table creation to sqlbox itself. This is the best way.</span></span></p> <p class="x_x_MsoNormal"><span style=""><span lang="EN-GB"> </span></span></p> <p class="x_x_MsoNormal"><span style=""><span lang="EN-GB">Just leave database empty and run kannel. If your kannel configured properly, sqlbox will create tables automatically.</span></span></p> <p class="x_x_MsoNormal"><span style=""><span lang="EN-GB"> </span></span></p> <p class="x_x_MsoNormal"><span style=""><span lang="EN-GB">Referring to sqlbox documentation:</span></span></p> <p class="x_x_MsoNormal" style="background:white"><span style=""><a name="x_x_AEN473" moz-do-not-send="true"><b><span style="font-size:13.5pt; font-family:"Times New Roman",serif; color:black">Database Tables</span></b></a></span><span style=""><b><span style="font-size:13.5pt; font-family:"Times New Roman",serif; color:black"></span></b></span></p> <p class="x_x_MsoNormal" style="background:white"><span style=""><span style="font-size:13.5pt; font-family:"Times New Roman",serif; color:black">Sqlbox creates it's DB tables on the fly if the tables are not present at that moment.</span></span></p> <p class="x_x_MsoNormal"><span style=""><span lang="EN-GB"> </span></span></p> <p class="x_x_MsoNormal"><span style=""><span lang="EN-GB">P.S. Kannel’s sqlbox saving SMS message incliding unicode in encoded format.</span></span></p> <span style=""></span> <div> <p class="x_x_MsoNormal" style=""><b><span style="font-size:12.0pt; font-family:"Times New Roman",serif">Best regards,</span></b><span style="font-size:12.0pt; font-family:"Times New Roman",serif"> <br> <br> <b>Ruben Melikyan</b></span></p> </div> <p class="x_x_MsoNormal"><span lang="EN-GB"> </span></p> <div> <div style="border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0in 0in 0in"> <p class="x_x_MsoNormal"><b>From:</b> users <a class="x_x_moz-txt-link-rfc2396E" href="mailto:[email protected]" moz-do-not-send="true"> <[email protected]></a> <b>On Behalf Of </b>Konstantinos Liadakis<br> <b>Sent:</b> 03.07.2024 17:13<br> <b>To:</b> <a class="x_x_moz-txt-link-abbreviated x_moz-txt-link-freetext moz-txt-link-freetext" href="mailto:[email protected]" moz-do-not-send="true"> [email protected]</a><br> <b>Subject:</b> unicode problem with sqlbox Revision: 62</p> </div> </div> <p class="x_x_MsoNormal"> </p> <p class="x_x_MsoNormal">Hello, </p> <div> <p>I am trying to send unicode using sqlbox but i am unable. I am getting the following error</p> <p>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<br> 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<br> 2024-07-03 12:53:37 [46054] [1] ERROR: Could not charset process message, dropping it!</p> <p>I am using </p> <p>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.</p> <p>The sqlbox version below <b>does not work with unicode</b></p> <p>Working Copy Root Path: /usr/local/src/kannel/sqlbox<br> URL: <a href="https://svn.kannel.org/sqlbox/trunk" class="x_x_moz-txt-link-freetext x_moz-txt-link-freetext moz-txt-link-freetext" moz-do-not-send="true"> https://svn.kannel.org/sqlbox/trunk</a><br> Relative URL: ^/trunk<br> Repository Root: <a href="https://svn.kannel.org/sqlbox" class="x_x_moz-txt-link-freetext x_moz-txt-link-freetext moz-txt-link-freetext" moz-do-not-send="true"> https://svn.kannel.org/sqlbox</a><br> Revision: 62<br> Node Kind: directory<br> Schedule: normal<br> Last Changed Author: stolj<br> Last Changed Rev: 62<br> Last Changed Date: 2023-03-09 11:22:07 +0000 (Thu, 09 Mar 2023)</p> <p> </p> <p>I am having an older instance where unicode from sqlbox <b>works</b> with no problem</p> <p>Path: .<br> Working Copy Root Path: /usr/local/src/kannel/sqlbox<br> URL: <a href="https://svn.kannel.org/sqlbox/trunk" class="x_x_moz-txt-link-freetext x_moz-txt-link-freetext moz-txt-link-freetext" moz-do-not-send="true"> https://svn.kannel.org/sqlbox/trunk</a><br> Relative URL: ^/trunk<br> Repository Root: <a href="https://svn.kannel.org/sqlbox" class="x_x_moz-txt-link-freetext x_moz-txt-link-freetext moz-txt-link-freetext" moz-do-not-send="true"> https://svn.kannel.org/sqlbox</a><br> Revision: 58<br> Node Kind: directory<br> Schedule: normal<br> Last Changed Author: rkluwen<br> Last Changed Rev: 58<br> Last Changed Date: 2017-07-12 23:38:55 +0300 (Wed, 12 Jul 2017)</p> <p>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</p> <p>I tried applying the sqlbox patch but nothing changed. Maybe i am missing something? When should the patch be applied?</p> <p>Thank you in advance for your help </p> <p>regards</p> <p>Dinos</p> </div> </div> </blockquote> </div> </blockquote> </div> </blockquote> </blockquote> <br> <pre class="moz-signature" cols="72">-- Kyriacos Sakkas Netsmart Tel: + 357 22 452565 Fax: + 357 22 452566 Email: <a class="moz-txt-link-abbreviated" href="mailto:[email protected]">[email protected]</a> <a class="moz-txt-link-freetext" href="http://www.netsmart.com.cy">http://www.netsmart.com.cy</a> Taking Business to a New Level! ** Confidentiality Notice: The information contained in this email message may be privileged, confidential and protected from disclosure. If you are not the intended recipient, any dissemination, distribution, or copying of this email message is strictly prohibited. If you think that you have received this email message in error, please email the sender at <a class="moz-txt-link-abbreviated" href="mailto:[email protected]">[email protected]</a> **</pre> </body> </html> --------------Yj0dib8XUOEhdAeGeJ99TOfn--