<div dir="ltr">What is really, really odd is that I copied the existing database storage (a Docker volume) and started a completely new Keycloak + db on that copy. That worked just fine.<div><br></div><div>Starting a new keycloak pointing to the existing mysql server fails. I've also tried redeploying both mysql and keycloak and that's still wrong. connectionsJpa is set to update.</div><div><br></div><div>I'll try a productiion deploy on the copy of the database and see if that helps</div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div><br></div><div><div style="color:rgb(0,0,0);font-size:12.8px"><div><font face="verdana, sans-serif"><b>Kevin Thorpe</b></font></div><div style="font-family:'Times New Roman'">VP Enterprise Platform</div><div style="font-family:'Times New Roman'"><img src="http://i.imgur.com/8UeC1YO.png" width="96" height="96"><br></div><div style="font-family:'Times New Roman'"><a href="http://www.p-i.net/" style="color:rgb(17,85,204);line-height:18.6311px" target="_blank">www.p-i.net</a> | <a href="https://twitter.com/@PI_150" style="color:rgb(17,85,204);line-height:18.6311px" target="_blank">@PI_150</a></div><br><b style="font-family:'Times New Roman'">T: <a href="tel:%2B44%20%280%2920%203005%206750" value="+442030056750" style="color:rgb(17,85,204)" target="_blank">+44 (0)20 3005 6750</a> | F: <a href="tel:%2B44%280%2920%207730%202635" value="+442077302635" style="color:rgb(17,85,204)" target="_blank">+44(0)20 7730 2635</a> | T: <a href="tel:%2B44%20%280%29808%20204%200344" value="+448082040344" style="color:rgb(17,85,204)" target="_blank">+44 (0)808 204 0344</a> </b><br><b style="font-family:'Times New Roman'"><font color="#515151">150 Buckingham Palace Road, London, SW1W 9TR, UK</font></b><font face="Times New Roman"> </font><br><br><div style="font-family:'Times New Roman'"><a><img src="https://clients.p-i.net/documents/11003/1116416/BSI-UKAS.logo_150.png" height="40px"></a> <a><img src="https://clients.p-i.net/documents/11003/1116416/ISO27001.logo_150.png" height="40px"></a> <a><img src="https://clients.p-i.net/documents/11003/1116416/QMS.logo_150.png" height="40px"></a> <a><img src="https://clients.p-i.net/documents/11003/1116416/pci.logo_150.png" height="40px"></a></div></div><div style="color:rgb(0,0,0);font-family:'Times New Roman';font-size:medium"><br><b><span style="color:rgb(106,168,79)">SAVE PAPER - THINK BEFORE YOU PRINT!</span></b><p><font size="1">____________________________________________________________________</font></p><p style="color:rgb(34,34,34)"><font size="1">This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.</font></p></div></div></div></div></div></div></div></div>
<br><div class="gmail_quote">On 8 August 2016 at 13:48, Marek Posolda <span dir="ltr"><<a href="mailto:mposolda@redhat.com" target="_blank">mposolda@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 bgcolor="#FFFFFF" text="#000000">
<div>From your logs, it seems the problem is
related to migration infinispan caches. It looks that you don't
have defined some of those caches in standalone.xml. <br>
<br>
Generally it's recommended to use Keycloak with keycloak-server
distribution and upgrade process is like this:<br>
- You stop your Keycloak 1.7.0.Final server<br>
- You download the Keycloak-server 2.0.0.Final distribution and
you just configure the DB ( datasource ) to point to same DB like
previously was Keycloak 1.7.0<br>
- You start Keycloak and liquibase make sure to upgrade your DB. <br>
<br>
Note that with this approach, you don't need to care about any
changes, which was done in standalone.xml or keycloak-server.json
or other files between Keycloak 1.7 or 2.0.<br>
<br>
Marek<br>
<br>
<br>
On 08/08/16 14:27, Shiva Saxena wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:rgb(19,79,92)">Hi,</div>
<div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small;color:rgb(19,79,92)"><br>
</div>
<div class="gmail_default"><span style="color:rgb(19,79,92);font-family:arial,helvetica,sans-serif;font-size:small">You
can try setting the "<span>databaseSchema</span>"
to "</span><font color="#333333" face="Consolas, Liberation
Mono, Menlo, Courier, monospace"><span style="font-size:13.6px;letter-spacing:0.2px;line-height:23.12px;background-color:rgb(247,247,247)">update</span></font><font color="#134f5c" face="arial, helvetica, sans-serif">" in "</font><span>connectionsJpa</span><span style="color:rgb(19,79,92);font-family:arial,helvetica,sans-serif">".</span></div>
<div class="gmail_default"><span style="color:rgb(19,79,92);font-family:arial,helvetica,sans-serif"><br>
</span></div>
<div class="gmail_default"><font color="#134f5c" face="arial,
helvetica, sans-serif">Here is the migration guide doc URL</font></div>
<div class="gmail_default"><font color="#134f5c" face="arial,
helvetica, sans-serif"><br>
</font></div>
<div class="gmail_default"><font color="#134f5c" face="arial,
helvetica, sans-serif"><a href="https://keycloak.gitbooks.io/server-adminstration-guide/content/v/2.0/topics/MigrationFromOlderVersions.html" target="_blank">https://keycloak.gitbooks.io/<wbr>server-adminstration-guide/<wbr>content/v/2.0/topics/<wbr>MigrationFromOlderVersions.<wbr>html</a><br>
</font></div>
<div class="gmail_extra"><br>
<div class="gmail_quote"><div><div class="h5">On Mon, Aug 8, 2016 at 4:47 PM, Kevin
Thorpe <span dir="ltr"><<a href="mailto:kevin.thorpe@p-i.net" target="_blank">kevin.thorpe@p-i.net</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 class="h5">
<div dir="ltr">Hi,
<div> I'm having problems upgrading from 1.7.0.Final
to 2.0.0.Final. I'm using the Docker images on which
we build our own images to add https with our certs,
our theme and a small patch to match our LDAP
configuration. The new image of 2.0.0 works fine with
a brand new database but doesn't start up with the
existing database. Do I need to upgrade via an earlier
release to modify the db?</div>
<div><br>
</div>
<div>I've attached the startup logs. I don't know enough
to see what's wrong.<br clear="all">
<div>
<div data-smartmail="gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div dir="ltr">
<div><br>
</div>
<div>
<div style="color:rgb(0,0,0);font-size:12.8px">
<div><font face="verdana, sans-serif"><b>Kevin
Thorpe</b></font></div>
<div>VP Enterprise Platform</div>
<div><img src="http://i.imgur.com/8UeC1YO.png" height="96" width="96"><br>
</div>
<div><a href="http://www.p-i.net/" style="color:rgb(17,85,204);line-height:18.6311px" target="_blank">www.p-i.net</a> | <a href="https://twitter.com/@PI_150" style="color:rgb(17,85,204);line-height:18.6311px" target="_blank">@PI_150</a></div>
<br>
<b>T: <a href="tel:%2B44%20%280%2920%203005%206750" value="+442030056750" style="color:rgb(17,85,204)" target="_blank">+44 (0)20 3005
6750</a> | F: <a href="tel:%2B44%280%2920%207730%202635" value="+442077302635" style="color:rgb(17,85,204)" target="_blank">+44(0)20 7730 2635</a> |
T: <a href="tel:%2B44%20%280%29808%20204%200344" value="+448082040344" style="color:rgb(17,85,204)" target="_blank">+44 (0)808 204
0344</a> </b><br>
<b><font color="#515151">150
Buckingham Palace Road, London,
SW1W 9TR, UK</font></b><font face="Times New Roman"> </font><br>
<br>
<div><a><img src="https://clients.p-i.net/documents/11003/1116416/BSI-UKAS.logo_150.png" height="40px"></a> <a><img src="https://clients.p-i.net/documents/11003/1116416/ISO27001.logo_150.png" height="40px"></a> <a><img src="https://clients.p-i.net/documents/11003/1116416/QMS.logo_150.png" height="40px"></a> <a><img src="https://clients.p-i.net/documents/11003/1116416/pci.logo_150.png" height="40px"></a></div>
</div>
<div><br>
<b><span style="color:rgb(106,168,79)">SAVE
PAPER - THINK BEFORE YOU PRINT!</span></b>
<p><font size="1">______________________________<wbr>______________________________<wbr>________</font></p>
<p style="color:rgb(34,34,34)"><font size="1">This email and any files
transmitted with it are
confidential and intended solely
for the use of the individual or
entity to whom they are addressed.
If you have received this email in
error please notify the system
manager. This message contains
confidential information and is
intended only for the individual
named. If you are not the named
addressee you should not
disseminate, distribute or copy
this e-mail. Please notify the
sender immediately by e-mail if
you have received this e-mail by
mistake and delete this e-mail
from your system. If you are not
the intended recipient you are
notified that disclosing, copying,
distributing or taking any action
in reliance on the contents of
this information is strictly
prohibited.</font></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br></div></div>
______________________________<wbr>_________________<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/mailma<wbr>n/listinfo/keycloak-user</a><br>
</blockquote>
</div>
<br>
<br clear="all"><span class="HOEnZb"><font color="#888888">
<div><br>
</div>
-- <br>
<div data-smartmail="gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr"><font style="font-family:Calibri,sans-serif" color="#000000" face="Calibri,sans-serif">
<div style="line-height:21.2999992370605px"><font size="2">Best Regards</font></div>
</font>
<div style="line-height:21.2999992370605px;color:rgb(68,68,68);font-family:Calibri,sans-serif"><font style="line-height:normal" color="#2672ec"><span style="line-height:21px"><font style="line-height:normal"><b style="line-height:22.7199993133545px"><font style="line-height:normal" face="Calibri" size="2">Shiva Saxena</font></b></font></span><font face="Calibri"><span style="line-height:21px"><font style="line-height:normal" size="2"><b style="line-height:18.4599990844727px">
</b></font></span></font></font>
<div style="line-height:21px"><font style="line-height:normal" size="2"><b style="line-height:18.4599990844727px"><font style="line-height:normal" color="#2672ec" face="Calibri"><a href="http://metalop.com/" style="line-height:18.4599990844727px;font-weight:inherit;color:blue" target="_blank">Blog</a></font><font style="line-height:normal" color="#444444"> | <a href="http://in.linkedin.com/in/shivasaxena/" style="line-height:18.4599990844727px;font-weight:inherit;color:blue" target="_blank">Linkedin</a> | <a href="http://stackoverflow.com/users/2490343/shiva" style="line-height:18.4599990844727px;font-weight:inherit;color:blue" target="_blank">StackOverflo<wbr>w</a></font></b></font></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</font></span></div><span class="HOEnZb"><font color="#888888">
</font></span></div><span class="HOEnZb"><font color="#888888">
<br>
<fieldset></fieldset>
<br>
<pre>______________________________<wbr>_________________
keycloak-user mailing list
<a href="mailto:keycloak-user@lists.jboss.org" target="_blank">keycloak-user@lists.jboss.org</a>
<a href="https://lists.jboss.org/mailman/listinfo/keycloak-user" target="_blank">https://lists.jboss.org/<wbr>mailman/listinfo/keycloak-user</a></pre>
</font></span></blockquote>
<br>
</div>
</blockquote></div><br></div>