[Koha] Problem with migration from KOHA 3.20 to 16.11.11

[Przemek Kosiński]

Hello,
I have some problems with migration to new server and migrate to new 
version koha.


On the old  server with KOHA 3.20 I made the command "koha-dump 
biblio-main" (it's an instance name) - everything is fine - backup done.

and

On new test server with KOHA 16.11 execute command koha-restore 
biblio-main-2017-09-13.sql.gz biblio-main-2017-09-13.tar.gz

Serwer parameters:
Server: Ubuntu 14.04 LST
Mysql: mysql Ver 14.14 Distrib 5.5.57, for debian-linux-gnu (x86_64) 
using readline 6.3
Apache: Server version: Apache/2.4.7 (Ubuntu)


Restored? Not!  It didn't work.  After the above command - I received 
such output at the terminal:


ERROR 1396 (HY000) at line 1: Operation DROP USER failed for 
'koha_biblio-main'@'%'
ERROR 1046 (3D000) at line 2: No database selected
DBI 
connect('database=koha_biblio-main;host=localhost;port=3306','koha_biblio-main',...) 
failed: Access denied for user 'koha_biblio-main'@'%' to database 
'koha_biblio-main' at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1395.
DBI 
connect('database=koha_biblio-main;host=localhost;port=3306','koha_biblio-main',...) 
failed: Access denied for user 'koha_biblio-main'@'%' to database 
'koha_biblio-main' at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1395.
DBI 
connect('database=koha_biblio-main;host=localhost;port=3306','koha_biblio-main',...) 
failed: Access denied for user 'koha_biblio-main'@'%' to database 
'koha_biblio-main' at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1395.
DBI 
connect('database=koha_biblio-main;host=localhost;port=3306','koha_biblio-main',...) 
failed: Access denied for user 'koha_biblio-main'@'%' to database 
'koha_biblio-main' at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1395.
DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: Access 
denied for user 'koha_biblio-main'@'%' to database 'koha_biblio-main' at 
/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1398. at 
/usr/share/koha/lib/Koha/Database.pm line 90
Something went wrong rebuilding biblio indexes for biblio-main
DBI 
connect('database=koha_biblio-main;host=localhost;port=3306','koha_biblio-main',...) 
failed: Access denied for user 'koha_biblio-main'@'%' to database 
'koha_biblio-main' at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1395.
DBI 
connect('database=koha_biblio-main;host=localhost;port=3306','koha_biblio-main',...) 
failed: Access denied for user 'koha_biblio-main'@'%' to database 
'koha_biblio-main' at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1395.
DBI 
connect('database=koha_biblio-main;host=localhost;port=3306','koha_biblio-main',...) 
failed: Access denied for user 'koha_biblio-main'@'%' to database 
'koha_biblio-main' at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1395.
DBI 
connect('database=koha_biblio-main;host=localhost;port=3306','koha_biblio-main',...) 
failed: Access denied for user 'koha_biblio-main'@'%' to database 
'koha_biblio-main' at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1395.
DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: Access 
denied for user 'koha_biblio-main'@'%' to database 'koha_biblio-main' at 
/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1398. at 
/usr/share/koha/lib/Koha/Database.pm line 90
Something went wrong rebuilding authority indexes for biblio-main
  * Restarting web server apache2 
                                              [Thu Sep 14 
13:53:41.069404 2017] [core:warn] [pid 30685] AH00111: Config variable 
${instance} is not defined
[Thu Sep 14 13:53:41.069560 2017] [core:warn] [pid 30685] AH00111: 
Config variable ${instance} is not defined
[Thu Sep 14 13:53:41.070842 2017] [core:warn] [pid 30685] AH00111: 
Config variable ${instance} is not defined
[Thu Sep 14 13:53:41.070867 2017] [core:warn] [pid 30685] AH00111: 
Config variable ${instance} is not defined
 
                                       [ OK ]

After open url with koha - browser show:

Software error:

DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: Access 
denied for user 'koha_biblio-main'@'%' to database 'koha_biblio-main' at 
/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1398. at 
/usr/share/koha/lib/Koha/Database.pm line 90
Compilation failed in require at 
/usr/share/koha/intranet/cgi-bin/mainpage.pl line 31.
BEGIN failed--compilation aborted at 
/usr/share/koha/intranet/cgi-bin/mainpage.pl line 31.


I tried changing database password or adding user with privileges via 
mysql console - it did not work. Any solution, idea, help?

Best regards,
Przemek Kosiński



-- 
*************************************************
Powiatowa i Miejska Biblioteka
Publiczna w Skarżysku-Kamiennej
www: www.biblioteka24.eu
mail: p.kosinski at biblioteka24.eu
*************************************************