[Koha] Wiping all partial or full Koha isntallation(s) and installing stable under Mint

[Liz Rea]

Hi,

There is currently a bug in Koha where it looks like the DB password is
being rejected, but if you click "[main page]" below the login form, you
are logged in. It's worth checking that you're not coming up against
this bug.

Cheers,
Liz


On 26/07/17 13:24, Jonathan Druart wrote:
> The credentials are in the config section, close to the database entry, not
> in the serverinfo section. The username must be something like
> 'koha_library' (if you created it using koha-create).
>
> On Tue, 25 Jul 2017 at 20:42 C.J.S. Hayward <cjsh at cjshayward.com> wrote:
>
>> I think my installation is corrupt.
>>
>> (koha-password displayed a password, but it didn't work for logging in as
>> kohauser either.)
>>
>> I want to uninstall and reinstall. Any words of advice besides being
>> meticulous about the wiki instructions?
>>
>>
>> Thanks
>>
>> On Tue, Jul 25, 2017 at 6:03 PM, Jonathan Druart <
>> jonathan.druart at bugs.koha-community.org> wrote:
>>
>>> You should not modify it, you can know the password of the database user
>>> using `sudo koha-passwd kohadev`, but the command will return the same
>>> value as the xml config file.
>>> Try to connect to mysql using `mysql -u koha_library -p` and enter the
>>> password.
>>> If it is rejected, you did something wrong when you create the instance.
>>> If
>>> it is not rejected it should not be rejected from the interface either.
>>>
>>> On Tue, 25 Jul 2017 at 19:38 C.J.S. Hayward <cjsh at cjshayward.com> wrote:
>>>
>>>> My suspicion is that you already had Listen lines predefined and you
>>>> double-punched on at least one port.
>>>>
>>>> I moved all Listen lines to ports.conf, removing them from the sites,
>>> and
>>>> maintaining only one Listen line per port. The behavior is, so far as I
>>> can
>>>> tell, identical. The .../library/koha-conf.xml credentials are rejected
>>>> every single time.
>>>>
>>>> Is there a command line way (bash or mysql) to set the password for
>>>> kohauser?
>>>>
>>>>
>>>> Thanks,
>>>>
>>>> On Tue, Jul 25, 2017 at 5:18 PM, Jonathan Druart <
>>>> jonathan.druart at bugs.koha-community.org> wrote:
>>>>
>>>>> I tried to add the "Listen" lines and it breaks everything for me.
>>>>> What is the behaviour if you remove them? Do you access the staff
>>>>> interface
>>>>> (login form) or the opac interface (maintenance screen)?
>>>>>
>>>>> On Tue, 25 Jul 2017 at 18:51 C.J.S. Hayward <cjsh at cjshayward.com>
>>> wrote:
>>>>>> Ok; I can clean that up.
>>>>>>
>>>>>> But let me see if the same symptoms appear next time I work on it; my
>>>>>> expectation is that the behavior is identical (i.e. I am not able to
>>>>> log in
>>>>>> through the web interface with credentials in library/koha-conf.xml),
>>>>> even
>>>>>> if I should move the Listen lines.
>>>>>>
>>>>>>
>>>>>> Thanks,
>>>>>>
>>>>>> On Tue, Jul 25, 2017 at 4:27 PM, Jonathan Druart <
>>>>>> jonathan.druart at bugs.koha-community.org> wrote:
>>>>>>
>>>>>>> I think the 2 "Listen" lines should go to ports.conf
>>>>>>>
>>>>>>> On Tue, 25 Jul 2017 at 18:11 C.J.S. Hayward <cjsh at cjshayward.com>
>>>>> wrote:
>>>>>>>> Thank you. This server is multipurpose and has multiple webapps
>>> that
>>>>>>>> listen on 8080 by default. My library entry in
>>>>>>> /etc/apache2/sites-enables
>>>>>>>> reads, with /etc/hosts assigning "opac" and "library" to
>>> 127.0.0.1:
>>>>>>>> # Koha instance library Apache config.
>>>>>>>>
>>>>>>>> # OPAC
>>>>>>>>
>>>>>>>> Listen 7027
>>>>>>>> <VirtualHost *:7027>
>>>>>>>>   <IfVersion >= 2.4>
>>>>>>>>    Define instance "library"
>>>>>>>>   </IfVersion>
>>>>>>>>    Include /etc/koha/apache-shared.conf
>>>>>>>> #  Include /etc/koha/apache-shared-disable.conf
>>>>>>>> #  Include /etc/koha/apache-shared-opac-plack.conf
>>>>>>>>    Include /etc/koha/apache-shared-opac.conf
>>>>>>>>
>>>>>>>>    ServerName opac
>>>>>>>>    SetEnv KOHA_CONF "/etc/koha/sites/library/koha-conf.xml"
>>>>>>>>    AssignUserID library-koha library-koha
>>>>>>>>
>>>>>>>>    ErrorLog    /var/log/koha/library/opac-error.log
>>>>>>>> #  TransferLog /var/log/koha/library/opac-access.log
>>>>>>>> #  RewriteLog  /var/log/koha/library/opac-rewrite.log
>>>>>>>> </VirtualHost>
>>>>>>>>
>>>>>>>> # Intranet
>>>>>>>> Listen 7028
>>>>>>>> <VirtualHost *:7028>
>>>>>>>>   <IfVersion >= 2.4>
>>>>>>>>    Define instance "library"
>>>>>>>>   </IfVersion>
>>>>>>>>    Include /etc/koha/apache-shared.conf
>>>>>>>> #  Include /etc/koha/apache-shared-disable.conf
>>>>>>>> #  Include /etc/koha/apache-shared-intranet-plack.conf
>>>>>>>>    Include /etc/koha/apache-shared-intranet.conf
>>>>>>>>
>>>>>>>>    ServerName intranet
>>>>>>>>    SetEnv KOHA_CONF "/etc/koha/sites/library/koha-conf.xml"
>>>>>>>>    AssignUserID library-koha library-koha
>>>>>>>>
>>>>>>>>    ErrorLog    /var/log/koha/library/intranet-error.log
>>>>>>>> #  TransferLog /var/log/koha/library/intranet-access.log
>>>>>>>> #  RewriteLog  /var/log/koha/library/intranet-rewrite.log
>>>>>>>> </VirtualHost>
>>>>>>>> ~
>>>>>>>>
>>>>>>>>
>>>>>>>> I had earlier tried to access opac:7027 and got the reported
>>> error.
>>>>> Now
>>>>>>> I
>>>>>>>> am trying to access intranet:7028 and I can't tell a difference.
>>>>>>>>
>>>>>>>> Do I need to be doing more if I reassign port numbers?
>>>>>>>>
>>>>>>>>
>>>>>>>> Thanks,
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7