[Koha] moving database from 17.5 to 19.11 error

[Alvaro Cornejo]

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