..until I do a DB repair/rebuild. Items are added, lookups done at LOC etc...everything seems OK... but...the items never "show up" in Koha...ie: users search for the items, but get no results until I run a rebuild/repair I'm unsure of where to even start looking? export PERL5LIB=/usr/share/koha/lib/ export KOHA_CONF=/etc/koha/sites/<My_Site>/koha-conf.xml perl /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b -r -v -run-as-root
What Koha version are you using and what install method? When you use Debian packages, you are provided with a script (koha-indexer) that can be used to start/stop the incremental indexing of any changes on the DB, without the need of a full reindex. Also, the fact you are used to manually run rebuild_zebra.pl (instead of, again, the management scripts the packages provide like koha-rebuild-zebra) with the --run-as-root flag, makes me suspect running with --run-as-root is generating a permissions issue on the Zebra index files, and maybe that's why the incremental indexer is failing, as it is running as the instance's user. Hope it clarifies Keep us posted El vie, 5 mar 2021 a las 10:23, Scott Owen (<sowen@almaschools.net>) escribió:
..until I do a DB repair/rebuild. Items are added, lookups done at LOC etc...everything seems OK... but...the items never "show up" in Koha...ie: users search for the items, but get no results until I run a rebuild/repair
I'm unsure of where to even start looking?
export PERL5LIB=/usr/share/koha/lib/ export KOHA_CONF=/etc/koha/sites/<My_Site>/koha-conf.xml perl /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b -r -v -run-as-root _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
-- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F
Version: *********************************************** Koha version: 17.11.18.000 OS version ('uname -a'): Linux hskoha 3.16.0-4-686-pae #1 SMP Debian 3.16.51-3 (2017-12-13) i686 Perl interpreter: /usr/bin/perl Perl version: 5.020002 Perl @INC: /usr/share/koha/lib /etc/perl /usr/local/lib/i386-linux-gnu/perl/5.20.2 /usr/local/share/perl/5.20.2 /usr/lib/i386-linux-gnu/perl5/5.20 /usr/share/perl5 /usr/lib/i386-linux-gnu/perl/5.20 /usr/share/perl/5.20 /usr/local/lib/site_perl . MySQL version: mysql Ver 14.14 Distrib 5.5.62, for debian-linux-gnu (i686) using readline 6.3 Apache version: Server version: Apache/2.4.10 (Debian) Memcached: Servers: undefined | Namespace: koha | Status: unknown | Config read from: Nowhere Note that the right place to define the memcached config is in your $KOHA_CONF file. Currently you do not have a valid memcached configuration defined. | Effective caching method: Zebra version: Zebra 2.0.59 (C) 1994-2014, Index Data Zebra is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. SHA1 ID: c00bfddbf0f3608340d61298acc61dafb167f9b2 Using ICU *********************************************************** " and maybe that's why the incremental indexer is failing, as it is running as the instance's user." -- certainly sounds possible. -- Any way to test / verify koha-indexer ?? (login as different users via putty and run the command ?? What output should I expect to see ...if any... ) thank you! On Fri, Mar 5, 2021 at 8:35 AM Tomas Cohen Arazi <tomascohen@gmail.com> wrote:
What Koha version are you using and what install method?
When you use Debian packages, you are provided with a script (koha-indexer) that can be used to start/stop the incremental indexing of any changes on the DB, without the need of a full reindex. Also, the fact you are used to manually run rebuild_zebra.pl (instead of, again, the management scripts the packages provide like koha-rebuild-zebra) with the --run-as-root flag, makes me suspect running with --run-as-root is generating a permissions issue on the Zebra index files, and maybe that's why the incremental indexer is failing, as it is running as the instance's user.
Hope it clarifies Keep us posted
El vie, 5 mar 2021 a las 10:23, Scott Owen (<sowen@almaschools.net>) escribió:
..until I do a DB repair/rebuild. Items are added, lookups done at LOC etc...everything seems OK... but...the items never "show up" in Koha...ie: users search for the items, but get no results until I run a rebuild/repair
I'm unsure of where to even start looking?
export PERL5LIB=/usr/share/koha/lib/ export KOHA_CONF=/etc/koha/sites/<My_Site>/koha-conf.xml perl /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b -r -v -run-as-root _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
-- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F
Did you install Koha using the Debian repository at debian.koha-community.org and then installing 'koha-common'? El vie, 5 mar 2021 a las 10:51, Scott Owen (<sowen@almaschools.net>) escribió:
Version:
*********************************************** Koha version: 17.11.18.000 OS version ('uname -a'): Linux hskoha 3.16.0-4-686-pae #1 SMP Debian 3.16.51-3 (2017-12-13) i686 Perl interpreter: /usr/bin/perl Perl version: 5.020002 Perl @INC: /usr/share/koha/lib /etc/perl /usr/local/lib/i386-linux-gnu/perl/5.20.2 /usr/local/share/perl/5.20.2 /usr/lib/i386-linux-gnu/perl5/5.20 /usr/share/perl5 /usr/lib/i386-linux-gnu/perl/5.20 /usr/share/perl/5.20 /usr/local/lib/site_perl . MySQL version: mysql Ver 14.14 Distrib 5.5.62, for debian-linux-gnu (i686) using readline 6.3 Apache version: Server version: Apache/2.4.10 (Debian) Memcached: Servers: undefined | Namespace: koha | Status: unknown | Config read from: Nowhere Note that the right place to define the memcached config is in your $KOHA_CONF file. Currently you do not have a valid memcached configuration defined. | Effective caching method: Zebra version: Zebra 2.0.59 (C) 1994-2014, Index Data Zebra is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. SHA1 ID: c00bfddbf0f3608340d61298acc61dafb167f9b2 Using ICU ***********************************************************
" and maybe that's why the incremental indexer is failing, as it is running as the instance's user." -- certainly sounds possible.
-- Any way to test / verify koha-indexer ?? (login as different users via putty and run the command ?? What output should I expect to see ...if any... )
thank you!
On Fri, Mar 5, 2021 at 8:35 AM Tomas Cohen Arazi <tomascohen@gmail.com> wrote:
What Koha version are you using and what install method?
When you use Debian packages, you are provided with a script (koha-indexer) that can be used to start/stop the incremental indexing of any changes on the DB, without the need of a full reindex. Also, the fact you are used to manually run rebuild_zebra.pl (instead of, again, the management scripts the packages provide like koha-rebuild-zebra) with the --run-as-root flag, makes me suspect running with --run-as-root is generating a permissions issue on the Zebra index files, and maybe that's why the incremental indexer is failing, as it is running as the instance's user.
Hope it clarifies Keep us posted
El vie, 5 mar 2021 a las 10:23, Scott Owen (<sowen@almaschools.net>) escribió:
..until I do a DB repair/rebuild. Items are added, lookups done at LOC etc...everything seems OK... but...the items never "show up" in Koha...ie: users search for the items, but get no results until I run a rebuild/repair
I'm unsure of where to even start looking?
export PERL5LIB=/usr/share/koha/lib/ export KOHA_CONF=/etc/koha/sites/<My_Site>/koha-conf.xml perl /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b -r -v -run-as-root _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
-- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F
-- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F
yes. On Fri, Mar 5, 2021 at 8:55 AM Tomas Cohen Arazi <tomascohen@gmail.com> wrote:
Did you install Koha using the Debian repository at debian.koha-community.org and then installing 'koha-common'?
El vie, 5 mar 2021 a las 10:51, Scott Owen (<sowen@almaschools.net>) escribió:
Version:
*********************************************** Koha version: 17.11.18.000 OS version ('uname -a'): Linux hskoha 3.16.0-4-686-pae #1 SMP Debian 3.16.51-3 (2017-12-13) i686 Perl interpreter: /usr/bin/perl Perl version: 5.020002 Perl @INC: /usr/share/koha/lib /etc/perl /usr/local/lib/i386-linux-gnu/perl/5.20.2 /usr/local/share/perl/5.20.2 /usr/lib/i386-linux-gnu/perl5/5.20 /usr/share/perl5 /usr/lib/i386-linux-gnu/perl/5.20 /usr/share/perl/5.20 /usr/local/lib/site_perl . MySQL version: mysql Ver 14.14 Distrib 5.5.62, for debian-linux-gnu (i686) using readline 6.3 Apache version: Server version: Apache/2.4.10 (Debian) Memcached: Servers: undefined | Namespace: koha | Status: unknown | Config read from: Nowhere Note that the right place to define the memcached config is in your $KOHA_CONF file. Currently you do not have a valid memcached configuration defined. | Effective caching method: Zebra version: Zebra 2.0.59 (C) 1994-2014, Index Data Zebra is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. SHA1 ID: c00bfddbf0f3608340d61298acc61dafb167f9b2 Using ICU ***********************************************************
" and maybe that's why the incremental indexer is failing, as it is running as the instance's user." -- certainly sounds possible.
-- Any way to test / verify koha-indexer ?? (login as different users via putty and run the command ?? What output should I expect to see ...if any... )
thank you!
On Fri, Mar 5, 2021 at 8:35 AM Tomas Cohen Arazi <tomascohen@gmail.com> wrote:
What Koha version are you using and what install method?
When you use Debian packages, you are provided with a script (koha-indexer) that can be used to start/stop the incremental indexing of any changes on the DB, without the need of a full reindex. Also, the fact you are used to manually run rebuild_zebra.pl (instead of, again, the management scripts the packages provide like koha-rebuild-zebra) with the --run-as-root flag, makes me suspect running with --run-as-root is generating a permissions issue on the Zebra index files, and maybe that's why the incremental indexer is failing, as it is running as the instance's user.
Hope it clarifies Keep us posted
El vie, 5 mar 2021 a las 10:23, Scott Owen (<sowen@almaschools.net>) escribió:
..until I do a DB repair/rebuild. Items are added, lookups done at LOC etc...everything seems OK... but...the items never "show up" in Koha...ie: users search for the items, but get no results until I run a rebuild/repair
I'm unsure of where to even start looking?
export PERL5LIB=/usr/share/koha/lib/ export KOHA_CONF=/etc/koha/sites/<My_Site>/koha-conf.xml perl /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b -r -v -run-as-root _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
-- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F
-- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F
My suggestion is: # get the instance name $ sudo koha-list # fix permissions $ sudo chown -R <instance>-koha:<instance>-koha /var/lib/koha/<instance> # perform a full rebuild, the package's way $ sudo koha-rebuild-zebra -f -a -b -v <instance> # make sure the indexer is enabled (should read USE_INDEXER_DAEMON="yes") $ sudo vim /etc/default/koha-common # start the indexer $ sudo koha-indexer --restart <instance> The init service 'koha-common' already handles the koha-indexer, so you can just $ sudo service koha-common restart One thing you can do is running this on a terminal: $ watch -n 0.5 'echo "SELECT * FROM zebraqueue WHERE done=0;| sudo koha-mysql <instance>"' You will see the 'pending' updates. If it is empty, you can just edit something and see things added, and then disappear. If they don't seem to be updated (the indexes) then you should look at /var/log/koha/<instance>/indexer*.log BTW: I strongly suggest you upgrade (at least) to the 20.05 release (19.11 is still maintained but not sure how long). Good luck! El vie, 5 mar 2021 a las 10:58, Scott Owen (<sowen@almaschools.net>) escribió:
yes.
On Fri, Mar 5, 2021 at 8:55 AM Tomas Cohen Arazi <tomascohen@gmail.com> wrote:
Did you install Koha using the Debian repository at debian.koha-community.org and then installing 'koha-common'?
El vie, 5 mar 2021 a las 10:51, Scott Owen (<sowen@almaschools.net>) escribió:
Version:
*********************************************** Koha version: 17.11.18.000 OS version ('uname -a'): Linux hskoha 3.16.0-4-686-pae #1 SMP Debian 3.16.51-3 (2017-12-13) i686 Perl interpreter: /usr/bin/perl Perl version: 5.020002 Perl @INC: /usr/share/koha/lib /etc/perl /usr/local/lib/i386-linux-gnu/perl/5.20.2 /usr/local/share/perl/5.20.2 /usr/lib/i386-linux-gnu/perl5/5.20 /usr/share/perl5 /usr/lib/i386-linux-gnu/perl/5.20 /usr/share/perl/5.20 /usr/local/lib/site_perl . MySQL version: mysql Ver 14.14 Distrib 5.5.62, for debian-linux-gnu (i686) using readline 6.3 Apache version: Server version: Apache/2.4.10 (Debian) Memcached: Servers: undefined | Namespace: koha | Status: unknown | Config read from: Nowhere Note that the right place to define the memcached config is in your $KOHA_CONF file. Currently you do not have a valid memcached configuration defined. | Effective caching method: Zebra version: Zebra 2.0.59 (C) 1994-2014, Index Data Zebra is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. SHA1 ID: c00bfddbf0f3608340d61298acc61dafb167f9b2 Using ICU ***********************************************************
" and maybe that's why the incremental indexer is failing, as it is running as the instance's user." -- certainly sounds possible.
-- Any way to test / verify koha-indexer ?? (login as different users via putty and run the command ?? What output should I expect to see ...if any... )
thank you!
On Fri, Mar 5, 2021 at 8:35 AM Tomas Cohen Arazi <tomascohen@gmail.com> wrote:
What Koha version are you using and what install method?
When you use Debian packages, you are provided with a script (koha-indexer) that can be used to start/stop the incremental indexing of any changes on the DB, without the need of a full reindex. Also, the fact you are used to manually run rebuild_zebra.pl (instead of, again, the management scripts the packages provide like koha-rebuild-zebra) with the --run-as-root flag, makes me suspect running with --run-as-root is generating a permissions issue on the Zebra index files, and maybe that's why the incremental indexer is failing, as it is running as the instance's user.
Hope it clarifies Keep us posted
El vie, 5 mar 2021 a las 10:23, Scott Owen (<sowen@almaschools.net>) escribió:
..until I do a DB repair/rebuild. Items are added, lookups done at LOC etc...everything seems OK... but...the items never "show up" in Koha...ie: users search for the items, but get no results until I run a rebuild/repair
I'm unsure of where to even start looking?
export PERL5LIB=/usr/share/koha/lib/ export KOHA_CONF=/etc/koha/sites/<My_Site>/koha-conf.xml perl /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b -r -v -run-as-root _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
-- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F
-- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F
-- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F
👍👏🤘😀 that did it !!! Thank you Sir !!! and .... are there upgrade instructions to 20.05 posted somewhere.?? all I ever do is: sudo apt-get update sudo apt-get upgrade sudo apt-get install koha-common On Fri, Mar 5, 2021 at 9:10 AM Tomas Cohen Arazi <tomascohen@gmail.com> wrote:
My suggestion is:
# get the instance name $ sudo koha-list # fix permissions $ sudo chown -R <instance>-koha:<instance>-koha /var/lib/koha/<instance> # perform a full rebuild, the package's way $ sudo koha-rebuild-zebra -f -a -b -v <instance> # make sure the indexer is enabled (should read USE_INDEXER_DAEMON="yes") $ sudo vim /etc/default/koha-common # start the indexer $ sudo koha-indexer --restart <instance>
The init service 'koha-common' already handles the koha-indexer, so you can just $ sudo service koha-common restart
One thing you can do is running this on a terminal: $ watch -n 0.5 'echo "SELECT * FROM zebraqueue WHERE done=0;| sudo koha-mysql <instance>"'
You will see the 'pending' updates. If it is empty, you can just edit something and see things added, and then disappear. If they don't seem to be updated (the indexes) then you should look at /var/log/koha/<instance>/indexer*.log
BTW: I strongly suggest you upgrade (at least) to the 20.05 release (19.11 is still maintained but not sure how long).
Good luck!
El vie, 5 mar 2021 a las 10:58, Scott Owen (<sowen@almaschools.net>) escribió:
yes.
On Fri, Mar 5, 2021 at 8:55 AM Tomas Cohen Arazi <tomascohen@gmail.com> wrote:
Did you install Koha using the Debian repository at debian.koha-community.org and then installing 'koha-common'?
El vie, 5 mar 2021 a las 10:51, Scott Owen (<sowen@almaschools.net>) escribió:
Version:
*********************************************** Koha version: 17.11.18.000 OS version ('uname -a'): Linux hskoha 3.16.0-4-686-pae #1 SMP Debian 3.16.51-3 (2017-12-13) i686 Perl interpreter: /usr/bin/perl Perl version: 5.020002 Perl @INC: /usr/share/koha/lib /etc/perl /usr/local/lib/i386-linux-gnu/perl/5.20.2 /usr/local/share/perl/5.20.2 /usr/lib/i386-linux-gnu/perl5/5.20 /usr/share/perl5 /usr/lib/i386-linux-gnu/perl/5.20 /usr/share/perl/5.20 /usr/local/lib/site_perl . MySQL version: mysql Ver 14.14 Distrib 5.5.62, for debian-linux-gnu (i686) using readline 6.3 Apache version: Server version: Apache/2.4.10 (Debian) Memcached: Servers: undefined | Namespace: koha | Status: unknown | Config read from: Nowhere Note that the right place to define the memcached config is in your $KOHA_CONF file. Currently you do not have a valid memcached configuration defined. | Effective caching method: Zebra version: Zebra 2.0.59 (C) 1994-2014, Index Data Zebra is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. SHA1 ID: c00bfddbf0f3608340d61298acc61dafb167f9b2 Using ICU ***********************************************************
" and maybe that's why the incremental indexer is failing, as it is running as the instance's user." -- certainly sounds possible.
-- Any way to test / verify koha-indexer ?? (login as different users via putty and run the command ?? What output should I expect to see ...if any... )
thank you!
On Fri, Mar 5, 2021 at 8:35 AM Tomas Cohen Arazi <tomascohen@gmail.com> wrote:
What Koha version are you using and what install method?
When you use Debian packages, you are provided with a script (koha-indexer) that can be used to start/stop the incremental indexing of any changes on the DB, without the need of a full reindex. Also, the fact you are used to manually run rebuild_zebra.pl (instead of, again, the management scripts the packages provide like koha-rebuild-zebra) with the --run-as-root flag, makes me suspect running with --run-as-root is generating a permissions issue on the Zebra index files, and maybe that's why the incremental indexer is failing, as it is running as the instance's user.
Hope it clarifies Keep us posted
El vie, 5 mar 2021 a las 10:23, Scott Owen (<sowen@almaschools.net>) escribió:
..until I do a DB repair/rebuild. Items are added, lookups done at LOC etc...everything seems OK... but...the items never "show up" in Koha...ie: users search for the items, but get no results until I run a rebuild/repair
I'm unsure of where to even start looking?
export PERL5LIB=/usr/share/koha/lib/ export KOHA_CONF=/etc/koha/sites/<My_Site>/koha-conf.xml perl /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b -r -v -run-as-root _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
-- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F
-- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F
-- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F
participants (2)
-
Scott Owen -
Tomas Cohen Arazi