You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@syncope.apache.org by Ralph de Boom <ra...@finalist.com> on 2015/10/07 17:22:46 UTC

Clean project install syncope 1.2.5 not working

Hi!

I followed:

https://cwiki.apache.org/confluence/display/SYNCOPE/Create+a+new+Syncope+project

and

https://cwiki.apache.org/confluence/display/SYNCOPE/Run+Syncope+in+real+environments

Using:

-Ubuntu 14.04
-Oracle JDK 7
-Tomcat 7.0.64
-Mysql 5.6

After using mvn clean package, i copy the 2 generated war files to 
webapps/.
Then I start tomcat by running ./catalina.sh run in the bin/ folder.

This results into:

SEVERE: Exception sending context initialized event to listener instance 
of class org.springframework.web.context.ContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating 
bean with name 'springContextInitializer' defined in file 
[/home/ralph/opt/apache-tomcat-7.0.64/apache-tomcat-7.0.64/webapps/syncope/WEB-INF/classes/org/apache/syncope/core/init/SpringContextInitializer.class]: 
Invocation of init method failed; nested exception is 
<openjpa-2.3.0-r422266:1540826 fatal user error> 
org.apache.openjpa.persistence.ArgumentException: Errors encountered 
while resolving metadata.  See nested exceptions for details.
         at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1554) 

         at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539) 

         at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475) 

         at 
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:302) 

         at 
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:229) 

         at 
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:298) 

         at 
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193) 

         at 
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:706) 

         at 
org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:762) 

         at 
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482) 

         at 
org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:403) 

         at 
org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306) 

         at 
org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106) 

         at 
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5003) 

         at 
org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5517) 

         at 
org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
         at 
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) 

         at 
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
         at 
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)
         at 
org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1095)
         at 
org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1930)
         at 
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
         at java.util.concurrent.FutureTask.run(FutureTask.java:262)
         at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) 

         at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) 

         at java.lang.Thread.run(Thread.java:745)
Caused by: <openjpa-2.3.0-r422266:1540826 fatal user error> 
org.apache.openjpa.persistence.ArgumentException: Errors encountered 
while resolving metadata.  See nested exceptions for details.
         at 
org.apache.openjpa.meta.MetaDataRepository.resolve(MetaDataRepository.java:675) 

         at 
org.apache.openjpa.meta.MetaDataRepository.getMetaDataInternal(MetaDataRepository.java:418) 

         at 
org.apache.openjpa.meta.MetaDataRepository.getMetaData(MetaDataRepository.java:389) 

         at 
org.apache.openjpa.meta.MetaDataRepository.getMetaData(MetaDataRepository.java:472) 

         at 
org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getClassMetaData(JPQLExpressionBuilder.java:176) 

         at 
org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.resolveClassMetaData(JPQLExpressionBuilder.java:152) 

         at 
org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateMetaData(JPQLExpressionBuilder.java:242) 

         at 
org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateMetaData(JPQLExpressionBuilder.java:212) 

         at 
org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateType(JPQLExpressionBuilder.java:205) 

         at 
org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.access$200(JPQLExpressionBuilder.java:80) 

         at 
org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.populate(JPQLExpressionBuilder.java:2428) 

         at 
org.apache.openjpa.kernel.jpql.JPQLParser.populate(JPQLParser.java:61)
         at 
org.apache.openjpa.kernel.ExpressionStoreQuery.populateFromCompilation(ExpressionStoreQuery.java:162) 

         at 
org.apache.openjpa.datacache.QueryCacheStoreQuery.populateFromCompilation(QueryCacheStoreQuery.java:268) 

         at 
org.apache.openjpa.kernel.QueryImpl.newCompilation(QueryImpl.java:673)
         at 
org.apache.openjpa.kernel.QueryImpl.compilationFromCache(QueryImpl.java:654) 

         at 
org.apache.openjpa.kernel.QueryImpl.compileForCompilation(QueryImpl.java:620) 

         at 
org.apache.openjpa.kernel.QueryImpl.compileForExecutor(QueryImpl.java:682)
         at org.apache.openjpa.kernel.QueryImpl.compile(QueryImpl.java:589)
         at 
org.apache.openjpa.persistence.EntityManagerImpl.createQuery(EntityManagerImpl.java:997) 

         at 
org.apache.openjpa.persistence.EntityManagerImpl.createQuery(EntityManagerImpl.java:979) 

         at 
org.apache.openjpa.persistence.EntityManagerImpl.createQuery(EntityManagerImpl.java:975) 

         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
         at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 

         at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 

         at java.lang.reflect.Method.invoke(Method.java:606)
         at 
org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:291) 

         at com.sun.proxy.$Proxy43.createQuery(Unknown Source)
         at 
org.apache.syncope.core.persistence.dao.impl.ResourceDAOImpl.findAll(ResourceDAOImpl.java:125) 

         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
         at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 

         at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 

         at java.lang.reflect.Method.invoke(Method.java:606)
         at 
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) 

         at 
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201) 

         at com.sun.proxy.$Proxy45.findAll(Unknown Source)
         at 
org.apache.syncope.core.init.ConnectorManager.load(ConnectorManager.java:118) 

         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
         at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 

         at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 

         at java.lang.reflect.Method.invoke(Method.java:606)
         at 
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) 

         at 
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) 

         at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) 

         at 
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98) 

         at 
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:262) 

         at 
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95) 

         at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 

         at 
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) 

         at com.sun.proxy.$Proxy47.load(Unknown Source)
         at 
org.apache.syncope.core.init.SpringContextInitializer.afterPropertiesSet(SpringContextInitializer.java:57) 

         at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1613) 

         at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1550) 

         ... 25 more
Caused by: <openjpa-2.3.0-r422266:1540826 fatal user error> 
org.apache.openjpa.persistence.ArgumentException: Table 
"ExternalResource" given for 
"org.apache.syncope.core.persistence.beans.ExternalResource" does not 
exist.
         at 
org.apache.openjpa.jdbc.meta.MappingInfo.createTable(MappingInfo.java:532)
         at 
