Hi Tommaso In my case, for an unknown issue, the database backup with the koha backup util was not complete thus, load failed.
I had to run backup using the mysqldump and that worked fine. I followed this instructions http://kohageek.blogspot.com/2015/08/move-old-koha-database-to-new.html The only change I made was to use gzip instead of xz because with xz dump didn't finish. Regards Alvaro |----------------------------------------------------------------------------------------| Stay safe / Cuídate/ Reste sécurisé *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. *q *Recycle always / Recicla siempre / Recyclez toujours P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire Le mer. 26 août 2020 à 09:38, tommaso spazzali <spazz...@magritte.it> a écrit : > Hi Alvaro, hi everybody, > did you solved this error? > > unfortunately I have the same behaviour moving with koha-backup / > kpha-restore from ubuntu 16 to ubuntu 20. > > The strange thing is that I tried succesfully the same operation on a > test server, now, in the production server I get the error ... > > any suggestion will be very appreciated :-) > > thanks > tommaso > > Il 08/01/20 07:13, Alvaro Cornejo ha scritto: > > Hi > > > > I´m tryin to do the DB move from 17.5 to 19.11. > > > > I take following steps: > > > > - backup 17.5 with koha-backup and I get two files a sql.gz and a tar.gz > > - scp both files to new server > > - run koha-remove biblioteca > > - run koha-restore sql tar files > > > > and I start having a lot of errors like: > > > > ERROR: File exists: /var/lib/koha/biblioteca/biblios/key/ > > > > and at the end I have: > > > > ERROR 1396 (HY000) at line 1: Operation DROP USER failed for > > 'koha_biblioteca'@'%' > > ERROR 1819 (HY000) at line 1: Your password does not satisfy the current > > policy requirements > > DBI > > > connect('database=koha_biblioteca;host=localhost;port=3306','koha_biblioteca',...) > > failed: Access denied for user 'koha_biblioteca'@'localhost' (using > > password: YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517. > > DBI > > > connect('database=koha_biblioteca;host=localhost;port=3306','koha_biblioteca',...) > > failed: Access denied for user 'koha_biblioteca'@'localhost' (using > > password: YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517. > > DBI > > > connect('database=koha_biblioteca;host=localhost;port=3306','koha_biblioteca',...) > > failed: Access denied for user 'koha_biblioteca'@'localhost' (using > > password: YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517. > > DBI > > > connect('database=koha_biblioteca;host=localhost;port=3306','koha_biblioteca',...) > > failed: Access denied for user 'koha_biblioteca'@'localhost' (using > > password: YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517. > > DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: Access > > denied for user 'koha_biblioteca'@'localhost' (using password: YES) at > > /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1520. at > > /usr/share/koha/lib/Koha/Database.pm line 107 > > Something went wrong rebuilding biblio indexes for biblioteca > > DBI > > > connect('database=koha_biblioteca;host=localhost;port=3306','koha_biblioteca',...) > > failed: Access denied for user 'koha_biblioteca'@'localhost' (using > > password: YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517. > > DBI > > > connect('database=koha_biblioteca;host=localhost;port=3306','koha_biblioteca',...) > > failed: Access denied for user 'koha_biblioteca'@'localhost' (using > > password: YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517. > > DBI > > > connect('database=koha_biblioteca;host=localhost;port=3306','koha_biblioteca',...) > > failed: Access denied for user 'koha_biblioteca'@'localhost' (using > > password: YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517. > > DBI > > > connect('database=koha_biblioteca;host=localhost;port=3306','koha_biblioteca',...) > > failed: Access denied for user 'koha_biblioteca'@'localhost' (using > > password: YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517. > > DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: Access > > denied for user 'koha_biblioteca'@'localhost' (using password: YES) at > > /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1520. at > > /usr/share/koha/lib/Koha/Database.pm line 107 > > Something went wrong rebuilding authority indexes for biblioteca > > [....] Restarting apache2 (via systemctl): apache2.serviceJob for > > apache2.service failed because the control process exited with error > code. > > See "systemctl status apache2.service" and "journalctl -xe" for details. > > failed! > > > > I double checked that mysqroot pass is the same on both systems. > > > > How do I check "user koha_biblioteca" password to be the same on both > > systems? > > > > > > > |-----------------------------------------------------------------------------------------------------------------| > > Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier > > celular y Nextel > > en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via > SMS > > y GPRS online > > Visitenos en www.perusms.com > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha@lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > > > -- > Tommaso Spazzali > Magritte S.n.c. > Via Meda, 25 > 20136 - Milano > tel: +39.02-49610592 > PGP Key: http://pgpkeys.mit.edu > > I dati personali che ci avete fornito o che ci fornirete saranno oggetto > di trattamento ai sensi del D. Lgs. 196/2003 attraverso strumenti idonei > a garantirne la sicurezza, per le finalita' connesse ad attivita' > commerciali nonche' di adempimento ad obblighi di legge. Il titolare del > trattamento e' la societa' Magritte S.n.c.. Vi ricordiamo che potete > esercitare i diritti di cui all’art. 7 del D. Lgs. 196/2003 consultabili > sul sito del garante della Privacy: http://www.garanteprivacy.it > > _______________________________________________ > > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha