- Koha - lists.katipo.co.nz

Problem with page number
by Luis Moises Rojas 20 Sep '17

20 Sep '17

I have a problem with the pages numbers when you do a seach. I mean, if you select: Search,if the search returns many data, you can see number at the footer of the screen like: 1 2 3... here is: 1 2 3 you can check at: http://catalogo.bijrd.gob.do Thanks -- *Luis Moisés Rojas P.*

2 1

Bug hold confirm and default location PROC problem
by vinod mishra 20 Sep '17

20 Sep '17

Dear All, Please find the two bugs reported in Koha 16.11.11 https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19346 https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19341 With Regards, Vinod Kumar Mishra, Assistant Librarian, Biju Patnaik Central Library (BPCL), NIT Rourkela, Sundergadh-769008, Odisha, India. Mob:91+9439420860 Website: http://mishravk.com/ ORCID ID: http://orcid.org/0000-0003-4666-7874 *"Spiritual relationship is far more precious than physical. Physical relationship divorced from spiritual is body without soul" -- Mahatma Gandhi*

1 0

Koha Facebook Groups
by George 19 Sep '17

19 Sep '17

Hello everyone, At the last IRC meeting someone asked about Koha Facebook groups. These are the two that I know of: Koha Users: https://www.facebook.com/groups/475420505905835 Koha Library System Project: https://www.facebook.com/groups/6381238597 Each group has about 3,000 members and there does seem to be a lot of overlap in membership. See you all later, George -- George Williams NExpress Coordinator Send NExpress support e-mails to nexpresshelp(a)nekls.org

1 0

Search Alphabetica
by Luis Moises Rojas 19 Sep '17

19 Sep '17

Hello everybody, If you go to: http://catalogo.bijrd.gob.do and search a book, you can see that there is not order. I have change these files: sort-string-utf-chr, word-phrase-utf.chr and nothing happen. Any idea? -- *Luis Moisés Rojas P.*

1 0

The University of hte South Pacific Library - seeking information on koha
by Elizabeth Fong 19 Sep '17

19 Sep '17

