[tech] Koha is Down

[Blair Johnson]

Something important to remember is that UniSFA has a UCC account that could
be used to manage the VM, however I don't think the account is currently
active, based on what Alfred told me when I was in last week. That's
definitely something that should be looked into.

Like I said, backups should be generated automatically, however I think
previously when we've attempted a roll-back there's been issues with files
that don't get removed that need to be removed. It's doable, but not
straight forward so I need to have another look at that so we have a
workflow in place.

As for what to try next: if you can access the database then I recommend
trying to clear up the errors that have shown up. I think they're the
result of a version change but I'm not entirely sure. Start with the
database, and if that goes nowhere then start looking at the Koha server/VM.

Cheers,

Blair


On Wed, 24 Oct. 2018, 6:48 pm Nick Bannon, <nick at ucc.gu.uwa.edu.au> wrote:

> On Sat, Oct 20, 2018 at 03:30:34PM +0800, Blair Johnson wrote:
> > Hi Nick, thanks for taking an interest.
> >
> > Having a look at the SQL database showed a few errors which might be
> > related to a version change - I'm not entirely sure what they mean. Is
> > wheel able to access the Koha database? If not then if I can find some
> time
> > I'll see about getting you logged in to have a look.
>
> Hi all! (I guess you're away currently, Blair?)
>
> Yes, UCC wheel can access the database/VM and start to find our way
> around - what shall we try next?
>
> mussel: ~/as>echo 'select count(*) from borrowers;'|mariadb
> --user=kohaadmin -p koha
> Enter password:
> count(*)
> 418
>
> > The same goes for the unisfa-koha VM. I think bob has a login as he
> helped
> > to set up the VM, otherwise it's just me.
>
> Bob, James, myself, (wheel) can log in and help, but it's UniSFA's
> machine to run, get comfortable with backups of, etc.
>
> Critically, I think Katherine needs a login and perhaps also some
> up-and-coming assistant librarian potentials. (they should use really
> good passwords https://xkcd.com/936/ so we don't add new problems. :) )
>
> > On Sat, 20 Oct. 2018, 3:05 pm Nick Bannon, <nick at ucc.gu.uwa.edu.au>
> wrote:
> > > On Sat, Oct 20, 2018 at 12:09:44PM +0800, Katherine Scott wrote:
> > > Hi, Katherine! Not sure if you've seen my previous message, maybe it's
> > > the unisfa-committee config? I've quoted it below.
>
> Could someone check if the previous message(s) were approved? or are
> they still waiting to go through?
>
> Katherine: Can you log into UCC machines like mussel or
> motsugo/ssh.ucc.asn.au ? with SSH?
>
> > > Otherwise, I can visit UWA, or I'll probably be there anyway on Monday
> > > or Tuesday.
> > > Nick.
>
> I did indeed visit UWA, but my timing may not have lined up well -
> Monday was during a screening, and Tuesday I was busy with some UCC
> stuff and when I came back to UniSFA it was shut. When might be good?
>
> Nick.
>
> --
>    Nick Bannon   | "I made this letter longer than usual because
> nick-sig at rcpt.to | I lack the time to make it shorter." - Pascal
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://lists.ucc.gu.uwa.edu.au/pipermail/tech/attachments/20181024/6bd6e97b/attachment.htm