Announcement

Collapse
No announcement yet.

Problem deleting an oxuser via soap webservice

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Problem deleting an oxuser via soap webservice

    Hello,

    I'm using oxappsuite v7.10.2 on a fresh debian stretch server.
    We i want to manager users, i'm using SOAP webservices and have no problems with create user and change password services.

    The only one which raise an error is the delete user one, with the following message :

    Code:
    2019-09-25T15:05:20,804+0200 ERROR [OXWorker-0000193] com.openexchange.admin.storage.mysqlStorage.OXUserMySQLStorage.delete(OXUserMySQLStorage.java:2384)                                                                                                                         
    Storage Error                                                                                                                                                                                                                                                                     
     com.openexchange.database.schema=oxappsuite_5                                                                                                                                                                                                                                  
     com.openexchange.grizzly.method=POST                                                                                                                                                                                                                                             
     com.openexchange.grizzly.pathInfo=/OXUserService                                                                                                                                                                                                                                 
     com.openexchange.grizzly.queryString=<none>                                                                                                                                                                                                                                                                                   
     com.openexchange.grizzly.remoteAddress=ip                                                                                                                                                                                                                          
     com.openexchange.grizzly.remotePort=40518                                                                                                                                                                                                                                        
     com.openexchange.grizzly.requestURI=/webservices/OXUserService                                                                                                                                                                                                                   
     com.openexchange.grizzly.serverName=host                                                                                                                                                                                                                                                        
     com.openexchange.grizzly.servletPath=/webservices                                                                                                                                                                                                                                
     com.openexchange.grizzly.threadName=OXWorker-0000193                                                                                                                                                                                                                             
     com.openexchange.grizzly.userAgent=python-requests/2.8.1                                                                                                                                                                                                                         
     com.openexchange.localhost.ipAddress=ip                                                                                                                                                                                                                                                                          
     com.openexchange.localhost.version=7.10.2-Rev9                                                                                                                                                                                                                                                                                
     com.openexchange.request.trackingId=920137076-460070448                                                                                                                                                                                                                                                                       
    com.openexchange.admin.rmi.exceptions.StorageException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 'oxappsuite_5.ot.type' isn't in GROUP BY                                                                                                                                                                    
            at com.openexchange.admin.storage.mysqlStorage.OXUserMySQLStorage.delete(OXUserMySQLStorage.java:2318)                                                                                                                                                                                                                 
            at com.openexchange.admin.storage.mysqlStorage.OXUserMySQLStorage.delete(OXUserMySQLStorage.java:2367)                                                                                                                                                                                                                 
            at com.openexchange.admin.rmi.impl.OXUser.delete(OXUser.java:1931)                                                               
            at com.openexchange.admin.rmi.impl.OXUser.delete(OXUser.java:1784)                                                               
            at com.openexchange.admin.soap.user.soap.OXUserServicePortTypeImpl.delete(OXUserServicePortTypeImpl.java:814)                                                                                                                                                                                                          
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)                                                                   
            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)                                                                       
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)                                                               
            at java.lang.reflect.Method.invoke(Method.java:498)                                                                                                    
            at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:179)                                                          
            at org.apache.cxf.jaxws.JAXWSMethodInvoker.performInvocation(JAXWSMethodInvoker.java:66)                                                               
            at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:96)                                                                      
            at org.apache.cxf.jaxws.AbstractJAXWSMethodInvoker.invoke(AbstractJAXWSMethodInvoker.java:232)                                                         
            at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMethodInvoker.java:85)                                                                          
            at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:74)                                                                      
            at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:59)                                                       
            at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)                                                                             
            at java.util.concurrent.FutureTask.run(FutureTask.java:266)                                                                                            
            at org.apache.cxf.interceptor.ServiceInvokerInterceptor$2.run(ServiceInvokerInterceptor.java:126)                                                      
            at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)                                                                   
            at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:131)                                                                                                                                                                                                              
            at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:308)                                                              
            at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)                                                        
            at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:267)                                                      
            at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:234)                                                                                                                                                                                                                    
            at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:208)                                                               
            at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:160)                                                               
            at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:216)                                                           
            at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:301)                                                                                                                                                                                                                    
            at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:220)                                                           
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:706)                                                                                        
            at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:276)                                                          
            at org.glassfish.grizzly.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:124)                                                                    
            at fr.capc.openexchange.cas.CasAbstractTicketValidationFilter.doFilter(CasAbstractTicketValidationFilter.java:209)                                                                                                                                                                                                     
            at org.glassfish.grizzly.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:114)                                                                    
            at fr.capc.openexchange.cas.CasAbstractAuthenticationFilter.doFilter(CasAbstractAuthenticationFilter.java:160)                                                                                                                                                                                                         
            at org.glassfish.grizzly.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:114)                                                                    
            at com.openexchange.http.grizzly.servletfilter.RequestReportingFilter.doFilter(RequestReportingFilter.java:138)                                                                                                                                                                                                        
            at org.glassfish.grizzly.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:114)                                                                    
            at com.openexchange.http.grizzly.servletfilter.WrappingFilter.doFilter(WrappingFilter.java:223)                                                        
            at org.glassfish.grizzly.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:114)                                                                    
            at com.openexchange.http.grizzly.service.http.OSGiAuthFilter.doFilter(OSGiAuthFilter.java:139)                                                         
            at org.glassfish.grizzly.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:114)                                                                    
            at org.glassfish.grizzly.servlet.FilterChainImpl.invokeFilterChain(FilterChainImpl.java:83)                                                            
            at org.glassfish.grizzly.servlet.ServletHandler.doServletService(ServletHandler.java:202)                                                              
            at org.glassfish.grizzly.servlet.ServletHandler.service(ServletHandler.java:154)                                                                       
            at com.openexchange.http.grizzly.service.http.OSGiMainHandler.service(OSGiMainHandler.java:302)                                                        
            at org.glassfish.grizzly.http.server.HttpHandler$1.run(HttpHandler.java:200)                                                                           
            at com.openexchange.threadpool.internal.CustomThreadPoolExecutor$MDCProvidingRunnable.run(CustomThreadPoolExecutor.java:2615)                                                                                                                                                                                          
            at com.openexchange.threadpool.internal.CustomThreadPoolExecutor$Worker.runTask(CustomThreadPoolExecutor.java:841)                                                                                                                                                                                                     
            at com.openexchange.threadpool.internal.CustomThreadPoolExecutor$Worker.run(CustomThreadPoolExecutor.java:868)                                                                                                                                                                                                         
            at java.lang.Thread.run(Thread.java:748)
    Do you know if this is caused by a bug or by a bad configuration of our ox??

    Thanks.

    Jérôme.


  • #2
    Not really sure but what MySQL (or similar) version do you run?
    GROUP BY rings a bell for the configurations requirements we have published under https://oxpedia.org/wiki/index.php?t...QL_mode_matrix

    Comment


    • #3
      Oh, i just read again that matrix and figured out the problem : i have done my mysql configuration using the example file given but i'm using mariadb 10.1.41.
      When i changed the sql_mode option, the user delete works well.

      Thanks for your help and sorry for my missreading

      Jérôme.

      Comment

      Working...
      X