[Koha] Upgrade problem Debian Packages

clint.deckard clint.deckard at frontiers.co.nz
Mon Jan 15 13:15:31 NZDT 2018


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 at 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 at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha


More information about the Koha mailing list