Hi all This is a follow up on errors in bulkmarcimport. Im still getting errors with the DBI connect. As a test i'm using the marc file supplied by Steven Baljkas, emcs2.mrc Command line is this: misc$ perl -I /home/rsnsw/koha/intranet/modules bulkmarcimport.pl -file emcs2.mrc Output is this: DBD::mysql::db do failed: Access denied for user: 'koha_admin@localhost' to database 'koha' at /home/rsnsw/koha/intranet/modules/C4/Biblio.pm line 289. DBD::mysql::db do failed: Access denied for user: 'koha_admin@localhost' to database 'koha' at /home/rsnsw/koha/intranet/modules/C4/Biblio.pm line 371. DBD::mysql::db do failed: Access denied for user: 'koha_admin@localhost' to database 'koha' at /home/rsnsw/koha/intranet/modules/C4/Biblio.pm line 371. 1 MARC record done in 0.469326972961426 secondsmisc$ Note that there are 3 error messages for this 1 record. Using David Bigwoods data there are lots of the same above errors. I have exported KOHA_CONF=/etc/koha.conf and koha.conf is readable by ugo so bulkmarcimport can read it OK. The user 'koha_admin' is in koha.conf and the password, lets say its 'secret'. I can access the mysql koha database like this OK mysql -u koha_admin -psecret koha mysql> and in the mysql user table there is the entry user=koha_admin and Host=localhost so bulkmarcimport should have no problems connecting to the koha database ! There is no version number in the bulkmarcimport script to report. Im using the one from the koha 2.0.1 tarball. Mike Joshua Ferraro wrote:
Hi Pierre, What version of Koha are you running? That error looks to me (at first glance) like a potential bug in the module's method for building the user@host string. Let me know what version of the Biblio.pm module you're running and I'll check it out. Anyone else have any other ideas?
On Fri, Nov 05, 2004 at 11:43:02AM -0800, pierre pierre wrote:
Dear Joshua,
Thanks for your help. Indeed after a little perl -MCPAN -e 'install "Time::HiRes"' (to avoid the ?Can't locate Time/HiRes.pm in @INC? message) the sript starts its process.
But then I have a similar error message to the one Mike has: DBD::mysql::db do failed: Access denied for user 'kohaadmin'@'localhost' to database 'Koha' at /usr/local/koha/intranet/modules/C4/Biblio.pm line 330.
With MySQL Query Browser I do not have any problem to connect with the kohaadmin user using the password I defined during the installation of Koha.
-- Michael Lake Chemistry, Materials & Forensic Science, UTS Ph: 9514 1725 Fx: 9514 1460 -- UTS CRICOS Provider Code: 00099F DISCLAIMER: This email message and any accompanying attachments may contain confidential information. If you are not the intended recipient, do not read, use, disseminate, distribute or copy this message or attachments. If you have received this message in error, please notify the sender immediately and delete this message. Any views expressed in this message are those of the individual sender, except where the sender expressly, and with authority, states them to be the views the University of Technology Sydney. Before opening any attachments, please check them for viruses and defects.