topic ALFRESCO 2.1 POSTGRES 9.0 PROBLEMI ALL'AVVIO in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/alfresco-2-1-postgres-9-0-problemi-all-avvio/m-p/28645#M14563 <HTML><HEAD></HEAD><BODY><SPAN>Buongiorno,</SPAN><BR /><BR /><SPAN>stò cercando di installare Alfresco 2.1 ma non riesco a farlo avviare.</SPAN><BR /><SPAN>Versioni che uso:</SPAN><BR /><SPAN>postgres 9.0</SPAN><BR /><SPAN>Cmdbuild 1.3.1.0</SPAN><BR /><SPAN>jdk1.6.0_16</SPAN><BR /><SPAN>Tomcat 6.0</SPAN><BR /><BR /><SPAN>Ho scompattato il alfresco-tomcat-2.1.0.zip sotto C:/alfresco</SPAN><BR /><BR /><SPAN>Configurazioni di alfresco:</SPAN><BR /><SPAN>C:/alfresco/tomcat/conf/server.xml (ho tolto le righe commentate)</SPAN><BR /><SPAN>&lt;Server port="8006" shutdown="SHUTDOWN"&gt;</SPAN><BR /><SPAN>&nbsp; &lt;Listener className="org.apache.catalina.mbeans.ServerLifecycleListener" /&gt;</SPAN><BR /><SPAN>&nbsp; &lt;Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener" /&gt;</SPAN><BR /><SPAN>&nbsp; &lt;Listener className="org.apache.catalina.storeconfig.StoreConfigLifecycleListener"/&gt;</SPAN><BR /><SPAN>&nbsp; &lt;GlobalNamingResources&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;Environment name="simpleValue" type="java.lang.Integer" value="30"/&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp; &lt;Resource name="UserDatabase" auth="Container"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; type="org.apache.catalina.UserDatabase"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; description="User database that can be updated and saved"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; factory="org.apache.catalina.users.MemoryUserDatabaseFactory"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pathname="conf/tomcat-users.xml" /&gt;</SPAN><BR /><SPAN>&nbsp; &lt;/GlobalNamingResources&gt;</SPAN><BR /><SPAN>&nbsp; &lt;Service name="Catalina"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;!– Define a non-SSL HTTP/1.1 Connector on port 8080 –&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;Connector port="8080" URIEncoding="UTF-8" maxHttpHeaderSize="8192"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; maxThreads="150" minSpareThreads="25" maxSpareThreads="75"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; enableLookups="false" redirectPort="8443" acceptCount="100"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; connectionTimeout="20000" disableUploadTimeout="true" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;Engine name="Catalina" defaultHost="localhost"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;Realm className="org.apache.catalina.realm.UserDatabaseRealm"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; resourceName="UserDatabase"/&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;Host name="localhost" appBase="webapps"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; unpackWARs="true" autoDeploy="true"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; xmlValidation="false" xmlNamespaceAware="false"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/Host&gt;</SPAN><BR /><SPAN> &lt;/Engine&gt;</SPAN><BR /><SPAN> &lt;/Service&gt;</SPAN><BR /><SPAN>&lt;/Server&gt;</SPAN><BR /><BR /><BR /><SPAN>C:/alfresco/tomcat/shared/classes/alfresco/extension/custom-repository.properties</SPAN><BR /><BR /><SPAN>###############################</SPAN><BR /><SPAN>## Common Alfresco Properties #</SPAN><BR /><SPAN>###############################</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN># Sample custom content and index data location</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN>dir.root=C:/alfresco/data</SPAN><BR /><SPAN>dir.indexes=C:/alfresco/data</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN># Sample database connection properties</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN>db.username=username del db</SPAN><BR /><SPAN>db.password=pwd del db</SPAN><BR /><SPAN>#db.pool.initial=10</SPAN><BR /><SPAN>#db.pool.max=100</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN># Property to control whether schema updates are performed automatically.</SPAN><BR /><SPAN># Updates must be enabled during upgrades as, apart from the static upgrade scripts,</SPAN><BR /><SPAN># there are also auto-generated update scripts that will need to be executed.&nbsp; After</SPAN><BR /><SPAN># upgrading to a new version, this can be disabled.</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN>db.schema.update=true</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN># HSQL connection</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN>#db.driver=org.hsqldb.jdbcDriver</SPAN><BR /><SPAN>#db.url=jdbc:hsqldb:file:alf_data/hsql_data/alfresco;ifexists=true;shutdown=true;</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN># MySQL connection (This is default and requires mysql-connector-java-5.0.3-bin.jar, which ships with the Alfresco server)</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN>#db.driver=org.gjt.mm.mysql.Driver</SPAN><BR /><SPAN>#db.url=jdbc:mysql://localhost/alfresco</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN># Oracle connection (requires ojdbc14_g.jar or equivalent jar in shared libraries location)</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN>#db.driver=oracle.jdbc.OracleDriver</SPAN><BR /><SPAN>#db.url=jdbc<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />racle:thin:@localhost:1521:alfresco</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN># Sybase connection (requires jconn2d.jar or equivalent jar in shared libraries location)</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN>#db.driver=com.sybase.jdbc2.jdbc.SybDriver</SPAN><BR /><SPAN>#db.url=jdbc:sybase:Tds:localhost:2638/alfresco</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN># SQLServer connection (requires jdts-1.2.jar or equivalent - </SPAN><A href="http://jtds.sourceforge.net/" rel="nofollow noopener noreferrer">http://jtds.sourceforge.net/</A><SPAN>)</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN>#db.driver=net.sourceforge.jtds.jdbc.Driver</SPAN><BR /><SPAN>#db.url=jdbc:jtds:sqlserver://localhost/alfresco</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN># SQLServer connection using Microsoft JDDB driver</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN>#db.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver</SPAN><BR /><SPAN>#db.url=jdbc:sqlserver://localhost;DatabaseName=alfresco</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN># PostgreSQL connection (requires postgresql-8.2-504.jdbc3.jar or equivalent)</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN>db.driver=org.postgresql.Driver</SPAN><BR /><SPAN>db.url=jdbc<img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />ostgresql://localhost:5432/alfresco</SPAN><BR /><BR /><BR /><SPAN>C:/alfresco/tomcat/shared/classes/alfresco/extension/custom-hibernate-dialect.properties</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN># Sample Hibernate configuration for changing Database dialect</SPAN><BR /><SPAN># For a full list: </SPAN><A href="http://www.hibernate.org/hib_docs/v3/reference/en/html_single/#configuration-optional-dialects" rel="nofollow noopener noreferrer">http://www.hibernate.org/hib_docs/v3/reference/en/html_single/#configuration-optional-dialects</A><BR /><SPAN>#</SPAN><BR /><BR /><SPAN>#</SPAN><BR /><SPAN># HSQL dialect</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN>#hibernate.dialect=org.hibernate.dialect.HSQLDialect</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN># MySQL dialect (default)</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN>#hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN># Oracle dialect</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN>#hibernate.dialect=org.hibernate.dialect.Oracle9Dialect</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN># Sybase dialect</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN>#hibernate.dialect=org.alfresco.repo.domain.hibernate.dialect.AlfrescoSybaseAnywhereDialect</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN># SQLServer dialect</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN>#hibernate.dialect=org.alfresco.repo.domain.hibernate.dialect.AlfrescoSQLServerDialect</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN># PostgreSQL dialect</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN>hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect</SPAN><BR /><SPAN>hibernate.query.substitutions=true TRUE, false FALSE</SPAN><BR /><BR /><BR /><SPAN>C:/Alfresco/tomcat/shared/classes/alfresco/extension/file-server-custom.xml aggiunta la definizione per il server FTP</SPAN><BR /><BR /><SPAN>&lt;alfresco-config area="file-servers"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp; &lt;!– abilitazione server FTP –&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp; &lt;config evaluator="string-compare" condition="FTP Server"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp; &lt;serverEnable enabled="true"/&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp; &lt;port&gt;1121&lt;/port&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp; &lt;/config&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp; &lt;config evaluator="string-compare" condition="Filesystems" replace="true"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;filesystems&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;filesystem name="Alfresco"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;store&gt;workspace://SpacesStore&lt;/store&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;rootPath&gt;/app:company_home&lt;/rootPath&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;!– Add a URL file to each folder that links back to the web client –&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;urlFile&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;filename&gt;__Alfresco.url&lt;/filename&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;webpath&gt;</SPAN><A href="http://${localname}:8080/alfresco/" rel="nofollow noopener noreferrer">http://${localname}:8080/alfresco/</A><SPAN>&lt;/webpath&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/urlFile&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;!– Mark locked files as offline –&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;offlineFiles/&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;!– Desktop actions –&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;desktopActions&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;global&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;path&gt;alfresco/desktop/Alfresco.exe&lt;/path&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;webpath&gt;</SPAN><A href="http://${localname}:8080/alfresco/" rel="nofollow noopener noreferrer">http://${localname}:8080/alfresco/</A><SPAN>&lt;/webpath&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/global&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;action&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;class&gt;org.alfresco.filesys.smb.server.repo.desk.CheckInOutDesktopAction&lt;/class&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;name&gt;CheckInOut&lt;/name&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;filename&gt;__CheckInOut.exe&lt;/filename&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/action&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;action&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;class&gt;org.alfresco.filesys.smb.server.repo.desk.JavaScriptDesktopAction&lt;/class&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;name&gt;JavaScriptURL&lt;/name&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;filename&gt;__ShowDetails.exe&lt;/filename&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;script&gt;alfresco/desktop/showDetails.js&lt;/script&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;attributes&gt;anyFiles&lt;/attributes&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;preprocess&gt;copyToTarget&lt;/preprocess&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/action&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/desktopActions&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/filesystem&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;!– AVM virtualization view of all stores/versions for WCM –&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;avmfilesystem name="AVM"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;virtualView/&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/avmfilesystem&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/filesystems&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp; &lt;/config&gt;</SPAN><BR /><SPAN>&lt;/alfresco-config&gt;</SPAN><BR /><BR /><BR /><BR /><SPAN>Creato in postgres con pgadmin il database alfresco </SPAN><BR /><SPAN>CREATE DATABASE alfresco</SPAN><BR /><SPAN>&nbsp; WITH OWNER = postgres</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ENCODING = 'UTF8'</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLESPACE = pg_default</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LC_COLLATE = 'Italian, Italy'</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LC_CTYPE = 'Italian, Italy'</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CONNECTION LIMIT = -1;</SPAN><BR /><BR /><BR /><BR /><SPAN>Una volta configurato i file ho inserito nella directory C:\alfresco\tomcat\common\lib l driver postgresql-8.2-504.jdbc3.jar</SPAN><BR /><SPAN>(Ho anche provato con il dirver postgresql-8.3-603.jdbc3.jar ma il problema è uguale </SPAN><BR /><SPAN>Con la libreria postgresql-9.0-801.jdbc4.jar non popola nemmeno il database.</SPAN><BR /><BR /><SPAN> </SPAN><BR /><SPAN>Cancellato completamente la cartella alf_data che viene sostituita con la cartella data configurata&nbsp; nel file custom-repository.properties</SPAN><BR /><SPAN> </SPAN><BR /><SPAN> </SPAN><BR /><SPAN>All'avvio del servizio di alfresco con alf_start.bat il database alfresco viene popolato ma il dervizio non parte.</SPAN><BR /><SPAN>Mi da il seguente alfresco.log:</SPAN><BR /><BR /><SPAN>11:34:45,181 WARN&nbsp; [org.springframework.remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI registry - creating new one</SPAN><BR /><SPAN>11:34:48,613 WARN&nbsp; [org.alfresco.util.OpenOfficeConnectionTester] A connection to OpenOffice could not be established.</SPAN><BR /><SPAN>11:34:54,572 INFO&nbsp; [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.PostgreSQLDialect.</SPAN><BR /><SPAN>11:34:54,728 INFO&nbsp; [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script C:\alfresco\tomcat\temp\Alfresco\AlfrescoSchemaCreate-org.hibernate.dialect.PostgreSQLDialect-7594952547763709728.sql (Generated).</SPAN><BR /><SPAN>11:35:03,683 INFO&nbsp; [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script C:\alfresco\tomcat\temp\Alfresco\AlfrescoSchemaUpdate-org.hibernate.dialect.PostgreSQLDialect-6410981750726339490.sql (Copied from classpath:alfresco/dbscripts/create/2.1/org.hibernate.dialect.PostgreSQLDialect/AlfrescoPostCreate-2.1-FKIndexes.sql).</SPAN><BR /><SPAN>11:35:05,804 INFO&nbsp; [org.alfresco.repo.domain.schema.SchemaBootstrap] All executed statements written to file C:\alfresco\tomcat\temp\Alfresco\AlfrescoSchemaUpdate-All_Statements-7539457490348660135.sql.</SPAN><BR /><SPAN>11:35:58,860 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed</SPAN><BR /><SPAN>org.hibernate.type.SerializationException: could not deserialize</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.util.SerializationHelper.deserialize(SerializationHelper.java:217)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.util.SerializationHelper.deserialize(SerializationHelper.java:240)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.type.SerializableType.fromBytes(SerializableType.java:82)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.type.SerializableType.get(SerializableType.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:113)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:102)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.type.AbstractType.hydrate(AbstractType.java:81)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.type.ComponentType.hydrate(ComponentType.java:560)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.type.ComponentType.nullSafeGet(ComponentType.java:275)</SPAN><BR /><SPAN>……</SPAN><BR /><SPAN>…..</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)</SPAN><BR /><SPAN>Caused by: java.io.StreamCorruptedException: invalid stream header: BB656430</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:783)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.io.ObjectInputStream.&lt;init&gt;(ObjectInputStream.java:280)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.util.SerializationHelper$CustomObjectInputStream.&lt;init&gt;(SerializationHelper.java:252)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.util.SerializationHelper.deserialize(SerializationHelper.java:209)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 86 more</SPAN><BR /><SPAN>11:35:59,140 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener</SPAN><BR /><SPAN>org.hibernate.type.SerializationException: could not deserialize</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.util.SerializationHelper.deserialize(SerializationHelper.java:217)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.util.SerializationHelper.deserialize(SerializationHelper.java:240)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.type.SerializableType.fromBytes(SerializableType.java:82)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.type.SerializableType.get(SerializableType.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:113)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:102)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.type.AbstractType.hydrate(AbstractType.java:81)</SPAN><BR /><SPAN>………..</SPAN><BR /><SPAN>……….</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)</SPAN><BR /><SPAN>Caused by: java.io.StreamCorruptedException: invalid stream header: BB656430</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:783)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.io.ObjectInputStream.&lt;init&gt;(ObjectInputStream.java:280)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.util.SerializationHelper$CustomObjectInputStream.&lt;init&gt;(SerializationHelper.java:252)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.util.SerializationHelper.deserialize(SerializationHelper.java:209)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 86 more</SPAN><BR /><SPAN>11:35:59,374 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] Exception sending context initialized event to listener instance of class org.alfresco.web.app.ContextListener</SPAN><BR /><SPAN>org.hibernate.type.SerializationException: could not deserialize</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.util.SerializationHelper.deserialize(SerializationHelper.java:217)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.util.SerializationHelper.deserialize(SerializationHelper.java:240)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.type.SerializableType.fromBytes(SerializableType.java:82)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.type.SerializableType.get(SerializableType.java:39)</SPAN><BR /><SPAN>…….</SPAN><BR /><SPAN>…….</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)</SPAN><BR /><SPAN>Caused by: java.io.StreamCorruptedException: invalid stream header: BB656430</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:783)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.io.ObjectInputStream.&lt;init&gt;(ObjectInputStream.java:280)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.util.SerializationHelper$CustomObjectInputStream.&lt;init&gt;(SerializationHelper.java:252)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.util.SerializationHelper.deserialize(SerializationHelper.java:209)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 86 more</SPAN><BR /><BR /><BR /><SPAN>Aiutatemi non so più dove sbattere la testa e dove andare a guardare</SPAN></BODY></HTML> Fri, 27 May 2011 13:36:03 GMT giuseppe 2011-05-27T13:36:03Z ALFRESCO 2.1 POSTGRES 9.0 PROBLEMI ALL'AVVIO https://connect.hyland.com/t5/alfresco-archive/alfresco-2-1-postgres-9-0-problemi-all-avvio/m-p/28645#M14563 Buongiorno,stò cercando di installare Alfresco 2.1 ma non riesco a farlo avviare.Versioni che uso<IMG id="smileytongue" class="emoticon emoticon-smileytongue" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />ostgres 9.0Cmdbuild 1.3.1.0jdk1.6.0_16Tomcat 6.0Ho scompattato il alfresco-tomcat-2.1.0.zip sotto C:/alfrescoConfigurazioni di alfresco:C:/alfresco/tomcat/conf/server.xml (ho tolto le righe commentate) Fri, 27 May 2011 13:36:03 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-2-1-postgres-9-0-problemi-all-avvio/m-p/28645#M14563 giuseppe 2011-05-27T13:36:03Z Re: ALFRESCO 2.1 POSTGRES 9.0 PROBLEMI ALL'AVVIO https://connect.hyland.com/t5/alfresco-archive/alfresco-2-1-postgres-9-0-problemi-all-avvio/m-p/28646#M14564 <HTML><HEAD></HEAD><BODY><SPAN>Sembra un problema derivante dal fatto che il repository si è corrotto, forse a causa di un cambiamento di configurazione in seguito ad un secondo avvio.</SPAN><BR /><BR /><SPAN>Io proverei a cancellare il db e la alf_data per far ripartire Alfresco da zero.</SPAN><BR /><BR /><SPAN>Suggerirei di utilizzare l'ultima versione Community di Alfresco che è disponibile a questo indirizzo:</SPAN><BR /><A href="http://wiki.alfresco.com/wiki/Download_Community_Edition" rel="nofollow noopener noreferrer">http://wiki.alfresco.com/wiki/Download_Community_Edition</A><BR /><BR /><SPAN>Spero ti possa aiutare&nbsp; <img id="smileywink" class="emoticon emoticon-smileywink" src="https://connect.hyland.com/i/smilies/16x16_smiley-wink.png" alt="Smiley Wink" title="Smiley Wink" /></SPAN></BODY></HTML> Fri, 27 May 2011 13:52:46 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-2-1-postgres-9-0-problemi-all-avvio/m-p/28646#M14564 openpj 2011-05-27T13:52:46Z Re: ALFRESCO 2.1 POSTGRES 9.0 PROBLEMI ALL'AVVIO https://connect.hyland.com/t5/alfresco-archive/alfresco-2-1-postgres-9-0-problemi-all-avvio/m-p/28647#M14565 <HTML><HEAD></HEAD><BODY><SPAN>Ciao, purtroppo l'ho già fatto. Ho sia cancellato alf_data e sostituito con una nuovo reèpository vuoto che viene creato automaticamente dopo le opportune configurazioni (precisamente in C:/alfresco/data) e cancellato e ricreato il db, ma niente.</SPAN><BR /><SPAN>Non posso installare una versione di Alfresco più recente perchè cmdbuild lavora solo con Alfresco 2.1.</SPAN></BODY></HTML> Fri, 27 May 2011 14:19:21 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-2-1-postgres-9-0-problemi-all-avvio/m-p/28647#M14565 giuseppe 2011-05-27T14:19:21Z Re: ALFRESCO 2.1 POSTGRES 9.0 PROBLEMI ALL'AVVIO https://connect.hyland.com/t5/alfresco-archive/alfresco-2-1-postgres-9-0-problemi-all-avvio/m-p/28648#M14566 <HTML><HEAD></HEAD><BODY><SPAN>Se ti può essere di aiuto:</SPAN><BR /><BR /><A href="http://wiki.alfresco.com/wiki/Database_Configuration#PostgreSQL_example" rel="nofollow noopener noreferrer">http://wiki.alfresco.com/wiki/Database_Configuration#PostgreSQL_example</A><BR /><BR /><SPAN>Io controllerei anche le versioni dei software utilizzati (Postgres - Alfresco).</SPAN></BODY></HTML> Mon, 30 May 2011 19:13:40 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-2-1-postgres-9-0-problemi-all-avvio/m-p/28648#M14566 maverik 2011-05-30T19:13:40Z Re: ALFRESCO 2.1 POSTGRES 9.0 PROBLEMI ALL'AVVIO https://connect.hyland.com/t5/alfresco-archive/alfresco-2-1-postgres-9-0-problemi-all-avvio/m-p/28649#M14567 <HTML><HEAD></HEAD><BODY><SPAN>Dubito che una versione così vecchia di Alfresco possa funzionare così com'è con una versione così nuova di PostgreSQL, tra i due prodotti ci sono anni di distanza.</SPAN></BODY></HTML> Tue, 31 May 2011 07:45:47 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-2-1-postgres-9-0-problemi-all-avvio/m-p/28649#M14567 mturatti 2011-05-31T07:45:47Z