[Koha-bugs] [Bug 26306] New: Access denied for user 'koha_library'@'localhost'

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

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 at lists.koha-community.org
          Reporter: spazzali at magritte.it
        QA Contact: testopia at 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-connection.html

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.