We've upgraded our Koha system from Koha 2.2.9 to Koha 3.0. The problem that we have now is that the new database in Koha 3.0 is not searchable. The records seem to be there, but the search returns absolutely nothing. We have not enabled the Zebra in the system. What could be wrong? -- View this message in context: http://www.nabble.com/Non-searchable-database-tp21590023p21590023.html Sent from the Koha - Discuss mailing list archive at Nabble.com.
You haven't built an index, so you have nothing to search. See the scripts: - misc/migration_tools/rebuild_nozebra.pl - misc/migration_tools/rebuild_zebra.pl You should prefer to use Zebra unless you have a very compelling reason not to, but only use the rebuild script for your type of setup. --Joe On Wed, Jan 21, 2009 at 2:07 PM, PasiK <pasi.korkalo@oululainen.com> wrote:
We've upgraded our Koha system from Koha 2.2.9 to Koha 3.0. The problem that we have now is that the new database in Koha 3.0 is not searchable. The records seem to be there, but the search returns absolutely nothing. We have not enabled the Zebra in the system. What could be wrong? -- View this message in context: http://www.nabble.com/Non-searchable-database-tp21590023p21590023.html Sent from the Koha - Discuss mailing list archive at Nabble.com.
Actually I tried running /use/share/koha/bin/migration_tools/rebuild_nozebra.pl, but it came up with en error: DBD::mysql::db do failed: Table 'Koha.nozebra' doesn't exist at ./rebuild_nozebra.pl line 45. Undefined subroutine &main::GetNoZebraIndexes called at ./rebuild_nozebra.pl line 47. I think it tries to use database named Koha, but the name of the new Koha 3.0 database is Koha3... I don't know how it comes up with that database, since in /etc/koha/koha-conf.xml there is a definition: <database>Koha2</database> The reason we chose not use zebra is because (as far as I understand) zebra would have required a lot of extra work. Joe Atzberger wrote:
You haven't built an index, so you have nothing to search. See the scripts:
- misc/migration_tools/rebuild_nozebra.pl - misc/migration_tools/rebuild_zebra.pl
You should prefer to use Zebra unless you have a very compelling reason not to, but only use the rebuild script for your type of setup.
--Joe
On Wed, Jan 21, 2009 at 2:07 PM, PasiK <pasi.korkalo@oululainen.com> wrote:
We've upgraded our Koha system from Koha 2.2.9 to Koha 3.0. The problem that we have now is that the new database in Koha 3.0 is not searchable. The records seem to be there, but the search returns absolutely nothing. We have not enabled the Zebra in the system. What could be wrong? -- View this message in context: http://www.nabble.com/Non-searchable-database-tp21590023p21590023.html Sent from the Koha - Discuss mailing list archive at Nabble.com.
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- View this message in context: http://www.nabble.com/Non-searchable-database-tp21590023p21602379.html Sent from the Koha - Discuss mailing list archive at Nabble.com.
And that is: <database>Koha3</database> of course... :D PasiK wrote:
<database>Koha2</database>
-- View this message in context: http://www.nabble.com/Non-searchable-database-tp21590023p21602400.html Sent from the Koha - Discuss mailing list archive at Nabble.com.
Hi, On Thu, Jan 22, 2009 at 6:32 AM, PasiK <pasi.korkalo@oululainen.com> wrote:
I think it tries to use database named Koha, but the name of the new Koha 3.0 database is Koha3... I don't know how it comes up with that database, since in /etc/koha/koha-conf.xml there is a definition:
<database>Koha2</database>
Check the value of the environment variable KOHA_CONF - it should be set to /etc/koha/koha-conf.xml, but it sounds like it may be pointing to the wrong file.
The reason we chose not use zebra is because (as far as I understand) zebra would have required a lot of extra work.
Not really - if you are using UNIMARC or MARC21, the default Zebra configuration files work out of the box. Regards, Galen -- Galen Charlton VP, Research & Development, LibLime galen.charlton@liblime.com p: 1-888-564-2457 x709 skype: gmcharlt
After (re)setting the KOHA_CONF, we get: <yazgfs> isn't a variable assignment, skipping it<!-- [scheme:]host[:port][/databaseName] --> isn't a variable assignment, skipping it<!-- scheme: tcp, ssl, unix, http, sru --> isn't a variable assignment, skipping it<!-- can run all servers on tcp, but the unix socket is faster --> isn't a variable assignment, skipping it<listen id="biblioserver" >unix:/var/run/koha/zebradb/bibliosocket</listen> isn't a variable assignment, skipping it<listen id="authorityserver"
unix:/var/run/koha/zebradb/authoritysocket</listen> isn't a variable assignment, skipping it<!-- public server runs on tcp --> isn't a variable assignment, skipping it<!-- <listen id="publicserver" >tcp:@:9999</listen> --> isn't a variable assignment, skipping it
and so on for every line on the koha-conf.xml, it's as if the script understands nothing about it. Finally the rebuild process ends to this message: failed: Access denied for user 'root'@'localhost' (using password: NO) at /usr/lib/perl5/5.8.8/C4/Context.pm line 411 Can't call method "do" on an undefined value at ./rebuild_nozebra.pl line 43. Obviously because the script was not able to read the password for the database from the xml file... yep... Galen Charlton wrote:
Hi,
On Thu, Jan 22, 2009 at 6:32 AM, PasiK <pasi.korkalo@oululainen.com> wrote:
I think it tries to use database named Koha, but the name of the new Koha 3.0 database is Koha3... I don't know how it comes up with that database, since in /etc/koha/koha-conf.xml there is a definition:
<database>Koha2</database>
Check the value of the environment variable KOHA_CONF - it should be set to /etc/koha/koha-conf.xml, but it sounds like it may be pointing to the wrong file.
The reason we chose not use zebra is because (as far as I understand) zebra would have required a lot of extra work.
Not really - if you are using UNIMARC or MARC21, the default Zebra configuration files work out of the box.
Regards,
Galen -- Galen Charlton VP, Research & Development, LibLime galen.charlton@liblime.com p: 1-888-564-2457 x709 skype: gmcharlt _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- View this message in context: http://www.nabble.com/Non-searchable-database-tp21590023p21727750.html Sent from the Koha - Discuss mailing list archive at Nabble.com.
participants (3)
-
Galen Charlton -
Joe Atzberger -
PasiK