[Koha] moving database from 17.5 to 19.11 error

Jonathan Druart jonathan.druart at bugs.koha-community.org
Thu Aug 27 19:43:16 NZST 2020


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


More information about the Koha mailing list