[Koha] [Koha-devel] Koha Cache -- Problem with Changing Admin Password?

[Richard Forristall]

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 at localhost: GRANT ALL PRIVILEGES ON *.* TO
'kohaadmin'@'localhost' IDENTIFIED BY PASSWORD
'*261256C2D675385D1636FA4EDA3B4FFAAFAE632D' WITH GRANT OPTION
*************************** 2. row ***************************
Grants for kohaadmin at 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 at 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 at 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 at 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 at foundations.edu]
Sent: Wed 12/23/2009 6:42 PM
To: Richard Forristall
Cc: koha-devel at lists.koha.org
Subject: Re: [Koha-devel] Koha Cache -- Problem with Changing Admin
Password?

Hi Rick,

2009/12/23 Richard Forristall <Richard.Forristall at 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