Hello, We have an entry in the bug tracker that is related to what you describe: Bug 11000 - koha-restore not working: Koha username error Maybe you can try and add more information there? Note that Ubuntu 14.04 is not longer supported. Cheers, Jonathan On Thu, 14 Sep 2017 at 09:48 Przemek Kosiński <p.kosinski@biblioteka24.eu> wrote:
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@biblioteka24.eu ************************************************* _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha