[Koha] Sorry, your Google login failed

[Katrin Fischer]

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
>