Would it be possible to create test MySql DB and check using it? (Or maybe Postgres to not mess with ports etc.) ?
On Mon, 30 Mar 2020 at 19:32, Maxim Solodovnik <solomax...@gmail.com> wrote: > Most probably both will work the same > The error is extremely weird > > On Mon, 30 Mar 2020 at 19:31, Ruben ALLITTEH <krallit...@outlook.fr> > wrote: > >> Ok. I will alter DB. >> Actually facebook oauth2 is working properly . >> Do you think Facebook user could be saving into DB but not Google user ? >> >> >> >> >> ------------------------------ >> *De :* Maxim Solodovnik <solomax...@gmail.com> >> *Envoyé :* lundi 30 mars 2020 11:49 >> *À :* Openmeetings user-list <user@openmeetings.apache.org> >> *Objet :* Re: google oauth2 error >> >> `COLLATE` matters when you searching/ordering >> >> I personally using MySql (NOT MariaDB due to some weird errors, maybe >> this is one of them ... ) >> >> >> On Mon, 30 Mar 2020 at 18:44, Ruben ALLITTEH <krallit...@outlook.fr> >> wrote: >> >> >> I have used " CREATE DATABASE openmeetings DEFAULT CHARACTER SET 'utf8'; >> " >> >> according to the official documentation (Installation of apache >> openmeetings 5.0.0 M2 on ubuntu 18.04 lts). Was anything wrong with it ? >> 😅 >> >> >> >> >> >> ------------------------------ >> *De :* Maxim Solodovnik <solomax...@gmail.com> >> *Envoyé :* lundi 30 mars 2020 11:32 >> *À :* Openmeetings user-list <user@openmeetings.apache.org> >> *Objet :* Re: google oauth2 error >> >> LGTM .... >> >> Maybe the way you have create DB matters >> Was it created with UTF support? >> >> (I'm using `CREATE DATABASE openmeetings DEFAULT CHARACTER SET utf8 >> COLLATE utf8_general_ci;`) >> >> On Mon, 30 Mar 2020 at 18:30, Ruben ALLITTEH <krallit...@outlook.fr> >> wrote: >> >> User mapping >> >> >> >> >> >> >> >> ------------------------------ >> *De :* Maxim Solodovnik <solomax...@gmail.com> >> *Envoyé :* lundi 30 mars 2020 11:20 >> *À :* Openmeetings user-list <user@openmeetings.apache.org> >> *Objet :* Re: google oauth2 error >> >> Can you see the attribute mapping in Admin->LDAP, are you? >> >> I would appreciate if you can test latest release or latest SNAPSHOT due >> to M2 is already too old :( >> >> On Mon, 30 Mar 2020 at 18:09, Ruben ALLITTEH <krallit...@outlook.fr> >> wrote: >> >> I am using MariaDB server. >> >> Maybe it was the same issue here : >> https://issues.apache.org/jira/browse/OPENMEETINGS-2057 >> >> I can try to install OM 5.0.0-M3 on a test server and I will check. >> >> >> >> >> >> ------------------------------ >> *De :* Maxim Solodovnik <solomax...@gmail.com> >> *Envoyé :* lundi 30 mars 2020 10:54 >> *À :* Openmeetings user-list <user@openmeetings.apache.org> >> *Objet :* Re: google oauth2 error >> >> The OAuth part was successful >> Then there was problem during saving GUser into DB >> >> What DB are you using? >> Can you check if you have this issue with 5.0.0-M3 (or upcoming >> M4-SNAPSHOT) if it will be not too complicated ... ? >> >> On Mon, 30 Mar 2020 at 17:47, Ruben ALLITTEH <krallit...@outlook.fr> >> wrote: >> >> "Internal error" >> >> >> >> DEBUG 03-30 10:31:23.769 o.a.o.w.p.a.SignInPage:174 [io-5443-exec-10] - >> redirectUrl= >> https://accounts.google.com/o/oauth2/auth?redirect_uri=https%3A%2F%2Fmedia.trstech.net%3A5443%2Fopenmeetings%2Foauth%2F2&response_type=code&client_id=ooooooooo.apps.googleusercontent.com&scope=https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fuserinfo.email+https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fuserinfo.profile >> DEBUG 03-30 10:31:25.704 o.a.o.w.p.a.SignInPage:96 [nio-5443-exec-3] - >> OAuthServer=OAuthServer [id=2, name=Google, iconUrl= >> https://www.google.com/images/google_favicon_128.png, enabled=true, >> clientId=oooooooooooo.apps.googleusercontent.com, >> clientSecret=****************, requestKeyUrl= >> https://accounts.google.com/o/oauth2/auth?redirect_uri={$redirect_uri}&response_type=code&client_id={$client_id}&scope=https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fuserinfo.email+https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fuserinfo.profile >> <https://accounts.google.com/o/oauth2/auth?redirect_uri=%7B$redirect_uri%7D&response_type=code&client_id=%7B$client_id%7D&scope=https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fuserinfo.email+https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fuserinfo.profile>, >> requestTokenUrl=https://accounts.google.com/o/oauth2/token, >> requestTokenAttributes=code={$code}&client_id={$client_id}&client_secret={$client_secret}&redirect_uri={$redirect_uri}&grant_type=authorization_code, >> requestTokenMethod=POST, requestInfoUrl= >> https://www.googleapis.com/oauth2/v1/userinfo?access_token={$access_token}, >> mapping={address.email=email, login=email, firstname=given_name, >> lastname=family_name}, isDeleted()=false] >> DEBUG 03-30 10:31:25.704 o.a.o.w.p.a.SignInPage:104 [nio-5443-exec-3] - >> OAuth response >> code=4/yAEuMyfCamKLsPOr5ybXfs5n2C-LV48Mrj-o1kvUardbYSBxC5-ZhUWYBMFPWZYC9cErTv5a0o-eVxBG-B04nv8 >> DEBUG 03-30 10:31:25.731 o.a.o.w.c.OmWebSocketPanel:63 [io-5443-exec-16] >> - Sending WebSocket PING >> DEBUG 03-30 10:31:25.837 o.a.o.w.p.a.SignInPage:315 [nio-5443-exec-3] - >> AuthInfo={ >> "access_token": >> "ya29.a0Adw1xeWPe7guL0YQNBr_Zl4IGKrwIQUwxA2SN99aHrdi7Oyb_RpjJ9J5_UpRiqmjRXVSytc4wSlUyysJ-wwdfLfdU1nMMBcTHzdy-_uP2V_ov9wrRrsHMxdXygDr5gRIlg6gthTYypNCYvAG2xdpU_QD4TBL8M", >> "expires_in": 3599, >> "scope": "openid https://www.googleapis.com/auth/userinfo.email >> https://www.googleapis.com/auth/userinfo.profile";, >> "token_type": "Bearer", >> "id_token": >> "eyJhbGciOiJSUzI1NiIsImtpZCI6IjUzYzY2YWFiNTBjZmRkOTFhMTQzNTBhNjY0ODM4MDBjODNjNjMiLCJ0eXAiOiJKV1QifQ.eyJpc3MiOiJhY2NvdW50cy5nb29nbGUuY29tIiwiYXpwIjoiNDgwMTc2NTU3NTI1LXUwczE2b3FiMGo0cm51NGt0YzJnMmQ3ZGo2NjR1ajdkLmFwcHMuZ29vZ2xldXNlcmNvbnRlbnQuY29tIiwiYXVkIjoiNDgwMTc2NTU3NTI1LXUwczE2b3FiMGo0cm51NGt0YzJnMmQ3ZGo2NjR1ajdkLmFwcHMuZ29vZ2xldXNlcmNvbnRlbnQuY29tIiwic3ViIjoiMTA0NzgwNTkwODI2NjczMzQ5MTY5IiwiZW1haWwiOiJra3Rhc3BAZ21haWwuY29tIiwiZW1haWxfdmVyaWZpZWQiOnRydWUsImF0X2hhc2giOiJ5M3Z6eEVHRkRzNU51LVJ6QndWM0VRIiwiaWF0IjoxNTg1NTY0Mjg1LCJleHAiOjE1ODU1Njc4ODV9.ca2P0TW32L22_Nkv8Ri3uXMlXKxrxuz2QSReqkBGgcpiohYzWH1ctpHZradKCoZ-9_-eoaE_q2YdCyKNoezgSoTfRBY8lJpuToDvyiTrkMbGq5H0si2fxvsehbEMxuLaqlB8xzFyLH_Wo4-vMfI81tDhClQMlq6YYt_-nnX-ohJJIS4lGqJQP2PTpwP2BqhsNBZz25uas4wgx3Hl13Veyvqf_7BnpWBKG72cx6Z1TMG1KgWOsG8P1_jW548uXaAC0C7Q6K8iR8EuN9hMpk-DwJ6zBqJgVDPcuEGQ8FYvLxJ6wCOaIY-8F24UKOTh_HT_-mGE5BNs8Ay9NAgd_syQnA" >> } >> DEBUG 03-30 10:31:25.838 o.a.o.w.p.a.SignInPage:109 [nio-5443-exec-3] - >> OAuthInfo=AuthInfo >> [accessToken=ya29.a0Adw1xeWPe7guL0YQNBr_Zl4IGKrwIQUwxA2SN99aHrdi7Oyb_RpjJ9J5_UpRiqmjRXVSytc4wSlUyysJ-wwdfLfdU1nMMBcTHzdy-_uP2V_ov9wrRrsHMxdXygDr5gRIlg6gthTYypNCYvAG2xdpU_QD4TBL8MVodlcv, >> refreshToken=, tokenType=Bearer, userId=, expiresIn=3599] >> DEBUG 03-30 10:31:25.922 o.a.o.w.p.a.SignInPage:292 [nio-5443-exec-3] - >> User info={ >> "id": "104780590826673347", >> "email": "kkt...@gmail.com", >> "verified_email": true, >> "name": "Tas Kp", >> "given_name": "Tas", >> "family_name": "Kp", >> "picture": " >> https://lh3.googleusercontent.com/a-/AOh14GiGTMYp5pcr1SPRe8Fei-bK5N7fI3m8i8ePEIJA >> ", >> "locale": "fr" >> } >> >> DEBUG 03-30 10:31:25.924 o.a.o.d.d.u.UserDao:395 [nio-5443-exec-3] - >> checkEmail: email = kkt...@gmail.com, id = null >> ERROR 03-30 10:31:25.928 o.a.w.DefaultExceptionMapper:170 >> [nio-5443-exec-3] - Unexpected error occurred >> org.apache.wicket.WicketRuntimeException: Can't instantiate page using >> constructor 'public >> org.apache.openmeetings.web.pages.auth.SignInPage(org.apache.wicket.request.mapper.parameter.PageParameters)' >> and argument >> 'code=[4/yAEuMyfCamKLsPOr5ybXfs5n2C-LV48Mrj-o1kvUardbYSBxC5-ZhUWYBMFPWZYC9cErTv5a0o-eVxBG-B04nv8], >> scope=[email profile openid >> https://www.googleapis.com/auth/userinfo.profile >> https://www.googleapis.com/auth/userinfo.email], authuser=[0], >> prompt=[none], oauthid=[2]'. An exception has been thrown during >> construction! >> at >> org.apache.wicket.session.DefaultPageFactory.newPage(DefaultPageFactory.java:194) >> at >> org.apache.wicket.session.DefaultPageFactory.newPage(DefaultPageFactory.java:99) >> at >> org.apache.wicket.DefaultMapperContext.newPageInstance(DefaultMapperContext.java:94) >> at >> org.apache.wicket.core.request.handler.PageProvider$Provision.getPage(PageProvider.java:369) >> at >> org.apache.wicket.core.request.handler.PageProvider.getPageInstance(PageProvider.java:170) >> at >> org.apache.wicket.request.handler.render.PageRenderer.getPage(PageRenderer.java:78) >> at >> org.apache.wicket.request.handler.render.WebPageRenderer.respond(WebPageRenderer.java:231) >> at >> org.apache.wicket.core.request.handler.RenderPageRequestHandler.respond(RenderPageRequestHandler.java:202) >> at >> org.apache.wicket.request.cycle.RequestCycle$HandlerExecutor.respond(RequestCycle.java:917) >> at >> org.apache.wicket.request.RequestHandlerExecutor.execute(RequestHandlerExecutor.java:63) >> at >> org.apache.wicket.request.cycle.RequestCycle.execute(RequestCycle.java:283) >> at >> org.apache.wicket.request.cycle.RequestCycle.processRequest(RequestCycle.java:254) >> at >> org.apache.wicket.request.cycle.RequestCycle.processRequestAndDetach(RequestCycle.java:222) >> at >> org.apache.wicket.protocol.ws.AbstractUpgradeFilter.processRequestCycle(AbstractUpgradeFilter.java:71) >> at >> org.apache.wicket.protocol.http.WicketFilter.processRequest(WicketFilter.java:207) >> at >> org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:300) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) >> at >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) >> at >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) >> at >> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:607) >> at >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) >> at >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) >> at >> org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678) >> at >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) >> at >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) >> at >> org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) >> at >> org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) >> at >> org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853) >> at >> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587) >> at >> org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) >> at >> java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) >> at >> java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) >> at >> org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) >> at java.base/java.lang.Thread.run(Thread.java:834) >> Caused by: java.lang.reflect.InvocationTargetException: null >> at >> jdk.internal.reflect.GeneratedConstructorAccessor632.newInstance(Unknown >> Source) >> at >> java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) >> at >> java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490) >> at >> org.apache.wicket.session.DefaultPageFactory.newPage(DefaultPageFactory.java:171) >> ... 34 common frames omitted >> Caused by: org.apache.openjpa.persistence.InvalidStateException: Detected >> reentrant flush. Make sure your flush-time instance callback methods or >> event listeners do not invoke any operations that require the in-progress >> flush to complete. >> at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2195) >> at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1962) >> at >> org.apache.openjpa.kernel.StateManagerImpl.assignObjectId(StateManagerImpl.java:618) >> at >> org.apache.openjpa.kernel.StateManagerImpl.assignField(StateManagerImpl.java:705) >> at >> org.apache.openjpa.kernel.StateManagerImpl.beforeAccessField(StateManagerImpl.java:1750) >> at >> org.apache.openjpa.kernel.StateManagerImpl.accessingField(StateManagerImpl.java:1679) >> at >> org.apache.openmeetings.db.entity.user.GroupUser.pcGetid(GroupUser.java) >> at >> org.apache.openmeetings.db.entity.user.GroupUser.toString(GroupUser.java:112) >> at java.base/java.text.MessageFormat.subformat(MessageFormat.java:1302) >> at java.base/java.text.MessageFormat.format(MessageFormat.java:885) >> at java.base/java.text.Format.format(Format.java:158) >> at java.base/java.text.MessageFormat.format(MessageFormat.java:860) >> at >> org.apache.openjpa.lib.util.Localizer$Message.getMessage(Localizer.java:281) >> at >> org.apache.openjpa.util.OpenJPAException.<init>(OpenJPAException.java:64) >> at org.apache.openjpa.util.UserException.<init>(UserException.java:49) >> at >> org.apache.openjpa.util.InvalidStateException.<init>(InvalidStateException.java:37) >> at >> org.apache.openjpa.kernel.SingleFieldManager.preFlush(SingleFieldManager.java:570) >> at >> org.apache.openjpa.kernel.SingleFieldManager.preFlush(SingleFieldManager.java:513) >> at >> org.apache.openjpa.kernel.StateManagerImpl.preFlush(StateManagerImpl.java:3189) >> at >> org.apache.openjpa.kernel.SingleFieldManager.preFlushPC(SingleFieldManager.java:811) >> at >> org.apache.openjpa.kernel.SingleFieldManager.preFlushPCs(SingleFieldManager.java:765) >> at >> org.apache.openjpa.kernel.SingleFieldManager.preFlush(SingleFieldManager.java:667) >> at >> org.apache.openjpa.kernel.SingleFieldManager.preFlush(SingleFieldManager.java:592) >> at >> org.apache.openjpa.kernel.SingleFieldManager.preFlush(SingleFieldManager.java:513) >> at >> org.apache.openjpa.kernel.StateManagerImpl.preFlush(StateManagerImpl.java:3189) >> at org.apache.openjpa.kernel.PNewState.beforeFlush(PNewState.java:44) >> at >> org.apache.openjpa.kernel.StateManagerImpl.beforeFlush(StateManagerImpl.java:1111) >> at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2239) >> at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2199) >> at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1962) >> at >> org.apache.openjpa.kernel.StateManagerImpl.assignObjectId(StateManagerImpl.java:618) >> at >> org.apache.openjpa.kernel.StateManagerImpl.assignField(StateManagerImpl.java:705) >> at >> org.apache.openjpa.kernel.StateManagerImpl.beforeAccessField(StateManagerImpl.java:1750) >> at >> org.apache.openjpa.kernel.StateManagerImpl.accessingField(StateManagerImpl.java:1679) >> at org.apache.openmeetings.db.entity.user.User.pcGetid(User.java) >> at org.apache.openmeetings.db.entity.user.User.getId(User.java:333) >> at org.apache.openmeetings.db.dao.user.UserDao.update(UserDao.java:268) >> at >> org.apache.openmeetings.db.dao.user.UserDao$$FastClassBySpringCGLIB$$1492ba5a.invoke(<generated>) >> at >> org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) >> at >> org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749) >> at >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) >> at >> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:295) >> at >> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98) >> at >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) >> at >> org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688) >> at >> org.apache.openmeetings.db.dao.user.UserDao$$EnhancerBySpringCGLIB$$ffdd416.update(<generated>) >> at >> org.apache.openmeetings.web.app.UserManager.loginOAuth(UserManager.java:260) >> at jdk.internal.reflect.GeneratedMethodAccessor3230.invoke(Unknown Source) >> at >> java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> at java.base/java.lang.reflect.Method.invoke(Method.java:566) >> at >> org.apache.wicket.proxy.LazyInitProxyFactory$JdkHandler.invoke(LazyInitProxyFactory.java:521) >> at com.sun.proxy.$Proxy135.loginOAuth(Unknown Source) >> at >> org.apache.openmeetings.web.pages.auth.SignInPage.loginViaOAuth2(SignInPage.java:298) >> at >> org.apache.openmeetings.web.pages.auth.SignInPage.<init>(SignInPage.java:111) >> >> >> >> >> >> >> >> ------------------------------ >> *De :* Maxim Solodovnik <solomax...@gmail.com> >> *Envoyé :* lundi 30 mars 2020 10:21 >> *À :* Openmeetings user-list <user@openmeetings.apache.org> >> *Objet :* Re: google oauth2 error >> >> Every "internal error" producing stacktrace on the log that could help >> Could you share it? >> >> On Mon, Mar 30, 2020, 17:17 Ruben ALLITTEH <krallit...@outlook.fr> wrote: >> >> Yes. >> When I tried with the original 'request token URL', OM redirect to an >> ''internal error page''. 🙁 >> I have take the another URL on ''google identity platform'' page. >> >> >> ------------------------------ >> *De :* Maxim Solodovnik <solomax...@gmail.com> >> *Envoyé :* lundi 30 mars 2020 09:54 >> *À :* Openmeetings user-list <user@openmeetings.apache.org> >> *Objet :* Re: google oauth2 error >> >> Well >> It seems you have changed "Request token URL" >> to inaccessible URL >> https://www.googleapis.com/oauth2/token >> originally was >> https://accounts.google.com/o/oauth2/token >> >> >> On Mon, 30 Mar 2020 at 16:41, Ruben ALLITTEH <krallit...@outlook.fr> >> wrote: >> >> catalina.out file >> >> DEBUG 03-30 08:31:53.284 o.a.o.w.c.OmWebSocketPanel:63 [io-5443-exec-16] >> - Sending WebSocket PING >> DEBUG 03-30 08:32:21.174 o.a.o.w.p.a.SignInPage:174 [io-5443-exec-14] - >> redirectUrl= >> https://accounts.google.com/o/oauth2/auth?redirect_uri=https%3A%2F%2Fmedia.trstech.net%3A5443%2Fopenmeetings%2Foauth%2F2&response_type=code&client_id=oooooooo.apps.googleusercontent.com&scope=https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fuserinfo.email+https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fuserinfo.profile >> DEBUG 03-30 08:32:21.771 o.a.o.w.p.a.SignInPage:96 [io-5443-exec-12] - >> OAuthServer=OAuthServer [id=2, name=Google, iconUrl= >> https://www.google.com/images/google_favicon_128.png, enabled=true, >> clientId=oooooooo.apps.googleusercontent.com, >> clientSecret=**************, requestKeyUrl= >> https://accounts.google.com/o/oauth2/auth?redirect_uri={$redirect_uri}&response_type=code&client_id={$client_id}&scope=https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fuserinfo.email+https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fuserinfo.profile >> <https://accounts.google.com/o/oauth2/auth?redirect_uri=%7B$redirect_uri%7D&response_type=code&client_id=%7B$client_id%7D&scope=https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fuserinfo.email+https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fuserinfo.profile>, >> requestTokenUrl=https://www.googleapis.com/oauth2/token, >> requestTokenAttributes=code={$code}&client_id={$client_id}&client_secret={$client_secret}&redirect_uri={$redirect_uri}&grant_type=authorization_code, >> requestTokenMethod=POST, requestInfoUrl= >> https://www.googleapis.com/oauth2/v1/userinfo?access_token={$access_token}, >> mapping={firstname=given_name, address.email=email, login=email, >> lastname=family_name}, isDeleted()=false] >> DEBUG 03-30 08:32:21.771 o.a.o.w.p.a.SignInPage:104 [io-5443-exec-12] - >> OAuth response >> code=4/yAHRB1V3MhQcAL-_SQNz8P84Txo7Qq8bWZit0YQbDljbqGLohW8xO_VFK9JZ8_IhuceRYy3JOqxlKKO0Kx0HEtM >> ERROR 03-30 08:32:21.835 o.a.o.w.p.a.SignInPage:116 [io-5443-exec-12] - >> OAuth2 login error >> java.io.FileNotFoundException: https://www.googleapis.com/oauth2/token >> at >> java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1915) >> at >> java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1515) >> at >> java.base/sun.net.www.protocol.https.HttpsURLConnectionImpl.getInputStream(HttpsURLConnectionImpl.java:250) >> at >> org.apache.openmeetings.web.pages.auth.SignInPage.getToken(SignInPage.java:268) >> at >> org.apache.openmeetings.web.pages.auth.SignInPage.<init>(SignInPage.java:105) >> at >> jdk.internal.reflect.GeneratedConstructorAccessor632.newInstance(Unknown >> Source) >> at >> java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) >> at >> java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490) >> at >> org.apache.wicket.session.DefaultPageFactory.newPage(DefaultPageFactory.java:171) >> at >> org.apache.wicket.session.DefaultPageFactory.newPage(DefaultPageFactory.java:99) >> at >> org.apache.wicket.DefaultMapperContext.newPageInstance(DefaultMapperContext.java:94) >> at >> org.apache.wicket.core.request.handler.PageProvider$Provision.getPage(PageProvider.java:369) >> at >> org.apache.wicket.core.request.handler.PageProvider.getPageInstance(PageProvider.java:170) >> at >> org.apache.wicket.request.handler.render.PageRenderer.getPage(PageRenderer.java:78) >> at >> org.apache.wicket.request.handler.render.WebPageRenderer.respond(WebPageRenderer.java:231) >> at >> org.apache.wicket.core.request.handler.RenderPageRequestHandler.respond(RenderPageRequestHandler.java:202) >> at >> org.apache.wicket.request.cycle.RequestCycle$HandlerExecutor.respond(RequestCycle.java:917) >> at >> org.apache.wicket.request.RequestHandlerExecutor.execute(RequestHandlerExecutor.java:63) >> at >> org.apache.wicket.request.cycle.RequestCycle.execute(RequestCycle.java:283) >> at >> org.apache.wicket.request.cycle.RequestCycle.processRequest(RequestCycle.java:254) >> at >> org.apache.wicket.request.cycle.RequestCycle.processRequestAndDetach(RequestCycle.java:222) >> at >> org.apache.wicket.protocol.ws.AbstractUpgradeFilter.processRequestCycle(AbstractUpgradeFilter.java:71) >> at >> org.apache.wicket.protocol.http.WicketFilter.processRequest(WicketFilter.java:207) >> at >> org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:300) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) >> at >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) >> at >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) >> at >> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:607) >> at >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) >> at >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) >> at >> org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678) >> at >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) >> at >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) >> at >> org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) >> at >> org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) >> at >> org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853) >> at >> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587) >> at >> org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) >> at >> java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) >> at >> java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) >> at >> org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) >> at java.base/java.lang.Thread.run(Thread.java:834) >> >> >> >> >> >> >> ------------------------------ >> *De :* Maxim Solodovnik <solomax...@gmail.com> >> *Envoyé :* lundi 30 mars 2020 09:23 >> *À :* Openmeetings user-list <user@openmeetings.apache.org> >> *Objet :* Re: google oauth2 error >> >> This usually mean there are FS permissions issue >> Please check catalina.out (if it is up-to-date) :) >> >> On Mon, 30 Mar 2020 at 16:22, Ruben ALLITTEH <krallit...@outlook.fr> >> wrote: >> >> I don't have 'openmeetings.log' on my server. I just have 'catalina.log', >> 'manager.log', 'access.log' >> ------------------------------ >> *De :* Maxim Solodovnik <solomax...@gmail.com> >> *Envoyé :* lundi 30 mars 2020 08:55 >> *À :* Openmeetings user-list <user@openmeetings.apache.org> >> *Objet :* Re: google oauth2 error >> >> I believe you need to check `openmeetings.log` instead of `access log` >> (share with care, might contain sensitive info) >> >> On Mon, 30 Mar 2020 at 15:51, Ruben ALLITTEH <krallit...@outlook.fr> >> wrote: >> >> openmeetings access log when I tried to connect with google >> >> >> >> [30/Mar/2020:08:31:53 +0000] "GET >> /openmeetings/?2-1.0-main~container-main-ws~panel&_=1585556656659 HTTP/1.1" >> 200 254 >> [30/Mar/2020:08:32:21 +0000] "POST >> /openmeetings/wicket/bookmarkable/org.apache.openmeetings.web.pages.auth.SignInPage?5-1.-signin-signin&code=4/yAHgY9d6rq0pQglpTuTnolJVRiwPL7k2WVsASikk3omcolBKbQqS4lH2U6HmRGGOsrMLs1YsBYUR1d4GakgBMXk&scope=email+profile+ >> https://www.googleapis.com/auth/userinfo.email+https://www.googleapis.com/auth/userinfo.profile+openid&authuser=0&prompt=none&oauthid=2 >> HTTP/1.1" 302 - >> [30/Mar/2020:08:32:21 +0000] "GET >> /openmeetings/oauth/2?code=4/yAHRB1V3MhQcAL-_SQNz8P84Txo7Qq8bWZit0YQbDljbqGLohW8xO_VFK9JZ8_IhuceRYy3JOqxlKKO0Kx0HEtM&scope=email+profile+ >> https://www.googleapis.com/auth/userinfo.email+https://www.googleapis.com/auth/userinfo.profile+openid&authuser=0&prompt=none >> HTTP/1.1" 200 18243 >> [30/Mar/2020:08:32:22 +0000] "GET /openmeetings/css/custom.css HTTP/1.1" >> 304 - >> [30/Mar/2020:08:32:22 +0000] "GET >> /openmeetings/css/theme_om/jquery-ui.min.css HTTP/1.1" 200 31071 >> [30/Mar/2020:08:32:22 +0000] "GET /openmeetings/css/theme.min.css >> HTTP/1.1" 200 45367 >> [30/Mar/2020:08:32:22 +0000] "GET >> /openmeetings/wicket/resource/com.googlecode.wicket.kendo.ui.resource.KendoUIJavaScriptResourceReference/kendo.ui.core.min.js.map >> HTTP/1.1" 304 - >> [30/Mar/2020:08:32:22 +0000] "GET >> /openmeetings/wicket/bookmarkable/org.apache.openmeetings.web.pages.auth.SignInPage?6--forget-form-captcha-captcha&code=4/yAHRB1V3MhQcAL-_SQNz8P84Txo7Qq8bWZit0YQbDljbqGLohW8xO_VFK9JZ8_IhuceRYy3JOqxlKKO0Kx0HEtM&scope=email+profile+ >> https://www.googleapis.com/auth/userinfo.email+https://www.googleapis.com/auth/userinfo.profile+openid&authuser=0&prompt=none&oauthid=2 >> HTTP/1.1" 200 28265 >> [30/Mar/2020:08:32:22 +0000] "GET /openmeetings/css/images/logo.png >> HTTP/1.1" 304 - >> [30/Mar/2020:08:32:22 +0000] "GET >> /openmeetings/css/theme_om/images/ui-icons_3d80b3_256x240.png HTTP/1.1" 304 >> - >> [30/Mar/2020:08:32:23 +0000] "GET >> /openmeetings/wicket/resource/com.googlecode.wicket.kendo.ui.theme.Initializer/kendo.default.mobile.min.css.map >> HTTP/1.1" 304 - >> [30/Mar/2020:08:32:23 +0000] "GET >> /openmeetings/wicket/bookmarkable/org.apache.openmeetings.web.pages.auth.SignInPage?6-1.0-&code=4/yAHRB1V3MhQcAL-_SQNz8P84Txo7Qq8bWZit0YQbDljbqGLohW8xO_VFK9JZ8_IhuceRYy3JOqxlKKO0Kx0HEtM&scope=email+profile+ >> https://www.googleapis.com/auth/userinfo.email+https://www.googleapis.com/auth/userinfo.profile+openid&authuser=0&prompt=none&oauthid=2&code%3D4=yAHRB1V3MhQcAL-_SQNz8P84Txo7Qq8bWZit0YQbDljbqGLohW8xO_VFK9JZ8_IhuceRYy3JOqxlKKO0Kx0HEtM&scope%3Demail%2Bprofile%2Bhttps%3A=%2Fwww.googleapis.com%2Fauth%2Fuserinfo.email%2Bhttps%3A%2F%2Fwww.googleapis.com%2Fauth%2Fuserinfo.profile%2Bopenid&authuser%3D0=&prompt%3Dnone=&_=1585557141478 >> HTTP/1.1" 200 80 >> [30/Mar/2020:08:32:23 +0000] "GET >> /openmeetings/wicket/bookmarkable/org.apache.openmeetings.web.pages.auth.SignInPage?6-1.0-signin&code=4/yAHRB1V3MhQcAL-_SQNz8P84Txo7Qq8bWZit0YQbDljbqGLohW8xO_VFK9JZ8_IhuceRYy3JOqxlKKO0Kx0HEtM&scope=email+profile+ >> https://www.googleapis.com/auth/userinfo.email+https://www.googleapis.com/auth/userinfo.profile+openid&authuser=0&prompt=none&oauthid=2&navigatorAppName=Netscape&navigatorAppVersion=5.0%20(Windows)&navigatorAppCodeName=Mozilla&navigatorCookieEnabled=true&navigatorJavaEnabled=false&navigatorLanguage=fr&navigatorPlatform=Win32&navigatorUserAgent=Mozilla%2F5.0%20(Windows%20NT%2010.0%3B%20Win64%3B%20x64%3B%20rv%3A74.0)%20Gecko%2F20100101%20Firefox%2F74.0&screenWidth=1536&screenHeight=864&screenColorDepth=24&utcOffset=0&utcDSTOffset=0&browserWidth=1536&browserHeight=539&hostname=media.trstech.net&codebase=https%3A%2F%2Fmedia.trstech.net%3A5443%2Fopenmeetings%2Foauth%2F2&settings=%5Bobject%20Object%5D&_=1585557141479 >> HTTP/1.1" 200 80 >> [30/Mar/2020:08:32:23 +0000] "GET >> /openmeetings/?2-1.0-main~container-main-ws~panel&_=1585556656660 HTTP/1.1" >> 200 254 >> >> >> >> >> >> >> Cordialement, >> >> Ruben ALLITTEH >> ------------------------------ >> *De :* Maxim Solodovnik <solomax...@gmail.com> >> *Envoyé :* dimanche 29 mars 2020 00:18 >> *À :* Openmeetings user-list <user@openmeetings.apache.org> >> *Objet :* Re: google oauth2 error >> >> Hello, >> >> Google OAuth works on demo https://om.alteametasoft.com:8443/next/ >> Can you check openmeetings.log? >> >> On Sat, 28 Mar 2020 at 21:57, Ruben ALLITTEH <krallit...@outlook.fr> >> wrote: >> >> >> Hello ! >> >> I’m trying to configure oauth2 google for openmeetings 5.0.0-M2 >> >> I have activated ID client oauth2 with client ID and secret. >> >> However authentication don’t working, once you are authenticated with >> google oauth2, openmeetings redirect to the sign-in page >> >> >> >> My current configuration >> >> Name : Google >> >> >> >> Client_id : ooooooooooooooooooooooooooo >> >> >> >> Client_secret : **************** >> >> >> >> Redirect_URI : https://media.trstech.net:5443/openmeetings/oauth/2 >> >> >> >> Request Key URL : >> https://accounts.google.com/o/oauth2/auth?redirect_uri={$redirect_uri}&response_type=code&client_id={$client_id}&scope=https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fuserinfo.email+https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fuserinfo.profile >> <https://accounts.google.com/o/oauth2/auth?redirect_uri=%7b$redirect_uri%7d&response_type=code&client_id=%7b$client_id%7d&scope=https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fuserinfo.email+https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fuserinfo.profile> >> >> >> >> Request token URL : >> https://oauth2.googleapis.com/tokeninfo?id_token={$code}&client_id={$client_id}&client_secret={$client_secret}&redirect_uri={$redirect_uri}&grant_type=authorization_code >> >> >> >> Request token attributes : >> code={$code}&client_id={$client_id}&client_secret={$client_secret}&redirect_uri={$redirect_uri}&grant_type=authorization_code >> >> >> >> Request info URL : >> https://www.googleapis.com/auth/userinfo?access_token={$access_token} >> >> >> >> Have anyone running google oauth2 with OM 5.0.0-M2 ? >> >> >> >> >> >> >> -- >> WBR >> Maxim aka solomax >> >> >> >> -- >> WBR >> Maxim aka solomax >> >> >> >> -- >> WBR >> Maxim aka solomax >> >> >> >> -- >> WBR >> Maxim aka solomax >> >> >> >> -- >> WBR >> Maxim aka solomax >> >> >> >> -- >> WBR >> Maxim aka solomax >> >> >> >> -- >> WBR >> Maxim aka solomax >> >> >> >> -- >> WBR >> Maxim aka solomax >> > > > -- > WBR > Maxim aka solomax > -- WBR Maxim aka solomax
