Bonjour,
dans le but de voir si squashtm peut répondre à nos besoins, j'essaie de le mettre en place sur l'une de nos machines.
J'ai récupéré squash-tm-1.13.2.RELEASE.tar.gz.
Sur une Debian, un tomcat8 est installé.
J'ai une base postgresql squashtm à disposition.
J'ai juste copié bundles/squash-tm.war dans ~TOMCAT/webapps
A chaud la webapp ne démarre pas.
J'ai stopppé le service tomcat, suivi le guide d'installation pour le déploiement dans tomcat (j'ai d'ailleurs une question concernant le fichier squash-tm.xml qui doit se placer dans ~TOMCAT/conf/[enginename]/[hostname]/... que sont enginename et hostname ?)
Je redémarre le service tomcat, pas mieux, la webapp ne démarre toujours pas et j'ai un tas de warnings et d'erreurs dans les logs du genre :
ERROR [localhost-startStop-1] --- SpringApplication: Application startup failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'embeddedServletContainerCustomizerBeanPostProcessor': BeanPostProcessor before instantiation of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration': BeanPostProcessor before instantiation of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'securityConfig.SquashMethodSecurityConfiguration': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire method: public void org.springframework.security.config.annotation.method.configuration.GlobalMethodSecurityConfiguration.setPermissionEvaluator(java.util.List); nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'securityConfig': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private org.springframework.security.acls.model.ObjectIdentityRetrievalStrategy org.squashtest.tm.service.SecurityConfig.objectIdentityRetrievalStrategy; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'squashtest.core.security.ObjectIdentityRetrievalStrategy': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private org.hibernate.SessionFactory org.squashtest.tm.service.security.acls.domain.InheritableAclsObjectIdentityRetrievalStrategy.sessionFactory; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'repositoryConfig': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private java.lang.String org.squashtest.tm.service.RepositoryConfig.hibernateDialect; nested exception is java.lang.IllegalArgumentException: Could not resolve placeholder 'hibernate.dialect' in string value "${hibernate.dialect}"
Related cause: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'customFieldBindingDao' defined in URL [jar:file:/usr/share/tomcat8/apache-tomcat-8.0.33/webapps/squash-tm/WEB-INF/lib/tm.service-1.13.2.RELEASE.jar!/META-INF/spring/dynamicdao-context.xml]: Cannot resolve reference to bean 'squashtest.tm.persistence.hibernate.SessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'repositoryConfig': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private java.lang.String org.squashtest.tm.service.RepositoryConfig.hibernateDialect; nested exception is java.lang.IllegalArgumentException: Could not resolve placeholder 'hibernate.dialect' in string value "${hibernate.dialect}"
Quelqu'un a-t-il déployé avec succès dans tomcat ?
Toute aide est la bienvenue...
Merci
Rachel
Déploiement de squash-tm.war dans tomcat8
Déploiement de squash-tm.war dans tomcat8
Bonjour,
Depuis la version 1.13, Squash TM embarque un nouveau serveur applicatif, à savoir Tomcat.
Nous vous recommandons donc d'utiliser le Tomcat embarqué qui pourrait vous éviter ce type d'erreur.
Est-ce qu'il existe une raison particulière pour que vous souhaitiez déployer Squash TM dans un autre Tomcat ?
Concernant [enginename] (en général Catalina) et [hostname] (correspond au localhost), les noms peuvent varier selon votre Tomcat. Pour voir à quoi cela correspond, vous pouvez démarrer le Tomcat et voir quels dossiers sont présents dans le dossier de configuration du Tomcat.
Cordialement,
Marion
Depuis la version 1.13, Squash TM embarque un nouveau serveur applicatif, à savoir Tomcat.
Nous vous recommandons donc d'utiliser le Tomcat embarqué qui pourrait vous éviter ce type d'erreur.
Est-ce qu'il existe une raison particulière pour que vous souhaitiez déployer Squash TM dans un autre Tomcat ?
Concernant [enginename] (en général Catalina) et [hostname] (correspond au localhost), les noms peuvent varier selon votre Tomcat. Pour voir à quoi cela correspond, vous pouvez démarrer le Tomcat et voir quels dossiers sont présents dans le dossier de configuration du Tomcat.
Cordialement,
Marion
Déploiement de squash-tm.war dans tomcat8
Bonjour,
merci de votre réponse.
J'aimerais déployer squashtm dans mon tomcat car j'ai déjà des applicatifs qui tournent et pour ne pas dupliquer les tomcat. Comme il y a un squash-tm.war je pensais que c'était fait pour.
Néanmoins, pour tester, j'ai tenté l'installation sur ma debian en suivant l'article "2.02 - Debian/Ubuntu installation"
J'ai laissé la base H2 par défaut, squash-tm s'installe mais ne se lance pas, j'ai les erreurs suivantes : (apparemment pb d'ouverture du fichier squash-tm.mv.db.mv.db, qui n'existe effectivement pas, par contre il y a un fichier squash-tm.mv.db)
Merci de votre aide
org.springframework.transaction.CannotCreateTransactionException: [b]Could not open Hibernate Session[/b] for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Could not open connection
at org.springframework.orm.hibernate4.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:544)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:463)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:276)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
at com.sun.proxy.$Proxy211.getBoolean(Unknown Source)
at org.squashtest.tm.web.internal.listener.SquashConfigContextExposer.exposeMilestoneFeatEnabled(SquashConfigContextExposer.java:70)
at org.squashtest.tm.web.internal.listener.SquashConfigContextExposer.onApplicationEvent(SquashConfigContextExposer.java:97)
at org.squashtest.tm.web.internal.listener.SquashConfigContextExposer.onApplicationEvent(SquashConfigContextExposer.java:1)
at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:151)
at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:128)
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:331)
at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:773)
at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.finishRefresh(EmbeddedWebApplicationContext.java:140)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:483)
at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:118)
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:686)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:320)
at org.squashtest.tm.SquashTm.main(SquashTm.java:55)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:53)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.hibernate.exception.GenericJDBCException: Could not open connection
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:235)
at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:171)
at org.hibernate.internal.SessionImpl.connection(SessionImpl.java:450)
at org.springframework.orm.hibernate4.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:450)
... 26 more
Caused by: org.h2.jdbc.JdbcSQLException: IO Exception: "/var/lib/squash-tm/data/squash-tm.mv.db.mv.db" [90028-187]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:168)
at org.h2.mvstore.db.MVTableEngine.init(MVTableEngine.java:112)
at org.h2.engine.Database.getPageStore(Database.java:2389)
at org.h2.engine.Database.open(Database.java:669)
at org.h2.engine.Database.openDatabase(Database.java:266)
at org.h2.engine.Database.(Database.java:260)
at org.h2.engine.Engine.openSession(Engine.java:60)
at org.h2.engine.Engine.openSession(Engine.java:167)
at org.h2.engine.Engine.createSessionAndValidate(Engine.java:145)
at org.h2.engine.Engine.createSession(Engine.java:128)
at org.h2.engine.Engine.createSession(Engine.java:26)
at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:347)
at org.h2.jdbc.JdbcConnection.(JdbcConnection.java:108)
at org.h2.jdbc.JdbcConnection.(JdbcConnection.java:92)
at org.h2.Driver.connect(Driver.java:72)
at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:307)
at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:200)
at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:699)
at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:633)
at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:484)
at org.apache.tomcat.jdbc.pool.ConnectionPool.(ConnectionPool.java:142)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:115)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:102)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:126)
at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:139)
at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:380)
at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:228)
... 29 more
Caused by: java.lang.IllegalStateException: [b]Could not open file nio:/var/lib/squash-tm/data/squash-tm.mv.db.mv.db[/b] [1.4.187/1]
at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:773)
at org.h2.mvstore.FileStore.open(FileStore.java:178)
at org.h2.mvstore.MVStore.(MVStore.java:337)
at org.h2.mvstore.MVStore$Builder.open(MVStore.java:2782)
at org.h2.mvstore.db.MVTableEngine$Store.(MVTableEngine.java:162)
at org.h2.mvstore.db.MVTableEngine.init(MVTableEngine.java:98)
... 54 more
Caused by: java.io.FileNotFoundException: /var/lib/squash-tm/data/squash-tm.mv.db.mv.db (Permission non accordée)
at java.io.RandomAccessFile.open0(Native Method)
at java.io.RandomAccessFile.open(RandomAccessFile.java:316)
at java.io.RandomAccessFile.(RandomAccessFile.java:243)
at java.io.RandomAccessFile.(RandomAccessFile.java:124)
at org.h2.store.fs.FileNio.(FilePathNio.java:43)
at org.h2.store.fs.FilePathNio.open(FilePathNio.java:23)
at org.h2.mvstore.FileStore.open(FileStore.java:153)
... 58 more
[16-05-18 11:30:28.543] SquashTM - 24999 INFO [main] []--- org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext: Closing org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@1192f99: startup date [Wed May 18 11:29:00 CEST 2016]; root of context hierarchy
merci de votre réponse.
J'aimerais déployer squashtm dans mon tomcat car j'ai déjà des applicatifs qui tournent et pour ne pas dupliquer les tomcat. Comme il y a un squash-tm.war je pensais que c'était fait pour.
Néanmoins, pour tester, j'ai tenté l'installation sur ma debian en suivant l'article "2.02 - Debian/Ubuntu installation"
J'ai laissé la base H2 par défaut, squash-tm s'installe mais ne se lance pas, j'ai les erreurs suivantes : (apparemment pb d'ouverture du fichier squash-tm.mv.db.mv.db, qui n'existe effectivement pas, par contre il y a un fichier squash-tm.mv.db)
Merci de votre aide
org.springframework.transaction.CannotCreateTransactionException: [b]Could not open Hibernate Session[/b] for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Could not open connection
at org.springframework.orm.hibernate4.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:544)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:463)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:276)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
at com.sun.proxy.$Proxy211.getBoolean(Unknown Source)
at org.squashtest.tm.web.internal.listener.SquashConfigContextExposer.exposeMilestoneFeatEnabled(SquashConfigContextExposer.java:70)
at org.squashtest.tm.web.internal.listener.SquashConfigContextExposer.onApplicationEvent(SquashConfigContextExposer.java:97)
at org.squashtest.tm.web.internal.listener.SquashConfigContextExposer.onApplicationEvent(SquashConfigContextExposer.java:1)
at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:151)
at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:128)
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:331)
at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:773)
at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.finishRefresh(EmbeddedWebApplicationContext.java:140)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:483)
at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:118)
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:686)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:320)
at org.squashtest.tm.SquashTm.main(SquashTm.java:55)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:53)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.hibernate.exception.GenericJDBCException: Could not open connection
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:235)
at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:171)
at org.hibernate.internal.SessionImpl.connection(SessionImpl.java:450)
at org.springframework.orm.hibernate4.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:450)
... 26 more
Caused by: org.h2.jdbc.JdbcSQLException: IO Exception: "/var/lib/squash-tm/data/squash-tm.mv.db.mv.db" [90028-187]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:168)
at org.h2.mvstore.db.MVTableEngine.init(MVTableEngine.java:112)
at org.h2.engine.Database.getPageStore(Database.java:2389)
at org.h2.engine.Database.open(Database.java:669)
at org.h2.engine.Database.openDatabase(Database.java:266)
at org.h2.engine.Database.(Database.java:260)
at org.h2.engine.Engine.openSession(Engine.java:60)
at org.h2.engine.Engine.openSession(Engine.java:167)
at org.h2.engine.Engine.createSessionAndValidate(Engine.java:145)
at org.h2.engine.Engine.createSession(Engine.java:128)
at org.h2.engine.Engine.createSession(Engine.java:26)
at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:347)
at org.h2.jdbc.JdbcConnection.(JdbcConnection.java:108)
at org.h2.jdbc.JdbcConnection.(JdbcConnection.java:92)
at org.h2.Driver.connect(Driver.java:72)
at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:307)
at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:200)
at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:699)
at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:633)
at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:484)
at org.apache.tomcat.jdbc.pool.ConnectionPool.(ConnectionPool.java:142)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:115)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:102)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:126)
at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:139)
at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:380)
at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:228)
... 29 more
Caused by: java.lang.IllegalStateException: [b]Could not open file nio:/var/lib/squash-tm/data/squash-tm.mv.db.mv.db[/b] [1.4.187/1]
at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:773)
at org.h2.mvstore.FileStore.open(FileStore.java:178)
at org.h2.mvstore.MVStore.(MVStore.java:337)
at org.h2.mvstore.MVStore$Builder.open(MVStore.java:2782)
at org.h2.mvstore.db.MVTableEngine$Store.(MVTableEngine.java:162)
at org.h2.mvstore.db.MVTableEngine.init(MVTableEngine.java:98)
... 54 more
Caused by: java.io.FileNotFoundException: /var/lib/squash-tm/data/squash-tm.mv.db.mv.db (Permission non accordée)
at java.io.RandomAccessFile.open0(Native Method)
at java.io.RandomAccessFile.open(RandomAccessFile.java:316)
at java.io.RandomAccessFile.(RandomAccessFile.java:243)
at java.io.RandomAccessFile.(RandomAccessFile.java:124)
at org.h2.store.fs.FileNio.(FilePathNio.java:43)
at org.h2.store.fs.FilePathNio.open(FilePathNio.java:23)
at org.h2.mvstore.FileStore.open(FileStore.java:153)
... 58 more
[16-05-18 11:30:28.543] SquashTM - 24999 INFO [main] []--- org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext: Closing org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@1192f99: startup date [Wed May 18 11:29:00 CEST 2016]; root of context hierarchy
Déploiement de squash-tm.war dans tomcat8
Bonjour,
merci de votre réponse.
J'aimerais installer sur un tomcat déjà utilisé pour d'autres applications, plutôt que de dupliquer les tomcat.
Néanmoins, pour essayer de tester squash, je l'ai installé en suivant le guide "2.02 - Debian/Ubuntu installation".
J'ai laissé la base h2 par défaut.
J'ai des problèmes de connexion à la base, voir log en pièce jointe
Merci de votre aide
Rachel
merci de votre réponse.
J'aimerais installer sur un tomcat déjà utilisé pour d'autres applications, plutôt que de dupliquer les tomcat.
Néanmoins, pour essayer de tester squash, je l'ai installé en suivant le guide "2.02 - Debian/Ubuntu installation".
J'ai laissé la base h2 par défaut.
J'ai des problèmes de connexion à la base, voir log en pièce jointe
Merci de votre aide
Rachel
Déploiement de squash-tm.war dans tomcat8
Bonjour,
Pour la version 1.13 de Squash, il faut une Debian Wheezy et activer le dépot Squash avec :
[code]echo "deb http://repo.squashtest.org/debian wheezy main" | sudo tee /etc/apt/sources.list.d/squash-tm.list[/code]
Le [url=https://sites.google.com/a/henix.fr/wik ... stallation]wiki[/url] a été mis à jour en ce sens.
Cordialement,
Marion
Pour la version 1.13 de Squash, il faut une Debian Wheezy et activer le dépot Squash avec :
[code]echo "deb http://repo.squashtest.org/debian wheezy main" | sudo tee /etc/apt/sources.list.d/squash-tm.list[/code]
Le [url=https://sites.google.com/a/henix.fr/wik ... stallation]wiki[/url] a été mis à jour en ce sens.
Cordialement,
Marion
Déploiement de squash-tm.war dans tomcat8
Bonjour,
j'ai une debian 8.4.
j'ai fait un remove + purge de squash-tm et j'ai recommencé l'installation en suivant le wiki mis à jour.
Lors de mon install je change le port http par défaut en 8084 et je laisse la base h2.
J'ai toujours le même pb (voir log ci-dessous)
Dans les logs on voit que le fichier /var/lib/squash-tm/data/[b]squash-tm.mv.db.mv.db[/b] n'est pas trouvé, et en effet il n'existe pas, celui qui existe s'appelle /var/lib/squash-tm/data/[b]squash-tm.mv.db[/b]
[code]
[16-05-24 09:45:55.574] SquashTM - 19799 ERROR [main] []--- org.springframework.boot.SpringApplication: Application startup failed
org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Could not open connection
at org.springframework.orm.hibernate4.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:544)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:463)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:276)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
at com.sun.proxy.$Proxy211.getBoolean(Unknown Source)
at org.squashtest.tm.web.internal.listener.SquashConfigContextExposer.exposeMilestoneFeatEnabled(SquashConfigContextExposer.java:70)
at org.squashtest.tm.web.internal.listener.SquashConfigContextExposer.onApplicationEvent(SquashConfigContextExposer.java:97)
at org.squashtest.tm.web.internal.listener.SquashConfigContextExposer.onApplicationEvent(SquashConfigContextExposer.java:1)
at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:151)
at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:128)
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:331)
at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:773)
at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.finishRefresh(EmbeddedWebApplicationContext.java:140)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:483)
at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:118)
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:686)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:320)
at org.squashtest.tm.SquashTm.main(SquashTm.java:55)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:53)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.hibernate.exception.GenericJDBCException: Could not open connection
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:235)
at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:171)
at org.hibernate.internal.SessionImpl.connection(SessionImpl.java:450)
at org.springframework.orm.hibernate4.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:450)
... 26 more
Caused by: org.h2.jdbc.JdbcSQLException: IO Exception: "/var/lib/squash-tm/data/squash-tm.mv.db.mv.db" [90028-187]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:168)
at org.h2.mvstore.db.MVTableEngine.init(MVTableEngine.java:112)
at org.h2.engine.Database.getPageStore(Database.java:2389)
at org.h2.engine.Database.open(Database.java:669)
at org.h2.engine.Database.openDatabase(Database.java:266)
at org.h2.engine.Database.(Database.java:260)
at org.h2.engine.Engine.openSession(Engine.java:60)
at org.h2.engine.Engine.openSession(Engine.java:167)
at org.h2.engine.Engine.createSessionAndValidate(Engine.java:145)
at org.h2.engine.Engine.createSession(Engine.java:128)
at org.h2.engine.Engine.createSession(Engine.java:26)
at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:347)
at org.h2.jdbc.JdbcConnection.(JdbcConnection.java:108)
at org.h2.jdbc.JdbcConnection.(JdbcConnection.java:92)
at org.h2.Driver.connect(Driver.java:72)
at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:307)
at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:200)
at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:699)
at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:633)
at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:484)
at org.apache.tomcat.jdbc.pool.ConnectionPool.(ConnectionPool.java:142)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:115)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:102)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:126)
at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:139)
at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:380)
at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:228)
... 29 more
Caused by: java.lang.IllegalStateException: Could not open file nio:/var/lib/squash-tm/data/squash-tm.mv.db.mv.db [1.4.187/1]
at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:773)
at org.h2.mvstore.FileStore.open(FileStore.java:178)
at org.h2.mvstore.MVStore.(MVStore.java:337)
at org.h2.mvstore.MVStore$Builder.open(MVStore.java:2782)
at org.h2.mvstore.db.MVTableEngine$Store.(MVTableEngine.java:162)
at org.h2.mvstore.db.MVTableEngine.init(MVTableEngine.java:98)
... 54 more
Caused by: java.io.FileNotFoundException: /var/lib/squash-tm/data/squash-tm.mv.db.mv.db (Permission non accordée)
at java.io.RandomAccessFile.open0(Native Method)
at java.io.RandomAccessFile.open(RandomAccessFile.java:316)
at java.io.RandomAccessFile.(RandomAccessFile.java:243)
at java.io.RandomAccessFile.(RandomAccessFile.java:124)
at org.h2.store.fs.FileNio.(FilePathNio.java:43)
at org.h2.store.fs.FilePathNio.open(FilePathNio.java:23)
at org.h2.mvstore.FileStore.open(FileStore.java:153)
... 58 more
[16-05-24 09:45:55.586] SquashTM - 19799 INFO [main] []--- org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext: Closing org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@59fd3780: startup date [Tue May 24 09:44:14 CEST 2016]; root of context hierarchy
[16-05-24 09:45:55.595] SquashTM - 19799 INFO [main] []--- org.springframework.context.support.DefaultLifecycleProcessor: Stopping beans in phase 0
[16-05-24 09:45:55.629] SquashTM - 19799 INFO [main] []--- org.springframework.jmx.export.annotation.AnnotationMBeanExporter: Unregistering JMX-exposed beans on shutdown
[16-05-24 09:45:55.665] SquashTM - 19799 INFO [main] []--- org.springframework.cache.ehcache.EhCacheManagerFactoryBean: Shutting down EhCache CacheManager
[16-05-24 09:45:55.700] SquashTM - 19799 INFO [main] []--- org.springframework.scheduling.concurrent.ThreadPoolTaskScheduler: Shutting down ExecutorService 'squashtest.tm.service.ThreadPoolTaskScheduler'
[16-05-24 09:45:55.700] SquashTM - 19799 INFO [main] []--- org.springframework.scheduling.concurrent.ThreadPoolTaskScheduler: Shutting down ExecutorService 'squashtest.tm.service.ThreadPoolTaskScheduler'
[/code]
j'ai une debian 8.4.
j'ai fait un remove + purge de squash-tm et j'ai recommencé l'installation en suivant le wiki mis à jour.
Lors de mon install je change le port http par défaut en 8084 et je laisse la base h2.
J'ai toujours le même pb (voir log ci-dessous)
Dans les logs on voit que le fichier /var/lib/squash-tm/data/[b]squash-tm.mv.db.mv.db[/b] n'est pas trouvé, et en effet il n'existe pas, celui qui existe s'appelle /var/lib/squash-tm/data/[b]squash-tm.mv.db[/b]
[code]
[16-05-24 09:45:55.574] SquashTM - 19799 ERROR [main] []--- org.springframework.boot.SpringApplication: Application startup failed
org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Could not open connection
at org.springframework.orm.hibernate4.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:544)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:463)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:276)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
at com.sun.proxy.$Proxy211.getBoolean(Unknown Source)
at org.squashtest.tm.web.internal.listener.SquashConfigContextExposer.exposeMilestoneFeatEnabled(SquashConfigContextExposer.java:70)
at org.squashtest.tm.web.internal.listener.SquashConfigContextExposer.onApplicationEvent(SquashConfigContextExposer.java:97)
at org.squashtest.tm.web.internal.listener.SquashConfigContextExposer.onApplicationEvent(SquashConfigContextExposer.java:1)
at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:151)
at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:128)
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:331)
at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:773)
at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.finishRefresh(EmbeddedWebApplicationContext.java:140)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:483)
at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:118)
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:686)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:320)
at org.squashtest.tm.SquashTm.main(SquashTm.java:55)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:53)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.hibernate.exception.GenericJDBCException: Could not open connection
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:235)
at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:171)
at org.hibernate.internal.SessionImpl.connection(SessionImpl.java:450)
at org.springframework.orm.hibernate4.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:450)
... 26 more
Caused by: org.h2.jdbc.JdbcSQLException: IO Exception: "/var/lib/squash-tm/data/squash-tm.mv.db.mv.db" [90028-187]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:168)
at org.h2.mvstore.db.MVTableEngine.init(MVTableEngine.java:112)
at org.h2.engine.Database.getPageStore(Database.java:2389)
at org.h2.engine.Database.open(Database.java:669)
at org.h2.engine.Database.openDatabase(Database.java:266)
at org.h2.engine.Database.(Database.java:260)
at org.h2.engine.Engine.openSession(Engine.java:60)
at org.h2.engine.Engine.openSession(Engine.java:167)
at org.h2.engine.Engine.createSessionAndValidate(Engine.java:145)
at org.h2.engine.Engine.createSession(Engine.java:128)
at org.h2.engine.Engine.createSession(Engine.java:26)
at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:347)
at org.h2.jdbc.JdbcConnection.(JdbcConnection.java:108)
at org.h2.jdbc.JdbcConnection.(JdbcConnection.java:92)
at org.h2.Driver.connect(Driver.java:72)
at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:307)
at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:200)
at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:699)
at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:633)
at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:484)
at org.apache.tomcat.jdbc.pool.ConnectionPool.(ConnectionPool.java:142)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:115)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:102)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:126)
at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:139)
at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:380)
at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:228)
... 29 more
Caused by: java.lang.IllegalStateException: Could not open file nio:/var/lib/squash-tm/data/squash-tm.mv.db.mv.db [1.4.187/1]
at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:773)
at org.h2.mvstore.FileStore.open(FileStore.java:178)
at org.h2.mvstore.MVStore.(MVStore.java:337)
at org.h2.mvstore.MVStore$Builder.open(MVStore.java:2782)
at org.h2.mvstore.db.MVTableEngine$Store.(MVTableEngine.java:162)
at org.h2.mvstore.db.MVTableEngine.init(MVTableEngine.java:98)
... 54 more
Caused by: java.io.FileNotFoundException: /var/lib/squash-tm/data/squash-tm.mv.db.mv.db (Permission non accordée)
at java.io.RandomAccessFile.open0(Native Method)
at java.io.RandomAccessFile.open(RandomAccessFile.java:316)
at java.io.RandomAccessFile.(RandomAccessFile.java:243)
at java.io.RandomAccessFile.(RandomAccessFile.java:124)
at org.h2.store.fs.FileNio.(FilePathNio.java:43)
at org.h2.store.fs.FilePathNio.open(FilePathNio.java:23)
at org.h2.mvstore.FileStore.open(FileStore.java:153)
... 58 more
[16-05-24 09:45:55.586] SquashTM - 19799 INFO [main] []--- org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext: Closing org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@59fd3780: startup date [Tue May 24 09:44:14 CEST 2016]; root of context hierarchy
[16-05-24 09:45:55.595] SquashTM - 19799 INFO [main] []--- org.springframework.context.support.DefaultLifecycleProcessor: Stopping beans in phase 0
[16-05-24 09:45:55.629] SquashTM - 19799 INFO [main] []--- org.springframework.jmx.export.annotation.AnnotationMBeanExporter: Unregistering JMX-exposed beans on shutdown
[16-05-24 09:45:55.665] SquashTM - 19799 INFO [main] []--- org.springframework.cache.ehcache.EhCacheManagerFactoryBean: Shutting down EhCache CacheManager
[16-05-24 09:45:55.700] SquashTM - 19799 INFO [main] []--- org.springframework.scheduling.concurrent.ThreadPoolTaskScheduler: Shutting down ExecutorService 'squashtest.tm.service.ThreadPoolTaskScheduler'
[16-05-24 09:45:55.700] SquashTM - 19799 INFO [main] []--- org.springframework.scheduling.concurrent.ThreadPoolTaskScheduler: Shutting down ExecutorService 'squashtest.tm.service.ThreadPoolTaskScheduler'
[/code]