<p dir="ltr">Hello Andrei,<br>
I think I can answer this one. You need to create a role with the autogrant option enabled because any organisation requires the users to have at least one role. The &quot;problem&quot; is that the postgres db is not populated by defult as the h2. If I remember well there&#39;s one video explaining how to start with the roles and organisations.</p>
<p dir="ltr">Kind regards,<br>
Ruben Romero</p>
<div class="gmail_quote">On Feb 13, 2015 11:19 PM, &quot;Anton Hughes&quot; &lt;<a href="mailto:ah@magick.nu">ah@magick.nu</a>&gt; wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi<div><br></div><div>We have been testing Apiman - and are really impressed with it!</div><div><br></div><div>We are now looking to move to use postgres db.</div><div><br></div><div>We are following the documentation on <a href="http://www.apiman.io/latest/installation-guide.html#_api_manager_database" target="_blank">http://www.apiman.io/latest/installation-guide.html#_api_manager_database</a> - and it looks like database and all tables are created correctly.</div><div><br></div><div>However, when I login as admin, and try to add an organization, I get the following, below error. </div><div><br></div><div>Does anyone know the cause - and how to solve this?</div><div><br></div><div>Thanks and regards</div><div><br></div><div><div style="color:rgb(51,51,51);font-family:&#39;Open Sans&#39;,Helvetica,Arial,sans-serif;font-size:13px"><div style="min-height:1px;padding-left:20px;padding-right:20px;float:left;width:786.65625px"><div style="font-size:18px;font-weight:bold">Server Error!</div><div style="font-size:14px;color:rgb(68,68,68)">Oh boy. This one is totally on us. Something really unexpected happened on the server and caused an error. It&#39;s not you, it&#39;s me. Really. You could probably just try it again and see what happens. If it keeps on happening you may need to contact someone about it.</div></div></div><div style="color:rgb(51,51,51);font-family:&#39;Open Sans&#39;,Helvetica,Arial,sans-serif;font-size:13px"><div style="min-height:1px;padding-left:20px;padding-right:20px;float:left;width:295px"></div><div style="min-height:1px;padding-left:20px;padding-right:20px;float:left;width:786.65625px"><div style="font-size:14px;font-weight:bold;text-decoration:underline">Error Message</div><div><input type="text" readonly value="The error detail message goes here." style="color:rgb(150,150,150);font-family:inherit;font-size:13px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:1.66666667;margin-top:5px;display:block;width:746.65625px;min-height:28px;padding:2px 6px;border:1px solid rgb(212,212,212);border-radius:1px;background-image:none;background-color:rgb(248,248,248)"></div></div></div><div style="color:rgb(51,51,51);font-family:&#39;Open Sans&#39;,Helvetica,Arial,sans-serif;font-size:13px;margin-top:15px"><div style="min-height:1px;padding-left:20px;padding-right:20px;float:left;width:295px"></div><div style="min-height:1px;padding-left:20px;padding-right:20px;float:left;width:786.65625px"><div style="font-size:14px;font-weight:bold;text-decoration:underline">Error Details</div><div><pre style="overflow:auto;font-family:Menlo,Monaco,Consolas,&#39;Courier New&#39;,monospace;font-size:11px;padding:9.5px;margin-top:0px;margin-bottom:10px;line-height:1.66666667;word-break:break-all;word-wrap:break-word;border:1px solid rgb(204,204,204);border-radius:1px;background-color:rgb(245,245,245)">io.apiman.manager.api.rest.contract.exceptions.SystemErrorException: No auto-grant roles have been configured.  Please create at least one auto-grant role.
        at io.apiman.manager.api.rest.impl.OrganizationResourceImpl.create(OrganizationResourceImpl.java:180)
        at io.apiman.manager.api.rest.impl.OrganizationResourceImpl$Proxy$_$$_WeldClientProxy.create(Unknown Source)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:137)
        at org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:296)
        at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:250)
        at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:237)
        at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:356)
        at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:179)
        at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:220)
        at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)
        at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
        at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:85)
        at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:130)
        at io.apiman.manager.api.security.impl.DefaultSecurityContextFilter.doFilter(DefaultSecurityContextFilter.java:56)
        at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60)
        at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132)
        at org.overlord.commons.gwt.server.filters.SimpleCorsFilter.doFilter(SimpleCorsFilter.java:71)
        at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60)
        at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132)
        at org.overlord.commons.i18n.server.filters.LocaleFilter.doFilter(LocaleFilter.java:61)
        at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60)
        at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132)
        at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:85)
        at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:61)
        at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
        at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)
        at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
        at org.keycloak.adapters.undertow.UndertowAuthenticatedActionsHandler.handleRequest(UndertowAuthenticatedActionsHandler.java:66)
        at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131)
        at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:56)
        at io.undertow.server.handlers.DisableCacheHandler.handleRequest(DisableCacheHandler.java:33)
        at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
        at io.undertow.security.handlers.AuthenticationConstraintHandler.handleRequest(AuthenticationConstraintHandler.java:51)
        at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:45)
        at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:63)
        at io.undertow.servlet.handlers.security.ServletSecurityConstraintHandler.handleRequest(ServletSecurityConstraintHandler.java:56)
        at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:58)
        at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:70)
        at io.undertow.security.handlers.SecurityInitialHandler.handleRequest(SecurityInitialHandler.java:76)
        at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
        at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)
        at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
        at org.keycloak.adapters.undertow.ServletPreAuthActionsHandler.handleRequest(ServletPreAuthActionsHandler.java:69)
        at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
        at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:261)
        at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:247)
        at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:76)
        at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:166)
        at io.undertow.server.Connectors.executeRootHandler(Connectors.java:197)
        at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:759)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:745)</pre></div></div></div><div><br></div>-- <br><div><div dir="ltr"><div><div dir="ltr"><b><p dir="ltr" style="font-weight:normal;line-height:1.15;margin-top:0pt;margin-bottom:0pt"><b style="font-family:arial;font-size:small;line-height:normal;font-weight:normal"></b></p><p dir="ltr" style="font-weight:normal;line-height:1.15;margin-top:0pt;margin-bottom:0pt"><b style="font-weight:normal"><br><span style="font-size:11px;font-family:Arial;color:rgb(0,102,153);vertical-align:baseline;white-space:pre-wrap"></span></b></p><div dir="ltr"><table style="border:none;border-collapse:collapse"><colgroup><col width="210"><col width="303"></colgroup><tbody><tr style="height:0px"><td style="border:0px solid rgb(0,0,0);vertical-align:top;padding:7px"><span style="font-weight:normal"><font>Anton Hughes<br></font></span></td><td style="border:0px solid rgb(0,0,0);vertical-align:top;padding:7px"><br></td></tr></tbody></table></div><b style="font-weight:normal"><br><span style="font-size:11px;font-family:Arial;color:rgb(0,102,153);vertical-align:baseline;white-space:pre-wrap"></span></b><p></p><b style="font-weight:normal"><span style="font-size:11px;font-family:Arial;color:rgb(0,102,153);vertical-align:baseline;white-space:pre-wrap"></span></b><p></p></b></div></div></div></div>
</div></div>
<br>_______________________________________________<br>
Apiman-user mailing list<br>
<a href="mailto:Apiman-user@lists.jboss.org">Apiman-user@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/apiman-user" target="_blank">https://lists.jboss.org/mailman/listinfo/apiman-user</a><br>
<br></blockquote></div>