- Koha - lists.katipo.co.nz

Book info in database
by Christoffer Landtman 22 Apr '03

22 Apr '03

I tried to decipher the koha.mysql file in search of the table(s) containing the book information, however, not succeeding as wished. As such I'm asking if someone could enlighten me on this matter? The question is in which table(s) is the book-information stored. By looking at the size of the different tables i could conclude that Koha does not implement all MARC-fileds e.g. when imoprting from MARC. Correct me if im wrong...=) Well, any help is appreciated, since it for me is vital information. Thanks in advance! -- Christoffer Landtman lanttis(a)homeharmony.fi www.homeharmony.fi

3 4

Re: [Koha] MARC import trouble
by Stephen Hedges 22 Apr '03

22 Apr '03

On April 11, Paul Poulain answered a question from Joshua Ferraro about importing MARC records in 1.9.x: > - the script to migrate from a previous ILS is > still to be done. Do we have any projected date for when this will be completed? We'd like very much to start testing Koha with our data, but we're not eager to re-catalogue 200,000+ items! If the MARC import utility is going to be delayed for very long, then we'll have to devise some other work-around to get our MARC data into 1.9.x. Has anyone else found a way to move their MARC data into Koha? (For instance, how did Dombes Abbey do it?) Stephen Hedges Nelsonville Public Library

2 1

Re: [Koha] Internal server error
by Mohamed Amin 22 Apr '03

22 Apr '03

1 0

Intranet Security
by Joshua Ferraro 22 Apr '03

22 Apr '03

I have been thinking about the current intranet security setup whereby any staff member can access any part of the intranet. Is this the policy in the libraries that are currently using Koha? It may be important to some of the larger systems (where more than a dozen people are using the intranet) to increase the levels of password protection. My concern is less of a control issues and more of an "oops I just deleted our main branch" issue. Even adding one more layer by seperating the admin from the normal staff functions might be useful. Even better, maybe users could be added and given "permission" to access parts of the intranet. What does everyone think? Joshua

5 4

remove me please!
by Daniel Dickinson 21 Apr '03

21 Apr '03

please remove me from your mailing lists for the time being. Thanks.Daniel Dickinson --------------------------------- Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo.

1 0

Re: [Koha] Internal server error
by Mohamed Amin 20 Apr '03

20 Apr '03

2 1

Re: [Koha] Internal server error (fwd)
by Ron Wickersham 19 Apr '03

19 Apr '03

