<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
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 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>