How to change master password of Koha ?

Koha master login username and password is same as MySQL database (e.g. koha_library), where data stored.

First change the password of koha_library database.
Then put new password in /etc/koha/sites/library/koha-conf.xml

Apply following commands in Applications > Accessories > Terminal

sudo mysql -uroot -p  

[enter the MySQL Root password]

use mysql;
SET PASSWORD FOR 'koha_library'@'localhost' = PASSWORD('koha123');
flush privileges;
quit;


Need to change new password in Koha configuration file.

Open the configuration file using any text editor. Use any text editor, mousepad/leafpad. Install mousepad;

sudo apt-get install mousepad

sudo mousepad /etc/koha/sites/library/koha-conf.xml

The file will open. Scroll to bottom part of the file and find the line for password.

You can find old password. Place your new password.
Save [Ctrl+O] and close [Ctrl+x] the file. Login Koha using new password.

29 comments:

  1. it's working.. thanks dude.. :-)

    ReplyDelete
  2. sudo -u koha misc/migration_tools/rebuild_zebra.pl -z -b -a
    DBD::mysql::db selectrow_array failed: Table 'kohadb.systempreferences' doesn't exist at C4/Context.pm line 563.
    DBD::mysql::st execute failed: Table 'kohadb.marc_subfield_structure' doesn't exist at C4/Context.pm line 1016.
    DBD::mysql::st fetchrow failed: fetch() without execute() at C4/Context.pm line 1017.
    DBD::mysql::st execute failed: Table 'kohadb.marc_subfield_structure' doesn't exist at C4/Context.pm line 1016.
    DBD::mysql::st fetchrow failed: fetch() without execute() at C4/Context.pm line 1017.
    DBD::mysql::st execute failed: Table 'kohadb.zebraqueue' doesn't exist at misc/migration_tools/rebuild_zebra.pl line 402.
    Can't use an undefined value as an ARRAY reference at /usr/lib/perl5/DBI.pm line 2064.

    ReplyDelete
  3. Thank You very Much...
    From Sri Lanka.
    Cheers!!!

    ReplyDelete
  4. after install no signal it showing wt i will do

    ReplyDelete
    Replies
    1. Are you telling about installation of Koha Live DVD?

      Delete
  5. You have just DESTROYED!! my koha server. your guide does not work for me and now i am screwed. the university catalog is down!

    results at [my ip:8080]
    Software error:

    /etc/koha/sites/library/koha-conf.xml:1: parser error : Start tag expected, '<' not found
    -
    ^
    BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Output.pm line 33.
    Compilation failed in require at /usr/share/koha/intranet/cgi-bin/mainpage.pl line 24.
    BEGIN failed--compilation aborted at /usr/share/koha/intranet/cgi-bin/mainpage.pl line 24.

    For help, please send mail to the webmaster ([no address given]), giving this error message and the time and date of the error.

    koha 3.18 Live DVD installation.

    ReplyDelete
  6. Software error:

    /etc/koha/sites/library/koha-conf.xml:1: parser error : Start tag expected, '<' not found
    -
    ^
    BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Output.pm line 33.
    Compilation failed in require at /usr/share/koha/intranet/cgi-bin/mainpage.pl line 24.
    BEGIN failed--compilation aborted at /usr/share/koha/intranet/cgi-bin/mainpage.pl line 24.

    For help, please send mail to the webmaster ([no address given]), giving this error message and the time and date of the error.

    ReplyDelete
    Replies
    1. May be u had a very wron problem and u applied this method and now you be like Miau Miau, Thanks it worked for me

      Delete
  7. Can't call method "do" on unblessed reference at /usr/share/koha/lib/C4/Context.pm line 793.

    For help, please send mail to the webmaster ([no address given]), giving this error message and the time and date of the error.

    ReplyDelete
  8. I have received the following error. Please help me.
    Koha Web installer › Step 3

    The following error occurred while importing the database structure:

    Warning: Using a password on the command line interface can be insecure.

    Please contact your system administrator

    ReplyDelete
  9. Excelente! Me servio mucho. Thanks!

    ReplyDelete
  10. sir, i have install Koha Live DVD but i want know about koha files, where is store, how to find its

    ReplyDelete
    Replies
    1. Koha file located in various folders,

      /usr/share/koha
      /etc/koha

      Delete
  11. sir i have two questions how to change barcode = Accession No. and what is koha live dvd root password

    ReplyDelete
  12. Thank you so much from New Delhi. It is working. May God bless you and your family.

    ReplyDelete
  13. I am ashok I have installed successfully. But i couldn’t open my opac. Can you pease guide me? May God bless you.

    ReplyDelete
  14. Sir, how to create failover for Koha

    ReplyDelete
  15. install.pl: DBD::mysql::st execute failed: BLOB, TEXT, GEOMETRY or JSON column 'defaultvalue' can't have a default value at /usr/share/perl5/DBIx/RunSQL.pm line 273.


    dear sir please solve the above problem

    ReplyDelete
  16. how can I rectify these two error?
    Software error:
    Tag “0” is not a valid tag. at usr/share/koha/lib/C4/Biblio.pm line 2486
    and
    can’t call method “data”on an undefined value at usr/share/koha/lib/C4/Search.pm line1723.

    ReplyDelete
  17. I

    I have only one problem after following this
    when I connect usin my dns name I have the Koha maintenance page

    ReplyDelete
  18. After everything I have this error:

    System Maintenance

    The Koha online catalog is offline for system maintenance. We'll be back soon! If you have any questions, please contact the site administrator

    ReplyDelete
  19. Oh my goodness, thank you for this site/blog. You are helping me!

    ReplyDelete
  20. Dear Vimal kumar i am using koha 16.05.5 and want to change the admin passward but couldn't change .plz help.....

    ReplyDelete
  21. Thank you, Sir. But after following this tutorial, I get these error

    BIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: Access denied for user 'koha_library'@'localhost' (using password: YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1492. at /usr/share/koha/lib/Koha/Database.pm line 100
    Compilation failed in require at /usr/share/koha/intranet/cgi-bin/mainpage.pl line 31.
    BEGIN failed--compilation aborted at /usr/share/koha/intranet/cgi-bin/mainpage.pl line 31.

    How can solves these problems?

    ReplyDelete
  22. Thanks Vimal Sir, yo done wonderful job to librarians,
    i installed koha 17.05.05 successfully.
    thanks

    ReplyDelete