https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26306 Bug ID: 26306 Summary: Access denied for user 'koha_library'@'localhost' Change sponsored?: --- Product: Koha Version: 20.05 Hardware: All OS: Linux Status: NEW Severity: critical Priority: P5 - low Component: Installation and upgrade (command-line installer) Assignee: koha-bugs@lists.koha-community.org Reporter: spazzali@magritte.it QA Contact: testopia@bugs.koha-community.org Created attachment 109223 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=109223&action=edit first line of a history command run on the server This might be a bug or not, is given with a workaround and happened restoring a koha-dump backap to a brand new Koha installation. I installed KOHA 20.05.02.000 on AWS Ubuntu 20 EC2 instance then I tried a koha-restore from a 19.11.05.000 koha-dump backup raise the following error: ERROR 1396 (HY000) at line 1: Operation DROP USER failed for 'koha_library'@'%' DBI connect('database=koha_library;host=localhost;port=3306','koha_library',...) failed: Access denied for user 'koha_library'@'localhost' (using password: YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517. DBI connect('database=koha_library;host=localhost;port=3306','koha_library',...) failed: Access denied for user 'koha_library'@'localhost' (using password: YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517. DBI connect('database=koha_library;host=localhost;port=3306','koha_library',...) failed: Access denied for user 'koha_library'@'localhost' (using password: YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517. DBI connect('database=koha_library;host=localhost;port=3306','koha_library',...) failed: Access denied for user 'koha_library'@'localhost' (using password: YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517. DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: Access denied for user 'koha_library'@'localhost' (using password: YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1520. at /usr/share/koha/lib/Koha/Database.pm line 116 Something went wrong rebuilding biblio indexes for library DBI connect('database=koha_library;host=localhost;port=3306','koha_library',...) failed: Access denied for user 'koha_library'@'localhost' (using password: YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517. DBI connect('database=koha_library;host=localhost;port=3306','koha_library',...) failed: Access denied for user 'koha_library'@'localhost' (using password: YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517. DBI connect('database=koha_library;host=localhost;port=3306','koha_library',...) failed: Access denied for user 'koha_library'@'localhost' (using password: YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517. DBI connect('database=koha_library;host=localhost;port=3306','koha_library',...) failed: Access denied for user 'koha_library'@'localhost' (using password: YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517. DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: Access denied for user 'koha_library'@'localhost' (using password: YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1520. at /usr/share/koha/lib/Koha/Database.pm line 116 Something went wrong rebuilding authority indexes for library Restarting apache2 (via systemctl): apache2.service. I attach the full history that bring to that errors (there is some useless stuff but i prefer to leave it untouched) note that in a first time I set a password to mariaDB user root then (1) I removed mariaDB root password but still get the error then I found this link https://kohageek.blogspot.com/2020/06/dbixclassstoragedbicatch-dbi-connectio... and with a "sudo service memcached restart" before the koha-restore command I got no error and the library is perfectly imported at the end I had to force a sudo service koha-common restart to have the Zebra server running. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.