[Koha] Sorry, your Google login failed

[Tony Hetrick]

That's it! Thank you. The email address was only in the username field. I
see now that this is what Mark was asking. I didn't connect the *primary
email address* to a field in the user settings. Once we added the email
address to the email field, it works as expected.

-Tony

On Wed, Jul 13, 2016 at 11:26 AM, Katrin Fischer <Katrin.Fischer.83 at web.de>
wrote:

> Hi Tony,
>
> which fields in the borrower record did you use for your e-mail address?
> I am surprised that you can use it for a local login as that would
> indicate it was put either into cardnumber or username. I am not sure
> how the Google login works, but it might check the first e-mail field
> instead.
>
> Hope this helps,
>
> Katrin
>
> Am 13.07.2016 um 04:57 schrieb Tony Hetrick:
> > Hi Mark,
> >
> > Thanks for the reply.
> > *Is your Koha primary email for that local user you want to log in as
> > matching the Google email address that you are authenticating with?*
> >
> > To clarify, the local account and Google account match.
> > * Using my local account (tony.hetrick at keiin.kg), I can log in manually
> > using the password set by the Koha admin.
> > * When I try to log in by clicking the *Log in with Google* button and
> > select my Google account (tony.hetrick at keiin.kg), Koha displays the
> login
> > error message after the Google auth page authenticates the request and
> > redirects me back to Koha.
> >
> > The only error logs I was looking at are the ones defined in the Apache
> > conf file. Are there other ones?
> >
> > -Tony
> >
> > On Wed, Jul 13, 2016 at 8:41 AM, Mark Tompsett <mtompset at hotmail.com>
> wrote:
> >
> >> Greetings,
> >>
> >> You didn't state anywhere that you actually had set your primary email
> >> address to match the one that you are authenticating with Google login.
> Is
> >> your Koha primary email for that local user you want to log in as
> matching
> >> the Google email address that you are authenticating with?
> >>
> >> GPML,
> >> Mark Tompsett
> >>
> >> -----Original Message-----
> >> From: tony.h
> >> Sent: Tuesday, July 12, 2016 3:44 AM
> >> To: koha at lists.katipo.co.nz
> >> Subject: [Koha] Sorry, your Google login failed
> >>
> >> Greetings,
> >>
> >> I'm having trouble getting the Google login to work since
> >> upgrading/rebuilding Koha (we rebuilt the VPS and followed the install
> >> guide: https://wiki.koha-community.org/wiki/Debian).
> >>
> >> *The problem:*
> >> 1) I can log in through my local account, no problem.
> >> 2) I then try to login through my Google account
> >> 3) After pressing allow from the accounts.google.com site, a message is
> >> displayed: /Sorry, your Google login failed. .../ The full message is
> >> below.
> >>
> >> "Log in to your account
> >> Google login
> >> Sorry, your Google login failed. The email address you are trying to
> use is
> >> not associated with a borrower at this library.
> >> Please note that the Google login will only work if you are using the
> >> e-mail
> >> address registered with this library.
> >> If you want to, you can try to log in using a different account Log in
> with
> >> Google
> >> If you do not have a Google account, but do have a local account, you
> can
> >> still log in:"
> >>
> >> There are no errors in the Apache log files.
> >>
> >> *Configuration*
> >> Since we had troubles, I'm following the testing guide to configure the
> >> OAuth login:
> >> https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10988#c68
> >>
> >> I removed the Google OAuth entries:
> >> DELETE FROM systempreferences WHERE variable LIKE 'GoogleO%';
> >>
> >> I then ran the upgrade schema tool, as I did when I imported the db:
> >> sudo koha-upgrade-schema keiin_lib
> >>
> >> I added values back in admin panel (Home › Administration › System
> >> preferences > Google OpenID Connect
> >>
> >> I confirmed the 4 values are displayed in the MySQL DB:
> >> SELECT * FROM systempreferences WHERE variable LIKE 'GoogleO%';
> >>
> >> Any thoughts?
> >> Tony
> >>
> >>
> >>
> >>
> >> --
> >> View this message in context:
> >>
> >>
> http://koha.1045719.n5.nabble.com/Sorry-your-Google-login-failed-tp5895227.html
> >> Sent from the Koha-general mailing list archive at Nabble.com.
> >> _______________________________________________
> >> Koha mailing list  http://koha-community.org
> >> Koha at lists.katipo.co.nz
> >> https://lists.katipo.co.nz/mailman/listinfo/koha
> >>
> >>
> > _______________________________________________
> > Koha mailing list  http://koha-community.org
> > Koha at lists.katipo.co.nz
> > https://lists.katipo.co.nz/mailman/listinfo/koha
> >
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>