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