Dear Listserv members The USP Library has a network of 23 Libraries spread through the Pacific in 12 countries - Fiji, Cook Is, Kiribati, Marshall is., Nauru, Niue, Samoa, Solomon Islands, Tokelau, Tonga, Tuvalu and Vanuatu. The Library currently operates two ILS - SPYDUS and Athena (no longer supported by the vendor). The Library's preference is for one system. The countries are part of 3 time zones. I seek urgent responses from Koha academic libraries currently using Koha ; a `yes' or `no' will suffice but a paragraph is welcome. This will be most appreciated. 1. Is there a Koha version specific to Academic Libraries? 2. Can Koha be installed in a Windows environment? 3. Is Customer support 24/7? 4. Depending on the severity of the bug, what are the time ranges for solving a bug? 5. Does Koha have a Discovery Layer Service? 6. Does Koha have Predictive text searching? 7. Does Koha include an eRM module? 8. Does Koha have a Mobile Interface and Circulation for Android or iOS or HTML5 Browsers) 9. Does Koha have a Digital Asset Management System? 10. Does Koha have a Dashboard for Analytics Solution? 11. Does Koha have a drag-and-drop feature for creating ad-hoc reports? 12. Is Lending of ebooks possible with Koha? * Already answered: We would like to have truly centralized solution, however, our libraries are located in different countries and in different time zones. Can Koha cater for this so that each library located in different countries can have their respective timestamp to match their local time zone? Elizabeth C. Reade Fong Acting University Librarian, 1 January 2017- The Library The University of the South Pacific Laucala Campus Suva FIJI Email: Fong_e(a)usp.ac.fj Ph: (679) 3232363 Fax: (679) 3231528 Mobile (679) 7748760 http://www.usp.ac.fj/library 'We are what we repeatedly do. Excellence, then is not an act, but a habit' Aristotle.

3 2

Spam from BestBookBuddies (OpenLX)
by Owen Leonard 19 Sep '17

19 Sep '17

Has anyone else received spam from "BestBookBuddies - an Initiative of: OpenLX Technologies Pvt. Ltd." ? They recently spammed me and everyone else on my library's contact page. If it were up to me they would be removed from the list of paid support providers, but I don't think the rules explicitly forbid sending spam. -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org

10 14

Re: [Koha] Hide MARC View separator
by | dalmeida | 19 Sep '17

19 Sep '17

Thank you, Mark Alexander and Owen Leonard! It worked thanks to your help! But this code didn't work for my Koha version: $(document).ready(function(){ $("#MARCview").parent().hide(); }); This one did: $(".view a:contains('MARC view')").hide(); Thank you! Diva Almeida On Mon, Sep 18, 2017 at 1:16 PM, <koha-request(a)lists.katipo.co.nz> wrote: > Send Koha mailing list submissions to > koha(a)lists.katipo.co.nz > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.katipo.co.nz/mailman/listinfo/koha > or, via email, send a message with subject or body 'help' to > koha-request(a)lists.katipo.co.nz > > You can reach the person managing the list at > koha-owner(a)lists.katipo.co.nz > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Koha digest..." > > Today's Topics: > > 1. Re: Hide MARC View separator (Mark Alexander) > 2. Re: Problem with migration from KOHA 3.20 to 16.11.11 > (Przemek Kosiński) > 3. Some questions about virtualization. (Przemek Kosiński) > 4. Re: Some questions about virtualization. (Fridolin SOMERS) > 5. Re: Some questions about virtualization. (lists) > 6. Re: Some questions about virtualization. (Michael Kuhn) > 7. Check-out Counts difference (SATISH) > 8. Re: Some questions about virtualization. (Tim Young) > 9. Re: Some questions about virtualization. (Scott Owen) > > > ---------- Forwarded message ---------- > From: Mark Alexander <marka(a)pobox.com> > To: "| dalmeida |" <divalmeida(a)gmail.com> > Cc: koha <koha(a)lists.katipo.co.nz> > Bcc: > Date: Sun, 17 Sep 2017 20:55:18 -0400 > Subject: Re: [Koha] Hide MARC View separator > Excerpts from | dalmeida |'s message of 2017-09-16 18:57:03 +0100: > > Does anyone know how to hide MARC View separator on book Details page? > I'd > > like to have only Normal View and ISBD View. > > I used the following as a hint: > > https://wiki.koha-community.org/wiki/JQuery_Library#Hide_ > Marc_.26_ISBD_view_from_OPAC > > which recommended using: > > $(".view a:contains('MARC view')").hide(); > > But using Firefox's "Inspect Element" feature, I saw that the "MARC view" > tab > has an ID of "MARCview". So I was able to simplify the Javascript in > OPACUserJS preference to the following: > > $(document).ready(function(){ > $("#MARCview").hide(); > }); > > Note: I tested this only on 17.05. > > > > ---------- Forwarded message ---------- > From: "Przemek Kosiński" <p.kosinski(a)biblioteka24.eu> > To: koha(a)lists.katipo.co.nz > Cc: > Bcc: > Date: Mon, 18 Sep 2017 11:22:41 +0200 > Subject: Re: [Koha] Problem with migration from KOHA 3.20 to 16.11.11 > Hi, > > Thanks for the hints. This explained a lot to me. > The data transfer attempt was made only for testing. I tested how > migration works and whether there will be problems. Now I know what to > expect. > I plan to migrate data to KOHA 17.05 on Ubuntu server 16.04 in the near > future. > > Thank you and best regards > Przemek > > W dniu 15.09.2017 o 15:31, Jonathan Druart pisze: > >> Paul, >> >> I am sure you understood what I meant: the Koha debian packages are based >> on Jessie (and so Ubuntu 16.04). >> We had problems with Apache versions (2.4) and other Perl libs that were >> not packaged/packagable easily for Wheezy. >> Debian packages are generated by only 1 guy (Mirko) and developers are >> (almost) all working on the same system. Same for the CI, we only run >> tests >> on Ubuntu 16.04 and Jessie. If someone need Wheezy support (or any other >> linux distro support), they can contact us and propose their help. >> >> From the wiki page: >> """ >> As of November 2016, the Debian packages for Koha are based on Jessie >> (Debian 8). Xenial (Ubuntu 16.04 LTS) is based on Jessie. >> That means Ubuntu 14.04 LTS is no longer supported. >> """ >> + http://lists.koha-community.org/pipermail/koha-devel/2016-Ju >> ly/042874.html >> >> Regards, >> Jonathan >> >> On Thu, 14 Sep 2017 at 20:38 Paul A <paul.a(a)navalmarinearchive.com> >> wrote: >> >> On 2017-09-14 09:51 AM, someone wrote: >>> >>> Note that Ubuntu 14.04 is not longer supported. >>>> >>> >>> Please note that Ubuntu 14.04 LTS is supported until April 2019 -- >>> <https://www.ubuntu.com/info/release-end-of-life>. Koha tends to be very >>> pro-active with enhancements (a potentially marvelous thing) but >>> possibly might leave stable operating systems in the dust. >>> -- >>> Paul >>> Tired old sys-admin >>> [just celebrated 78 years of life, 62 years of FORTRAN, and 58 years of >>> COBOL] >>> [now ducking the inevitable flames] >>> [ ;=} ] >>> [still running Koha 3.8.24 on 14.04LTS as a reference, non-lending, >>> library at very respectable speeds on copper wire] >>> _______________________________________________ >>> Koha mailing list http://koha-community.org >>> Koha(a)lists.katipo.co.nz >>> https://lists.katipo.co.nz/mailman/listinfo/koha >>> >>> _______________________________________________ >> Koha mailing list http://koha-community.org >> Koha(a)lists.katipo.co.nz >> https://lists.katipo.co.nz/mailman/listinfo/koha >> >> > > -- > ************************************************* > Powiatowa i Miejska Biblioteka > Publiczna w Skarżysku-Kamiennej > www: www.biblioteka24.eu > mail: p.kosinski(a)biblioteka24.eu > ************************************************* > > > > ---------- Forwarded message ---------- > From: "Przemek Kosiński" <p.kosinski(a)biblioteka24.eu> > To: "koha@lists" <koha(a)lists.katipo.co.nz> > Cc: > Bcc: > Date: Mon, 18 Sep 2017 12:03:26 +0200 > Subject: [Koha] Some questions about virtualization. > Hi > I have some questions about virtualization. > > 1. Does anyone use KOHA on virtualized servers? > 2. What solution did you choose KVM, LXC / LDX, VMVare, ProxmoxVE or > Docker containers? > 3. Does it work on production servers or only on test servers? > 4. Problems, challenges, thoughts? > > Tips, hints, guides welcome;) > Przemek Kosinski > -- > ************************************************* > Powiatowa i Miejska Biblioteka > Publiczna w Skarżysku-Kamiennej > www: www.biblioteka24.eu > mail: p.kosinski(a)biblioteka24.eu > ************************************************* > > > > ---------- Forwarded message ---------- > From: Fridolin SOMERS <fridolin.somers(a)biblibre.com> > To: koha(a)lists.katipo.co.nz > Cc: > Bcc: > Date: Mon, 18 Sep 2017 12:39:21 +0200 > Subject: Re: [Koha] Some questions about virtualization. > Hi, > > We at Biblibre use LXD with Ubuntu Xenial as host and guest. > Super powerfull with a huge scalability, we run 50 Koha on one server. > In each container, unix user is always the same which makes scripting very > easy. > We use images to backup and create test/dev containers. > > PS : to show lxd env in prompt we used a trick : "hostname -A" in PS1 > instead of "hostname". > > Regards, > > Le 18/09/2017 à 12:03, Przemek Kosiński a écrit : > >> Hi >> I have some questions about virtualization. >> >> 1. Does anyone use KOHA on virtualized servers? >> 2. What solution did you choose KVM, LXC / LDX, VMVare, ProxmoxVE or >> Docker containers? >> 3. Does it work on production servers or only on test servers? >> 4. Problems, challenges, thoughts? >> >> Tips, hints, guides welcome;) >> Przemek Kosinski >> > > -- > Fridolin SOMERS > Biblibre - Pôles support et système > fridolin.somers(a)biblibre.com > > > > ---------- Forwarded message ---------- > From: lists <lists(a)merit.unu.edu> > To: koha(a)lists.katipo.co.nz > Cc: > Bcc: > Date: Mon, 18 Sep 2017 12:48:26 +0200 > Subject: Re: [Koha] Some questions about virtualization. > Hi Przemek, > > 1. Does anyone use KOHA on virtualized servers? >> > We do, yes. > > 2. What solution did you choose KVM, LXC / LDX, VMVare, ProxmoxVE or >> > Proxmox with ceph storage. > > 4. Problems, challenges, thoughts? >> > There are no differences with bare-metal, as far as we know. Only the many > benefits that virtualisation gives you. :-) > > MJ > > > > ---------- Forwarded message ---------- > From: Michael Kuhn <mik(a)adminkuhn.ch> > To: koha(a)lists.katipo.co.nz > Cc: > Bcc: > Date: Mon, 18 Sep 2017 13:32:43 +0200 > Subject: Re: [Koha] Some questions about virtualization. > Hi Przemek > > 1. Does anyone use KOHA on virtualized servers? >> > > I have installed about ten productive Koha instances so far. All of them > are on virtualized hosts. > > 2. What solution did you choose KVM, LXC / LDX, VMVare, ProxmoxVE or >> Docker containers? >> > > I never choose the solution myself, but the responsible IT department of > the library does. To my knowledge, some used Vmware, some LXC, some Proxmox > VE, of some I even don't know it and until now there was never reason to > care about it (as long as the people at the IT department know what they're > doing). > > My own Koha demo installation (koha.adminkuhn.ch) is virtualized with > Proxmox and hosted by an external IT provider (Contabo). This setup has 2 > CPU, 6 GB RAM, 500 GB harddisk and costs me less than 100 Euro per year. > > For my own local Koha test installations I usually use Virtualbox. > > 3. Does it work on production servers or only on test servers? >> > > Both. > > 4. Problems, challenges, thoughts? >> > > Generally the same problems as with physical machines but of course, a > virtual machine can never be as fast as a physical machine. Also there may > be problems if too many virtual machines are sitting on the same host resp. > if some of them are eating up CPU etc. So if you need total control and > maximum power there's still nothing better than hardware - but usually you > won't need that, so the benefits of virtualization (especially backups) > will outweigh everything else. > > Besides, there are only minor problems with virtualization, for example > > Best wishes: Michael > -- > Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis > Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz > T 0041 (0)61 261 55 61 · E mik(a)adminkuhn.ch · W www.adminkuhn.ch > > > > ---------- Forwarded message ---------- > From: SATISH <lis4satish(a)gmail.com> > To: Koha <koha(a)lists.katipo.co.nz>, satish <lis4satish(a)gmail.com> > Cc: > Bcc: > Date: Mon, 18 Sep 2017 17:07:34 +0530 > Subject: [Koha] Check-out Counts difference > Hi > > After upgrade from Koha 16.5 to 16.11.09.000 / Package Installation/ Ubuntu > 14.04 Desktop, In Patrons, did browser cache clearing. > > found two problems with check-out. > 1) for some patrons, "Check-out Count" is not same as "Circulation > History" > This is causing, confusion while patron login to their account using OPAC. > In OPAC, it showing Available even though it has been checkout. > For koha administrator, the "status" shows blank. > > 2) Unable to Check-in books, for some patrons. > > Therefore, it is most urgent for me to answer the patrons. > I did not understand what is the reason for this behaviour. > Can you please give your suggestions for a fix. > > > Looking forward for your valuable answers. > > With thanks > Satish MV > Librarian > Govt. Engineering College, Hassan. > Karnataka - 573201 > > > > ---------- Forwarded message ---------- > From: Tim Young <Tim.Young(a)lightsys.org> > To: "koha@lists" <koha(a)lists.katipo.co.nz> > Cc: > Bcc: > Date: Mon, 18 Sep 2017 07:02:19 -0500 > Subject: Re: [Koha] Some questions about virtualization. > I have done a fair bit with different ones of these. > > 1) Yes > > 2) I will spend most of my time discussing this below. Skipping this > answer for the moment. > > 3) Koha works fine on virtualized servers, so long as the host machine is > powerful enough to run it. For the most part, you never realize a service > is on a virtualized server, unless your virtualization environment has > issues. > > > Choosing a virtualization environment: > > The first rule is to *use what you are familiar with*. If all your > techies are Windows people, use Hypervisor. If they are all Linux, use one > of the Linux ones KVM, Proxmox, etc. If you already have a VMWare > presence, then you can add Koha to your VMWare host. > > Containers are a linux-only thing. If you go to install them on Windows, > it creates a Linux VM under which the containers run. Containers work very > nicely if you have lots and lots of machines, or if you are really strapped > for CPU power But if you have never used containers before, the learning > curve is a lot steeper than you might think. Remember, not only do you > need to get a server running, but you need to be able to back it up. > > > If you are starting into Virtualization, the first question is what > operating systems do you know. The Linux hosting options are very nice if > you know Linux pretty well. Proxmox, for example, is a paid-for GUI that > you can use to access the free Linux KVM stuff. Linux does that all for > free, but the interface is either harder to set up, or very manual. You > can use an openstack or cloudstack, but those are very complex and awkward > to maintain if you are new at virtualization. I like Linux, and I use > Linux VMs all the time. But, more people prefer hypervisor or VMWare > because they have much nicer user interfaces. As nice as virtualization > is, you need to get something you can manage. No server is "turn it on and > forget it." All servers require backing up, upgrading, and the like. With > Virtualization, you want to be able to take snapshots and access the > machine "console" if it has an issue booting. > > Windows licenses are always a pain. I think "understanding licensing" is > the biggest complaint I hear from people who use Windows Hypervisor. And > it can get fairly expensive. > > The biggest complaint I hear from Linux people is the interface and trying > to manage the machine from a Windows platform. > > The biggest complaint I hear from VMWare people is that it is hard to > manage the computer from a machine that you do not have everything set up > on. And, the VMWare licenses usually end up costing a fair bit more than > you anticipated. > > You may notice I did not mention Oracle Virtualbox as an option. Many > people are tempted to use it since it appears to be free. It does have a > lot of features, but it does not scale well in the server world. And, you > are supposed to pay for it if you are using it for servers. It is an > awesome virtualization environment for testing and for use for yourself, > but the free setup is missing a lot of features (like, starting VMs at > boot) which you expect out of a server platform. I have never use it in a > paid-for environment; I am sure it would work well, but it is the one > platform I have not used myself. > > My 2c. > > - Tim Young > > On 9/18/2017 5:03 AM, Przemek.KosiA(a)LightSys.org wrote: > >> Hi >> I have some questions about virtualization. >> >> 1. Does anyone use KOHA on virtualized servers? >> 2. What solution did you choose KVM, LXC / LDX, VMVare, ProxmoxVE or >> Docker containers? >> 3. Does it work on production servers or only on test servers? >> 4. Problems, challenges, thoughts? >> >> Tips, hints, guides welcome;) >> Przemek Kosinski >> > > > > > ---------- Forwarded message ---------- > From: Scott Owen <sowen(a)edzone.net> > To: "koha@lists" <koha(a)lists.katipo.co.nz> > Cc: > Bcc: > Date: Mon, 18 Sep 2017 08:15:56 -0400 > Subject: Re: [Koha] Some questions about virtualization. > "The biggest complaint I hear from VMWare people is that it is hard to > manage the computer from a machine that you do not have everything set up > on. And, the VMWare licenses usually end up costing a fair bit more than > you anticipated." > > ---the flip side.....ESXi is still free. I have run and entire school > district off 3-4 EXSi servers for a number of years.... > I truly just don't need all the bells/whistles (and cost) of the fully > licensed VMware products. > ESXi 6 (latest version) runs from a web browser...no special client needed. > > ESXi -- free...Koha ---free.....all you have to purchase is the hardware. > > I have run 3 Koha VM's off ESXi for a few years now....no issues that could > be attributed to a virtual infrastructure. > > > > > > On Mon, Sep 18, 2017 at 8:02 AM, Tim Young <Tim.Young(a)lightsys.org> wrote: > > > I have done a fair bit with different ones of these. > > > > 1) Yes > > > > 2) I will spend most of my time discussing this below. Skipping this > > answer for the moment. > > > > 3) Koha works fine on virtualized servers, so long as the host machine is > > powerful enough to run it. For the most part, you never realize a > service > > is on a virtualized server, unless your virtualization environment has > > issues. > > > > > > Choosing a virtualization environment: > > > > The first rule is to *use what you are familiar with*. If all your > > techies are Windows people, use Hypervisor. If they are all Linux, use > one > > of the Linux ones KVM, Proxmox, etc. If you already have a VMWare > > presence, then you can add Koha to your VMWare host. > > > > Containers are a linux-only thing. If you go to install them on Windows, > > it creates a Linux VM under which the containers run. Containers work > very > > nicely if you have lots and lots of machines, or if you are really > strapped > > for CPU power But if you have never used containers before, the learning > > curve is a lot steeper than you might think. Remember, not only do you > > need to get a server running, but you need to be able to back it up. > > > > > > If you are starting into Virtualization, the first question is what > > operating systems do you know. The Linux hosting options are very nice > if > > you know Linux pretty well. Proxmox, for example, is a paid-for GUI that > > you can use to access the free Linux KVM stuff. Linux does that all for > > free, but the interface is either harder to set up, or very manual. You > > can use an openstack or cloudstack, but those are very complex and > awkward > > to maintain if you are new at virtualization. I like Linux, and I use > > Linux VMs all the time. But, more people prefer hypervisor or VMWare > > because they have much nicer user interfaces. As nice as virtualization > > is, you need to get something you can manage. No server is "turn it on > and > > forget it." All servers require backing up, upgrading, and the like. > With > > Virtualization, you want to be able to take snapshots and access the > > machine "console" if it has an issue booting. > > > > Windows licenses are always a pain. I think "understanding licensing" is > > the biggest complaint I hear from people who use Windows Hypervisor. And > > it can get fairly expensive. > > > > The biggest complaint I hear from Linux people is the interface and > trying > > to manage the machine from a Windows platform. > > > > The biggest complaint I hear from VMWare people is that it is hard to > > manage the computer from a machine that you do not have everything set up > > on. And, the VMWare licenses usually end up costing a fair bit more than > > you anticipated. > > > > You may notice I did not mention Oracle Virtualbox as an option. Many > > people are tempted to use it since it appears to be free. It does have a > > lot of features, but it does not scale well in the server world. And, > you > > are supposed to pay for it if you are using it for servers. It is an > > awesome virtualization environment for testing and for use for yourself, > > but the free setup is missing a lot of features (like, starting VMs at > > boot) which you expect out of a server platform. I have never use it in > a > > paid-for environment; I am sure it would work well, but it is the one > > platform I have not used myself. > > > > My 2c. > > > > - Tim Young > > > > On 9/18/2017 5:03 AM, Przemek.KosiA(a)LightSys.org wrote: > > > >> Hi > >> I have some questions about virtualization. > >> > >> 1. Does anyone use KOHA on virtualized servers? > >> 2. What solution did you choose KVM, LXC / LDX, VMVare, ProxmoxVE or > >> Docker containers? > >> 3. Does it work on production servers or only on test servers? > >> 4. Problems, challenges, thoughts? > >> > >> Tips, hints, guides welcome;) > >> Przemek Kosinski > >> > > > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > > -- D'Almeida Ateliê *arte final desde 1997*divalmeida.com S E T Ú B A L . P O R T U G A L

1 0

Hide MARC View separator
by | dalmeida | 18 Sep '17

18 Sep '17

Hi, Does anyone know how to hide MARC View separator on book Details page? I'd like to have only Normal View and ISBD View. Many thanks for any tip. Diva -- D'Almeida Ateliê *arte final desde 1997*divalmeida.com S E T Ú B A L . P O R T U G A L

3 2

Some questions about virtualization.
by Przemek Kosiński 18 Sep '17

18 Sep '17

Hi I have some questions about virtualization. 1. Does anyone use KOHA on virtualized servers? 2. What solution did you choose KVM, LXC / LDX, VMVare, ProxmoxVE or Docker containers? 3. Does it work on production servers or only on test servers? 4. Problems, challenges, thoughts? Tips, hints, guides welcome;) Przemek Kosinski -- ************************************************* Powiatowa i Miejska Biblioteka Publiczna w Skarżysku-Kamiennej www: www.biblioteka24.eu mail: p.kosinski(a)biblioteka24.eu *************************************************

6 5

Problem with migration from KOHA 3.20 to 16.11.11
by Przemek Kosiński 18 Sep '17

18 Sep '17

Hello, I have some problems with migration to new server and migrate to new version koha. On the old server with KOHA 3.20 I made the command "koha-dump biblio-main" (it's an instance name) - everything is fine - backup done. and On new test server with KOHA 16.11 execute command koha-restore biblio-main-2017-09-13.sql.gz biblio-main-2017-09-13.tar.gz Serwer parameters: Server: Ubuntu 14.04 LST Mysql: mysql Ver 14.14 Distrib 5.5.57, for debian-linux-gnu (x86_64) using readline 6.3 Apache: Server version: Apache/2.4.7 (Ubuntu) Restored? Not! It didn't work. After the above command - I received such output at the terminal: ERROR 1396 (HY000) at line 1: Operation DROP USER failed for 'koha_biblio-main'@'%' ERROR 1046 (3D000) at line 2: No database selected DBI connect('database=koha_biblio-main;host=localhost;port=3306','koha_biblio-main',...) failed: Access denied for user 'koha_biblio-main'@'%' to database 'koha_biblio-main' at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1395. DBI connect('database=koha_biblio-main;host=localhost;port=3306','koha_biblio-main',...) failed: Access denied for user 'koha_biblio-main'@'%' to database 'koha_biblio-main' at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1395. DBI connect('database=koha_biblio-main;host=localhost;port=3306','koha_biblio-main',...) failed: Access denied for user 'koha_biblio-main'@'%' to database 'koha_biblio-main' at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1395. DBI connect('database=koha_biblio-main;host=localhost;port=3306','koha_biblio-main',...) failed: Access denied for user 'koha_biblio-main'@'%' to database 'koha_biblio-main' at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1395. DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: Access denied for user 'koha_biblio-main'@'%' to database 'koha_biblio-main' at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1398. at /usr/share/koha/lib/Koha/Database.pm line 90 Something went wrong rebuilding biblio indexes for biblio-main DBI connect('database=koha_biblio-main;host=localhost;port=3306','koha_biblio-main',...) failed: Access denied for user 'koha_biblio-main'@'%' to database 'koha_biblio-main' at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1395. DBI connect('database=koha_biblio-main;host=localhost;port=3306','koha_biblio-main',...) failed: Access denied for user 'koha_biblio-main'@'%' to database 'koha_biblio-main' at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1395. DBI connect('database=koha_biblio-main;host=localhost;port=3306','koha_biblio-main',...) failed: Access denied for user 'koha_biblio-main'@'%' to database 'koha_biblio-main' at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1395. DBI connect('database=koha_biblio-main;host=localhost;port=3306','koha_biblio-main',...) failed: Access denied for user 'koha_biblio-main'@'%' to database 'koha_biblio-main' at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1395. DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: Access denied for user 'koha_biblio-main'@'%' to database 'koha_biblio-main' at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1398. at /usr/share/koha/lib/Koha/Database.pm line 90 Something went wrong rebuilding authority indexes for biblio-main * Restarting web server apache2 [Thu Sep 14 13:53:41.069404 2017] [core:warn] [pid 30685] AH00111: Config variable ${instance} is not defined [Thu Sep 14 13:53:41.069560 2017] [core:warn] [pid 30685] AH00111: Config variable ${instance} is not defined [Thu Sep 14 13:53:41.070842 2017] [core:warn] [pid 30685] AH00111: Config variable ${instance} is not defined [Thu Sep 14 13:53:41.070867 2017] [core:warn] [pid 30685] AH00111: Config variable ${instance} is not defined [ OK ] After open url with koha - browser show: Software error: DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: Access denied for user 'koha_biblio-main'@'%' to database 'koha_biblio-main' at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1398. at /usr/share/koha/lib/Koha/Database.pm line 90 Compilation failed in require at /usr/share/koha/intranet/cgi-bin/mainpage.pl line 31. BEGIN failed--compilation aborted at /usr/share/koha/intranet/cgi-bin/mainpage.pl line 31. I tried changing database password or adding user with privileges via mysql console - it did not work. Any solution, idea, help? Best regards, Przemek Kosiński -- ************************************************* Powiatowa i Miejska Biblioteka Publiczna w Skarżysku-Kamiennej www: www.biblioteka24.eu mail: p.kosinski(a)biblioteka24.eu *************************************************

4 5