3 # koha-create -- Create a new Koha instance.
4 # Copyright 2010 Catalyst IT, Ltd
6 # This program is free software: you can redistribute it and/or modify
7 # it under the terms of the GNU General Public License as published by
8 # the Free Software Foundation, either version 3 of the License, or
9 # (at your option) any later version.
11 # This program is distributed in the hope that it will be useful,
12 # but WITHOUT ANY WARRANTY; without even the implied warranty of
13 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14 # GNU General Public License for more details.
16 # You should have received a copy of the GNU General Public License
17 # along with this program. If not, see <http://www.gnu.org/licenses/>.
19 # Read configuration variable file if it is present
20 [ -r /etc
/default
/koha-common
] && .
/etc
/default
/koha-common
24 # include helper functions
25 if [ -f "/usr/share/koha/bin/koha-functions.sh" ]; then
26 .
"/usr/share/koha/bin/koha-functions.sh"
28 echo "Error: /usr/share/koha/bin/koha-functions.sh not present." 1>&2
37 Creates new Koha instances.
41 $scriptname [DB usage mode] [options] instancename
44 --create-db Create a new database on localhost. (default).
45 --request-db Creates a instancename-db-request.txt file where
46 you adjust your DB settings and re-run with --populate-db.
47 --populate-db Finish the installation you started with --request-db after
48 you adjusted the instancename-db-request.txt file.
49 --use-db Use this option if you already created and populated your DB.
52 --marcflavor flavor Set the MARC flavor. Valid values are marc21 (default),
54 --zebralang lang Choose the primary language for Zebra indexing. Valid
55 values are cs, en (default), es, fr, gr, nb, ru and uk.
56 --auth-idx idx_mode Set the indexing mode for authority records. Valid
57 values are dom (default) and grs1.
58 --biblio-idx idx_mode Set the indexing mode for bibliographic records.
59 Valid values are dom (default) and grs1.
60 --use-memcached Set the instance to make use of memcache.
61 --memcached-servers str Set a comma-separated list of host:port memcached servers.
62 --memcached-prefix str Set the desired prefix for the instance memcached namespace.
63 --enable-sru Enable the Z39.50/SRU server (default: disabled).
64 --sru-port Specifiy a TCP port number for the Z39.50/SRU server
65 to listen on. (default: 7090).
66 --defaultsql some.sql Specify a default SQL file to be loaded on the DB.
67 --configfile cfg_file Specify an alternate config file for reading default values.
68 --passwdfile passwd Specify an alternate passwd file.
69 --dbhost host Enforce the use of the specified DB server
70 --database dbname Enforce the use of the specified DB name (64 char limit)
71 --adminuser n Explicit the admin user ID in the DB. Relevant in
72 conjunction with --defaultsql and --populate-db.
73 --upload-path dir Set a user defined upload_path. It defaults to
74 /var/lib/koha/<instance>/uploads
75 --letsencrypt Set up a https-only site with letsencrypt certificates
76 --help,-h Show this help.
78 Note: the instance name cannot be longer that 11 chars.
83 # UPPER CASE VARIABLES - from configfile or default value
84 # lower case variables - generated within this script
85 generate_config_file
() {
87 chown
"root:$username" "$2"
89 sed -e "s/__KOHA_CONF_DIR__/\/etc\/koha\/sites\/$name/g" \
90 -e "s/__KOHASITE__/$name/g" \
91 -e "s/__OPACPORT__/$OPACPORT/g" \
92 -e "s/__INTRAPORT__/$INTRAPORT/g" \
93 -e "s/__OPACSERVER__/$opacdomain/g" \
94 -e "s/__INTRASERVER__/$intradomain/g" \
95 -e "s/__ZEBRA_PASS__/$zebrapwd/g" \
96 -e "s/__ZEBRA_MARC_FORMAT__/$ZEBRA_MARC_FORMAT/g" \
97 -e "s/__ZEBRA_LANGUAGE__/$ZEBRA_LANGUAGE/g" \
98 -e "s/__SRU_BIBLIOS_PORT__/$SRU_SERVER_PORT/g" \
99 -e "s/__START_SRU_PUBLICSERVER__/$START_SRU_PUBLICSERVER/g" \
100 -e "s/__END_SRU_PUBLICSERVER__/$END_SRU_PUBLICSERVER/g" \
101 -e "s/__BIBLIOS_INDEXING_MODE__/$BIBLIOS_INDEXING_MODE/g" \
102 -e "s/__AUTHORITIES_INDEXING_MODE__/$AUTHORITIES_INDEXING_MODE/g" \
103 -e "s/__ZEBRA_BIBLIOS_CFG__/$ZEBRA_BIBLIOS_CFG/g" \
104 -e "s/__ZEBRA_AUTHORITIES_CFG__/$ZEBRA_AUTHORITIES_CFG/g" \
105 -e "s/__START_BIBLIOS_RETRIEVAL_INFO__/`echo $START_BIBLIOS_RETRIEVAL_INFO`/g" \
106 -e "s/__END_BIBLIOS_RETRIEVAL_INFO__/`echo $END_BIBLIOS_RETRIEVAL_INFO`/g" \
107 -e "s/__START_AUTHORITIES_RETRIEVAL_INFO__/`echo $START_AUTHORITIES_RETRIEVAL_INFO`/g" \
108 -e "s/__END_AUTHORITIES_RETRIEVAL_INFO__/`echo $END_AUTHORITIES_RETRIEVAL_INFO`/g" \
109 -e "s/__API_SECRET__/$API_SECRET/g" \
110 -e "s/__DB_NAME__/$mysqldb/g" \
111 -e "s/__DB_HOST__/$mysqlhost/g" \
112 -e "s/__DB_USER__/$mysqluser/g" \
113 -e "s/__DB_PASS__/$mysqlpwd/g" \
114 -e "s/__UNIXUSER__/$username/g" \
115 -e "s/__UNIXGROUP__/$username/g" \
116 -e "s#__UPLOAD_PATH__#$UPLOAD_PATH#g" \
117 -e "s/__LOG_DIR__/\/var\/log\/koha\/$name/g" \
118 -e "s/__PLUGINS_DIR__/\/var\/lib\/koha\/$name\/plugins/g" \
119 -e "s/__MEMCACHED_NAMESPACE__/$MEMCACHED_NAMESPACE/g" \
120 -e "s/__MEMCACHED_SERVERS__/$MEMCACHED_SERVERS/g" \
121 "/etc/koha/$1" > "$2"
128 $1 ~/\[/ { inclient=0 }
129 $1 ~/\[client\]/ { inclient=1; next }
130 inclient==1 && $1 ~/host/ { gsub(/ /, "", $2); print $2 }' \
131 /etc
/mysql
/koha-common.cnf
134 getinstancemysqlpassword
() {
135 xmlstarlet sel
-t -v 'yazgfs/config/pass' "/etc/koha/sites/$1/koha-conf.xml"
138 getinstancemysqluser
() {
139 xmlstarlet sel
-t -v 'yazgfs/config/user' "/etc/koha/sites/$1/koha-conf.xml"
142 getinstancemysqldatabase
() {
143 xmlstarlet sel
-t -v 'yazgfs/config/database' "/etc/koha/sites/$1/koha-conf.xml"
146 check_apache_config
()
149 # Check that mpm_itk is installed and enabled
150 if ! /usr
/sbin
/apachectl
-M 2> /dev
/null |
grep -q 'mpm_itk'; then
151 # Check Apache version
152 APACHE_DISABLE_MPM_MSG
=""
153 if /usr
/sbin
/apache2ctl
-v |
grep -q "Server version: Apache/2.4"; then
154 # mpm_event or mpm_worker need to be disabled first. mpm_itk depends
155 # on mpm_prefork, which is enabled if needed. See
156 # https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=734865
157 if /usr
/sbin
/apachectl
-M 2> /dev
/null |
grep -q 'mpm_event'; then
158 APACHE_DISABLE_MPM_MSG
=" sudo a2dismod mpm_event ;"
159 elif /usr
/sbin
/apachectl
-M 2> /dev
/null |
grep -q 'mpm_worker'; then
160 APACHE_DISABLE_MPM_MSG
=" sudo a2dismod mpm_worker ;"
161 # else mpm_prefork: a2enmod mpm_itk works
163 # else Apache 2.2: a2enmod mpm_itk works
168 Koha requires mpm_itk to be enabled within Apache in order to run.
169 Typically this can be enabled with:
171 $APACHE_DISABLE_MPM_MSG sudo a2enmod mpm_itk
177 # Check that mod_rewrite is installed and enabled.
178 if ! /usr
/sbin
/apachectl
-M 2> /dev
/null |
grep -q 'rewrite_module'; then
181 Koha requires mod_rewrite to be enabled within Apache in order to run.
182 Typically this can be enabled with:
189 # Check that the CGI module is installed and enabled
190 # (Apache 2.4 may not have it by default.)
191 if ! /usr
/sbin
/apachectl
-M 2> /dev
/null |
grep -q 'cgi_module'; then
193 Koha requires mod_cgi to be enabled within Apache in order to run.
194 Typically this can be enabled with:
201 # Check that mod_ssl is installed and enabled.
202 if [ "$CLO_LETSENCRYPT" = "yes" ]; then
203 if ! /usr
/sbin
/apachectl
-M 2> /dev
/null |
grep -q 'ssl_module'; then
206 Koha requires mod_ssl to be enabled within Apache in order to run with --letsencrypt.
207 Typically this can be enabled with:
217 set_biblios_indexing_mode
()
219 local indexing_mode
=$1
222 case $indexing_mode in
224 START_BIBLIOS_RETRIEVAL_INFO
=`cat <<EOF
225 <xi:include href="\/etc\/koha\/$marc_format-retrieval-info-bib-dom.xml"\n
226 xmlns:xi="http:\/\/www.w3.org\/2001\/XInclude">\n
231 END_BIBLIOS_RETRIEVAL_INFO
=`cat <<EOF
236 BIBLIOS_INDEXING_MODE
="dom"
237 ZEBRA_BIBLIOS_CFG
="zebra-biblios-dom.cfg"
240 START_BIBLIOS_RETRIEVAL_INFO
=" <retrievalinfo>"
241 END_BIBLIOS_RETRIEVAL_INFO
=" <\/retrievalinfo>"
242 BIBLIOS_INDEXING_MODE
="grs1"
243 ZEBRA_BIBLIOS_CFG
="zebra-biblios.cfg"
246 die
"Error: '$indexing_mode' is not a valid indexing mode for bibliographic records."
252 set_authorities_indexing_mode
()
254 local indexing_mode
=$1
257 case $indexing_mode in
259 START_AUTHORITIES_RETRIEVAL_INFO
=`cat <<EOF
260 <xi:include href="\/etc\/koha\/$marc_format-retrieval-info-auth-dom.xml"\n
261 xmlns:xi="http:\/\/www.w3.org\/2001\/XInclude">\n
266 END_AUTHORITIES_RETRIEVAL_INFO
=`cat <<EOF
271 AUTHORITIES_INDEXING_MODE
="dom"
272 ZEBRA_AUTHORITIES_CFG
="zebra-authorities-dom.cfg"
275 START_AUTHORITIES_RETRIEVAL_INFO
=" <retrievalinfo>"
276 END_AUTHORITIES_RETRIEVAL_INFO
=" <\/retrievalinfo>"
277 AUTHORITIES_INDEXING_MODE
="grs1"
278 ZEBRA_AUTHORITIES_CFG
="zebra-authorities.cfg"
281 die
"Error: '$indexing_mode' is not a valid indexing mode for authority records."
291 if [ "$CLO_MEMCACHED_SERVERS" != "" ]; then
292 MEMCACHED_SERVERS
=$CLO_MEMCACHED_SERVERS
294 if [ "$MEMCACHED_SERVERS" = "" ]; then
295 MEMCACHED_SERVERS
=$DEFAULT_MEMCACHED_SERVERS
296 # else: was set by the koha-sites.conf file
300 if [ "$CLO_MEMCACHED_PREFIX" != "" ]; then
301 MEMCACHED_NAMESPACE
="$CLO_MEMCACHED_PREFIX$instance"
303 if [ "$MEMCACHED_PREFIX" != "" ]; then
304 MEMCACHED_NAMESPACE
="$MEMCACHED_PREFIX$instance"
306 MEMCACHED_NAMESPACE
="$DEFAULT_MEMCACHED_PREFIX$instance"
316 if [ "$CLO_UPLOAD_PATH" != "" ]; then
317 UPLOAD_PATH
=$CLO_UPLOAD_PATH
319 UPLOAD_PATH
="$UPLOAD_PATH_BASE/$instance/$UPLOAD_DIR"
325 # remove the commenting symbols
326 START_SRU_PUBLICSERVER
=""
327 END_SRU_PUBLICSERVER
=""
328 if [ "$SRU_SERVER_PORT" = "" ]; then
329 # --sru-port not passed, use the default
330 SRU_SERVER_PORT
=$DEFAULT_SRU_SERVER_PORT
336 if [ $
(dpkg-query
-W -f='${Status}' letsencrypt
2>/dev
/null |
grep -c "ok installed") -eq 0 ]; then
338 apt-cache show letsencrypt
&>/dev
/null
339 local aptcacheshow
=$?
341 if [ $aptcacheshow -eq 0 ]; then
342 read -r -p "The letsencrypt package is not installed. Do it now? [y/N] " response
343 if [[ $response =~ ^
([yY
][eE
][sS
]|
[yY
])$
]]; then
344 local debrelease
="$(lsb_release -c -s)"
345 if [ $debrelease = "jessie" ]; then
346 apt-get
install -y -t jessie-backports letsencrypt
348 apt-get
install -y letsencrypt
351 die
"You have to install letsencrypt to use the --letsencrypt parameter."
354 echo "No installation candidate available for package letsencrypt."
355 if [[ -f /usr
/bin
/letsencrypt
]]; then
356 read -r -p "If you have a symlink from /usr/bin/letsencrypt to letsencrypt-auto, it should work. [y/N] " response
357 if [[ ! $response =~ ^
([yY
][eE
][sS
]|
[yY
])$
]]; then
358 die
"You have to install letsencrypt to use the --letsencrypt parameter."
361 die
"You can create a symlink from /usr/bin/letsencrypt to letsencrypt-auto."
367 letsencrypt_instance
()
369 # Get letsencrypt certificates
370 letsencrypt
--agree-tos --renew-by-default --webroot certonly \
371 -w /usr
/share
/koha
/opac
/htdocs
/ -d $opacdomain -w /usr
/share
/koha
/intranet
/htdocs
/ -d $intradomain
372 # enable all ssl settings (apache won't start with these before certs are present)
373 sed -i "s:^\s*#\(\s*SSL.*\)$:\1:" "/etc/apache2/sites-available/$name.conf"
374 # change port from 80 to 443. (apache won't start if it is 443 without certs present)
375 sed -i "s:^\s*\(<VirtualHost \*\:\)80> #https$:\1443>:" "/etc/apache2/sites-available/$name.conf"
376 # enable redirect from http to https on port 80
377 sed -i "s:^\s*#\(.*\)#nohttps$:\1:" "/etc/apache2/sites-available/$name.conf"
378 # make koha-list --letsencrypt aware of this instance # could be done by checking apache conf instead
379 echo -e "opacdomain=\"$opacdomain\"\nintradomain=\"$intradomain\"" > /var
/lib
/koha
/$name/letsencrypt.enabled
380 # restart apache with working certs
381 service apache2 restart
384 # Set defaults and read config file, if it exists.
393 ZEBRA_MARC_FORMAT
="marc21"
396 PASSWDFILE
="/etc/koha/passwd"
398 # memcached variables
402 # hardcoded memcached defaults
403 DEFAULT_MEMCACHED_SERVERS
="127.0.0.1:11211"
404 DEFAULT_MEMCACHED_PREFIX
="koha_"
405 # hardcoded upload_path
406 UPLOAD_PATH_BASE
="/var/lib/koha"
409 # Generate a randomizaed API secret
410 API_SECRET
="$(pwgen -s 64 1)"
411 # SRU server variables
414 # hardcoded default SRU server port
415 DEFAULT_SRU_SERVER_PORT
="7090"
416 START_SRU_PUBLICSERVER
="<!--"
417 END_SRU_PUBLICSERVER
="-->"
419 # Indexing mode variables (default is DOM)
420 BIBLIOS_INDEXING_MODE
="dom"
421 AUTHORITIES_INDEXING_MODE
="dom"
423 START_BIBLIOS_RETRIEVAL_INFO
=""
424 END_BIBLIOS_RETRIEVAL_INFO
=""
425 START_AUTHORITIES_RETRIEVAL_INFO
=""
426 END_AUTHORITIES_RETRIEVAL_INFO
=""
430 if [ -e /etc
/koha
/koha-sites.conf
]
432 .
/etc
/koha
/koha-sites.conf
435 [ $# -ge 1 ] && [ $# -le 16 ] ||
( usage
; die
"Error: wrong parameters" )
437 TEMP
=`getopt -o chrpm:l:d:f:b:a: -l create-db,request-db,populate-db,use-db,use-memcached,enable-sru,sru-port:,help,marcflavor:,auth-idx:,biblio-idx:,zebralang:,defaultsql:,configfile:,passwdfile:,dbhost:,database:,adminuser:,memcached-servers:,memcached-prefix:,upload-path:,letsencrypt, \
440 # Note the quotes around `$TEMP': they are essential!
443 # Temporary variables for the command line options
444 CLO_ZEBRA_MARC_FORMAT
=""
445 CLO_ZEBRA_LANGUAGE
=""
448 CLO_BIBLIOS_INDEXING_MODE
=""
449 CLO_AUTHORITIES_INDEXING_MODE
=""
450 CLO_MEMCACHED_SERVERS
=""
451 CLO_MEMCACHED_PREFIX
=""
460 op
=request
; shift ;;
462 op
=populate
; shift ;;
466 USE_MEMCACHED
="yes" ; shift ;;
468 CLO_MEMCACHED_SERVERS
="$2" ; shift 2 ;;
470 CLO_MEMCACHED_PREFIX
="$2" ; shift 2;;
472 CLO_ZEBRA_MARC_FORMAT
="$2" ; shift 2 ;;
474 CLO_ZEBRA_LANGUAGE
="$2" ; shift 2 ;;
476 CLO_AUTHORITIES_INDEXING_MODE
="$2" ; shift 2 ;;
478 CLO_BIBLIOS_INDEXING_MODE
="$2" ; shift 2 ;;
480 CLO_DEFAULTSQL
="$2" ; shift 2 ;;
482 configfile
="$2" ; shift 2 ;;
484 CLO_PASSWDFILE
="$2" ; shift 2 ;;
486 CLO_DATABASE
="$2" ; shift 2 ;;
488 CLO_DBHOST
="$2" ; shift 2 ;;
490 CLO_ADMINUSER
="$2" ; shift 2 ;;
492 ENABLE_SRU
="yes" ; shift ;;
494 SRU_SERVER_PORT
="$2" ; shift 2 ;;
496 CLO_UPLOAD_PATH
="$2" ; shift 2 ;;
498 CLO_LETSENCRYPT
="yes" ; shift ;;
504 die
"Internal error processing command line arguments" ;;
508 # Load the configfile given on the command line
509 if [ "$configfile" != "" ]
511 if [ -e "$configfile" ]
515 die
"$configfile does not exist.";
519 # Make sure options from the command line get the highest precedence
520 if [ "$CLO_ZEBRA_MARC_FORMAT" != "" ]
522 ZEBRA_MARC_FORMAT
="$CLO_ZEBRA_MARC_FORMAT"
524 if [ "$CLO_ZEBRA_LANGUAGE" != "" ]
526 ZEBRA_LANGUAGE
="$CLO_ZEBRA_LANGUAGE"
528 if [ "$CLO_DEFAULTSQL" != "" ]
530 DEFAULTSQL
="$CLO_DEFAULTSQL"
532 if [ "$CLO_ADMINUSER" != "" ]
534 ADMINUSER
="$CLO_ADMINUSER"
536 if [ "$CLO_PASSWDFILE" != "" ]
538 PASSWDFILE
="$CLO_PASSWDFILE"
541 if [ "$CLO_BIBLIOS_INDEXING_MODE" != "" ]; then
542 BIBLIOS_INDEXING_MODE
=$CLO_BIBLIOS_INDEXING_MODE
545 set_biblios_indexing_mode
$BIBLIOS_INDEXING_MODE $ZEBRA_MARC_FORMAT
547 if [ "$ENABLE_SRU" != "no" ]; then
551 if [ "$CLO_AUTHORITIES_INDEXING_MODE" != "" ]; then
552 AUTHORITIES_INDEXING_MODE
=$CLO_AUTHORITIES_INDEXING_MODE
555 set_authorities_indexing_mode
$AUTHORITIES_INDEXING_MODE $ZEBRA_MARC_FORMAT
557 [ $# -ge 1 ] ||
( usage
; die
"Missing instance name..." )
561 set_upload_path
$name
563 if [ "$op" = use
] && [ "$CLO_DATABASE" = "" ] &&
564 ( [ ! -f "$PASSWDFILE" ] ||
[ ! `cat $PASSWDFILE | grep "^$name:"` ] )
567 --use-db must have a database name. It can be specified in a readable
568 password file ($PASSWDFILE). Using --passwdfile overrides the default
569 /usr/koha/passwd file. Each line of a passwd file should be in the format of:
570 instance:username:password:dbname:dbhost
571 A database name can also be specified using '--database dbname'.
576 if [ "$USE_MEMCACHED" = "yes" ]; then
578 elif [ "$CLO_MEMCACHED_SERVERS" != "" ] || \
579 [ "$CLO_MEMCACHED_PREFIX" != "" ]; then
583 Error: you provided memcached configuration switches but memcached is not enabled.
584 Please set USE_MEMCACHED="yes" on /etc/koha/koha-sites.conf or use the
585 --use-memcached option switch to enable it.
591 # Unset memcached-related variables
596 # Are we root? If not, the mod_rewrite check will fail and be confusing, so
597 # we look into this first.
600 die
"This script must be run with root privileges."
603 # Check everything is ok with Apache, die otherwise
606 opacdomain
="$OPACPREFIX$name$OPACSUFFIX$DOMAIN"
607 intradomain
="$INTRAPREFIX$name$INTRASUFFIX$DOMAIN"
609 # Check everything is ok with letsencrypt, die otherwise
610 if [ "$CLO_LETSENCRYPT" = "yes" ]; then
614 if [ -f $PASSWDFILE ] && [ `cat $PASSWDFILE | grep "^$name:"` ]
616 passwdline
=`cat $PASSWDFILE | grep "^$name:"`
617 mysqluser
=`echo $passwdline | cut -d ":" -f 2`
618 mysqlpwd
=`echo $passwdline | cut -d ":" -f 3`
619 mysqldb
=`echo $passwdline | cut -d ":" -f 4`
620 mysqlhost
=`echo $passwdline | cut -d ":" -f 5`
623 # The order of precedence for MySQL database name is:
624 # default < passwd file < command line
625 if [ "$mysqldb" = "" ]
630 if [ "$CLO_DATABASE" != "" ]
632 mysqldb
="$CLO_DATABASE"
635 if [ "$mysqluser" = "" ]
637 mysqluser
="koha_$name"
640 if [ "$CLO_DBHOST" != "" ]
642 mysqlhost
="$CLO_DBHOST"
645 if [ "$mysqlhost" = "" ]
647 mysqlhost
="$(getmysqlhost)"
650 if [ "$op" = create
] ||
[ "$op" = request
] ||
[ "$op" = use
]
652 if [ "$mysqlpwd" = "" ]
654 mysqlpwd
="$(pwgen -s 16 1)"
657 mysqlpwd
="$(getinstancemysqlpassword $name)"
661 if [ "$op" = create
] ||
[ "$op" = request
] ||
[ "$op" = use
]
663 # Create new user and group.
664 username
="$name-koha"
665 if getent passwd
"$username" > /dev
/null
667 die
"User $username already exists."
669 if getent group
"$username" > /dev
/null
671 die
"Group $username already exists."
673 adduser
--no-create-home --disabled-login \
674 --gecos "Koha instance $username" \
675 --home "/var/lib/koha/$name" \
678 # Create the site-specific directories.
679 koha-create-dirs
"$name"
681 # Generate Zebra database password.
682 zebrapwd
="$(pwgen -s 16 1)"
683 # Future enhancement: make this configurable for when your db is on
685 mysql_hostname
="localhost"
686 # Set up MySQL database for this instance.
687 if [ "$op" = create
]
689 mysql
--defaults-extra-file=/etc
/mysql
/koha-common.cnf
<<eof
690 CREATE DATABASE \`$mysqldb\`;
691 CREATE USER \`$mysqluser\`@'$mysql_hostname' IDENTIFIED BY '$mysqlpwd';
692 CREATE USER \`$mysqluser\`@'%' IDENTIFIED BY '$mysqlpwd';
693 GRANT ALL PRIVILEGES ON \`$mysqldb\`.* TO \`$mysqluser\`;
694 GRANT ALL PRIVILEGES ON \`$mysqldb\`.* TO \`$mysqluser\`@'$mysql_hostname';
699 if [ "$CLO_LETSENCRYPT" = "yes" ]; then
700 APACHE_CONFIGFILE
="apache-site-https.conf.in"
702 APACHE_CONFIGFILE
="apache-site.conf.in"
704 # Generate and install Apache site-available file and log dir.
705 generate_config_file
$APACHE_CONFIGFILE \
706 "/etc/apache2/sites-available/$name.conf"
707 mkdir
"/var/log/koha/$name"
708 chown
"$username:$username" "/var/log/koha/$name"
711 # Generate and install main Koha config file.
712 generate_config_file koha-conf-site.xml.
in \
713 "/etc/koha/sites/$name/koha-conf.xml"
715 # Generate and install the log4perl config file.
716 generate_config_file log4perl-site.conf.
in \
717 "/etc/koha/sites/$name/log4perl.conf"
719 # Generate and install Zebra config files.
720 generate_config_file zebra-biblios-site.cfg.
in \
721 "/etc/koha/sites/$name/zebra-biblios.cfg"
722 generate_config_file zebra-biblios-dom-site.cfg.
in \
723 "/etc/koha/sites/$name/zebra-biblios-dom.cfg"
724 generate_config_file zebra-authorities-site.cfg.
in \
725 "/etc/koha/sites/$name/zebra-authorities.cfg"
726 generate_config_file zebra-authorities-dom-site.cfg.
in \
727 "/etc/koha/sites/$name/zebra-authorities-dom.cfg"
728 generate_config_file zebra.passwd.
in \
729 "/etc/koha/sites/$name/zebra.passwd"
732 # Create a GPG-encrypted file for requesting a DB to be set up.
733 if [ "$op" = request
]
735 touch "$name-db-request.txt"
736 chmod 0600 "$name-db-request.txt"
737 cat > "$name-db-request.txt" << eof
738 Please create a MySQL database and user on $mysqlhost as follows:
740 database name: $mysqldb
741 database user: $mysqluser
747 echo "See $name-db-request.txt for database creation request."
748 echo "Please forward it to the right person, and then run"
749 echo "$0 --populate-db $name"
755 if [ "$op" = create
] ||
[ "$op" = populate
]
757 # Re-fetch the passwords from the config we've generated, allows it
758 # to be different from what we set, in case the user had to change
760 mysqluser
=$
(getinstancemysqluser
$name)
761 mysqldb
=$
(getinstancemysqldatabase
$name)
762 # Use the default database content if that exists.
763 if [ -e "$DEFAULTSQL" ]
765 # Populate the database with default content.
767 sed "s/__KOHASITE__/koha_$name/g" |
768 mysql
--host="$mysqlhost" --user="$mysqluser" --password="$mysqlpwd" "$mysqldb"
771 # Change the default user's password.
772 staffpass
="$(pwgen 12 1)"
773 staffdigest
=$
(echo -n "$staffpass" |
775 use Digest::MD5 qw(md5_base64);
776 while (<>) { print md5_base64($_), "\n"; }')
777 mysql
--host="$mysqlhost" --user="$mysqluser" \
778 --password="$mysqlpwd" <<eof
781 SET password = '$staffdigest'
782 WHERE borrowernumber = $ADMINUSER;
785 echo "staff user password is '$staffpass' but keep that secret"
787 # Upgrade the database schema, just in case the dump was from an
789 koha-upgrade-schema
"$name"
791 echo "Koha instance is empty, no staff user created."
796 if [ "$op" = create
] ||
[ "$op" = populate
] ||
[ "$op" = use
]
798 # Reconfigure Apache.
800 a2ensite
"$name" > /dev
/null
2>&1 ||
801 a2ensite
"${name}.conf" > /dev
/null
2>&1
803 echo "Warning: problem enabling $name in Apache" >&2
805 service apache2 restart
808 koha-start-zebra
"$name"
810 if [ "$USE_INDEXER_DAEMON" = "yes" ]; then
811 # Start Indexer daemon
812 koha-indexer
--start "$name"
815 if [ "$CLO_LETSENCRYPT" = "yes" ]; then
816 # Get letsencrypt certificates
822 if [ "$op" = request
]
829 Email for this instance is disabled. When you're ready to enable it, use:
830 koha-email-enable $name