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: [email protected]
*************************************************
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
https://lists.katipo.co.nz/mailman/listinfo/koha
