moving database from 17.5 to 19.11 error
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
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
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@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
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-connectio... 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@magritte.it <mailto:spazzali@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
Hi, I suggest you make a clean install, create a fresh instance, and then load the DB and var lib files. That will give you better results even in a happy restore case, as several files will be generated with newer defaults. El mié., 26 ago. 2020 17:54, tommaso spazzali <spazzali@magritte.it> escribió:
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-connectio...
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@magritte.it <mailto:spazzali@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
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@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-connectio...
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@magritte.it <mailto:spazzali@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
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@lists.katipo.co.nz> im Auftrag von Jonathan Druart <jonathan.druart@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@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-connectio...
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@magritte.it <mailto:spazzali@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
The full description is here https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26306 ciao tommaso Il 27/08/20 10:05, Stowasser Rainer ha scritto:
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@lists.katipo.co.nz> im Auftrag von Jonathan Druart <jonathan.druart@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@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-connectio...
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@magritte.it <mailto:spazzali@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
-- 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
participants (5)
-
Alvaro Cornejo -
Jonathan Druart -
Stowasser Rainer -
Tomas Cohen Arazi -
tommaso spazzali