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 m...@adminkuhn.ch · W www.adminkuhn.ch
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