org.apache.openjpa.jdbc.meta.ClassMappingInfo.getTable(ClassMappingInfo.java:309) 

         at 
org.apache.openjpa.jdbc.meta.ClassMappingInfo.getTable(ClassMappingInfo.java:331) 

         at 
org.apache.openjpa.jdbc.meta.strats.FullClassStrategy.map(FullClassStrategy.java:73) 

         at 
org.apache.openjpa.jdbc.meta.ClassMapping.setStrategy(ClassMapping.java:392) 

         at 
org.apache.openjpa.jdbc.meta.RuntimeStrategyInstaller.installStrategy(RuntimeStrategyInstaller.java:56) 

         at 
org.apache.openjpa.jdbc.meta.MappingRepository.prepareMapping(MappingRepository.java:410) 

         at 
org.apache.openjpa.meta.MetaDataRepository.preMapping(MetaDataRepository.java:769) 

         at 
org.apache.openjpa.meta.MetaDataRepository.resolve(MetaDataRepository.java:658) 

         ... 77 more

If I look in the mysql database. These tables have been generated:

ACT_EVT_LOG
ACT_GE_BYTEARRAY
ACT_GE_PROPERTY
ACT_HI_ACTINST
ACT_HI_ATTACHMENT
ACT_HI_COMMENT
ACT_HI_DETAIL
ACT_HI_IDENTITYLINK
ACT_HI_PROCINST
ACT_HI_TASKINST
ACT_HI_VARINST
ACT_ID_GROUP
ACT_ID_INFO
ACT_ID_MEMBERSHIP
ACT_ID_USER
ACT_RE_DEPLOYMENT
ACT_RE_MODEL
ACT_RE_PROCDEF
ACT_RU_EVENT_SUBSCR
ACT_RU_EXECUTION
ACT_RU_IDENTITYLINK
ACT_RU_JOB
ACT_RU_TASK
ACT_RU_VARIABLE
QRTZ_CRON_TRIGGERS
QRTZ_FIRED_TRIGGERS
QRTZ_LOCKS
QRTZ_PAUSED_TRIGGER_GRPS
QRTZ_SCHEDULER_STATE
QRTZ_SIMPLE_TRIGGERS
SYNCOPEAUDIT

I think syncope is failing somewhere to make more tables it needs.

The documentation doesn't provide any answer to this.

Cheers,
Ralph

Re: Clean project install syncope 1.2.5 not working

Posted by Ralph de Boom <ra...@finalist.com>.
Oh, And if you wonder why I was using 'mvn clean package', I had run 
earlier into different problems with 'mvn clean package 
-Dconf.directory=/opt/syncope/conf 
-Dbundles.directory=/opt/syncope/bundles 
-Dlog.directory=/opt/syncope/log ', in which syncope did do even less. 
So hence, i started running mvn clean package....

^_^

On 09-10-15 13:46, Ralph de Boom wrote:
> On 09-10-15 13:20, Francesco Chicchiriccò wrote:
>> mvn clean package -Dconf.directory=/opt/syncope/conf 
>> -Dbundles.directory=/opt/syncope/bundles 
>> -Dlog.directory=/opt/syncope/log
>
> Huzzah, I finally found the cause.
>
> using mvn clean package, the eventual war generated will contain 
> references to load stuff from the project source directory. Which 
> causes stuff to be loaded on runtime that breaks deploying the war 
> properly.
>
> strace -f -e trace=open bin/catalina.sh run 2>>strace2.log 3>>strace2.log
>
> cat strace.log | grep open | grep /home/ralph/projects/
> [pid 27424] 
> open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/log/core.log", 
> O_RDWR|O_CREAT, 0666) = 200
> [pid 27424] 
> open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/log/core-persistence.log", 
> O_RDWR|O_CREAT, 0666) = 201
> [pid 27424] 
> open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/log/core-rest.log", 
> O_RDWR|O_CREAT, 0666) = 202
> [pid 27424] 
> open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/log/core-connid.log", 
> O_RDWR|O_CREAT, 0666) = 203
> [pid 27424] 
> open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/test-classes/persistence.properties", 
> O_RDONLY) = 204
> [pid 27424] 
> open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/test-classes/persistence.properties", 
> O_RDONLY) = 204
> [pid 27424] 
> open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/test-classes/rest.properties", 
> O_RDONLY) = -1 ENOENT (No such file or directory)
> [pid 27424] 
> open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/test-classes/security.properties", 
> O_RDONLY) = -1 ENOENT (No such file or directory)
> [pid 27424] 
> open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/test-classes/connid.properties", 
> O_RDONLY) = 204
> [pid 27424] 
> open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/test-classes/workflow.properties", 
> O_RDONLY) = -1 ENOENT (No such file or directory)
> [pid 27424] 
> open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/test-classes/mail.properties", 
> O_RDONLY) = 204
> [pid 27424] 
> open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/bundles/net.tirasa.connid.bundles.ldap-1.4.0.jar", 
> O_RDONLY) = 205
> [pid 27424] 
> open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/bundles/net.tirasa.connid.bundles.soap-1.3.0.jar", 
> O_RDONLY) = 205
> [pid 27424] 
> open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/bundles/net.tirasa.connid.bundles.db.table-2.2.2.jar", 
> O_RDONLY) = 205
> [pid 27424] 
> open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/bundles/net.tirasa.connid.bundles.ad-1.2.3.jar", 
> O_RDONLY) = 205
> [pid 27424] 
> open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/bundles/net.tirasa.connid.bundles.csvdir-0.8.2.jar", 
> O_RDONLY) = 205
> [pid 27424] 
> open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/bundles/net.tirasa.connid.bundles.ldap-1.4.0.jar", 
> O_RDONLY) = 205
> [pid 27424] 
> open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/bundles/net.tirasa.connid.bundles.soap-1.3.0.jar", 
> O_RDONLY) = 207
> [pid 27424] 
> open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/bundles/net.tirasa.connid.bundles.db.table-2.2.2.jar", 
> O_RDONLY) = 246
> [pid 27424] 
> open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/bundles/net.tirasa.connid.bundles.ad-1.2.3.jar", 
> O_RDONLY) = 248
> [pid 27424] 
> open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/bundles/net.tirasa.connid.bundles.csvdir-0.8.2.jar", 
> O_RDONLY) = 252
> [pid 27424] 
> open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/console/target/log/console.log", 
> O_RDWR|O_CREAT, 0666) = 107
> [pid 27424] 
> open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/console/target/test-classes/console.properties", 
> O_RDONLY) = 108
>
> I don't know which of these files causes the problems I had. But my 
> case is solved.
>
> I might add a note that even with 'mvn clean package 
> -Dconf.directory=/opt/syncope/conf 
> -Dbundles.directory=/opt/syncope/bundles 
> -Dlog.directory=/opt/syncope/log' a reference to my project source dir 
> is still made!
>
> ./webapps/syncope-console/WEB-INF/classes/console.properties:21:activitiModelerDirectory=/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/console/target/activiti-modeler 
>
>
> If this might cause problems you might need to include this on the 
> documentation how to change this setting accordingly?
>
> Cheers,
> Ralph


