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