OK, a restart of memcached did the trick.
Should have thought of that earlier
Clint.
clint.deckard wrote:
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
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