Re: Clean project install syncope 1.2.5 not working

Posted by Francesco Chicchiriccò <il...@apache.org>.
On 09/10/2015 13:46, Ralph de Boom wrote:
> On 09-10-15 13:20, Francesco Chicchiriccò wrote:
>> mvn clean package -Dconf.directory=/opt/syncope/conf 
>> -Dbundles.directory=/opt/syncope/bundles 
>> -Dlog.directory=/opt/syncope/log
>
> Huzzah, I finally found the cause.
>
> using mvn clean package, the eventual war generated will contain 
> references to load stuff from the project source directory. Which 
> causes stuff to be loaded on runtime that breaks deploying the war 
> properly.
>
> [...]
>
> I don't know which of these files causes the problems I had. But my 
> case is solved.
>
> I might add a note that even with 'mvn clean package 
> -Dconf.directory=/opt/syncope/conf 
> -Dbundles.directory=/opt/syncope/bundles 
> -Dlog.directory=/opt/syncope/log' a reference to my project source dir 
> is still made!
>
> ./webapps/syncope-console/WEB-INF/classes/console.properties:21:activitiModelerDirectory=/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/console/target/activiti-modeler 
>
>
> If this might cause problems you might need to include this on the 
> documentation how to change this setting accordingly?

Activiti Modeler is a separate component that can be enabled by following

https://cwiki.apache.org/confluence/display/SYNCOPE/Enable+Activiti+Modeler

I don't think the dangling reference to activitiModelerDirectory should 
cause any trouble, because it is contained in console.properties, which 
in turn is first looked up in conf.directory, then in classpath.

Glad that you've solved :-)
Regards.

-- 
Francesco Chicchiriccò

Tirasa - Open Source Excellence
http://www.tirasa.net/

Involved at The Apache Software Foundation:
member, Syncope PMC chair, Cocoon PMC, Olingo PMC
http://people.apache.org/~ilgrosso/



Re: Clean project install syncope 1.2.5 not working

Posted by Ralph de Boom <ra...@finalist.com>.
On 09-10-15 13:20, Francesco Chicchiriccò wrote:
> mvn clean package -Dconf.directory=/opt/syncope/conf 
> -Dbundles.directory=/opt/syncope/bundles -Dlog.directory=/opt/syncope/log

Huzzah, I finally found the cause.

using mvn clean package, the eventual war generated will contain 
references to load stuff from the project source directory. Which causes 
stuff to be loaded on runtime that breaks deploying the war properly.

strace -f -e trace=open bin/catalina.sh run 2>>strace2.log 3>>strace2.log

cat strace.log | grep open | grep /home/ralph/projects/
[pid 27424] 
open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/log/core.log", 
O_RDWR|O_CREAT, 0666) = 200
[pid 27424] 
open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/log/core-persistence.log", 
O_RDWR|O_CREAT, 0666) = 201
[pid 27424] 
open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/log/core-rest.log", 
O_RDWR|O_CREAT, 0666) = 202
[pid 27424] 
open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/log/core-connid.log", 
O_RDWR|O_CREAT, 0666) = 203
[pid 27424] 
open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/test-classes/persistence.properties", 
O_RDONLY) = 204
[pid 27424] 
open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/test-classes/persistence.properties", 
O_RDONLY) = 204
[pid 27424] 
open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/test-classes/rest.properties", 
O_RDONLY) = -1 ENOENT (No such file or directory)
[pid 27424] 
open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/test-classes/security.properties", 
O_RDONLY) = -1 ENOENT (No such file or directory)
[pid 27424] 
open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/test-classes/connid.properties", 
O_RDONLY) = 204
[pid 27424] 
open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/test-classes/workflow.properties", 
O_RDONLY) = -1 ENOENT (No such file or directory)
[pid 27424] 
open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/test-classes/mail.properties", 
O_RDONLY) = 204
[pid 27424] 
open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/bundles/net.tirasa.connid.bundles.ldap-1.4.0.jar", 
O_RDONLY) = 205
[pid 27424] 
open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/bundles/net.tirasa.connid.bundles.soap-1.3.0.jar", 
O_RDONLY) = 205
[pid 27424] 
open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/bundles/net.tirasa.connid.bundles.db.table-2.2.2.jar", 
O_RDONLY) = 205
[pid 27424] 
open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/bundles/net.tirasa.connid.bundles.ad-1.2.3.jar", 
O_RDONLY) = 205
[pid 27424] 
open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/bundles/net.tirasa.connid.bundles.csvdir-0.8.2.jar", 
O_RDONLY) = 205
[pid 27424] 
open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/bundles/net.tirasa.connid.bundles.ldap-1.4.0.jar", 
O_RDONLY) = 205
[pid 27424] 
open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/bundles/net.tirasa.connid.bundles.soap-1.3.0.jar", 
O_RDONLY) = 207
[pid 27424] 
open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/bundles/net.tirasa.connid.bundles.db.table-2.2.2.jar", 
O_RDONLY) = 246
[pid 27424] 
open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/bundles/net.tirasa.connid.bundles.ad-1.2.3.jar", 
O_RDONLY) = 248
[pid 27424] 
open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/core/target/bundles/net.tirasa.connid.bundles.csvdir-0.8.2.jar", 
O_RDONLY) = 252
[pid 27424] 
open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/console/target/log/console.log", 
O_RDWR|O_CREAT, 0666) = 107
[pid 27424] 
open("/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/console/target/test-classes/console.properties", 
O_RDONLY) = 108

