Re: unicode problem with sqlbox Revision: 62
Konstantinos Liadakis <[email protected]> Thu, 4 Jul 2024 12:42:38 +0300
| Newsgroups | gmane.comp.mobile.kannel.user |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format. --------------O4vxKhG7XXwaLKj9j1BkfuE9 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: quoted-printable Here is the insert query which works perfectly fine on old system but=20 not on the new one INSERT INTO send_sms ( =C2=A0=C2=A0=C2=A0 sql_id, momt, sender, receiver, udhdata, msgdata, tim= e, smsc_id,=20 service, account, id, sms_type, mclass, mwi, coding, compress, validity,=20 deferred, dlr_mask, dlr_url, pid, alt_dcs, rpi, charset, boxc_id, binfo,=20 meta_data, priority, foreign_id ) VALUES ( =C2=A0=C2=A0=C2=A0 1, 'MT', 'UnicKlad', '306931234567', NULL,=20 '%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',=20 NULL, 'MYSMSC', NULL, 'account', NULL, 2, NULL, NULL, 2, NULL, 4320,=20 NULL, 19, 'http://url', NULL, NULL, NULL, 'utf-8', NULL, NULL, NULL,=20 NULL, NULL ); On 4/7/24 12:39, Ruben Melikyan wrote: > Hi Dinos, > Please paste here your sql query which inserts unicode message to=20 > 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=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/m= ysql/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_ty= pe |=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=20 >> and had compiled sqlbox using sources located in original Addons folde= r. >> >> Best regards, >> Ruben Melikyan >> ----------------------------------------------------------------------= -- >> *From:* Konstantinos Liadakis <[email protected]>=20 >> <mailto:[email protected]> >> *Sent:* Thursday, July 4, 2024 2:20:58 AM >> *To:* Ruben Melikyan <[email protected]> <mailto:[email protected]>;=20 >> [email protected] <mailto:[email protected]> <[email protected]>=20 >> <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.=20 >> 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=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 = encoded=20 >>> format. >>> >>> *Best regards,* >>> >>> *Ruben Melikyan* >>> >>> *From:* users <[email protected]>=20 >>> <mailto:[email protected]> *On Behalf Of *Konstantinos Liadaki= s >>> *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 >>> --------------O4vxKhG7XXwaLKj9j1BkfuE9 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>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> =C2=A0=C2=A0=C2=A0 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> =C2=A0=C2=A0=C2=A0 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=3D"moz-txt-link-freetext" href=3D"http://= url">http://url</a>', NULL, NULL, NULL, 'utf-8', NULL, NULL, NULL, NULL, NULL<br> );<br> </p> <div class=3D"moz-cite-prefix">On 4/7/24 12:39, 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">Please paste here your sql query which inserts unicode message to SendTable.=C2=A0</div> <div dir=3D"ltr"><br> </div> <div dir=3D"ltr">Please provide full query</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 11:44:39 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>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= /share/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 | Val= ue=C2=A0=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= |<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> +--------+------+----------+--------------+---------+--------------------= -------------------------------------------------------------------------= -------------------+------------+--------------+---------+------------+--= ----+----------+--------+------+--------+----------+----------+----------= +----------+-------------------------------------------------------------= -------------------------------------------------------------------------= ------------------+------+---------+------+---------+---------+-------+--= ----------------------------------------------+----------+------------+<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 | deferred | 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"x_moz-cite-prefix">On 4/7/24 07:24, Ruben Melikyan wrote:<br> </div> <blockquote type=3D"cite"> <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 you send ASCII( not unicode message), what happens? Do you see record in your table?</span></l= i> <li style=3D"list-style-type:"2. ""><span>Wha= t are your DB settings ?<span></span></span></li> <li style=3D"list-style-type:"3. ""><span>How do you send message? Please provide=C2=A0 detailed description 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 you= r 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"x_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 tabindex=3D"-1" style=3D"display:inline-block; width:98%"> <div id=3D"x_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"x_moz-txt-link-rfc2396E" href=3D"mailto:[email protected]" moz-do-not-send=3D"true"><[email protected]></a>= <br> <b>Sent:</b> Thursday, July 4, 2024 2:20:58 AM<br> <b>To:</b> Ruben Melikyan <a class=3D"x_moz-txt-link-rfc2396E" href=3D"mailto:[email protected]" moz-do-not-send=3D"true"> <[email protected]></a>; <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> <a class=3D"x_moz-txt-link-rfc2396E" href=3D"mailto:[email protected]" moz-do-not-send=3D"true"= > <[email protected]></a><br> <b>Subject:</b> Re: unicode problem with sqlbox Revision: 62</font> <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_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_x_MsoNormal, li.x_x_MsoNormal, div.x_x_MsoNorma= l {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=3D"x_x_WordSection1"> <p class=3D"x_x_MsoNormal"><a name=3D"x_x__Hlk120024655" moz-do-not-send=3D"true"><span lang=3D"EN-GB">Hi,</sp= an></a></p> <p class=3D"x_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_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_x_MsoNormal"><span style=3D""><span lang=3D"EN-GB">=C2=A0</span></span></p> <p class=3D"x_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_x_MsoNormal"><span style=3D""><span lang=3D"EN-GB">=C2=A0</span></span></p> <p class=3D"x_x_MsoNormal"><span style=3D""><span lang=3D"EN-GB">Referring to sqlbox documentation:</= span></span></p> <p class=3D"x_x_MsoNormal" style=3D"background:white"><sp= an style=3D""><a name=3D"x_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= ><span style=3D"font-size:13.5pt; font-family:"Times New Roman",serif;= color:black"></span></b></span></p> <p class=3D"x_x_MsoNormal" style=3D"background:white"><sp= an 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_x_MsoNormal"><span style=3D""><span lang=3D"EN-GB">=C2=A0</span></span></p> <p class=3D"x_x_MsoNormal"><span style=3D""><span lang=3D"EN-GB">P.S. Kannel=E2=80=99s sqlbox saving = SMS message incliding unicode in encoded format.</span>= </span></p> <span style=3D""></span> <div> <p class=3D"x_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_x_MsoNormal"><span lang=3D"EN-GB">=C2=A0</s= pan></p> <div> <div style=3D"border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0in 0= in 0in"> <p class=3D"x_x_MsoNormal"><b>From:</b> users <a class=3D"x_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_x_moz-txt-link-abbreviated x_moz-txt-link-freetext moz-txt-lin= k-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_x_MsoNormal">=C2=A0</p> <p class=3D"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=3D"https://svn.kannel.org/sqlbox/trunk" class=3D"x_x_moz-txt-link-freetext x_moz-txt-link-freetext moz-txt-link-f= reetext" 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_x_moz-txt-link-freetext x_moz-txt-link-freetext moz-txt-link-f= reetext" 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_x_moz-txt-link-freetext x_moz-txt-link-freetext moz-txt-link-f= reetext" 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_x_moz-txt-link-freetext x_moz-txt-link-freetext moz-txt-link-f= reetext" 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> </div> </blockquote> </body> </html> --------------O4vxKhG7XXwaLKj9j1BkfuE9--