<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi Adam,<br>
<br>
at first I'd like to point you to new midpoint version 2.1.1p1
(bugfix release) <a class="moz-txt-link-freetext" href="http://evolveum.com/downloads/midpoint/2.1.1p1/">http://evolveum.com/downloads/midpoint/2.1.1p1/</a>
released a couple days ago.<br>
Your context.xml file with datasource looks OK, but config.xml with
repository configuration doesn't use datasource provided by tomcat.<br>
If you upgrade to 2.1.1p1 you can replace <repository> part in
config.xml with xml fragment provided below and midpoint will then
use jdbc/syncopeDataSource.<br>
<br>
<repository><br>
<repositoryServiceFactoryClass>com.evolveum.midpoint.repo.sql.SqlRepositoryFactory</repositoryServiceFactoryClass><br>
<hibernateHbm2ddl>validate</hibernateHbm2ddl><br>
<embedded>false</embedded><br>
<dataSource>java:comp/env/jdbc/syncopeDataSource</dataSource>
<!-- I put there jdbc/syncopeDataSource which I found in your
context.xml --><br>
<hibernateDialect>com.evolveum.midpoint.repo.sql.util.MidPointMySQLDialect</hibernateDialect><br>
</repository><br>
<br>
Other hints:<br>
1/ Please create or recreate DB before you start tomcat.
Midpoint could already change DB schema during your previous
attempts to load application.<br>
(that was caused by hibernateHbm2ddl update). Or at least
check all DATETIME columns they must have new DATETIME(6) type,
because of timestamp precision.<br>
<br>
2/ MySQL database should already contain tables before you run
tomcat. Otherwise midpoint will throw an exception during tomcat
startup. <br>
SQL script location:
<a class="moz-txt-link-freetext" href="https://svn.evolveum.com/midpoint/tags/midpoint-2.1.1/config/mysql-schema.sql">https://svn.evolveum.com/midpoint/tags/midpoint-2.1.1/config/mysql-schema.sql</a><br>
<br>
Best regards,<br>
<br>
<br>
vilo<br>
<br>
<div class="moz-cite-prefix">On 03/26/2013 07:50 PM, Adam Davenport
wrote:<br>
</div>
<blockquote cite="mid:5151EDDA.4040409@uwo.ca" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
Attached is the config.xml you requested. I followed the
directions exactly from <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="https://wiki.evolveum.com/display/midPoint/Repository+Configuration#RepositoryConfiguration-MySQL">https://wiki.evolveum.com/display/midPoint/Repository+Configuration#RepositoryConfiguration-MySQL</a>
including changing hibernateHbm2dll to "update" as per the Errata.<br>
<br>
Note: MySQL version 5.6.10 and context.xml attached for Tomcat
datasource configuration.<br>
<br>
Thanks.<br>
<br>
<br>
<div class="moz-cite-prefix">On 26/03/2013 2:16 PM, Viliam Repan
wrote:<br>
</div>
<blockquote cite="mid:5151E61B.2020409@evolveum.com" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
Hi Adam,<br>
<br>
I'm assuming you're using MySQL version greater or equal than
5.6.4 and you have datasource configured in tomcat. <br>
Could you please post your config.xml file with repository
configuration (it's in your midpoint.home folder)?<br>
<br>
Your repository configuration should probably look something
like this:<br>
<blockquote><repository><br>
<repositoryServiceFactoryClass>com.evolveum.midpoint.repo.sql.SqlRepositoryFactory</repositoryServiceFactoryClass><br>
<hibernateHbm2ddl>validate</hibernateHbm2ddl><br>
<embedded>false</embedded><br>
<dataSource>java:comp/env/jdbc/someDataSourceName</dataSource><br>
<hibernateDialect>com.evolveum.midpoint.repo.sql.util.MidPointMySQLDialect</hibernateDialect><br>
</repository><br>
</blockquote>
Cheers,<br>
<br>
v<br>
<br>
<div class="moz-cite-prefix">On 03/26/2013 06:27 PM, Adam
Davenport wrote:<br>
</div>
<blockquote cite="mid:5151DA6B.2040601@uwo.ca" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
As mentioned, I followed the instructions under "<span
id="title-text"><a moz-do-not-send="true"
href="/display/midPoint/Installing+midPoint+from+Binary+Release+-+2.1.1">Installing
midPoint from Binary Release - 2.1.1</a>". After starting
the Tomcat application server I am unable to access the
admin interface and get the following errors in the logs. I
have done no additional customization other than what is
mentioned in the kiwi page so I am unsure the files o
investigate further. I can attach the full logs if
necessary, please let me know. Thank you.<br>
<br>
<b>idm.log</b><br>
2013-03-26 11:32:45,311
[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1][]
WARN (com.mchange.v2.resourcepool.BasicResourcePool):
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@19d0a2a2
-- Acquisition Attempt Failed!!! Clearing pending acquires.
While trying to acquire a needed new resource, we failed to
succeed more than the maximum number of allowed acquisition
attempts (30). Last acquisition attempt exception: <br>
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right
syntax to use near '??' at line 1<br>
at
sun.reflect.GeneratedConstructorAccessor72.newInstance(Unknown
Source) ~[na:na]<br>
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
~[na:1.7.0]<br>
at
java.lang.reflect.Constructor.newInstance(Constructor.java:525)
~[na:1.7.0]<br>
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
~[mysql-connector-java-5.1.21.jar:na]<br>
<br>
<b>localhost.log</b><br>
Related cause:
org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'jndiDataSource' defined in
URL [<a moz-do-not-send="true" class="moz-txt-link-freetext"
href="jar:file:/C:/Program%20Files/Apache%20Software%20Foundation/Tomcat%207.0/webapps/midpoint/WEB-INF/lib/repo-sql-impl-2.1.1.jar%21/ctx-repository-session.xml">jar:file:/C:/Program%20Files/Apache%20Software%20Foundation/Tomcat%207.0/webapps/midpoint/WEB-INF/lib/repo-sql-impl-2.1.1.jar!/ctx-repository-session.xml</a>]:
Invocation of init method failed; nested exception is
java.lang.IllegalArgumentException: Property 'jndiName' is
required<br>
at
org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:135)<br>
<br>
<b>Infrastruture</b><br>
Server: Windows Server 2008 R2 Standard<br>
App Serv: Tomcat 7.0<br>
Database: MySQL 5.6<br>
Java: Java(TM) SE Runtime Environment (build 1.7.0-b147)<br>
Java HotSpot(TM) 64-Bit Server VM (build 21.0-b17, mixed
mode)<br>
<br>
</span>
<div class="moz-cite-prefix">On 26/03/2013 12:13 PM, Radovan
Semancik wrote:<br>
</div>
<blockquote cite="mid:5151C921.5010901@evolveum.com"
type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<div class="moz-cite-prefix">Hello,<br>
<br>
You are writing to the right place. This list is intended
for general discussion which may include asking questions.
Jira is the right channel to report a bug or request a
feature. But it would be nice to be confident that what
you report is a bug. And that's what this list is for.<br>
<br>
So, what's the problem?<br>
<br>
<pre class="moz-signature" cols="72">--
Radovan Semancik
Software Architect
evolveum.com
</pre>
<br>
<br>
On 03/26/2013 04:57 PM, Adam Davenport wrote:<br>
</div>
<blockquote cite="mid:5151C570.20007@uwo.ca" type="cite">
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
I am in the process of evaluating midPoint as our
university is in the process of selecting a new identity
management solution. My first step is to <span
id="title-text"><a moz-do-not-send="true"
href="/display/midPoint/Installing+midPoint+from+Binary+Release+-+2.1.1">"Installing
midPoint from Binary Release - 2.1.1" but I am having
some issues. I am new to the open source and Evolveum
community and would like to know how I go about
getting community support? Should I use the mailing
list or post to Jira? Thank you.<br>
</a></span>
<pre class="moz-signature" cols="72">--
Adam Davenport
Programmer/Analyst, Information Technology Services
Western University
</pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
midPoint mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.evolveum.com/mailman/listinfo/midpoint">http://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</blockquote>
<br>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
midPoint mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.evolveum.com/mailman/listinfo/midpoint">http://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</blockquote>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
midPoint mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.evolveum.com/mailman/listinfo/midpoint">http://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Ing. Viliam Repáň
Evolveum, s.r.o.
tel: +421 910 797978
mail: <a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:vilo.repan@evolveum.com">vilo.repan@evolveum.com</a>
</pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
midPoint mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.evolveum.com/mailman/listinfo/midpoint">http://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</blockquote>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
midPoint mailing list
<a class="moz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a>
<a class="moz-txt-link-freetext" href="http://lists.evolveum.com/mailman/listinfo/midpoint">http://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Ing. Viliam Repáň
Evolveum, s.r.o.
tel: +421 910 797978
mail: <a class="moz-txt-link-abbreviated" href="mailto:vilo.repan@evolveum.com">vilo.repan@evolveum.com</a>
</pre>
</body>
</html>