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

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

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

--- Comment #5 from M. Tompsett <mtompset at hotmail.com> ---
Created attachment 79052
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=79052&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) ls -la /var/spool/koha/kohadev
   -- there is a koha-dump.cnf file with rw owner only perms
9) sudo cat /var/spool/koha/kohadev/koha-dump.cnf
   -- the host, username, and password should match what
      are in the koha-conf.xml file.
10) 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 has the new
            username/password in the koha-dump.cnf file.

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