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

Linux distribution with Koha?
by Krishnan Mani 01 Dec '08

01 Dec '08

Hello, Thanks to the help of various people on this list, a friend and i managed to get Koha installed on a PC in a location that had no internet access. We took the kitchen sink approach: download the necessary .rpms, Koha 3.0, and (!) the entire CPAN archive, ship these across on suitable storage media, and run through the installation a couple of times by trial and error to get things right. But, of course, all of this, (especially a 6 gig CPAN archive) is definitely more than what Koha itself needs. We have now gathered enough courage to think that we should create a whole Linux distribution that is focused on Koha. The basic idea is: "Install this OS and you have Koha up and running." Perhaps, if we focused closely enough on what most libraries (and most non-technical users) really need, it might even be easier to install and get everything running than even a regular Linux install. So, i think we need inputs on more than a few things: a) What libraries and librarians (professional and otherwise) really need from their Koha servers? Perhaps you need some basic tools to edit Marc records, or create some spreadsheets. Perhaps you need some reasonable system administration tools and enough stuff lying around to add your own custom scripts... b) On the technical front, what does Koha really need for a full install? For e.g., it probably uses a few dozen Perl modules, which in turn need (a lot?) more dependencies on other Perl modules, etc.? I'd like the tech gurus advice on how to construct the essential "bill of material" for what needs to be assembled to create the distrib. i haven't even begun to look for the answers. i know that there are perhaps a lot of questions and opinions and experiences to share. This probably needs its own place that people can go to contribute, debate, etc. If that really is the case, i can put together a separate website (or part of the Wiki?) that can be used to collect all your help and useful information. i also get the feeling that there are probably things to fix with the Koha installation process itself before we can think of making it to a distribution. Thanks and regards, krishnan mani Pune, India Add more friends to your messenger and enjoy! Go to http://messenger.yahoo.com/invite/

2 1

Best server Computer for Koha
by mikyas hailu 29 Nov '08

29 Nov '08

Hey All, Please inform us the best server suitable to koha. Regards,

2 1

Re: [Koha-devel] Koha-devel Digest, Vol 36, Issue 41
by vijaya kumar 28 Nov '08

28 Nov '08

