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@gmail.com Reporter: library@stas.org QA Contact: testopia@bugs.koha-community.org CC: robin@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.