November 2002 - Koha-devel - lists.koha-community.org

New configuration/install script
by Andrew Arensburger 20 Nov '02

20 Nov '02

As I mentioned on IRC a while back, I've been working on a new configuration/installation script for Koha. Now I've uploaded a first draft to the CVS main branch, to give people a look at it. Just run "safe-installer". This is nowhere near complete, but it should be enough for people to tell whether I'm on the right track or not, and whether I should continue. Currently, this script only installs and/or upgrades the Koha database. Some features of note: - The current 'installer.pl' asks a question, makes a change to the system, asks the next question, makest the next change, and so forth. 'safe-installer', on the other hand, asks all of the questions up front, and only then installs everything. This way, if you interrupt it before it's done, you don't wind up with a half-completed installation. - 'safe-installer' doesn't actually do anything itself. There's a Makefile to do the real work of creating the database, installing the web files, etc. This way, you don't have to be root to do the configuration. You might not even have to be root to do the installation. - 'safe-installer' works by creating a "Make.conf" file that contains the configuration values that will be used by 'make'. The advantage of this is that if someone wants to write a Koha RPM/port/apt/package/whatever, they can simply create "Make.conf" and use 'make install', thereby bypassing the interactive installer. - I've thrown in "install-sh", because Koha really ought to be portable, but not every OS has a BSD-compatible 'install' tool, nor does every OS support 'mkdir -p'. 'install-sh' does all of this, and is in the public domain, which should be GPL-compatible. A note in passing: one fairly interesting aspect of this script is that it involves a completely different type of optimization than I'm used to. Normally, when you're trying to estimate the speed of a program, you assume that all atomic operations (integer addition and multiplication, if-then, comparisons, etc.) all take the same amount of time. Here, however, an 'if' statement could take tens of seconds, if it involves getting input from the user. So the trick is to optimize for user time by asking as few questions as possible (in the average case, at least), while at the same time keeping them clear enough to give Joe Average User an idea of what's going on. -- Andrew Arensburger This message *does* represent the arensb(a)ooblick.com views of ooblick.com Build a better mousetrap and the world will immediately get their fingers caught in it.

4 3

[Bug 128] Failure to load MARC records gives no feedback
by bugzilla-daemon＠wilbur.katipo.co.nz 19 Nov '02

19 Nov '02

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=128 ------- Additional Comments From a.c.li(a)ieee.org 2002-11-20 09:41 ------- Oh, it is DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/koha/intranet/cgi-bin/acqui.simple/marcimport.pl line 823, <fh00001EXPORT\.TXT> line 1. I guess it's a MySQL config problem, but Koha should still catch the error condition and produce some feedback, I think... ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 124] Issue due date
by bugzilla-daemon＠wilbur.katipo.co.nz 19 Nov '02

19 Nov '02

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=124 tonnesen(a)cmsd.bc.ca changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED ------- Additional Comments From tonnesen(a)cmsd.bc.ca 2002-11-19 07:49 ------- Discussion on the mailing list made this out as a feature instead of a bug, although a warning should be issued in case the due date is set in error to a date which is already passed. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

3 2

koha 1.3.2 => question before releasing
by paul POULAIN 18 Nov '02

18 Nov '02

Hi everybody, I plan to release a 1.3.2 version soon. what works in this version : * you can manage MARC biblios (add, modify...) and items * you can "link" a MARC subfield to any "old-DB" field : both db are managed in parallel, and if you modify a value in a MARC biblio, the corresponding value is modified in old-DB. * you can "link" a MARC subfield to 4 differents behaviours : - "free value" => whatever you want - "authorised value" => any value of a specified category. You can define as many categories as you want, and as many values as you want - "authority value" => any value in authority file. - "plug_in value" => the value is calculated through a "plugin" script. This possibility still needs documenting, but works nicely. So, i'm entering a "beta-test" phase now. It means i'm playing with koha, and tracking things i hadn't imagined... I encounter a "little problem" : some values, like, for example "biblioitem.itemtype" are mapped to a specific table. But if you don't use an "itemtypes" value in the MARC subfield "itemtype", koha goes woo-woo, as consistency is broken. My question is : can someone give me a complte list of such links. I'm speakins of links between biblio, biblioitems and items and other tables. What i already know : * no links in biblio * biblioitems.itemtype => itemtypes.itemtype * items.booksellerid => booksellerid * items.homebranch => ??? * items.holdingbranch => ??? Am i missing others ? Note : i'm working since nov,1st with a "french UNIMARC" version : works nicely, as nicely as the "english USMARC" one. I'm quite happy ;-) -- Paul

