<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi Adam,<br>
<br>
no, you don't need to worry about that error. That's only partial
result. Top level message state SUCCESS<br>
*op*
com.evolveum.midpoint.init.InitialDataImport.initialObjectsImport,
st: SUCCESS, msg: null<br>
<br>
This log message is for informational purposes only. It's logged
during midpoint initialization. Error occurred there<br>
because midpoint checks repository for default objects like system
configuration or default admin user. If these <br>
objects are not in repository they will be imported, otherwise they
aren't replaced. On first run there weren't objects <br>
as you can see below ERROR message, for example:<br>
*op* com.evolveum.midpoint.repo.api.RepositoryService.getObject,
st: FATAL_ERROR, msg: Object of type 'ValuePolicyType' with oid
'00000000-0000-0000-0000-000000000003' was not found.<br>
[cause]ObjectNotFoundException:Object of type
'ValuePolicyType' with oid '00000000-0000-0000-0000-000000000003'
was not found.<br>
<br>
Best regards,<br>
<br>
v<br>
<br>
<div class="moz-cite-prefix">On 03/27/2013 06:16 PM, Adam Davenport
wrote:<br>
</div>
<blockquote cite="mid:51532970.5010408@uwo.ca" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
Thank you Vilo, I made your suggested changes and now I am able to
login to the administrative interface.<br>
<br>
In the idm.log I see the following error message (see attached).
Do I need to worry about this?<br>
<br>
2013-03-27 12:15:28,729 [] [localhost-startStop-1] INFO
(com.evolveum.midpoint.init.InitialDataImport): Initialization
status:<br>
*op*
com.evolveum.midpoint.init.InitialDataImport.initialObjectsImport,
st: SUCCESS, msg: null<br>
*op*
com.evolveum.midpoint.init.InitialDataImport.importObject, st:
FATAL_ERROR, msg: Couldn't import objects.<br>
*op*
com.evolveum.midpoint.model.api.ModelService.getObject, st:
FATAL_ERROR, msg: Object of type 'ValuePolicyType' with oid
'00000000-0000-0000-0000-000000000003' was not found.<br>
<br>
<br>
<div class="moz-cite-prefix">On 26/03/2013 4:15 PM, Viliam Repan
wrote:<br>
</div>
<blockquote cite="mid:515201D7.5010704@evolveum.com" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
Hi Adam,<br>
<br>
at first I'd like to point you to new midpoint version 2.1.1p1
(bugfix release) <a moz-do-not-send="true"
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 moz-do-not-send="true"
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 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>