Forum SquashTM

Hello

I ran the startup.sh in ubuntu with the following variable
JAR_NAME="org.apache.felix.main-4.2.1.jar" # Java main library
HTTP_PORT=8080 # Port for HTTP connector (default 8080; disable with -1)
# Directory variables
TMP_DIR=../tmp # Jetty tmp and work directory
BUNDLES_DIR=../bundles # Bundles directory
CACHE_DIR=.. # Cache directory
CONF_DIR=../conf # Configurations directory
LOG_DIR=../logs # Log directory
JETTY_HOME=../jettyhome # Jetty home directory
LUCENE_DIR=../luceneindexes # Lucene indexes directory
PLUGINS_DIR=../plugins # Plugins directory
# DataBase parameters
DB_URL=jdbc:mysql://localhost:3306/squashtm # DataBase URL
DB_DRIVER=com.mysql.jdbc.Driver # DataBase driver
DB_USERNAME=root # DataBase username
DB_PASSWORD=test1234 # DataBase password
DB_DIALECT=org.hibernate.dialect.MySQLDialect # DataBase dialect
## Do not configure a third digit here
REQUIRED_VERSION=1.6
# Extra Java args
JAVA_ARGS="-Xms128m -Xmx512m -XX:MaxPermSize=192m -server"

I got the below result
root@TNQ-LTP-078:/etc/squash-tm/bin# sh ./startup.sh
./startup.sh : checking java environment... done
checking version... done
./startup.sh : starting Felix...
Picked up _JAVA_OPTIONS: -Ddb.driver=com.mysql.jdbc.Driver -Ddb.url=jdbc:mysql://localhost:3306/squashtm -Ddb.username=root -Ddb.password=test1234 -Ddb.dialect=org.hibernate.dialect.MySQLDialect -Duser.language=en
log4j:WARN No appenders could be found for logger (org.eclipse.jetty.util.log).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
____________________________
Welcome to Apache Felix Gogo

g!



Please let me know how to continue after the command.

I have the below commands
____________________________
Welcome to Apache Felix Gogo

g! install org.apache.felix.framework-4.2.1.jar
g! install org.apache.felix.main-4.2.1.jar
g! install squash-launcher.jar

When I launched the Squashtm using http://localhost:8080/squash
Received the below error message
HTTP ERROR 500

Problem accessing /squash/login. Reason:

Server Error

Caused by:

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:440)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:371)
at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:329)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:105)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at com.sun.proxy.$Proxy234.findConfiguration(Unknown Source)
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:319)
at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:58)
at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:62)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:71)
at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:54)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.osgi.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:59)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at com.sun.proxy.$Proxy153.findConfiguration(Unknown Source)
at org.squashtest.tm.web.internal.controller.authentication.LoginLogoutController.login(LoginLogoutController.java:49)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

Hi,

The result when you ran the startup.sh seems to be normal.

For error 500, maybe you should try with your real IP instead of "localhost" in squash URL.

Best regards,
Mathilde.

Thanks Now I am able to login to my squashTM
In the Online demo I am able to view the Bugtracker Workspace but I am unable to see the bugtracker workspace in my installed

Thanks in advance

Hi,

You've got to install a bugtracker in your squash (administration>Bugtrackers>Add)

You can download a free mantis for exemple.

After that, bugtracker workspace should be available.

Best regards,
Mathilde.

Hi

I have installed bugzilla in my localhost and the plugins for bugzilla are also added. But the in the Kind dropdown does not display bugzilla option. Can you pls help me on this.