[Koha-bugs] [Bug 15935] New: Provide koha-cleanup-database command for package install

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15935

            Bug ID: 15935
           Summary: Provide koha-cleanup-database command for package
                    install
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Command-line Utilities
          Assignee: gmcharlt at gmail.com
          Reporter: library at stas.org
        QA Contact: testopia at bugs.koha-community.org
                CC: robin at catalyst.net.nz

We have provided commands for the most important command line actions for
package users, but there are yet several important commands which require
calling the .pl file directly. 

The commands provided by the packages take into account the location of
koha-conf.xml and perl files for the instance provided or detected, but do not
seem to use the environmental variable KOHA_CONF and PERL5LIB directly.

As a result it seems that the Debian/Ubuntu packages do not presently set up
these environmental variables. On package installs executing the commands not
yet provided for requires manually setting these variables.

For instance, when trying to run the cleanup_database.pl utility on a package
install it will fail because KOHA_CONF is not specified. To allow it to work
one must manually set this variable.

I propose the creation a command for the package installs called
"koha-cleanup-database" which will avoid the use of environmental variables,
but provide for package users the ability to cleanup their databases.

I propose this utility because of its value -- we have been cataloging a 40,000
volume library and from all the z39.50 searches our database had reached over
1.5 GB. On the non-package install we cleaned up the database down to only 120
MB by removing the old z39.50 searches and the whole setup is much more stable
and fast. Upgrading to a package install on a new server, we have lost this
functionality.

-- 
You are receiving this mail because:
You are watching all bug changes.