Problem with migration from KOHA 3.20 to 16.11.11
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 *************************************************
Hi Przemek
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:
Did you really use the following command? koha-restore biblio-main-2017-09-13.sql.gz biblio-main-2017-09-13.tar.gz I guess "koha-restore" is not able to deal with compressed files, so you should first uncompress them. After that you will also need to execute "koha-upgrade-schema". However, in July I successfully changed from an old host with Ubuntu 14.04.5 LTS and Koha 3.20.4 to a new host with Debian GNU/Linux and Koha 17.05.1. After building the new host (not using the .tar.gz file) and creating the new Koha instance I used the following command (instead of using "koha-restore"): $ mysql -u root -pPASSWORD DATABASE_NAME < dumpfile-3.20-20170724.sql After that I upgraded the database schema susing this command: $ sudo koha-upgrade-schema INSTANCENAME Hope that helps. Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch
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
On 2017-09-14 09:51 AM, someone wrote:
Note that Ubuntu 14.04 is not longer supported.
Please note that Ubuntu 14.04 LTS is supported until April 2019 -- <https://www.ubuntu.com/info/release-end-of-life>. Koha tends to be very pro-active with enhancements (a potentially marvelous thing) but possibly might leave stable operating systems in the dust. -- Paul Tired old sys-admin [just celebrated 78 years of life, 62 years of FORTRAN, and 58 years of COBOL] [now ducking the inevitable flames] [ ;=} ] [still running Koha 3.8.24 on 14.04LTS as a reference, non-lending, library at very respectable speeds on copper wire]
Paul, I am sure you understood what I meant: the Koha debian packages are based on Jessie (and so Ubuntu 16.04). We had problems with Apache versions (2.4) and other Perl libs that were not packaged/packagable easily for Wheezy. Debian packages are generated by only 1 guy (Mirko) and developers are (almost) all working on the same system. Same for the CI, we only run tests on Ubuntu 16.04 and Jessie. If someone need Wheezy support (or any other linux distro support), they can contact us and propose their help. >From the wiki page: """ As of November 2016, the Debian packages for Koha are based on Jessie (Debian 8). Xenial (Ubuntu 16.04 LTS) is based on Jessie. That means Ubuntu 14.04 LTS is no longer supported. """ + http://lists.koha-community.org/pipermail/koha-devel/2016-July/042874.html Regards, Jonathan On Thu, 14 Sep 2017 at 20:38 Paul A <paul.a@navalmarinearchive.com> wrote: > On 2017-09-14 09:51 AM, someone wrote: > > > Note that Ubuntu 14.04 is not longer supported. > > Please note that Ubuntu 14.04 LTS is supported until April 2019 -- > <https://www.ubuntu.com/info/release-end-of-life>. Koha tends to be very > pro-active with enhancements (a potentially marvelous thing) but > possibly might leave stable operating systems in the dust. > -- > Paul > Tired old sys-admin > [just celebrated 78 years of life, 62 years of FORTRAN, and 58 years of > COBOL] > [now ducking the inevitable flames] > [ ;=} ] > [still running Koha 3.8.24 on 14.04LTS as a reference, non-lending, > library at very respectable speeds on copper wire] > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha >
Hi, Thanks for the hints. This explained a lot to me. The data transfer attempt was made only for testing. I tested how migration works and whether there will be problems. Now I know what to expect. I plan to migrate data to KOHA 17.05 on Ubuntu server 16.04 in the near future. Thank you and best regards Przemek W dniu 15.09.2017 o 15:31, Jonathan Druart pisze:
Paul,
I am sure you understood what I meant: the Koha debian packages are based on Jessie (and so Ubuntu 16.04). We had problems with Apache versions (2.4) and other Perl libs that were not packaged/packagable easily for Wheezy. Debian packages are generated by only 1 guy (Mirko) and developers are (almost) all working on the same system. Same for the CI, we only run tests on Ubuntu 16.04 and Jessie. If someone need Wheezy support (or any other linux distro support), they can contact us and propose their help.
From the wiki page: """ As of November 2016, the Debian packages for Koha are based on Jessie (Debian 8). Xenial (Ubuntu 16.04 LTS) is based on Jessie. That means Ubuntu 14.04 LTS is no longer supported. """ + http://lists.koha-community.org/pipermail/koha-devel/2016-July/042874.html
Regards, Jonathan
On Thu, 14 Sep 2017 at 20:38 Paul A <paul.a@navalmarinearchive.com> wrote:
On 2017-09-14 09:51 AM, someone wrote:
Note that Ubuntu 14.04 is not longer supported.
Please note that Ubuntu 14.04 LTS is supported until April 2019 -- <https://www.ubuntu.com/info/release-end-of-life>. Koha tends to be very pro-active with enhancements (a potentially marvelous thing) but possibly might leave stable operating systems in the dust. -- Paul Tired old sys-admin [just celebrated 78 years of life, 62 years of FORTRAN, and 58 years of COBOL] [now ducking the inevitable flames] [ ;=} ] [still running Koha 3.8.24 on 14.04LTS as a reference, non-lending, library at very respectable speeds on copper wire] _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- ************************************************* Powiatowa i Miejska Biblioteka Publiczna w Skarżysku-Kamiennej www: www.biblioteka24.eu mail: p.kosinski@biblioteka24.eu *************************************************
participants (4)
-
Jonathan Druart -
Michael Kuhn -
Paul A -
Przemek Kosiński