Missing books after migration to new server
Hi all, I migrated a Koha 24.05.03 installation to a new server according to https://kohageek.blogspot.com/2015/08/move-old-koha-database-to-new.html (Basically a mysqldump and import.) After restarting the Apache2 service, I can successfully log in. I can access patrons and see the library. Everything seems to work, except that I cannot see any item in the Cataloging section and in the OPAC front end. When searching in the Cataloging section, I can see staged marc files and also results from configured Z39.50/SRU servers. All this was configured/staged before the migration. That means the migartions worked (mostly). The items/books all exist in the MariaDB database. The count of rows in the biblio table is as expected. It seems to me that this is some kind of caching issue. I flushed and restarted memcached multiple times and also rebuild the Zebra index to no avail. Can someone point me into the right direction? That would be much appreciated. Thanks Sven
Hi all, I found the cause & solution. I was even more sure that this was some kind of indexing error after I noticed that I was able to new/edit records in https://example.com/cgi-bin/koha/catalogue/detail.pl?biblionumber=N by manually setting the number. I then had a another look into the status of koha-common.service and noticed the following message: Error: you must provide at least one instance name I think this was related to my custom/manual Apache2 configuration. I then added the /etc/apache2/sites-available/mysite.conf and then executed koha-enable mysite systemctl restart koha-common.service Now everything works as expected. Regards Sven On 21/09/2024 13.00, Sven Seeberg wrote:
Hi all,
I migrated a Koha 24.05.03 installation to a new server according to https://kohageek.blogspot.com/2015/08/move-old-koha-database-to-new.html
(Basically a mysqldump and import.)
After restarting the Apache2 service, I can successfully log in. I can access patrons and see the library. Everything seems to work, except that I cannot see any item in the Cataloging section and in the OPAC front end.
When searching in the Cataloging section, I can see staged marc files and also results from configured Z39.50/SRU servers. All this was configured/staged before the migration. That means the migartions worked (mostly).
The items/books all exist in the MariaDB database. The count of rows in the biblio table is as expected. It seems to me that this is some kind of caching issue. I flushed and restarted memcached multiple times and also rebuild the Zebra index to no avail. Can someone point me into the right direction? That would be much appreciated.
Thanks Sven _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Hi Sven, Koha uses a search engine, either Zebra or Elasticsearch. If you haven't set up Elasticsearch, the default is Zebra. Have a look at the koha-rebuild-zebra command in order to do a full reindex of your data. Something like this should do the trick: sudo koha-rebuild-zebra -f -v name_of_your_instance Hope that helps, Katrin On 21.09.24 13:00, Sven Seeberg wrote:
Hi all,
I migrated a Koha 24.05.03 installation to a new server according to https://kohageek.blogspot.com/2015/08/move-old-koha-database-to-new.html
(Basically a mysqldump and import.)
After restarting the Apache2 service, I can successfully log in. I can access patrons and see the library. Everything seems to work, except that I cannot see any item in the Cataloging section and in the OPAC front end.
When searching in the Cataloging section, I can see staged marc files and also results from configured Z39.50/SRU servers. All this was configured/staged before the migration. That means the migartions worked (mostly).
The items/books all exist in the MariaDB database. The count of rows in the biblio table is as expected. It seems to me that this is some kind of caching issue. I flushed and restarted memcached multiple times and also rebuild the Zebra index to no avail. Can someone point me into the right direction? That would be much appreciated.
Thanks Sven _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
participants (2)
-
Katrin Fischer -
Sven Seeberg