Fwd: [Koha-devel] Koha Cache -- Problem with Changing Admin Password?
Hi Rick, Please post the output from this SQL executed at a mysql prompt: SHOW GRANTS FOR 'kohaadmin'@'localhost'\G Also, please cc the list as there may be others who can help or be helped by this thread. Kind Regards and Merry Christmas, Chris ---------- Forwarded message ---------- From: Richard Forristall <Richard.Forristall@goodwillaz.org> Date: Thu, Dec 24, 2009 at 12:50 AM Subject: RE: [Koha-devel] Koha Cache -- Problem with Changing Admin Password? To: Chris Nighswonger <cnighswonger@foundations.edu> Hi Chris, Yes, from the command line I get access to mysql with the password I put into koha-conf.xml and I already restarted apache2. Thanks, Rick -----Original Message----- From: Chris Nighswonger [mailto:cnighswonger@foundations.edu] Sent: Wed 12/23/2009 6:42 PM To: Richard Forristall Cc: koha-devel@lists.koha.org Subject: Re: [Koha-devel] Koha Cache -- Problem with Changing Admin Password? Hi Rick, 2009/12/23 Richard Forristall <Richard.Forristall@goodwillaz.org>:
Does Koha use a cache to remember config settings in OPAC and Intranet?
Not these.
I updated koha_conf.xml to change the password and now in the librarian view and OPAC view I get this error:
Access denied for user 'kohaadmin'@'localhost' (using password: YES) at /home/koha/kohaclone/C4/Context.pm line 667. Compilation failed in require at /home/koha/kohaclone/C4/Circulation.pm line 25.
This line indicates that somehow the password in koha-conf.xml does not match the one in mysql. Can you access the db via 'mysql -ukohaadmin -p' with the same password presently in koha-conf.xml? Kind Regards, Chris
Hi Chris and thanks for the heads up on CCing the list. I logged into mysql using the password I have set in koha-conf.xml - here's the output of your requested SQL: mysql> SHOW GRANTS FOR 'kohaadmin'@'localhost'\G *************************** 1. row *************************** Grants for kohaadmin@localhost: GRANT ALL PRIVILEGES ON *.* TO 'kohaadmin'@'localhost' IDENTIFIED BY PASSWORD '*261256C2D675385D1636FA4EDA3B4FFAAFAE632D' WITH GRANT OPTION *************************** 2. row *************************** Grants for kohaadmin@localhost: GRANT ALL PRIVILEGES ON `koha`.* TO 'kohaadmin'@'localhost' 2 rows in set (0.05 sec) Merry Christmas to you too :--) Thanks, Rick ------------------------------------------- Rick Forristall Programmer Analyst Goodwill of Central AZ 602.535.4078 ------------------------------------------- -----Original Message----- From: Chris Nighswonger [mailto:cnighswonger@foundations.edu] Sent: Thursday, December 24, 2009 6:39 AM To: Richard Forristall Cc: Koha User's List Subject: Fwd: [Koha-devel] Koha Cache -- Problem with Changing Admin Password? Hi Rick, Please post the output from this SQL executed at a mysql prompt: SHOW GRANTS FOR 'kohaadmin'@'localhost'\G Also, please cc the list as there may be others who can help or be helped by this thread. Kind Regards and Merry Christmas, Chris ---------- Forwarded message ---------- From: Richard Forristall <Richard.Forristall@goodwillaz.org> Date: Thu, Dec 24, 2009 at 12:50 AM Subject: RE: [Koha-devel] Koha Cache -- Problem with Changing Admin Password? To: Chris Nighswonger <cnighswonger@foundations.edu> Hi Chris, Yes, from the command line I get access to mysql with the password I put into koha-conf.xml and I already restarted apache2. Thanks, Rick -----Original Message----- From: Chris Nighswonger [mailto:cnighswonger@foundations.edu] Sent: Wed 12/23/2009 6:42 PM To: Richard Forristall Cc: koha-devel@lists.koha.org Subject: Re: [Koha-devel] Koha Cache -- Problem with Changing Admin Password? Hi Rick, 2009/12/23 Richard Forristall <Richard.Forristall@goodwillaz.org>:
Does Koha use a cache to remember config settings in OPAC and Intranet?
Not these.
I updated koha_conf.xml to change the password and now in the librarian view and OPAC view I get this error:
Access denied for user 'kohaadmin'@'localhost' (using password: YES) at /home/koha/kohaclone/C4/Context.pm line 667. Compilation failed in require at /home/koha/kohaclone/C4/Circulation.pm line 25.
This line indicates that somehow the password in koha-conf.xml does not match the one in mysql. Can you access the db via 'mysql -ukohaadmin -p' with the same password presently in koha-conf.xml? Kind Regards, Chris
Rick, On Thu, Dec 24, 2009 at 8:50 AM, Richard Forristall <Richard.Forristall@goodwillaz.org> wrote:
mysql> SHOW GRANTS FOR 'kohaadmin'@'localhost'\G *************************** 1. row *************************** Grants for kohaadmin@localhost: GRANT ALL PRIVILEGES ON *.* TO 'kohaadmin'@'localhost' IDENTIFIED BY PASSWORD '*261256C2D675385D1636FA4EDA3B4FFAAFAE632D' WITH GRANT OPTION *************************** 2. row *************************** Grants for kohaadmin@localhost: GRANT ALL PRIVILEGES ON `koha`.* TO 'kohaadmin'@'localhost' 2 rows in set (0.05 sec)
This looks fine. So I'm a bit stumped. Maybe someone else has a thought... Kind Regards, Chris
-----Original Message----- From: Chris Nighswonger [mailto:cnighswonger@foundations.edu] Sent: Thursday, December 24, 2009 6:39 AM To: Richard Forristall Cc: Koha User's List Subject: Fwd: [Koha-devel] Koha Cache -- Problem with Changing Admin Password?
Hi Rick,
Please post the output from this SQL executed at a mysql prompt:
SHOW GRANTS FOR 'kohaadmin'@'localhost'\G
Also, please cc the list as there may be others who can help or be helped by this thread.
Kind Regards and Merry Christmas,
Chris
---------- Forwarded message ---------- From: Richard Forristall <Richard.Forristall@goodwillaz.org> Date: Thu, Dec 24, 2009 at 12:50 AM Subject: RE: [Koha-devel] Koha Cache -- Problem with Changing Admin Password? To: Chris Nighswonger <cnighswonger@foundations.edu>
Hi Chris,
Yes, from the command line I get access to mysql with the password I put into koha-conf.xml and I already restarted apache2.
Thanks,
Rick
-----Original Message----- From: Chris Nighswonger [mailto:cnighswonger@foundations.edu] Sent: Wed 12/23/2009 6:42 PM To: Richard Forristall Cc: koha-devel@lists.koha.org Subject: Re: [Koha-devel] Koha Cache -- Problem with Changing Admin Password?
Hi Rick,
2009/12/23 Richard Forristall <Richard.Forristall@goodwillaz.org>:
Does Koha use a cache to remember config settings in OPAC and Intranet?
Not these.
I updated koha_conf.xml to change the password and now in the librarian view and OPAC view I get this error:
Access denied for user 'kohaadmin'@'localhost' (using password: YES) at /home/koha/kohaclone/C4/Context.pm line 667. Compilation failed in require at /home/koha/kohaclone/C4/Circulation.pm line 25.
This line indicates that somehow the password in koha-conf.xml does not match the one in mysql.
Can you access the db via 'mysql -ukohaadmin -p' with the same password presently in koha-conf.xml?
Kind Regards, Chris
participants (2)
-
Chris Nighswonger -
Richard Forristall