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

Re: [Koha-devel] Road Types
by Nicole Engard 13 Jan '10

13 Jan '10

I love that idea!! I'm going to submit it as a suggested enhancement via bugs.koha.org. Nicole On Wed, Jan 13, 2010 at 12:24 AM, Pablo A. Bianchi <pbianchi(a)fi.uba.ar> wrote: > On Mon, Jan 4, 2010 at 1:37 PM, Nicole Engard <nengard(a)gmail.com> wrote: >> >> We need a consensus of sorts on an issue that has a few bugs >> associated with it. In America addresses go 'street number' 'street >> name' 'street type' -- in France it goes 'street number' 'street type' >> 'street name' > > in Spanish it goes 'street type' 'street name' 'street number'. > >> >> This is coming across as a display problem on the patron records. So >> I'm wondering if there is a way that we can set up the templates to >> display the address in the way that the librarian chooses. Right now >> there are a few bugs related to the fact that the street number >> and/order street type doesn't even display - when I went to fix them I >> realize (with Owen's help) that I might be causing some >> internationalization issues - so I wanted to consult with you all on >> what we think is the best way to tackle this. > > There are only 6 ( factorial(3) ) possibilities. A drop-down menu on system > preferences? (I18N/L10N?) > >

1 0

Web crawlers hammered our Koha multi server
by Rick Welykochy 13 Jan '10

13 Jan '10

Hi all We are running several instances of Koha on the one box using Linux Vserver. The other night the server was brought to its knees and mysql ran out of free connections. Further investigation found over 80 instances of perl + Apache running OPAC search queries. There were many attendant instances of Zebra spawned as well, seeing to these searches. Once our daily backup kicked in at the same time, all hades broke lose. We were DoS'd at one stage and had to remote reboot the thing. How did the web crawlers find our obscure site? Probably due to a URL containing a search being posted to a web site. After some thought, two of us came up with a simple solution to solve this situation. The Problem: the OPAC search and OPAC advanced searches are accessible by the public from the Koha OPAC home page. Consequently, an over zealous web crawler indexing the site using the opac-search.pl script can impact the performance of the Koha system. In the extreme, an under- resourced system can experience a DoS when the number of searches exceeds the capacity of the system. The Solution: modify the opac-search.pl script in the following manner: (A) Only allow queries using the POST method; otherwise if GET is used return a simple page with "No search result found". (B) Exception: do allow GET queries but only if the HTTP_REFERER matches the SERVER_NAME. This allows all the searches to work via web site links. Here is the small code segment added to opac-search.pl, immediately after the BEGIN block: if ($ENV{HTTP_REFERER} !~ /$ENV{SERVER_NAME}/ && $ENV{REQUEST_METHOD} ne "POST") { print "Content-type: text/html\n\n"; print "<h1>Search Results</h1>Nothing found.\n"; exit; } CAVEAT: This solution does not allow one to paste an "opac_search.pl" link into the browser and have it work as previously expected. But this was the cause of the problem in the first place. A better solution is to require a user to login to the OPAC before allowing a search. Addendum: also install a robots.txt file at the following location in the Koha source tree: opac/htdocs/robots.txt The robots.txt file should contain the following contents, which deny all access to indexing engines. You can learn more about robots.txt on the web, and configure it to allow some indexing if you wish. ----------------------------- User-agent: * Disallow: / ----------------------------- I plan to submit a bug report regarding this situation, but first open it up for discussion here. cheers rickw -- _________________________________ Rick Welykochy || Praxis Services If you have any trouble sounding condescending, find a Unix user to show you how it's done. -- Scott Adams

4 6

Use of TMPL_IF EXPR
by Owen Leonard 12 Jan '10

12 Jan '10

Re: Bug 2670 (http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=2670) Is it possible to set up guidelines under which EXPR is allowed? If we can confirm that variables will be output under all circumstances would an EXPR be allowed? -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org

5 5

Stack smashing resolved -- we think
by Chadwick, John, DCA 11 Jan '10

11 Jan '10

Okay, it looks like the stack smashing issue has been resolved through increased allocation of memory in several places on the MySQL server. Our server has 8GB of memory with a quad core processor. I allocated 1000GB to the MyISAM sort buffer size. I also increased the key buffer size. I found a few things about memory, but not much, on the Koha Wiki. I would like to hear from others what you have found to be optimal memory allocation for MySQL with about 20,000 bibs. Also, what would the optimal memory allocation for Zebra to use for indexing (or reindexing). Thanks, John Chadwick John.Chadwick(a)state.nm.us http://www.nmstatelibrary.org <http://www.nmstatelibrary.org/> Confidentiality Notice: This e-mail, including all attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited unless specifically provided under the New Mexico Inspection of Public Records Act. If you are not the intended recipient, please contact the sender and destroy all copies of this message. -- This email has been scanned by the Sybari - Antigen Email System. ______________________________________________________________________ Confidentiality Notice: This e-mail,including all attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review,use,disclosure or distribution is prohibited unless specifically provided under the New Mexico Inspection of Public Records Act. If you are not the intended recipient, please contact the sender and destroy all copies of this message. This email has been scanned using Webroot Email Security. ______________________________________________________________________

3 5

koha with better support for postgresql
by ricardo mendoza 11 Jan '10

11 Jan '10

Hi all, at this time how to improve support for koha to use postgresql, someone could explain that you can do to make fully functional koha with postgresql.I see that postgresql offers many features than can koha use managed to improve its performance. I like to explore the possibility of starting to develop the necessary code for koha to make a complete and functional use of all PostgreSQL features, with the help of experienced developers. Thank you, Ricardo

6 10

The OLE Project news: Funding goes to (closed) Kuali Foundation: open source administrative software for higher education, by higher education
by Irma Birchall 11 Jan '10

11 Jan '10

Hi all, You might wish to know that Indiana University has been awarded US$2.38 million from The Andrew W. Mellon Foundation to develop library software. The article does not mention if any or which currently available open source code will be used. Even with US$2.38 can all wheels be reinvented? Who will get the credit at the end of the day? Read more about it here http://kuali.org/node/268 Some sentences from the article are copied below: "Brad Wheeler, Kuali Foundation board chair and vice president for information technology at IU says: "We are grateful for their support of this open, extensible and deeply collaborative work among the OLE investing libraries. The libraries' choice to anchor the project in the Kuali Foundation will ensure its quality, openness and sustainability for years to come."" "IU will lead the Kuali OLE (Open Library Environment) project, a partnership of research libraries dedicated to managing increasingly digital resources and collections. Together, these libraries will develop "community source" software that will be made available to libraries worldwide." "The Kuali OLE collaboration comes at the perfect time," said Deborah Jakubs, Rita DiGiallonardo Holloway University Librarian and vice provost for library affairs at Duke University. "If libraries are to provide excellent support for scholarship and teaching well into the future, we must develop a new model that reflects the true needs of our organizations and facilitates our work in a constantly changing environment. This partnership capitalizes on the experience, the commitment and the energy of a key group of institutions to build that model for the future of research library operations." "An accomplished team of librarians select, manage and grow Indiana University's research collections, which include more than 6.6 million books and materials in more than 350 languages. The materials support every academic discipline on campus, with an emphasis in the humanities and social sciences. Collections also include journals, maps, films and sound recordings. Users can access more than 692 databases, 60,315 electronic journals, and 816,255 electronic books, as well as locally developed digital content." Best regards, Irma ....... Irma Birchall Calyx Group Pty Limited trading as CALYX information essentials Koha implementations and services M: +61 413 510 717 irma(a)calyx.net.au www.calyx.net.au www.koha.org

1 0

Re: [Koha-devel] virtual_keyboard_code
by Zico 11 Jan '10

11 Jan '10

On Mon, Jan 11, 2010 at 11:21 PM, Owen Leonard <oleonard(a)myacpl.org> wrote: > > I developed this by myself. > > It works for me. What does your browser's javascript debugger say? > > Ok; I have developed a fully working Bengali ( Bangladesh ) on screen keyboard for my system. It`s working prefectly. -- Best, Zico

1 0

Cron Jobs
by Nicole Engard 11 Jan '10

11 Jan '10

