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.h... Sent from the Koha-general mailing list archive at Nabble.com.
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@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.h... Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
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@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@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@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@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.h... Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
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@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@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@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@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.h... Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
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@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@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@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@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@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.h...
Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Did you mean AutoEmailPrimaryAddress syspref? I'm having the same issue, but without a user already created on Koha and GoogleOpenIDConnectAutoRegister set to Allow.
participants (5)
-
Katrin Fischer -
Mark Tompsett -
Pablo Bianchi -
Tony Hetrick -
tony.h