[Koha] Sorry, your Google login failed

[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
>
>