[Koha-bugs] [Bug 11000] New: koha-restore not working: Koha username error

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Fri Oct 4 22:12:57 CEST 2013


http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11000

            Bug ID: 11000
           Summary: koha-restore not working: Koha username error
 Change sponsored?: ---
           Product: Koha
           Version: 3.12
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: P5 - low
         Component: Command-line Utilities
          Assignee: gmcharlt at gmail.com
          Reporter: pablo.bianchi at gmail.com
        QA Contact: testopia at bugs.koha-community.org

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...

-- 
You are receiving this mail because:
You are watching all bug changes.


More information about the Koha-bugs mailing list