[Koha] Koha Digest, Vol 156, Issue 9

Thu Oct 11 01:01:11 NZDT 2018

Dear all,

                Greetings!I have just upgraded Koha 17.05 to 18.05.04-1. Active directory authenticationis now broken. Getting the error message below:

 LDAP search failed to return object :000004DC: LdapErr: DSID-0C0907C2, comment: In order to perform this operation asuccessful bind must be completed on the connection., data 0, v2580 at/usr/share/koha/lib/C4/Auth_with_ldap.pm line 101.

I will really appreciate your help onthis. Thank you.

Kind regards,
Mesfin
    On Wednesday, October 10, 2018, 2:01:42 AM GMT+3, <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. Regarding the error in KOHA server migration (Rejeesh K.Nair)
  2. KohaCon19 location vote results (Caroline Cyr-La-Rose)
  3. Re: CHECK IN ERROR (Jonathan Druart)

----------------------------------------------------------------------

Message: 1
Date: Tue, 9 Oct 2018 19:19:52 +0530
From: "Rejeesh K.Nair" <rejeeshknair at gmail.com>
To: koha <koha at lists.katipo.co.nz>
Subject: [Koha] Regarding the error in KOHA server migration
Message-ID:
    <CAFGLYesdvkmN84SSRrZUWRkUxWbj+q65v_4JMuTqYx0m-XRiMg at mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"

Hi All,

I am trying to migrate our KOHA version 16.05.04.000 to another server with
KOHA environment from our live server.
In order to, I have moved files into second server and create a database
and import the data.
But when load the website shows the below error.

*Software error:Access denied for user 'root'@'localhost' (using password:
YES) at /usr/share/koha/lib/C4/Context.pm line 785.BEGIN
failed--compilation aborted at /usr/share/koha/lib/C4/Auth.pm line
92.Compilation failed in require at
/usr/share/koha/opac/cgi-bin/opac/opac-main.pl <http://opac-main.pl> line
23.BEGIN failed--compilation aborted at
/usr/share/koha/opac/cgi-bin/opac/opac-main.pl <http://opac-main.pl> line
23.*

To solve this issue, I have execute the following query for getting the
privileges for database permissions

*GRANT ALL PRIVILEGES ON <db_name>.* TO <db_user>; FLUSH PRIVILEGES;* But
the same error occurred. Can someone help me to solve this?

Thanks & Regards,
Rejeesh K.Nair
Mob: +91 (0) 9495316906
Web: www.rejeeshknair.com
Facebook <https://www.facebook.com/rejeeshnairk>|LinkedIn
<http://in.linkedin.com/in/rejeeshknair>|Twitter
<http://www.twitter.com/rejeeshknair>

------------------------------

Message: 2
Date: Tue, 9 Oct 2018 10:54:26 -0400
From: Caroline Cyr-La-Rose <caroline.cyr-la-rose at inlibro.com>
To: Koha Main Mailing List <koha at lists.katipo.co.nz>
Subject: [Koha] KohaCon19 location vote results
Message-ID: <febbed11-50a3-6a05-c280-847f27f49181 at inlibro.com>
Content-Type: text/plain; charset=utf-8; format=flowed

Hello everyone!

As most of you know, Interleaf Technologies, Dublin Business School and 
PTFS-Europe won the KohaCon19 bid, which will be held in Dublin from May 
20 to May 26 2019.

During the meeting, I didn't have the exact numbers on hand. Here they 
are now. These are the results for 1st choice:

- Dublin 208 votes, 52.13%

- Stockholm 153 votes, 38.35%

- No vote* 38 votes, 9.52%

* people who registered, but didn't vote, for any number of reasons.

Caroline

-- 
Caroline Cyr La Rose, M.L.I.S.
Librarian / Head of Training and Support, inLibro

caroline.cyr-la-rose at inLibro.com <mailto:caroline.cyr-la-rose at inLibro.com>

www.inLibro.com <http://www.inLibro.com>

------------------------------

Message: 3
Date: Tue, 9 Oct 2018 11:56:06 -0300
From: Jonathan Druart <jonathan.druart at bugs.koha-community.org>
To: Igbudu Tersoo <murphyigbudu at gmail.com>
Cc: Koha at lists.katipo.co.nz
Subject: Re: [Koha] CHECK IN ERROR
Message-ID:
    <CAJzKNY4C3QDXM0tKroazGmMVz_Hw4LBisjT=XRtdHFCF_bjSYQ at mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"

Hello Igbudu,

Did you read the wiki page? Which part(s) need clarification?

Regards,
Jonathan

On Mon, 8 Oct 2018 at 09:03 Igbudu Tersoo <murphyigbudu at gmail.com> wrote:

> *Hi everyone,*
>
> *I am using koha version 17.11 with the database Mysql ver15.11
> distribution 10.0.36-MariaDB.  I want to "**check in" and the error message
> below appears, I click on about page and the second information about data
> problems comes out. Please what can I do. I have limited knowledge with
> mysql and MariaDB.*
>
> *Thanks a lot.*
>
>
> *Check in error message message*
>
> 037655: Computer Science
> <
> http://154.68.225.19:8001/cgi-bin/koha/catalogue/detail.pl?type=intra&biblionumber=136
> >
>
> *The item has not been checked in due to a configuration issue in your
> system. You must ask an administrator to take a look at the about page
> <http://154.68.225.19:8001/cgi-bin/koha/about.pl#sysinfo> and search for
> the "data problems" section*
>
> Top of Form
>
>
> About page information Data problems
>
> Some of your tables have problems with their auto_increment values which
> may lead to data loss.
>
> *You should not ignore this warning.*
>
> The problem is that InnoDB does not keep auto_increment across SQL server
> restarts (it is only set in memory). So on server startup the
> auto_increment values are set to max(table.id)+1.
>
> To know how to avoid this problem see the related wiki page: DBMS auto
> increment fix <
> https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix>
> Problems found Patrons
>
> The following ids exist in both tables *borrowers* and *deletedborrowers*:
>
> 4
> Checkouts
>
> The following ids exist in both tables *issues* and *old_issues*:
>
> 16, 17, 18
>
>
>
> Warnings regarding the system configuration
>
> *Preferences and parameters*
>
> *Warning*
>
> You are missing the <template_cache_dir> entry in your koha-conf.xml file.
> That will bring a performance boost to enable it.
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>

------------------------------

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 156, Issue 9
************************************