Installing Koha 18.11 LTS on Ubuntu 16.04 LTS

Add a Koha Keys

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

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

sudo apt-get update
sudo apt-get upgrade
sudo apt-get clean

Download and install the latest Koha 18.11

sudo apt-get install koha-common

sudo nano /etc/koha/koha-sites.conf

----------koha-sites.conf----------------
 # Apache virtual hosts creation variables
DOMAIN=".myDNSname.org"
INTRAPORT="9000"               # use 9000 for an Koha OPAC.
INTRAPREFIX=""
INTRASUFFIX="-intra"
OPACPORT="9090"                # use 9090 for an Koha Staff Login
OPACPREFIX=""
OPACSUFFIX=""

 # SQL file to load into new instances
DEFAULTSQL=""

 # Zebra global configuration variables
ZEBRA_MARC_FORMAT="marc21"   # or normarc or unimarc.
ZEBRA_LANGUAGE="en"          # match with installation language (e.g. es for Spanish)
BIBLIOS_INDEXING_MODE="dom"
AUTHORITIES_INDEXING_MODE="dom"

 # Memcached global configuration variables
USE_MEMCACHED="no"
MEMCACHED_SERVERS="127.0.0.1:11211"
MEMCACHED_PREFIX="koha_"

-----------------
Install MySql

sudo apt-get install mysql-server
(give password as you wish for mysql root user)


sudo a2enmod rewrite
sudo a2enmod cgi
sudo service apache2 restart

sudo koha-create --create-db library

----------
Setup Default Ports for Koha

sudo nano /etc/apache2/ports.conf

Listen 80
Listen 9090           # koha staff
Listen 9000           # koha OPAC

---------
Enable Modules and Site

sudo a2enmod deflate
sudo a2ensite library
sudo service apache2 restart

------
The username to log in with will be koha_library. and you can get the password from this command

sudo xmlstarlet sel -t -v 'yazgfs/config/pass' /etc/koha/sites/library/koha-conf.xml;echo
(Username is Koha_library, pwd is showing in command pormnt)

---------------
The staff client, or administrative page, can be accessed at: http://localhost:9090 & Opac at http://localhost:9000

----------
Upgrade Koha for latest relesase

sudo apt-get update
sudo apt-get upgrade
sudo apt-get install koha-common

----------
Back-up and restore Koha

sudo su
mysqldump -uroot -p koha_library | xz > koha_library.sql

(Enter pwd of your root mysql user)

sudo su
mysql -uroot -p (Enter the MySQL Root password)
drop database koha_library;
create database koha_library;
quit;

--------------
Restore Koha DB
sudo su
mysql -uroot -p koha_library < koha_library.sql (Enter the MySQL Root password)
exit

-------------
Upgrade Schema

sudo service memcached restart
sudo koha-upgrade-schema library
----
Re-build Zebra Index

sudo koha-rebuild-zebra -v -f library

(if error then apply bellow command)

koha-rebuild-zebra -f -a -b -v library

How to List DSpace DB and Tables in PostgreSQL Using psql

Listing Databases

postgres=# \l

Switching Databases

postgres=# \c sales

Listing Tables

sales=# \dt