I don't know which of these files causes the problems I had. But my case 
is solved.

I might add a note that even with 'mvn clean package 
-Dconf.directory=/opt/syncope/conf 
-Dbundles.directory=/opt/syncope/bundles 
-Dlog.directory=/opt/syncope/log' a reference to my project source dir 
is still made!

./webapps/syncope-console/WEB-INF/classes/console.properties:21:activitiModelerDirectory=/home/ralph/projects/git/bnl-iam-syncope-1.2.5/nl.stichtingbibliotheek.idm/console/target/activiti-modeler

If this might cause problems you might need to include this on the 
documentation how to change this setting accordingly?

Cheers,
Ralph

Re: Clean project install syncope 1.2.5 not working

Posted by Francesco Chicchiriccò <il...@apache.org>.
On 09/10/2015 13:15, Ralph de Boom wrote:
> Hmm,
>
> So far my discoveries:
>
> Using:
>
> -My localhost and a freshly installed VM with mysql-server-5-6 = broken
> -That freshly installed VM with openjdk-7 + mysql-server-5-6 = works
> -My localhost with openjdk-7 with installed VM with mysql-server-5-6 = 
> broken
> -My chroot jail localhost with openjdk-7 with mysql-server-5-6 = works
>
> So now my question is. Which files other than in the apache tomcat 
> path does syncope read during runtime that might influence how 
> databases are not created...?

The only files and directories - besides Tomcat's - are the ones you 
specify at build time via

mvn clean package -Dconf.directory=/opt/syncope/conf 
-Dbundles.directory=/opt/syncope/bundles -Dlog.directory=/opt/syncope/log

as specified in

https://cwiki.apache.org/confluence/display/SYNCOPE/Run+Syncope+in+real+environments#RunSyncopeinrealenvironments-Syncope%3E=1.2.0

If you have not used this exact command for building, please do and test 
again.
Regards.

> (My localhost is running on full disk encryption set during ubuntu 
> install itself... But that shouldn't cause problems...?)
>
> Cheers,
> Ralph
>
> On 09-10-15 11:48, Ralph de Boom wrote:
>> Hi both,
>>
>> Hmm, well now I know at least the project itself is functioning 
>> properly and got to investigate why mysql aint then..
>>
>> only things different from default configuration is:
>>
>> datadir = /mnt/disk2/mysql
>> innodb_file_per_table=1
>>
>> The reason for that is my current mysql instance has a syncope 1.1.8 
>> installation of 70+GB syncope db with ACT_GE_BYTEARRAY.ibd being 
>> 63+gb (3800users defined). Which doesn't fit on my SSD...
>>
>> Ill revert these 2 changes back to /var/lib/mysql and run it again today.
>>
>> Thanks for the time again

-- 
Francesco Chicchiriccò

Tirasa - Open Source Excellence
http://www.tirasa.net/

Involved at The Apache Software Foundation:
member, Syncope PMC chair, Cocoon PMC, Olingo PMC
http://people.apache.org/~ilgrosso/


Re: Clean project install syncope 1.2.5 not working

Posted by Ralph de Boom <ra...@finalist.com>.
Hmm,

So far my discoveries:

Using:

-My localhost and a freshly installed VM with mysql-server-5-6 = broken
-That freshly installed VM with openjdk-7 + mysql-server-5-6 = works
-My localhost with openjdk-7 with installed VM with mysql-server-5-6 = 
broken
-My chroot jail localhost with openjdk-7 with mysql-server-5-6 = works

So now my question is. Which files other than in the apache tomcat path 
does syncope read during runtime that might influence how databases are 
not created...?

(My localhost is running on full disk encryption set during ubuntu 
install itself... But that shouldn't cause problems...?)

Cheers,
Ralph

On 09-10-15 11:48, Ralph de Boom wrote:
> Hi both,
>
> Hmm, well now I know at least the project itself is functioning 
> properly and got to investigate why mysql aint then..
>
> only things different from default configuration is:
>
> datadir = /mnt/disk2/mysql
> innodb_file_per_table=1
>
> The reason for that is my current mysql instance has a syncope 1.1.8 
> installation of 70+GB syncope db with ACT_GE_BYTEARRAY.ibd being 63+gb 
> (3800users defined). Which doesn't fit on my SSD...
>
> Ill revert these 2 changes back to /var/lib/mysql and run it again today.
>
> Thanks for the time again
>


Re: Clean project install syncope 1.2.5 not working

Posted by Ralph de Boom <ra...@finalist.com>.
Hi both,

Hmm, well now I know at least the project itself is functioning properly 
and got to investigate why mysql aint then..

only things different from default configuration is:

datadir = /mnt/disk2/mysql
innodb_file_per_table=1

The reason for that is my current mysql instance has a syncope 1.1.8 
installation of 70+GB syncope db with ACT_GE_BYTEARRAY.ibd being 63+gb 
(3800users defined). Which doesn't fit on my SSD...

Ill revert these 2 changes back to /var/lib/mysql and run it again today.

Thanks for the time again

On 09-10-15 08:53, Francesco Chicchiriccò wrote:
> Hi Ralph,
> I confirm what Marco said below: barely decompressing your own
>
> apache-tomcat-7.0.64.tar.gz
>
> from
>
> https://www.dropbox.com/sh/u13p574i58frrc8/AACh0uvxuy268doqvoRU7Zxha?dl=0
>
> and starting, everything works (naturally Syncope complains about some 
> paths it could not find, but this is a consequence of not using 
> -Dconf* params when building, as suggested).
>
> I did this on my laptop, Kubuntu 15.04 with latest MySQL 5.6 from 
> standard packages and no special configuration.
>
> A couple of questions to you:
>
>  1. did you make any special configuration for MySQL (like as 
> lower_case_table_names [1] or InnoDB)?
>  2. can you try to build your own project on a different machine?
>
> Regards.
>
> [1] 
> http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_lower_case_table_names
>
> On 08/10/2015 18:49, Ralph de Boom wrote:
>> A followup, yes, embedded mode works.
>>
>> But with mysql 5.6, the target aimed database we're running on, it's 
>> not working.
>>
>> Running on java 7 or 8 doesn't make a difference at all.
>>
>> On 08-Oct-15 18:41, Ralph de Boom wrote:
>>> Before running tomcat, delete the database and recreate it.
>>>
>>> I've been doing this for the past 2 days now...
>>>
>>> Where should core.log, core-rest.log, console.log be generated? I 
>>> can't find them...
>>>
>>> Cheers again.
>>>
>>> On 08-Oct-15 18:27, Marco Di Sabatino Di Diodoro wrote:
>>>> Hi Ralph,
>>>>
>>>> I used your Apache Tomcat with the deployed wars and it works. 
>>>> After, I runned your src in embedded mode and it works properly.
>>>> In your uploaded files I can't find syncope logs (core.log, 
>>>> core-rest.log, console.log ...).
>>>>
>>>> Before running tomcat, delete the database and recreate it.
>>>>
>>>> Marco
>>>>
>>>>
>>>> Il 08/10/2015 14:28, PhoenixtheII ha scritto:
>>>>> I added mysqlquery.log to the same dropbox link. It seems that the syncope
>>>>> tables are never queried if the exists by openjpa. But for the activity
>>>>> tables it does do that, and finds out it needs to make them.
>>>>>
>>>>> --
>>>>> View this message in context:http://syncope-user.1051894.n5.nabble.com/Clean-project-install-syncope-1-2-5-not-working-tp5708144p5708150.html
>>>>> Sent from the syncope-user mailing list archive at Nabble.com.
> -- 
> Francesco Chicchiriccò
>
> Tirasa - Open Source Excellence
> http://www.tirasa.net/
>
> Involved at The Apache Software Foundation:
> member, Syncope PMC chair, Cocoon PMC, Olingo PMC
> http://people.apache.org/~ilgrosso/


Re: Clean project install syncope 1.2.5 not working

Posted by Francesco Chicchiriccò <il...@apache.org>.
Hi Ralph,
I confirm what Marco said below: barely decompressing your own

apache-tomcat-7.0.64.tar.gz

from

https://www.dropbox.com/sh/u13p574i58frrc8/AACh0uvxuy268doqvoRU7Zxha?dl=0

and starting, everything works (naturally Syncope complains about some 
paths it could not find, but this is a consequence of not using -Dconf* 
params when building, as suggested).

I did this on my laptop, Kubuntu 15.04 with latest MySQL 5.6 from 
standard packages and no special configuration.

A couple of questions to you:

  1. did you make any special configuration for MySQL (like as 
lower_case_table_names [1] or InnoDB)?
  2. can you try to build your own project on a different machine?

Regards.

[1] 
http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_lower_case_table_names

On 08/10/2015 18:49, Ralph de Boom wrote:
> A followup, yes, embedded mode works.
>
> But with mysql 5.6, the target aimed database we're running on, it's 
> not working.
>
> Running on java 7 or 8 doesn't make a difference at all.
>
> On 08-Oct-15 18:41, Ralph de Boom wrote:
>> Before running tomcat, delete the database and recreate it.
>>
>> I've been doing this for the past 2 days now...
>>
>> Where should core.log, core-rest.log, console.log be generated? I 
>> can't find them...
>>
>> Cheers again.
>>
>> On 08-Oct-15 18:27, Marco Di Sabatino Di Diodoro wrote:
>>> Hi Ralph,
>>>
>>> I used your Apache Tomcat with the deployed wars and it works. 
>>> After, I runned your src in embedded mode and it works properly.
>>> In your uploaded files I can't find syncope logs (core.log, 
>>> core-rest.log, console.log ...).
>>>
>>> Before running tomcat, delete the database and recreate it.
>>>
>>> Marco
>>>
>>>
>>> Il 08/10/2015 14:28, PhoenixtheII ha scritto:
>>>> I added mysqlquery.log to the same dropbox link. It seems that the syncope
>>>> tables are never queried if the exists by openjpa. But for the activity
>>>> tables it does do that, and finds out it needs to make them.
>>>>
>>>> --
>>>> View this message in context:http://syncope-user.1051894.n5.nabble.com/Clean-project-install-syncope-1-2-5-not-working-tp5708144p5708150.html
>>>> Sent from the syncope-user mailing list archive at Nabble.com.

-- 
Francesco Chicchiriccò

Tirasa - Open Source Excellence
http://www.tirasa.net/

Involved at The Apache Software Foundation:
member, Syncope PMC chair, Cocoon PMC, Olingo PMC
http://people.apache.org/~ilgrosso/


Re: Clean project install syncope 1.2.5 not working

Posted by Ralph de Boom <ra...@finalist.com>.
A followup, yes, embedded mode works.

But with mysql 5.6, the target aimed database we're running on, it's not
working.

Running on java 7 or 8 doesn't make a difference at all.