hi Mohamed, last weekend i installed Mandrake 9.0 and Koha 1.9.2, so a different version, but i think the same things will apply. the installer script for 1.9.2 set up virtual hosting entries in /etc/httpd/conf/httpd.conf. in the default Mandrake apache configuration, the cgi scripts won't execute since the Koha installer needs to put the cgi-scripts in it's own directory structure. i added the directory section in the opac virtual host section after the line ScriptAlias /cgi-bin/koha/ /usr/local/koha/opac/cgi-bin/ <Directory /usr/local/koha/opac/cgi-bin> AllowOverride None Options ExecCGI Order allow,deny Allow from all </Directory> in the intranet virtual host section after the line ScriptAlias /cgi-bin/koha/ "/usr/local/koha/intranet/cgi-bin/" <Directory /usr/local/koha/intranet/cgi-bin> AllowOverride None Options ExecCGI Order allow,deny Allow from all </Directory> then you need to apache. (mandrake 9.0 has apachectl in the default path so you can just type apachectl at a command prompt) # apachectl configtest (which should say OK) # apachectl graceful and at that point the cgi scripts are authorized to run. -ron On Thu, 17 Apr 2003, Mohamed Amin wrote: > Date: Thu, 17 Apr 2003 15:45:11 +0000 > From: Mohamed Amin <abo_amin(a)hotmail.com> > To: chris(a)katipo.co.nz > Subject: [Koha] Internal server error > > <html><div style='background-color:'>Hi I've installed Koha 1.2.3 on Linux Mandrake , Mysql , Perl5.8, and it's installed successfully . but it does not work , the browser gives me an error >  said " Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. " > this error appears when I try to execute any perl script . All html files are working properly I tried to execute these scripts from the command prompt like ( # perl search.pl ) it gave an output but with this header > [root@lib cgi-bin]# perl search.pl Issuing rollback() for database handle being DESTROY'd without explicit disconnect() at search.pl line 18, <KC> line 33. Issuing rollback() for database handle being DESTROY'd without explicit disconnect () at /usr/lib/perl5/site_perl/5.6.0/i386-linux/C4/Search.pm line 203, <KC> line 66. Issuing rollback() for database handle being DESTROY'd without explicit disconnect() at search.pl line 76, <KC> line 66. Set-Cookie: sessionID=; path=/; expires=Fri, 16-Apr-2004 17:30:10 GMT Date: Thu, 17 Apr 2003 17:30:10 GMT Content-Type: text/html; charset=ISO-8859-1 > <!doctype html public "-//w3c//dtd html 4.0 transitional//en">   > <html> <head> <title>KOHA: INTRANET: Catalogue</title> > <style type="text/css">  > </style> > <SCRIPT LANGUAGE="JavaScript">  >  > <table cellpadding=0 cellspacing=0 width="100%" border=0> <tr bgcolor=663266 > >         <td  valign=top>         <table cellpadding=0 cellspacing=0  border=0 height=29>         <tr valign=top bg color=663266 >         <td background="/images/catalogue-spot-1.gif" width="224"         height="29"><img src="/images/holder.gif" widt h=210 height=4 alt=" " hspace=0 vspace=0>         <img src="/images/holder.gif"         width=35 height=21 align=left alt=" " hspace=0 vspace=0>KOHA: <a href="/cgi-bin/koha/mainpage.pl">Main Menu</a>         <img src="/images/holder.gif" width=210 height=1 alt=" " hspace=0 vspace=0>&l! > t;/FONT></td> >         </TR></TABLE> </td> >         <td  valign=bottom align=right> <img src="/images/holder.gif"  WIDTH=1  HEIGHT=38 HSPACE=0 vspace=0></td> <td  valign=bottom align=right>          <table cellpadding=0 cellspacing=0  border=0 height=29><tr><td> <img src=/images/cat-cat.gif border="0" name=menu usemap="#map" HSPACE=0 vspace=0 ></td> >         </TR></TABLE></TD> </tr> > </tr> <TR VALIGN=TOP BGCOLOR="000000"><TD  COLSPAN=3><img src="/images/blackdot.gif"  WIDTH=1  HEIGHT=2  HSPACE=0 vspace=0></TD></TR> > </table> > <map name="map"> <area shape="rect" coords="18,8,84,27" href="/cgi-bin/koha/catalogue-home.pl" alt="Catalogue" onMouseOver="if(document.images)document.menu.src='/images/cat-cat.gif'" onMouseOut="if(document.images)document.menu.src=' /images/cat-cat.gif'"> > <area shape="rect" coords="94,8,149,28" href="/cgi-bin/koha/members-home.pl" alt="Members" onMouseOver="if(document.images)document.menu.src='/images/cat-mem.gif'" onMouseOut="if(document.images)document.menu.src='/images/cat-cat.gif'"> > <area shape="rect" coords="154,9,212,29" alt="Acquisitions"   href="/cgi-bin/koha/loadmodules.pl?module=acquisitions" onMouseOver="if(document.images)document.menu.src='/images/cat-acq.gif'" onMouseOut="if(document.images)document.menu.s rc='/images/cat-cat.gif'"> > <area  shape="rect"alt="Reports"  coords="217,7,289,27"href="/cgi-bin/koha/reports-home.pl" onMouseOver="if(document.images)document.menu.src='/images/cat-rep.gif'" onMouseOut="if(document.images)document.menu.src='/images/cat-cat.gif'"& gt; > <area shape="rect" coords="306,8,352,27" href="/cgi-bin/koha/circ/circulation.pl" alt="Circulation" onMouseOver="if(document.images)document.menu.src='/images/cat-crc.gif'" onMouseOut="if(document.images)document.menu.src='/images/cat-cat.gif'"&gt ; > <area  shape="rect" alt="Home" coords="374,9,419,29" href="/cgi-bin/koha/mainpage.pl" onMouseOver="if(document.images)document.menu.src='/images/cat-hom.gif'" onMouseOut="if(document.images)document.menu.src='/images/cat-cat.gif'"> < area shape="default" nohref> </map> >   > <BLOCKQUOTE> > <center> >     <a href=/cgi-bin/koha/userpage.pl>Log In</a> to Koha >   >     You did not specify any seach criteria >  results found >      >         <img src=/images/numbers/placeholder.gif border=0> >   >         <img src=/images/numbers/placeholder.gif border=0> >     >   >  >     Try another <a href=/cgi-bin/koha/catalogue-home.pl>search</a> >   > &nbsp; > </BLOCKQUOTE> > <table cellpadding=0 cellspacing=0 width="100%" border=0> <TR VALIGN=TOP BGCOLOR="000000"><TD  COLSPAN=6><img src="/images/blackdot.gif"  WIDTH=1  HEIGHT=2  HSPACE=0 vspace=0></TD></TR></T ABLE> > <CENTER> <A HREF="/cgi-bin/koha/mainpage.pl">Home</a> || <A HREF="/cgi-bin/koha/circ/circulation.pl">Circulation</a> || <A HREF="/cgi-bin/koha/catalogu e-home.pl">Catalogue</a> || <A HREF="/cgi-bin/koha/members-home.pl">Members</a> || <A HREF="/cgi-bin/koha/loadmodules.pl?module=acquisitions">Acquisitions</a> || <A HREF="/cgi-bin/koha/reports-home.pl">Repor ts</a> || <A HREF="/cgi-bin/koha/admin-home.pl">System Parameters</a> || <A HREF="/help/">Help</a> </CENTER> </BODY> > </HTML> >   > Plz help me </div> <hr>Help STOP SPAM with <a href="http://g.msn.com/8HMTEN/2731">the new MSN 8 </a> and get 2 months FREE*</html> > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha >

1 0

Internal server error
by Mohamed Amin 17 Apr '03

17 Apr '03

1 0

Open Source or Free Software?
by Joshua Ferraro 17 Apr '03

17 Apr '03

Hi All: Koha is often referred to as an "open source" project (definition at http://www.opensource.org/osd.html. Do we also characterize it as "free software" (definition at http://www.gnu.org/philosophy/free-sw.html)? I know that in practice, nearly all software meeting one definition also meets the other, I was just wondering what everyone thinks about the distinction. To my mind, there are advantages to both terms. "Open source" is more widely known (at least around here) and expresses the "openness" of the code. "Free software" (as in free speech) comes closer to the library concept of free access to information; it also (conveniently) covers the monetary aspect of things (after all, the software is available at no cost). Joshua

6 5

V1.9.2 Windows Install Package for Koha now available
by robweir＠alum.drexel.edu 16 Apr '03

16 Apr '03

Windows install packages for Koha Stable Release V1.2.3 and Koha Test Release V1.9.2 are now available. There is a set of pages on the Koha wiki supporting installing Koha on Windows. Go to http://www.saas.nsw.edu.au/wiki/index.php?page=KohaProject and click on KohaOnWindows to find download links and other information to help you install and run Koha on a WIndows platform. Questions and suggestions regarding Koha on Windows should be directed to koha-win32(a)lists.sourceforge.net. Rob

1 0