Sorry, your Google login failed

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Sorry, your Google login failed

tony.h
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
Reply | Threaded
Open this post in threaded view
|

Re: Sorry, your Google login failed

Mark Tompsett
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: [hidden email]
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
[hidden email]
https://lists.katipo.co.nz/mailman/listinfo/koha 

_______________________________________________
Koha mailing list  http://koha-community.org
[hidden email]
https://lists.katipo.co.nz/mailman/listinfo/koha
Reply | Threaded
Open this post in threaded view
|

Re: Sorry, your Google login failed

tony.h
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 ([hidden email]), 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 ([hidden email]), 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 <[hidden email]> 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: [hidden email]
> 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
> [hidden email]
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
>
_______________________________________________
Koha mailing list  http://koha-community.org
[hidden email]
https://lists.katipo.co.nz/mailman/listinfo/koha
Reply | Threaded
Open this post in threaded view
|

Re: Sorry, your Google login failed

Katrin Fischer-2
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 ([hidden email]), 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 ([hidden email]), 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 <[hidden email]> 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: [hidden email]
>> 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
>> [hidden email]
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> [hidden email]
> https://lists.katipo.co.nz/mailman/listinfo/koha
>

_______________________________________________
Koha mailing list  http://koha-community.org
[hidden email]
https://lists.katipo.co.nz/mailman/listinfo/koha
Reply | Threaded
Open this post in threaded view
|

Re: Sorry, your Google login failed

tony.h
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 <[hidden email]>
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 ([hidden email]), 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 ([hidden email]), 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 <[hidden email]>
> 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: [hidden email]
> >> 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
> >> [hidden email]
> >> https://lists.katipo.co.nz/mailman/listinfo/koha
> >>
> >>
> > _______________________________________________
> > Koha mailing list  http://koha-community.org
> > [hidden email]
> > https://lists.katipo.co.nz/mailman/listinfo/koha
> >
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> [hidden email]
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
_______________________________________________
Koha mailing list  http://koha-community.org
[hidden email]
https://lists.katipo.co.nz/mailman/listinfo/koha