<p dir="ltr">Thank you guys , I'm gonna give it a try today</p>
<div class="gmail_quote">On Sep 16, 2015 3:50 AM, "Stian Thorgersen" <<a href="mailto:sthorger@redhat.com">sthorger@redhat.com</a>> 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">Adding to Marko's reponse, the database is automatically initiated by Keycloak (it is also updated on upgrade)</div><div class="gmail_extra"><br><div class="gmail_quote">On 15 September 2015 at 21:01, Marko Strukelj <span dir="ltr"><<a href="mailto:mstrukel@redhat.com" target="_blank">mstrukel@redhat.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>First, you should always use: <a href="http://keycloak.github.io/docs/userguide/html/index.html" target="_blank">http://keycloak.github.io/docs/userguide/html/index.html</a> for the latest documentation.<div><br></div><div>Second, you don't have to change anything in keycloak-server.json file for MySQL setup. </div><div><br></div><div>What you do is modify the KEYCLOAK_HOME/standalone/configuration/standalone.xml file - which is a Wildfly configuration file, and change the KeycloakDS definition there to use MySQL rather than H2.</div><div><br></div><div>In order to install mysql driver into Wildfly you have to create a new module for it under KEYCLOAK_HOME/modules directory, and download a .jar file. <br><div><br></div><div>See this article: <a href="http://wildfly.org/news/2014/02/06/GlassFish-to-WildFly-migration" target="_blank">http://wildfly.org/news/2014/02/06/GlassFish-to-WildFly-migration</a></div><div><br></div><div>I think it goes through all the steps ... </div></div></div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote"><div><div>On Tue, Sep 15, 2015 at 8:21 PM, Fadi Abdin <span dir="ltr"><<a href="mailto:fadiabdeen@gmail.com" target="_blank">fadiabdeen@gmail.com</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div><div dir="ltr">I'm following the instructions on <a href="http://docs.jboss.org/keycloak/docs/1.0-alpha-3/userguide/html/server-installation.html" target="_blank">http://docs.jboss.org/keycloak/docs/1.0-alpha-3/userguide/html/server-installation.html</a> to setup MySQL instead of the H2. <div><br></div><div>But i cant find how do i initiate the keycloak database . is there ddl file i run on the database before setting up the connections in the standalone.xml</div><div><br></div><div>Thanks,</div><div><br></div></div>
<br></div></div>_______________________________________________<br>
keycloak-user mailing list<br>
<a href="mailto:keycloak-user@lists.jboss.org" target="_blank">keycloak-user@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/keycloak-user" rel="noreferrer" target="_blank">https://lists.jboss.org/mailman/listinfo/keycloak-user</a><br></blockquote></div><br></div>
<br>_______________________________________________<br>
keycloak-user mailing list<br>
<a href="mailto:keycloak-user@lists.jboss.org" target="_blank">keycloak-user@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/keycloak-user" rel="noreferrer" target="_blank">https://lists.jboss.org/mailman/listinfo/keycloak-user</a><br></blockquote></div><br></div>
</blockquote></div>