Re: [Koha] jsprint setup -
Chad, This is overkill. If everything you do from this browser is going to be silently printed to the same printer, simply set up your printer prefs in FireFox. Then go to the about:config page and add a new boolean called print.always_print_silent and set it to true. Randy Original Message From: Chad Roseburg croseb...@ncrl.org Sent: 3/29/2013 3:30:56 PM To: koha@lists.katipo.co.nz Subject: [Koha] jsprint setup - I am trying to setup silent printing using the 'IntranetSlipPrinterJS' in Koha 3.10. Documentation found here: http://wiki.koha-community.org/wiki/Setting_up_slip_printer_to_print_silently My javascript looks like this: function printThenClose() { try { jsPrintSetup.setPrinter('TSP143-(STR_T-001)'); jsPrintSetup.clearSilentPrint(); jsPrintSetup.setOption('printSilent', 1); jsPrintSetup.setOption('headerStrLeft',); jsPrintSetup.setOption('headerStrCenter',); jsPrintSetup.setOption('headerStrRight',); jsPrintSetup.setOption('footerStrLeft',); jsPrintSetup.setOption('footerStrCenter',); jsPrintSetup.setOption('footerStrRight',); jsPrintSetup.print(); } catch(err) { //Default printing if jsPrint-setup is not available window.print(); window.close(); } } Using Firefox 19 on Ubuntu 12.04. It brings up the receipt window but that's it. I've tried commenting out the setprinter line ...no change. JSprint addon is set to allow any site access. Tried other permissions to no avail. Does anyone have complete instructions for getting this to work? Thanks! -- Chad Roseburg Automation Dept. North Central Regional Library ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Zebra not updating biblios automatically in koha 3.8
Why would this require a server reboot? Also .bashrc env vars dono't affect cron. If you want to insure that cron env variables are set properly edit that users crontab. *nix != windoze server reboot not usually necessary. When changing .bashrc files all that is required is to logout and log back in. Randy Rowe Lincoln City Libraries I.T. Original Message From: Paul pau...@aandc.org Sent: 8/31/2012 3:40:10 PM To: Elaine Bradtke e...@efdss.org, Koha@lists.katipo.co.nz Subject: Re: [Koha] Zebra not updating biblios automatically in koha 3.8 At 08:37 PM 8/31/2012 +0100, Elaine Bradtke wrote: My colleagues are reporting a similar problem with 3.8.4 Downloading and editing of records seems to function normally, but once it is saved, none of the usual searches brings it up, and running a report on recently catalogued items give zero results. mysql Ver 14.14 Distrib 5.1.63, for debian-linux-gnu (i486) using readline 6.1 Apache/2.2.16 (Debian) Zebra version:Zebra 2.0.50 Any ideas? I have found that 3.8.x may have problems with env vars not being available to cron. Please try editing: sudo vi /home/koha/.bashrc Add the following two lines: export PERL5LIB=/usr/share/koha/lib export KOHA_CONF=/etc/koha/koha-conf.xml :x then reboot your server. This in itself cannot do any harm, and could well cure your problem. Best - Paul Elaine Bradtke On Fri, Aug 31, 2012 at 12:05 PM, sunil sharma koha.sunil...@gmail.com wrote: Dear All, I installed Koha 3.8.02 and also check latest version of koha 3.8.04 on centos 6.2, The same problem I am facing in both of these version. when I enter any new biblio, it is not updated automatically to zebra, I am using zebra latest version 2.0.54 and all cronjobs are set. I also manually check zebra functioning by ./rebuild_zebra.pl -b -a -v -z but it shows export biblios zero, but I already added some bilios to koha yet it shows exported zero. And, when I use ./rebuild_zebra.pl -b -a -v -r then it rebuild all the biblios and my all added biblio shows in result i.e. exported 10 biblios. My question is that why ./rebuild_zebra.pl -b -a -v -z option is not working. where is the problem, because my zebra working fine in 3.6, is there any problem in koha 3.8. or any other issue. Please help me out. Thanx in advance. Sunil ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --- Writing about music is like dancing about architecture --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha --- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. http://NavalMarineArchive.com and http://UltraMarine.ca ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Excel to MARC - Marcedit 5.8
I haven't tried running MarcEdit in Wine. I've been amazed at what Wine will run. Randy Rowe Lincoln City Libraries I.T. -Original Message- From: Paul pau...@aandc.org Sent 6/26/2012 9:13:32 AM To: amit bondwal bondwal.a...@gmail.com, koha@lists.katipo.co.nz Subject: Re: [Koha] Excel to MARC - Marcedit 5.8 At 05:44 AM 6/26/2012 -0700, amit bondwal wrote: HI Sandeep, I don't know much about it, but may be this can help, Is your excel sheet have three sheets? then delete the two extra empty sheets in that file and save as the file in text(tab delieted) format. marc edit support more text(tab delimeted) format. Then try to convert by marc edit in text delimated in addins. A couple of years ago we tried to use Office97 (we've never had a more recent version) to do just that -- but ended up using OpenOffice|LibreOffice to open and save the Excel files as tab-delimited .csv files. Excel appeared to have difficulties with UTF8 and special characters. Disclaimer: Terry Reece has done an apparently marvelous job developing MarcEdit; we've never been able to run recent versions as our old Windows laptop is more of a museum exhibit than a useful tool. I would strongly suggest joining the list at http://metis3.gmu.edu/cgi-bin/wa?A0=MARCEDIT-L. As an aside, has anyone managed to get MarcEdit to function on a Linux box? We have failed miserably. Best - Paul Regards Amit Bondwal On Tue, Jun 26, 2012 at 1:40 AM, Stacy Pober [via Koha] ml-node+s1045719n571771...@n5.nabble.com wrote: There's an excellent support list for MARCEDIT called MARCEDIT-L.  Terry Reese, the author of the program monitors the list, and he will often offer solutions along with some of the other list subscribers. http://metis3.gmu.edu/cgi-bin/wa?A0=MARCEDIT-L It's also a good way to give input on features you'd like to see or to find out whether someone already has solved a particular problem you're having. Stacy On Mon, Jun 25, 2012 at 9:18 AM, [hidden email] wrote: As marcedit is proprietary software, unfortunately the only person who is likely to be able to help is the marcedit author, unless someone else has seen and solved it before. -- Stacy Pober Information Alchemist Riverdale, NY 10471 [hidden email] ___ Koha mailing list  http://koha-community.org [hidden email] http://lists.katipo.co.nz/mailman/listinfo/koha If you reply to this email, your message will be added to the discussion below: http://koha.1045719.n5.nabble.com/Excel-to-MARC-Marcedit-5-8-tp5717503p5717713.html To unsubscribe from Koha, click here. NAML -- View this message in context: http://koha.1045719.n5.nabble.com/Excel-to-MARC-Marcedit-5-8-tp5717503p5717757.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha --- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. http://UltraMarine.ca, http://AandC.org and http://MarDoc.ca ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Printing Dewey spine labels in Koha 4.06
Morning. To print our labels, we use Bartender labeling software. We design the labels in Bartender and use the MySQL ODBC connector to get the label data. Works so much better than the Koha export to PDF functionality. Feel free to use whichever labeling software you chose as a substitute for Bartender. Randy Rowe Lincoln City Libraries I.T. -Original Message- From: jpisunyer jpisun...@gmail.com Sent 5/14/2012 9:24:36 PM To: koha@lists.katipo.co.nz Subject: [Koha] Printing Dewey spine labels in Koha 4.06 Could anyone help me print a Dewey spine label in Koha 4.06? I have an error message and also am not sure of the logistics - do I get a single-label printer and do one at a time? I am setting up a new library in Baltimore, MD, USA and have about 4,000 books to label. Here is the error message: Koha error The following fatal error has occurred: DBD::mysql::st execute failed: Table 'koha_bcpss.printers_profile' doesn't exist at /home/ptfs/kohaclone/C4/Labels/Lib.pm line 215. ApacheServer version: Apache/2.2.9 (Debian) Server built: Apr 20 2010 15:42:00 Koha4.06.00.000 Koha DB4.060 MySQLmysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (x86_64) using readline 5.2 OSLinux KOHAPROD 2.6.26-2-amd64 #1 SMP Sun Jun 20 20:16:30 UTC 2010 x86_64 Perl5.01 Thank you. jpisunyer -- View this message in context: http://koha.1045719.n5.nabble.com/Printing-Dewey-spine-labels-in-Koha-4-06-tp5709708.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ��___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Z39.50 pop-up box
To restart Apache as root or using sudo /etc/init.d/apache2 restart or /etc/init.d/apache2 stop /etc/init.d/apache2 start Randy Rowe Lincoln City Libraries I.T. -Original Message- From: Paul pau...@aandc.org Sent 2/6/2012 10:43:30 AM To: Garry Collum gcol...@hotmail.com, koha@lists.katipo.co.nz Subject: Re: [Koha] Z39.50 pop-up box At 06:39 PM 2/5/2012 -0500, Garry Collum wrote: Ah! My offlist reply was unintentional. There is also an instance of the PopupZ3950 function in addbiblio.tt. ~/koha-tmpl/intranet-tmpl/prog/en/modules/cataloguing/addbiblio.tt Many thanks Garry. For the record in 3.6.1 it is at /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/modules/cataloguing/addbiblio.tt One question remains from my original query: Is there a quick CLI command to restart Koha without rebooting the server? The .tt didn't need it, but the .inc did (maybe a quirk of my install of memcached.) Again tnx and br, Paul ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ��___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Which directory is Koha database on Ubuntu?
mysqldump should just know where to find the database. But as you asked it should be in /var/lib/mysql/XXX where XXX is the name you gave it during install. Randy Rowe Lincoln City Libraries I.T. (402) 441-8523 -Original Message- From: Raphael Muonga chisan...@gmail.com Sent 2/2/2012 1:35:43 AM To: Koha koha@lists.katipo.co.nz Subject: [Koha] Which directory is Koha database on Ubuntu? I am using Koha 3.2 installed using LiveCD with Ubuntu 10.10 In which directory is the database located? I would like to do msqldump of it. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ��___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha Digest, Vol 74, Issue 25
-Original Message- From: Indranil Das Gupta indr...@gmail.com Sent 12/15/2011 2:14:19 AM To: Thippeswamy G.N thipp...@gmit.info Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Koha Digest, Vol 74, Issue 25 Hi, 2011/12/15 Thippeswamy G.N thipp...@gmit.info Sir, How can i take dataBack and restore the database. Even I took Data Backup from PHPmyAdmin, but when i try to restore that, it showing the Back file is too big, because through PHPMYADMIN we can restore max(2MB) file. Please give me the proper solution for this. Thank you snipped You are obviously new to the mailing list etiquette and culture and specifically to the Koha maling list, so here are a couple of pointers to help you get started. 1. Please snip your posts / replies of unnecessary quotes. 2. We are not a sexist, solely male-dominated community, so a Sir-addressed mail may not get you all the help you are looking for. 3. PhpMyAdmin is not a part of the Koha software stack, hence the question is Off-Topic or OT on this forum. You are likely to be better served by asking this on on https://lists.sourceforge.net/lists/listinfo/phpmyadmin-users However, since you asked, try saving the db dump file as a BZipped file (it will get you better compression, Zip is known to break) and then try to restore from the .bz2 file. I'm assuming that you are dumping a .sql file hope that helps -idg -- Indranil Das Gupta Phone : +91-98300-20971 Blog : http://indradg.randomink.org/blog IRC : indradg on irc://irc.freenode.net Twitter : indradg -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- Please exchange editable Office documents only in ODF Format. No other format is acceptable. Support Open Standards. For a free editor supporting ODF, please visit LibreOffice - http://www.documentfoundation.org Actually your best bet would be to edit your php.ini file and look for the following setting ; Maximum allowed size for uploaded files. ; http://php.net/upload-max-filesize upload_max_filesize = 2M Change that to the file size that you need and restart Apache. Randy Rowe Lincoln City Libraries I.T. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Introduction and incredibly slow searches
Is top showing that you really are using the 4 CPUs available? Pressing the numeral 1 will toggle multiple CPU lines in top. To display the CPU a program is running on first press 'f' then 'J' to add the CPU in use column (P) to top's display. What is your load average? Does 'uname -a' show that you're running the SMP version of Debian? Randy Rowe Lincoln City Libraries I.T. -Original Message- From: IBS Computer Support ibssupp...@colorado.edu Sent 10/27/2011 10:35:36 AM To: Randall Rowe r.r...@lincolnlibraries.org, ibs computer support ibssupp...@colorado.edu, koha@lists.katipo.co.nz koha@lists.katipo.co.nz, Chris Cormack ch...@bigballofwax.co.nz Subject: RE: [Koha] Introduction and incredibly slow searches To answer the questions from Randy and Chris and add more detail. Koha was installed following these directions: http://wiki.koha-community.org/wiki/Koha_3.2_on_Debian_Squeeze and the install notes towards the bottom of this page starting at “Step: Install Koha” http://wiki.koha-community.org/wiki/Setting_Up_Koha_in_Virtual_Environment_%2B_Using_That_as_a_Development_Environment The server is a virtual machine on ESXi v4.1. It is the only virtual machine on the host ESXi server. It has 4 CPUs dedicated to it, as well as 1GB RAM Watching “top” it doesn’t use enough RAM to get to need to swap Top shows: opac-search.pl for however many tabs I open from the initial search screen followed up with opac-detail.pl ping requests are 1ms Machines are on the same physical network, just different subnets. Thanks, Jeremy From: Randall Rowe [mailto:r.r...@lincolnlibraries.org] Sent: Thursday, October 27, 2011 5:47 AM To: ibs computer support; koha@lists.katipo.co.nz Subject: Re: [Koha] Introduction and incredibly slow searches What version of koha are you running? Where did you download it? I noticed that you went through the examples on liblime.com. If that is where you downloaded koha then you are not running the community version of koha. Regardless of what koha you are running, check the output of the command top. That should give you an idea of what is taking up time in the process. Are all these machines on a local network? Is ping response between the machines reasonable? Randy Rowe Lincoln City Libraries I.T. -Original Message- From: IBS Computer Support ibssupp...@colorado.edu Sent 10/26/2011 3:47:54 PM To: koha@lists.katipo.co.nz koha@lists.katipo.co.nz Subject: [Koha] Introduction and incredibly slow searches Hello Everyone, New to the list, new to Koha, increasingly frustrated :} I’ve built a koha server for our in-house library which seems to have gone over fine but I’m having issues with incredibly slow search response. I’m running the latest stable koha-common 3.6 (updated a few minutes ago) on Debian 6.0.3. I have successfully entered in a record for one book. When I search from the initial koha page it takes ~4 seconds to find this item. Then once the item has loaded if I click one of the links for a searchable item (author, details, etc.) it takes ~4-5 seconds for it to load. When I open all of these options at the same time in new tabs it takes forever. It seems to be an almost linear increase in the time it takes for the searches to complete. Also, each new tab running a different search will continue to run until one has finished, then once one has finished another will go. This process is ~4 seconds for each search. Seems like all searches are in a very slow queue. So for this example book I have in the system there are 7 items that are searchable. If I go through and open each in a separate tab the total process for all of this is 30+seconds. I tried running a webserver load test with just 10 users clicking on a different link each time the new page loaded and it failed horribly with an average page load wait of 50 seconds I really don’t know where to go to look for what’s causing this. When I use the “browse by author or subject search”, the authority search results page comes back in less than 2 seconds. Though it does show 0 biblios records (no clue what that is) I’ve gone through many example sites found here: http://www.liblime.com/demos And they don’t seem to have this same issue. Any help. Thought, direction would be greatly appreciated! Thanks, Jeremy ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] SIP Assistance
Mike, The 3M Standard Interchange Protocol doesn't define PC or PF fields. Ordinarily the AQ field isn't associated with patrons, it's associated with items and designates their permanent location. The summary field works like this: Position Definition 0 hold items 1 overdue items 2 charged items 3 fine items 4 recall items 5 unavailable holds 6 fee items Despite the fact that there are only 7 defined fields the field length is required to be 10 characters so the last 3 are always spaces. Placing a Y in any of the fields is basically a request for that field's detailed information is requested in addition to the summary information. If you do not wish the detailed information then use a space character (ASCII code $20) in that field on the 63 request. Only one category of items should be requested at a time, so, for example, to get the detailed information on charged items and fine items you would need to make 2 requests 63002MMDDHHMMSS Y... and then 63002MMDDHHMMSS Y... Parsing each response for the information requested. All of this is based on SIP version 2. Randy Rowe Lincoln City Libraries I.T. -Original Message- From: Planet Mike m...@planetmike.org Sent 10/13/2011 5:07:55 PM To: koha@lists.katipo.co.nz Subject: [Koha] SIP Assistance Hello community. I am looking for assistance with setting up the SIPServer for Overdrive access. I am new to SIP and have found various docs on how to setup SIP with 3M machines, but not a lot about Overdrive. I have setup a SIP user as staff with circ access and configured the SIPServer.xml. I can start the SIP service and log in. When I telnet in to the service, I get the following: ### telnet session ### telnet my.host.org 8023 Trying 1.11.11.11... Connected to my.host.org. Escape character is '^]'. login: abcsip password: driveover Login OK. Initiating SIP 9300CNabcsip|COdrive|CCABC 941 6300120111013161 00 AOABC|AA12345678901234 64 00120111013 171831 AOABC|AA12345678901234|AEService User|BLY|CC10|BD316 Bloomfield St|beu...@email.com|BF718.555.1212|PB19741201|PCVOLUNTEER|PIY|AFGreetings from Koha. | ### end telnet session ### To me, this looks like it is working. I am able to run a few different AA numbers and get the correct results. Now for the question. I need to make sure that PC, PF and AQ fields are available and correct. I see that PC is in my Message 64, but how do I ask for PF and AQ? I am also a bit lost when it comes to what the summary field is. I set mine to 00 in the Message 63 to get a 64 that didn't start 64. Could someone please explain to me how to get at least PC PF and AQ from the Patron Information? What else, if anything, do I have to do in ether the SIP configuration or Koha configuration? Thank you for your help, Mike ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] some overdue messages not sending
Most every time I have heard of this situation, the email is getting trapped by a spam filter on the client end. Randy Rowe Lincoln City Libraries I.T. -Original Message- From: Lesley Kimball wiggi...@comcast.net Sent 9/1/2011 10:28:52 AM To: koha@lists.katipo.co.nz Subject: [Koha] some overdue messages not sending Hi everyone, I know that most of our e-mail overdue notices are going out -- I can see them listed in patron's messaging/notices and sometimes people reply or tell us they've gotten the e-mail. But, I have one patron who should be getting e-mails and he hasn't and there isn't anything in his messaging/notices. When there is an incorrect e-mail address Koha still sends a message but then I get the bounce-back. In this case there is nothing at all. Has anyone run into this before? We are using 3.4 Thanks, Lesley ~~ You see, I don't believe that libraries should be drab places where people sit in silence, and that's been the main reason for our policy of employing wild animals as librarians. -- Monty Python, Gorilla Librarian sketch ~~~ Lesley Kimball Director Wiggin Memorial Library Stratham, NH direc...@wigginml.org ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] April 13th, 2005 entry
Not really true. I have seen numerous responses to questions by PTFS employees on this list that were technical in nature and had nothing to do with PTFS/Liblime Koha. I also noticed that some of them are listed in the thank you list as contributors to the current community version. Randy Rowe Lincoln City Libraries I.T. -Original Message- From: Owen Leonard oleon...@myacpl.org Sent 8/25/2011 5:42:04 PM To: DeGroff, Amy adegr...@liblime.com Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] April 13th, 2005 entry I find it interesting that the only thing that will prompt Liblime's participation on this list is possible bad press. We will soon be publishing a new release of LibLime Koha in download format as well as a unified git repository. This is meaningless information for this list. We discuss Koha here. If you want to be lauded for your accomplishments, those accomplishments will have to be in the form of real collaboration. -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ��___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Enabling SSL for Koha staff view
Direct from Apache.org SSL FAQ Why is it not possible to use Name-Based Virtual Hosting to identify different SSL virtual hosts? Name-Based Virtual Hosting is a very popular method of identifying different virtual hosts. It allows you to use the same IP address and the same port number for many different sites. When people move on to SSL, it seems natural to assume that the same method can be used to have lots of different SSL virtual hosts on the same server. It comes as rather a shock to learn that it is impossible. The reason is that the SSL protocol is a separate layer which encapsulates the HTTP protocol. So the SSL session is a separate transaction, that takes place before the HTTP session has begun. The server receives an SSL request on IP address X and port Y (usually 443). Since the SSL request does not contain any Host: field, the server has no way to decide which SSL virtual host to use. Usually, it will just use the first one it finds, which matches the port and IP address specified. You can, of course, use Name-Based Virtual Hosting to identify many non-SSL virtual hosts (all on port 80, for example) and then have a single SSL virtual host (on port 443). But if you do this, you must make sure to put the non-SSL port number on the NameVirtualHost directive, e.g. NameVirtualHost 192.168.1.1:80 Other workaround solutions include: Using separate IP addresses for different SSL hosts. Using different port numbers for different SSL hosts. Randy Rowe Lincoln City Libraries I.T. -Original Message- From: Martin Renvoize martin.renvo...@ptfs-europe.com Sent 5/13/2011 3:33:09 AM To: Mizst Audens mizs...@gmail.com Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Enabling SSL for Koha staff view You could however, Use Name based Virtualhosts (like kohaapoc.yourlibrary.com and kohastaff.yourlibrary.com) and run both on port 443 for secure. To do this you'll either need two certificates (one for each domain) or a SAN shared certificate with both domain names in it. An example http.conf might look like (assuming the two certificate approach); ## OPAC Default Access VirtualHost 127.0.1.1:80 DocumentRoot /home/koha/kohaclone/koha-tmpl ServerName kohalibrary.halton.gov.uk . . . /VirtualHost ## OPAC Secure VirtualHost 127.0.1.1:443 DocumentRoot /home/koha/kohaclone/koha-tmpl ServerName kohalibrary.halton.gov.uk . . . # SSL Setup # CA Root and Intermediate Certificates SSLEngine On SSLCACertificatePath /etc/apache2/ssl/certs/ SSLCACertificateFile /etc/apache2/ssl/certs/gs_combined_ca.crt SSLCertificateFile /etc/apache2/ssl/certs/kohalibrary.crt SSLCertificateKeyFile /etc/apache2/ssl/certs/kohalibrary.key /VirtualHost ## Intranet Secure VirtualHost 109.75.173.120:443 DocumentRoot /home/koha/kohaclone/koha-tmpl ServerName kohastaff.halton.gov.uk . . . # SSL Setup # CA Root and Intermediate Certificates SSLEngine On SSLCACertificatePath /etc/apache2/ssl/certs/ SSLCACertificateFile /etc/apache2/ssl/certs/gs_combined_ca.crt SSLCertificateFile /etc/apache2/ssl/certs/kohastaff.crt SSLCertificateKeyFile /etc/apache2/ssl/certs/kohastaff.key /VirtualHost 2011/5/8 Mizst Audens mizs...@gmail.com No, it's not possible due to the limitation of the architecture. A port can serve only http or https but not both at the same time. The transparency of http/https in normal websites is due to the standardization of port 80 and 443. (port 80 runs http, and port 443 runs https, so each port only runs one type of connection) When you don't use these standard ports, you will need to specify the correct combination of protocol and port in order to reach a service. --Mizst On Sun, May 8, 2011 at 12:33 PM, Altaf Mahmud altaf.mah...@gmail.com wrote: Is it possible to use port 8080 for both purposes (HTTP and HTTPS)? Actually, I just wanted to secure port 8080, can I do that? Thanks a lot! On Sat, May 7, 2011 at 8:34 PM, Mizst Audens mizs...@gmail.com wrote: You must create another virtual host at another port (for example, 8081) for the staff area and enable SSL for that virtual host, and it will require another SSL certificate. Your staff will need to use (example) https://127.0.1.1:8081 if they want to use SSL, and http://127.0.1.1:8080 if they don't want to use SSL. Note that https://127.0.1.1 is in fact an alias for https://127.0.1.1:443. You already used 443 for the OPAC, so you'll need another port for the staff. --Mizst 2011/5/7 Altaf Mahmud altaf.mah...@gmail.com Hello, I'm trying to implement SSL in my Koha server running on Debian 6.0 (squeeze). I've implemented it for my OPAC view, I've created another file 'koha-ssl' in ../apache2/sites-available/ directory and enabled it. I've edited ../apache2/sites-available/koha like following: NameVirtualHost *:80 VirtualHost 127.0.1.1:80 . .
Re: [Koha] SQL statement for generating current checkouts
Nabonita, Simply change the WHERE issues.issuedate = '-mm-dd' part to read WHERE issues.issuedate = '-mm-dd' in each query. Randy Rowe Lincoln City Libraries I.T. -Original Message- From: nabon...@jncasr.ac.in nabon...@jncasr.ac.in Sent 4/20/2011 11:35:49 PM To: Church, Beverly bchu...@liblime.com Cc: koha@lists.katipo.co.nz koha@lists.katipo.co.nz Subject: Re: [Koha] SQL statement for generating current checkouts Thanks Beverly for send me the SQL query. But this is retrieving only those titles which are issued on the given date. Where as I need to know that the titles which were on loan AS OF 2011-03-29. This may contain overdue books, and books which were issued/renewed on or before the given date. I'm not sure if this sort of result can be generated in Koha. Regards Nabonita -- Nabonita Guha Library-cum-Information Officer Library, Jawaharlal Nehru Centre for Advanced Scientific Research, Jakkur Post, Bangalore 560064 Karnataka, India Phone: +91-80-22082930 Email: nabon...@jncasr.ac.in Web: http://lib.jncasr.ac.in At Wednesday, 20-04-2011 on 5:46 pm Church, Beverly wrote: Nabonita, You can use this query if you want to see the title: SELECT issues.issuedate, items.barcode, biblio.title, borrowers.firstname,borrowers.surname, borrowers.cardnumber, borrowers.categorycode FROM issues LEFT JOIN borrowers ON borrowers.borrowernumber = issues.borrowernumber LEFT JOIN items ON issues.itemnumber = items.itemnumber LEFT JOIN biblio ON items.biblionumber=biblio.biblionumber WHERE issues.issuedate = '-mm-dd' If you don't need the title, use this query: SELECT issues.issuedate, items.barcode, borrowers.firstname, borrowers.surname, borrowers.cardnumber, borrowers.categorycode FROM issues LEFT JOIN borrowers ON borrowers.borrowernumber = issues.borrowernumber LEFT JOIN items ON issues.itemnumber = items.itemnumber WHERE issues.issuedate = '-mm-dd' * * * * Beverly Church LibLime Project Manager phone: 1-888-564-2457 ext. 717 1-301-654-8088 ext. 292 email: bchu...@liblime.com skype: beverlychurch 2011/4/20 nabonita Guha nabon...@jncasr.ac.in Dear Koha users/Developers, Can you please help me in building SQL statement to generate current checkouts on a given date (not for a date range). For example, I need to generate a report to get list of (barcodes with borrowers card number, surname and firstname and borrower's category with date of issue) were on Loan as on 2011-03-29. Looking forward to hearing from you. With best regards Nabonita -- Nabonita Guha Library-cum-Information Officer Library, Jawaharlal Nehru Centre for Advanced Scientific Research, Jakkur Post, Bangalore 560064 Karnataka, India Phone: +91-80-22082930 Email: nabon...@jncasr.ac.in Web: http://lib.jncasr.ac.in ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha