[Koha-bugs] [Bug 28489] CGI::Session is incorrectly serialized to DB in production env / when strict_sql_modes = 0

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28489

--- Comment #60 from David Cook <dcook at prosentient.com.au> ---
Dev test plan:

1. vi /etc/apache2/sites-enabled/kohadev.conf
2. Change "SetEnv PERL5LIB "/kohadevbox/koha" to SetEnv PERL5LIB
"/kohadevbox/koha:/kohadevbox/koha/lib"
2b. service apache2 reload
3. cp debian/scripts/koha-functions.sh /usr/share/koha/bin/koha-functions.sh
4. koha-plack --restart kohadev
5. Log into http://localhost:8081/cgi-bin/koha/mainpage.pl
6. Go to CGI script http://localhost:8081/cgi-bin/koha/tools/export.pl 
(Note that this is still run in CGI even when using Plack)

NOTE: We'll need to update koha-gitify
(https://gitlab.com/koha-community/koha-gitify) to get that Apache
configuration. There's no harm in updating it, since this is a backwards
compatible change. See
https://gitlab.com/koha-community/koha-gitify/-/merge_requests/2. 

--

Deploy test plan:

Dev:
1. perl Makefile.PL
1a. Installation mode: dev
1b. Configuration directory: /opt/koha-dev
2. make
3. ls blib/PERL_MODULE_DIR/
4. Note the following: C4  CGI  cpanfile  Koha  Koha.pm
5. make install
5b. Note the output says the following:
In order to use Koha's command-line batch jobs,
you should set the following environment variables:

export KOHA_CONF=/opt/koha-dev/etc/koha-conf.xml
export PERL5LIB=/kohadevbox/koha:/kohadevbox/koha/lib
6. vi /opt/koha-dev/etc/koha-httpd.conf
7. Note the following: SetEnv PERL5LIB "/kohadevbox/koha:/kohadevbox/koha/lib"
6. rm -rf /opt/koha-dev
7. make clean

Single:
1. perl Makefile.PL
1a. Installation mode: single
1b. Please specify the directory in which to install Koha: /opt/koha
2. make
3. ls blib/PERL_MODULE_DIR/
4. Note the following: C4  CGI  cpanfile  Koha  Koha.pm
5. make install
5b. Note the output says the following:
In order to use Koha's command-line batch jobs,
you should set the following environment variables:

export KOHA_CONF=/opt/koha/etc/koha-conf.xml
export PERL5LIB=/opt/koha/lib
6. ls /opt/koha/lib
7. Note the following: C4  CGI  cpanfile  Koha  Koha.pm
8. vi /opt/koha/etc/koha-httpd.conf
9. Note the following: SetEnv PERL5LIB "/opt/koha/lib"
10. rm -rf /opt/koha
11. make clean

Standard:
1. perl Makefile.PL
1a. accept all the defaults
2. make
3. ls blib/PERL_MODULE_DIR/
4. Note the following: C4  CGI  cpanfile  Koha  Koha.pm
5. make install
5b. Note there is a set_koha_ownership failure because of a missing "koha"
user, but that's OK since this is an overly intensive process within
koha-testing-docker anyway, and the install has already succeeded at this
point.
6. ls /usr/share/koha/lib
7. Note the following: C4  CGI  cpanfile  Koha  Koha.pm

-- 
You are receiving this mail because:
You are watching all bug changes.