Misc

library@library-NS14A6:~$ sudo su

[sudo] password for library: 

    1  apt update

    2  apt upgrade

    3  echo deb http://debian.koha-community.org/koha oldstable main | sudo tee /etc/apt/sources.list.d/koha.list

    4  wget -O- https://debian.koha-community.org/koha/gpg.asc | sudo apt-key add -

    5  sudo apt update

    6  sudo apt upgrade

    7  sudo apt clean

    8  sudo apt install koha-common

    9  sudo gedit /etc/koha/koha-sites.conf 

   10  sudo apt install mariadb-server

   11  sudo apt install mariadb-server mariadb-client -y

   12  sudo mysql_secure_installation

   13  sudo a2enmod rewrite cgi && sudo systemctl restart apache2

   14  sudo koha-create --create-db library

   15  echo "ServerName localhost" | sudo tee /etc/apache2/conf-available/fqdn.conf

   16  sudo a2enconf fqdn

   17  apachectl configtest

   18  sudo gedit /etc/apache2/ports.conf

   19  sudo a2dissite 000-default && sudo a2enmod deflate && sudo a2ensite library

   20  sudo systemctl restart apache2

   21  sudo apt install liblocale-codes-perl

   22  sudo xmlstarlet sel -t -v 'yazgfs/config/pass' /etc/koha/sites/library/koha-conf.xml;echo

   23  sudo perl -MCPAN -e 'install Bundle::KohaSupport'

   24  sudo apt install phpmyadmin php-mbstring php-zip php-gd php-json php-curl

   25  sudo mysql -u root -p

new user

CREATE USER 'library_admin'@'localhost' IDENTIFIED BY 'Root@123#';

GRANT ALL PRIVILEGES ON *.* TO 'library_admin'@'localhost' WITH GRANT OPTION;

exit 

   26  apt install net-tools

   28  ifconfig

   29  sudo reboot

   30  mysql -unikunj -p koha_library < /home/library/Documents/ca/census18623.sql 

   31  sudo xmlstarlet sel -t -v 'yazgfs/config/pass' /etc/koha/sites/library/koha-conf.xml;echo

   32  cp /home/library/Documents/ca/header.jpg /usr/share/koha/opac/htdocs/opac-tmpl/bootstrap/images/

   33  cp /home/library/Documents/ca/header.png /usr/share/koha/opac/htdocs/opac-tmpl/bootstrap/images/

   34  cp /home/library/Documents/ca/census.jpg /usr/share/koha/opac/htdocs/opac-tmpl/bootstrap/images/

   35  gedit

   36  cd

   37  exit

   38  export PERL5LIB="/usr/share/koha/lib" 

   39  export KOHA_CONF="/etc/koha/sites/library/koha-conf.xml"

   40  exit

   41  history

$ sudo koha-translate --list

To get a list of the available languages run:

$ sudo koha-translate --list --available

To install a new language run:

$ sudo koha-translate --install <language-code>

For further options run:

$ sudo koha-translate --help

To enable and configure ICU:

1. Install the yaz-icu package:

 sudo apt-get install yaz-icu

2. In the staff interface go to More > Administration > Global system preferences > Searching.

3. Change the UseICUStyleQuotes system preference to Using.

4. Change the QueryFuzzy system preference to Don't try.

5. Change the QueryStemming system preference to Don't try.

6. Edit /etc/koha/zebradb/etc/default.idx

 Change or add the bolded lines:

 # Traditional word index

 # Used if completenss is 'incomplete field' (@attr 6=1) and

 # structure is word/phrase/word-list/free-form-text/document-text

 index w

 completeness 0

 position 1

 alwaysmatches 1

 firstinfield 1

 icuchain words-icu.xml

 # Phrase index

 # Used if completeness is 'complete {sub}field' (@attr 6=2, @attr 6=1)

 # and structure is word/phrase/word-list/free-form-text/document-text

 index p

 completeness 1

 firstinfield 1

 icuchain phrases-icu.xml 

If the Koha instance is on a shared server and you only want to use ICU for this particular instance, this functionality was added in Bug 12216

7. Depending on the language you are searching, you may need to modify words-icu.xml or phrases-icu.xml - these are in the same directory as /etc/koha/zebradb/etc/default.idx. The ICU Chains Library covers the modifications required for several languages - you are encouraged to add more.

8. Restart Zebra and rebuild the search index.

 If you are using packages (the recommended way to install Koha), run:

  sudo koha-zebra --restart {yourinstancename}

  sudo koha-rebuild-zebra -f {yourinstancename}

Bulk marc import

sudo su

export PERL5LIB="/usr/share/koha/lib"

export KOHA_CONF="/etc/koha/sites/library/koha-conf.xml"

cd /usr/share/koha/bin/migration_tools

Execute the following command,

perl bulkmarcimport.pl -file sample.mrc

User can import bibliographic records in a desired MARC Bibliographic Framework (e.g. BKS),

perl bulkmarcimport.pl -framework BKS -file sample.mrc

The following command will delete all existing records and install new batch of marc file.

perl bulkmarcimport.pl -d -file sample.mrc

Rebuild Zebra after import process finish

sudo koha-rebuild-zebra -v -f library