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