[Bug 20500] New: koha-create fails to connect to mysql
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20500 Bug ID: 20500 Summary: koha-create fails to connect to mysql Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Packaging Assignee: koha-bugs@lists.koha-community.org Reporter: synapse.ova@gmail.com QA Contact: testopia@bugs.koha-community.org CC: mirko@abunchofthings.net On VPS server (used Debian 8 and Ubuntu 16.04) installed Vesta CP, then installed Koha (17.11). MySQL version 5.5.59-0+deb8u1 (Debian). Everything was fine until I tried to create koha db: # sudo koha-create --create-db lib ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost' (using password: YES) I found out that user debian-sys-maint is present on DB. Password, that is written in config file is the right one. The db user has enough privileges. The same problem was happening even if I tried to connect to MySQL with code, written in koha-create script: # mysql --defaults-extra-file=/etc/mysql/koha-common.cnf ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost' (using password: YES) I tried wrapping options with quote marks, removing extra spaces in .cnf file but with no result. But somehow everything was fine after I changed option "defaults-extra-file" to "defaults-file". Just in case, these lines are contained in files: • koha-create • koha-remove • koha-reset-passwd • koha-restore (3 times) On installed system you can find them in the /usr/sbin/ folder -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20500 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart@bugs.koha-c | |ommunity.org --- Comment #1 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Sounds like a MySQL problem, try to grant privileges to this user. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20500 Rudolf Byker <rudolfbyker@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |rudolfbyker@gmail.com --- Comment #2 from Rudolf Byker <rudolfbyker@gmail.com> --- Probably a MySQL problem, yes. What are the contents of your /etc/mysql/koha-common.cnf ? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20500 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |katrin.fischer@bsz-bw.de Status|NEW |RESOLVED Resolution|--- |INVALID -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20500 --- Comment #3 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- There has been no more information provided by the reporter in a while - moving to RESOLVED for now. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org