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@lists.katipo.co.nz> wrote: Send Koha mailing list submissions to koha@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@lists.katipo.co.nz You can reach the person managing the list at koha-owner@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@gmail.com> To: koha <koha@lists.katipo.co.nz> Subject: [Koha] Regarding the error in KOHA server migration Message-ID: <CAFGLYesdvkmN84SSRrZUWRkUxWbj+q65v_4JMuTqYx0m-XRiMg@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@inlibro.com> To: Koha Main Mailing List <koha@lists.katipo.co.nz> Subject: [Koha] KohaCon19 location vote results Message-ID: <febbed11-50a3-6a05-c280-847f27f49181@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@inLibro.com <mailto:caroline.cyr-la-rose@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@bugs.koha-community.org> To: Igbudu Tersoo <murphyigbudu@gmail.com> Cc: Koha@lists.katipo.co.nz Subject: Re: [Koha] CHECK IN ERROR Message-ID: <CAJzKNY4C3QDXM0tKroazGmMVz_Hw4LBisjT=XRtdHFCF_bjSYQ@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@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@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------ Subject: Digest Footer _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha ------------------------------ End of Koha Digest, Vol 156, Issue 9 ************************************