Bug importing MARC records?
Hello all, I have a fresh install of Koha 2.0.0RC4 and I want to import some MARC records. I tried using the bulkimport.pl script, but it seems I am getting some errors. The errors say: DBD::mysql::db do failed: Access denied for user: 'kohaadmin@localhost' to database 'Koha' at /usr/local/koha/intranet/modules/C4/Biblio.pm line 289 DBD::mysql::db do failed: Access denied for user: 'kohaadmin@localhost' to database 'Koha' at /usr/local/koha/intranet/modules/C4/Biblio.pm line 371 They just keep repeating. I assumed that it was getting the password from pass=XXX in /etc/koha.conf, so I checked that and I have the correct password there. I then tried the script with more verbose output. It said it was adding the records - so I looked and indeed they were added. Is the error messages a bug or am I doing something wrong? Thanks, Edward Corrado
Edward, it looks like the error is caused when the program tries to lock the MARC tables. That doesn't stop the data from loading, but would be a problem in a production environment. Just out of curiousity, how are you logged in? (as kohaadmin? as root? as some other user?) Edward M. Corrado said:
Hello all,
I have a fresh install of Koha 2.0.0RC4 and I want to import some MARC records. I tried using the bulkimport.pl script, but it seems I am getting some errors. The errors say:
DBD::mysql::db do failed: Access denied for user: 'kohaadmin@localhost' to database 'Koha' at /usr/local/koha/intranet/modules/C4/Biblio.pm line 289 DBD::mysql::db do failed: Access denied for user: 'kohaadmin@localhost' to database 'Koha' at /usr/local/koha/intranet/modules/C4/Biblio.pm line 371
They just keep repeating. I assumed that it was getting the password from pass=XXX in /etc/koha.conf, so I checked that and I have the correct password there. I then tried the script with more verbose output. It said it was adding the records - so I looked and indeed they were added. Is the error messages a bug or am I doing something wrong?
Thanks, Edward Corrado
------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click _______________________________________________ Koha-devel mailing list Koha-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/koha-devel
-- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges@skemotah.com
I was logged in (and ran the script) as root. Edward On Tue, 16 Mar 2004, Stephen Hedges wrote:
Edward, it looks like the error is caused when the program tries to lock the MARC tables. That doesn't stop the data from loading, but would be a problem in a production environment. Just out of curiousity, how are you logged in? (as kohaadmin? as root? as some other user?)
Edward M. Corrado said:
Hello all,
I have a fresh install of Koha 2.0.0RC4 and I want to import some MARC records. I tried using the bulkimport.pl script, but it seems I am getting some errors. The errors say:
DBD::mysql::db do failed: Access denied for user: 'kohaadmin@localhost' to database 'Koha' at /usr/local/koha/intranet/modules/C4/Biblio.pm line 289 DBD::mysql::db do failed: Access denied for user: 'kohaadmin@localhost' to database 'Koha' at /usr/local/koha/intranet/modules/C4/Biblio.pm line 371
They just keep repeating. I assumed that it was getting the password from pass=XXX in /etc/koha.conf, so I checked that and I have the correct password there. I then tried the script with more verbose output. It said it was adding the records - so I looked and indeed they were added. Is the error messages a bug or am I doing something wrong?
Thanks, Edward Corrado
------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click _______________________________________________ Koha-devel mailing list Koha-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/koha-devel
-- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges@skemotah.com
On Tue, Mar 16, 2004 at 08:54:11PM -0500, Edward M. Corrado said:
I was logged in (and ran the script) as root.
Edward
On Tue, 16 Mar 2004, Stephen Hedges wrote:
Edward, it looks like the error is caused when the program tries to lock the MARC tables. That doesn't stop the data from loading, but would be a problem in a production environment. Just out of curiousity, how are you logged in? (as kohaadmin? as root? as some other user?)
Hi all
My guess is that the kohaadmin user doesnt have permission to lock the tables in mysql. Do you know how to check the mysql permissions Edward? Chris -- Chris Cormack Programmer 027 4500 789 Katipo Communications Ltd chris@katipo.co.nz www.katipo.co.nz
Hi all, Basically the message subject says it all. I edited Auth.pm to add the missing } and now I can't login to any of the accounts. Any suggestions for why that might have happened? Joshua
Joshua Ferraro wrote:
Hi all,
Basically the message subject says it all. I edited Auth.pm to add the missing } and now I can't login to any of the accounts.
Any suggestions for why that might have happened?
Joshua
Are you working on stable or unstable ? (guessing you're on unstable) If you have not LDAP installed, check that your systempref does not contain anything in the LDAP server. It works fine for me in HEAD (with ldap commented), as well as with rel_2_0 (with unmodified & up2date Auth.pm) ps : going to bed now, 11PM in France ;-) -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)
Are you working on stable or unstable ? (guessing you're on unstable) unstable.
If you have not LDAP installed, check that your systempref does not contain anything in the LDAP server. It works fine for me in HEAD (with ldap commented), as well as with rel_2_0 (with unmodified & up2date Auth.pm) I do have LDAP installed (I installed Net::LDAP). I committed my change to Auth.pm before I realized that logins were broken, is that the version
On Wed, Mar 17, 2004 at 11:23:24PM +0100, paul POULAIN wrote: that's working for you? Joshua
Joshua Ferraro wrote:
I do have LDAP installed (I installed Net::LDAP). I committed my change
to Auth.pm before I realized that logins were broken, is that the version that's working for you?
OK, there was a bug (in the } that was added a few days ago) It's fixed in CVS -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)
On Fri, Mar 19, 2004 at 04:24:38PM +0100, paul POULAIN wrote:
Joshua Ferraro wrote:
I do have LDAP installed (I installed Net::LDAP). I committed my change
to Auth.pm before I realized that logins were broken, is that the version that's working for you?
OK, there was a bug (in the } that was added a few days ago) It's fixed in CVS Thanks Paul...and sorry for committing the bug :-) everything seems to be working now.
Joshua
This discussion may have moved off-list, but I want to be sure Edward figures this out ('cause I'm curious): Chris Cormack said:
On Tue, Mar 16, 2004 at 08:54:11PM -0500, Edward M. Corrado said:
I was logged in (and ran the script) as root.
Edward
On Tue, 16 Mar 2004, Stephen Hedges wrote:
Edward, it looks like the error is caused when the program tries to lock the MARC tables. That doesn't stop the data from loading, but would be a problem in a production environment. Just out of curiousity, how are you logged in? (as kohaadmin? as root? as some other user?)
Hi all
My guess is that the kohaadmin user doesnt have permission to lock the tables in mysql. Do you know how to check the mysql permissions Edward?
Chris
To check permissions, connect to mysql and issue the following command from the "mysql>" prompt: show grants for kohaadmin@localhost; You should get something like this back: GRANT SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO 'kohaadmin'@'localhost' IDENTIFIED BY PASSWORD '5c6f1ab3038094f4' If you don't see "LOCK TABLES" in the list, then it's possible that something is wrong with your mysql install. Try upgrading the grant tables (http://www.mysql.com/doc/en/Upgrading-grant-tables.html) to see if that fixes things. If it doesn't, then we need to dig deeper... -- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges@skemotah.com
participants (5)
-
Chris Cormack -
Edward M. Corrado -
Joshua Ferraro -
paul POULAIN -
Stephen Hedges