Hi all, I found these scripts in the cronjobs folder that I do not have documented. Can you please tell me what they do and when you think they should be run? If I have one marked as deprecated that isn't supposed to be - let me know that too :) misc/cronjobs/MARC21_parse_test.pl misc/cronjobs/backup.sh misc/cronjobs/cloud-kw.pl misc/cronjobs/cloud-sample.conf misc/cronjobs/create_koc_db.pl misc/cronjobs/j2a.pl (marked as deprecated) misc/cronjobs/notifyMailsOp.pl (marked as deprecated) misc/cronjobs/runreport.pl misc/cronjobs/services_throttle.pl misc/cronjobs/smsoverdues.pl (marked as deprecated) misc/cronjobs/zebraqueue_start.pl (marked as deprecated) misc/cronjobs/stats/monthly_circulation_statistics.pl misc/cronjobs/stats/monthly_new_items_statistics.pl misc/cronjobs/stats/monthly_new_patron_statistics.pl In the manual I have this listed for each: Script: What it Does: Frequency Suggestion: Required by: Thanks in advance! Nicole

3 6

koha 3.0.5 virtual keyboard
by Zico 10 Jan '10

10 Jan '10

Hi, i have added a virtual keyboard in my OPAC. I am providing you the code with which i did it. The procedure i followed: I entered my given whole code in Opacheader field. But, the point is: *I cannot input any fonts/data from my keyboard in my OPAC search box. That means, i cannot use my virtual keyboard to input any data in my search box. Here is the complete code: "** <html> <head> <style> .searchform { font-size:20px; width:40px; text-align:center; } .searchform2{ font-size:20px; width:36.6px; text-align:center; } .space { width:160px; } .dari { width:80px; } </style> <script src="http://jquery.com/src/jquery-latest.min.js"></script> <script src="http://fromvega.com/code/easydrag/jquery.easydrag.js"></script> </head> <body> <textarea id="searchform" </textarea> <br/><input type="button" style="font-size:20px;margin-bottom:20px;" value="ভার্চুয়াল কিবোর্ড" onclick="showVk();" /><br/> <div id="keyb" style="display:none;text-align:center;border:1px solid #ccc;width:450px;background-color:#FFF;"> <div id='vktitle' style='position: relative;padding:0px 10px 0px 10px;font-size:20px;height:40px;line-height:40px;background-color:#444;color:#CCC;text-align:left;'> ভার্চুয়াল কীবোর্ড <div style="position: absolute; bottom: 0.1em; right: 0.5em;cursor:pointer;" onclick="hideVk();"> বন্ধ কর </div> </div> <div id="vkcontainer" style="padding:20px;"> <div id="vkvowels" style="width:420px;tect-align:center;"> </div> <div id="vkkars" style="width:420px;tect-align:center;"> </div> <div id="vkconsonants" style="margin-top:15px"> </div> <div id="vknumbers" style="margin-top:15px"> </div> <div style="clear:both;"></div> </div> </div> <br/> <script> var ir, searchform, banglaSafe=""; $(document).ready(function(){ showVirtualKeyboard(); $('#keyb').easydrag(true); }); var reserved = "2445,2446,2449,2450,2473,2481,2483,2484,2485,2444,2500,2501,2502,"; var activeta = "searchform"; function showVirtualKeyboard(){ var counter = 0; for(i=2437; i<=2489;i++) { // ir = reserved.indexOf(i+","); if (ir=="-1"){ searchform = "\\u0"+num2hex(i); banglaSafe = "&#"+i+";"; if (i<2453 ) drawButton(i,"vkvowels"); else{ drawButton(i,"vkconsonants"); counter++; } //$("<input type='button' onclick='insertAtCursor(\""+searchform+"\")' value='"+searchformSafe+"' />").appendTo('#consonants'); if ( i>2453 && counter>=10) { $("<br/>").appendTo("#vkconsonants"); counter=0; } } } drawHexButton("\u0995\u09CD\u09B7","vkconsonants"); drawHexButton("\u09DC","vkconsonants"); drawHexButton("\u09DD","vkconsonants"); drawHexButton("\u09DF","vkconsonants"); drawHexButton("\u09CE","vkconsonants"); drawHexButton("\u0982","vkconsonants"); drawHexButton("\u0983","vkconsonants"); drawHexButton("\u0981","vkconsonants"); $("#vkvowels input").attr("class","searchform2"); $("#vkconsonants input").attr("class","searchform"); $("<input class='searchform space' type='button' onclick='insertAtCursor(\" \")' value='\u09B8\u09CD\u09AA\u09C7\u09B8' />").appendTo('#vkconsonants'); $("<input class='searchform dari' type='button' onclick='insertAtCursor(\"\u0964\")' value='\u0964' />").appendTo('#vkconsonants'); $("<input class='searchform space' type='button' onclick='insertAtCursor(\"\u09CD\")' value='\u09AF\u09C1\u0995\u09CD\u09A4\u0020\u0995\u09B0\u09C1\u09A8' />").appendTo('#vkconsonants'); $("<br/>").appendTo("#vkconsonants"); for(i=2534; i<=2543;i++) { searchform = "\\u0"+num2hex(i); banglaSafe = "&#"+i+";"; $("<input type='button' onclick='insertAtCursor(\""+searchform+"\")' value='"+banglaSafe+"' />").appendTo('#vknumbers'); } for(i=2494; i<=2504;i++) { ir = reserved.indexOf(i+","); if (ir=="-1"){ searchform = "\\u0"+num2hex(i); banglaSafe = "&#"+i+";"; $("<input type='button' onclick='insertAtCursor(\""+searchform+"\")' value='"+banglaSafe+"' />").appendTo('#vkkars'); } } drawButton("2507","vkkars"); drawButton("2508","vkkars"); $("<input class='searchform' type='button' onclick='insertAtCursor(\"\u09CD\u09AF\")' value='\u09CD\u09AF' />").appendTo('#vkkars'); $("#vknumbers input").attr("class","searchform"); $("#vkkars input").attr("class","searchform2"); } function num2hex(num) { num = new Number(num); return num.toString(16); } function hex2num(hex) { return parseInt(hex,16); } function drawButton(value, container, cls) { //if (cls=="") searchform = "\\u0"+num2hex(value); banglaSafe = "&#"+value+";"; $("<input type='button' onclick='insertAtCursor(\""+searchform+"\")' value='"+banglaSafe+"' />").appendTo('#'+container); } function drawHexButton(value, container) { $("<input type='button' onclick='insertAtCursor(\""+value+"\")' value='"+value+"' />").appendTo('#'+container); } function hideVk() { $("#keyb").hide("slow"); } function showVk() { $("#keyb").show("slow"); } function insertAtCursor(myValue) { var myField = document.getElementById(activeta); if (document.selection) { myField.focus(); sel = document.selection.createRange(); sel.text = myValue; sel.collapse(true); sel.select(); } //MOZILLA/NETSCAPE support else if (myField.selectionStart || myField.selectionStart == 0) { var startPos = myField.selectionStart; var endPos = myField.selectionEnd; var scrollTop = myField.scrollTop; startPos = (startPos == -1 ? myField.value.length : startPos ); myField.value = myField.value.substring(0, startPos) + myValue + myField.value.substring(endPos, myField.value.length); myField.focus(); myField.selectionStart = startPos + myValue.length; myField.selectionEnd = startPos + myValue.length; myField.scrollTop = scrollTop; } else { var scrollTop = myField.scrollTop; myField.value += myValue; myField.focus(); myField.scrollTop = scrollTop; } } </script> </body> </html> * " Can you please help me? -- Best, Zico

2 1

PDF-API2-Simple and XML::LibXSLT errors
by David Schuster 08 Jan '10

08 Jan '10

I'm running a laptop with a very clean Debian Lenny on this old Laptop. I feel very close! If you'd rather I can email the Dev group in case others have similar problems. Running make for R/RE/REDTREE/PDF-API2-Simple-1.1.4u.tar.gz has already been unwrapped into direcotry /root/.cpan/build/PDF-API2-Simple-1.1.4-2Zz9NZ '/usr/bin/perl Makefile.PL INSTALLDIRS=site' returned status 512, won't make Running make test Make had some problems, won't test Running Make Install Make had some problems, won't install ugh. I get a similar error with XML::LibXSLT I'm a semi techie, but I'm lost on this any specific suggestions I will try! Thanks David Schuster -- View this message in context: http://old.nabble.com/PDF-API2-Simple-and-XML%3A%3ALibXSLT-errors-tp2707146… Sent from the Koha - Dev mailing list archive at Nabble.com.

2 2