[Koha] Lost password

[Michael Kuhn]

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 at adminkuhn.ch · W www.adminkuhn.ch