Re: unicode problem with sqlbox Revision: 62
Konstantinos Liadakis <[email protected]> Thu, 4 Jul 2024 10:44:39 +0300
| Newsgroups | gmane.comp.mobile.kannel.user |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format. --------------dxTtxcFXRHr1n2N3GiD96ffs Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: quoted-printable Hellomy replies below to your questions 1. I can send normal sms with no problem, it is just unicode that i am=20 not able to send 2. MariaDB [kannel]> show variables like '%char%'; +--------------------------+----------------------------+ | Variable_name=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0 | Value=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | +--------------------------+----------------------------+ | character_set_client=C2=A0=C2=A0=C2=A0=C2=A0 | utf8mb4=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0 | | character_set_connection | utf8mb4=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= | | character_set_database=C2=A0=C2=A0 | utf8mb4=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0 | | character_set_filesystem | binary=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0 | | character_set_results=C2=A0=C2=A0=C2=A0 | utf8mb4=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0 | | character_set_server=C2=A0=C2=A0=C2=A0=C2=A0 | utf8mb4=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0 | | character_set_system=C2=A0=C2=A0=C2=A0=C2=A0 | utf8mb3=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0 | | character_sets_dir=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | /usr/share/mys= ql/charsets/ | +--------------------------+----------------------------+ 8 rows in set (0.002 sec) MariaDB [kannel]> show variables like '%collation%'; +----------------------+--------------------+ | Variable_name=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | Value=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | +----------------------+--------------------+ | collation_connection | utf8mb4_general_ci | | collation_database=C2=A0=C2=A0 | utf8mb4_general_ci | | collation_server=C2=A0=C2=A0=C2=A0=C2=A0 | 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=C2=A0=C2=A0 | receiver=C2=A0=C2=A0=C2=A0=C2=A0 |= udhdata | msgdata |=20 time=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | smsc_id=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0 | service | account=C2=A0=C2=A0=C2=A0 | id=C2=A0=C2=A0 | sms_type = |=20 mclass | mwi=C2=A0 | coding | compress | validity | deferred | dlr_mask |= =20 dlr_url | pid=C2=A0 | alt_dcs | rpi=C2=A0 | charset | boxc_id | binfo |=20 meta_data=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0 | priority | foreign_id | +--------+------+----------+--------------+---------+--------------------= -------------------------------------------------------------------------= -------------------+------------+--------------+---------+------------+--= ----+----------+--------+------+--------+----------+----------+----------= +----------+-------------------------------------------------------------= -------------------------------------------------------------------------= ------------------+------+---------+------+---------+---------+-------+--= ----------------------------------------------+----------+------------+ I installed kannel from svn, and also sqlbox. Today i did make clean in sqlbox and recompiled the one from addons=20 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=C2=A0 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=20 > current stable version (1.4.5), did not change anything in sources and=20 > had compiled sqlbox using sources located in original Addons folder. > > Best regards, > Ruben Melikyan > -----------------------------------------------------------------------= - > *From:* Konstantinos Liadakis <[email protected]> > *Sent:* Thursday, July 4, 2024 2:20:58 AM > *To:* Ruben Melikyan <[email protected]>; [email protected] <[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=20 > 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=20 >> 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=20 >> present at that moment. >> >> P.S. Kannel=E2=80=99s sqlbox saving SMS message incliding unicode in e= ncoded=20 >> format. >> >> *Best regards,* >> >> *Ruben Melikyan* >> >> *From:* users <[email protected]>=20 >> <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=20 >> getting the following error >> >> 2024-07-03 12:53:37 [46054] [1] ERROR: MYSQL: You have an error in=20 >> your SQL syntax; check the manual that corresponds to your MariaDB=20 >> 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=20 >> your SQL syntax; check the manual that corresponds to your MariaDB=20 >> 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=20 >> message, dropping it! >> >> I am using >> >> Kannel bearerbox version `svn-r5335M'. Build `Apr 21 2024 15:23:40',=20 >> compiler `11.4.0'. System Linux, release 5.15.0-113-generic, version=20 >> #123-Ubuntu SMP Mon Jun 10 08:16:17 UTC 2024, machine x86_64.=20 >> Hostname kannel3.srv.example.com, IP 1.1.1.1 Libxml version 2.9.13.=20 >> Using OpenSSL 3.0.2 15 Mar 2022. Compiled with MySQL 8.0.36, using=20 >> 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=20 >> <https://svn.kannel.org/sqlbox/trunk> >> Relative URL: ^/trunk >> Repository Root: https://svn.kannel.org/sqlbox=20 >> <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=20 >> no problem >> >> Path: . >> Working Copy Root Path: /usr/local/src/kannel/sqlbox >> URL: https://svn.kannel.org/sqlbox/trunk=20 >> <https://svn.kannel.org/sqlbox/trunk> >> Relative URL: ^/trunk >> Repository Root: https://svn.kannel.org/sqlbox=20 >> <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=3D2 and charset utf-8 and messages are url encoded.=20 >> In fact same query that works on old sqlbox does not work on the=20 >> newer one giving the charset error above >> >> I tried applying the sqlbox patch but nothing changed. Maybe i am=20 >> missing something? When should the patch be applied? >> >> Thank you in advance for your help >> >> regards >> >> Dinos >> --------------dxTtxcFXRHr1n2N3GiD96ffs Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable <!DOCTYPE html> <html> <head> <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DUTF= -8"> </head> <body> <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=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0 | Value=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 = |<br> +--------------------------+----------------------------+<br> | character_set_client=C2=A0=C2=A0=C2=A0=C2=A0 | utf8mb4=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0 |<br> | character_set_connection | utf8mb4=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0 |<br> | character_set_database=C2=A0=C2=A0 | utf8mb4=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0 |<br> | character_set_filesystem | binary=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0 |<br> | character_set_results=C2=A0=C2=A0=C2=A0 | utf8mb4=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0 |<br> | character_set_server=C2=A0=C2=A0=C2=A0=C2=A0 | utf8mb4=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0 |<br> | character_set_system=C2=A0=C2=A0=C2=A0=C2=A0 | utf8mb3=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0 |<br> | character_sets_dir=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | /usr/sha= re/mysql/charsets/ |<br> +--------------------------+----------------------------+<br> 8 rows in set (0.002 sec)<br> <br> MariaDB [kannel]> show variables like '%collation%';<br> +----------------------+--------------------+<br> | Variable_name=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | Value=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= |<br> +----------------------+--------------------+<br> | collation_connection | utf8mb4_general_ci |<br> | collation_database=C2=A0=C2=A0 | utf8mb4_general_ci |<br> | collation_server=C2=A0=C2=A0=C2=A0=C2=A0 | utf8mb4_general_ci |<b= r> +----------------------+--------------------+<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> +--------+------+----------+--------------+---------+--------------------= -------------------------------------------------------------------------= -------------------+------------+--------------+---------+------------+--= ----+----------+--------+------+--------+----------+----------+----------= +----------+-------------------------------------------------------------= -------------------------------------------------------------------------= ------------------+------+---------+------+---------+---------+-------+--= ----------------------------------------------+----------+------------+<b= r> | sql_id | momt | sender=C2=A0=C2=A0 | receiver=C2=A0=C2=A0=C2=A0=C2= =A0 | udhdata | msgdata=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0 | time=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | smsc_id=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0 | service | account=C2=A0=C2=A0=C2=A0 | id=C2=A0=C2=A0 | sms_type | mclass | mwi=C2=A0 | coding | compress | validity | defe= rred | dlr_mask | dlr_url=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | pid=C2=A0 | alt_dcs | rpi=C2=A0 | charset | boxc_id | binfo | meta_data=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0 | priority | foreign_id |<br> +--------+------+----------+--------------+---------+--------------------= -------------------------------------------------------------------------= -------------------+------------+--------------+---------+------------+--= ----+----------+--------+------+--------+----------+----------+----------= +----------+-------------------------------------------------------------= -------------------------------------------------------------------------= ------------------+------+---------+------+---------+---------+-------+--= ----------------------------------------------+----------+------------+<b= r> </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=3D"moz-cite-prefix">On 4/7/24 07:24, Ruben Melikyan wrote:= <br> </div> <blockquote type=3D"cite" cite=3D"mid:[email protected].= PROD.OUTLOOK.COM"> <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DU= TF-8"> <div> <div dir=3D"ltr"> <div dir=3D"ltr">Hi Dinos,</div> <div dir=3D"ltr">If so, I need more info:</div> <div dir=3D"ltr"> <ol data-editing-info=3D"{"orderedStyleType":1,"unorderedStyle= Type":1}" style=3D"margin-top: 0px; margin-bottom: 0px;"> <li style=3D"list-style-type: "1. ";"><span>if yo= u send ASCII( not unicode message), what happens? Do you see record in your table?</span></li> <li style=3D"list-style-type: "2. ";"><span>What are your DB settings ?<span></span></span></li> <li style=3D"list-style-type: "3. ";"><span>How d= o you send message? Please provide=C2=A0 detailed descrip= tion with example.<span></span></span></li> <li style=3D"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=3D"list-style-type: "5. "; font-size: inherit;"><span style=3D"font-size: inherit;">Please also provide your SentTable structure</span></li> </ol> </div> <div dir=3D"ltr"><span></span></div> <div dir=3D"ltr"><br> </div> <div dir=3D"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=3D"ms-outlook-mobile-signature"> <div><br> </div> <div dir=3D"ltr"> <div dir=3D"ltr">Best regards,</div> <div dir=3D"ltr">Ruben Melikyan</div> </div> </div> <hr style=3D"display:inline-block;width:98%" tabindex=3D"-1"> <div id=3D"divRplyFwdMsg" dir=3D"ltr"><font style=3D"font-size:11pt= " face=3D"Calibri, sans-serif" color=3D"#000000"><b>From:</b> Konstantinos Liadakis <a class=3D"moz-txt-link-rfc2396E" href=3D= "mailto:[email protected]"><[email protected]></a><br> <b>Sent:</b> Thursday, July 4, 2024 2:20:58 AM<br> <b>To:</b> Ruben Melikyan <a class=3D"moz-txt-link-rfc2396E" hr= ef=3D"mailto:[email protected]"><[email protected]></a>; <a class=3D"moz-txt-link-abbreviated" href=3D"mailto:users@kann= el.org">[email protected]</a> <a class=3D"moz-txt-link-rfc2396E" href=3D"m= ailto:[email protected]"><[email protected]></a><br> <b>Subject:</b> Re: unicode problem with sqlbox Revision: 62</f= ont> <div>=C2=A0</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=3D"x_moz-cite-prefix">On 3/7/24 19:06, Ruben Melikyan wrote:<br> </div> <blockquote type=3D"cite"> <meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)"> <style>@font-face {font-family:"Cambria Math"}@font-face {font-family:Calibri}p.x_MsoNormal, li.x_MsoNormal, div.x_MsoNormal {margin:0in; font-size:11.0pt; font-family:"Calibri",sans-serif}a:link, span.x_MsoHyperlink {color:blue; text-decoration:underline}span.x_EmailStyle21 {font-family:"Calibri",sans-serif; color:windowtext}.x_MsoChpDefault {font-size:10.0pt}div.x_WordSection1 {}</style> <div class=3D"x_WordSection1"> <p class=3D"x_MsoNormal"><a name=3D"x__Hlk120024655" moz-do-not-send=3D"true"><span lang=3D"EN-GB">Hi,</span><= /a></p> <p class=3D"x_MsoNormal"><span style=3D""><span lang=3D"EN-GB= ">Obviously you have problem with your mysql database tables.</span= ></span></p> <p class=3D"x_MsoNormal"><span style=3D""><span lang=3D"EN-GB= ">You can leave table creation to sqlbox itself. This is the best way.</span></span></p> <p class=3D"x_MsoNormal"><span style=3D""><span lang=3D"EN-GB= ">=C2=A0</span></span></p> <p class=3D"x_MsoNormal"><span style=3D""><span lang=3D"EN-GB= ">Just leave database empty and run kannel. If your kannel configured properly, sqlbox will create tables automatically.</span></span></p> <p class=3D"x_MsoNormal"><span style=3D""><span lang=3D"EN-GB= ">=C2=A0</span></span></p> <p class=3D"x_MsoNormal"><span style=3D""><span lang=3D"EN-GB= ">Referring to sqlbox documentation:</span></span></p> <p class=3D"x_MsoNormal" style=3D"background:white"><span style=3D""><a name=3D"x_AEN473" moz-do-not-send=3D"true">= <b><span style=3D"font-size:13.5pt; font-family:"Times New Roman",serif;= color:black">Database Tables</span></b></a></span><span style=3D""><b><sp= an style=3D"font-size:13.5pt; font-family:"Times New Roman",serif;= color:black"></span></b></span></p> <p class=3D"x_MsoNormal" style=3D"background:white"><span style=3D""><span style=3D"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=3D"x_MsoNormal"><span style=3D""><span lang=3D"EN-GB= ">=C2=A0</span></span></p> <p class=3D"x_MsoNormal"><span style=3D""><span lang=3D"EN-GB= ">P.S. Kannel=E2=80=99s sqlbox saving SMS message incliding un= icode in encoded format.</span></span></p> <span style=3D""></span> <div> <p class=3D"x_MsoNormal" style=3D""><b><span style=3D"font-size:12.0pt; font-family:"Times New Roman",serif"= >Best regards,</span></b><span style=3D"font-size:12.0pt; font-family:"Times New Roman",serif"= > <br> <br> <b>Ruben Melikyan</b></span></p> </div> <p class=3D"x_MsoNormal"><span lang=3D"EN-GB">=C2=A0</span></= p> <div> <div style=3D"border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0in 0= in 0in"> <p class=3D"x_MsoNormal"><b>From:</b> users <a class=3D"x_moz-txt-link-rfc2396E" href=3D"mailto:[email protected]" moz-do-not-send=3D"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=3D"x_moz-txt-link-abbreviated moz-txt-link-freetext" href=3D"mailto:[email protected]" moz-do-not-send=3D"true">[email protected]</a><br> <b>Subject:</b> unicode problem with sqlbox Revision: 62</p> </div> </div> <p class=3D"x_MsoNormal">=C2=A0</p> <p class=3D"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=3D"https://svn.kannel.org/sqlbox/trunk" class=3D"x_moz-txt-link-freetext moz-txt-link-freetext" moz-do-not-send=3D"true"> https://svn.kannel.org/sqlbox/trunk</a><br> Relative URL: ^/trunk<br> Repository Root: <a href=3D"https://svn.kannel.org/sqlbox" class=3D"x_moz-txt-link-freetext moz-txt-link-freetext" moz-do-not-send=3D"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>=C2=A0</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=3D"https://svn.kannel.org/sqlbox/trunk" class=3D"x_moz-txt-link-freetext moz-txt-link-freetext" moz-do-not-send=3D"true"> https://svn.kannel.org/sqlbox/trunk</a><br> Relative URL: ^/trunk<br> Repository Root: <a href=3D"https://svn.kannel.org/sqlbox" class=3D"x_moz-txt-link-freetext moz-txt-link-freetext" moz-do-not-send=3D"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=3D2 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=C2=A0</p> <p>regards</p> <p>Dinos</p> </div> </div> </blockquote> </div> </blockquote> </body> </html> --------------dxTtxcFXRHr1n2N3GiD96ffs--