[Koha] Restoring the default Marc Framework
Hi all I altered the default marc Framework. I understand that it's not a good idea. How can I restore the original Default MARC Framework (in my case the one at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql Does simply running mysql -u koha_instancename -p koha_instancename marc21_framework_DEFAULT.sql do the job? Or is this dangerous? cu Beda ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Migration issues from ancient 2.2.5 to 3.x
Hi all, I intend to migrate from an ancient in-production system - 2.2.5 running on FC4 to 3.10.4 running on Debian. As the first step I'm trying to move the data into Koha 3.0. So far I've tried to follow : 1) http://wiki.koha-community.org/wiki/Upgrading_2.2 2) http://lists.katipo.co.nz/public/koha/2011-August/030213.html Here what I have done. 1. Setup a VM running Koha 3.0 on Ubuntu 8.04 2. Taken a DB dump of 2.2.5 with Drop table if exist syntax. 3. Dropped the 3.0's tables from the DB and imported the 2.2.5 db 4. Followed the instructions from the Wiki article. Thing seems to work and I can login etc. However, a whole load of system preferences are missing from the db even after going through the 22_to_30 scripts Specifically I'm missing : StaffClient TemplateEncoding : utf-8 StaffClient Intranetcolorstylesheet : blue.css (to have some blue colors. This step is not required, you can skip it) StaffClient Template : prog What do you suggest I do? tia, -indra -- Indranil Das Gupta Phone : +91-98300-20971 Blog: http://indradg.randomink.org/blog IRC : indradg on irc://irc.freenode.net Twitter : indradg -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- Please exchange editable Office documents only in ODF Format. No other format is acceptable. Support Open Standards. For a free editor supporting ODF, please visit LibreOffice - http://www.documentfoundation.org ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Migration issues from ancient 2.2.5 to 3.x
Hi, On Fri, Apr 12, 2013 at 9:32 AM, Indranil Das Gupta indr...@gmail.com wrote: However, a whole load of system preferences are missing from the db even after going through the 22_to_30 scripts Specifically I'm missing : StaffClient TemplateEncoding : utf-8 StaffClient Intranetcolorstylesheet : blue.css (to have some blue colors. This step is not required, you can skip it) StaffClient Template : prog What do you suggest I do? Fortunately, just adding the missing system preferences will do the right thing. A quick and dirty way to get them in with the default values would be to [1] Create a unique index on systempreferences.variable. [2] Run the following; the unique index will prevent duplicates system preferences from being loaded: mysql [connection info] --force installer/data/mysql/sysprefs.sql [3] Drop the unique index. Regards, Galen -- Galen Charlton Manager of Implementation Equinox Software, Inc. / The Open Source Experts email: g...@esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web:http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org http://evergreen-ils.org ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Restoring the default Marc Framework
I altered the default marc Framework. I understand that it's not a good idea. How can I restore the original Default MARC Framework (in my case the one at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql First, do a backup. As you talk about instances, I presume you are using packages. Frameworks are stored in the database, so first detect which database you need to change, i.e. which instance. Look in /etc/koha/sites/instance/koha-conf.xml, near the end you will find name of database, dbuser and dbpassword Next, remove default framework mysql -uuser -ppass db -e delete from marc_tag_structure where frameworkcode = ''; delete from marc_subfield_structure where frameworkcode = '' Next, load default framework mysql -uuser -ppass db /usr/share/koha/intranet/cgi- bin/installer/data/mysql/de-DE/marcflavour/marc21/ mandatory/marc21_framework_DEFAULT.sql Regards, Bernardo ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Can't reach web install on Ubuntu 12.04
Triana: Here are a few things to try: --If you are using DNS, can you ping the server using the DNS address? --Can you access the staff interface using the IP address of the server? --On the server itself, assuming you have a windowing desktop installed, can you open the staff interface using localhost? -- Greg Lawson Network Administrator Rolling Hills Consolidated Library 1912 N. Belt Highway St. Joseph, MO 64506 - On 04/12/2013 11:12 AM, Triana Carmenate wrote: I am trying to install Koha on Ubuntu 12.04 Desktop, following the instructions from here http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages. However, when I try to access the administration website it will not open. I am using a dynamic dns. Is there anything I need to configure with apache2 to get my site running? Thanks, tcarm ___ 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] Can't reach web install on Ubuntu 12.04
Hi, On Fri, Apr 12, 2013 at 9:42 PM, Triana Carmenate tcarm...@fiu.edu wrote: However, when I try to access the administration website it will not open. I am using a dynamic dns. Is there anything I need to configure with apache2 to get my site running? Dynamic dns shouldn't be the issue. Koha works just fine with dyndns as long as other things being equal. Check if your iptables rules are an issue. Unlikely on a stock Ubuntu, but still good to get out of the way. Check if you can ping the box on the dynamic IP. The places to check would be your Koha instance specific httpd.conf includes and ports.conf and make sure that your VirtualHost and Listen directives are setup correctly. hth -indra -- Indranil Das Gupta Phone : +91-98300-20971 Blog: http://indradg.randomink.org/blog IRC : indradg on irc://irc.freenode.net Twitter : indradg -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- Please exchange editable Office documents only in ODF Format. No other format is acceptable. Support Open Standards. For a free editor supporting ODF, please visit LibreOffice - http://www.documentfoundation.org ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Can't reach web install on Ubuntu 12.04
Greetings, What did you put in the /etc/koha/koha-sites.conf file? (http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Pre-Web_Install_Setup) What does your /etc/hosts file contain? Are you trying to use the Ubuntu Desktop browser or are you trying to access it from another machine? The other email had some good ideas. The problem we have is determining WHERE the problem is: 1) Networking issue? -- glaws suggested a ping. $ ping {fully qualified domain name, e.g. www.koha-community.org} If you can't ping it, then you have a networking issue. 2) Apache issue? Is it even running? -- glaws suggested trying to go the IP address of the machine. The problem with this is that depending on your koha-sites.conf file, you may not be able to access the staff client because named hosts are assumed in these instructions. Can you get a page that says the system is down for maintenance at least? That's actually a good sign. 3) Some other issue? This is where I struggled with how much to write or not write in these instructions. Explaining how to fix /etc/apache2/ports.conf, /etc/apache2/sites-available/library (or whatever you called your OPAC), /etc/hosts, and these sorts of tweaks require a level of network and software administration that the novice linux user is not going to have. This is why I put important commands in the blue boxes. Reading around the blue boxes to make sure they are the ones to do is the only key part. If you follow these instructions without variation you will have a library.framisdooby.org and library-intra.framisdooby.org working. Though, they will not be accessible by another machine. Oh, and you can't dynamic dns to a 192.168.x.x address, because the dynamic dns site is external, and 192.168.x.x is an internal network address. GPML, Mark Tompsett ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha