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 <c...@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.dru...@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 <c...@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.dru...@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 <c...@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.dru...@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 <c...@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@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 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha