Sir/Madam, I have upgraded to 18.05 unfortunately, to remove auto increment, I deleted borrowers and old issues. after that, I am trying to open koha with my Id and password but not accepting. In old version (17.11), It was remain stored in xml file and with user ID koha_library and password we were able to recover it. But now what to do? Kindly guide me. Rajesh Bhatt
Hi Rajesh
I have upgraded to 18.05 unfortunately, to remove auto increment, I deleted borrowers and old issues. after that, I am trying to open koha with my Id and password but not accepting. In old version (17.11), It was remain stored in xml file and with user ID koha_library and password we were able to recover it.
As you can read in the respective release notes (https://koha-community.org/koha-18-05-released/): "It is no longer possible to use the database user to login into Koha. You should first create a superlibrarian patron and use it for logging in." Of course this can cause problems if you lose, delete or forget your password.
But now what to do? Kindly guide me.
I hope you still have a backup file of your database - such backup files consist of proper SQL. For example to create a certain user the backup file will contain lines like this: INSERT INTO `borrowers` VALUES (1,'1','Morlock','Demokrit','Herr','','','',NULL,'Baslerstrasse 445','','Allschwil','','4123','Schweiz','','','','','','','',NULL,'','','','','','','','','1970-01-01','GBA','S','2016-11-30','2025-03-02',NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,'','$2a$08$dsPH1AD9y9llpQaE45sae.Wkfplp0a3P3GEllf0XKodDU3RR2Ue5e',1,'demo','','','','','','','','','','','','','',NULL,NULL,1,0,'inherit','2018-05-25 18:04:33',NULL,'default',0,NULL); You should find such a line for your own original user with superlibrarian rights. Using such a line you should be able to recreate a particular user via the SQL command line of Mysql/Mariadb. The shown hash here is as follows: $2a$08$dsPH1AD9y9llpQaE45sae.Wkfplp0a3P3GEllf0XKodDU3RR2Ue5e It will create a password "demo". Maybe this is not the full solution (depending on what tables you have actually deleted) but it may be part of it. I haven't tried it myself but I hope this is of any help to you. Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch
As stated in the release notes, it is no longer possible to log in with the DB credentials. You need to create a superlibrarian user using the create_superlibrarian.pl script like this: $ sudo koha-shell instance $ /usr/share/koha/bin/devel/create_superlibrarian.pl Regards El mié., 30 may. 2018 a las 8:14, takan bhatt (<takan.bhatt@gmail.com>) escribió:
Sir/Madam,
I have upgraded to 18.05 unfortunately, to remove auto increment, I deleted borrowers and old issues. after that, I am trying to open koha with my Id and password but not accepting. In old version (17.11), It was remain stored in xml file and with user ID koha_library and password we were able to recover it. But now what to do? Kindly guide me.
Rajesh Bhatt _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Tomás Cohen Arazi Theke Solutions (https://theke.io <http://theke.io/>) ✆ +54 9351 3513384 GPG: B2F3C15F
Thanks a lot all the experts... I will try as per directed here. It is a learning for me. Actually, I was trying to find out solution for auto increments... from a blog I deleted Issues and borrower as a borrower was showing in deleteborrower in about (in both the tables). I know ID and password. it is not case that I forgotten but it is not working... Thanks and regards Rajesh Bhatt On Wed 30 May, 2018, 6:27 PM Tomas Cohen Arazi, <tomascohen@gmail.com> wrote:
As stated in the release notes, it is no longer possible to log in with the DB credentials. You need to create a superlibrarian user using the create_superlibrarian.pl script like this:
$ sudo koha-shell instance $ /usr/share/koha/bin/devel/create_superlibrarian.pl
Regards
El mié., 30 may. 2018 a las 8:14, takan bhatt (<takan.bhatt@gmail.com>) escribió:
Sir/Madam,
I have upgraded to 18.05 unfortunately, to remove auto increment, I deleted borrowers and old issues. after that, I am trying to open koha with my Id and password but not accepting. In old version (17.11), It was remain stored in xml file and with user ID koha_library and password we were able to recover it. But now what to do? Kindly guide me.
Rajesh Bhatt _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Tomás Cohen Arazi Theke Solutions (https://theke.io <http://theke.io/>) ✆ +54 9351 3513384 GPG: B2F3C15F
Users in the deletedborrowers table were not able to login anyway. As you mentioned the user/pass on an XML file, I assume you are talking about the DB user. El mié., 30 may. 2018 a las 10:22, takan bhatt (<takan.bhatt@gmail.com>) escribió:
Thanks a lot all the experts... I will try as per directed here. It is a learning for me. Actually, I was trying to find out solution for auto increments... from a blog I deleted Issues and borrower as a borrower was showing in deleteborrower in about (in both the tables). I know ID and password. it is not case that I forgotten but it is not working...
Thanks and regards
Rajesh Bhatt
On Wed 30 May, 2018, 6:27 PM Tomas Cohen Arazi, <tomascohen@gmail.com> wrote:
As stated in the release notes, it is no longer possible to log in with the DB credentials. You need to create a superlibrarian user using the create_superlibrarian.pl script like this:
$ sudo koha-shell instance $ /usr/share/koha/bin/devel/create_superlibrarian.pl
Regards
El mié., 30 may. 2018 a las 8:14, takan bhatt (<takan.bhatt@gmail.com>) escribió:
Sir/Madam,
I have upgraded to 18.05 unfortunately, to remove auto increment, I deleted borrowers and old issues. after that, I am trying to open koha with my Id and password but not accepting. In old version (17.11), It was remain stored in xml file and with user ID koha_library and password we were able to recover it. But now what to do? Kindly guide me.
Rajesh Bhatt _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Tomás Cohen Arazi Theke Solutions (https://theke.io <http://theke.io/>) ✆ +54 9351 3513384 <+54%209%20351%20351-3384> GPG: B2F3C15F
-- Tomás Cohen Arazi Theke Solutions (https://theke.io <http://theke.io/>) ✆ +54 9351 3513384 GPG: B2F3C15F
My problem of Auto increments solved. Thanks all. Without efforts and failure no one can learn. I am keeping extra installation (clone). So I can experiment. On Wed 30 May, 2018, 6:56 PM Tomas Cohen Arazi, <tomascohen@gmail.com> wrote:
Users in the deletedborrowers table were not able to login anyway. As you mentioned the user/pass on an XML file, I assume you are talking about the DB user.
El mié., 30 may. 2018 a las 10:22, takan bhatt (<takan.bhatt@gmail.com>) escribió:
Thanks a lot all the experts... I will try as per directed here. It is a learning for me. Actually, I was trying to find out solution for auto increments... from a blog I deleted Issues and borrower as a borrower was showing in deleteborrower in about (in both the tables). I know ID and password. it is not case that I forgotten but it is not working...
Thanks and regards
Rajesh Bhatt
On Wed 30 May, 2018, 6:27 PM Tomas Cohen Arazi, <tomascohen@gmail.com> wrote:
As stated in the release notes, it is no longer possible to log in with the DB credentials. You need to create a superlibrarian user using the create_superlibrarian.pl script like this:
$ sudo koha-shell instance $ /usr/share/koha/bin/devel/create_superlibrarian.pl
Regards
El mié., 30 may. 2018 a las 8:14, takan bhatt (<takan.bhatt@gmail.com>) escribió:
Sir/Madam,
I have upgraded to 18.05 unfortunately, to remove auto increment, I deleted borrowers and old issues. after that, I am trying to open koha with my Id and password but not accepting. In old version (17.11), It was remain stored in xml file and with user ID koha_library and password we were able to recover it. But now what to do? Kindly guide me.
Rajesh Bhatt _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Tomás Cohen Arazi Theke Solutions (https://theke.io <http://theke.io/>) ✆ +54 9351 3513384 <+54%209%20351%20351-3384> GPG: B2F3C15F
-- Tomás Cohen Arazi Theke Solutions (https://theke.io <http://theke.io/>) ✆ +54 9351 3513384 GPG: B2F3C15F
participants (3)
-
Michael Kuhn -
takan bhatt -
Tomas Cohen Arazi