I WANT TO USE KOHA SOFTWARE FOR OUR LIBRARY AUTOMATION. PLEASE SEND SHORT CUT METHOD FOR KOHA INSTALLATION. AS EARLY AS POSSIBLE. YOURS SINCERLY DR.JVK On Thu, Nov 27, 2008 at 4:30 PM, <koha-devel-request(a)lists.koha.org> wrote: > Send Koha-devel mailing list submissions to > koha-devel(a)lists.koha.org > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists.koha.org/mailman/listinfo/koha-devel > or, via email, send a message with subject or body 'help' to > koha-devel-request(a)lists.koha.org > > You can reach the person managing the list at > koha-devel-owner(a)lists.koha.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Koha-devel digest..." > > > Today's Topics: > > 1. Re: Koha PEOPLE Efficiency [WAS: RFC: Koha : Merge biblio & > biblioitems tables] (Rick Welykochy) > 2. Re: mod_perl (Wojciech Zatorski) > 3. Re: [RFC ver2 4/4] DBIx::Class - Changes to C4::Members to > start using DBIx::Class (Paul POULAIN) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 27 Nov 2008 05:41:10 +1100 > From: Rick Welykochy <rick(a)praxis.com.au> > Subject: Re: [Koha-devel] Koha PEOPLE Efficiency [WAS: RFC: Koha : > Merge biblio & biblioitems tables] > To: Andrew Moore <andrew.moore(a)liblime.com> > Cc: "koha-devel(a)lists.koha.org" <koha-devel(a)lists.koha.org> > Message-ID: <492D9846.4030504(a)praxis.com.au> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > Andrew Moore wrote: > > > On Tue, Nov 25, 2008 at 5:40 PM, Rick Welykochy <rick(a)praxis.com.au> > wrote: > >> <RANT> > >> > >> I am *VERY* concerned about people performance. To wit: > > > > Hi Rick - I'm thankful for your rant. Not only do I agree that we're > > suffering from some technical debt that makes contributions more > > difficult, time consuming, and laborious, but I see notes like yours > > as more of a motivational encouragement than a repetition of old > > arguments. I try to make my new code better than what came before it, > > and to make some of the surrounding code a little better, too. I hope > > you do the same and to help me and others improve. > > [SNIP] > > Thanks Andrew for taking the time to move my <RANT> forwards to suggestions > for some positive action. That is of course what we need here. > > I am taking onboard all of your recommendations ... one could become *very* > busy dipping into all of these pies. I'll see what fits my spare time and > "esprit". > > And I haven't forgotten about your ORM work and suggestions. I just have to > get that darn perl modules installed in a clean install of Koha, which > takes > finding a spare (virtual) host somewhere. > > Hrrmmm ... this brings up another topic: Koha dev environments. > But I'll leave that for another posting. > > > cheers > rickw > > > > -- > _________________________________ > Rick Welykochy || Praxis Services > > You go find out what they need and I'll start coding. > -- two geeks > > > ------------------------------ > > Message: 2 > Date: Wed, 26 Nov 2008 20:03:23 +0100 > From: Wojciech Zatorski <listy-in(a)zatorski.net> > Subject: Re: [Koha-devel] mod_perl > To: Koha-devel <koha-devel(a)lists.koha.org> > Message-ID: <405097270.20081126200323(a)zatorski.net> > Content-Type: text/plain; charset=Windows-1250 > > Hello Joe, > > Wednesday, November 26, 2008, 4:48:56 PM, you wrote: > > JA> Wojciech -- > > JA> Obviously 3 years ago would have been with a 2.2 (or perhaps > JA> earlier?) version of Koha.? Have you upgraded to 3.x under the > JA> same environment? > > yes.. version 2.2.x and no we still using 2.2.x as framework. > > JA> ? Can you also confirm that you have multiple > JA> Koha databases running concurrently on the same server? > > yes on version 2.2.x we have multiple KOHA installation (perl code > shared). > > my $r = Apache2::RequestUtil->request( ); > $conf_fname = $r->dir_config('KOHA_CONF'); > > -- > The Main Library of Szczecin University. > Computerization Department. > http://bg.univ.szczecin.pl > > > > ------------------------------ > > Message: 3 > Date: Thu, 27 Nov 2008 09:12:38 +0100 > From: Paul POULAIN <paul.poulain(a)free.fr> > Subject: Re: [Koha-devel] [RFC ver2 4/4] DBIx::Class - Changes to > C4::Members to start using DBIx::Class > To: "koha-devel(a)lists.koha.org" <koha-devel(a)lists.koha.org> > Message-ID: <492E5676.1070900(a)free.fr> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > Rick Welykochy a ?crit : > > Paul POULAIN wrote: > > If by "user" you are referring to the librarian or Koha user, then > > it is up to the Koha application to intercept and process the above > > error if it does happen and take remedial action, i.e. send an indignant > > email to Koha-dev! > > > > Given that you *cannot* create invalid FK relationships in the database, > > I don't see how anything could fail using FK constraints. They are a > > Good Thing (tm) and are required to avoid orphaned child records > > amongst many other things. > > I know what is a FK done for, Rick (and in fact I'm the author of most > of the FK in the DB atm ;-) ) > What is a shame is that the librarian can enter something, enter "OK", > and ... see nothing ... the value hasn't be added due to a FK error, and > nothing on the browser : everything seems OK ! Quite annoying for the > librarian ! > > We can't ask the librarian to look in error.log ! So we need to display > something on the browser, like "Oups, something goes wrong. Ask the Koha > team and specify the following problem : "FK contraint at xxxxx.pm, line > YYY, koha version X.XX.XX.XXX" " > > Fortunatly, those errors are very uncommon, and I think I've seen them > occuring only when a part of the DB has been entered through SQL insert > & not the browser. But we should trap that anyway ! (as we should trap > any SQL error) > > > -- > Paul POULAIN > http://www.biblibre.com > Expert en Logiciels Libres pour l'info-doc > NOUVEAU TELEPHONE : 04 91 81 35 08 > > > ------------------------------ > > _______________________________________________ > Koha-devel mailing list > Koha-devel(a)lists.koha.org > http://lists.koha.org/mailman/listinfo/koha-devel > > > End of Koha-devel Digest, Vol 36, Issue 41 > ****************************************** > -- Dr.J.Vijaya Kumar Engineering College Library Andhra University Visakhapatnam- 530 003 Phones: Res : (0891) 2718711 M : 9440503562 E-Mail Address: kumarjammala(a)gmail.com kumarjammala(a)rediffmail.com jammalamadakavijayakumar(a)yahoo.com

1 0

Re: [Koha-devel] mod_perl (was: DBIx::Class stuff)
by Andrew Moore 26 Nov '08

26 Nov '08

On Sat, Nov 22, 2008 at 7:24 PM, Rick Welykochy <rick(a)praxis.com.au> wrote: > Joshua Ferraro wrote: > >> Speed is definitely a major concern here ... and I believe it's one of >> the reasons that Koha originally wasn't written with an ORM. Andy, any >> thoughts about what this choice will mean w/respect to performance? > > The use of mod_perl would speed things up by an order (and a half) > of magnitude, giving the software more leeway to use abstractions > like an OR mapper. Hi Rick - I've long suspected that Koha could benefit from using mod_perl, too. Do you know of any work done to see if it's possible or what changes would need to be made in order to allow it? Thanks, -Andy

11 19

Label and barcode generator broken
by Bernard Shiundu 26 Nov '08

26 Nov '08