On 08-Oct-15 18:41, Ralph de Boom wrote:
> Before running tomcat, delete the database and recreate it.
>
> I've been doing this for the past 2 days now...
>
> Where should core.log, core-rest.log, console.log be generated? I
> can't find them...
>
> Cheers again.
>
> On 08-Oct-15 18:27, Marco Di Sabatino Di Diodoro wrote:
>> Hi Ralph,
>>
>> I used your Apache Tomcat with the deployed wars and it works. After,
>> I runned your src in embedded mode and it works properly.
>> In your uploaded files I can't find syncope logs (core.log,
>> core-rest.log, console.log ...).
>>
>> Before running tomcat, delete the database and recreate it.
>>
>> Marco
>>     
>>
>> Il 08/10/2015 14:28, PhoenixtheII ha scritto:
>>> I added mysqlquery.log to the same dropbox link. It seems that the syncope
>>> tables are never queried if the exists by openjpa. But for the activity
>>> tables it does do that, and finds out it needs to make them.
>>>
>>> --
>>> View this message in context: http://syncope-user.1051894.n5.nabble.com/Clean-project-install-syncope-1-2-5-not-working-tp5708144p5708150.html
>>> Sent from the syncope-user mailing list archive at Nabble.com.
>>
>> -- 
>> Dott. Marco Di Sabatino Di Diodoro
>> Tel. +39 3939065570
>>
>> Tirasa S.r.l.
>> Viale D'Annunzio 267 - 65127 Pescara
>> Tel +39 0859116307 / FAX +39 0859111173
>> http://www.tirasa.net
>>
>> Apache Syncope PMC Member
>> http://people.apache.org/~mdisabatino/
>


Re: Clean project install syncope 1.2.5 not working

Posted by Ralph de Boom <ra...@finalist.com>.
Before running tomcat, delete the database and recreate it.

I've been doing this for the past 2 days now...

Where should core.log, core-rest.log, console.log be generated? I can't
find them...

Cheers again.

On 08-Oct-15 18:27, Marco Di Sabatino Di Diodoro wrote:
> Hi Ralph,
>
> I used your Apache Tomcat with the deployed wars and it works. After,
> I runned your src in embedded mode and it works properly.
> In your uploaded files I can't find syncope logs (core.log,
> core-rest.log, console.log ...).
>
> Before running tomcat, delete the database and recreate it.
>
> Marco
>     
>
> Il 08/10/2015 14:28, PhoenixtheII ha scritto:
>> I added mysqlquery.log to the same dropbox link. It seems that the syncope
>> tables are never queried if the exists by openjpa. But for the activity
>> tables it does do that, and finds out it needs to make them.
>>
>> --
>> View this message in context: http://syncope-user.1051894.n5.nabble.com/Clean-project-install-syncope-1-2-5-not-working-tp5708144p5708150.html
>> Sent from the syncope-user mailing list archive at Nabble.com.
>
> -- 
> Dott. Marco Di Sabatino Di Diodoro
> Tel. +39 3939065570
>
> Tirasa S.r.l.
> Viale D'Annunzio 267 - 65127 Pescara
> Tel +39 0859116307 / FAX +39 0859111173
> http://www.tirasa.net
>
> Apache Syncope PMC Member
> http://people.apache.org/~mdisabatino/


Re: Clean project install syncope 1.2.5 not working

Posted by Marco Di Sabatino Di Diodoro <ma...@tirasa.net>.
Hi Ralph,

I used your Apache Tomcat with the deployed wars and it works. After, I 
runned your src in embedded mode and it works properly.
In your uploaded files I can't find syncope logs (core.log, 
core-rest.log, console.log ...).

Before running tomcat, delete the database and recreate it.

Marco


Il 08/10/2015 14:28, PhoenixtheII ha scritto:
> I added mysqlquery.log to the same dropbox link. It seems that the syncope
> tables are never queried if the exists by openjpa. But for the activity
> tables it does do that, and finds out it needs to make them.
>
> --
> View this message in context: http://syncope-user.1051894.n5.nabble.com/Clean-project-install-syncope-1-2-5-not-working-tp5708144p5708150.html
> Sent from the syncope-user mailing list archive at Nabble.com.

-- 
Dott. Marco Di Sabatino Di Diodoro
Tel. +39 3939065570

Tirasa S.r.l.
Viale D'Annunzio 267 - 65127 Pescara
Tel +39 0859116307 / FAX +39 0859111173
http://www.tirasa.net

Apache Syncope PMC Member
http://people.apache.org/~mdisabatino/


Re: Clean project install syncope 1.2.5 not working

Posted by PhoenixtheII <ra...@finalist.com>.
I added mysqlquery.log to the same dropbox link. It seems that the syncope
tables are never queried if the exists by openjpa. But for the activity
tables it does do that, and finds out it needs to make them.

--
View this message in context: http://syncope-user.1051894.n5.nabble.com/Clean-project-install-syncope-1-2-5-not-working-tp5708144p5708150.html
Sent from the syncope-user mailing list archive at Nabble.com.

Re: Clean project install syncope 1.2.5 not working

Posted by PhoenixtheII <ra...@finalist.com>.
https://www.dropbox.com/sh/u13p574i58frrc8/AACh0uvxuy268doqvoRU7Zxha?dl=0

This is all the logs tomcat generates.

Included are the apache tomcat directory totally and the maven project src.

.wars were generated with mvn clean package

Yes, without the -D bundles/logs/conf properties additions to /opt/syncope,
because that would give me a different error. (Something with "audit/null"). 

Thanks for the time in advance ;)


--
View this message in context: http://syncope-user.1051894.n5.nabble.com/Clean-project-install-syncope-1-2-5-not-working-tp5708144p5708149.html
Sent from the syncope-user mailing list archive at Nabble.com.

Re: Clean project install syncope 1.2.5 not working

Posted by Francesco Chicchiriccò <il...@apache.org>.
On 07/10/2015 17:35, PhoenixtheII wrote:
> My context.xml:
> [...]

If driver, username, password and JDBC URL are consistent with 
persistence.properties, the reason should be somewhere else.

Please stop Tomcat, remove all tables from database, clean up all log 
files and start again; then post the complete stacktraces you might find 
in all logs (catalina.out, core.log, core-persistence.log in particular) 
somewhere so that I can take a look.

Regards.

-- 
Francesco Chicchiriccò

Tirasa - Open Source Excellence
http://www.tirasa.net/

Involved at The Apache Software Foundation:
member, Syncope PMC chair, Cocoon PMC, Olingo PMC
http://people.apache.org/~ilgrosso/


Re: Clean project install syncope 1.2.5 not working

