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