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

[Chris Nighswonger]

Hey Rick,

Glad to hear you figured it out!

Kind Regards,
Chris

On Thu, Dec 24, 2009 at 1:10 PM, Richard Forristall
<Richard.Forristall at goodwillaz.org> wrote:
> OK, well I found the issue - but some background info is required so
> anyone reading this can understand and apply to their situation.
>
> We installed the Koha unconfigured virtual appliance (VMDK) from here:
> http://kylehall.info/index.php/projects/koha/koha-virtual-appliance/
>
>
> Normally one expects the admin password to reside in something like:
> /koha/etc/koha-conf.xml
>
> A search of this file found a location here:
> /home/koha/koha-dev/etc/koha-conf.xml which had the default password
> value like this
>  <db_scheme>mysql</db_scheme>
>  <database>koha</database>
>  <hostname>localhost</hostname>
>  <port>3306</port>
>  <user>kohaadmin</user>
>  <pass>defaultpasswordwashere</pass>
>
> A copy of this file is also in here:
> /home/koha/kohaclone/blib/KOHA_CONF_DIR/koha-conf.xml
>
> I was originally changing the password in the second location, and not
> the first - - once I found and changed it in the first file, all seemed
> to work (this was after I changed the kohaadmin at localhost user's
> password in mysql and restarted apache2)
>
> I believe if you look in the Koha file in folder C4/Context.pm for these
> lines you see that the program looks for the first available readable
> file for a koha-conf.xml and uses it -
> # Koha's main configuration file koha-conf.xml
> # is searched for according to this priority list:
> #
> # 1. Path supplied via use C4::Context '/path/to/koha-conf.xml'
> # 2. Path supplied in KOHA_CONF environment variable.
> # 3. Path supplied in INSTALLED_CONFIG_FNAME, as long
> #    as value has changed from its default of
> #    '__KOHA_CONF_DIR__/koha-conf.xml', as happens
> #    when Koha is installed in 'standard' or 'single'
> #    mode.
> # 4. Path supplied in CONFIG_FNAME.
> #
> # The first entry that refers to a readable file is used.
>
> use constant CONFIG_FNAME => "/etc/koha/koha-conf.xml";
>                # Default config file, if none is specified
>
> my $INSTALLED_CONFIG_FNAME = '__KOHA_CONF_DIR__/koha-conf.xml';
>                # path to config file set by installer
>                # __KOHA_CONF_DIR__ is set by rewrite-confg.PL
>                # when Koha is installed in 'standard' or 'single'
>                # mode.  If Koha was installed in 'dev' mode,
>                # __KOHA_CONF_DIR__ is *not* rewritten; instead
>                # developers should set the KOHA_CONF environment
> variable
>
> $context = undef;        # Initially, no context is set
> @context_stack = ();        # Initially, no saved contexts
>
>
> =================================================================
> So, lesson learned?
>
> 1. look for all locations of "koha-conf.xml" and change the password in
> all locations.
>
> 2. restart apache2 (/etc/init.d/apache2 restart
>
> 3. change kohaadmin at localhost user's password in mysql
>
> ****************************************************************
> =========== { SPECIAL THANKS }===================================
> Chris Nighswonger from Foundations Bible College -- Thanks Chris for
> trying to figure this out with me!
> ===========/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/=============
>
> Everyone have a great Christmas!
>
>
>
> Thanks,
>
> Rick
> -------------------------------------------
> Rick Forristall
> Programmer Analyst
> Goodwill of Central AZ
> 602.535.4078
> -------------------------------------------
>
> -----Original Message-----
> From: Chris Nighswonger [mailto:cnighswonger at foundations.edu]
> Sent: Wednesday, December 23, 2009 6:43 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
>