Posted by PhoenixtheII <ra...@finalist.com>.
My context.xml:

<?xml version='1.0' encoding='utf-8'?>


<Context>

    
    <WatchedResource>WEB-INF/web.xml</WatchedResource>

    
    <Manager pathname=""/>

    <Resource name="jdbc/syncopeDataSource" 
              auth="Container" 
              type="javax.sql.DataSource"
              factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" 
              testWhileIdle="true"
              testOnBorrow="true"
              testOnReturn="true" 
              validationQuery="SELECT 1" 
              validationInterval="30000"
              maxActive="100"
              minIdle="2" 
              maxWait="10000" 
              initialSize="2" 
              removeAbandonedTimeout="20000"
              removeAbandoned="true" 
              logAbandoned="true"
              suspectTimeout="20000"
              timeBetweenEvictionRunsMillis="5000"
              minEvictableIdleTimeMillis="5000"
             
jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer"
              username="syncope" 
              password="syncope" 
              driverClassName="com.mysql.jdbc.Driver"
             
url="jdbc:mysql://localhost:3306/syncope?characterEncoding=UTF-8"/>

    
    

</Context>


--------------------



My persistence props:

jpa.driverClassName=com.mysql.jdbc.Driver
jpa.url=jdbc:mysql://localhost:3306/syncope?characterEncoding=UTF-8
jpa.username=syncope
jpa.password=syncope
jpa.dialect=org.apache.openjpa.jdbc.sql.MySQLDictionary
jpa.pool.validationQuery=SELECT 1
#note: other connection pool settings can also be configured here, see
persistenceContext.xml
quartz.jobstore=org.quartz.impl.jdbcjobstore.StdJDBCDelegate
quartz.sql=tables_mysql_innodb.sql
audit.sql=audit_mysql_innodb.sql
database.schema=


--
View this message in context: http://syncope-user.1051894.n5.nabble.com/Clean-project-install-syncope-1-2-5-not-working-tp5708144p5708146.html
Sent from the syncope-user mailing list archive at Nabble.com.

Re: Clean project install syncope 1.2.5 not working

Posted by Francesco Chicchiriccò <il...@apache.org>.
Hi,
it seems that there is some difference between the database coordinates 
defined in

core/src/main/resources/persistence.properties

and the datasource defined in Tomcat under

$CATALINA_HOME/conf/context.xml

It seems that the former is working (because all the non-JPA tables are 
being created) while the latter is not working (because of the JPA error 
reported below).

Please check.
Regards.

