[Bug 19547] New: Maria DB doesn't have a debian.cnf
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19547 Bug ID: 19547 Summary: Maria DB doesn't have a debian.cnf Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Database Assignee: koha-bugs@lists.koha-community.org Reporter: mtompset@hotmail.com QA Contact: testopia@bugs.koha-community.org This means if you install Debian with no root password set (so sudo is installed by default), and then you start to following the typical installation instructions (https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages), when you get to the point where you want to koha-create you get something like this: $ sudo koha-create --create-db library awk: cannot open /etc/mysql/koha-common.cnf (No such file or directory) -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19547 M. Tompsett <mtompset@hotmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|koha-bugs@lists.koha-commun |mtompset@hotmail.com |ity.org | Status|NEW |ASSIGNED -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19547 --- Comment #1 from M. Tompsett <mtompset@hotmail.com> --- Created attachment 68850 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=68850&action=edit Bug 19547: MariaDB install has no debian.cnf This attempts to handle issues arising when running koha-create on a system that never had MySQL installed. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19547 --- Comment #2 from M. Tompsett <mtompset@hotmail.com> --- Further thought makes me think we should be generating our koha-common.cnf file if there is no debian.cnf, rather than soft-link. MariaDB generates a dummy debian.cnf with root user and blank password when I ran 'sudo dpkg-reconfigure mariadb-server'. This patch may work for koha-create options other than --create-db, but I have yet to test further after these results thus far. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19547 --- Comment #3 from M. Tompsett <mtompset@hotmail.com> --- Created attachment 68851 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=68851&action=edit Bug 19547: Deal with --create-db missing debian.cnf issue -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19547 M. Tompsett <mtompset@hotmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |Needs Signoff --- Comment #4 from M. Tompsett <mtompset@hotmail.com> --- TEST PLAN ----------- 1) Fresh KohaDevBox to be thrown away later. 2) login vagrant/vagrant or vagrant ssh 3) sudo -i 4) cd /etc/mysql 5) mv debian.cnf broken_debian.cnf -- this makes sure the link is broken (as is the case in long hard old school koha installs with MariaDB) 6) exit 7) cd ~/kohaclone 8) git checkout master 9) git pull 10) git checkout -b bug_19547 origin/master 11) git checkout master 12) perl ~/misc4dev/cp_debian_files.pl 13) sudo koha-create --create-db testmaster1 -- nasty error 14) sudo koha-create --request-db testmaster2 -- nasty error 14) git checkout bug_19547 15) perl ~/misc4dev/cp_debian_files.pl 16) sudo koha-create --create-db testfix1 -- should work 17) sudo koha-create --request-db testfix2 -- should work -- Sadly, testmaster1 and testmaster2 may require manual steps to remove. That is why I wrote "to be thrown away later." -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19547 --- Comment #5 from M. Tompsett <mtompset@hotmail.com> --- This problem does exist if you manually install yourself. You will have to do the move, because the problem does not exist on the kohadevbox, and I don't know why a fresh git install manually done following the wiki instructions using mariadb-server and mariadb-client does not have a debian.cnf file. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19547 M. Tompsett <mtompset@hotmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|enhancement |minor -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19547 --- Comment #6 from M. Tompsett <mtompset@hotmail.com> --- (In reply to M. Tompsett from comment #4)
TEST PLAN ----------- ... 10) git checkout -b bug_19547 origin/master -- 10.5 git bz apply 19547 11) git checkout master
Oops... forgot the obvious line. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19547 Dilan Johnpullé <dilan@calyx.net.au> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Signed Off -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19547 Dilan Johnpullé <dilan@calyx.net.au> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #68851|0 |1 is obsolete| | --- Comment #7 from Dilan Johnpullé <dilan@calyx.net.au> --- Created attachment 72283 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72283&action=edit Bug 19547: Deal with --create-db missing debian.cnf issue Followed test plan. Patch functions as described and both commands execute. Signed-off-by: Dilan Johnpullé <dilan@calyx.net.au> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19547 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|minor |normal CC| |jonathan.druart@bugs.koha-c | |ommunity.org Keywords| |rel_18_05_candidate -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19547 Marcel de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Passed QA Patch complexity|--- |Small patch -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19547 Marcel de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #68850|0 |1 is obsolete| | --- Comment #8 from Marcel de Rooy <m.de.rooy@rijksmuseum.nl> --- Created attachment 72345 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72345&action=edit Bug 19547: MariaDB install has no debian.cnf This attempts to handle issues arising when running koha-create on a system that never had MySQL installed. Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19547 Marcel de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #72283|0 |1 is obsolete| | --- Comment #9 from Marcel de Rooy <m.de.rooy@rijksmuseum.nl> --- Created attachment 72346 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=72346&action=edit Bug 19547: Deal with --create-db missing debian.cnf issue Followed test plan. Patch functions as described and both commands execute. Signed-off-by: Dilan Johnpullé <dilan@calyx.net.au> Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19547 Marcel de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- QA Contact|testopia@bugs.koha-communit |m.de.rooy@rijksmuseum.nl |y.org | CC| |m.de.rooy@rijksmuseum.nl -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19547 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Passed QA |Pushed to Master --- Comment #10 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Pushed to master for 18.05, thanks to everybody involved! -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19547 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Keywords|rel_18_05_candidate | -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19547 Nick Clemens <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |nick@bywatersolutions.com Status|Pushed to Master |Pushed to Stable --- Comment #11 from Nick Clemens <nick@bywatersolutions.com> --- Awesome work all, backported to stable for 17.11.05 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19547 Fridolin SOMERS <fridolin.somers@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |fridolin.somers@biblibre.co | |m --- Comment #12 from Fridolin SOMERS <fridolin.somers@biblibre.com> --- Pushed to 17.05.x for 17.05.11 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19547 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Pushed to Stable |RESOLVED Resolution|--- |FIXED CC| |martin.renvoize@ptfs-europe | |.com -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org