Debian-LTS has issued an advisory on May 22: https://www.debian.org/lts/security/2023/dla-3431 We fixed these issues in sqlite3 in Bug 18869 and Bug 22792 years ago. Do we still need to be carrying around this old package? Mageia 8 is also affected.
Blocks: (none) => 30163Status comment: (none) => Patches available from DebianWhiteboard: (none) => MGA8TOO
Done for both Cauldron and mga8!
CC: (none) => geiger.david68210
Thanks. What about removing it from Cauldron? It doesn't look like much depends on it, and it doesn't appear to be anything important. Mageia 8 update: libsqlite0-devel-2.8.17-26.1.mga8 libsqlite0-2.8.17-26.1.mga8 sqlite-tools-2.8.17-26.1.mga8 libsqlite0-static-devel-2.8.17-26.1.mga8 from sqlite-2.8.17-26.1.mga8.src.rpm
Status comment: Patches available from Debian => Possibly could be dropped in Cauldron
(In reply to David GEIGER from comment #1) > Done for both Cauldron and mga8! Brilliant. You need to be the assignee, though.
CC: geiger.david68210 => (none)Assignee: bugsquad => geiger.david68210
# urpmq --whatrequires-recursive lib64sqlite0|sort -u gambas3-gb-db-sqlite2 javasqlite lib64sqlite0 lib64sqlite0-devel lib64sqlite0-static-devel libdbi-drivers-dbd-sqlite opendbx-sqlite perl-DBD-SQLite2 sqlite-tools task-gambas3 tilitin So tilitin "Free Finnish bookkeeping software" is the only Mageia application that uses it, but the rest may be needed for third party software and development with gambas3-ide.
CC: (none) => davidwhodgins
The tilitin package hasn't been updated in 9 years, so it's either unmaintained or dead. Gambas also has sqlite3 support, so it could be built without sqlite2 support.
I just installed and tried tilitin in m9 and it appears to work, though I can't read the menus. Once nice thing about book keeping software is that it does not change, unless it includes tax features, which basic book keeping does not. It's up to the person keeping the books to know which accounts to set up for taxes, what accounts to credit/debit for the various transactions, etc.
CC'ing Jani. The software upstream hasn't been updated in 10 years and no other distro other than us appears to have it packaged. Is there other bookkeeping software?
CC: (none) => jani.valimaa
I disabled sqlite support for gambas3, opendbx, libdbi-drivers and javasqlite. Now we have to drop from repo: perl-DBD-SQLite2-0.380.0-7.mga9.src.rpm perl-DBIx-Class-Loader-0.210.0-10.mga9.src.rpm
So nothing depend on sqlite2 anymore!
sqlite now removed, so this bug is fixed for cauldron!
Status comment: Possibly could be dropped in Cauldron => (none)Version: Cauldron => 8Whiteboard: MGA8TOO => (none)
Assigning to QA, Packages in 8/Core/Updates_testing: ====================== libsqlite0-2.8.17-26.1.mga8 libsqlite0-devel-2.8.17-26.1.mga8 libsqlite0-static-devel-2.8.17-26.1.mga8 lib64sqlite0-2.8.17-26.1.mga8 lib64sqlite0-devel-2.8.17-26.1.mga8 sqlite-tools-2.8.17-26.1.mga8 lib64sqlite0-static-devel-2.8.17-26.1.mga8 From SRPMS: sqlite-2.8.17-26.1.mga8.src.rpm
Assignee: geiger.david68210 => qa-bugs
Version: 8 => CauldronBlocks: 30163 => (none)CC: (none) => mageia
Version: Cauldron => 8Component: RPM Packages => SecurityQA Contact: (none) => security
MGA8-64 MATE on Acer Aspire 5253 No installation issues. As in bug 30660, used sqlitestudio to create a new database and create a new table in it with a PK, not null string, other string without rules. Populated a few rows, all worked OK.
CC: (none) => herman.viaeneWhiteboard: (none) => MGA8-64-OK
sqlitestudio uses sqlite3, not sqlite (sqlite2). See Comment 4 for the packages that use this.
Whiteboard: MGA8-64-OK => (none)
@David You might have to apply a request for a miracle in Lourdes (France), since I checked that I don't have anything sqlite3 installed, just the last 4 packages specified in Comment 11. And the comments in MCC on SQLstudio reads: "* All SQLite3 and SQLite2 features wrapped within simple GUI"
It looks like our package is only built with sqlite3 support (and you do have lib64sqlite3_0 installed).
You're right @@#####. It's a selector that cannot be reset and is very light grey on a slighty darker background. Overlooked it completely. Well, you'll have to go on without a miracle..... Continuing the test.
Installed and run tilitin. As my Finnish is non-existing, I checked a few things in Google Translate, entered two records, closed tilitin and opened it again. And the two records were there, so I dare to guess they have been written to the database. In view of Dave's comments, giving the OK.
Whiteboard: (none) => MGA8-64-OK
Validating.
CC: (none) => andrewsfarm, sysadmin-bugsKeywords: (none) => validated_update
Keywords: (none) => advisory
An update for this issue has been pushed to the Mageia Updates repository. https://advisories.mageia.org/MGASA-2023-0208.html
Resolution: (none) => FIXEDStatus: NEW => RESOLVED