Koha - problem with searches/zebra indexing in second instance
All, We created a second instance of Koha using the instructions at http://wiki.koha-community.org/wiki/Installing_Multiple_Instances_of_Koha We dumped the data from our original instance and then reloaded it into the koha_test instance. We have tried to reindex several time by using rebuild_zebra.pl in koha_test /var/log/koha_test/koha-zebradaemon-output.log and koha-zebradaemon.err are both empty The error in koha-opac-error_log is HTML::Template::Pro:in TMPL_LOOP at pos 416: PARAM:LOOP:next_loop(0): callback returned null scope I think it was our install that had a problem because in koha-error_log I see for the date of the install: Thu Apr 07 15:04:37 2011] [error] [client X.X.X.X] [Thu Apr 7 15:04:37 2011] install.pl: C4::Installer::load_sql returned the following errors while attempting to load /usr/share/koha_test/intranet/cgi-bin/installer/data/mysql/en/mandatory/sysprefs.sql:, referer: http://koha_test.mdah.state.ms.us:8080/cgi-bin/koha/installer/install.pl [Thu Apr 07 15:04:37 2011] [error] [client X.X.X.X] [Thu Apr 7 15:04:37 2011] install.pl: Warning: something's wrong at /usr/share/koha_test/lib/C4/Installer.pm line 530., referer: http://koha_test.mdah.state.ms.us:8080/cgi-bin/koha/installer/install.pl [Thu Apr 07 15:04:38 2011] [error] [client X.X.X.X] [Thu Apr 7 15:04:38 2011] install.pl: C4::Installer::load_sql returned the following errors while attempting to load /usr/share/koha_test/intranet/cgi-bin/installer/data/mysql/en/mandatory/userflags.sql:, referer: http://koha_test.mdah.state.ms.us:8080/cgi-bin/koha/installer/install.pl [Thu Apr 07 15:04:38 2011] [error] [client X.X.X.X] [Thu Apr 7 15:04:38 2011] install.pl: Warning: something's wrong at /usr/share/koha_test/lib/C4/Installer.pm line 530., referer: http://koha_test.mdah.state.ms.us:8080/cgi-bin/koha/installer/install.pl [Thu Apr 07 15:04:38 2011] [error] [client X.X.X.X] [Thu Apr 7 15:04:38 2011] install.pl: C4::Installer::load_sql returned the following errors while attempting to load /usr/share/koha_test/intranet/cgi-bin/installer/data/mysql/en/mandatory/userpermissions.sql:, referer: http://koha_test.mdah.state.ms.us:8080/cgi-bin/koha/installer/install.pl Any insight/help would be appreciated. -- Linda Culberson lculber@mdah.state.ms.us Archives and Records Services Division Ms. Dept. of Archives & History P. O. Box 571 Jackson, MS 39205-0571 Telephone: 601/576-6873 Facsimile: 601/576-6824
Hie, There is one problem with multi instances that you maybe didn't notice : The environment variables *KOHA_CONF* and *PERL5LIB* are the same for each instance (they are redefined in cronjobs and apache conf). They are mandatory for lauching perl scripts manually. I think that's why rebuild_zebra doesn't work, it uses the original instance. My solution is to use symbolic links to the currently used instance : for example, I have 2 instance : */usr/share/kohaA/ and /etc/kohaA /usr/share/kohaB/ and /etc/kohaB * Create symbolic links : *ln -s /usr/share/kohaA /usr/share/koha_current ln -s /etc/kohaA /etc/koha_current* And (re)define env vars : *PERL5LIB="/usr/share/koha_current/lib" KOHA_CONF="/etc/koha_current"* Now, when you whan to work manually on a instance, be sure that symbolic links uses the correct instance. (You may create a bash to manager that) Regards, PS : there might be a solution in creating a user per instance that has env vars in his bashrc. On Mon, Apr 11, 2011 at 8:22 PM, Linda Culberson <lculber@mdah.state.ms.us>wrote:
All, We created a second instance of Koha using the instructions at http://wiki.koha-community.org/wiki/Installing_Multiple_Instances_of_Koha We dumped the data from our original instance and then reloaded it into the koha_test instance. We have tried to reindex several time by using rebuild_zebra.pl in koha_test /var/log/koha_test/koha-zebradaemon-output.log and koha-zebradaemon.err are both empty
The error in koha-opac-error_log is HTML::Template::Pro:in TMPL_LOOP at pos 416: PARAM:LOOP:next_loop(0): callback returned null scope
I think it was our install that had a problem because in koha-error_log I see for the date of the install: Thu Apr 07 15:04:37 2011] [error] [client X.X.X.X] [Thu Apr 7 15:04:37 2011] install.pl: C4::Installer::load_sql returned the following errors while attempting to load /usr/share/koha_test/intranet/cgi-bin/installer/data/mysql/en/mandatory/sysprefs.sql:, referer: http://koha_test.mdah.state.ms.us:8080/cgi-bin/koha/installer/install.pl [Thu Apr 07 15:04:37 2011] [error] [client X.X.X.X] [Thu Apr 7 15:04:37 2011] install.pl: Warning: something's wrong at /usr/share/koha_test/lib/C4/Installer.pm line 530., referer: http://koha_test.mdah.state.ms.us:8080/cgi-bin/koha/installer/install.pl [Thu Apr 07 15:04:38 2011] [error] [client X.X.X.X] [Thu Apr 7 15:04:38 2011] install.pl: C4::Installer::load_sql returned the following errors while attempting to load /usr/share/koha_test/intranet/cgi-bin/installer/data/mysql/en/mandatory/userflags.sql:, referer: http://koha_test.mdah.state.ms.us:8080/cgi-bin/koha/installer/install.pl [Thu Apr 07 15:04:38 2011] [error] [client X.X.X.X] [Thu Apr 7 15:04:38 2011] install.pl: Warning: something's wrong at /usr/share/koha_test/lib/C4/Installer.pm line 530., referer: http://koha_test.mdah.state.ms.us:8080/cgi-bin/koha/installer/install.pl [Thu Apr 07 15:04:38 2011] [error] [client X.X.X.X] [Thu Apr 7 15:04:38 2011] install.pl: C4::Installer::load_sql returned the following errors while attempting to load /usr/share/koha_test/intranet/cgi-bin/installer/data/mysql/en/mandatory/userpermissions.sql:, referer: http://koha_test.mdah.state.ms.us:8080/cgi-bin/koha/installer/install.pl
Any insight/help would be appreciated.
-- Linda Culberson lculber@mdah.state.ms.us Archives and Records Services Division Ms. Dept. of Archives & History P. O. Box 571 Jackson, MS 39205-0571 Telephone: 601/576-6873 Facsimile: 601/576-6824
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
-- Fridolyn SOMERS ICT engineer PROGILONE - Lyon - France fridolyn.somers@gmail.com
2011/4/12 Fridolyn SOMERS <fridolyn.somers@gmail.com>:
Hie,
There is one problem with multi instances that you maybe didn't notice :
The environment variables KOHA_CONF and PERL5LIB are the same for each instance (they are redefined in cronjobs and apache conf). They are mandatory for lauching perl scripts manually.
This is acknowledged in the instructions when creating the cronjob files. To+
On Tue, Apr 12, 2011 at 11:38 AM, Tomas Cohen Arazi <tomascohen@gmail.com>wrote:
2011/4/12 Fridolyn SOMERS <fridolyn.somers@gmail.com>:
Hie,
There is one problem with multi instances that you maybe didn't notice :
The environment variables KOHA_CONF and PERL5LIB are the same for each instance (they are redefined in cronjobs and apache conf). They are mandatory for lauching perl scripts manually.
This is acknowledged in the instructions when creating the cronjob files.
To+
Yes I agree for cronjobs. But I understood the problem was when lauching a script manually. For example, recreating Zebra database : *perl /usr/share/koha/misc/migration_tools/rebuild_zebra.pl -b -v -r* In this case, the script looks for C4::Context using the PERL5LIB env var. Regards, -- Fridolyn SOMERS ICT engineer PROGILONE - Lyon - France fridolyn.somers@gmail.com
Yes, Fridolyn is correct, the problem is when launching the cronjob manually using rebuild_zebra.pl -v -b -r I added one record manually into the catalog, and that one is showing up. But the ones that were loaded by taking from the primary instance (we duplicated the database) don't come up in the searches. Is duplicating the database the problem? Thanks again for your help. On 4/12/2011 6:12 AM, Fridolyn SOMERS wrote:
On Tue, Apr 12, 2011 at 11:38 AM, Tomas Cohen Arazi <tomascohen@gmail.com <mailto:tomascohen@gmail.com>> wrote:
2011/4/12 Fridolyn SOMERS <fridolyn.somers@gmail.com <mailto:fridolyn.somers@gmail.com>>: > Hie, > > There is one problem with multi instances that you maybe didn't notice : > > The environment variables KOHA_CONF and PERL5LIB are the same for each > instance > (they are redefined in cronjobs and apache conf). > They are mandatory for lauching perl scripts manually.
This is acknowledged in the instructions when creating the cronjob files.
To+
Yes I agree for cronjobs. But I understood the problem was when lauching a script manually. For example, recreating Zebra database : /perl /usr/share/koha/misc/migration_tools/rebuild_zebra.pl <http://rebuild_zebra.pl> -b -v -r/
In this case, the script looks for C4::Context using the PERL5LIB env var.
Regards,
-- Fridolyn SOMERS ICT engineer PROGILONE - Lyon - France fridolyn.somers@gmail.com <mailto:fridolyn.somers@gmail.com>
-- Linda Culberson lculber@mdah.state.ms.us Archives and Records Services Division Ms. Dept. of Archives & History P. O. Box 571 Jackson, MS 39205-0571 Telephone: 601/576-6873 Facsimile: 601/576-6824
Yes, Fridolyn is correct, the problem is when launching the cronjob manually using rebuild_zebra.pl -v -b -r I added one record manually into the catalog, and that one is showing up. But the ones that were loaded by taking from the primary instance (we duplicated the database) don't come up in the searches. Is there a "correct" or prescribed method of duplicating a database that we should be following? We are going to try Fridolyn's method of dealing with the variables. Thanks to all for your help. On 4/12/2011 6:12 AM, Fridolyn SOMERS wrote:
On Tue, Apr 12, 2011 at 11:38 AM, Tomas Cohen Arazi <tomascohen@gmail.com <mailto:tomascohen@gmail.com>> wrote:
2011/4/12 Fridolyn SOMERS <fridolyn.somers@gmail.com <mailto:fridolyn.somers@gmail.com>>: > Hie, > > There is one problem with multi instances that you maybe didn't notice : > > The environment variables KOHA_CONF and PERL5LIB are the same for each > instance > (they are redefined in cronjobs and apache conf). > They are mandatory for lauching perl scripts manually.
This is acknowledged in the instructions when creating the cronjob files.
To+
Yes I agree for cronjobs. But I understood the problem was when lauching a script manually. For example, recreating Zebra database : /perl /usr/share/koha/misc/migration_tools/rebuild_zebra.pl <http://rebuild_zebra.pl> -b -v -r/
In this case, the script looks for C4::Context using the PERL5LIB env var.
Regards,
-- Fridolyn SOMERS ICT engineer PROGILONE - Lyon - France fridolyn.somers@gmail.com <mailto:fridolyn.somers@gmail.com>
-- Linda Culberson lculber@mdah.state.ms.us Archives and Records Services Division Ms. Dept. of Archives & History P. O. Box 571 Jackson, MS 39205-0571 Telephone: 601/576-6873 Facsimile: 601/576-6824
participants (3)
-
Fridolyn SOMERS -
Linda Culberson -
Tomas Cohen Arazi