[Koha] moving database from 17.5 to 19.11 error
Stowasser Rainer
rainer.stowasser at zamg.ac.at
Thu Aug 27 20:05:15 NZST 2020
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-bounces at lists.katipo.co.nz> im Auftrag von Jonathan Druart <jonathan.druart at 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 <spazzali at 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 <spazzali at magritte.it
> > <mailto:spazzali at 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 at lists.katipo.co.nz <mailto:Koha at 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 at lists.katipo.co.nz <mailto:Koha at 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 at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org
Koha at lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
More information about the Koha
mailing list