[Koha] reset admin password [resolved]

[Eric Lease Morgan]

On Jan 12, 2026, at 2:34 PM, Eric Lease Morgan <eric_morgan at infomotions.com> wrote:

>>> How do I reset Koha's admin password so I can log into the Web-based administrative interface?
>> 
>> You can use this script:
>> 
>> - misc/devel/create_superlibrarian.pl --help
>> 
>> I think the options would be something like create_superlibrarian.pl --userid <your_username> --password <your_new_password> --branchcode <your_library_code> --categorycode <your_patron_category>
>> 
>> We should really add this to our documentation!
>> 
>> --
>> David Nind
>> New Zealand
> 
> 
> Thank you for the prompt reply, but alas, the create_superlibrarian.pl seems to require all of options:... And I do not know of any values for --categorycode nor --cardnumber. 'Got any suggestions?
> 
> --
> Eric Morgan


Yes, the create_superlibrarian.pl script does the trick, but one needs known values for --branchcode and --categorycode. To get these values I needed to query the underlying database, something like this:

  $ sudo mysql -u koha_catalog -p
  > use koha_catalog;
  > select * from branches;
  > select * from categories;

From the results I learned by branch code was ININI and my category code was PATRON. I then ran the following command:

  ./create_superlibrarian.pl --userid ericleasemorgan \
  --password "foobarbaz" --branchcode ININI           \
  --categorycode PATRON --cardnumber 12912

I ignored the following errors the script returned:

Use of uninitialized value $email in string ne at /usr/share/koha/lib/Koha/Patron.pm line 1445.
Use of uninitialized value $email in string ne at /usr/share/koha/lib/Koha/Patron.pm line 1445.
Use of uninitialized value $email in string ne at /usr/share/koha/lib/Koha/Patron.pm line 1445.

Finally, I was able to open my Web browser to the port 8080 backend and log in with the new credentials. Whew!

Now I will try writing a MOTD sort of thing for the public front-end.

koha++

--
Eric Morgan