- Koha - lists.katipo.co.nz

Re: [Koha] Help please
by Stephon McCray 08 Dec '05

08 Dec '05

MySQL server is running on the same machine that I'm trying to get KOHA to run on...is KOHA not going to run on MySQL 5.0? Do I need to install some other program in order for it to work? Thanks, Stephon McCray >-----Original Message----- >From: Stephen Hedges [mailto:shedges@skemotah.com] >Sent: Wednesday, November 30, 2005 01:08 PM >To: 'Stephon McCray' >Cc: 'koha' >Subject: Re: [Koha] Help please > >Here's the official word from MySQL: > >"MySQL 5.0 uses an authentication protocol based on a password hashing >algorithm that is incompatible with that used by older (pre-4.1) clients. >If you upgrade the server from 4.1, attempts to connect to it with an >older client may fail with the following message: > >shell> mysql >Client does not support authentication protocol requested >by server; consider upgrading MySQL client > >To solve this problem, you should use one of the following approaches: > > * Upgrade all client programs to use a 4.1.1 or newer client library. > * When connecting to the server with a pre-4.1 client program, use an >account that still has a pre-4.1-style password. > * Reset the password to pre-4.1 style for each user that needs to use >a pre-4.1 client program. This can be done using the SET PASSWORD >statement and the OLD_PASSWORD() function: > >mysql> SET PASSWORD FOR > -> 'some_user'@'some_host' = OLD_PASSWORD('newpwd'); > > Alternatively, use UPDATE and FLUSH PRIVILEGES: > >mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd') > -> WHERE Host = 'some_host' AND User = 'some_user'; >mysql> FLUSH PRIVILEGES; > > Substitute the password you want to use for newpwd in the >preceding examples. MySQL cannot tell you what the original password >was, so you'll need to pick a new one. > * Tell the server to use the older password hashing algorithm: > 1. Start mysqld with the --old-passwords option. > 2. Assign an old-format password to each account that has had its >password updated to the longer 4.1 format. You can identify these >accounts with the following query: > >mysql> SELECT Host, User, Password FROM mysql.user > -> WHERE LENGTH(Password) > 16; > > For each account record displayed by the query, use the Host >and User values and assign a password using the OLD_PASSWORD() >function and either SET PASSWORD or UPDATE, as described >earlier." > >HTH. > >Stephen > >Stephon McCray said: >> Could someone please help me to understand what's going on and how I can >> fix it. >> >> Running a XP professional SP2 machine with MySQL 5 and Apache 2.0.55 and >> the latest version of Active Perl. >> [Tue Nov 29 17:41:58 2005] [error] [client 127.0.0.1] Premature end of >> script headers: mainpage.pl[Tue Nov 29 17:41:58 2005] [error] [client >> 127.0.0.1] DBI connect('blank224:localhost','koha',...) failed: Client >> does not support authentication protocol requested by server; consider >> upgrading MySQL client at c:/usr/koha224/intranet/modules/C4/Context.pm >> line 411[Tue Nov 29 17:41:58 2005] [error] [client 127.0.0.1] Can't call >> method "prepare" on an undefined value at >> c:/usr/koha224/intranet/modules/C4/Koha.pm line 326.Also:[Tue Nov 29 >> 17:41:41 2005] [error] [client 127.0.0.1] Premature end of script headers: >> opac-main.pl[Tue Nov 29 17:41:41 2005] [error] [client 127.0.0.1] DBI >> connect('blank224:localhost','koha',...) failed: Client does not support >> authentication protocol requested by server; consider upgrading MySQL >> client at c:/usr/koha224/intranet/modules/C4/Context.pm line >> 411Thanks,Stephon McCrayIT DirectorWestern Academy Charter School >> _______________________________________________ > > >-- >Stephen Hedges >Skemotah Solutions, USA >www.skemotah.com -- shedges(a)skemotah.com > >

4 8

Mapping dewey an local call numbers
by klnasveschuk＠klnconsulting.net 07 Dec '05

07 Dec '05

I'm trying to migrate some marc records that have local call numbers stored under tag 50a and 50b tags. Any suggestions on what should I map these to in Koha tables and fields? Also, I've mapped 082a tags to biblioitems.dewey. Is this correct or should it be something else? Kent N

1 0

ldap config info
by mourik jan c heupink 07 Dec '05

07 Dec '05

dear koha users, We're currently evaluating koha. Looks like a GREAT product so far, but at this moment I do have one question. I know koha can interact with existing ldap servers. I have read the help page, describing koha 2.0 and koha 2.2 ldap behaviour. But I'm really unsure how to change auth-with-ldap.pl (filename from memory) Are there any working examples out there? Is there any documentation that goes a bit deeper into this issue than these few lines in the online help? (I also see "a-weak" a lot in that file, I have NO idea what exactly that is) (maybe an example cn from an example ldap server..?) Some pointers would be very much appreciated! Kind regards from Holland, Mourik Jan

