- Koha - lists.katipo.co.nz

SQL query to enable all patrons messaging preferences
by Vimal Kumar V. 01 Mar '17

01 Mar '17

Hi Liz, Thank you for the solution. It's working. Regards, -- Vimal Kumar V. Librarian School of Indian Legal Thought Mahatma Gandhi University Kottayam, Kerala Web: http://www.vimalkumar.info Blogs: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in http://dspacegeek.blogspot.in http://moovandan.blogspot.in <http://moovandan.blogspot.in> --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

1 0

Re: [Koha] Installing Koha on LInux Mint VERSION="18.1 (Serena)
by Daniel F. Twum 01 Mar '17

01 Mar '17

Database size after install was 10.7 MiB. On Tue, 28 Feb 2017 21:57:29 -0500, "Daniel F. Twum" wrote: The default timeout was not long enough so I kept getting timeouts during the table creation. I experimented with different values and finally used 6000 to see what will happen. That's when the table creation finally completed, and population also went to success as well. I am running on a Dell desktop with i7 processor and 16GB of RAM. During the install, I had Firefox as the only UI running. First few times I was running top to see what was happening but during the success runs, I stopped running so missed out on the swap business. Load average was higher than normal. cheers, --Daniel --------------------------------------------------------------------- Message: 1 Date: Tue, 28 Feb 2017 16:30:29 -0500 From: Paul A To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Installing Koha on LInux Mint VERSION="18.1 (Serena)" Message-ID: Content-Type: text/plain; charset=utf-8; format=flowed On 2017-02-27 06:19 AM, Daniel F. Twum wrote: [snip] >I had to increase Timeout in the /etc/apache2/apache2.conf to > myusbpc-XPS-8700 koha_ofosualibrary # grep Timeout /etc/apache2/apache2.conf > # Timeout: The number of seconds before receives and sends time out. > Timeout 6000 Did you "down-grade" MySQL to 5.5 / 5.6 or change to MariaDB? How big is your database, and how much memory was available? An hour and three quarters seems inordinately long, although a lack of multi-core threading might be a cause. Did this spill over into swap? Ref. point for us is that any MySql op that lasts for more than a couple of seconds (with 16 Gigs RAM on reasonably fast 8-core systems) is suspect as being badly coded. Mint, per se, shouldn't be a stumbling point -- it's only a desktop, and should have minimal impact on the underlying Debian/Ubuntu system. Best - Paul > > Thanks for your help. > > regards, > --Daniel > > > > On Sat, 25 Feb 2017 15:49:06 +0100, Tajoli Zeno wrote: > > Hi Daniel, > > Il 25/02/2017 15:32, Daniel F. Twum ha scritto: >> My first attempt at installing Koha on Linux Mint has encountered the > following issues: >> >> myusbpc@myusbpc-XPS-8700 ~/Downloads/koha-16.11.00 $ sudo apt-get install koha-common >> Reading package lists... Done >> Building dependency tree >> Reading state information... Done >> E: Unable to locate package koha-common >> >> I am following the instructions https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages >> Here is the history of what I did: >> 513 echo deb http://debian.koha-community.org/koha stable main | sudo tee /etc/apt/sources.list.d/koha.list >> 514 ll /etc/apt/sources.list.d/koha.list >> 515 cat /etc/apt/sources.list.d/koha.list >> 516 wget -O- http://debian.koha-community.org/koha/gpg.asc | sudo apt-key add - >> 517 sudo apt-get install koha-common >> > > the problem is that after 516 > >516 wget -O- http://debian.koha-community.org/koha/gpg.asc | sudo > apt-key add - > > you try to install koha-common > > 517 sudo apt-get install koha-common > > The correct sequence is: > wget -O- http://debian.koha-community.org/koha/gpg.asc | sudo apt-key add - > sudo apt-get update > sudo apt-get upgrade > sudo apt-get install koha-common > > > I suggest you to read all web page > https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages before to > continue > > Remeber that your version of Linux Mint uses MySQL 5.7 so check this > paragraph: > > https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Ubuntu_16.04… > > Generaly speaking use Linux Mint only if you know it very well. > Koha is tested on Debian and Ubuntu, we probaly have very little > experience on Linux Mint. > > Bye > Zeno Tajoli

1 0

Re: [Koha] Installing Koha on LInux Mint VERSION="18.1 (Serena)
by Daniel F. Twum 01 Mar '17

01 Mar '17

