[Koha] moving database from 17.5 to 19.11 error

tommaso spazzali spazzali at magritte.it
Thu Aug 27 08:53:15 NZST 2020


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



More information about the Koha mailing list