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