[tech] Koha is Down

[Nick Bannon]

On Mon, Nov 05, 2018 at 03:40:19PM +0800, Finley Hoskins wrote in
oh-so-close to https://en.wikipedia.org/wiki/ISO_8601 :
> I'll post in the CCC group for anyone who is interested in
> learning how to [run Koha]
> If you would like to be on committee or CCC next year, please get in touch
On Mon, Nov 12, 2018 at 03:38:26PM +0800, Finley Hoskins wrote:
> Librarian/Library
> When will Koha come back from the war?
> Koha is still down so Katherine can't really do anything
> about that

Thank you for the prompt minutes, Fin!

Sadly, yes, Koha's still down, it's been too long and we ought to to
focus on getting it back again; but recording what it takes with an eye
to a training session soon.

I stopped by during some book sorting the previous weekend and spoke to
Simon and Katherine.

We reset the "unisfa" account on UCC machines; the password is in the
UniSFA committee's store. There is also a separate "unisfa" account
created on the VM unisfa-koha.ucc.asn.au , same password.

We can browse the Koha backend database, and replicate the
"error: 1932: Table 'koha.sessions' doesn't exist" message:
	https://secure.ucc.asn.au/phpmyadmin/

TODO: Clear or reset the sessions?
(Very roughly - tried?) Compare the following, what has recent changes/data in it:
  * koha->koha
  * koha->koha_broken_20180505
  * koha->koha_testing

-rw------- 1 nick wheel 32809839 Nov 12 22:11 koha.sql
	* Contains a number of 2018 dates
-rw------- 1 nick wheel 34019379 Nov 12 22:11 koha_broken_20180505.sql
	* Contains fewer 2018 dates
-rw------- 1 nick wheel 40085188 Nov 12 22:11 koha_testing.sql
	* Contains no 2018 dates

Blair, anyone:
When's good to have another go at backup/restores, and then plan for
showing it to a larger group?
(Personally, evenings this week are not so good for me: Tue/Wed/Thu.
Friday could work, or daytimes, or the weekend)

While it was handy, I did an iperf/speed test on deepthought's 100Mbps
ethernet, via its router, sharpchin. (a MikroTik RB951G-2HnD)
65MBps my laptop to murasoi(uccrouter)
32Mbps murasoi(uccrouter) to my laptop

Nick.
0419 957 011

-- 
   Nick Bannon   | "I made this letter longer than usual because
nick-sig at rcpt.to | I lack the time to make it shorter." - Pascal