I did not "down-grade" but rather installed MariaDB. The final database size of table creation and population was: The default timeout was not long enough so I kept getting timeouts during the table creation. I experimented with different values and finally used 6000 to see what will happen. That's when the table creation finally completed, and population also went to success as well. I am running on a Dell desktop with i7 processor and 16GB of RAM. During the install, I had Firefox as the only UI running. First few times I was running top to see what was happening but during the success runs, I stopped running so missed out on the swap business. Load average was higher than normal. cheers, --Daniel --------------------------------------------------------------------- Message: 1 Date: Tue, 28 Feb 2017 16:30:29 -0500 From: Paul A To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Installing Koha on LInux Mint VERSION="18.1 (Serena)" Message-ID: Content-Type: text/plain; charset=utf-8; format=flowed On 2017-02-27 06:19 AM, Daniel F. Twum wrote: [snip] >I had to increase Timeout in the /etc/apache2/apache2.conf to > myusbpc-XPS-8700 koha_ofosualibrary # grep Timeout /etc/apache2/apache2.conf > # Timeout: The number of seconds before receives and sends time out. > Timeout 6000 Did you "down-grade" MySQL to 5.5 / 5.6 or change to MariaDB? How big is your database, and how much memory was available? An hour and three quarters seems inordinately long, although a lack of multi-core threading might be a cause. Did this spill over into swap? Ref. point for us is that any MySql op that lasts for more than a couple of seconds (with 16 Gigs RAM on reasonably fast 8-core systems) is suspect as being badly coded. Mint, per se, shouldn't be a stumbling point -- it's only a desktop, and should have minimal impact on the underlying Debian/Ubuntu system. Best - Paul > > Thanks for your help. > > regards, > --Daniel > > > > On Sat, 25 Feb 2017 15:49:06 +0100, Tajoli Zeno wrote: > > Hi Daniel, > > Il 25/02/2017 15:32, Daniel F. Twum ha scritto: >> My first attempt at installing Koha on Linux Mint has encountered the > following issues: >> >> myusbpc@myusbpc-XPS-8700 ~/Downloads/koha-16.11.00 $ sudo apt-get install koha-common >> Reading package lists... Done >> Building dependency tree >> Reading state information... Done >> E: Unable to locate package koha-common >> >> I am following the instructions https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages >> Here is the history of what I did: >> 513 echo deb http://debian.koha-community.org/koha stable main | sudo tee /etc/apt/sources.list.d/koha.list >> 514 ll /etc/apt/sources.list.d/koha.list >> 515 cat /etc/apt/sources.list.d/koha.list >> 516 wget -O- http://debian.koha-community.org/koha/gpg.asc | sudo apt-key add - >> 517 sudo apt-get install koha-common >> > > the problem is that after 516 > >516 wget -O- http://debian.koha-community.org/koha/gpg.asc | sudo > apt-key add - > > you try to install koha-common > > 517 sudo apt-get install koha-common > > The correct sequence is: > wget -O- http://debian.koha-community.org/koha/gpg.asc | sudo apt-key add - > sudo apt-get update > sudo apt-get upgrade > sudo apt-get install koha-common > > > I suggest you to read all web page > https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages before to > continue > > Remeber that your version of Linux Mint uses MySQL 5.7 so check this > paragraph: > > https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Ubuntu_16.04… > > Generaly speaking use Linux Mint only if you know it very well. > Koha is tested on Debian and Ubuntu, we probaly have very little > experience on Linux Mint. > > Bye > Zeno Tajoli

1 0

Ask for Koha platform
by autolib 01 Mar '17

01 Mar '17

Dear Sirs, I am writing to you from Lyuben Karavelov Regional Library - Ruse. We would like to use your Koha platform, but we have several questions first. We would like to know if there is any way that the data we enter can also be saved in our servers because if we encounter some internet related problem we would not have the access to them 1-How can we transfer the data that is stored in our local servers to your platform? Can you help us? 2-Is your platform capable of using multiple languages especially Bulgarian, Cyrillic? 3-Is there any limit of how many of our employees can use your platform simultaneously? Thank you! Regards, -- ПАВЕЛ ГОРАНОВ Администратор Отдел Автоматизация тел: +359876938566 [1] е-поща: autolib(a)libruse.bg РЕГИОНАЛНА БИБЛИОТЕКА "ЛЮБЕН КАРАВЕЛОВ" - ГРАД РУСЕ Русе, 7000, ул. Дондуков-Корсаков №1 libruse.bg [2] [3] Links: ------ [1] tel:+359876938566 [2] http://www.libruse.bg [3] https://www.facebook.com/Library.Ruse/

3 2

Exporting batchs in card creator
by Tony Morton 28 Feb '17

28 Feb '17

Hi there, I am trying to export a classroom "batch", however when I go to export it, it will not provide me with a document to print. I have deleted this and started all over again, and its still the same problem. I have had no troubles with the other 3 classes "batches". Is this common, or am I doing something wrong? I'm going under tools, patron card creator, manage batches - then I choose batch I want to export. Please advise. Thanks JO Ngā mihi - Kind regards Tony Tony Morton Dip ILS | Senior Librarian Waimate District Library Waimate District Council | 125 Queen Street | PO Box 122 | Waimate 7960 | New Zealand •: +64 3 689 0000 | DDI: +64 3 689 0071 | Ê: +64 3 689 8075 | Mobile: +64 0210740867

