Bugzilla – Attachment 21984 Details for
Bug 10782
Add a koha-mysqlcheck script
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 10782 - Add a koha-mysqlcheck script
Bug-10782---Add-a-koha-mysqlcheck-script.patch (text/plain), 5.16 KB, created by
Magnus Enger
on 2013-10-14 19:20:01 UTC
(
hide
)
Description:
Bug 10782 - Add a koha-mysqlcheck script
Filename:
MIME Type:
Creator:
Magnus Enger
Created:
2013-10-14 19:20:01 UTC
Size:
5.16 KB
patch
obsolete
>From f92d0b8df0a4dc4b9770455505c03e32d8af4846 Mon Sep 17 00:00:00 2001 >From: Magnus Enger <magnus@enger.priv.no> >Date: Mon, 14 Oct 2013 21:10:31 +0200 >Subject: [PATCH] Bug 10782 - Add a koha-mysqlcheck script > >This patch adds the koha-mysqlcheck script, as a "frontend" for >the mysqlcheck command. It can be used to check the integrity of >database tables, as well as to repair them. See "man mysqlcheck" >for more information. > >The script takes a Koha instance name as its only required >parameter. Any other parameters provided before the instance >name are passed directly to mysqlcheck, which means that all >the functionality of mysqlcheck is available through this script. > >To test the script: >- Apply the patch, build your own packages and install them, or >- copy koha-mysqlcheck to a server already running off packages > >- Run some variations of the command, with and without arguments, > and check that the output makes sense. E.g.: > sudo koha-mysqlcheck myinstance > sudo koha-mysqlcheck -e myinstance # Extended checks > sudo koha-mysqlcheck -e -v myinstance # Extended checks and verbose >- See "man mysqlcheck" for other relevant options > >To test the man page: >- Run these commands and look at the formatted man page: > $ xsltproc /usr/share/xml/docbook/stylesheet/docbook-xsl/manpages/docbook.xsl \ > debian/docs/koha-mysqlcheck.xml > $ man -l koha-mysqlcheck.8 >- Make sure this test passes: > $ prove -v xt/verify-debian-docbook.t >--- > debian/docs/koha-mysqlcheck.xml | 44 ++++++++++++++++++++++++++++++++++++ > debian/scripts/koha-mysqlcheck | 49 +++++++++++++++++++++++++++++++++++++++++ > 2 files changed, 93 insertions(+) > create mode 100644 debian/docs/koha-mysqlcheck.xml > create mode 100755 debian/scripts/koha-mysqlcheck > >diff --git a/debian/docs/koha-mysqlcheck.xml b/debian/docs/koha-mysqlcheck.xml >new file mode 100644 >index 0000000..d94885d >--- /dev/null >+++ b/debian/docs/koha-mysqlcheck.xml >@@ -0,0 +1,44 @@ >+<article xmlns='http://docbook.org/ns/docbook'> >+<title>koha-mysqlcheck</title> >+<info> >+<productname>Koha</productname> is the first free software library automation package. >+<author> >+ <orgname>The Koha Community</orgname> >+ <uri>http://koha-community.org/</uri> >+</author> >+</info> >+ >+<refentry xml:id="koha-mysqlcheck"> >+ >+ <refmeta> >+ <refentrytitle>koha-mysqlcheck</refentrytitle> >+ <manvolnum>8</manvolnum> >+ </refmeta> >+ >+ <refnamediv> >+ <refname>koha-mysqlcheck</refname> >+ <refpurpose>Run <command>mysqlcheck</command> on the database of the specified Koha instance.</refpurpose> >+ <refclass>UNIX/Linux</refclass> >+ </refnamediv> >+ >+ <refsynopsisdiv> >+ <cmdsynopsis> >+ <command>koha-mysqlcheck</command> <arg><option>...</option></arg> <arg choice="req" rep="norepeat"><replaceable>instancename</replaceable></arg> >+ </cmdsynopsis> >+ </refsynopsisdiv> >+ >+ <refsect1><title>Description</title> >+ <para>Run <command>mysqlcheck</command> on the database of the specified Koha instance.</para> >+ <para>Any arguments provided before the name of the instance are passed directly to <command>mysqlcheck</command>. This means that all the operations of <command>mysqlcheck</command> are available through this script.</para> >+ </refsect1> >+ >+ <refsect1><title>See also</title> >+ <simplelist type="inline"> >+ <member><command>mysqlcheck(1)</command></member> >+ <member><command>koha-mysql(8)</command></member> >+ </simplelist> >+ </refsect1> >+ >+</refentry> >+ >+</article> >diff --git a/debian/scripts/koha-mysqlcheck b/debian/scripts/koha-mysqlcheck >new file mode 100755 >index 0000000..5825e79 >--- /dev/null >+++ b/debian/scripts/koha-mysqlcheck >@@ -0,0 +1,49 @@ >+#!/bin/bash >+# >+# koha-mysqlcheck: run mysqlcheck on the database of the specified Koha instance. >+# Copyright 2013 Magnus Enger Librioech >+# Based on koha-mysql, which is Copyright 2011 Catalyst IT, Ltd >+# >+# This program is free software: you can redistribute it and/or modify >+# it under the terms of the GNU General Public License as published by >+# the Free Software Foundation, either version 3 of the License, or >+# (at your option) any later version. >+# >+# This program is distributed in the hope that it will be useful, >+# but WITHOUT ANY WARRANTY; without even the implied warranty of >+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the >+# GNU General Public License for more details. >+# >+# You should have received a copy of the GNU General Public License >+# along with this program. If not, see <http://www.gnu.org/licenses/>. >+ >+set -e >+ >+umask 0077 >+ >+die() { >+ echo "$@" 1>&2 >+ exit 1 >+} >+ >+# Parse command line. >+if [ $# -lt 1 ]; then >+ die "Usage: $0 [options] instancename" >+fi >+ >+# Separate any arguments from the instance name >+array=($@) >+len=${#array[@]} >+name=${array[$len-1]} >+args=${array[@]:0:$len-1} >+ >+kohaconfig="/etc/koha/sites/$name/koha-conf.xml" >+ >+mysqlhost="$( xmlstarlet sel -t -v 'yazgfs/config/hostname' $kohaconfig )" >+mysqldb="$( xmlstarlet sel -t -v 'yazgfs/config/database' $kohaconfig )" >+mysqluser="$( xmlstarlet sel -t -v 'yazgfs/config/user' $kohaconfig )" >+mysqlpass="$( xmlstarlet sel -t -v 'yazgfs/config/pass' $kohaconfig )" >+ >+mysqlcheck --host="$mysqlhost" --user="$mysqluser" --password="$mysqlpass" \ >+ $args "$mysqldb" >+ >-- >1.8.1.2
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 10782
:
21984
|
25357
|
27459