To be clear there are still a part 2 and 3 and 4. It's not finished yet :) Chris On Tue, 3 Jan 2023 at 12:20, Chris Cormack <chris@bigballofwax.co.nz> wrote:

Part one is done, the harder part, switching it from i386 to amd64, so hopefully now the rest is smooth sailing

Chris

On Tue, 3 Jan 2023 at 11:53, Chris Cormack <chris@bigballofwax.co.nz> wrote:

...

Hi All

The linode that bugs, dashboard, splitter, download, plus the bots run on needs an OS upgrade.

I am about to snapshot it and attempt that now. The server may or may not go down for various parts of the upgrade. I will let you know when it has been completed of I have to rollback.

Chris

Hi again all Everything should be back now, please let me know if you spot anything off. For those that are interested, I resized the server, changed it from i386 to amd64 and upgraded from Ubuntu 18.04 to 20.04. (18.04 goes out of support in April). It should be slightly faster with more ram available. Happy new OS for new year :) Chris On Tue, 3 Jan 2023 at 12:55, Tomas Cohen Arazi <tomascohen@gmail.com> wrote:

Thanks for letting us know! Good luck!

El lun, 2 ene 2023 19:54, Chris Cormack <chris@bigballofwax.co.nz> escribió:

...

Hi All

The linode that bugs, dashboard, splitter, download, plus the bots run on needs an OS upgrade.

I am about to snapshot it and attempt that now. The server may or may not go down for various parts of the upgrade. I will let you know when it has been completed of I have to rollback.

Chris _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : https://www.koha-community.org/ git : https://git.koha-community.org/ bugs : https://bugs.koha-community.org/

Hi Chris. Thanks for all your work in supporting and maintaining these! I get this message when trying to access the IRC logs at http://irc.koha-community.org/koha/today Software error: Can't locate Date/Simple.pm in @INC (you may need to install the Date::Simple module) (@INC contains: /home/chrisc/ilbot/lib/ /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.30.0 /usr/local/share/perl/5.30.0 /usr/lib/x86_64-linux-gnu/perl5/5.30 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.30 /usr/share/perl/5.30 /usr/local/lib/site_perl /usr/lib/x86_64-linux-gnu/perl-base) at /home/chrisc/ilbot/cgi/out.pl line 6. BEGIN failed--compilation aborted at /home/chrisc/ilbot/cgi/out.pl line 6. For help, please send mail to the webmaster (chris@bigballofwax.co.nz), giving this error message and the time and date of the error. There are also server errors when accessing some of the links from http://irc.koha-community.org/ David

The DB hasnt changed at all, mysql versions have. So they will have to be fixed manually. There are some table names that are now reserved words in mysql so need to be back ticked. Please send the errors to me so I can fix. Bugzilla isn't really being actively maintained anymore so I will have to fix these. There is no version to upgrade to. Chris On 4 January 2023 6:44:23 am NZDT, Tomas Cohen Arazi <tomascohen@gmail.com> wrote:

I've seen some errors on saved reports. But it looks like DB structure changes won't be easy to fix manually.

El mar, 3 ene 2023 a las 14:43, David Nind (<david@davidnind.com>) escribió:

...

Hi Chris.

Thanks for all your work in supporting and maintaining these!

I get this message when trying to access the IRC logs at http://irc.koha-community.org/koha/today Software error:

Can't locate Date/Simple.pm in @INC (you may need to install the Date::Simple module) (@INC contains: /home/chrisc/ilbot/lib/ /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.30.0 /usr/local/share/perl/5.30.0 /usr/lib/x86_64-linux-gnu/perl5/5.30 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.30 /usr/share/perl/5.30 /usr/local/lib/site_perl /usr/lib/x86_64-linux-gnu/perl-base) at /home/chrisc/ilbot/cgi/out.pl line 6. BEGIN failed--compilation aborted at /home/chrisc/ilbot/cgi/out.pl line 6.

For help, please send mail to the webmaster (chris@bigballofwax.co.nz), giving this error message and the time and date of the error.

There are also server errors when accessing some of the links from http://irc.koha-community.org/

David

_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : https://www.koha-community.org/ git : https://git.koha-community.org/ bugs : https://bugs.koha-community.org/

-- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F

Yeah the first way is pretty much how I fixed it. I don't really like it though I think changing the table name is a better idea. So hopefully that will be the long term fix. Good news about the release, we are on 5.0.6 plus koha customisations, I'll merge 5.2 in when it's released and we will go to that. Chris On 4 January 2023 11:41:28 am NZDT, David Cook <dcook@prosentient.com.au> wrote:

It looks like they might have a new version coming out in a few weeks: https://www.bugzilla.org/blog/2022/12/13/upcoming-releases-and-more-fun-stuf...

Looks like someone has a PR for the MySQL/MariaDB issue: https://github.com/bugzilla/bugzilla/pull/107/files

Also looks like Mozilla have gone a different route with their Bugzilla fork:

https://github.com/mozilla-bteam/bmo/commit/5dc1b8c85c4e90c3467fd82cab9fca05...

David Cook

Senior Software Engineer

Prosentient Systems

Suite 7.03

6a Glen St

Milsons Point NSW 2061

Australia

Office: 02 9212 0899

Online: 02 8005 0595

From: Koha-devel <koha-devel-bounces@lists.koha-community.org> On Behalf Of Chris Cormack Sent: Wednesday, 4 January 2023 4:54 AM To: koha-devel@lists.koha-community.org; Tomas Cohen Arazi <tomascohen@gmail.com>; David Nind <david@davidnind.com> Cc: Koha-devel <koha-devel@lists.koha-community.org>; koha-user <koha@lists.katipo.co.nz> Subject: Re: [Koha-devel] Upgrading bugs.koha-community.org (plus others)

The DB hasnt changed at all, mysql versions have. So they will have to be fixed manually. There are some table names that are now reserved words in mysql so need to be back ticked. Please send the errors to me so I can fix.

Bugzilla isn't really being actively maintained anymore so I will have to fix these. There is no version to upgrade to.

Chris

On 4 January 2023 6:44:23 am NZDT, Tomas Cohen Arazi <tomascohen@gmail.com <mailto:tomascohen@gmail.com> > wrote:

I've seen some errors on saved reports. But it looks like DB structure changes won't be easy to fix manually.

El mar, 3 ene 2023 a las 14:43, David Nind (<david@davidnind.com <mailto:david@davidnind.com> >) escribió:

Hi Chris.

Thanks for all your work in supporting and maintaining these!

I get this message when trying to access the IRC logs at http://irc.koha-community.org/koha/today

Software error:

Can't locate Date/Simple.pm in @INC (you may need to install the Date::Simple module) (@INC contains: /home/chrisc/ilbot/lib/ /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.30.0 /usr/local/share/perl/5.30.0 /usr/lib/x86_64-linux-gnu/perl5/5.30 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.30 /usr/share/perl/5.30 /usr/local/lib/site_perl /usr/lib/x86_64-linux-gnu/perl-base) at /home/chrisc/ilbot/cgi/out.pl <http://out.pl> line 6. BEGIN failed--compilation aborted at /home/chrisc/ilbot/cgi/out.pl <http://out.pl> line 6.

For help, please send mail to the webmaster (chris@bigballofwax.co.nz <mailto:chris@bigballofwax.co.nz> ), giving this error message and the time and date of the error.

There are also server errors when accessing some of the links from http://irc.koha-community.org/

David

_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org <mailto:Koha-devel@lists.koha-community.org> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : https://www.koha-community.org/ git : https://git.koha-community.org/ bugs : https://bugs.koha-community.org/

Hi David That should be sorted now thanks for the heads up Chris On 6/01/23 01:26, David Nind wrote:

Hi Chris.

I'm not sure whether this is related to the upgrades, but the IRC log is no longer being updated.

David Nind

-- Kaihuawaere Matihiko (he/him) Catalyst IT Kāi Tahu, Kāti Māmoe, Waitaha 027 4500789 chrisc@catalyst.net.nz

Hi Chris. It looks like the IRC logging has stopped logging again. David Nind

Hi Chris. Looks like the IRC server it is misbehaving, and has kicked the bot off again! 8-( David Nind

Hi David This should be fixed now, please do let me know if you spot anything else. I might try to shift that site to https too over the break. Chris On 4/01/23 06:42, David Nind wrote:

Hi Chris.

Thanks for all your work in supporting and maintaining these!

I get this message when trying to access the IRC logs at http://irc.koha-community.org/koha/today <http://irc.koha-community.org/koha/today>

Software error:

Can't locate Date/Simple.pm in @INC (you may need to install the Date::Simple module) (@INC contains: /home/chrisc/ilbot/lib/ /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.30.0 /usr/local/share/perl/5.30.0 /usr/lib/x86_64-linux-gnu/perl5/5.30 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.30 /usr/share/perl/5.30 /usr/local/lib/site_perl /usr/lib/x86_64-linux-gnu/perl-base) at /home/chrisc/ilbot/cgi/out.pl <http://out.pl> line 6. BEGIN failed--compilation aborted at /home/chrisc/ilbot/cgi/out.pl <http://out.pl> line 6.

For help, please send mail to the webmaster (chris@bigballofwax.co.nz <mailto:chris@bigballofwax.co.nz>), giving this error message and the time and date of the error.

There are also server errors when accessing some of the links from http://irc.koha-community.org/ <http://irc.koha-community.org/>

David

_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : https://www.koha-community.org/ git : https://git.koha-community.org/ bugs : https://bugs.koha-community.org/

-- Kaihuawaere Matihiko (he/him) Catalyst IT Kāi Tahu, Kāti Māmoe, Waitaha 027 4500789 chrisc@catalyst.net.nz