Salve,
Sto cercando di installare cmdbuild su una distribuzione Ubuntu Server 9.10
Versione Tomcat: 6.0.20
Versione Postgresql 8.4
Si verifica errore d'installazione in fase di installazione come da oggetto.
Potreste darci indicazioni?
PS Lo stesso errore si è verificato con Ubuntu 8.04 e Postgresql 8.3.
Saluti,
Tiziano
Sembra che non siano state copiate correttamente le librerie di PostgreSQL dentro l'istanza di Tomcat. Riporto quanto scritto nel file INSTALL.txt all'interno dell'archivio cmdbuild-1.1.1.zip
* Aggiungere le librerie presenti in extras/tomcat-libs, relative alla
versione di Tomcat su cui verrà installato CMDBuild, fra quelle a
disposizione del servlet container (come indicato nel file INSTALL.txt
presente nella cartella)
* Copiare cmdbuild.war nella cartella "webapps" di Tomcat
Dopo queste operazioni, accedendo a CMDBuild dovrebbe vedere correttamente l'interfaccia di configurazione e nel secondo passo dovrebbe leggere "Database connection (PostgreSQL 8.3-603)" che corrisponde alla versione del driver distribuito con CMDBuild (compatibile e testato anche con la versione 8.4 del database).
Paolo
Salve,
Chiedo scusa per la mancata descrizione dettagliata:
Il file postgresql-8.3-603.jdbc3 era stato spostato nella cartella di Tomcat /lib come da istruzioni. Dopo aver riscontrato l'errore sono ricorso al supporto tramite questo forum.
Di seguito il cat del log file catalina.out
2-dic-2009 22.49.27 org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/lib/jvm/java-6-sun-1.6.0.15/jre/lib/i386/client:/usr/lib/jvm/java-6-sun-1.6.0.15/jre/lib/i386:/usr/lib/jvm/java-6-sun-1.6.0.15/jre/../lib/i386:/usr/java/packages/lib/i386:/lib:/usr/lib
2-dic-2009 22.49.27 org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
2-dic-2009 22.49.27 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 832 ms
2-dic-2009 22.49.27 org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
2-dic-2009 22.49.27 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.20
2-dic-2009 22.49.28 org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
2-dic-2009 22.49.28 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
2-dic-2009 22.49.28 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/40 config=null
2-dic-2009 22.49.28 org.apache.catalina.startup.Catalina start
INFO: Server startup in 1124 ms
2-dic-2009 22.54.07 org.apache.coyote.http11.Http11Protocol pause
INFO: Pausing Coyote HTTP/1.1 on http-8080
2-dic-2009 22.54.08 org.apache.catalina.core.StandardService stop
INFO: Stopping service Catalina
2-dic-2009 22.54.09 org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/lib/jvm/java-6-sun-1.6.0.15/jre/lib/i386/client:/usr/lib/jvm/java-6-sun-1.6.0.15/jre/lib/i386:/usr/lib/jvm/java-6-sun-1.6.0.15/jre/../lib/i386:/usr/java/packages/lib/i386:/lib:/usr/lib
2-dic-2009 22.54.09 org.apache.coyote.http11.Http11Protocol destroy
INFO: Stopping Coyote HTTP/1.1 on http-8080
2-dic-2009 22.54.09 org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
2-dic-2009 22.54.09 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 861 ms
2-dic-2009 22.54.09 org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
2-dic-2009 22.54.09 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.20
2-dic-2009 22.54.10 org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
2-dic-2009 22.54.10 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
2-dic-2009 22.54.10 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/36 config=null
2-dic-2009 22.54.10 org.apache.catalina.startup.Catalina start
INFO: Server startup in 1130 ms
2-dic-2009 22.57.24 org.apache.coyote.http11.Http11Protocol pause
INFO: Pausing Coyote HTTP/1.1 on http-8080
2-dic-2009 22.57.25 org.apache.catalina.core.StandardService stop
INFO: Stopping service Catalina
2-dic-2009 22.57.25 org.apache.coyote.http11.Http11Protocol destroy
INFO: Stopping Coyote HTTP/1.1 on http-8080
2-dic-2009 23.00.16 org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/lib/jvm/java-6-sun-1.6.0.15/jre/lib/i386/client:/usr/lib/jvm/java-6-sun-1.6.0.15/jre/lib/i386:/usr/lib/jvm/java-6-sun-1.6.0.15/jre/../lib/i386:/usr/java/packages/lib/i386:/lib:/usr/lib
2-dic-2009 23.00.16 org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
2-dic-2009 23.00.16 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 794 ms
2-dic-2009 23.00.16 org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
2-dic-2009 23.00.16 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.20
2-dic-2009 23.00.17 org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
2-dic-2009 23.00.17 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
2-dic-2009 23.00.17 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/41 config=null
2-dic-2009 23.00.17 org.apache.catalina.startup.Catalina start
INFO: Server startup in 1134 ms
2-dic-2009 23.19.07 org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive cmdbuild.war
cat: cat: No such file or directory
2-dic-2009 22.49.27 org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/lib/jvm/java-6-sun-1.6.0.15/jre/lib/i386/client:/usr/lib/jvm/java-6-sun-1.6.0.15/jre/lib/i386:/usr/lib/jvm/java-6-sun-1.6.0.15/jre/../lib/i386:/usr/java/packages/lib/i386:/lib:/usr/lib
2-dic-2009 22.49.27 org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
2-dic-2009 22.49.27 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 832 ms
2-dic-2009 22.49.27 org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
2-dic-2009 22.49.27 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.20
2-dic-2009 22.49.28 org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
2-dic-2009 22.49.28 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
2-dic-2009 22.49.28 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/40 config=null
2-dic-2009 22.49.28 org.apache.catalina.startup.Catalina start
INFO: Server startup in 1124 ms
2-dic-2009 22.54.07 org.apache.coyote.http11.Http11Protocol pause
INFO: Pausing Coyote HTTP/1.1 on http-8080
2-dic-2009 22.54.08 org.apache.catalina.core.StandardService stop
INFO: Stopping service Catalina
2-dic-2009 22.54.09 org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/lib/jvm/java-6-sun-1.6.0.15/jre/lib/i386/client:/usr/lib/jvm/java-6-sun-1.6.0.15/jre/lib/i386:/usr/lib/jvm/java-6-sun-1.6.0.15/jre/../lib/i386:/usr/java/packages/lib/i386:/lib:/usr/lib
2-dic-2009 22.54.09 org.apache.coyote.http11.Http11Protocol destroy
INFO: Stopping Coyote HTTP/1.1 on http-8080
2-dic-2009 22.54.09 org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
2-dic-2009 22.54.09 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 861 ms
2-dic-2009 22.54.09 org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
2-dic-2009 22.54.09 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.20
2-dic-2009 22.54.10 org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
2-dic-2009 22.54.10 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
2-dic-2009 22.54.10 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/36 config=null
2-dic-2009 22.54.10 org.apache.catalina.startup.Catalina start
INFO: Server startup in 1130 ms
2-dic-2009 22.57.24 org.apache.coyote.http11.Http11Protocol pause
INFO: Pausing Coyote HTTP/1.1 on http-8080
2-dic-2009 22.57.25 org.apache.catalina.core.StandardService stop
INFO: Stopping service Catalina
2-dic-2009 22.57.25 org.apache.coyote.http11.Http11Protocol destroy
INFO: Stopping Coyote HTTP/1.1 on http-8080
2-dic-2009 23.00.16 org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/lib/jvm/java-6-sun-1.6.0.15/jre/lib/i386/client:/usr/lib/jvm/java-6-sun-1.6.0.15/jre/lib/i386:/usr/lib/jvm/java-6-sun-1.6.0.15/jre/../lib/i386:/usr/java/packages/lib/i386:/lib:/usr/lib
2-dic-2009 23.00.16 org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
2-dic-2009 23.00.16 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 794 ms
2-dic-2009 23.00.16 org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
2-dic-2009 23.00.16 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.20
2-dic-2009 23.00.17 org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
2-dic-2009 23.00.17 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
2-dic-2009 23.00.17 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/41 config=null
2-dic-2009 23.00.17 org.apache.catalina.startup.Catalina start
INFO: Server startup in 1134 ms
2-dic-2009 23.19.07 org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive cmdbuild.war
log4j: Parsing for [root] with value=[WARN, R].
log4j: Level token is [WARN].
log4j: Category root set to WARN
log4j: Parsing appender named "R".
log4j: Parsing layout options for "R".
log4j: Setting property [conversionPattern] to [%-5.5p %d{yyyy-MM-dd HH:mm:ss} [%-8c] %m%n].
log4j: End of parsing for "R".
log4j: Setting property [file] to [/usr/local/tomcat/tomcat/cmdbuild.log].
log4j: Setting property [maxFileSize] to [100MB].
log4j: Setting property [maxBackupIndex] to [10].
log4j: setFile called: /usr/local/tomcat/tomcat/cmdbuild.log, true
log4j: setFile ended
log4j: Parsed "R" options.
log4j: Parsing for [sql] with value=[WARN].
log4j: Level token is [WARN].
log4j: Category sql set to WARN
log4j: Handling log4j.additivity.sql=[null]
log4j: Parsing for [cmdbuild] with value=[INFO].
log4j: Level token is [INFO].
log4j: Category cmdbuild set to INFO
log4j: Handling log4j.additivity.cmdbuild=[null]
log4j: Parsing for [soap] with value=[WARN].
log4j: Level token is [WARN].
log4j: Category soap set to WARN
log4j: Handling log4j.additivity.soap=[null]
log4j: Parsing for [email] with value=[INFO].
log4j: Level token is [INFO].
log4j: Category email set to INFO
log4j: Handling log4j.additivity.email=[null]
log4j: Parsing for [persist] with value=[WARN].
log4j: Level token is [WARN].
log4j: Category persist set to WARN
log4j: Handling log4j.additivity.persist=[null]
log4j: Parsing for [jsonrpc] with value=[INFO].
log4j: Level token is [INFO].
log4j: Category jsonrpc set to INFO
log4j: Handling log4j.additivity.jsonrpc=[null]
log4j: Parsing for [workflow] with value=[INFO].
log4j: Level token is [INFO].
log4j: Category workflow set to INFO
log4j: Handling log4j.additivity.workflow=[null]
log4j: Parsing for [rest] with value=[WARN].
log4j: Level token is [WARN].
log4j: Category rest set to WARN
log4j: Handling log4j.additivity.rest=[null]
log4j: Parsing for [dms] with value=[WARN].
log4j: Level token is [WARN].
log4j: Category dms set to WARN
log4j: Handling log4j.additivity.dms=[null]
log4j: Finished configuring.
Per l'installazione del server tomcat ho seguito queste istruzioni
http://kmtk.cs.ait.ac.th/knowledge-center/how-to/install-tomcat-6-on-ubuntu-server-8.0.4
Saluti.
Previously Tiziano wrote:
Il file postgresql-8.3-603.jdbc3 era stato spostato nella cartella di Tomcat /lib come da istruzioni. [...] Di seguito il cat del log file catalina.out
CMDBuild scrive il log nel file cmdbuild.log (di default creato dentro la Tomcat Home). Il file catalina.out va controllato solo se l'applicazione non è accassibile (ad esempio quando manca una libreria fondamentale al funzionamento minimo del sistema). Le consiglio di controllare che non ci siano altre versioni dei driver JDBC di postgres installate nel sistema (che potrebbero entrare in conflitto) e in caso di postare il contenuto del file cmdbuild.log dopo l'ultimo avvio di Tomcat.
Paolo
Ecco l’output del file cmdbuild.log dentro la cartella tomcat
.
INFO 2009-12-02 23:19:10 [cmdbuild] Loading common configurations for CMDBuild
INFO 2009-12-02 23:19:10 [cmdbuild] Initialize custom ParameterTransformers
INFO 2009-12-02 23:19:10 [cmdbuild] Transformer for: JSONArray : org.cmdbuild.servlets.utils.transformer.JSONArrayTransformer
INFO 2009-12-02 23:19:10 [cmdbuild] Transformer for: FileItem : org.cmdbuild.servlets.utils.transformer.FileItemTransformer
INFO 2009-12-02 23:19:10 [cmdbuild] Transformer for: JSONObject : org.cmdbuild.servlets.utils.transformer.JSONObjectTransformer
INFO 2009-12-02 23:19:10 [cmdbuild] Initializer custom ParameterBuilders
INFO 2009-12-02 23:19:10 [cmdbuild] Builder for: ActivityIdentifier: org.cmdbuild.servlets.utils.builder.ActivityIdentifierParameter
INFO 2009-12-02 23:19:10 [cmdbuild] Builder for: ITable: org.cmdbuild.servlets.utils.builder.TableParameter
INFO 2009-12-02 23:19:10 [cmdbuild] Builder for: IDomain: org.cmdbuild.servlets.utils.builder.DomainParameter
INFO 2009-12-02 23:19:10 [cmdbuild] Builder for: ICard: org.cmdbuild.servlets.utils.builder.CardParameter
INFO 2009-12-02 23:19:10 [cmdbuild] Builder for: IRelation: org.cmdbuild.servlets.utils.builder.RelationParameter
INFO 2009-12-02 23:19:10 [cmdbuild] Builder for: User: org.cmdbuild.servlets.utils.builder.UserParameter
INFO 2009-12-02 23:19:10 [cmdbuild] Builder for: Role: org.cmdbuild.servlets.utils.builder.RoleParameter
INFO 2009-12-02 23:19:10 [cmdbuild] Builder for: ICardFilterManager: org.cmdbuild.servlets.utils.builder.FilterParameter
INFO 2009-12-02 23:19:10 [cmdbuild] Builder for: XMLDocument: org.cmdbuild.servlets.utils.builder.XMLDocumentBuilder
INFO 2009-12-02 23:19:20 [jsonrpc ] Calling url /utils/gettranslationobject
INFO 2009-12-03 23:43:06 [jsonrpc ] Calling url /utils/gettranslationobject
INFO 2009-12-04 01:12:35 [jsonrpc ] Calling url /utils/gettranslationobject
Il pacchetto libpg-java (Java database JDBC driver for postgresql) risulta non installato sul sistema da synaptic (quindi è presente solo il driver da voi fornito).
Saluto
Salve,
purtroppo il procedimento che ha seguito è corretto e la situazione è piuttosto anomala.
Ci conferma che ha messo la librerie in {tomcat_home}/libs?
Eventualmente può provare ad inserirle dentro le librerie di java (che vengono indicate nel catalina.out), e riprovare.
Non so se in quel caso sia necessario un riavvio del sistema...
Cordiali saluti,
Lisa