On 07/10/2015 17:22, Ralph de Boom wrote:
> Hi!
>
> I followed:
>
> https://cwiki.apache.org/confluence/display/SYNCOPE/Create+a+new+Syncope+project
>
> and
>
> https://cwiki.apache.org/confluence/display/SYNCOPE/Run+Syncope+in+real+environments
>
> Using:
>
> -Ubuntu 14.04
> -Oracle JDK 7
> -Tomcat 7.0.64
> -Mysql 5.6
>
> After using mvn clean package, i copy the 2 generated war files to 
> webapps/.
> Then I start tomcat by running ./catalina.sh run in the bin/ folder.
>
> This results into:
>
> SEVERE: Exception sending context initialized event to listener 
> instance of class org.springframework.web.context.ContextLoaderListener
> org.springframework.beans.factory.BeanCreationException: Error 
> creating bean with name 'springContextInitializer' defined in file 
> [/home/ralph/opt/apache-tomcat-7.0.64/apache-tomcat-7.0.64/webapps/syncope/WEB-INF/classes/org/apache/syncope/core/init/SpringContextInitializer.class]: 
> Invocation of init method failed; nested exception is 
> <openjpa-2.3.0-r422266:1540826 fatal user error> 
> org.apache.openjpa.persistence.ArgumentException: Errors encountered 
> while resolving metadata.  See nested exceptions for details.
>         at 
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1554) 
>
>         at 
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539) 
>
>         at 
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475) 
>
>         at 
> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:302) 
>
>         at 
> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:229) 
>
>         at 
> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:298) 
>
>         at 
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193) 
>
>         at 
> org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:706) 
>
>         at 
> org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:762) 
>
>         at 
> org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482) 
>
>         at 
> org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:403) 
>
>         at 
> org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306) 
>
>         at 
> org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106) 
>
>         at 
> org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5003) 
>
>         at 
> org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5517) 
>
>         at 
> org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
>         at 
> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) 
>
>         at 
> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
>         at 
> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)
>         at 
> org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1095)
>         at 
> org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1930) 
>
>         at 
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
>         at java.util.concurrent.FutureTask.run(FutureTask.java:262)
>         at 
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) 
>
>         at 
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) 
>
>         at java.lang.Thread.run(Thread.java:745)
> Caused by: <openjpa-2.3.0-r422266:1540826 fatal user error> 
> org.apache.openjpa.persistence.ArgumentException: Errors encountered 
> while resolving metadata.  See nested exceptions for details.
>         at 
> org.apache.openjpa.meta.MetaDataRepository.resolve(MetaDataRepository.java:675) 
>
>         at 
> org.apache.openjpa.meta.MetaDataRepository.getMetaDataInternal(MetaDataRepository.java:418) 
>
>         at 
> org.apache.openjpa.meta.MetaDataRepository.getMetaData(MetaDataRepository.java:389) 
>
>         at 
> org.apache.openjpa.meta.MetaDataRepository.getMetaData(MetaDataRepository.java:472) 
>
>         at 
> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getClassMetaData(JPQLExpressionBuilder.java:176) 
>
>         at 
> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.resolveClassMetaData(JPQLExpressionBuilder.java:152) 
>
>         at 
> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateMetaData(JPQLExpressionBuilder.java:242) 
>
>         at 
> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateMetaData(JPQLExpressionBuilder.java:212) 
>
>         at 
> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getCandidateType(JPQLExpressionBuilder.java:205) 
>
>         at 
> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.access$200(JPQLExpressionBuilder.java:80) 
>
>         at 
> org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder$ParsedJPQL.populate(JPQLExpressionBuilder.java:2428) 
>
>         at 
> org.apache.openjpa.kernel.jpql.JPQLParser.populate(JPQLParser.java:61)
>         at 
> org.apache.openjpa.kernel.ExpressionStoreQuery.populateFromCompilation(ExpressionStoreQuery.java:162) 
>
>         at 
> org.apache.openjpa.datacache.QueryCacheStoreQuery.populateFromCompilation(QueryCacheStoreQuery.java:268) 
>
>         at 
> org.apache.openjpa.kernel.QueryImpl.newCompilation(QueryImpl.java:673)
>         at 
> org.apache.openjpa.kernel.QueryImpl.compilationFromCache(QueryImpl.java:654) 
>
>         at 
> org.apache.openjpa.kernel.QueryImpl.compileForCompilation(QueryImpl.java:620) 
>
>         at 
> org.apache.openjpa.kernel.QueryImpl.compileForExecutor(QueryImpl.java:682) 
>
>         at 
> org.apache.openjpa.kernel.QueryImpl.compile(QueryImpl.java:589)
>         at 
> org.apache.openjpa.persistence.EntityManagerImpl.createQuery(EntityManagerImpl.java:997) 
>
>         at 
> org.apache.openjpa.persistence.EntityManagerImpl.createQuery(EntityManagerImpl.java:979) 
>
>         at 
> org.apache.openjpa.persistence.EntityManagerImpl.createQuery(EntityManagerImpl.java:975) 
>
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 
>
>         at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
>
>         at java.lang.reflect.Method.invoke(Method.java:606)
>         at 
> org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:291) 
>
>         at com.sun.proxy.$Proxy43.createQuery(Unknown Source)
>         at 
> org.apache.syncope.core.persistence.dao.impl.ResourceDAOImpl.findAll(ResourceDAOImpl.java:125) 
>
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 
>
>         at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
>
>         at java.lang.reflect.Method.invoke(Method.java:606)
>         at 
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) 
>
>         at 
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201) 
>
>         at com.sun.proxy.$Proxy45.findAll(Unknown Source)
>         at 
> org.apache.syncope.core.init.ConnectorManager.load(ConnectorManager.java:118) 
>
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 
>
>         at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
>
>         at java.lang.reflect.Method.invoke(Method.java:606)
>         at 
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) 
>
>         at 
> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) 
>
>         at 
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) 
>
>         at 
> org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98) 
>
>         at 
> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:262) 
>
>         at 
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95) 
>
>         at 
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) 
>
>         at 
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) 
>
>         at com.sun.proxy.$Proxy47.load(Unknown Source)
>         at 
> org.apache.syncope.core.init.SpringContextInitializer.afterPropertiesSet(SpringContextInitializer.java:57) 
>
>         at 
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1613) 
>
>         at 
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1550) 
>
>         ... 25 more
> Caused by: <openjpa-2.3.0-r422266:1540826 fatal user error> 
> org.apache.openjpa.persistence.ArgumentException: Table 
> "ExternalResource" given for 
> "org.apache.syncope.core.persistence.beans.ExternalResource" does not 
> exist.
>         at 
> org.apache.openjpa.jdbc.meta.MappingInfo.createTable(MappingInfo.java:532) 
>
>         at 
> org.apache.openjpa.jdbc.meta.ClassMappingInfo.getTable(ClassMappingInfo.java:309) 
>
>         at 
> org.apache.openjpa.jdbc.meta.ClassMappingInfo.getTable(ClassMappingInfo.java:331) 
>
>         at 
> org.apache.openjpa.jdbc.meta.strats.FullClassStrategy.map(FullClassStrategy.java:73) 
>
>         at 
> org.apache.openjpa.jdbc.meta.ClassMapping.setStrategy(ClassMapping.java:392) 
>
>         at 
> org.apache.openjpa.jdbc.meta.RuntimeStrategyInstaller.installStrategy(RuntimeStrategyInstaller.java:56) 
>
>         at 
> org.apache.openjpa.jdbc.meta.MappingRepository.prepareMapping(MappingRepository.java:410) 
>
>         at 
> org.apache.openjpa.meta.MetaDataRepository.preMapping(MetaDataRepository.java:769) 
>
>         at 
> org.apache.openjpa.meta.MetaDataRepository.resolve(MetaDataRepository.java:658) 
>
>         ... 77 more
>
> If I look in the mysql database. These tables have been generated:
>
> ACT_EVT_LOG
> ACT_GE_BYTEARRAY
> ACT_GE_PROPERTY
> ACT_HI_ACTINST
> ACT_HI_ATTACHMENT
> ACT_HI_COMMENT
> ACT_HI_DETAIL
> ACT_HI_IDENTITYLINK
> ACT_HI_PROCINST
> ACT_HI_TASKINST
> ACT_HI_VARINST
> ACT_ID_GROUP
> ACT_ID_INFO
> ACT_ID_MEMBERSHIP
> ACT_ID_USER
> ACT_RE_DEPLOYMENT
> ACT_RE_MODEL
> ACT_RE_PROCDEF
> ACT_RU_EVENT_SUBSCR
> ACT_RU_EXECUTION
> ACT_RU_IDENTITYLINK
> ACT_RU_JOB
> ACT_RU_TASK
> ACT_RU_VARIABLE
> QRTZ_CRON_TRIGGERS
> QRTZ_FIRED_TRIGGERS
> QRTZ_LOCKS
> QRTZ_PAUSED_TRIGGER_GRPS
> QRTZ_SCHEDULER_STATE
> QRTZ_SIMPLE_TRIGGERS
> SYNCOPEAUDIT
>
> I think syncope is failing somewhere to make more tables it needs.
>
> The documentation doesn't provide any answer to this.
>
> Cheers,
> Ralph


-- 
Francesco Chicchiriccò

Tirasa - Open Source Excellence
http://www.tirasa.net/

Involved at The Apache Software Foundation:
member, Syncope PMC chair, Cocoon PMC, Olingo PMC
http://people.apache.org/~ilgrosso/