Re: [Koha] DBMS auto increment fix
Dear All, I had tried the fix given on page: https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix with steps as given below: - Edit /etc/mysql/my.cnf - Locate the [mysqld] section and add: init-file=/var/lib/mysql/init-file_kohadev.sql - Create a file /var/lib/mysql/init-file_kohadev.sql - Edit it with the following contents Restart MySQL This solution works for single mysql instance having multiple database, then we have to repeat all these statements for all the DBs. But my problem is that I am using mysql_mutli and there are different mysql instance for each Koha instance, considering master-slave instances, I have to use mysql_mutli. So, how should I use these statements in case of mysql_multi. Can anyone guide me in this regard? On Wed, Sep 27, 2017 at 1:29 PM, SATISH <lis4sat...@gmail.com> wrote: > Hi, > > Koha updated from 16.11.09 to 16.11.11.000 / Package Installation/ Ubuntu > 14.04 Desktop > and using Mysql Version 14.14 Distrib 5.5.57 > > I have faced problems regarding check-in earlier. Therefore, Is it relevant > / necessary for the said version of Koha to follow instructions given in > the URL on DBMS auto increment > https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix > > I mean to ask, should I edit /etc/mysq as defined in the wiki page. > > With Thanks > Satish MV > Librarian, > Govt. Engineering College, Hassan. > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > -- Thanks & Regards Sunil Sharma ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Bulk Patron Image upload zip file giving Error 500
Hi Marc, Thanks for the valuable input. Let me debug these lines which you had point out and get back to you if I will get any solution with this. On Fri, Jul 21, 2017 at 12:33 PM, Marc Véron <ve...@veron.ch> wrote: > Hi Sunil > > I have the impression that the error occurs on line 118 of > picture-upload.pl > > unless( system( "unzip", $tempfile, '-d', $dirname ) == 0 ) { > > It seems that the zip is extracted but the program thinks that something > went wrong with extracting and exits (following lines). > > Because the error occurs since Debian 8.3 I suppose that system(...) > returns an other value than with Debian 8.2 > > For the return values of system see: > http://perldoc.perl.org/functions/system.html > > Just my 2 cents... > > Marc > > > Am 21.07.2017 um 06:29 schrieb Sunil Sharma: > >> Hello Friends, >> >> If someone faced the problem mentioned in my previous mail attached below >> and having any solution, please guide. >> >> I am using Koha 16.05.12 with Debian 8.3 OS on my cloud server. >> >> Currently, I am facing a very strange problem while uploading a single >> patron image via Koha Bulk Patron image upload tool, the image file is >> uploading fine. But When I tried using *zip file* of all patron images >> with >> a mapped text file named as IDLINK.TXT, As soon as I browse the zip file >> and try to upload the images, the images are uploaded but instead of >> result >> page, the page will through error 500. >> >> I had checked many Koha versions i.e. Koha 3.22.x, Koha 16.05.x, Koha >> 16.11.x but same *error 500* will be the result. >> >> To troubleshoot the problem I had tested the same Koha versions with same >> zip file at my local virtual machine but the strange problem which I >> found, >> that* all Koha* versions with bulk patron upload feature *worked fine on >> Debian 8.2 *but *through error 500 with Debian 8.3 and onwards i.e. 8.4, >> 8.8 etc. * >> >> >> I had tested with different Apache versions but on Debian 8.2 all things >> worked fine, but on Debian 8.3 no success (may be any security fetch or >> something wrong is there) >> >> As there are a lot of other application are running on my cloud server so >> I >> can't change the OS. Please guide me what will I do? >> >> The Koha error logs are as given below: >> >> >> >> >> >> *[Thu Jul 12 13:43:02.2017] [http:error] [pid 16357] [client x.x.x.x] >> AH02429: Response header name ' extracting' contains invalid characters, >> aborting request, referer: >> http://example.com/cgi-bin/koha/tools/picture-upload.pl >> <http://example.com/cgi-bin/koha/tools/picture-upload.pl>[Thu Jul 12 >> 13:50:38.2017] [http:error] [pid 14327] [client x.x.x.x] AH02429: Response >> header name ' inflating' contains invalid characters, aborting request, >> referer: http://example.com/cgi-bin/koha/tools/picture-upload.pl >> <http://example.com/cgi-bin/koha/tools/picture-upload.pl>[Thu Jul 12 >> 13:59:27.2017] [http:error] [pid 25507] [client x.x.x.x] AH02429: Response >> header name ' inflating' contains invalid characters, aborting request, >> referer: http://example.com/cgi-bin/koha/tools/picture-upload.pl >> <http://example.com/cgi-bin/koha/tools/picture-upload.pl>* >> >> >> Any pointers would be of help. >> >> >> On Fri, Jul 14, 2017 at 3:19 PM, Sunil Sharma <koha.sunil...@gmail.com> >> wrote: >> >> Hi Ian Bays, >>> >>> Thank you very much for the valuable input. >>> >>> I had checked and you are right that all patron images are uploading >>> correctly but was failing when trying to show the results page with the >>> error 500 as you observed. >>> >>> Now, it is confirmed with your mail that something is wrong. Please guide >>> if you will find any solution for this problem. >>> >>> If someone else faced this problem and having solution, please guide. >>> >>> >>> >>> On Fri, Jul 14, 2017 at 2:19 PM, Ian Bays <ian.b...@ptfs-europe.com> >>> wrote: >>> >>> Hello, >>>> >>>> I have noticed the same problem uploading a zip file of patron images >>>> and >>>> saw similar messages in the log file. >>>> >>>> However on checking the patron records saw the images so I concluded >>>> that >>>> the upload was working correctly but was failing when trying to show the >>>> results page with the error 500. &
Re: [Koha] Bulk Patron Image upload zip file giving Error 500
Hello Friends, If someone faced the problem mentioned in my previous mail attached below and having any solution, please guide. I am using Koha 16.05.12 with Debian 8.3 OS on my cloud server. Currently, I am facing a very strange problem while uploading a single patron image via Koha Bulk Patron image upload tool, the image file is uploading fine. But When I tried using *zip file* of all patron images with a mapped text file named as IDLINK.TXT, As soon as I browse the zip file and try to upload the images, the images are uploaded but instead of result page, the page will through error 500. I had checked many Koha versions i.e. Koha 3.22.x, Koha 16.05.x, Koha 16.11.x but same *error 500* will be the result. To troubleshoot the problem I had tested the same Koha versions with same zip file at my local virtual machine but the strange problem which I found, that* all Koha* versions with bulk patron upload feature *worked fine on Debian 8.2 *but *through error 500 with Debian 8.3 and onwards i.e. 8.4, 8.8 etc. * I had tested with different Apache versions but on Debian 8.2 all things worked fine, but on Debian 8.3 no success (may be any security fetch or something wrong is there) As there are a lot of other application are running on my cloud server so I can't change the OS. Please guide me what will I do? The Koha error logs are as given below: *[Thu Jul 12 13:43:02.2017] [http:error] [pid 16357] [client x.x.x.x] AH02429: Response header name ' extracting' contains invalid characters, aborting request, referer: http://example.com/cgi-bin/koha/tools/picture-upload.pl <http://example.com/cgi-bin/koha/tools/picture-upload.pl>[Thu Jul 12 13:50:38.2017] [http:error] [pid 14327] [client x.x.x.x] AH02429: Response header name ' inflating' contains invalid characters, aborting request, referer: http://example.com/cgi-bin/koha/tools/picture-upload.pl <http://example.com/cgi-bin/koha/tools/picture-upload.pl>[Thu Jul 12 13:59:27.2017] [http:error] [pid 25507] [client x.x.x.x] AH02429: Response header name ' inflating' contains invalid characters, aborting request, referer: http://example.com/cgi-bin/koha/tools/picture-upload.pl <http://example.com/cgi-bin/koha/tools/picture-upload.pl>* Any pointers would be of help. On Fri, Jul 14, 2017 at 3:19 PM, Sunil Sharma <koha.sunil...@gmail.com> wrote: > Hi Ian Bays, > > Thank you very much for the valuable input. > > I had checked and you are right that all patron images are uploading > correctly but was failing when trying to show the results page with the > error 500 as you observed. > > Now, it is confirmed with your mail that something is wrong. Please guide > if you will find any solution for this problem. > > If someone else faced this problem and having solution, please guide. > > > > On Fri, Jul 14, 2017 at 2:19 PM, Ian Bays <ian.b...@ptfs-europe.com> > wrote: > >> Hello, >> >> I have noticed the same problem uploading a zip file of patron images and >> saw similar messages in the log file. >> >> However on checking the patron records saw the images so I concluded that >> the upload was working correctly but was failing when trying to show the >> results page with the error 500. >> >> There is definitely something wrong but you might like to check to see if >> the upload actually worked OK. >> >> Best regards. >> Ian >> >> On 13/07/2017 06:32, Sunil Sharma wrote: >> >>> Hello Friends, >>> >>> I am using Koha 16.05.12 with Debian 8.3 OS on my cloud server. >>> >>> Currently, I am facing a very strange problem while uploading a single >>> patron image via Koha Bulk Patron image upload tool, the image file is >>> uploading fine. But When I tried using *zip file* of all patron images >>> with >>> a mapped text file named as IDLINK.TXT, As soon as I browse the zip file >>> and try to upload the file, the page will through error 500. >>> >>> I had checked many Koha versions i.e. Koha 3.22.x, Koha 16.05.x, Koha >>> 16.11.x but same *error 500* will be the result. >>> >>> To troubleshoot the problem I had tested the same Koha versions with same >>> zip file at my local virtual machine but the strange problem which I >>> found, >>> that* all Koha* versions with bulk patron upload feature *worked fine on >>> Debian 8.2 *but *through error 500 with Debian 8.3 * >>> >>> I had tested with different Apache versions but on Debian 8.2 all things >>> worked fine, but on Debian 8.3 no success (may be any security fetch or >>> something wrong is there) >>> >>> As there are a lot of other application are running on my cloud server >>> so I >>> can
Re: [Koha] Bulk Patron Image upload zip file giving Error 500
Hi Ian Bays, Thank you very much for the valuable input. I had checked and you are right that all patron images are uploading correctly but was failing when trying to show the results page with the error 500 as you observed. Now, it is confirmed with your mail that something is wrong. Please guide if you will find any solution for this problem. If someone else faced this problem and having solution, please guide. On Fri, Jul 14, 2017 at 2:19 PM, Ian Bays <ian.b...@ptfs-europe.com> wrote: > Hello, > > I have noticed the same problem uploading a zip file of patron images and > saw similar messages in the log file. > > However on checking the patron records saw the images so I concluded that > the upload was working correctly but was failing when trying to show the > results page with the error 500. > > There is definitely something wrong but you might like to check to see if > the upload actually worked OK. > > Best regards. > Ian > > On 13/07/2017 06:32, Sunil Sharma wrote: > >> Hello Friends, >> >> I am using Koha 16.05.12 with Debian 8.3 OS on my cloud server. >> >> Currently, I am facing a very strange problem while uploading a single >> patron image via Koha Bulk Patron image upload tool, the image file is >> uploading fine. But When I tried using *zip file* of all patron images >> with >> a mapped text file named as IDLINK.TXT, As soon as I browse the zip file >> and try to upload the file, the page will through error 500. >> >> I had checked many Koha versions i.e. Koha 3.22.x, Koha 16.05.x, Koha >> 16.11.x but same *error 500* will be the result. >> >> To troubleshoot the problem I had tested the same Koha versions with same >> zip file at my local virtual machine but the strange problem which I >> found, >> that* all Koha* versions with bulk patron upload feature *worked fine on >> Debian 8.2 *but *through error 500 with Debian 8.3 * >> >> I had tested with different Apache versions but on Debian 8.2 all things >> worked fine, but on Debian 8.3 no success (may be any security fetch or >> something wrong is there) >> >> As there are a lot of other application are running on my cloud server so >> I >> can't change the OS. Please guide me what will I do? >> >> The Koha error logs are as given below: >> >> >> >> >> >> *[Thu Jul 12 13:43:02.2017] [http:error] [pid 16357] [client x.x.x.x] >> AH02429: Response header name ' extracting' contains invalid characters, >> aborting request, referer: >> http://example.com/cgi-bin/koha/tools/picture-upload.pl >> <http://example.com/cgi-bin/koha/tools/picture-upload.pl>[Thu Jul 12 >> 13:50:38.2017] [http:error] [pid 14327] [client x.x.x.x] AH02429: Response >> header name ' inflating' contains invalid characters, aborting request, >> referer: http://example.com/cgi-bin/koha/tools/picture-upload.pl >> <http://example.com/cgi-bin/koha/tools/picture-upload.pl>[Thu Jul 12 >> 13:59:27.2017] [http:error] [pid 25507] [client x.x.x.x] AH02429: Response >> header name ' inflating' contains invalid characters, aborting request, >> referer: http://example.com/cgi-bin/koha/tools/picture-upload.pl >> <http://example.com/cgi-bin/koha/tools/picture-upload.pl>* >> >> >> >> Any pointers would be of help. >> >> >> > -- > Ian Bays > Director of Projects, PTFS Europe Limited > Content Management and Library Solutions > +44 (0) 800 756 6803 (phone) > +44 (0) 7774 995297 (mobile) > +44 (0) 800 756 6384 (fax) > skype: ian.bays > email: ian.b...@ptfs-europe.com > > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > -- Thanks & Regards Sunil Sharma ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Bulk Patron Image upload zip file giving Error 500
Hello Friends, I am using Koha 16.05.12 with Debian 8.3 OS on my cloud server. Currently, I am facing a very strange problem while uploading a single patron image via Koha Bulk Patron image upload tool, the image file is uploading fine. But When I tried using *zip file* of all patron images with a mapped text file named as IDLINK.TXT, As soon as I browse the zip file and try to upload the file, the page will through error 500. I had checked many Koha versions i.e. Koha 3.22.x, Koha 16.05.x, Koha 16.11.x but same *error 500* will be the result. To troubleshoot the problem I had tested the same Koha versions with same zip file at my local virtual machine but the strange problem which I found, that* all Koha* versions with bulk patron upload feature *worked fine on Debian 8.2 *but *through error 500 with Debian 8.3 * I had tested with different Apache versions but on Debian 8.2 all things worked fine, but on Debian 8.3 no success (may be any security fetch or something wrong is there) As there are a lot of other application are running on my cloud server so I can't change the OS. Please guide me what will I do? The Koha error logs are as given below: *[Thu Jul 12 13:43:02.2017] [http:error] [pid 16357] [client x.x.x.x] AH02429: Response header name ' extracting' contains invalid characters, aborting request, referer: http://example.com/cgi-bin/koha/tools/picture-upload.pl <http://example.com/cgi-bin/koha/tools/picture-upload.pl>[Thu Jul 12 13:50:38.2017] [http:error] [pid 14327] [client x.x.x.x] AH02429: Response header name ' inflating' contains invalid characters, aborting request, referer: http://example.com/cgi-bin/koha/tools/picture-upload.pl <http://example.com/cgi-bin/koha/tools/picture-upload.pl>[Thu Jul 12 13:59:27.2017] [http:error] [pid 25507] [client x.x.x.x] AH02429: Response header name ' inflating' contains invalid characters, aborting request, referer: http://example.com/cgi-bin/koha/tools/picture-upload.pl <http://example.com/cgi-bin/koha/tools/picture-upload.pl>* Any pointers would be of help. -- Thanks & Regards Sunil Sharma ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Search By Barcode having 1, 2 or 3 digit not working in Koha 3.20 or in 3.22
Hi Katrin, Yes, when I check this system preference it is set on as "automatically". When I changed it to "Only if * added" search is performing fine. Thanks for the help. On Fri, Apr 29, 2016 at 7:41 PM, Katrin Fischer <katrin.fischer...@web.de> wrote: > Hi, > > How are you searching for the barcode? > Did you turn on the QueryAutoTruncate system preference? > > Hope this helps, > > Katrin > > Am 29.04.2016 um 13:16 schrieb Sunil Sharma: > > Hello Friends, > > > > I checked both Koha 3.20.x as well as Koha 3.22.x on Debian 8 OS, Zebra > > version 2.0.61. My other search is working fine but when I search any > > barcode having 1, 2 or 3 digit, the search result page will not reflect > > proper search result both in Koha OPAC as well as on Staff-Admin page. > > > > For example, when I search 123 it will give the records having barcode as > > 1231, 1232, 1233, same as if I will search for barcode 121 then it will > > give result for biblio having accession no. 121220, 121121 and so on. > Even > > these barcodes (121 or 123) are present in Koha. > > > > Any pointers would be of help. > > > > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > -- Thanks & Regards Sunil Sharma ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Search By Barcode having 1, 2 or 3 digit not working in Koha 3.20 or in 3.22
Hello Friends, I checked both Koha 3.20.x as well as Koha 3.22.x on Debian 8 OS, Zebra version 2.0.61. My other search is working fine but when I search any barcode having 1, 2 or 3 digit, the search result page will not reflect proper search result both in Koha OPAC as well as on Staff-Admin page. For example, when I search 123 it will give the records having barcode as 1231, 1232, 1233, same as if I will search for barcode 121 then it will give result for biblio having accession no. 121220, 121121 and so on. Even these barcodes (121 or 123) are present in Koha. Any pointers would be of help. -- Thanks & Regards Sunil Sharma ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Merge Records via List not working in Koha 3.22.x
Hello Friends, I am using Koha 3.22.5 on Debian 8 OS. I have many duplicate title in my catalog, So I want to merge such records through Koha List module using merge function, At the end of the process it will show succesfully merged. But in actual it will neither merge items from source to destination record nor it will delete the other records except reference as it worked in previous version Koha 3.18 or koha 3.20. Any pointers would be of help. -- Thanking you, Sunil Sharma ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Report on Titles in the collection
Here is the query, what you want :- SELECT items.barcode, biblio.title FROM items LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber) GROUP BY items.biblionumber HAVING ( COUNT(*) 1 ) On Mon, Aug 26, 2013 at 7:15 AM, Madhura Deodhar IES Library library.m...@gmail.com wrote: I want a list of titles having more than one items . Can anyone help me with the SQL query? -- *Regards,* ** *Madhura M.Deodhar* *Librarian *IES Management College and Research Centre VMD Lotlikar Vidya Sankul Opp.Lilavati Hospital, Bandra Reclamation Bandra (West) Mumbai - 50 61378327(direct) 9869385665/9167004647 http://iesmglib.blogspot.com *P **Please consider the environment before printing this e-mail.* * * ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha //BR Sunil ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Routing list notice not working properly
Dear all, I configure the postfix mail server for koha 3.08.11 in debian-6. All notice going fine, except routing list. Actually the routing list notice to subscriber list is going fine after receiving a new serial but only title of that particular serial is displayed in the mail, other information get skip. For e.g. my routing list notice is set like this;- Koha Module: Serial (routing list) Code: RLIST Message Subject: Serial is now available Message Body:- Dear Borrower, The following magazine/journal has been arrived in the Library and Information Center, and available for reference : biblio.title, biblio.author , items.barcode serial.serialseq, serial.publisheddate Thanks, Library and Information Center *Now, when we receive the mail it contain the following text only, * Dear Borrower, The following magazine/journal has been arrived in the Library and Information Center, and available for reference : sample Journal, , , Thanks, Library and Information Center so, it is clear that only biblio.title is supported by this notice. Please help me in this regard. Any help would be appreciated. //BR Sunil ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Want to raise a bug about fine module
Dear All, In fine module, currently we can set fine for a particular patron category and for any item type. A number of option available in current fine criteria like loan period, fine amount, fine charging interval etc. But this limit a library to apply a constant fine amount for a category whether the no. of days for which fine is applicable are 10 days or 100 days. What I want to say that in koha there should be increasing fine amount criteria. i.e when fine is calculated it should calculate like this:- Let say, After 'x' days the fine amount is 'a' After 'x+y' days the fine amount become 'a+b' where, x - the loan period a - fine amount after x days y - A constant period after which the fine gets change b - the fine amount applicable after 'x+y' days Please give your suggestion and help me in this regard. //BR Sunil ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Want to raise a bug about fine module
Hi I am not understanding the term Multiple overlapping fines, could you please explain me how this should resolve my problem. Thanks in Advance, Sunil On Tue, May 21, 2013 at 10:13 AM, Manos PETRIDIS egpetri...@yahoo.comwrote: I wonder if this could be accomplished by using multiple overlapping fines. MP Από το iPhone μου 21 Μαϊ 2013, 2:53 μ.μ., ο/η sunil sharma koha.sunil...@gmail.com έγραψε: Dear All, In fine module, currently we can set fine for a particular patron category and for any item type. A number of option available in current fine criteria like loan period, fine amount, fine charging interval etc. But this limit a library to apply a constant fine amount for a category whether the no. of days for which fine is applicable are 10 days or 100 days. What I want to say that in koha there should be increasing fine amount criteria. i.e when fine is calculated it should calculate like this:- Let say, After 'x' days the fine amount is 'a' After 'x+y' days the fine amount become 'a+b' where, x - the loan period a - fine amount after x days y - A constant period after which the fine gets change b - the fine amount applicable after 'x+y' days Please give your suggestion and help me in this regard. //BR Sunil ___ 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] Fwd: Routing list notice not working properly
Dear all, I configure the postfix mail server for koha 3.08.11 in debian-6. All notice going fine, except routing list. Actually the routing list notice to subscriber list is going fine after receiving a new serial but only title of that particular serial is displayed in the mail, other information get skip. For e.g. my routing list notice is set like this;- Koha Module: Serial (routing list) Code: RLIST Message Subject: Serial is now available Message Body:- Dear Borrower, The following magazine/journal has been arrived in the Library and Information Center, and available for reference : biblio.title, biblio.author , items.barcode serial.serialseq, serial.publisheddate Thanks, Library and Information Center *Now, when we receive the mail it contain the following text only, * Dear Borrower, The following magazine/journal has been arrived in the Library and Information Center, and available for reference : sample Journal, , , Thanks, Library and Information Center so, it is clear that only biblio.title is supported by this notice. Please help me in this regard. Any help would be appreciated. //BR Sunil ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Need Help in Koha Multiple instance
Thanx a lot for all your valuable suggestions. Problem solved by exporting the variable for that particular instance. And making script to resolve that permanently. Sunil On Sun, Apr 21, 2013 at 6:53 AM, Mason James m...@kohaaloha.com wrote: On 2013-04-20, at 10:28 PM, sunil sharma wrote: Hello all, I installed koha 3.8.x multiple instances on a debian-squeeze server by refering this link: http://wiki.koha-community.org/wiki/Installing_Multiple_Instances_of_Koha. use the debian packages, if you are attempting multiple instances of Koha... http://wiki.koha-community.org/wiki/Koha_3.x_on_Debian_Squeeze ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Need Help in Koha Multiple instance
Hello all, I installed koha 3.8.x multiple instances on a debian-squeeze server by refering this link: http://wiki.koha-community.org/wiki/Installing_Multiple_Instances_of_Koha . But I am facing problem in rebuilding zebra in multiple instances. Actually when I installed one instance for example koha1, it installed perfectly and rebuildzebra.pl work fine after uploading my database. After installing another instance say koha2, it also installed perfectly and rebuildzebra.plalso works fine. But now the problem is that, now if I again come at my first instance i.e. koha1, make rebuildzebra.pl command to run again, it takes database of my 2nd instance. This is because in zebra configuration file while rebuild zebra it show like this:- Zebra configuration information Zebra biblio directory = /var/lib/*koha2*/zebradb/biblios Zebra authorities directory = /var/lib/*koha2*/zebradb/authorities Koha directory = /usr/share/*koha2*/intranet/cgi-bin In place of *koha2*, this should take *koha1* in my first instance of koha, which is making wrong zebra rebuild and show me biblio of koha2 instance in koha1 instance. How should I resolve this problem. Can Anyone help me in this regard? Thanks in advance for your help, Sunil ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Google SMTP for mailing service
Dear sheikh, Yes, It is possible to use googlesmtp service for sending emails in koha. The step by step procedure for ubuntu system is as follows:- *1. Installation of postfix mail server package. * Open a a terminal and apply following command, apt-get install postfix Select no configuration in the post installation screen. *2. Copy the configuration file.* cp /usr/share/postfix/main.cf.debian /etc/postfix/main.cf *3. Install following packages too* apt-get install libsasl2-2 apt-get install libsasl2-modules apt-get install ca-certificates *4. Open the following file and add some lines.* gedit /etc/postfix/main.cf Add the following lines at the bottom of the file. relayhost = [smtp.gmail.com]:587 smtp_sasl_auth_enable = yes smtp_sasl_password_maps = hash:/etc/postfix/sasl_passwd smtp_sasl_security_options = noanonymous smtp_tls_CAfile = /etc/postfix/cacert.pem smtp_use_tls = yes *5. Create a new file to save the gmail password.* gedit /etc/postfix/sasl_passwd Add the following line in the opened file. [smtp.gmail.com]:587urgmai...@gmail.com:yourpassword Add your gmail user name and password. *6. Change the permission of following file.* chmod 400 /etc/postfix/sasl_passwd *7. Translate the /etc/postfix/sasl_passwd to Postfix lookup tables.* postmap /etc/postfix/sasl_passwd *8. Create the /etc/aliases.db* postalias hash:/etc/aliases *9. Create the /etc/postfix/cacert.pem.* cat /etc/ssl/certs/Equifax_Secure_CA.pem /etc/postfix/cacert.pem *10. Restart Postfix.* /etc/init.d/postfix restart Be Sure that you done the below step before to start email in Koha notices:- Administration Patron categories Overdue notice required Yes Koha Administration Patrons Enhancedmessagingpreferences Allow I think this is all you need. Enjoy!!! //BR Sunil On Mon, Oct 22, 2012 at 5:29 PM, sheikh303 sheikh...@gmail.com wrote: Is it possible to use google smtp service for sending emails in koha? thanks -- View this message in context: http://koha.1045719.n5.nabble.com/Google-SMTP-for-mailing-service-tp5730442.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] koha-index-daemon
Dear Friend, /etc/init.d/koha-index-daemon: line 67: log_daemon_msg: command not found /etc/init.d/koha-index-daemon: line 68: daemon: command not found /etc/init.d/koha-index-daemon: line 71: log_end_msg: command not found Both log_daemon_msg and log_end_msg commands belong to LSB-related packages. On Debian/Ubuntu that would be lsb-core. On RedHat derivates it might be redhat-lsb. As for the daemon command, I can't tell. I checked out the redhat-lsb package on my centos 6.2 machine, the package is already installed and the newest. My 2nd error of line 68: daemon: command not found is resolved after installing the daemon-tool as told by Mr.Bernardo. But the two errors of line 67 71 remains as it is, i.e. /etc/init.d/koha-index-daemon: line 67: log_daemon_msg: command not found /etc/init.d/koha-index-daemon: line 71: log_end_msg: command not found Can You or anybody else please help me in this regard to solve out my problem. *Thanx in Advance*, *Sunil* ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] koha-index-daemon
Dear Friend, Thanx for your quick reply, By installing 'daemon' program, the error of line 68 is removed but still the error in remianing 2 linesis as it is. i.e. $ /etc/init.d/koha-index-daemon start shows error:- /etc/init.d/koha-index-daemon: line 59: log_daemon_msg: command not found /etc/init.d/koha-index-daemon: line 63: log_end_msg: command not found And such as, /etc/init.d/koha-index-daemon stop shows error:- /etc/init.d/koha-index-daemon: line 67: log_daemon_msg: command not found /etc/init.d/koha-index-daemon: line 71: log_end_msg: command not found Can you pleasee see in this matter again. Please help me in this regard. Thanx in Advance, *Sunil* On Fri, Sep 21, 2012 at 3:25 PM, Bernardo Gonzalez Kriegel bgkrie...@gmail.com wrote: Sunil, the problem, as indicated by this line /etc/init.d/koha-index-daemon: line 68: daemon: command not found is that you don't have the 'daemon' program. On Centos this is unavailable, so go to http://libslack.org/daemon/ , download the source, compile and install. Regards, Bernardo -- Bernardo Gonzalez Kriegel bgkrie...@gmail.com On Fri, Sep 21, 2012 at 6:12 AM, sunil sharma koha.sunil...@gmail.comwrote: Dear All, I am facing an error while executing my koha-index-daemon file using * koha-index-daemon-ctl.sh*. My koha-index-daemon-ctl.sh file is as: #!/bin/sh # This file is part of Koha. # # Koha is free software; you can redistribute it and/or modify it under the # terms of the GNU General Public License as published by the Free Software # Foundation; either version 2 of the License, or (at your option) any later # version. # # Koha is distributed in the hope that it will be useful, but WITHOUT ANY # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR # A PARTICULAR PURPOSE. See the GNU General Public License for more details. # # You should have received a copy of the GNU General Public License along with # Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place, # Suite 330, Boston, MA 02111-1307 USA ### BEGIN INIT INFO # Provides: koha-index-daemon-$DBNAME # Required-Start:$local_fs $syslog # Required-Stop: $local_fs $syslog # Default-Start: 2 3 4 5 # Default-Stop: 0 1 6 # X-Interactive: false # Short-Description: Start/stop koha-index-daemon for $DBNAME ### END INIT INFO . /lib/lsb/init-functions USER=koha GROUP=koha DBNAME=koha NAME=koha-index-daemon-$DBNAME LOGDIR=/var/log/koha PERL5LIB=/usr/share/koha/lib KOHA_CONF=/etc/koha/koha-conf.xml ERRLOG=$LOGDIR/koha-index-daemon.err STDOUT=$LOGDIR/koha-index-daemon.log OUTPUT=$LOGDIR/koha-index-daemon-output.log export KOHA_CONF export PERL5LIB INDEXDAEMON=koha-index-daemon INDEXDAEMON_OPTS=--timeout 30 --conf $KOHA_CONF \ --directory /var/tmp/koha-index-daemon-$DBNAME DAEMONOPTS=--name=$NAME \ --errlog=$ERRLOG \ --stdout=$STDOUT \ --output=$OUTPUT \ --verbose=1 --respawn --delay=30 USER=--user=$USER.$GROUP case $1 in start) log_daemon_msg Starting Koha indexing daemon ($DBNAME) if daemon $DAEMONOPTS $USER -- $INDEXDAEMON $INDEXDAEMON_OPTS; then log_end_msg 0 else log_end_msg 1 fi ;; stop) log_daemon_msg Stopping Koha indexing daemon ($DBNAME) if daemon $DAEMONOPTS $USER --stop -- $INDEXDAEMON $INDEXDAEMON_OPTS; then log_end_msg 0 else log_end_msg 1 fi ;; restart) log_daemon_msg Restarting the Koha indexing daemon ($DBNAME) if daemon $DAEMONOPTS $USER --restart -- $INDEXDAEMON $INDEXDAEMON_OPTS; then log_end_msg 0 else log_end_msg 1 fi ;; *) log_success_msg Usage: /etc/init.d/$NAME {start|stop|restart} exit 1 ;; esac Then I create a symlink for this script as:- $ ln -s /usr/share/koha/bin/koha-zebra-indexdaemon-ctl.sh /etc/init.d/koha-zebra-indexdaemon While I am running this file giving any option start|stop|restart it displays error, like as below: $ /etc/init.d/koha-index-daemon start shows error:- /etc/init.d/koha-index-daemon: line 59: log_daemon_msg: command not found /etc/init.d/koha-index-daemon: line 60: daemon: command not found /etc/init.d/koha-index-daemon: line 63: log_end_msg: command not found And such as, /etc/init.d/koha-index-daemon stop shows error:- /etc/init.d/koha-index-daemon: line 67: log_daemon_msg: command not found /etc/init.d/koha-index-daemon: line 68: daemon: command not found /etc/init.d/koha-index-daemon: line 71: log_end_msg: command not found Any body can help me in this regard is very useful to me. I am using *koha 3.08* on *centos 6.2*. My zebra index version is *Zebrahttp://www.indexdata.com/zebra2.0.52. Thanx in Advance, Sunil * ___ Koha
[Koha] Zebra not updating biblios automatically in koha 3.8
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
Re: [Koha] Date format
Dear Sandeep, Do the following steps in Excel, If you open the excel sheet with open office, then: 1. Select whole column to which you want to apply the required date format. 2. Right click on any cell, and select Format cell, under Number tag option, Select Date format, in right pane select the desired format i.e. 1999-11-30, the Format Code is -MM-DD for that as you see under the same window, when you select that. 3. Apply or Click OK the whole column now set to ur required format. If you are using MS Office 2007 or 2010 then the steps are like below: 1. Select whole column to which you want to apply the required date format. 2. Right click on any cell, and select Format cell, under Number tag option, where Date format given, the last option is custom format. 3. Select Custom Format and in right pane under Type Text box, type your desired format i.e. -MM-DD, and select that from below as you add that format. 4. Apply or Click OK the whole column now set to ur required format. Hope your problem will solved now. BR// Sunil -- On Sat, Jun 9, 2012 at 5:30 PM, SANDEEP BHAVSAR sandeep.bhav...@gmail.comwrote: Dear All Kindly help me in converting date format from DD-MM- to -MM-DD in Excel If possible give the solution step by step. I tried with Text to Colums options in Excel. -- Thanks and Regards Sandeep Bhavsar Librarian Dr.V.N.Bedekar Institute of Management Studies Thane(W) 400601 MUMBAI. INDIA @@ email: sandeep.bhav...@gmail.com Mob : 9029 345777 elibrary :http://www.vpmthane.org/im/elib/main.htm @@ ___ 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] How to Delete Records with no Item
Dear All, I am Sunil, currently facing a problem. I am working on koha 3.06.04. And in my koha there are a lot of record entry in which there are no item added. And I want to remove all of them in one go because there are a lot of such entries in my database where no item is added in my framework records. So anyone suggest me in this regard is helpful to me. Thanks in advance, Sunil ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Want to add more feature or module in koha
Dear All, I am Sunil from India and I want to start my carrier with koha, open-source Integrated Library System. I am working at koha from last 4 months and currently at some developing level, I observe all the feature of koha but I want to add some more feature in koha-community's koha like in liblime koha, which are: 1. Libraries can create new receipt templates for reach library by clicking New Receipt Template in the Receipt Template Manager which we add in any sys pref i.e. at Tools. (in other words: Koha will features customizable print slips and a management interface for the creation, alteration, saving, and deleting of customize print slips circulation receipts). 2. Koha features a rich set of features around holds: including: - Ability to fill local holds first (thus reducing transportation costs) - Enriched holds queue report, including sort and pagination support for large list printing and functionality so a hold can be filled (triggered) or passed to another library directly from the report - New hold notices – for holds canceled and/or expired 3. the last I want to generate my report in word format also, as by default it is in csv format. Hope the community help me on these topics. Thanks in Advance, Sunil ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha