This is a space where the community of Teamwork users can ask for support, explanations,
and also vote up or down questions, answers and feature requests.
>> Back to Teamwork's site.

Postgresql Installation

0

Just installed Teamwork with postgresql. When I tried to create a company I was kicked out of Teamwork, creating a person was OK. Then I tried creating a new project, was OK. But when I set up a task type I was kicked out again. How can send you the log file? Please note I have tested the same Teamwork version but with HsqlDB without these problems. Thanks for your help

asked Jan 22 '11 at 07:54

Yann's gravatar image

Yann
26●3

edited Jan 24 '11 at 06:05

Pietro%20Polsinelli's gravatar image

Pietro Polsinelli ♦♦
4617●2●12
4 Answers:
oldestnewestmost voted
1

Maybe you should check if you have run in your PostgreSQL database the query explained in chapter 19.6.5 of the user guide here

http://www.twproject.com/documentation.page

Let me know if this fixes your problem.

answered Jan 24 '11 at 03:24

Silvia%20Chelazzi's gravatar image

Silvia Chelazzi ♦♦
4085●1●9
1

It works fine now, some java libraries were missing on the server

answered Feb 09 '11 at 15:06

Yann's gravatar image

Yann
26●3
0

In my own experience, it didn't work out of the box: the doc states that

Tests on PostgreSQL 8.3+ have shown that due to a change in default casting behavior, Teamwork’s database must be configured with:

CREATE FUNCTION int_to_text(INT4) RETURNS TEXT AS ' SELECT

textin(int4out($1)); ' LANGUAGE SQL STRICT IMMUTABLE; CREATE CAST (INT4 AS TEXT) WITH FUNCTION int_to_text(INT4) AS IMPLICIT;

Since 4.3 this is done by the setup procedure.

However, it hadn't been done by the setup process, and I experienced the following errors, until I applied it manually :

2011 juin 06 13:15:57 FATAL platformLogger:23 - select listener from org.jblooming.messaging.Listener as listener where ( (upper(ownerx) like :owner1 ) )
and (listener.identifiableId = :docId) and ( (upper(theClass) like :theClass1 ) ) logged operator: (6) System Manager Server time: 2011 06 06 13:15:57. The exception thrown:

org.jblooming.PlatformRuntimeException: Server time: 2011 06 06 13:15:57. select listener from org.jblooming.messaging.Listener as listener where ( (upper( ownerx) like :owner1 ) ) and (listener.identifiableId = :docId) and ( (upper(theClass) like :theClass1 ) ) logged operator: (6) System Manager Server time: 2011 06 06 13:15:57. The exception thrown:

    at com.twproject.task.businessLogic.TaskController.perform(TaskController.java:148)
    at org.jblooming.waf.view.PageState.perform(PageState.java:217)
    at org.apache.jsp.applications.teamwork.task.taskEditor_jsp._jspService(taskEditor_jsp.java:90)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.jblooming.waf.AccessControlFilter.doFilter(AccessControlFilter.java:39)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at com.twproject.task.TaskPublicPageFilter.doFilter(TaskPublicPageFilter.java:64)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.jblooming.waf.FrontControllerFilter.doFilter(FrontControllerFilter.java:146)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.jblooming.http.multipartfilter.MultipartFormRequestEncodingFilter.doFilter(MultipartFormRequestEncodingFilter.java:99)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.jblooming.http.CachingFilter.doFilter(CachingFilter.java:44)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.jblooming.http.ByPassFilter.doFilter(ByPassFilter.java:46)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    at java.lang.Thread.run(Thread.java:662)

Caused by: org.jblooming.persistence.exceptions.FindException: select listener from org.jblooming.messaging.Listener as listener where ( (upper(ownerx) lik e :owner1 ) ) and (listener.identifiableId = :docId) and ( (upper(theClass) like :theClass1 ) ) 

    at org.jblooming.oql.OqlQuery.list(OqlQuery.java:73)
    at com.twproject.document.businessLogic.DocumentAction.make(DocumentAction.java:424)
    at com.twproject.document.businessLogic.DocumentAction.cmdEdit(DocumentAction.java:90)
    at com.twproject.task.businessLogic.TaskAction.cmdPerformDocumentAction(TaskAction.java:1420)
    at com.twproject.task.businessLogic.TaskController.perform(TaskController.java:145)
    ... 38 more

Caused by: org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:2216) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104) at org.hibernate.loader.Loader.list(Loader.java:2099) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at org.jblooming.oql.OqlQuery.list(OqlQuery.java:71) ... 42 more Caused by: org.postgresql.util.PSQLException: ERROR: function upper(integer) does not exist Indice : No function matches the given name and argument types. You might need to add explicit type casts. Position : 533 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2077) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1810) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:498) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:386) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271) at sun.reflect.GeneratedMethodAccessor27.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:68) at org.logicalcobwebs.cglib.proxy.Proxy$ProxyImpl$$EnhancerByCGLIB$$5a9511cd.executeQuery(<generated>) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186) at org.hibernate.loader.Loader.getResultSet(Loader.java:1787) at org.hibernate.loader.Loader.doQuery(Loader.java:674) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) at org.hibernate.loader.Loader.doList(Loader.java:2213) ... 50 more

answered Jun 15 '11 at 05:21

Le%20Cantonnier's gravatar image

Le Cantonnier
24●3
0

Another comment on Postgresql setup documentation:

It says :

A sample connection property set is user=myuser password=mypassword

url=jdbc:postgresql://localhost/teamwork

dialect=org.hibernate.dialect.PostgreSQLDialect

driver=org.postgresql.Driver

And I have:

dialect=org.hibernate.dialect.PostgreSQLDialectDBBlobs

driver=org.postgresql.Driver

I also updated the JDBC Jar to http://jdbc.postgresql.org/download/postgresql-8.4-702.jdbc3.jar (running along with Postgresql 8.4, tomcat 6.0.24 and Sun Java 1.6.0_24 on Ubuntu 10.04)

answered Jun 15 '11 at 05:32

Le%20Cantonnier's gravatar image

Le Cantonnier
24●3
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Tags:

×6

Asked: Jan 22 '11 at 07:54

Seen: 1,257 times

Last updated: Jun 15 '11 at 05:32

Related questions

Error on upgrading from 4.4 to 4.6

Postgresql & 4.7 : incomplete database creation, resulting in unusable app

Update teamwork (Use postgres database) version of 4.4.16000 to 4.7.25010

FAQ: Teamwork and PostgreSql

Teamwork 4.7 patch release 4.7.25011 / postgres-hibernate bug

| Teamwork faq | about | contact us | Teamwork blog | Teamwork documentation | feedback always welcome