Bug 45768 – (4.1/7.8.2) OX listener must decode strings to unicode for sqlite

Bug 45768 - (4.1/7.8.2) OX listener must decode strings to unicode for sqlite


Summary:	(4.1/7.8.2) OX listener must decode strings to unicode for sqlite

Status:	CLOSED WONTFIX

Product:	Z_Internal OX development
Classification:	Unclassified
Component:	Listener
Version:	UCS 4.1 / 7.8.2
Hardware:	Other Linux

Importance:	P5 normal (vote)
Target Milestone:	7.8.2-4-ucs10
Assigned To:	Daniel Tröder
QA Contact:	Sönke Schwardt-Krummrich

URL:
Keywords:

Depends on:	45769
Blocks:
	Show dependency tree / graph

Reported:	2017-11-23 15:03 CET by Daniel Tröder
Modified:	2018-04-12 10:24 CEST (History)
CC List:	2 users (show)

See Also:	45769
What kind of report is it?:	Bug Report
What type of bug is this?:	6: Setup Problem: Issue for the setup process
Who will be affected by this bug?:	2: Will only affect a few installed domains
How will those affected feel about the bug?:	5: Blocking further progress on the daily work
User Pain:	0.343
Enterprise Customer affected?:
School Customer affected?:	Yes
ISV affected?:
Waiting Support:
Flags outvoted (downgraded) after PO Review:
Ticket number:
Bug group (optional):
Max CVSS v3 score:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description Daniel Tröder

2017-11-23 15:03:06 CET

There will be otherwise:

sqlite3.ProgrammingError: You must not use 8-bit bytestrings unless you use a text_factory that can interpret 8-bit bytestrings (like text_factory = str). It is highly recommended that you instead just switch your application to Unicode strings.

Comment 1 Daniel Tröder

2017-11-29 13:32:00 CET

Git commits were cherry-picked from 4.2 branch:

commit 39f7a4112b84a4afdb6baba928d40c308cb1a061
    Bug #45769: decode strings to unicode for sqlite
        (cherry picked from commit fff0b34)

univention-ox (8.1.4-1)

Comment 2 Daniel Tröder

2017-12-04 12:51:42 CET

A bug was fixed and backported from 4.2:

commit 79c6dbf97032cb1e7b5f875894d3501b5b829b8d
    Bug #45768: list comprehension empties list
    (cherry picked from commit 86f1628)

commit cdb44abfc088cc1259e5b9bd6cb5a05c74cba742
    Bug #45768: don't use unicode for SQL command, only for arguments
    (cherry picked from commit 51d8185)

commit 759cdad5d5bf21b5ed53b5413aa193d41402e488
    Bug #45768: enhance mypy annotations
    (cherry picked from commit 6c0c14f)

commit 48aa23c3f3d4d39560102d1383f377c3bea456a6
    Bug #45768: changelog

commit 66585db4ecb476af53c1f3c03b91c86e6c683590
    Bug #45768: advisory update

univention-ox (8.1.4-2)

Comment 3 Sönke Schwardt-Krummrich

2018-04-12 10:23:05 CEST

→ NO QA → RESOLVED → CLOSED

This issue has been filed against UCS 4.1.

UCS 4.1 and OX 7.8.2 is out of maintenance and many UCS and OX components have
vastly changed in later releases. Thus, this issue is now being closed.

If this issue still occurs in newer UCS/OX versions, please use "Clone this bug"
or reopen this issue. In this case please provide detailed information on how
this issue is affecting you.