Re: [Koha] Mysqldump and Ubuntu
Hi Clint. Both ways of entering the mysqldump command are valid and should work (at least they do on Debian, I don't have mysql installed on my Ubuntu desktop so can't check). If you type man mysqldump from the command line you will get a list of options, which will also show the shortcut way to enter the same command e.g. instead of --user=myuser you can just go -u myuser. This is very convenient if you need to run the command a lot. Most people, and lots of tutorials, tend to use the shortcut format. For an even quicker way you don't have to enter the space between the shortcut command and the value e.g. -u myuser can be entered as -umyuser In addition, you don't need to end the filename you are saving the data to with .sql, but a lot of people do to help identify what is in the file. You can open these files with any text editor. There are many good MySql tutorials on the web. A couple of good tutorials from a quick search are: - This one looks okay: http://www.mysqltutorial.org/how-to-backup-database-using-mysqldump.aspx - A good basic SQL general tutorial doesn't go astray either: http://w3schools.com/sql/default.asp David Nind | david.n...@gmail.com PO Box 12367, Thorndon, Wellington, New Zealand 6144 h. +64 4 9720 600 | m. +64 21 0537 847 | w. +64 4 8906 098 On 24 June 2012 13:55, clint.deckard clint.deck...@frontiers.co.nz wrote: Kia ora, I have spent a good deal of time getting mysqldump to work for me, partly because I am not an expert. Finally, I found out that Ubuntu (I installed this instance from KohaLiveCD) requires the format mysqldump --user=myuser --password=mypassword kohamysql_backup.sql this differs from the example in the wiki mysqldump -u myuser -p mypassword koha mydatadump.sql I thought I'd add this knowledge to the wiki but then thought perhaps I should check on this list first in case I make a fool of myself (again). Comments anyone? Clint. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. __**_ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/**mailman/listinfo/kohahttp://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] Recall function
Dear All I need to know if is recall function added to koha 3.8.1 or not if is not how i can add it or use it in this release Thanks for your effort Best Regards, Alaa BadriSystem and network administrator New Generation International Schools01227204728 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Mysqldump and Ubuntu
The wiki version you have here looks almost correct, except there should be no space after the -p. That space will cause errors. Otherwise, your version means exactly the same thing. -- Sent from my Android phone with K-9 Mail. Please excuse my brevity. clint.deckard clint.deck...@frontiers.co.nz wrote: Kia ora, I have spent a good deal of time getting mysqldump to work for me, partly because I am not an expert. Finally, I found out that Ubuntu (I installed this instance from KohaLiveCD) requires the format mysqldump --user=myuser --password=mypassword kohamysql_backup.sql this differs from the example in the wiki mysqldump -u myuser -p mypassword koha mydatadump.sql I thought I'd add this knowledge to the wiki but then thought perhaps I should check on this list first in case I make a fool of myself (again). Comments anyone? Clint. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. _ 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] Recall function
University libraries have it, where a student may be allowed, say, 3 recall requests per year to allow for things that are real emergencies. I used it once when I needed to verify something a week before my thesis was due. -- Sent from my Android phone with K-9 Mail. Please excuse my brevity. David Nind david.n...@gmail.com wrote: Hi Alaa. Koha doesn't have this feature as far as I can see in 3.8.1 or 3.8.2 (happy to be corrected if it does). There is an abandoned RFC (request for comment) for this: http://wiki.koha-community.org/wiki/Recall_requests_RFC Recalls are also mentioned in this RFC: http://wiki.koha-community.org/wiki/Messaging_rewrite_RFC To add this type of feature you could log an enhancement request, develop it yourself if you have the skills, or sponsor the development e.g. through another developer or one of the commercial Koha support companies: http://wiki.koha-community.org/wiki/Enhancement_Request_Guidelines As a non-librarian my only comment is that this seems like a very strange 'feature' to have. I have an item checked out, someone else wants it and can't wait until it is returned by the normal due date (using the holds/reserve feature), but can then make me return it early! (I know what my response would be!). After a quick search on the internet it looks like something academic libraries might use. I could understand this type of feature if the loan period for an item was months or years. As 'they' say, every library is a little different David Nind | david.n...@gmail.com PO Box 12367, Thorndon, Wellington, New Zealand 6144 h. +64 4 9720 600 | m. +64 21 0537 847 | w. +64 4 8906 098 On 24 June 2012 20:36, alaa Badri elbadri_fat...@hotmail.com wrote: Dear All I need to know if is recall function added to koha 3.8.1 or not if is not how i can add it or use it in this release Thanks for your effort Best Regards, Alaa BadriSystem and network administrator New Generation International Schools01227204728 _ 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
Re: [Koha] Recall function
Thanks All I will develop it for myself Best Regards, Alaa BadriSystem and network administrator New Generation International Schools01227204728 Subject: Re: [Koha] Recall function From: ro...@catalyst.net.nz Date: Sun, 24 Jun 2012 14:10:17 +0100 To: david.n...@gmail.com; elbadri_fat...@hotmail.com CC: koha@lists.katipo.co.nz University libraries have it, where a student may be allowed, say, 3 recall requests per year to allow for things that are real emergencies. I used it once when I needed to verify something a week before my thesis was due. -- Sent from my Android phone with K-9 Mail. Please excuse my brevity. David Nind david.n...@gmail.com wrote: Hi Alaa. Koha doesn't have this feature as far as I can see in 3.8.1 or 3.8.2 (happy to be corrected if it does). There is an abandoned RFC (request for comment) for this: http://wiki.koha-community.org/wiki/Recall_requests_RFC Recalls are also mentioned in this RFC: http://wiki.koha-community.org/wiki/Messaging_rewrite_RFC To add this type of feature you could log an enhancement request, develop it yourself if you have the skills, or sponsor the development e.g. through another developer or one of the commercial Koha support companies: http://wiki.koha-community.org/wiki/Enhancement_Request_Guidelines As a non-librarian my only comment is that this seems like a very strange 'feature' to have. I have an item checked out, someone else wants it and can't wait until it is returned by the normal due date (using the holds/reserve feature), but can then make me return it early! (I know what my response would be!). After a quick search on the internet it looks like something academic libraries might use. I could understand this type of feature if the loan period for an item was months or years. As 'they' say, every library is a little different David Nind | david.n...@gmail.com PO Box 12367, Thorndon, Wellington, New Zealand 6144 h. +64 4 9720 600 | m. +64 21 0537 847 | w. +64 4 8906 098 On 24 June 2012 20:36, alaa Badri elbadri_fat...@hotmail.com wrote: Dear All I need to know if is recall function added to koha 3.8.1 or not if is not how i can add it or use it in this release Thanks for your effort Best Regards, Alaa BadriSystem and network administrator New Generation International Schools01227204728 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
Re: [Koha] Recall function
On Jun 25, 2012 1:28 AM, alaa Badri elbadri_fat...@hotmail.com wrote: Thanks All I will develop it for myself And commit it back to Koha for all to use as well, I'm sure you also meant to say. :) Chris Best Regards, Alaa BadriSystem and network administrator New Generation International Schools01227204728 Subject: Re: [Koha] Recall function From: ro...@catalyst.net.nz Date: Sun, 24 Jun 2012 14:10:17 +0100 To: david.n...@gmail.com; elbadri_fat...@hotmail.com CC: koha@lists.katipo.co.nz University libraries have it, where a student may be allowed, say, 3 recall requests per year to allow for things that are real emergencies. I used it once when I needed to verify something a week before my thesis was due. -- Sent from my Android phone with K-9 Mail. Please excuse my brevity. David Nind david.n...@gmail.com wrote: Hi Alaa. Koha doesn't have this feature as far as I can see in 3.8.1 or 3.8.2 (happy to be corrected if it does). There is an abandoned RFC (request for comment) for this: http://wiki.koha-community.org/wiki/Recall_requests_RFC Recalls are also mentioned in this RFC: http://wiki.koha-community.org/wiki/Messaging_rewrite_RFC To add this type of feature you could log an enhancement request, develop it yourself if you have the skills, or sponsor the development e.g. through another developer or one of the commercial Koha support companies: http://wiki.koha-community.org/wiki/Enhancement_Request_Guidelines As a non-librarian my only comment is that this seems like a very strange 'feature' to have. I have an item checked out, someone else wants it and can't wait until it is returned by the normal due date (using the holds/reserve feature), but can then make me return it early! (I know what my response would be!). After a quick search on the internet it looks like something academic libraries might use. I could understand this type of feature if the loan period for an item was months or years. As 'they' say, every library is a little different David Nind | david.n...@gmail.com PO Box 12367, Thorndon, Wellington, New Zealand 6144 h. +64 4 9720 600 | m. +64 21 0537 847 | w. +64 4 8906 098 On 24 June 2012 20:36, alaa Badri elbadri_fat...@hotmail.com wrote: Dear All I need to know if is recall function added to koha 3.8.1 or not if is not how i can add it or use it in this release Thanks for your effort Best Regards, Alaa BadriSystem and network administrator New Generation International Schools01227204728 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 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha sending mail
Dear All can any one tell step by step how to set up koha 3.9 to send emails Best Regards, Alaa BadriSystem and network administrator New Generation International Schools01227204728 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha 3.6.6 released
The Koha community is proud to release Koha version 3.6.6. This is a bugfix release, and contains a number of important fixes You can obtain Koha 3.6.6 from the http://download.koha-community.org site. Debian packages will be available from the http://debian.koha-community.org shortly also. Please read the release notes below for more information RELEASE NOTES FOR KOHA 3.6.6 24 Jun 2012 Koha is the first free and open source software library automation package (ILS). Development is sponsored by libraries of varying types and sizes, volunteers, and support companies from around the world. The website for the Koha project is http://koha-community.org/ Koha 3.6.6 can be downloaded from: http://download.koha-community.org/koha-3.06.06.tar.gz Installation instructions can be found at: http://wiki.koha-community.org/wiki/Installation_Documentation OR in the INSTALL files that come in the tarball Koha 3.6.6 is a bugfix/maintenance release. Highlights of 3.6.6 == 7016 blocker CanBookBeReserved uses GetItemsInfo unnecessarily 7354 critical Can't edit local use system preferences 7528 critical amount subtracting 1 cent 7927 critical library not showing on subscription full history anymore 2012 major Add bilio crashes under no zebra 3969 major Budget Search Doesn't Work 5327 major Unit tests required for all C4 modules 6496 major authors appearing incorrectly in OPAC and Staff Client 6931 major hardcoded insert incompatible with UNIMARC Bugs fixed in 3.6.6 == 2399 normal All status fields in the item edit interface offer two blank/null entries per dropdown instead of one 3337 normal RSS link is not correct 3413 normal repeatable tickbox not sticking 1st time round 7722 normal Insidious problem with searching 7820 normal Missing packages from install_misc/debian.packages 7833 normal unique holiday link broken 7845 normal Multiple 260s don't display properly in search results 7922 normal Fixing typos and improving translations in German sample data 8022 normal Permissions test doesn't check all languages 8025 normal Patron attribute not selected if value is zero 1577 enhancement installer and language 7213 enhancement Document /svc/ HTTP API and provide example command-line client 7990 enhancement bad html attribute into aqplan.tt : styl= insted of style= System requirements == Changes since 3.4: * Perl 5.10 is required Documentation == As of Koha 3.2, the Koha manual is now maintained in DocBook. The home page for Koha documentation is http://koha-community.org/documentation/ As of the date of these release notes, only the English version of the Koha manual is available: http://manual.koha-community.org/3.6/en/ The Git repository for the Koha manual can be found at http://git.koha-community.org/gitweb/?p=kohadocs.git;a=summary Translations == Complete or near-complete translations of the OPAC and staff interface are available in this release for the following languages: * Chinese (China) * Chinese (Taiwan) * Danish * English (USA) * English (UK) * English (New Zealand) * French (Canada) * French (France) * German * Greek * Italian * Portuguese (Brazil) * Spanish Partial translations are available for various other languages. The Koha team welcomes additional translations; please see http://wiki.koha-community.org/wiki/Translating_Koha for information about translating Koha, and join the koha-translate list to volunteer: http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-translate The most up-to-date translations can be found at: http://translate.koha-community.org/ Release Team == The release team for Koha 3.6 is Release Manager:Chris Cormack chr...@catalyst.net.nz Documentation Manager: Nicole C Engard neng...@gmail.com Translation Manager:Frédéric Demians frede...@tamil.fr QA Manager: Ian Walls ian.wa...@bywatersolutions.com Bug Wranglers: MJ Ray, Marcel de Rooy, Paul Poulain, Mason James Past Release Maintainer (3.6.x): Chris Nighswonger cnighswon...@foundations.edu Release Maintainer (3.6.x): Jared Camins-Esakov jcam...@cpbibliography.com Credits == We thank the following libraries who are known to have sponsored new features in Koha 3.6: * Los Gatos Public Library * NEKLS * East Brunswick Public Library * Athens County Public Libraries * Horowhenua Library Trust * Halton Borough Council * South Taranaki District Council We thank the following individuals who contributed patches to Koha 3.6.6. 1 Gaetan Boisson 3 Jared Camins-Esakov 1 Colin Campbell 1 Galen Charlton 3 Chris Cormack 1 Stéphane Delaune 1 Jonathan Druart 1 Magnus Enger
Re: [Koha] Mysqldump and Ubuntu
Robin, thank you for your help. The space after the -p was the cause of the problems. Cheers, Clint. Robin Sheat wrote: The wiki version you have here looks almost correct, except there should be no space after the -p. That space will cause errors. Otherwise, your version means exactly the same thing. -- Sent from my Android phone with K-9 Mail. Please excuse my brevity. clint.deckard clint.deck...@frontiers.co.nz wrote: Kia ora, I have spent a good deal of time getting mysqldump to work for me, partly because I am not an expert. Finally, I found out that Ubuntu (I installed this instance from KohaLiveCD) requires the format mysqldump --user=myuser --password=mypassword kohamysql_backup.sql this differs from the example in the wiki mysqldump -u myuser -p mypassword koha mydatadump.sql I thought I'd add this knowledge to the wiki but then thought perhaps I should check on this list first in case I make a fool of myself (again). Comments anyone? Clint. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- This message has been scanned for viruses and dangerous content by *MailScanner* http://www.mailscanner.info/, and is believed to be clean. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Rebuild-zebra stops working very often...
Hi there
Here is what our technician said in relation to your message :
If Zebra cannot connect to the database, Koha itself will not work.
The database connection error is unrelated to the Koha search
problem.
The Zebra logs are located under /var/log/koha/library, I
have looked at the zebra-output.log file contained within
the directory, there is nothing in it and it hasn't been written to
since April 24. The zebra-error.log in the same directory
hasn't been written to since the computer was installed.
So I don't know what to do... We are stuck. I can't restart zebra every two
hours. Would reinstalling everything help? Wouldn't it take two weeks to set
up and fix everything?
If you have any idea about what's going on...
Cheers,
Sonia.
Subject: Re: [Koha] Rebuild-zebra stops working very often...
From: chr...@catalyst.net.nz
Date: Sun, 24 Jun 2012 13:10:41 +1200
To: sossola...@hotmail.com
CC: koha@lists.katipo.co.nz
Ahh that is not the zebra error log. But the rebuild zebra one. I think you may
be confusing zebra with the job to rebuild the zebra indexes, they are 2 quite
different things.
However not being able to talk to the database is a fatal error for the rebuild
zebra script. The database failing will also cause all sorts of other errors. I
would get your tech people to look at your database set up. Something very bad
is going wrong there.
Chris
Sonia P. sossola...@hotmail.com wrote:
Dear all
Thanks again for your help.
Here is (below) the content of the zebra error file. Would you please have a
look at it and tell me if there are things which could explain why
zebra-rebuild stops working now and then? There is that DBIconnect error, but
I am not sure it's related. And there is no time day in the error file, so I
can't check what happened when zebra rebuild doesn't work properly. (I have
removed all the multiple duplicates...)
Cheers,
Sonia.
Wide character in subroutine entry at /usr/share/perl5/MARC/Charset/Table.pm
line 96.
DBI connect('dbname=koha_library;host=localhost;port=3306','koha_library',...)
failed: Can't connect to loc
al MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) at
/usr/share/koha/lib/C4/Context.pm lin
e 692
Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (111) at /usr/share/koha/l
ib/C4/Context.pm line 692.
DBI connect('dbname=koha_library;host=localhost;port=3306','koha_library',...)
failed: Can't connect to loc
al MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) at
/usr/share/koha/lib/C4/Context.pm lin
e 692
Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (111) at /usr/share/koha/l
ib/C4/Context.pm line 692.
DBI connect('dbname=koha_library;host=localhost;port=3306','koha_library',...)
failed: Can't connect to loc
al MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at
/usr/share/koha/lib/C4/Context.pm line
692
Can't connect to local MySQL server throu
gh
socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/koha/lib
/C4/Context.pm line 692.
error retrieving biblio 12126 at
/usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 473.
error retrieving biblio 11493 at
/usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 473.
error retrieving biblio 13829 at
/usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 473.
$ Wide character in subroutine entry at /usr/share/perl5/MARC/Charset/Table.pm
line 96.
$ DBI
connect('dbname=koha_library;host=localhost;port=3306','koha_library',...)
failed: Can't connect to local MySQL server through socket
$ '/var/run/mysqld/mysqld.sock' (111) at /usr/share/koha/lib/C4/Context.pm line
692
error retrieving biblio 14703 at /usr/share/koha/bin/migration_tools/rebuild_
zebra.pl line 473.
$ Wide character in subroutine entry at /usr/share/perl5/MARC/Charset/Table.pm
line 96.
$ DBI
connect('dbname=koha_library;host=localhost;port=3306','koha_library',...)
failed: Can't connect to local MySQL server through socket
$ '/var/run/mysqld/mysqld.sock' (111) at /usr/share/koha/lib/C4/Context.pm line
692
$ error retrieving biblio 14703 at
/usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 473.
$ Wide character in subroutine entry at /usr/share/perl5/MARC/Charset/Table.pm
line 96.
$ DBI
connect('dbname=koha_library;host=localhost;port=3306','koha_library',...)
failed: Can't connect to local MySQL server through socket
$ '/var/run/mysqld/mysqld.sock' (111) at /usr/share/koha/lib/C4/Context.pm line
692
$ error retrieving biblio 14
703 at
/usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 473.
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
