[Koha] Koha Digest, Vol 119, Issue 15
Esmael Wan
opensistem at yahoo.com
Fri Sep 11 02:58:15 NZST 2015
Hi Michael, thanks for the response, its fine!, actually i missed the email on 8 September
Regards
Esmael
On Thursday, September 10, 2015 4:50 PM, "koha-request at lists.katipo.co.nz" <koha-request at lists.katipo.co.nz> wrote:
Send Koha mailing list submissions to
koha at lists.katipo.co.nz
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.katipo.co.nz/mailman/listinfo/koha
or, via email, send a message with subject or body 'help' to
koha-request at lists.katipo.co.nz
You can reach the person managing the list at
koha-owner at lists.katipo.co.nz
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Koha digest..."
Today's Topics:
1. Local Cover Image (Esmael Wan)
2. Fwd: Koha 3.20.3 UTF-8 Problems (Abdulsalam Yousef)
3. Re: Koha and LDAP: Password comparison fails
(Ahmad Amanullah Khan)
4. Re: Local Cover Image (Michael Kuhn)
5. Re: Koha and LDAP: Password comparison fails (mourik jan heupink)
6. How configure OAI (Arayik Manukyan)
7. Database update Problem (Bhaskar Ghosh)
----------------------------------------------------------------------
Message: 1
Date: Thu, 10 Sep 2015 04:33:30 +0000 (UTC)
From: Esmael Wan <opensistem at yahoo.com>
To: "koha at lists.katipo.co.nz" <koha at lists.katipo.co.nz>
Subject: [Koha] Local Cover Image
Message-ID:
<473158203.233588.1441859610967.JavaMail.yahoo at mail.yahoo.com>
Content-Type: text/plain; charset=UTF-8
Hi,
I tried to load local cover image to replace 'No cover image available' in OPAC display. The new cover is display but still the empty square box is display below the new local cover image. FYI im using latest version of Koha 3.20.02, Pls help
Esmael
------------------------------
Message: 2
Date: Thu, 10 Sep 2015 08:26:43 +0300
From: Abdulsalam Yousef <ayousef at kwareict.com>
To: Koha <koha at lists.katipo.co.nz>
Subject: [Koha] Fwd: Koha 3.20.3 UTF-8 Problems
Message-ID:
<CADRHuh3Bk_=om3gHUEfT+tBrB-iU2r_CO8QJEYHKQFcp-RLMYA at mail.gmail.com>
Content-Type: text/plain; charset=UTF-8
---------- Forwarded message ----------
From: Abdulsalam Yousef <ayousef at kwareict.com>
Date: Tue, Sep 8, 2015 at 8:35 AM
Subject: Koha 3.20.3 UTF-8 Problems
To: Koha <koha at lists.katipo.co.nz>,
koha-devel-request at lists.koha-community.org
Hello All,
Koha 3.20.3 suffers from UTF-8 Problems in some pages such as, When trying
to edit help in
Arabic interface
it shows garbage like this:
٠رØباً بك٠٠ي ÙƒÙiˆÙ‡Ø§
إذا كانت هذه هي ال٠رة الأولى
الأخرى ال٠وجودة ٠ي الإدارة.
Although it shows help good in Arabic when reading help.
Also when trying to import borrowers form tools > Import patrons
Default values like (Salutation:, Surname, ...etc) looks like (تØية:)
in Arabic interface, Although it's ok in Arabic interface columns.def file,
Also the same thing when trying to build new Guided reports from Guided
reports wizard.
Thanks
------------------------------
Message: 3
Date: Thu, 10 Sep 2015 07:18:51 +0000
From: Ahmad Amanullah Khan <ahmadamanullahkhan at gmail.com>
To: uwe <singlespeedfahrer at yandex.com>, koha at lists.katipo.co.nz
Subject: Re: [Koha] Koha and LDAP: Password comparison fails
Message-ID:
<CAGo9-on+Yq6H3eQ-9SXQ8Yba1nYavqfaYuxvMt-jO2kCQT_cxA at mail.gmail.com>
Content-Type: text/plain; charset=UTF-8
Dear All
I will appreciate if you guide us how you integrated KOHA with AD. Any
guide will be highly appreciated.
Thanks
On Thu, Sep 10, 2015, 3:45 AM uwe <singlespeedfahrer at yandex.com> wrote:
> Am Freitag, den 21.08.2015, 10:36 +0200 schrieb mourik jan heupink:
> > I have no other clues, no. Must say I'm rather surprised to read that
> > auth by bind is no option for you. Are you sure? Why not
>
> It seems that I misunderstood the auth-by-bind function. Finally
> someone who has more ldap knowledge helped out to connect the ldap to
> our koha installation. Now it works with auth-by-bind as you suggested.
> Thank you very much. Your hint guided us into the right way to get it
> to work.
>
> Best wishes
> Uwe
>
> >
> >
> > On 08/20/2015 03:02 PM, uwe wrote:
> > > Hello,
> > >
> > > Am Mittwoch, den 19.08.2015, 22:24 +0200 schrieb mourik jan
> > > heupink:
> > > > I'm not sure if it will help you, but we have never had much luck
> > > >
> > > > with the password compare routine, which koha seems to like.
> > > >
> > > > I don't know any other ldap client that works like that. The
> > > > usual
> > > > way
> > > > (and this one works perfectly here, using openldap and also
> > > > samba4/AD)
> > > > is: use <auth_by_bind>1</auth_by_bind>
> > > >
> > > > Your principal_name would then be something like:
> > > >
> > > > <principal_name>dn=%s,ou=id,dc=MY_ORG,dc=org</principal_name>
> > >
> > > Thank you for your answer and hints but unfortunally auth_by_bind
> > > seems
> > > to be no option for us.
> > >
> > > Is there another way to solve the issue?
> > >
> > > Thanks in advance
> > > Uwe
> > >
> > > > Hopefully this helps you as well.
> > > >
> > > > MJ
> > > >
> > > > On 8/18/2015 14:35, uwe wrote:
> > > > > Hello,
> > > > >
> > > > > we have a Koha-Installation and would like to connect to our
> > > > > OpenLDAP
> > > > > -server, but I can't get it to work.
> > > > >
> > > > > First our Koha setup:
> > > > >
> > > > > > OS: debian wheezy
> > > > > > Koha: 3.20.02
> > > > >
> > > > > Connecting to ldap-server works fine but the password
> > > > > comparison
> > > > > fails
> > > > > with the follwing error (tested in the console but also fails
> > > > > in
> > > > > the
> > > > > web gui; also given password is correct):
> > > > >
> > > > > > root at biblio:/etc/koha/sites/MY_SITE# env
> > > > > > PERL5LIB=/usr/share/koha/lib
> > > > > KOHA_CONF=/etc/koha/sites/MY_SITE/koha-conf.xml perl
> > > > > /usr/share/koha/opac/cgi-bin/opac/opac-user.pl
> > > > > userid=MY_MAIL_NAME at MY_
> > > > > ORG.org password=MY_PASSWORD. | head -5
> > > > >
> > > > > > Got 2 ldap mapkeys ( total ): userid
> > > > > > Got 2 ldap mapkeys (populated): userid
> > > > > > Checking Auth at /usr/share/koha/lib/C4/Auth.pm line 703,
> > > > > > <DATA>
> > > > > > line
> > > > > 558.
> > > > > > kohaversion : 3.2002000
> > > > > > ## checkpw - checking LDAP
> > > > > > LDAP Auth rejected : invalid password for user
> > > > > > 'MY_MAIL_NAME at MY_O
> > > > > > RG.o
> > > > > rg'. LDAP error #5: LDAP_COMPARE_FALSE
> > > > > > # This code is returned when a compare request completes and
> > > > > > the
> > > > > attribute value given is not in the entry specified
> > > > > >
> > > > > > Login failed, resetting anonymous session... at
> > > > > /usr/share/koha/lib/C4/Auth.pm line 1107, <DATA> line 595.
> > > > >
> > > > > Configuration in koha-conf.xml, see below. Our ldap-server uses
> > > > > SSHA as
> > > > > password sheme. Could this be the problem?
> > > > >
> > > > > How can I solve it? Can't find much usefull when searching
> > > > > internet
> > > > > for
> > > > > the problem.
> > > > >
> > > > > Thanks and best wishes
> > > > > Uwe
> > > > >
> > > > > > <useldapserver>1</useldapserver> <!-- see C4::Auth_with_ldap
> > > > > > for
> > > > > extra configs you must add if you want to turn this on -->
> > > > > >
> > > > > > <!-- LDAP SERVER (optional) -->
> > > > > >
> > > > > > <ldapserver id="ldapserver" listenref="ldapserver">
> > > > > > <hostname>MY_LDAP_SERVER</hostname>
> > > > > > <base>ou=id,dc=MY_ORG,dc=org</base>
> > > > > > <user>cn=biblio,ou=daemons,dc=MY_ORG,dc=org</user>
> > > > > > <!--
> > > > > > DN,
> > > > > if not anonymous -->
> > > > > > <pass>MY_SECRET_PASSWORD</pass> <!-- password, if
> > > > > > not
> > > > > anonymous -->
> > > > > > <replicate>0</replicate> <!-- add new users from LDAP
> > > > > > to
> > > > > > Koha
> > > > > database -->
> > > > > > <update>0</update> <!-- update existing users in
> > > > > > Koha
> > > > > database -->
> > > > > > <anonymous_bind>0</anonymous_bind>
> > > > > > <auth_by_bind>0</auth_by_bind> <!-- set to 1 to
> > > > > > authenticate
> > > > > by binding instead of password comparison, e.g., to use Active
> > > > > Directory -->
> > > > > > <!--<principal_name>%s at MY_ORG.org</principal_name>-->
> > > > > > <mapping> <!-- match koha SQL field names to your
> > > > > > LDAP
> > > > > > record
> > > > > field names -->
> > > > > > <!--<firstname is="firstname"></firstname>
> > > > > > <surname is="surname"></surname>
> > > > > > <address is="postaladdress">hier</address>
> > > > > > <city is="l">Berlin</city>
> > > > > > <zipcode is="postalcode">1000</zipcode>
> > > > > > <branchcode
> > > > > > is="businesscategory"></branchcode>
> > > > > > -->
> > > > > > <userid is="uid"></userid>
> > > > > > <!--<password is="USER_PASSWORD"></password>
> > > > > > <email is="mail"></email>
> > > > > > <categorycode
> > > > > > is="employeetype">PT</categorycode>
> > > > > > <phone is="telephonenumber">11111</phone>
> > > > > > <flags is="flags">2</flags> -->
> > > > > > </mapping>
> > > > > > </ldapserver>
> > > > >
> > > > >
> > > > > (hint: some private data is anonymized with large letters)
> > > > >
> > > > _______________________________________________
> > > > Koha mailing list http://koha-community.org
> > > > Koha at lists.katipo.co.nz
> > > > https://lists.katipo.co.nz/mailman/listinfo/koha
> > _______________________________________________
> > Koha mailing list http://koha-community.org
> > Koha at lists.katipo.co.nz
> > https://lists.katipo.co.nz/mailman/listinfo/koha
> --
> Q: What is green and lives in the ocean?
> A: Moby Pickle.
>
>
> _______________________________________________
> Koha mailing list http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
------------------------------
Message: 4
Date: Thu, 10 Sep 2015 09:45:05 +0200
From: Michael Kuhn <mik at adminkuhn.ch>
To: koha at lists.katipo.co.nz
Subject: Re: [Koha] Local Cover Image
Message-ID: <55F13501.8070506 at adminkuhn.ch>
Content-Type: text/plain; charset=utf-8; format=flowed
Hi Esmael
> I tried to load local cover image to replace 'No cover image
> available' in OPAC display. The new cover is display but still the
> empty square box is display below the new local cover image. FYI im
> using latest version of Koha 3.20.02, Pls help
Did you try to add the following CSS code to Koha parameter
"OPACUserCSS" as I suggested on 8 September?
.no-image {
display: none !important;
}
Kind regards, Michael
------------------------------
Message: 5
Date: Thu, 10 Sep 2015 10:07:03 +0200
From: mourik jan heupink <heupink at merit.unu.edu>
To: koha at lists.katipo.co.nz
Subject: Re: [Koha] Koha and LDAP: Password comparison fails
Message-ID: <55F13A27.1010606 at merit.unu.edu>
Content-Type: text/plain; charset=utf-8; format=flowed
Here is the AD bit from our koha-conf.xml:
> <ldapserver id="DC">
> <hostname>samba.domain.com</hostname>
> <base>CN=Users,DC=samba,DC=domain,DC=com</base>
> <replicate>1</replicate>
> <update>1</update>
> <auth_by_bind>1</auth_by_bind>
> <principal_name>%s at samba.domain.com</principal_name>
> <mapping> <!-- match koha SQL field names to your LDAP record field names -->
> <firstname is="givenName" ></firstname>
> <surname is="sn" ></surname>
> <address is="streetAddress" ></address>
> <city is="l" ></city>
> <zipcode is="postalCode" ></zipcode>
> <branchcode is="branch" >our_branch</branchcode>
> <userid is="uid" ></userid>
> <password is="userPassword" ></password>
> <email is="mail" ></email>
> <categorycode is="employeeType" >A</categorycode>
> <phone is="telephoneNumber"></phone>
> </mapping>
> </ldapserver>
Explained:
samba.domain.com is the name of our active directory, if you specify
that as hostname to bind to, koha will use (round robin) dns to connect
to all DC's. Gives you a nice load spread, plus if one DC happens to be
down, only some logons will fail.
(verify with "host samba.domain.com" reveral times in a row, it should
normally return different ip's, dependin on your number of dc's)
Base should be your users container.
Principal took me some time to understand:
<principal_name>%s at samba.domain.com</principal_name>
%s is replaced with a username, so in my example koha tries to bind as
username at samba.domain.com
I think the above explains it all?
MJ
On 09/10/2015 09:18 AM, Ahmad Amanullah Khan wrote:
> Dear All
>
> I will appreciate if you guide us how you integrated KOHA with AD. Any
> guide will be highly appreciated.
>
> Thanks
>
> On Thu, Sep 10, 2015, 3:45 AM uwe <singlespeedfahrer at yandex.com> wrote:
>
>> Am Freitag, den 21.08.2015, 10:36 +0200 schrieb mourik jan heupink:
>>> I have no other clues, no. Must say I'm rather surprised to read that
>>> auth by bind is no option for you. Are you sure? Why not
>>
>> It seems that I misunderstood the auth-by-bind function. Finally
>> someone who has more ldap knowledge helped out to connect the ldap to
>> our koha installation. Now it works with auth-by-bind as you suggested.
>> Thank you very much. Your hint guided us into the right way to get it
>> to work.
>>
>> Best wishes
>> Uwe
>>
>>>
>>>
>>> On 08/20/2015 03:02 PM, uwe wrote:
>>>> Hello,
>>>>
>>>> Am Mittwoch, den 19.08.2015, 22:24 +0200 schrieb mourik jan
>>>> heupink:
>>>>> I'm not sure if it will help you, but we have never had much luck
>>>>>
>>>>> with the password compare routine, which koha seems to like.
>>>>>
>>>>> I don't know any other ldap client that works like that. The
>>>>> usual
>>>>> way
>>>>> (and this one works perfectly here, using openldap and also
>>>>> samba4/AD)
>>>>> is: use <auth_by_bind>1</auth_by_bind>
>>>>>
>>>>> Your principal_name would then be something like:
>>>>>
>>>>> <principal_name>dn=%s,ou=id,dc=MY_ORG,dc=org</principal_name>
>>>>
>>>> Thank you for your answer and hints but unfortunally auth_by_bind
>>>> seems
>>>> to be no option for us.
>>>>
>>>> Is there another way to solve the issue?
>>>>
>>>> Thanks in advance
>>>> Uwe
>>>>
>>>>> Hopefully this helps you as well.
>>>>>
>>>>> MJ
>>>>>
>>>>> On 8/18/2015 14:35, uwe wrote:
>>>>>> Hello,
>>>>>>
>>>>>> we have a Koha-Installation and would like to connect to our
>>>>>> OpenLDAP
>>>>>> -server, but I can't get it to work.
>>>>>>
>>>>>> First our Koha setup:
>>>>>>
>>>>>>> OS: debian wheezy
>>>>>>> Koha: 3.20.02
>>>>>>
>>>>>> Connecting to ldap-server works fine but the password
>>>>>> comparison
>>>>>> fails
>>>>>> with the follwing error (tested in the console but also fails
>>>>>> in
>>>>>> the
>>>>>> web gui; also given password is correct):
>>>>>>
>>>>>>> root at biblio:/etc/koha/sites/MY_SITE# env
>>>>>>> PERL5LIB=/usr/share/koha/lib
>>>>>> KOHA_CONF=/etc/koha/sites/MY_SITE/koha-conf.xml perl
>>>>>> /usr/share/koha/opac/cgi-bin/opac/opac-user.pl
>>>>>> userid=MY_MAIL_NAME at MY_
>>>>>> ORG.org password=MY_PASSWORD. | head -5
>>>>>>
>>>>>>> Got 2 ldap mapkeys ( total ): userid
>>>>>>> Got 2 ldap mapkeys (populated): userid
>>>>>>> Checking Auth at /usr/share/koha/lib/C4/Auth.pm line 703,
>>>>>>> <DATA>
>>>>>>> line
>>>>>> 558.
>>>>>>> kohaversion : 3.2002000
>>>>>>> ## checkpw - checking LDAP
>>>>>>> LDAP Auth rejected : invalid password for user
>>>>>>> 'MY_MAIL_NAME at MY_O
>>>>>>> RG.o
>>>>>> rg'. LDAP error #5: LDAP_COMPARE_FALSE
>>>>>>> # This code is returned when a compare request completes and
>>>>>>> the
>>>>>> attribute value given is not in the entry specified
>>>>>>>
>>>>>>> Login failed, resetting anonymous session... at
>>>>>> /usr/share/koha/lib/C4/Auth.pm line 1107, <DATA> line 595.
>>>>>>
>>>>>> Configuration in koha-conf.xml, see below. Our ldap-server uses
>>>>>> SSHA as
>>>>>> password sheme. Could this be the problem?
>>>>>>
>>>>>> How can I solve it? Can't find much usefull when searching
>>>>>> internet
>>>>>> for
>>>>>> the problem.
>>>>>>
>>>>>> Thanks and best wishes
>>>>>> Uwe
>>>>>>
>>>>>>> <useldapserver>1</useldapserver> <!-- see C4::Auth_with_ldap
>>>>>>> for
>>>>>> extra configs you must add if you want to turn this on -->
>>>>>>>
>>>>>>> <!-- LDAP SERVER (optional) -->
>>>>>>>
>>>>>>> <ldapserver id="ldapserver" listenref="ldapserver">
>>>>>>> <hostname>MY_LDAP_SERVER</hostname>
>>>>>>> <base>ou=id,dc=MY_ORG,dc=org</base>
>>>>>>> <user>cn=biblio,ou=daemons,dc=MY_ORG,dc=org</user>
>>>>>>> <!--
>>>>>>> DN,
>>>>>> if not anonymous -->
>>>>>>> <pass>MY_SECRET_PASSWORD</pass> <!-- password, if
>>>>>>> not
>>>>>> anonymous -->
>>>>>>> <replicate>0</replicate> <!-- add new users from LDAP
>>>>>>> to
>>>>>>> Koha
>>>>>> database -->
>>>>>>> <update>0</update> <!-- update existing users in
>>>>>>> Koha
>>>>>> database -->
>>>>>>> <anonymous_bind>0</anonymous_bind>
>>>>>>> <auth_by_bind>0</auth_by_bind> <!-- set to 1 to
>>>>>>> authenticate
>>>>>> by binding instead of password comparison, e.g., to use Active
>>>>>> Directory -->
>>>>>>> <!--<principal_name>%s at MY_ORG.org</principal_name>-->
>>>>>>> <mapping> <!-- match koha SQL field names to your
>>>>>>> LDAP
>>>>>>> record
>>>>>> field names -->
>>>>>>> <!--<firstname is="firstname"></firstname>
>>>>>>> <surname is="surname"></surname>
>>>>>>> <address is="postaladdress">hier</address>
>>>>>>> <city is="l">Berlin</city>
>>>>>>> <zipcode is="postalcode">1000</zipcode>
>>>>>>> <branchcode
>>>>>>> is="businesscategory"></branchcode>
>>>>>>> -->
>>>>>>> <userid is="uid"></userid>
>>>>>>> <!--<password is="USER_PASSWORD"></password>
>>>>>>> <email is="mail"></email>
>>>>>>> <categorycode
>>>>>>> is="employeetype">PT</categorycode>
>>>>>>> <phone is="telephonenumber">11111</phone>
>>>>>>> <flags is="flags">2</flags> -->
>>>>>>> </mapping>
>>>>>>> </ldapserver>
>>>>>>
>>>>>>
>>>>>> (hint: some private data is anonymized with large letters)
>>>>>>
>>>>> _______________________________________________
>>>>> Koha mailing list http://koha-community.org
>>>>> Koha at lists.katipo.co.nz
>>>>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>> _______________________________________________
>>> Koha mailing list http://koha-community.org
>>> Koha at lists.katipo.co.nz
>>> https://lists.katipo.co.nz/mailman/listinfo/koha
>> --
>> Q: What is green and lives in the ocean?
>> A: Moby Pickle.
>>
>>
>> _______________________________________________
>> Koha mailing list http://koha-community.org
>> Koha at lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
> _______________________________________________
> Koha mailing list http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
------------------------------
Message: 6
Date: Thu, 10 Sep 2015 12:24:07 +0400
From: Arayik Manukyan <araik at flib.sci.am>
To: Koha <koha at lists.katipo.co.nz>
Subject: [Koha] How configure OAI
Message-ID: <55F13E27.8020503 at flib.sci.am>
Content-Type: text/plain; charset=utf-8; format=flowed
Dear community,
We are using Koha tarball 3.18.05 on Ubuntu 12.04.5.
Resently we enabled in system preferences OAI-PHM ,
but we couldn't harvest record from Koha using MarcEdit.
Is it nessesary to install SOPAC2 and how can we install it in our Koha
version .
Please, help with instructions.
Thenks, Araik.
------------------------------
Message: 7
Date: Thu, 10 Sep 2015 14:16:32 +0530
From: Bhaskar Ghosh <bggunp at gmail.com>
To: koha <koha at lists.katipo.co.nz>
Subject: [Koha] Database update Problem
Message-ID:
<CAES+QbF5ZfZvMtroc0qgP1=4yXry5uGr_gPBkWEKEuYOaALbQA at mail.gmail.com>
Content-Type: text/plain; charset=UTF-8
All,
When i trying to restore the database of Koha 3.18.03 to 3.20.03, give the error
“ERROR 2013 (HY000) at line 285: Lost connection to MySQL server during query
”
how to solve it?
Thanks
------------------------------
Subject: Digest Footer
_______________________________________________
Koha mailing list
Koha at lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------
End of Koha Digest, Vol 119, Issue 15
*************************************
More information about the Koha
mailing list