[Koha-bugs] [Bug 20929] koha-dump should not pass a --password argument to mysqldump

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Wed Apr 3 16:17:27 CEST 2019


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

--- Comment #8 from Liz Rea <wizzyrea at gmail.com> ---
Created attachment 87356
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=87356&action=edit
Bug 20929: Create and Use CNF file

Rather than have hostname, username, and passwords
on the command line, visible with a ps, use a
CNF file so that mysqldump knows them more securely.

TEST PLAN
----------
1) start kohadevbox
2) reset_all
3) sudo systemctl deamon-reload
4) git bz apply 20929
   -- choose just this patch
5) restart_all
6) perl /home/vagrant/misc4dev/cp_debian_files.pl
7) sudo koha-dump kohadev
8) in another terminal window: while true; do ls -lah /var/spool/koha/kohadev;
sleep 1; done
   -- there is a koha-dump.cnf file with rw owner only perms in one of the ls
runs
9) zcat the backup to make sure the backup has meaningful
    data in it.

BONUS TEST: Change the kohadev DB password, make the
            koha-conf.xml file match, confirm your kohadev
            still works, and that a retest of koha-dump still works.
Test plan mostly written by Mark Tompsett.

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


More information about the Koha-bugs mailing list