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

[Chris Nighswonger]

Rick,

On Thu, Dec 24, 2009 at 8:50 AM, Richard Forristall
<Richard.Forristall at goodwillaz.org> wrote:
> 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)

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 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
>