Dear Jonathan Theres something probably related here
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6416 Kind regards Hofrat Mag. Rainer Stowasser Head of Library and Archives ZAMG ________________________________________ Von: Koha <koha-boun...@lists.katipo.co.nz> im Auftrag von Jonathan Druart <jonathan.dru...@bugs.koha-community.org> Gesendet: Donnerstag, 27. August 2020 09:43:16 An: tommaso spazzali Cc: Koha Betreff: Re: [Koha] moving database from 17.5 to 19.11 error Hi Tomasso, Can you open a new bug report and describe how we could simply recreate the problem? If a memcached restart is missing it's a bug somewhere. Regards, Jonathan Le mer. 26 août 2020 à 22:53, tommaso spazzali <spazz...@magritte.it> a écrit : > > Thanks Alvaro, > > I was sure my backup was complete (I already made a restore with it) so > looking a little deeper in the internet I found this: > > https://kohageek.blogspot.com/2020/06/dbixclassstoragedbicatch-dbi-connection.html > > and it worked very well > > I removed the wrong library and before doing a koha-restore I executed > > sudo service memcached restart > > maybe somebody knows why :-) > > thanks again > regards > tommaso > > Il 26/08/20 17:35, Alvaro Cornejo ha scritto: > > 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 > > <mailto: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 <http://www.perusms.com> > > > _______________________________________________ > > > Koha mailing list http://koha-community.org > > > Koha@lists.katipo.co.nz <mailto: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 <mailto:Koha@lists.katipo.co.nz> > > Unsubscribe: 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 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha