[
https://issues.apache.org/jira/browse/MRM-1881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sorin Sbarnea updated MRM-1881:
-------------------------------
Description:
It seems that support for PostgreSQL is broken and mostly undocumented.
There a few things that need to be addressed:
* Include PostgreSQL ODBC driver in the build, no need to keep it outside only
to make the installation harder.
* Include commented out PostreSQL database configuration inside
/conf/jetty.conf including
{noformat}
<New id="users" class="org.eclipse.jetty.plus.jndi.Resource">
<Arg>jdbc/users</Arg>
<Arg>
<New class="org.apache.tomcat.jdbc.pool.DataSource">
<Set name="driverClassName">org.postgresql.Driver</Set>
<Set name="url">jdbc:postgresql://localhost/archiva</Set>
<Set name="name">ArchivaApp</Set>
<Set name="username">archiva</Set>
<Set name="password">archivasecret</Set>
<!-- depends on your concurrent users numbers -->
<Set name="maxWait">10000</Set>
<Set name="removeAbandonedTimeout">10000</Set>
<Set name="maxActive">30</Set>
<Set name="initialSize">15</Set>
<Set name="removeAbandoned">true</Set>
<Set name="logAbandoned">true</Set>
<Set name="testOnBorrow">true</Set>
<!-- very rigourous sql query validation -->
<Set name="validationQuery">select 1</Set>
<Set name="testOnReturn">false</Set>
<!--<Set name="defaultTransactionIsolation">READ_COMMITTED</Set>-->
</New>
</Arg>
</New>
{noformat}
Also even with these changes being made it seems that Archiva is not properly
initialized. The database tables are created with the default admin account but
we cannot validate the admin account (email confirmation fails). We will attach
the logs.
Here are few excerpts from the logs:
{noformat}
INFO | jvm 1 | 2015/04/07 17:34:15 | 2015-04-07
17:34:15.209:WARN:oejw.WebAppContext:Failed startup of context
o.e.j.w.WebAppContext{/,file:/opt/archiva/apps/archiva/},/opt/archiva/apps/archiva
INFO | jvm 1 | 2015/04/07 17:34:15 |
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'archivaServices': Cannot resolve reference to bean
'authenticationInterceptor
INFO | jvm 1 | 2015/04/07 17:34:15 | at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:359)
INFO | jvm 1 | 2015/04/07 17:34:15 | at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
INFO | jvm 1 | 2015/04/07 17:34:15 | at
java.lang.Thread.run(Thread.java:745)
INFO | jvm 1 | 2015/04/07 17:34:15 | Caused by:
INFO | jvm 1 | 2015/04/07 17:34:15 |
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'authenticationInterceptor#rest': Injection of autowired dependencies
failed;
INFO | jvm 1 | 2015/04/07 17:34:15 | at
org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:334)
2015-04-07 17:34:13,313 [WrapperSimpleAppMain] INFO
org.apache.archiva.web.security.ArchivaRbacManager [] - use rbacManagerIds:
'[jdo]'
2015-04-07 17:34:13,452 [WrapperSimpleAppMain] WARN JPOX.Plugin [] - Extension
Point "org.eclipse.jdt.apt.core.annotationProcessorFactory" not registered, but
plugin "" defined in jar:file:/opt/archiva/apps
/archiva/WEB-INF/lib/org.eclipse.sisu.inject-0.0.0.M2a.jar!/plugin.xml refers
to it.
2015-04-07 17:34:13,471 [WrapperSimpleAppMain] WARN JPOX.Plugin [] - Extension
Point "org.eclipse.jdt.apt.core.annotationProcessorFactory" not registered, but
plugin "" defined in jar:file:/opt/archiva/apps
/archiva/WEB-INF/lib/org.eclipse.sisu.inject-0.0.0.M2a.jar!/plugin.xml refers
to it.
2015-04-07 17:34:13,660 [WrapperSimpleAppMain] INFO
org.apache.archiva.redback.role.DefaultRoleManager [] - loading System
2015-04-07 17:34:14,867 [WrapperSimpleAppMain] INFO
org.apache.archiva.redback.role.processor.DefaultRoleModelProcessor [] - time
to process roles model: 191 ms
2015-04-07 17:34:14,873 [WrapperSimpleAppMain] INFO
org.apache.archiva.redback.role.DefaultRoleManager [] - loading Archiva
2015-04-07 17:34:15,129 [WrapperSimpleAppMain] INFO
org.apache.archiva.redback.role.processor.DefaultRoleModelProcessor [] - time
to process roles model: 156 ms
2015-04-07 17:34:15,130 [WrapperSimpleAppMain] INFO
org.apache.archiva.redback.role.DefaultRoleManager [] - DefaultRoleManager
initialize time 1527
2015-04-07 17:34:15,165 [WrapperSimpleAppMain] WARN
org.springframework.web.context.support.XmlWebApplicationContext [] - Exception
encountered during context initialization - cancelling refresh attempt
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'archivaServices': Cannot resolve reference to bean
'authenticationInterceptor#rest' while setting bean property 'provid
ers' with key [1]; nested exception is
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'authenticationInterceptor#rest': Injection of autowired dependencies
failed; nes
ted exception is org.springframework.beans.factory.BeanCreationException: Could
not autowire field: private org.apache.archiva.redback.users.UserManager
org.apache.archiva.redback.rest.services.interceptors.
AuthenticationInterceptor.userManager; nested exception is
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'userManager#archiva': Injection of autowired dependencies fa
iled; nested exception is
org.springframework.beans.factory.BeanCreationException: Could not autowire
field: private
org.apache.archiva.admin.model.runtime.RedbackRuntimeConfigurationAdmin
org.apache.archiva
.web.security.ArchivaConfigurableUsersManager.redbackRuntimeConfigurationAdmin;
nested exception is org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'redbackRuntimeConfi
gurationAdmin#default': Injection of autowired dependencies failed; nested
exception is org.springframework.beans.factory.BeanCreationException: Could not
autowire field: private java.util.List org.apache.ar
chiva.admin.repository.AbstractRepositoryAdmin.auditListeners; nested exception
is org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'auditListener#metadata': Injection o
f autowired dependencies failed; nested exception is
org.springframework.beans.factory.BeanCreationException: Could not autowire
field: private org.apache.archiva.metadata.repository.RepositorySessionFactory
org.apache.archiva.audit.MetadataAuditListener.repositorySessionFactory;
nested exception is org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'repositorySessionFactory#
jcr': Injection of autowired dependencies failed; nested exception is
org.springframework.beans.factory.BeanCreationException: Could not autowire
field: private org.apache.archiva.metadata.repository.Metadat
aResolver
org.apache.archiva.metadata.repository.jcr.JcrRepositorySessionFactory.metadataResolver;
nested exception is org.springframework.beans.factory.BeanCreationException:
Error creating bean with name '
metadataResolver#default': Injection of autowired dependencies failed; nested
exception is org.springframework.beans.factory.BeanCreationException: Could not
autowire field: private org.apache.archiva.metada
ta.repository.storage.RepositoryStorage
org.apache.archiva.metadata.repository.DefaultMetadataResolver.repositoryStorage;
nested exception is org.springframework.beans.factory.BeanCreationException:
Error cr
eating bean with name 'repositoryStorage#maven2': Injection of autowired
dependencies failed; nested exception is
org.springframework.beans.factory.BeanCreationException: Could not autowire
field: private or
g.apache.archiva.admin.model.managed.ManagedRepositoryAdmin
org.apache.archiva.metadata.repository.storage.maven2.Maven2RepositoryStorage.managedRepositoryAdmin;
nested exception is org.springframework.beans
.factory.BeanCreationException: Error creating bean with name
'managedRepositoryAdmin#default': Invocation of init method failed; nested
exception is org.apache.archiva.admin.model.RepositoryAdminException:
Cannot forcefully unlock a NativeFSLock which is held by another indexer
component:
/opt/archiva/repositories/repositories/snapshots/repositories/snapshots/.indexer/write.lock
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:359)
~[spring-beans-4.1.4.RELEASE.jar:4.1.4.RELEASE]
{noformat}
was:
It seems that support for PostgreSQL is broken and mostly undocumented.
There a few things that need to be addressed:
* Include PostgreSQL ODBC driver in the build, no need to keep it outside only
to make the installation harder.
* Include commented out PostreSQL database configuration inside
/conf/jetty.conf including
{noformat}
<New id="users" class="org.eclipse.jetty.plus.jndi.Resource">
<Arg>jdbc/users</Arg>
<Arg>
<New class="org.apache.tomcat.jdbc.pool.DataSource">
<Set name="driverClassName">org.postgresql.Driver</Set>
<Set name="url">jdbc:postgresql://localhost/archiva</Set>
<Set name="name">ArchivaApp</Set>
<Set name="username">archiva</Set>
<Set name="password">archivasecret</Set>
<!-- depends on your concurrent users numbers -->
<Set name="maxWait">10000</Set>
<Set name="removeAbandonedTimeout">10000</Set>
<Set name="maxActive">30</Set>
<Set name="initialSize">15</Set>
<Set name="removeAbandoned">true</Set>
<Set name="logAbandoned">true</Set>
<Set name="testOnBorrow">true</Set>
<!-- very rigourous sql query validation -->
<Set name="validationQuery">select 1</Set>
<Set name="testOnReturn">false</Set>
<!--<Set name="defaultTransactionIsolation">READ_COMMITTED</Set>-->
</New>
</Arg>
</New>
{noformat}
Also even with these changes being made it seems that Archiva is not properly
initialized. The database tables are created with the default admin account but
we cannot validate the admin account (email confirmation fails). We will attach
the logs.
> Release 2.2.0 does not work with PostgreSQL
> -------------------------------------------
>
> Key: MRM-1881
> URL: https://issues.apache.org/jira/browse/MRM-1881
> Project: Archiva
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 2.2.0
> Environment: oracle-java-1.8, ubuntu-12.04-lts
> Reporter: Sorin Sbarnea
> Priority: Critical
> Labels: postgresql
> Attachments: logs.tar.gz
>
>
> It seems that support for PostgreSQL is broken and mostly undocumented.
> There a few things that need to be addressed:
> * Include PostgreSQL ODBC driver in the build, no need to keep it outside
> only to make the installation harder.
> * Include commented out PostreSQL database configuration inside
> /conf/jetty.conf including
> {noformat}
> <New id="users" class="org.eclipse.jetty.plus.jndi.Resource">
> <Arg>jdbc/users</Arg>
> <Arg>
> <New class="org.apache.tomcat.jdbc.pool.DataSource">
> <Set name="driverClassName">org.postgresql.Driver</Set>
> <Set name="url">jdbc:postgresql://localhost/archiva</Set>
> <Set name="name">ArchivaApp</Set>
> <Set name="username">archiva</Set>
> <Set name="password">archivasecret</Set>
> <!-- depends on your concurrent users numbers -->
> <Set name="maxWait">10000</Set>
> <Set name="removeAbandonedTimeout">10000</Set>
> <Set name="maxActive">30</Set>
> <Set name="initialSize">15</Set>
> <Set name="removeAbandoned">true</Set>
> <Set name="logAbandoned">true</Set>
> <Set name="testOnBorrow">true</Set>
> <!-- very rigourous sql query validation -->
> <Set name="validationQuery">select 1</Set>
> <Set name="testOnReturn">false</Set>
> <!--<Set name="defaultTransactionIsolation">READ_COMMITTED</Set>-->
> </New>
> </Arg>
> </New>
> {noformat}
> Also even with these changes being made it seems that Archiva is not properly
> initialized. The database tables are created with the default admin account
> but we cannot validate the admin account (email confirmation fails). We will
> attach the logs.
> Here are few excerpts from the logs:
> {noformat}
> INFO | jvm 1 | 2015/04/07 17:34:15 | 2015-04-07
> 17:34:15.209:WARN:oejw.WebAppContext:Failed startup of context
> o.e.j.w.WebAppContext{/,file:/opt/archiva/apps/archiva/},/opt/archiva/apps/archiva
> INFO | jvm 1 | 2015/04/07 17:34:15 |
> org.springframework.beans.factory.BeanCreationException: Error creating bean
> with name 'archivaServices': Cannot resolve reference to bean
> 'authenticationInterceptor
> INFO | jvm 1 | 2015/04/07 17:34:15 | at
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:359)
> INFO | jvm 1 | 2015/04/07 17:34:15 | at
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
> INFO | jvm 1 | 2015/04/07 17:34:15 | at
> java.lang.Thread.run(Thread.java:745)
> INFO | jvm 1 | 2015/04/07 17:34:15 | Caused by:
> INFO | jvm 1 | 2015/04/07 17:34:15 |
> org.springframework.beans.factory.BeanCreationException: Error creating bean
> with name 'authenticationInterceptor#rest': Injection of autowired
> dependencies failed;
> INFO | jvm 1 | 2015/04/07 17:34:15 | at
> org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:334)
> 2015-04-07 17:34:13,313 [WrapperSimpleAppMain] INFO
> org.apache.archiva.web.security.ArchivaRbacManager [] - use rbacManagerIds:
> '[jdo]'
> 2015-04-07 17:34:13,452 [WrapperSimpleAppMain] WARN JPOX.Plugin [] -
> Extension Point "org.eclipse.jdt.apt.core.annotationProcessorFactory" not
> registered, but plugin "" defined in jar:file:/opt/archiva/apps
> /archiva/WEB-INF/lib/org.eclipse.sisu.inject-0.0.0.M2a.jar!/plugin.xml refers
> to it.
> 2015-04-07 17:34:13,471 [WrapperSimpleAppMain] WARN JPOX.Plugin [] -
> Extension Point "org.eclipse.jdt.apt.core.annotationProcessorFactory" not
> registered, but plugin "" defined in jar:file:/opt/archiva/apps
> /archiva/WEB-INF/lib/org.eclipse.sisu.inject-0.0.0.M2a.jar!/plugin.xml refers
> to it.
> 2015-04-07 17:34:13,660 [WrapperSimpleAppMain] INFO
> org.apache.archiva.redback.role.DefaultRoleManager [] - loading System
> 2015-04-07 17:34:14,867 [WrapperSimpleAppMain] INFO
> org.apache.archiva.redback.role.processor.DefaultRoleModelProcessor [] - time
> to process roles model: 191 ms
> 2015-04-07 17:34:14,873 [WrapperSimpleAppMain] INFO
> org.apache.archiva.redback.role.DefaultRoleManager [] - loading Archiva
> 2015-04-07 17:34:15,129 [WrapperSimpleAppMain] INFO
> org.apache.archiva.redback.role.processor.DefaultRoleModelProcessor [] - time
> to process roles model: 156 ms
> 2015-04-07 17:34:15,130 [WrapperSimpleAppMain] INFO
> org.apache.archiva.redback.role.DefaultRoleManager [] - DefaultRoleManager
> initialize time 1527
> 2015-04-07 17:34:15,165 [WrapperSimpleAppMain] WARN
> org.springframework.web.context.support.XmlWebApplicationContext [] -
> Exception encountered during context initialization - cancelling refresh
> attempt
> org.springframework.beans.factory.BeanCreationException: Error creating bean
> with name 'archivaServices': Cannot resolve reference to bean
> 'authenticationInterceptor#rest' while setting bean property 'provid
> ers' with key [1]; nested exception is
> org.springframework.beans.factory.BeanCreationException: Error creating bean
> with name 'authenticationInterceptor#rest': Injection of autowired
> dependencies failed; nes
> ted exception is org.springframework.beans.factory.BeanCreationException:
> Could not autowire field: private
> org.apache.archiva.redback.users.UserManager
> org.apache.archiva.redback.rest.services.interceptors.
> AuthenticationInterceptor.userManager; nested exception is
> org.springframework.beans.factory.BeanCreationException: Error creating bean
> with name 'userManager#archiva': Injection of autowired dependencies fa
> iled; nested exception is
> org.springframework.beans.factory.BeanCreationException: Could not autowire
> field: private
> org.apache.archiva.admin.model.runtime.RedbackRuntimeConfigurationAdmin
> org.apache.archiva
> .web.security.ArchivaConfigurableUsersManager.redbackRuntimeConfigurationAdmin;
> nested exception is org.springframework.beans.factory.BeanCreationException:
> Error creating bean with name 'redbackRuntimeConfi
> gurationAdmin#default': Injection of autowired dependencies failed; nested
> exception is org.springframework.beans.factory.BeanCreationException: Could
> not autowire field: private java.util.List org.apache.ar
> chiva.admin.repository.AbstractRepositoryAdmin.auditListeners; nested
> exception is org.springframework.beans.factory.BeanCreationException: Error
> creating bean with name 'auditListener#metadata': Injection o
> f autowired dependencies failed; nested exception is
> org.springframework.beans.factory.BeanCreationException: Could not autowire
> field: private org.apache.archiva.metadata.repository.RepositorySessionFactory
> org.apache.archiva.audit.MetadataAuditListener.repositorySessionFactory;
> nested exception is org.springframework.beans.factory.BeanCreationException:
> Error creating bean with name 'repositorySessionFactory#
> jcr': Injection of autowired dependencies failed; nested exception is
> org.springframework.beans.factory.BeanCreationException: Could not autowire
> field: private org.apache.archiva.metadata.repository.Metadat
> aResolver
> org.apache.archiva.metadata.repository.jcr.JcrRepositorySessionFactory.metadataResolver;
> nested exception is org.springframework.beans.factory.BeanCreationException:
> Error creating bean with name '
> metadataResolver#default': Injection of autowired dependencies failed; nested
> exception is org.springframework.beans.factory.BeanCreationException: Could
> not autowire field: private org.apache.archiva.metada
> ta.repository.storage.RepositoryStorage
> org.apache.archiva.metadata.repository.DefaultMetadataResolver.repositoryStorage;
> nested exception is org.springframework.beans.factory.BeanCreationException:
> Error cr
> eating bean with name 'repositoryStorage#maven2': Injection of autowired
> dependencies failed; nested exception is
> org.springframework.beans.factory.BeanCreationException: Could not autowire
> field: private or
> g.apache.archiva.admin.model.managed.ManagedRepositoryAdmin
> org.apache.archiva.metadata.repository.storage.maven2.Maven2RepositoryStorage.managedRepositoryAdmin;
> nested exception is org.springframework.beans
> .factory.BeanCreationException: Error creating bean with name
> 'managedRepositoryAdmin#default': Invocation of init method failed; nested
> exception is org.apache.archiva.admin.model.RepositoryAdminException:
> Cannot forcefully unlock a NativeFSLock which is held by another indexer
> component:
> /opt/archiva/repositories/repositories/snapshots/repositories/snapshots/.indexer/write.lock
> at
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:359)
> ~[spring-beans-4.1.4.RELEASE.jar:4.1.4.RELEASE]
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
