| Summary: | gnokii-smsd-mysql: incoming SMS with non-ascii chars are wrong in MySQL database | ||||||
|---|---|---|---|---|---|---|---|
| Product: | [Fedora] Fedora | Reporter: | Patrick Monnerat <patrick> | ||||
| Component: | gnokii | Assignee: | Linus Walleij <triad> | ||||
| Status: | CLOSED WONTFIX | QA Contact: | Fedora Extras Quality Assurance <extras-qa> | ||||
| Severity: | medium | Docs Contact: | |||||
| Priority: | unspecified | ||||||
| Version: | 14 | CC: | bnocera, redhat-bugzilla, triad | ||||
| Target Milestone: | --- | ||||||
| Target Release: | --- | ||||||
| Hardware: | Unspecified | ||||||
| OS: | Unspecified | ||||||
| Whiteboard: | |||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||
| Doc Text: | Story Points: | --- | |||||
| Clone Of: | Environment: | ||||||
| Last Closed: | 2012-08-16 16:33:23 UTC | Type: | --- | ||||
| Regression: | --- | Mount Type: | --- | ||||
| Documentation: | --- | CRM: | |||||
| Verified Versions: | Category: | --- | |||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||
| Attachments: |
|
||||||
Ping ! Since this report proposes a patch, a fix or at least an acknowledgement would have been welcome... I'm not the package maintainer, but I think, this issue has been solved also upstream with gnokii-0.6.31 when reading the code. This message is a notice that Fedora 14 is now at end of life. Fedora has stopped maintaining and issuing updates for Fedora 14. It is Fedora's policy to close all bug reports from releases that are no longer maintained. At this time, all open bugs with a Fedora 'version' of '14' have been closed as WONTFIX. (Please note: Our normal process is to give advanced warning of this occurring, but we forgot to do that. A thousand apologies.) Package Maintainer: If you wish for this bug to remain open because you plan to fix it in a currently maintained version, feel free to reopen this bug and simply change the 'version' to a later Fedora version. Bug Reporter: Thank you for reporting this issue and we are sorry that we were unable to fix it before Fedora 14 reached end of life. If you would still like to see this bug fixed and are able to reproduce it against a later version of Fedora, you are encouraged to click on "Clone This Bug" (top right of this page) and open it against that version of Fedora. Although we aim to fix as many bugs as possible during every release's lifetime, sometimes those efforts are overtaken by events. Often a more recent Fedora release includes newer upstream software that fixes bugs or makes them obsolete. The process we are following is described here: http://fedoraproject.org/wiki/BugZappers/HouseKeeping |
Created attachment 510479 [details] Patch as described in the comment Description of problem: When an incoming SMS contains non-ascii characters, the stored version in the MySQL Inbox table shows garbage instead of these characters. Version-Release number of selected component (if applicable): 0.6.28-1 How reproducible: Always Steps to Reproduce: 1. Setup an SMS gateway with inbound SMS written to a mysql database. 2. Make sure /etc/my.cnf contains "default-character-set=utf8" in the [client] group. 3. From a mobile phone (i.e.), send an SMS with accentuated characters to your gateway 4. Examine the corresponding message in the Inbox table. Actual results: UTF8 2-byte characters are understood as if they were "latin1": thus they are stored on 4-bytes in the database. Expected results: Proper UTF8-only handling, and correct UTF8 encoding in the DB. Additional info: This is a "mysql client default character set" problem: although my /etc/my.cnf contains "default-character-set=utf8" in the [client] group, this file is not read by default. The attached patch fixes this problem by forcing the read of the [client] option group in the default mysql option file (/etc/my.cnf). In addition, it also fixes an FTBFS problem (yet undetected by the Fedora build system).