topic Re: Alfresco Community y Oracle in Alfresco Archive

Alfresco Community y Oracle

pps — Thu, 17 Nov 2011 11:36:25 GMT

HolaEstoy instalando Alfreco Community y quiero utilizar como Base de datos Oracle.He probado con la version 3.4 y tambien con la 4.0 y no lo consigo.Si utilizo mysql (tanto la embebida como una externa) no hay problemas, pero con oracle, alfresco no arranca.He copiado la libreria ojdbc14.jar en la

Re: Alfresco Community y Oracle

cristinamr — Thu, 17 Nov 2011 22:55:18 GMT

Buenas.

No deberías tener problema. Mete ojdbc14.jar dentro de tomcat/lib y en tu alfresco-global.properties pon una referencia a esa BBDD. Por ejemplo, imagina que crear una BBDD que se llama alfresco342, deberías poner algo como esto:

### database connection properties ###
db.username=alfresco342
db.password=alfresco342
db.name=alfresco342
db.host=localhost
db.port=3333
db.driver=oracle.jdbc.OracleDriver
db.url=jdbc:oracle:thin:@localhost:1521:xe
hibernate.default_schema=ALFRESCO342‍‍‍‍‍‍‍‍‍

Importante, especifica el esquema porque sino te dará problemas al arrancar.

Prueba y nos cuentas

Un saludo.

Re: Alfresco Community y Oracle

pps — Fri, 18 Nov 2011 10:00:42 GMT

Gracias Cristina

La configuracion creo que la tengo bien porque con ella puedo utilizar la version enterprise (trial) sin problemas.

Debe de ser algo relacionado con la version community y no se si existe alguna solucion

Re: Alfresco Community y Oracle

cristinamr — Fri, 18 Nov 2011 10:08:30 GMT

¡Anda! No sé por qué pero pensé que comentaba Enterprise. La community "por defecto" no trae compatibilidad con Oracle peeeeero, hay un proyecto en la forja de Alfresco que podrías ojear, creo que te lo soluciona :wink:

Comentame si te funciona ¿vale?

¡Un saludo!

Re: Alfresco Community y Oracle

pps — Fri, 18 Nov 2011 13:20:41 GMT

Gracias de nuevo

He revisado el parche pero tiene algunas restricciones impoprtantes. Basicamente este parche sirve para la version 3.4a y solo para la version en ingles.

Cuando tenga tiempo lo probare… y si consigo que funcione os lo cuento

Re: Alfresco Community y Oracle

cristinamr — Sat, 19 Nov 2011 19:56:19 GMT

Ojea este enlace. Creo que te puede servir de ayuda

Re: Alfresco Community y Oracle

pps — Mon, 21 Nov 2011 17:21:08 GMT

Por fin he conseguido que Alfresco Community se conecte y utilice Oracle

Os voy a contar como lo he conseguido aunque no estoy muy seguro de que solamente pueda hacerse asi o de que esta sea la mejor manera. Por eso no creo que sea necesario seguir esta receta al pie de la letra.

Tampoco se por que he tenido que seguir un camino erratico y abusar del metodo de prueba/error para conseguirlo. La verdad es que hay bastantes cosas que se me escapan del funcionaminto interno de alfresco y esta debe ser la razon.

Por ahora solamente he hecho algunas pruebas ligeras con la nueva instalacion. Espero que sea estable y no haya problemas cuando comenzemos a hacer un uso intensivo de la misma.

1) Descargar la version 3.4.d (no he probado con otras releases)

https://process.alfresco.com/ccdl/?file=release/community/build-3370/alfresco-community-3.4.d-installer-linux-x64.bin

2) Hacer la instalacion:

chmod +x alfresco-community-3.4.d-installer-linux-x64.bin
./alfresco-community-3.4.d-installer-linux-x64.bin
‍‍‍

Instalamos en /opt/alfresco-3.4.d

Contestar a todo con Yes y optar por la opcion de usar una bases de datos mysql externa (para evitar que instale el mysql enbebido.

3) incluir soporte para oracle

a) copiar el driver de oracle (ojdbc14.jar o similar) en /opt/alfresco-community-3.4.d/tomcat/lib

b) descargar el "parche" para incluir soporte en oracle http://forge.alfresco.com/frs/download.php/1041/oracle-alfresco-3.4_a.amp

c) modificar el alfresco.war con este parche:

java -jar /opt/alfresco-3.4.d/bin/alfresco-mmt.jar install /root/oracle-alfresco-3-1.4_a.amp /opt/alfresco-3.4.d/tomcat/webapps/alfresco.war‍

Para esto he usado un java 1.6, pero con la 1.5 tambien funciona.

Ahora en /opt/alfresco-3.4.d/tomcat/webapps/ tendremos una copia del antiguo alfresco.war y el nuevo alfresco.war que se desplegara al arrancar

4) Configurar la base de datos

Creamos un nuevo esquema en la base de datos oracle que vayamos autilizar. Para ello nos conectamos como SYSTEM a oracle.

sqlplus SYSTEM/<password>@<host>:1521/<sid>

sqlplus>CREATE USER alfresco IDENTIFIED BY <pasword> DEFAULT TABLESPACE USERS ACCOUNT UNLOCK;
sqlplus> GRANT ALL PRIVILEGES TO alfresco;

Seguramente con menos privilegios tambien es suficiente

5) Configuramos alfresco para acceso al Oracle

vi /opt/alfresco-3.4.d/tomcat/shared/classes/alfresco-global.properties

db.driver=oracle.jdbc.OracleDriver
db.username=alfresco
db.password=<password>
db.name=alfresco
db.url=jdbcracle:thin:@<host>:1521:<sid-id>

db.pool.validate.query=SELECT 1 FROM DUAL
hibernate.default_schema=ALFRESCO
#hibernate.show_sql=true

6) Arrancamos con la nueva configuracion

/etc/init.d/alfresco start

En /opt/alfresco-3.4.d/alfresco.log podenos ir viendo como va el proceso de arranque.

Si todo va bien, al terminar en la base de datso se habran crado un monton de tablas y ya podremos acceder a la web de alfresco

Este es el log que ha dejado mi instalacion:

16:08:11,110 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/repository.properties]
16:08:11,112 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/domain/transaction.properties]
16:08:11,112 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from file [/opt/alfresco-3.4.d/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/module/org_alfresco_module_wcmquickstart/alfresco-global.properties]
16:08:11,112 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from file [/opt/alfresco-3.4.d/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/module/test/alfresco-global.properties]
16:08:11,112 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from file [/opt/alfresco-3.4.d/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/module/org_alfresco_module_dod5015/alfresco-global.properties]
16:08:11,113 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from file [/opt/alfresco-3.4.d/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/module/tests/alfresco-global.properties]
16:08:11,113 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from URL [file:/opt/alfresco-3.4.d/tomcat/shared/classes/alfresco-global.properties]
16:08:11,157 INFO  [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
16:08:11,266 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/version.properties]
16:08:11,294 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/domain/cache-strategies.properties]
16:08:11,316 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/module/org.alfresco.module.vti/context/vti.properties]
16:08:11,316 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from URL [file:/opt/alfresco-3.4.d/tomcat/shared/classes/alfresco/extension/custom-vti.properties]
16:08:23,945 WARN  [org.springframework.beans.GenericTypeAwarePropertyDescriptor] Invalid JavaBean property 'serviceBeans' being accessed! Ambiguous write methods found next to actually used [public void org.apache.cxf.jaxrs.JAXRSServerFactoryBean.setServiceBeans(java.util.List)]: [public void org.apache.cxf.jaxrs.JAXRSServerFactoryBean.setServiceBeans(java.lang.Object[])]
16:08:24,431 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor Repository Template Processor for extension ftl
16:08:24,433 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor Repository Script Processor for extension js
16:08:28,383 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect.
16:08:28,622 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/alfresco-3.4.d/tomcat/temp/Alfresco/AlfrescoSchema-AlfrescoOracle9Dialect-Update-6641162782149294266.sql (Copied from classpath:alfresco/dbscripts/create/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/AlfrescoCreate-RepoTables.sql).
16:08:31,379 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/alfresco-3.4.d/tomcat/temp/Alfresco/AlfrescoSchema-AlfrescoOracle9Dialect-Update-1118159703802842659.sql (Copied from classpath:alfresco/dbscripts/create/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/AlfrescoCreate-LockTables.sql).
16:08:31,749 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/alfresco-3.4.d/tomcat/temp/Alfresco/AlfrescoSchema-AlfrescoOracle9Dialect-Update-4962923189842346312.sql (Copied from classpath:alfresco/dbscripts/create/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/AlfrescoCreate-ContentTables.sql).
16:08:32,000 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/alfresco-3.4.d/tomcat/temp/Alfresco/AlfrescoSchema-AlfrescoOracle9Dialect-Update-72461855472599352.sql (Copied from classpath:alfresco/dbscripts/create/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/AlfrescoCreate-PropertyValueTables.sql).
16:08:32,615 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/alfresco-3.4.d/tomcat/temp/Alfresco/AlfrescoSchema-AlfrescoOracle9Dialect-Update-1851569391090534691.sql (Copied from classpath:alfresco/dbscripts/create/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/AlfrescoCreate-AuditTables.sql).
16:08:32,816 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/alfresco-3.4.d/tomcat/temp/Alfresco/AlfrescoSchema-AlfrescoOracle9Dialect-Update-5737067017740183306.sql (Copied from classpath:alfresco/dbscripts/create/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/AlfrescoCreate-AvmTables.sql).
16:08:34,320 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/alfresco-3.4.d/tomcat/temp/Alfresco/AlfrescoSchema-AlfrescoOracle9Dialect-Update-1927927157902670668.sql (Copied from classpath:alfresco/dbscripts/create/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/AlfrescoCreate-ActivityTables.sql).
16:08:34,652 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/alfresco-3.4.d/tomcat/temp/Alfresco/AlfrescoSchema-AlfrescoOracle9Dialect-Update-1333994687735617308.sql (Copied from classpath:alfresco/dbscripts/create/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/AlfrescoCreate-UsageTables.sql).
16:08:35,519 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/alfresco-3.4.d/tomcat/temp/Alfresco/AlfrescoSchema-AlfrescoOracle9Dialect-Update-1330092427540936561.sql (Generated).
16:08:38,274 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/alfresco-3.4.d/tomcat/temp/Alfresco/AlfrescoSchema-AlfrescoOracle9Dialect-Update-6211734035704149527.sql (Copied from classpath:alfresco/dbscripts/create/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect/AlfrescoPostCreate-JBPM-Extra.sql).
16:08:38,284 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] All executed statements:  /opt/alfresco-3.4.d/tomcat/temp/Alfresco/AlfrescoSchema-AlfrescoOracle9Dialect-All_Statements-6578626645512991775.sql.
16:08:59,095 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Normalized schema dumped to file /opt/alfresco-3.4.d/tomcat/temp/Alfresco/AlfrescoSchema-AlfrescoOracle9Dialect-5852303028453209730.xml.
16:08:59,104 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default]
16:08:59,117 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/version.properties]
16:08:59,117 INFO  [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
16:08:59,118 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/domain/cache-strategies.properties]
16:08:59,118 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/module/org.alfresco.module.vti/context/vti.properties]
16:08:59,118 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from URL [file:/opt/alfresco-3.4.d/tomcat/shared/classes/alfresco/extension/custom-vti.properties]
16:08:59,170 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'sysAdmin' subsystem, ID: [sysAdmin, default] complete
16:08:59,272 WARN  [org.alfresco.repo.dictionary.DictionaryRepositoryBootstrap] StoreRef 'workspace://SpacesStore' does not exist
16:09:00,578 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'thirdparty' subsystem, ID: [thirdparty, default]
16:09:00,592 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/version.properties]
16:09:00,593 INFO  [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
16:09:00,594 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/domain/cache-strategies.properties]
16:09:00,594 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/module/org.alfresco.module.vti/context/vti.properties]
16:09:00,594 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from URL [file:/opt/alfresco-3.4.d/tomcat/shared/classes/alfresco/extension/custom-vti.properties]
16:09:00,783 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'thirdparty' subsystem, ID: [thirdparty, default] complete
16:09:00,784 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'OOoDirect' subsystem, ID: [OOoDirect, default]
16:09:00,797 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/version.properties]
16:09:00,798 INFO  [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
16:09:00,798 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/domain/cache-strategies.properties]
16:09:00,798 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/module/org.alfresco.module.vti/context/vti.properties]
16:09:00,798 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from URL [file:/opt/alfresco-3.4.d/tomcat/shared/classes/alfresco/extension/custom-vti.properties]
16:09:01,024 WARN  [org.alfresco.util.OpenOfficeConnectionTester] An initial OpenOffice connection could not be established.
16:09:01,038 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'OOoDirect' subsystem, ID: [OOoDirect, default] complete
16:09:13,743 INFO  [org.alfresco.repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: /opt/alfresco-3.4.d/alf_data
16:09:13,764 INFO  [org.alfresco.repo.admin.patch.PatchExecuter] Checking for patches to apply …
16:09:15,754 INFO  [org.alfresco.repo.admin.patch.PatchExecuter]    Applying patch 'patch.wcmFolders' (Ensures the existance of the WCM specific 'Web Projects' and 'Web Forms' folders.).
16:09:16,039 INFO  [org.alfresco.repo.admin.patch.PatchExecuter]    Applying patch 'patch.wcmDeployed' (null).
16:09:16,059 WARN  [org.alfresco.repo.admin.patch.PatchExecuter] Patch description is not available: Patch[ id=patch.wcmDeployed, description=patch.wcmDeployed.description, fixesFromSchema=0, fixesToSchema=4113, targetSchema=10000]
16:09:16,312 INFO  [org.alfresco.repo.admin.patch.PatchExecuter] 
=== Applied patch                 === 
ID: patch.db-V3.4-UsageTables
RESULT: 
Script completed
=====================================
16:09:16,312 INFO  [org.alfresco.repo.admin.patch.PatchExecuter] 
=== Applied patch                 === 
ID: patch.db-V3.0-ActivityTables
RESULT: 
Script completed
=====================================
16:09:16,312 INFO  [org.alfresco.repo.admin.patch.PatchExecuter] 
=== Applied patch                 === 
ID: patch.db-V3.2-LockTables
RESULT: 
Script completed
=====================================
16:09:16,312 INFO  [org.alfresco.repo.admin.patch.PatchExecuter] 
=== Applied patch                 === 
ID: patch.db-V3.2-ContentTables
RESULT: 
Script completed
=====================================
16:09:16,313 INFO  [org.alfresco.repo.admin.patch.PatchExecuter] 
=== Applied patch                 === 
ID: patch.db-V3.2-PropertyValueTables
RESULT: 
Script completed
=====================================
16:09:16,313 INFO  [org.alfresco.repo.admin.patch.PatchExecuter] 
=== Applied patch                 === 
ID: patch.db-V3.2-AuditTables
RESULT: 
Script completed
=====================================
16:09:16,313 INFO  [org.alfresco.repo.admin.patch.PatchExecuter] 
=== Applied patch                 === 
ID: patch.db-V3.2-AvmTables
RESULT: 
Script completed
=====================================
16:09:16,313 INFO  [org.alfresco.repo.admin.patch.PatchExecuter] 
=== Applied patch                 === 
ID: patch.db-V3.3-JBPM-Extra
RESULT: 
Script completed
=====================================
16:09:16,313 INFO  [org.alfresco.repo.admin.patch.PatchExecuter] 
=== Applied patch                 === 
ID: patch.wcmFolders
RESULT: 
The Web Projects folder was successfully created: workspace://SpacesStore/07fcbe01-5377-4c3d-8ca5-54d26344c097
The Web Forms folder was successfully created: workspace://SpacesStore/07fcbe01-5377-4c3d-8ca5-54d26344c097
=====================================
16:09:16,313 INFO  [org.alfresco.repo.admin.patch.PatchExecuter] 
=== Applied patch                 === 
ID: patch.wcmDeployed
RESULT: 
Imported view into bootstrap location: /app:company_home (workspace://SpacesStore/460a1e17-8c50-427e-9034-2b48276a784b)
=====================================
16:09:16,327 INFO  [org.alfresco.repo.module.ModuleServiceImpl] Found 5 module(s).
16:09:16,380 INFO  [org.alfresco.repo.module.ModuleServiceImpl] Installing module 'org_alfresco_module_wcmquickstart' version 1.0.
16:09:16,426 INFO  [org.alfresco.repo.module.ModuleServiceImpl] Installing module 'org_alfresco_module_dod5015' version 1.0.
16:09:16,659 INFO  [org.alfresco.repo.module.ModuleServiceImpl] Installing module 'org.alfresco.module.vti' version 1.2.
16:09:16,691 INFO  [org.alfresco.repo.module.ModuleServiceImpl] Installing module 'Oracle.for.Alfresco.3.4.a.Community' version 1.0.
16:09:16,723 INFO  [org.alfresco.repo.module.ModuleServiceImpl] Installing module 'org.alfresco.module.quickr' version 1.0.
16:09:17,400 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'fileServers' subsystem, ID: [fileServers, default]
16:09:17,416 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/version.properties]
16:09:17,417 INFO  [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
16:09:17,417 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/domain/cache-strategies.properties]
16:09:17,418 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/module/org.alfresco.module.vti/context/vti.properties]
16:09:17,418 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from URL [file:/opt/alfresco-3.4.d/tomcat/shared/classes/alfresco/extension/custom-vti.properties]
16:09:17,628 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'Authentication' subsystem, ID: [Authentication, managed, alfrescoNtlm1]
16:09:17,639 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/version.properties]
16:09:17,639 INFO  [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
16:09:17,639 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/domain/cache-strategies.properties]
16:09:17,639 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/module/org.alfresco.module.vti/context/vti.properties]
16:09:17,639 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from URL [file:/opt/alfresco-3.4.d/tomcat/shared/classes/alfresco/extension/custom-vti.properties]
16:09:17,795 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'Authentication' subsystem, ID: [Authentication, managed, alfrescoNtlm1] complete
16:09:22,811 ERROR [org.alfresco.fileserver] Failed to get local domain/workgroup name, using default of WORKGROUP
16:09:22,811 ERROR [org.alfresco.fileserver] (This may be due to firewall settings or incorrect <broadcast> setting)
16:09:22,908 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'fileServers' subsystem, ID: [fileServers, default] complete
16:09:22,908 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'imap' subsystem, ID: [imap, default]
16:09:22,921 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/version.properties]
16:09:22,921 INFO  [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
16:09:22,922 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/domain/cache-strategies.properties]
16:09:22,922 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/module/org.alfresco.module.vti/context/vti.properties]
16:09:22,922 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from URL [file:/opt/alfresco-3.4.d/tomcat/shared/classes/alfresco/extension/custom-vti.properties]
16:09:22,985 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'imap' subsystem, ID: [imap, default] complete
16:09:22,985 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'email' subsystem, ID: [email, outbound]
16:09:22,996 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/version.properties]
16:09:22,997 INFO  [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
16:09:22,997 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/domain/cache-strategies.properties]
16:09:22,998 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/module/org.alfresco.module.vti/context/vti.properties]
16:09:22,998 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from URL [file:/opt/alfresco-3.4.d/tomcat/shared/classes/alfresco/extension/custom-vti.properties]
16:09:23,047 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'email' subsystem, ID: [email, outbound] complete
16:09:23,047 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'email' subsystem, ID: [email, inbound]
16:09:23,055 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/version.properties]
16:09:23,056 INFO  [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
16:09:23,056 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/domain/cache-strategies.properties]
16:09:23,056 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/module/org.alfresco.module.vti/context/vti.properties]
16:09:23,056 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from URL [file:/opt/alfresco-3.4.d/tomcat/shared/classes/alfresco/extension/custom-vti.properties]
16:09:23,083 WARN  [org.springframework.beans.GenericTypeAwarePropertyDescriptor] Invalid JavaBean property 'blockedSenders' being accessed! Ambiguous write methods found next to actually used [public void org.alfresco.email.server.EmailServer.setBlockedSenders(java.util.List)]: [public void org.alfresco.email.server.EmailServer.setBlockedSenders(java.lang.String)]
16:09:23,083 WARN  [org.springframework.beans.GenericTypeAwarePropertyDescriptor] Invalid JavaBean property 'allowedSenders' being accessed! Ambiguous write methods found next to actually used [public void org.alfresco.email.server.EmailServer.setAllowedSenders(java.util.List)]: [public void org.alfresco.email.server.EmailServer.setAllowedSenders(java.lang.String)]
16:09:23,129 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'email' subsystem, ID: [email, inbound] complete
16:09:23,130 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'googledocs' subsystem, ID: [googledocs, default]
16:09:23,146 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/version.properties]
16:09:23,146 INFO  [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
16:09:23,146 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/domain/cache-strategies.properties]
16:09:23,146 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/module/org.alfresco.module.vti/context/vti.properties]
16:09:23,147 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from URL [file:/opt/alfresco-3.4.d/tomcat/shared/classes/alfresco/extension/custom-vti.properties]
16:09:23,355 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'googledocs' subsystem, ID: [googledocs, default] complete
16:09:23,355 INFO  [org.alfresco.repo.usage.UserUsageTrackingComponent] Enabled - calculate missing user usages …
16:09:23,422 INFO  [org.alfresco.repo.usage.UserUsageTrackingComponent] Found 0 users to recalculate
16:09:23,423 INFO  [org.alfresco.repo.usage.UserUsageTrackingComponent] … calculated missing usages for 0 users
16:09:23,423 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'Synchronization' subsystem, ID: [Synchronization, default]
16:09:23,545 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/version.properties]
16:09:23,554 INFO  [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
16:09:23,554 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/domain/cache-strategies.properties]
16:09:23,554 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/module/org.alfresco.module.vti/context/vti.properties]
16:09:23,554 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from URL [file:/opt/alfresco-3.4.d/tomcat/shared/classes/alfresco/extension/custom-vti.properties]
16:09:23,720 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'Synchronization' subsystem, ID: [Synchronization, default] complete
16:09:23,746 INFO  [org.alfresco.service.descriptor.DescriptorService] Alfresco JVM - v1.6.0_18-b07; maximum heap size 682,688MB
16:09:23,746 INFO  [org.alfresco.service.descriptor.DescriptorService] Alfresco started (Community): Current version 3.4.0 (d 3370) schema 4113 - Originally installed version 3.4.0 (d 3370) schema 4113
16:09:23,748 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'Replication' subsystem, ID: [Replication, default]
16:09:23,785 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/version.properties]
16:09:23,787 INFO  [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
16:09:23,787 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/domain/cache-strategies.properties]
16:09:23,787 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/module/org.alfresco.module.vti/context/vti.properties]
16:09:23,787 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from URL [file:/opt/alfresco-3.4.d/tomcat/shared/classes/alfresco/extension/custom-vti.properties]
16:09:23,799 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'Replication' subsystem, ID: [Replication, default] complete
16:09:35,491 INFO  [org.alfresco.module.vti.VtiServer] Vti server started successfully on port: 7070
16:09:48,398 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 449 Web Scripts (+0 failed), 700 URLs
16:09:48,398 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 2 Package Description Documents (+0 failed) 
16:09:48,398 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 1 Schema Description Documents (+0 failed) 
16:09:48,401 INFO  [org.springframework.extensions.webscripts.AbstractRuntimeContainer] Initialised Repository Web Script Container (in 9986.998ms)
16:09:48,410 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
16:09:48,412 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
16:09:48,587 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'wcm_deployment_receiver' subsystem, ID: [wcm_deployment_receiver, default]
16:09:48,606 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/version.properties]
16:09:48,606 INFO  [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
16:09:48,606 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/domain/cache-strategies.properties]
16:09:48,607 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/module/org.alfresco.module.vti/context/vti.properties]
16:09:48,607 INFO  [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from URL [file:/opt/alfresco-3.4.d/tomcat/shared/classes/alfresco/extension/custom-vti.properties]
16:09:48,666 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'wcm_deployment_receiver' subsystem, ID: [wcm_deployment_receiver, default] complete
16:09:52,935 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 309 Web Scripts (+0 failed), 319 URLs
16:09:52,936 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 8 Package Description Documents (+0 failed) 
16:09:52,936 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 0 Schema Description Documents (+0 failed) 
16:09:53,130 INFO  [org.springframework.extensions.webscripts.AbstractRuntimeContainer] Initialised Spring Surf Container Web Script Container (in 1179.955ms)
16:09:53,156 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
16:09:53,208 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
16:09:53,293 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
16:09:53,296 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
16:09:53,405 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
16:09:53,408 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Alfresco Community y Oracle

cristinamr — Mon, 21 Nov 2011 17:32:23 GMT

Entonces, ¿con el proyecto d ela sourceforge al final te sirvió no? Bueno es saberlo porque pensaba qe no funcionaría con vesiones más recientes! :mrgreen:

Un saludo y me alegro que lo consiguieras echar a andar tan pronto ^^

Re: Alfresco Community y Oracle

pps — Tue, 22 Nov 2011 13:04:16 GMT

Los parches del sourceforge funcionan aunque no se valorar la estabilidad que pueden tener y los problemas que pueden dar al usarlos con una version ligeramnete diferente.

Por esta razon y porque pienso utilizarlo para un servicio critico (por esto el interes por utilizar oracle en vez de mysql) me gustaria saber si alguien tiene expericia en ello.

Los comentarios que he visto se refieren mas a cómo instalar y configurar que a valorar su comportamiento "en explotacion"

Un saludo y gracias por tus comentarios, Cristina

Re: Alfresco Community y Oracle

cristinamr — Tue, 22 Nov 2011 13:32:39 GMT

Pues he visto muchas instalaciones similares pero sobre Alfresco Enterprise y funcionaban correctamente.
Igualmente, siempre te queda el hacerle pruebas de estrés con la ayuda del jmeter. Quizás con la ayuda de esta herramienta puedas comprobar el comportamiento de ese alfresco community contra oracle.

¡Un saludo!

Re: Alfresco Community y Oracle

rubia69 — Tue, 22 Nov 2011 15:20:00 GMT

gracias por el link Cristina, muy útil!

Re: Alfresco Community y Oracle

cristinamr — Fri, 25 Nov 2011 13:26:59 GMT

Los comentarios que he visto se refieren mas a cómo instalar y configurar que a valorar su comportamiento "en explotacion"

Ya encontré una referencia: Esta semana estoy un curso y uno de los asistentes me confirmó que su empresa trabaja solo con communitys y tiene varias instalaciones "gordas" con Oracle + parches y que funciona perfectamente.

Un saludo.

Re: Alfresco Community y Oracle

ecalle — Tue, 20 Mar 2012 17:28:05 GMT

Si han realizado pruebas con el jmeter podrian responderme porfavor que tal es el performance de la app alfresco con el uso de Oracle.

Gracias de Antemano.

Re: Alfresco Community y Oracle

cristinamr — Wed, 21 Mar 2012 07:38:33 GMT

Desconozco si alguien las ha hecho, pero te animo ecalle a que las hagas tu mismo y las compartas en la comunidad! Sin duda alguna sería un gran aporte.

Te recomiendo este post del usuario @fegorama como puto de partida (es el que puse más arriba).

¡¡Un saludo!!

PD: De todas formas a finales del año pasado conocí a un hombre que tenía puesto en PRO community + oracle y me comentó que le iba todo correcto. Por si sirve de algo 😃

Re: Alfresco Community y Oracle

ecalle — Mon, 26 Mar 2012 17:10:41 GMT

Hola quisiera hacer las pruebas con el jmeter, pero hay un detalle como puedo instalar alfresco Community y base de datos oracle si tuvieran esa documentación que me puedan proporcionar para saber como hacerlo, pues la verdad estoy intentando instalar Alfresco Comunity y oracle en un servidor windows y la verdad no encuentro información de como hacerlo, he visto que rubia69 recibio una informacion de CristinaMR enviandole información de como hacerlo aver si me pueden ayudar por favor.

Gracias de Antemano.

Atte.
Edwin

Re: Alfresco Community y Oracle

cristinamr — Tue, 27 Mar 2012 07:43:13 GMT

En la wiki tienes lo que necesitas! Ojea está página.

¡Un saludo!

Re: Alfresco Community y Oracle

ecalle — Tue, 27 Mar 2012 14:43:57 GMT

En la wiki tienes lo que necesitas! Ojea está página.

¡Un saludo!

a ver si me sacas de la duda Cristina, voy a instalar Alfresco 4 community en version de 32 bits y mi duda es que si alfresco comunnity puede trabajar con una base de datos alojada en oracle 10g y deseo saberlo ya que he leido en otros post comentan que la version community no puede trabajar con Oracle 10g.

Re: Alfresco Community y Oracle

cristinamr — Tue, 27 Mar 2012 14:50:30 GMT

Community y oracle si que pueden trabajar.

El problema que veo es la version del alfresco, sino recuerdo mal el conector que había de oracle colgado en el sourceforge (la página donde estaba subido), no era compatible con la versión 4, pero sé de buena mano que la gente lo ha cogido modificado y está funcionando correctamente. Probablemente tendrás que hacer lo mismo.

Un saludo

Re: Alfresco Community y Oracle

igomez — Mon, 02 Apr 2012 11:15:49 GMT

Yo tengo un Alfresco Community 4.0.B y 4.0.D corriendo en un Oracle sin problemas.

El .amp está aqui: http://forge.alfresco.com/gf/project/oracle/

El oficial es para la 4.0.B pero uno mismo se lo puede modificar para que funcione con la 4.0.D, comparando cambios en la estructura de la BBDD y demás.

Un saludo.

Re: Alfresco Community y Oracle

cristinamr — Mon, 02 Apr 2012 11:51:06 GMT

We! Gracias por el aporte igomez :mrgreen: