| Summary: | koha-restore not working: Koha username error | ||
|---|---|---|---|
| Product: | Koha | Reporter: | Pablo AB <pablo.bianchi> |
| Component: | Packaging | Assignee: | Bugs List <koha-bugs> |
| Status: | CLOSED FIXED | QA Contact: | Testopia <testopia> |
| Severity: | normal | ||
| Priority: | P3 | CC: | karamqubsi, robin, rudolfbyker |
| Version: | 16.05 | ||
| Hardware: | All | ||
| OS: | All | ||
| GIT URL: | Initiative type: | --- | |
| Sponsorship status: | --- | Comma delimited list of Sponsors: | |
| Crowdfunding goal: | 0 | Patch complexity: | --- |
| Documentation contact: | Documentation submission: | ||
| Text to go in the release notes: | Version(s) released in: | ||
| Circulation function: | |||
Hi , I faced the same problem today as described by Pablo AB
I'm using ubuntu 14.04 LTS ,
I encountered with the problem first with koha 16.05.00 package installation , them I upgraded to koha 16.05.01 (also package ) , and the same problem ,
I tried to restore the instance in other server with the same condition and the same problem is there ,
sudo koha-restore myInstanceName-2016-06-28.sql.gz myInstanceName-2016-06-28.tar.gz
ERROR: File exists: /var/lib/koha/myInstanceName/
ERROR: File exists: /var/lib/koha/myInstanceName/biblios/
ERROR: File exists: /var/lib/koha/myInstanceName/biblios/key/
ERROR: File exists: /var/lib/koha/myInstanceName/biblios/register/
ERROR: File exists: /var/lib/koha/myInstanceName/biblios/tmp/
ERROR: File exists: /var/lib/koha/myInstanceName/biblios/shadow/
ERROR: File exists: /var/lib/koha/myInstanceName/uploads/
ERROR: File exists: /var/lib/koha/myInstanceName/authorities/
ERROR: File exists: /var/lib/koha/myInstanceName/authorities/key/
ERROR: File exists: /var/lib/koha/myInstanceName/authorities/register/
ERROR: File exists: /var/lib/koha/myInstanceName/authorities/tmp/
ERROR: File exists: /var/lib/koha/myInstanceName/authorities/shadow/
ERROR: File exists: /var/lib/koha/myInstanceName/plugins/
ERROR 1396 (HY000) at line 1: Operation DROP USER failed for 'koha_myInstanceName'@'%'
ERROR 1046 (3D000) at line 2: No database selected
Warning: You passed -x which is already the default and is now deprecated·
DBI connect('database=koha_myInstanceName;host=localhost;port=3306','koha_myInstanceName',...) failed: Access denied for user 'koha_myInstanceName'@'%' to database 'koha_myInstanceName' at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1395.
DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: Access denied for user 'koha_myInstanceName'@'%' to database 'koha_myInstanceName' at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1398. at /usr/share/koha/lib/Koha/Database.pm line 90
Something went wrong rebuilding biblio indexes for myInstanceName
DBI connect('database=koha_myInstanceName;host=localhost;port=3306','koha_myInstanceName',...) failed: Access denied for user 'koha_myInstanceName'@'%' to database 'koha_myInstanceName' at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1395.
DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: Access denied for user 'koha_myInstanceName'@'%' to database 'koha_myInstanceName' at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1398. at /usr/share/koha/lib/Koha/Database.pm line 90
Something went wrong rebuilding authority indexes for myInstanceName
* Restarting web server apache2 AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this message
[ OK ]
karam@ubuntu-1gb-lon1-USIM:~/myInstanceName2$ sudo koha-remove myInstanceName
Removing Koha instance myInstanceName
Zebra already stopped for instance myInstanceName.
* Restarting web server apache2 AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this message
Update : Tested on Debian 8.5 . Koha 16.05.01 (packages ) there is no problem , it is just ubuntu problem . As far as I can see, this is fixed. Shall we close the issue? (In reply to Rudolf Byker from comment #4) > As far as I can see, this is fixed. Shall we close the issue? |
koha-restore without previously removing the instance give 78 links of "ERROR: File exists:" and that’s more or less expected, but: koha-remove myInstance (OK) Then: koha-restore /var/spool/koha/myInstance/myInstance-2013-09-23.sql.gz /var/spool/koha/myInstance/myInstance-2013-09-23.tar.gz ERROR: File exists: /var/lib/koha/myInstance/ ERROR: File exists: /var/lib/koha/myInstance/.bash_history ERROR: File exists: .... [total 44 lines] ERROR 1396 (HY000) at line 1: Operation DROP USER failed for 'koha_myInstance'@'%' DBI connect('dbname=koha_myInstance;host=localhost;port=3306','koha_myInstance',...) failed: Access denied for user 'koha_myInstance'@'localhost' (using password: YES) at /usr/share/koha/lib/C4/Context.pm line 803 Access denied for user 'koha_myInstance'@'localhost' (using password: YES) at /usr/share/koha/lib/C4/Context.pm line 803. Something went wrong rebuilding biblio indexes for myInstance DBI connect('dbname=koha_myInstance;host=localhost;port=3306','koha_myInstance',...) failed: Access denied for user 'koha_myInstance'@'localhost' (using password: YES) at /usr/share/koha/lib/C4/Context.pm line 803 Access denied for user 'koha_myInstance'@'localhost' (using password: YES) at /usr/share/koha/lib/C4/Context.pm line 803. Something went wrong rebuilding authority indexes for myInstance [ ok ] Restarting web server: apache2 ... waiting . I fix this just with: GRANT ALL PRIVILEGES ON `koha_myInstance` . * TO 'koha_myInstance'@'localhost'; and running again the previous command, but is very scary to erase and not being able to restore an instance...