1 0

MARC Tag
by Carol Ku 07 Dec '05

07 Dec '05

Let me rephrase the question: For example tag 050 Library of Congress call number, this tag is marked as repeatable, however I specified that only subfield a and b are repeatable. But when I click on the "+" button next to the tag 050, all subfields were repeated. I thought only subfield a and b should be repeated. I need to have control of what subfield to appear when I repeat a tag number, how can I do that? --------------------------------- Yahoo! Personals Single? There's someone we'd like you to meet. Lots of someones, actually. Try Yahoo! Personals

2 1

Error when using bulkmarcimport.pl
by klnasveschuk＠klnconsulting.net 06 Dec '05

06 Dec '05

Hello, I'm trying to import data into Koha v. 2.2.4 using: export PERL5LIB=/usr/local/koha/intranet/modules; /usr/local/koha/intranet/scripts/misc/bulkauthimport.pl -f /root/goodmarc I get this message when importing: XX => at /usr/local/koha/intranet/scripts/misc/bulkauthimport.pl line 112. This occurs for every entry. Lines 111 - 113 are: $authtypecode="MM" if ($authtypecode eq 'j'); # mot matière warn "XX => $authtypecode"; # now, create biblio and items with NEWnewXX call. Nothing goes into any tables. Any suggestions on where to look? Kent N

2 2

MARC subfield
by Carol Ku 06 Dec '05

06 Dec '05

Two questions regarding MARC subfied: 1) In the subfield page, there is an option to choose whether we want the field to be repeatable and mandatory, however the display of these two options appear as: (Check box square) repeatable mandatory (Check box square) Is the second check box for choosing the field to be manadatory? 2) When I check off the box for repeatable, how do I add just the subfield on the add biblio page? I only see an option to add a tag, not subfield. Thanks. Carol --------------------------------- Yahoo! Personals Let fate take it's course directly to your email. See who's waiting for you Yahoo! Personals

1 0

editing templates
by William Macfarlane 03 Dec '05

03 Dec '05

For a couple of unimportant reasons I decided that I wanted to edit the npl opac and intranet search templates to display items.itemcallnumber as the call number rather than biblioitems.classification like it does by default. I don't know anything about html templating, but I imagined that this would be a pretty simple change to make. I went into /usr/local/koha/intranet/htdocs/intranet-tmpl/npl/en/search.marc/result.tmpl and replaced every instance of "classification" with "itemcallnumber" . This results in itemcallnumber displaying in parentheses after the branch name in the location column (ie "MAIN(530.076)"), but the call number column, which used to display biblioitems.classification now displays nothing. Maybe I'm not understanding how the TMPL_VAR commands work, but it seems to me that, later in the file, where it is describing the location column that TMPL_VAR NAME="itemcallnumber" refers to my call number, but that when I try to use it earlier it is empty, or pointing to nothing, or something. On the other hand, replacing "classification" with "itemcallnumber" in /usr/local/koha/opac/htdocs/opac-tmpl/npl/en/opac-detail.tmpl works fine, and results in the opac detail page displaying my call numbers properly. Both my opac and my intranet are set to display with the NPL templates, and this works just fine in all other respects. thanks, Will

1 0

Koha vs. Mandarin M3
by Fabian Kruse 01 Dec '05

01 Dec '05

Hello again, first of all thanks a lot to all the helpful and fast replies for my past queries. It´s really great that all of you share your knowledge, helping other people out!! While still working on the Koha test installation (MySQL is harder than I thought), some people came up with the idea to install the Mandarin M3 core package, free to download at http://www.mlasolutions.com/ . Put as I see it, you have to pay for Z39.50 (right now not important for us), WebOPAC and a whole lot of other things annual fees - so here`s where the company is earning money (which we do not have, and if we had it I would prefer spending it for the donation of a new feature or bugfix in Koha...). Anyone knows a website that compares the two systems (Mandarin and Koha)? Or anyone has worked with the two of them and could tell me which he prefers or about the (dis-)advantages of both of them? Thanks a lot in advance. Cheers Fabian

1 0

Biblio default tag display
by Carol Ku 01 Dec '05

01 Dec '05

How can I change the default tags displayed at the module of adding biblio? I would like to include tag 050 Library of Congress Call Number into the add bibilo, how can I do that? --------------------------------- Yahoo! DSL Something to write home about. Just $16.99/mo. or less

4 7

Display of tag number on add biblio module
by Carol Ku 30 Nov '05

30 Nov '05

The path to the page where one would enter biblio information is: intranet/cgi-bin/koha/acqui.somple/addbibio.pl However, when I go to the file, it doesn't seem to show the information where I can add a tag number to be displayed. Which file should I go, I also tried htdocs, still to no avail. I have Koha 2.2.4 on Windows. --------------------------------- Yahoo! Music Unlimited - Access over 1 million songs. Try it free.

1 0