Just noticed that the label generator seems broken ... While it still does produce the barcode numbers with the guide boxes, It doesn't generate the actual barcodes anymore. A peek at the logs shows first >> stack underflow:tags stack is empty, referer: http://<myserver>/cgi-bin/koha/labels/label-manager.pl?op=add_batch&type=labels<http://%3cmyserver%3e/cgi-bin/koha/labels/label-manager.pl?op=add_batch&type=labels> Then later on >> label-print-pdf.pl: failed to parse label formatstring: io and barcode at /opt/koha/src/C4/Labels.pm line 862., referer: http://<myserver>/cgi-bin/koha/labels/label-manager.pl?op=add&batch_id=1&itemnumber=1&itemnumber=2&itemnumber=3<http://%3cmyserver%3e/cgi-bin/koha/labels/label-manager.pl?op=add&batch_id=1&itemnumber=1&itemnumber=2&itemnumber=3> This is both on version 3.00.00.107 with perl 5.008008 and on 3.01.00.003 with perl 5.010000 ... Anyone else seen this before I go ahead and file a bug report? Bernard Shiundu Strathmore University Nairobi, Kenya ________________________________ Strathmore University provides all-round education in an atmosphere of freedom and responsibility. This email and any files transmitted with it are intended solely for use by the recipient(s) to whom it is addressed and may contain confidential information. If you have received this email in error please notify the sender immediately and permanently delete this email and/or any files attached to it from your computer. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Strathmore University. The University accepts no liability whatsoever for any loss or damages incurred, or suffered, resulting, or arising, from the use of this email and/or its attachments. The University warrants neither the integrity of the e-mail nor its freedom from errors, viruses, interception or any other form of interference.

4 3

Account types in Koha
by Allen Reinmeyer 26 Nov '08

26 Nov '08

In an effort to add some functionality to the fines management, I've added to the RFC for fines thresholds all of the account types I've found in Koha. It's probably not a complete list yet, especially in respect to understanding what all the fines mean. If anyone has insight, feel free to add to the descriptions. At a minimum, I expect to pull all account types out of the code and into a table. I would like to consolidate types where possible and provide a standard interface to account types. If any types are missing, feel free to add those as well. Thank you, -- Allen Reinmeyer LibLime Developer allen.reinmeyer(a)liblime.com

2 2

Koha presentation at IFLA Milan 2009 ?
by Zeno Tajoli 25 Nov '08

25 Nov '08

Hi to all, reading the subject 'Koha Con 2009' I think that I need to write this message. This year IFLA congress will be in Milan 23-27 August. Many of you think to be here ? I probably be one of the voluntairs. If BibLime or some other buys a stand in the Exbion section, good thing but it is quite expensive. If we want to do a more informal exbition to first time users or no users of Koha, I can offer a place in Milan (not very near to Congress site but with public transport easy) that can be used for a presentation day. I suggest wensday 26 august (the day of 'free' of the congress). Bye to all. Zeno Tajoli CILEA - Segrate (MI) tajoliAT_SPAM_no_prendiATcilea.it (Indirizzo mascherato anti-spam; sostituisci quanto tra AT con @)

2 2

See information in OPAC
by Emmanuel Enciso 25 Nov '08

25 Nov '08

Hi, I´ve some problems with my database, I imported 15,000 records in MARC21 format in MARC_BREEDING table, but I can´t see in OPAC module. I know there is a process that I have to run but one by one. Is there way or process to see all records in OPAC module? Thanks Emmanuel _________________________________________________________________ Live Search premia tus búsquedas, llévate hasta ¡Un Auto! http://www.ganabuscando.com/Default.aspx

2 1

bumping the authorised_values.category column to 20 chars ?
by Mason James 24 Nov '08

24 Nov '08

Hi folks Any objections to bumping the authorised_values.category column to say.. 20 chars?? I'm having to make my new auth categories a little terse/cryptic because of the current 10 char limit mysql> describe authorised_values; +------------------+--------------+------+-----+--------- +----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+--------------+------+-----+--------- +----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | category | varchar(10) | NO | MUL | | | <<<<<< | authorised_value | varchar(80) | NO | | | | | lib | varchar(80) | YES | | NULL | | | imageurl | varchar(200) | YES | | NULL | | +------------------+--------------+------+-----+--------- +----------------+ 5 rows in set (0.00 sec) Good idea or Bad idea ? Mason.

5 7

Koha Con 2009? with Development time?
by David Schuster 22 Nov '08

22 Nov '08

There is a question on the table if this meeting announced as an American Conference for Koha should be more like a Koha Con 2009 with the format similar to 2006. With that we would like to schedule a meeting to discuss on IRC the KohaCon possibility. Who wants/would be interested in attending this IRC (and eventually a full conference?) What days of the week are best for this IRC? Times are best for you - GMT for this IRC? - http://wwp.greenwichmeantime.com/ In this discussion we would talk if a developer meeting is of interest? Should it be pre or post the Conferece that is being planned for April 16/17 in the US? How much time should be considered 1 or 2 days? What should those days look like? Where is the best place to house them(how many is of concern along with other needed items if they are to meet) In addition I would love to hear any input this group might have for the April 16/17 "conference" as well. Presentations - workshop etc... how it should be structured for a meeting of users and developers. Sincerely, David Schuster LibLime customer -- View this message in context: http://www.nabble.com/Koha-Con-2009--with-Development-time--tp20628172p2062… Sent from the Koha - Dev mailing list archive at Nabble.com.

2 2