1 0

[Bug 126] MySQL password not quoted
by bugzilla-daemon＠wilbur.katipo.co.nz 18 Nov '02

18 Nov '02

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=126 tonnesen(a)cmsd.bc.ca changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED ------- Additional Comments From tonnesen(a)cmsd.bc.ca 2002-11-19 07:47 ------- Patch applied. Thanks. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 128] Failure to load MARC records gives no feedback
by bugzilla-daemon＠wilbur.katipo.co.nz 18 Nov '02

18 Nov '02

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=128 tonnesen(a)cmsd.bc.ca changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED OS/Version| |All ------- Additional Comments From tonnesen(a)cmsd.bc.ca 2002-11-19 07:45 ------- The Upload facility was not intended to handle bulk importing of MARC records. There is a command line tool (bulkmarcimport.pl) for importing large quantities of MARC records. Still, I'm not sure where this error is coming from. The uploadedmarc's marc field is defined as LONGBLOB which is capable of storing much more than 1.7MB. Is there any error in the apache error log files when you attempt to upload the file? ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 127] Can't delete dangling biblio item
by bugzilla-daemon＠wilbur.katipo.co.nz 18 Nov '02

18 Nov '02

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=127 tonnesen(a)cmsd.bc.ca changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED OS/Version| |All ------- Additional Comments From tonnesen(a)cmsd.bc.ca 2002-11-19 07:39 ------- If you didn't enter an item then there is no item to search for, is there? You should be able to search for the title or author and it will show a page with the biblio information, but no items listed. You can delete the biblio record from this page. If this isn't working then this _is_ a bug. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 98] Portability problem with field names
by bugzilla-daemon＠wilbur.katipo.co.nz 16 Nov '02

16 Nov '02

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=98 a.c.li(a)ieee.org changed: What |Removed |Added ---------------------------------------------------------------------------- Component|Database |Installation ------- Additional Comments From a.c.li(a)ieee.org 2002-11-17 07:53 ------- DATETIME does not seem to be a SQL reserved word, so MySQL versions that treat it as reserved should be considered buggy. The installation notes and/or FAQ should be updated to note that any user encounting this problem (and the missing index_priv column) with their MySQL versions should be upgrade. (What is the minimum MySQL version that is ok?) The installer should probably also check for the MySQL version. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 128] New: Failure to load MARC records gives no feedback
by bugzilla-daemon＠wilbur.katipo.co.nz 16 Nov '02

16 Nov '02

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=128 Summary: Failure to load MARC records gives no feedback Product: Koha Version: 1.2.3 Platform: PC Status: NEW Severity: normal Priority: P2 Component: Acquisitions (Simple) AssignedTo: tonnesen(a)cmsd.bc.ca ReportedBy: a.c.li(a)ieee.org QAContact: koha-devel(a)lists.sourceforge.net I tried to upload 1.7 MB of MARC records to 1.2.3RC23. It seems to ignore it, without giving any error or warning message. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

2 1

[Bug 127] New: Can't delete dangling biblio item
by bugzilla-daemon＠wilbur.katipo.co.nz 14 Nov '02

14 Nov '02

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=127 Summary: Can't delete dangling biblio item Product: Koha Version: 1.2.3 Platform: PC Status: NEW Severity: normal Priority: P2 Component: Acquisitions (Simple) AssignedTo: tonnesen(a)cmsd.bc.ca ReportedBy: a.c.li(a)ieee.org QAContact: koha-devel(a)lists.sourceforge.net If I do a simple acquisition, finish entering the biblio info, and decide to not proceed with entering the rest of the item info, I get a biblio record in the database, but no items referring to it. I can't search for the item, and I can't delete it because deleting requires a successful search first. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0