2 1

SQL query to enable all patrons messaging preferences
by Vimal Kumar V. 28 Feb '17

28 Feb '17

Dear Friends, I would like to enable all SMS and Email messaging preferences (Check-in, check-out etc) of all patrons. Kindly help me to create an SQL query to do the process. Regards, -- Vimal Kumar V. Librarian School of Indian Legal Thought Mahatma Gandhi University Kottayam, Kerala Web: http://www.vimalkumar.info Blogs: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in http://dspacegeek.blogspot.in http://moovandan.blogspot.in <http://moovandan.blogspot.in> --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

2 1

Installing Koha on LInux Mint VERSION="18.1 (Serena)"
by Daniel F. Twum 28 Feb '17

28 Feb '17

<head> <title></title> </head> <body> <div class="userStyles" style=" font-family: Arial; font-size: 12pt; color: #000000;">  <footer class="signatureContainer"> <pre class="bz_comment_text" id="comment_text_0" style="white-space: pre-wrap; width: 50em; background-color: rgb(255, 255, 255);">My first attempt at installing Koha on Linux Mint has encountered the following issues: myusbpc@myusbpc-XPS-8700 ~/Downloads/koha-16.11.00 $ sudo apt-get install koha-common Reading package lists... Done Building dependency tree Reading state information... Done E: Unable to locate package koha-common I am following the instructions @ <a href="https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages" style="color: rgb(51, 51, 51);">https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages</a> Here is the history of what I did: 513 echo deb <a href="http://debian.koha-community.org/koha" style="color: rgb(51, 51, 51);">http://debian.koha-community.org/koha</a> stable main | sudo tee /etc/apt/sources.list.d/koha.list 514 ll /etc/apt/sources.list.d/koha.list 515 cat /etc/apt/sources.list.d/koha.list 516 wget -O- <a href="http://debian.koha-community.org/koha/gpg.asc" style="color: rgb(51, 51, 51);">http://debian.koha-community.org/koha/gpg.asc</a> | sudo apt-key add - 517 sudo apt-get install koha-common My system settings are: myusbpc@myusbpc-XPS-8700 ~/Downloads/koha-16.11.00 $ cat /etc/os-release NAME="Linux Mint" VERSION="18.1 (Serena)" ID=linuxmint ID_LIKE=ubuntu PRETTY_NAME="Linux Mint 18.1" VERSION_ID="18.1" HOME_URL="<a href="http://www.linuxmint.com/" style="color: rgb(51, 51, 51);">http://www.linuxmint.com/</a>" SUPPORT_URL="<a href="http://forums.linuxmint.com/" style="color: rgb(51, 51, 51);">http://forums.linuxmint.com/</a>" BUG_REPORT_URL="<a href="http://bugs.launchpad.net/linuxmint/" style="color: rgb(51, 51, 51);">http://bugs.launchpad.net/linuxmint/</a>" VERSION_CODENAME=serena UBUNTU_CODENAME=xenial -- Please advise on how to proceed. Thanks.</pre> </footer> </div> </body>

3 4

Koha General IRC Meeting Reminder - 1 MArch 2017, 20 UTC
by Nick Clemens 28 Feb '17

28 Feb '17

Hello All, Just a reminder that tomorrow at 20 UTC is the monthly general IRC meeting for koha. Local time conversion here: http://www.timeanddate.com/worldclock/fixedtime.html?msg=Koha+IRC+General+M… The agenda is on the wiki here https://wiki.koha-community.org/wiki/General_IRC_meeting_1_March_2017 Please add anything you wish to discuss. See you soon! -Nick

1 0

Re: [Koha] Best Koha Implementation Award - 2017 (Koha Conclave)
by Nathan Curulla 28 Feb '17

28 Feb '17

Congratulations to the Vikram Sarabhai Library and the Mysore University Library!! Amit, can you please send me a quick email outlining this award so that I can draw up a community press release? Thanks!! > Nathan A. Curulla > Owner, CRO > ByWater Solutions > Support and Consulting for Open Source Software > Headquarters: Portland, OR. > East Coast Office: Redding, CT. > Phone/Fax # (888) 900-8944 xt 2 > Cell # (203) 685-7207 > http://bywatersolutions.com <http://bywatersolutions.com/> > nate(a)bywatersolutions.com <mailto:nate@bywatersolutions.com> >

1 0

Re: [Koha] Step-by-step guide to enable Koha Staff Client on another machine
by Vimal Kumar V. 27 Feb '17

27 Feb '17

Dear Jurgens I hope that this link useful for your purpose, http://kohageek.pbworks.com/w/page/51840331/Network%20Configuration Regards, -- Vimal Kumar V. Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: http://www.vimalkumar.org Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

6 7