[Koha] Migrating from one server to another

Thu Jul 14 07:25:02 NZST 2022

Breadcrumb/defect remark for future people looking at this:

The username was "koha_[instance name]"; in my case, it was "koha_library".

The password was given by running "koha_passwd [instance name]" at the command line.

Somewhere along the way I was told that the information I wanted was a username/password pair in the koha-conf.xml. That is erroneous, and it is a defect that the user is directed there instead of specifying a username of "koha_[instance name]" and a password obtainable by running "koha_passwd [instance name]".

Br. C.S. Hayward, https://c-s-hayward.com.

------- Original Message -------
On Wednesday, July 13th, 2022 at 11:15 AM, C.S. Hayward <c.s.hayward at protonmail.com> wrote:

> It gives the staff admin interface.
>
> I have an immediate difficulty moving ahead. It is requesting a username and password. There is one username and password pair in koha-conf.xml; it's not accepted. I also tried usernames I had from the old website and they are likewise not accepted.
>
> How can I dig up or reset the setup administrative username and password, given that the library name is simply 'library'?
>
>
> Thanks,
>
> Br. C.S. Hayward, https://c-s-hayward.com
>
> ------- Original Message -------
> On Wednesday, July 6th, 2022 at 12:06 PM, Tim McMahon tmcmahon at wlpl.org wrote:
>
>
>
> > What happens when you access your staff interface?
> >
> > On 7/6/22 10:37 AM, C.S. Hayward wrote:
> >
> > > From the console:
> > >
> > > root at library:~# koha-worker --status library
> > > * worker running for library (default) [ OK ]
> > > root at library:~# koha-enable library
> > > Instance library already enabled.
> > > root at library:~# koha-worker -start library
> > > Error: invalid option switch (-start)
> > > root at library:~# koha-worker --start library
> > > * Error: worker already running for library (default) [fail]
> > >
> > > Attempting to accesshttps://library.cjshayward.com still redirects tohttps://library.cjshayward.com/cgi-bin/koha/maintenance.pl.
> > >
> > > Advice?
> > >
> > > Thanks,
> > >
> > > Br. C.S. Hayward,https://c-s-hayward.com
> > >
> > > ------- Original Message -------
> > > On Wednesday, July 6th, 2022 at 8:08 AM, Lennon Mazondelennon at kohasupport.com wrote:
> > >
> > > > Hi,
> > > >
> > > > An internal server error (500) could mean your Koha instance is either not enabled or is not running (run "koha-worker --status") in which case enable it by running "koha-enable instancename" and "koha-worker --start instancename".
> > > >
> > > > NB: I just checked your admin and OPAC domains and it seems like your instance is up and running. You need to complete the web installer setup and you should be good to go.
> > > >
> > > > Best regards,
> > > >
> > > > Lennon
> > > >
> > > > lennon at kohasupport.com
> > > >
> > > > kohasupport.com
> > > >
> > > > > -----Original message-----
> > > > > From: C.S. Hayward
> > > > > Sent: Tuesday, July 5 2022, 8:02 pm
> > > > > To: Lennon Mazonde
> > > > > Cc: koha
> > > > > Subject: Re: [Koha] Migrating from one server to another
> > > > >
> > > > > Thank you.
> > > > >
> > > > > I had earlier followed the instructions athttp://kohageek.pbworks.com/w/page/60452540/How to move your koha database to newly installed Koha and got an unbranded internal server error athttps://library.cjshayward.com and a Koha branded internal server error athttps://library-intra.cjshayward.com.
> > > > >
> > > > > Since then (this may have been the equivalent of asking for my tea with cream and lemon) I ran the script you mentioned andhttps://library.cjshayward.com redirects tohttps://library.cjshayward.com/cgi-bin/koha/maintenance.pl.
> > > > >
> > > > > A few questions:
> > > > >
> > > > > 1: Have I messed up the system by trying to migrate both ways?
> > > > >
> > > > > 2: Would it likely be less energy to fix the system I have or start over? Would it make sense to do an aptitude purge for koha and then reinstall, or should I be trying a less surgical approach.
> > > > >
> > > > > 3: How can I get useful diagnostics? When I got the earlier 500 error, /var/log/apache2/error.log wasn't getting anything on additional attempted page load.
> > > > >
> > > > > I now have on the system the koha.sql created athttp://kohageek.pbworks.com/w/page/60452540/How to move your koha database to newly installed Koha.
> > > > >
> > > > > Thanks,
> > > > >
> > > > > Br. C.S. Hayward,https://c-s-hayward.com
> > > > >
> > > > > ------- Original Message -------
> > > > > On Monday, July 4th, 2022 at 6:14 AM, Lennon Mazondelennon at kohasupport.com wrote:
> > > > >
> > > > > > Forgot to add the link to the GitHub repo, here it is -https://github.com/grandmaestr/koha-scripts.
> > > > > >
> > > > > > Best regards,
> > > > > >
> > > > > > ### Lennon Mazonde
> > > > > >
> > > > > > KohaSupport
> > > > > >
> > > > > > [blob:https://mail.proton.me/e8ef4ba0-e203-49f9-877f-0b7a940b8f83]
> > > > > >
> > > > > > lennon at kohasupport.com
> > > > > >
> > > > > > [blob:https://mail.proton.me/62ee6d68-51dc-4913-952e-6337c32582bb]
> > > > > >
> > > > > > www.kohasupport.com
> > > > > >
> > > > > > [blob:https://mail.proton.me/9edf60da-ed68-47c1-8229-b123f31dd6a0]
> > > > > >
> > > > > > 651 North Broad Street, Middletown, DE 19709, USA
> > > > > >
> > > > > > The content of this email is confidential and intended for the recipient specified in message only. It is strictly forbidden to share any part of this message with any third party, without a written consent of the sender. If you received this message by mistake, please reply to this message and follow with its deletion, so that we can ensure such a mistake does not occur in the future.
> > > > > >
> > > > > > On 7/4/22 12:11 PM, Lennon Mazonde wrote:
> > > > > >
> > > > > > > Hi,
> > > > > > >
> > > > > > > I have a repo on GitHub with scripts that might be able to help you. Have a look at the 'koha-migrate' script - I originally wrote it to migrate several Koha MariaDB databases running on a Ubuntu (20.04LTS) server to Amazon Aurora MySQL on AWS but it should work for other use-cases. There are several other scripts there you might find useful as well. As always, test them in a dev environment before running them on your production server :)
> > > > > > >
> > > > > > > If anyone else is interested and would like to contribute to the project, please let me know!
> > > > > > >
> > > > > > > Best regards,
> > > > > > >
> > > > > > > Lennon Mazonde
> > > > > > >
> > > > > > > KohaSupport
> > > > > > >
> > > > > > > lennon at kohasupport.com
> > > > > > >
> > > > > > > www.kohasupport.com
> > > > > > >
> > > > > > > 651 North Broad Street, Middletown, DE 19709, USA
> > > > > > >
> > > > > > > The content of this email is confidential and intended for the recipient specified in message only. It is strictly forbidden to share any part of this message with any third party, without a written consent of the sender. If you received this message by mistake, please reply to this message and follow with its deletion, so that we can ensure such a mistake does not occur in the future.
> > > > > > >
> > > > > > > On 7/1/22 5:17 PM, C.S. Hayward wrote:
> > > > > > >
> > > > > > > (Note: I am not using "migrate" as it is usually used today, meaning switching from ABC software to DEF. I'm referring to relocating an installation's data.)
> > > > > > >
> > > > > > > I would like to migrate my data from one Koha installation on one server to another installation on another server. Both use MariaDB.
> > > > > > >
> > > > > > > Where are instructions suitable to migrating data between two different servers?
> > > > > > >
> > > > > > > Thanks,
> > > > > > > Br. C.S. Hayward
> > > > > > > _______________________________________________
> > > > > > >
> > > > > > > Koha mailing listhttp://koha-community.org
> > > > > > > Koha at lists.katipo.co.nz
> > > > > > > Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
> > > > > > >
> > > > > > > _______________________________________________
> > > > > > >
> > > > > > > Koha mailing listhttp://koha-community.org
> > > > > > > Koha at lists.katipo.co.nz
> > > > > > > Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
> > > > > > > _______________________________________________
> > >
> > > Koha mailing listhttp://koha-community.org
> > > Koha at lists.katipo.co.nz
> > > Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
> >
> > --
> > Tim McMahon
> > West Liberty Public Library
> > _______________________________________________
> >
> > Koha mailing list http://koha-community.org
> > Koha at lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha