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 su

[enter the Linux Root password]

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, gedit/leafpad. Leafpad is not available, install;

apt-get install leafpad

sudo leafpad /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. 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
  2. Thank You very Much...
    From Sri Lanka.
    Cheers!!!

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

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

      Delete
  4. 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
  5. 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
  6. 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
  7. 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
  8. Excelente! Me servio mucho. Thanks!

    ReplyDelete
  9. 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
  10. sir i have two questions how to change barcode = Accession No. and what is koha live dvd root password

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

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

    ReplyDelete
  13. Sir, how to create failover for Koha

    ReplyDelete
  14. 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
  15. 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
  16. I

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

    ReplyDelete
  17. 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
  18. Oh my goodness, thank you for this site/blog. You are helping me!

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

    ReplyDelete