[midPoint] midPoint Support
Viliam Repan
vilo.repan at evolveum.com
Tue Mar 26 21:15:19 CET 2013
Hi Adam,
at first I'd like to point you to new midpoint version 2.1.1p1 (bugfix
release) http://evolveum.com/downloads/midpoint/2.1.1p1/ released a
couple days ago.
Your context.xml file with datasource looks OK, but config.xml with
repository configuration doesn't use datasource provided by tomcat.
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.
<repository>
<repositoryServiceFactoryClass>com.evolveum.midpoint.repo.sql.SqlRepositoryFactory</repositoryServiceFactoryClass>
<hibernateHbm2ddl>validate</hibernateHbm2ddl>
<embedded>false</embedded>
<dataSource>java:comp/env/jdbc/syncopeDataSource</dataSource> <!-- I put
there jdbc/syncopeDataSource which I found in your context.xml -->
<hibernateDialect>com.evolveum.midpoint.repo.sql.util.MidPointMySQLDialect</hibernateDialect>
</repository>
Other hints:
1/ Please create or recreate DB before you start tomcat. Midpoint
could already change DB schema during your previous attempts to load
application.
(that was caused by hibernateHbm2ddl update). Or at least check
all DATETIME columns they must have new DATETIME(6) type, because of
timestamp precision.
2/ MySQL database should already contain tables before you run
tomcat. Otherwise midpoint will throw an exception during tomcat startup.
SQL script location:
https://svn.evolveum.com/midpoint/tags/midpoint-2.1.1/config/mysql-schema.sql
Best regards,
vilo
On 03/26/2013 07:50 PM, Adam Davenport wrote:
> Attached is the config.xml you requested. I followed the directions
> exactly from
> https://wiki.evolveum.com/display/midPoint/Repository+Configuration#RepositoryConfiguration-MySQL
> including changing hibernateHbm2dll to "update" as per the Errata.
>
> Note: MySQL version 5.6.10 and context.xml attached for Tomcat
> datasource configuration.
>
> Thanks.
>
>
> On 26/03/2013 2:16 PM, Viliam Repan wrote:
>> Hi Adam,
>>
>> I'm assuming you're using MySQL version greater or equal than 5.6.4
>> and you have datasource configured in tomcat.
>> Could you please post your config.xml file with repository
>> configuration (it's in your midpoint.home folder)?
>>
>> Your repository configuration should probably look something like this:
>>
>> <repository>
>> <repositoryServiceFactoryClass>com.evolveum.midpoint.repo.sql.SqlRepositoryFactory</repositoryServiceFactoryClass>
>> <hibernateHbm2ddl>validate</hibernateHbm2ddl>
>> <embedded>false</embedded>
>> <dataSource>java:comp/env/jdbc/someDataSourceName</dataSource>
>> <hibernateDialect>com.evolveum.midpoint.repo.sql.util.MidPointMySQLDialect</hibernateDialect>
>> </repository>
>>
>> Cheers,
>>
>> v
>>
>> On 03/26/2013 06:27 PM, Adam Davenport wrote:
>>> As mentioned, I followed the instructions under "Installing midPoint
>>> from Binary Release - 2.1.1
>>> </display/midPoint/Installing+midPoint+from+Binary+Release+-+2.1.1>".
>>> 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.
>>>
>>> *idm.log*
>>> 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 at 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:
>>> 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
>>> at
>>> sun.reflect.GeneratedConstructorAccessor72.newInstance(Unknown
>>> Source) ~[na:na]
>>> at
>>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
>>> ~[na:1.7.0]
>>> at
>>> java.lang.reflect.Constructor.newInstance(Constructor.java:525)
>>> ~[na:1.7.0]
>>> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
>>> ~[mysql-connector-java-5.1.21.jar:na]
>>>
>>> *localhost.log*
>>> Related cause:
>>> org.springframework.beans.factory.BeanCreationException: Error
>>> creating bean with name 'jndiDataSource' defined in URL
>>> [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]:
>>> Invocation of init method failed; nested exception is
>>> java.lang.IllegalArgumentException: Property 'jndiName' is required
>>> at
>>> org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:135)
>>>
>>> *Infrastruture*
>>> Server: Windows Server 2008 R2 Standard
>>> App Serv: Tomcat 7.0
>>> Database: MySQL 5.6
>>> Java: Java(TM) SE Runtime Environment (build 1.7.0-b147)
>>> Java HotSpot(TM) 64-Bit Server VM (build 21.0-b17, mixed mode)
>>>
>>> On 26/03/2013 12:13 PM, Radovan Semancik wrote:
>>>> Hello,
>>>>
>>>> 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.
>>>>
>>>> So, what's the problem?
>>>>
>>>> --
>>>>
>>>> Radovan Semancik
>>>> Software Architect
>>>> evolveum.com
>>>>
>>>>
>>>> On 03/26/2013 04:57 PM, Adam Davenport wrote:
>>>>> 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 "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.
>>>>> </display/midPoint/Installing+midPoint+from+Binary+Release+-+2.1.1>
>>>>> --
>>>>> Adam Davenport
>>>>> Programmer/Analyst, Information Technology Services
>>>>> Western University
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> midPoint mailing list
>>>>> midPoint at lists.evolveum.com
>>>>> http://lists.evolveum.com/mailman/listinfo/midpoint
>>>>
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> midPoint mailing list
>>>> midPoint at lists.evolveum.com
>>>> http://lists.evolveum.com/mailman/listinfo/midpoint
>>>
>>>
>>>
>>> _______________________________________________
>>> midPoint mailing list
>>> midPoint at lists.evolveum.com
>>> http://lists.evolveum.com/mailman/listinfo/midpoint
>>
>> --
>> Ing. Viliam Repán(
>> Evolveum, s.r.o.
>>
>> tel: +421 910 797978
>> mail:vilo.repan at evolveum.com
>>
>>
>> _______________________________________________
>> midPoint mailing list
>> midPoint at lists.evolveum.com
>> http://lists.evolveum.com/mailman/listinfo/midpoint
>
>
>
> _______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com
> http://lists.evolveum.com/mailman/listinfo/midpoint
--
Ing. Viliam Repán(
Evolveum, s.r.o.
tel: +421 910 797978
mail: vilo.repan at evolveum.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20130326/553b1bd2/attachment.htm>
More information about the midPoint
mailing list