Bug 30209

Summary: Upgrade 'libdbd-sqlite2-perl' package to 'libdbd-sqlite3-perl'
Product: Koha Reporter: Mason James <mtj>
Component: PackagingAssignee: Mason James <mtj>
Status: REOPENED --- QA Contact: Testopia <testopia>
Severity: blocker    
Priority: P1 - high CC: arthur.suzuki, fridolin.somers, mtj, tomascohen, victor
Version: MainKeywords: rel_21_11_candidate
Hardware: All   
OS: All   
See Also: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29881
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4269
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'
Bug 30209: Upgrade 'libdbd-sqlite2-perl' package to 'libdbd-sqlite3-perl'
Bug 30209: Upgrade 'libdbd-sqlite2-perl' package to 'libdbd-sqlite3-perl'
Bug 30209: Upgrade 'libdbd-sqlite2-perl' package to 'libdbd-sqlite3-perl'

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)