July 2007 - Koha-bugs - lists.koha-community.org

[Bug 1382] New: Koha fails to install when MySQL DB is on localhost
by bugzilla-daemon＠pippin.metavore.com 09 Jul '07

09 Jul '07

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1382 Summary: Koha fails to install when MySQL DB is on localhost Product: Koha Version: 2.2.9 Platform: PC OS/Version: Linux - Gentoo Status: NEW Severity: normal Priority: P3 Component: Installation AssignedTo: mjr(a)ttllp.co.uk ReportedBy: dswhite42(a)spambob.com QAContact: koha-bugs(a)nongnu.org I'm trying to install Koha 2.2.9 on a Gentoo Linux box (kernel 2.6.20) w/MySQL 5.0.40 . (I know MySQL 5 isn't fully supported yet, but I don't think this is a v4-vs-v5 issue). During the installation, I use the default of "localhost" for the database host, then choose "kohaadmin" as my user, and (e.g.) "foobar" for a password. Later, when the installer tries to create the database, I get back this message: --------------------------------------------------------- Creating the MySQL database for Koha... ERROR 1045 (28000): Access denied for user 'kohaadmin2'@'localhost' (using password: YES) DBI connect('Koha:localhost','kohaadmin2',...) failed: Access denied for user 'kohaadmin2'@'localhost' (using password: YES) at /usr/local/koha/intranet/modules/C4/Context.pm line 411 Can't call method "prepare" on an undefined value at scripts/updater/updatedatabase line 1553. Problem updating database... --------------------------------------------------------- The database is created, but it's not being populated correctly due to some permission problems. Looking at my MySQL debug logs, I see this line: GRANT ALL PRIVILEGES on Koha.* to 'kohaadmin' IDENTIFIED BY 'foobar' Now, this syntax doesn't appear to be correct for either MySQL 4.1 or MySQL 5.0 . According to both http://dev.mysql.com/doc/refman/4.1/en/adding-users.html and http://dev.mysql.com/doc/refman/5.0/en/adding-users.html , if you want a user to have localhost access, it's necessary to explicitly specify that in the GRANT ALL PRIVILEGES string. (the default GRANT string, which is used by Install.pm, grants privileges to the user from any host OTHER THAN localhost.) So to fix this, I edited Install.pm and changed line 1803 from this: system("$mysqldir/bin/mysql '-u$mysqluser' -e \"GRANT ALL PRIVILEGES on ".$database.".* to '$user' IDENTIFIED BY '$pass' \" mysql"); to these two lines: system("$mysqldir/bin/mysql '-u$mysqluser' -e \"GRANT ALL PRIVILEGES on ".$database.".* to '$user'\@'localhost' IDENTIFIED BY '$pass' \" mysql"); system("$mysqldir/bin/mysql '-u$mysqluser' -e \"GRANT ALL PRIVILEGES on ".$database.".* to '$user'\@'%' IDENTIFIED BY '$pass' \" mysql"); Just thought I'd pass it along. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 1316] Cardnumber is not a required field and adding a borrowers with a blank cardnumber fails
by bugzilla-daemon＠pippin.metavore.com 09 Jul '07

09 Jul '07

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1316 chris.cormack(a)liblime.com changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED ------- Comment #1 from chris.cormack(a)liblime.com 2007-07-08 16:46 ------- Fixed when fixing 1295 this morning ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 1300] Catalogue statistics document type doesn't use itemtype or any other value in the drop down
by bugzilla-daemon＠pippin.metavore.com 09 Jul '07

09 Jul '07

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1300 chris.cormack(a)liblime.com changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |WORKSFORME ------- Comment #1 from chris.cormack(a)liblime.com 2007-07-08 16:45 ------- Hmm seems to work ok for me http://staff.v3.kohalibrary.com/cgi-bin/koha/reports/catalogue_stats.pl ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 1376] export.pl downloads a perl script instead of exporting MARC
by bugzilla-daemon＠pippin.metavore.com 09 Jul '07

09 Jul '07

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1376 chris.cormack(a)liblime.com changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |RESOLVED Resolution| |FIXED ------- Comment #2 from chris.cormack(a)liblime.com 2007-07-08 16:23 ------- Fixed in cvs ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 1376] export.pl downloads a perl script instead of exporting MARC
by bugzilla-daemon＠pippin.metavore.com 09 Jul '07

09 Jul '07

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1376 chris.cormack(a)liblime.com changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED ------- Comment #1 from chris.cormack(a)liblime.com 2007-07-08 16:13 ------- Ahh it is downloading marc, its just called export.pl Will fix now ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 1295] Adding a new borrower with the same cardnumber as another borrower
by bugzilla-daemon＠pippin.metavore.com 09 Jul '07

09 Jul '07

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1295 chris.cormack(a)liblime.com changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |RESOLVED Resolution| |FIXED ------- Comment #2 from chris.cormack(a)liblime.com 2007-07-08 16:05 ------- Fixed in CVS. Can no longer have 2 borrowers with the same cardnumber ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 1381] New: Need to forward-port label printing to 3.0
by bugzilla-daemon＠pippin.metavore.com 09 Jul '07

09 Jul '07

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1381 Summary: Need to forward-port label printing to 3.0 Product: Koha Version: HEAD Platform: All OS/Version: All Status: NEW Severity: blocker Priority: P3 Component: Reports AssignedTo: chris.cormack(a)liblime.com ReportedBy: jmf(a)liblime.com QAContact: koha-bugs(a)nongnu.org ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 1380] New: Need to forward-port corporate serials to 3.0
by bugzilla-daemon＠pippin.metavore.com 09 Jul '07

09 Jul '07

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1380 Summary: Need to forward-port corporate serials to 3.0 Product: Koha Version: HEAD Platform: All OS/Version: All Status: NEW Severity: blocker Priority: P3 Component: Serials AssignedTo: chris.cormack(a)liblime.com ReportedBy: jmf(a)liblime.com QAContact: koha-bugs(a)nongnu.org Need to forward-port corporate serials to 3.0 ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 1379] New: what happened to Catalog Maintenace?
by bugzilla-daemon＠pippin.metavore.com 09 Jul '07

09 Jul '07

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1379 Summary: what happened to Catalog Maintenace? Product: Koha Version: HEAD Platform: All OS/Version: All Status: NEW Severity: normal Priority: P3 Component: MARC AssignedTo: chris.cormack(a)liblime.com ReportedBy: jmf(a)liblime.com QAContact: koha-bugs(a)nongnu.org Catalog maintenance seems to have vanished for 3.0 ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 1378] New: Bunch of patrons issues with 3.0
by bugzilla-daemon＠pippin.metavore.com 09 Jul '07

09 Jul '07

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1378 Summary: Bunch of patrons issues with 3.0 Product: Koha Version: HEAD Platform: All OS/Version: All Status: NEW Severity: normal Priority: P3 Component: Members AssignedTo: chris.cormack(a)liblime.com ReportedBy: jmf(a)liblime.com QAContact: koha-bugs(a)nongnu.org Patrons: * It doesn't look like you can change the borrower type after the patron has been added. I don't see how to change a "professional" to something else. * a child can't have two parents * if it's multi-step, it should say (1 of 3) * lost link to issues from the borrower detail screen * We should use the calendar picker on the issues screen instead of those drop-downs for 'specify due date' * circulation.tmpl warndeparture? * patronimages stuff - don't lose it * undebar patron if all items are returned ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0