Bug 30209 - Upgrade 'libdbd-sqlite2-perl' package to 'libdbd-sqlite3-perl'
Summary: Upgrade 'libdbd-sqlite2-perl' package to 'libdbd-sqlite3-perl'
Status: REOPENED
Alias: None
Product: Koha
Classification: Unclassified
Component: Packaging (show other bugs)
Version: Main
Hardware: All All
: P1 - high blocker
Assignee: Mason James
QA Contact: Testopia
URL:
Keywords: rel_21_11_candidate
Depends on:
Blocks:
 
Reported: 2022-03-02 01:59 UTC by Mason James
Modified: 2022-08-31 07:41 UTC (History)
5 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
22.05.00, 21.05.19
Circulation function:


Attachments
Bug 30209: Upgrade 'libdbd-sqlite2-perl' package to 'libdbd-sqlite3-perl' (1.81 KB, patch)
2022-03-02 02:19 UTC, Mason James
Details | Diff | Splinter Review
Bug 30209: Upgrade 'libdbd-sqlite2-perl' package to 'libdbd-sqlite3-perl' (1.81 KB, patch)
2022-03-02 02:20 UTC, Mason James
Details | Diff | Splinter Review
Bug 30209: Upgrade 'libdbd-sqlite2-perl' package to 'libdbd-sqlite3-perl' (1.86 KB, patch)
2022-03-07 12:34 UTC, Mason James
Details | Diff | Splinter Review
Bug 30209: Upgrade 'libdbd-sqlite2-perl' package to 'libdbd-sqlite3-perl' (1.93 KB, patch)
2022-03-08 13:18 UTC, Mason James
Details | Diff | Splinter Review

Note You need to log in before you can comment on or make changes to this bug.
Description Mason James 2022-03-02 01:59:45 UTC
the DBD::SQLite2 package has been removed in debian-testing, therefor we should upgrade to DBD::SQLite3 package

only one script uses DBD::SQLite2 (misc/cronjobs/create_koc_db.pl), see BZ-4269 

'create_koc_db.pl' can use both sqlite2 and sqlite3, so we can upgrade this package without a problem
Comment 1 Mason James 2022-03-02 02:19:14 UTC
Created attachment 131217 [details] [review]
Bug 30209: Upgrade 'libdbd-sqlite2-perl' package to 'libdbd-sqlite3-perl'

to test...

- apply patch, build and install new package

- build and install new package

- check that libdbd-sqlite3-perl package is installed

    note: libdbd-sqlite3-perl package installs DBD::SQLite module, which uses sqlite3 :)

        https://packages.debian.org/stretch/libdbd-sqlite3-perl
        https://metacpan.org/pod/DBD::SQLite
Comment 2 Mason James 2022-03-02 02:20:40 UTC
Created attachment 131218 [details] [review]
Bug 30209: Upgrade 'libdbd-sqlite2-perl' package to 'libdbd-sqlite3-perl'

to test...

- apply patch, build and install new package

- build and install new package

- check that libdbd-sqlite3-perl package is installed

    note: libdbd-sqlite3-perl package installs DBD::SQLite module, which uses sqlite3 :)

        https://packages.debian.org/stretch/libdbd-sqlite3-perl
        https://metacpan.org/pod/DBD::SQLite
Comment 4 Mason James 2022-03-07 12:34:54 UTC
Created attachment 131432 [details] [review]
Bug 30209: Upgrade 'libdbd-sqlite2-perl' package to 'libdbd-sqlite3-perl'

to test...

- apply patch, build and install new package

- build and install new package

- check that libdbd-sqlite3-perl package is installed

    note: libdbd-sqlite3-perl package installs DBD::SQLite module, which uses sqlite3 :)

        https://packages.debian.org/stretch/libdbd-sqlite3-perl
        https://metacpan.org/pod/DBD::SQLite

Signed-off-by: Mason James <mtj@kohaaloha.com>
Comment 5 Mason James 2022-03-08 13:09:11 UTC
hi Frido
can you apply this patch to pass the master tests on jenkins

https://jenkins.koha-community.org/view/master/job/Koha_Master_D10/548/
Comment 6 Mason James 2022-03-08 13:18:27 UTC
Created attachment 131457 [details] [review]
Bug 30209: Upgrade 'libdbd-sqlite2-perl' package to 'libdbd-sqlite3-perl'

to test...

1/ apply patch, build and install new package

2/ check that libdbd-sqlite3-perl package is installed

     $ dpkg -l | grep libdbd-sqlite
     ii  libdbd-sqlite3-perl:amd64              1.62-3          amd64

    note: libdbd-sqlite3-perl package installs DBD::SQLite module, which uses sqlite3 :)

        https://packages.debian.org/stretch/libdbd-sqlite3-perl
        https://metacpan.org/pod/DBD::SQLite

Signed-off-by: Mason James <mtj@kohaaloha.com>
Comment 7 Mason James 2022-03-09 09:41:46 UTC
(In reply to Mason James from comment #5)
> hi Frido
> can you apply this patch to pass the master tests on jenkins
> 
> https://jenkins.koha-community.org/view/master/job/Koha_Master_D10/548/

lets not apply this to 21.11 and lower, for now
Comment 8 Fridolin Somers 2022-03-10 04:36:53 UTC
Pushed to master for 22.05, thanks to everybody involved ﷐[U+1F984]﷑
Comment 9 Mason James 2022-08-29 16:04:34 UTC
(In reply to Mason James from comment #7)
> (In reply to Mason James from comment #5)
> > hi Frido
> > can you apply this patch to pass the master tests on jenkins
> > 
> > https://jenkins.koha-community.org/view/master/job/Koha_Master_D10/548/
> 
> lets not apply this to 21.11 and lower, for now

hi tuxayo, any chance we can get this patch added to 21.05?
Comment 10 Mason James 2022-08-29 16:07:22 UTC
(In reply to Mason James from comment #7)
> (In reply to Mason James from comment #5)
> > hi Frido
> > can you apply this patch to pass the master tests on jenkins
> > 
> > https://jenkins.koha-community.org/view/master/job/Koha_Master_D10/548/
> 
> lets not apply this to 21.11 and lower, for now

hi tuxayo, any chance we can get this patch added to 21.05?
Comment 11 Victor Grousset/tuxayo 2022-08-29 21:30:11 UTC
Backported: Pushed to 21.05.x branch for 21.05.19
Comment 12 Victor Grousset/tuxayo 2022-08-29 21:30:57 UTC
(In reply to Mason James from comment #10)
> hi tuxayo, any chance we can get this patch added to 21.05?

What about 21.11?
Comment 13 Mason James 2022-08-31 07:40:30 UTC
(In reply to Victor Grousset/tuxayo from comment #12)
> (In reply to Mason James from comment #10)
> > hi tuxayo, any chance we can get this patch added to 21.05?
> 
> What about 21.11?

ok, lets do 21.11 too :0)