Migrating from one server to another
(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
One minor clarification: Earlier I was trying to install Koha on an existing Debian server. Now I have left that server and am working on installing to a clean Ubuntu server. I've had an uneventful run-through of getting to the web installer, and getting through most of using the web installer on the new machine. I suspect further data may be clobbered by the data from the migration. Br. C.S. Hayward, https://c-s-hayward.com. ------- Original Message ------- On Friday, July 1st, 2022 at 11:17 AM, C.S. Hayward <c.s.hayward@protonmail.com> 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
Try the following: http://kohageek.pbworks.com/w/page/60452540/How%20to%20move%20your%20koha%20... On Fri, Jul 1, 2022, 17:28 C.S. Hayward <c.s.hayward@protonmail.com> wrote:
One minor clarification:
Earlier I was trying to install Koha on an existing Debian server. Now I have left that server and am working on installing to a clean Ubuntu server.
I've had an uneventful run-through of getting to the web installer, and getting through most of using the web installer on the new machine. I suspect further data may be clobbered by the data from the migration.
Br. C.S. Hayward, https://c-s-hayward.com.
------- Original Message ------- On Friday, July 1st, 2022 at 11:17 AM, C.S. Hayward < c.s.hayward@protonmail.com> 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 list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Hi CS, What version of Koha is running on the old server and what version is running on the new server? I've relocated my data from a server running Koha 20 to one running Koha 21 without issue. Both servers were Debian 10. It is fairly simple using the koha-dump and koha-restore commands from the Linux terminal. You run koha-dump on the old server, copy the files created to the new server, and then run koha-restore on the new server. The koha-dump command creates a .tar file of the application config files and the database dump file. You can install Koha on the new server but instead of creating a new instance (like you would if you were installing a new library setup) you can use the koha-restore command to restore the previous Koha installation to the new server. A brief summary of the koha-dump and koha-restore commands can be found here: https://wiki.koha-community.org/wiki/Commands_provided_by_the_Debian_package... After the older install is restored to the new server (using koha-restore) you must edit the Apache config file used for the Koha instance to match the new server environment (assuming you're using Apache for the server). On my Debian server the site config file is located at /etc/apache2/sites-enabled/instanceName.conf If it would help, I will look for my notes I made the last time I did this earlier this year. -Evan On Fri, Jul 1, 2022 at 9:28 AM C.S. Hayward <c.s.hayward@protonmail.com> wrote:
One minor clarification:
Earlier I was trying to install Koha on an existing Debian server. Now I have left that server and am working on installing to a clean Ubuntu server.
I've had an uneventful run-through of getting to the web installer, and getting through most of using the web installer on the new machine. I suspect further data may be clobbered by the data from the migration.
Br. C.S. Hayward, https://c-s-hayward.com.
------- Original Message ------- On Friday, July 1st, 2022 at 11:17 AM, C.S. Hayward < c.s.hayward@protonmail.com> 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 list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
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@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 list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Forgot to add the link to the GitHub repo, here it is - https://github.com/grandmaestr/koha-scripts. Best regards, Lennon Mazonde KohaSupport lennon@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/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@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 list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Thank you. I had earlier followed the instructions at http://kohageek.pbworks.com/w/page/60452540/How%20to%20move%20your%20koha%20... and got an unbranded internal server error at https://library.cjshayward.com and a Koha branded internal server error at https://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 and https://library.cjshayward.com redirects to https://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 at http://kohageek.pbworks.com/w/page/60452540/How%20to%20move%20your%20koha%20.... Thanks, Br. C.S. Hayward, https://c-s-hayward.com ------- Original Message ------- On Monday, July 4th, 2022 at 6:14 AM, Lennon Mazonde <lennon@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@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@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 list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
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@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 at http://kohageek.pbworks.com/w/page/60452540/How%20to%20move%20your%20koha%20... and got an unbranded internal server error at https://library.cjshayward.com and a Koha branded internal server error at https://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 and https://library.cjshayward.com redirects to https://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 at http://kohageek.pbworks.com/w/page/60452540/How%20to%20move%20your%20koha%20.... Thanks, Br. C.S. Hayward, https://c-s-hayward.com ------- Original Message ------- On Monday, July 4th, 2022 at 6:14 AM, Lennon Mazonde <lennon@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@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@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 list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
From the console:
root@library:~# koha-worker --status library * worker running for library (default) [ OK ] root@library:~# koha-enable library Instance library already enabled. root@library:~# koha-worker -start library Error: invalid option switch (-start) root@library:~# koha-worker --start library * Error: worker already running for library (default) [fail] Attempting to access https://library.cjshayward.com still redirects to https://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 Mazonde lennon@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@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 at http://kohageek.pbworks.com/w/page/60452540/How to move your koha database to newly installed Koha and got an unbranded internal server error at https://library.cjshayward.com and a Koha branded internal server error at https://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 and https://library.cjshayward.com redirects to https://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 at http://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 Mazonde lennon@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@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@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 list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
What happens when you access your staff interface? On 7/6/22 10:37 AM, C.S. Hayward wrote:
From the console:
root@library:~# koha-worker --status library * worker running for library (default) [ OK ] root@library:~# koha-enable library Instance library already enabled. root@library:~# koha-worker -start library Error: invalid option switch (-start) root@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@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@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@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@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@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@lists.katipo.co.nz Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing listhttp://koha-community.org Koha@lists.katipo.co.nz Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing listhttp://koha-community.org Koha@lists.katipo.co.nz Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha -- *Tim McMahon* West Liberty Public Library
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@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@library:~# koha-worker --status library * worker running for library (default) [ OK ] root@library:~# koha-enable library Instance library already enabled. root@library:~# koha-worker -start library Error: invalid option switch (-start) root@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@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@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@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@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@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@lists.katipo.co.nz Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing listhttp://koha-community.org Koha@lists.katipo.co.nz Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________
Koha mailing listhttp://koha-community.org Koha@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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
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@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@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@library:~# koha-worker --status library * worker running for library (default) [ OK ] root@library:~# koha-enable library Instance library already enabled. root@library:~# koha-worker -start library Error: invalid option switch (-start) root@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@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@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@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@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@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@lists.katipo.co.nz > Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha > > _______________________________________________ > > Koha mailing listhttp://koha-community.org > Koha@lists.katipo.co.nz > Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________
Koha mailing listhttp://koha-community.org Koha@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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
participants (5)
-
C.S. Hayward -
Evan Stewart -
Lennon Mazonde -
Mr. Sitali C. S. -
Tim McMahon