Thanks for the reply Liz, Yes the instance did exist with koha-create --create-db, I used koha-remove then koha-restore. The instances are the same name and it is not 'instance' :) The odd thing is that I migrated a number of instances with the same process two weeks ago without issue, but the two I tried today have the same result. Appreciatively, Clint. Liz Rea wrote:
On 15/01/18 11:55, clint.deckard wrote:
Following an upgrade form 16.05 to 17.11 using the packages (and koha-restore) on Debian Jessie I get the following error when trying to access the staff or opac interface; "DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: Access denied for user 'koha_instance'@'localhost' (using password: YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1490. at /usr/share/koha/lib/Koha/Database.pm line 100"
I did notice the error during koha-restore 'DROP USER koha_instance failed' (approx).
I'd appreciate some help.
Clint. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha Hi Clint,
Did the instance koha_instance exist before you tried to restore the database? i.e. did you koha-create instance before or after you restored the database?
Is the instance name the same between your dumped database and the new instance? If not, they probably should be. If you can't do that for some reason, you'll need to unzip and edit the database dump to include the new db name, it'll look something like:
-- -- Current Database: `koha_instance` --
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `koha_instance` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `koha_instance`;
if "instance" there doesn't match the name of your new db/instance, you'll need to edit the dump to change it to match up, if that makes sense.
I'm making a grand assumption that you know that most Koha instances aren't named instance, they can be named whatever you want and that there's nothing magic about "instance" as a name when you've done koha-create, or koha_instance as the database name. All that needs to happen is that the koha-create <instance> and koha_<instance> should match up. Then everything should work. And that the <instance> should exist before you try to import the database.
If koha-restore doesn't work after you've unzipped and edited the dump file, you can do (I'm assuming you'll have only one dump file in the current directory - if you have more than one specify the full filename!)
cat instance-*.sql | sudo koha-mysql instance
and that will import the edited database into the instance's database.
Cheers, Liz