04-10-2012 02:52 AM
04-10-2012 03:07 AM
04-10-2012 03:41 AM
I just said that in Alfresco Enterprise there is an Activiti Explorer integrated. This integration may also become part of the community edition but it's not yet part of the latest community release.Entonces reformulo la pregunta: ¿cómo se instala Activiti Explorer en Alfresco Community? ¿Alguien lo ha hecho?
You still can use the open source Activiti Explorer, but you'll need to connect it to the Activiti database used by Alfresco.
04-10-2012 04:58 AM
04-10-2012 05:02 AM
04-10-2012 05:14 AM
cd /root/
wget -c http://activiti.org/downloads/activiti-5.9.zip
unzip activiti-5.9.zip
cd /root/activiti-5.9
apt-get install ant
Y una vez instalado, construyo:cd /root/activiti-5.9/setup
ant internal.build.webapps
Esto me ha creado los directorios:build/webapps/activiti-explorer.war
build/webapps/activiti-rest.war
cd /root/activiti-5.9/setup/build/webapps/activiti-explorer.war/WEB-INF/classes
mv ui.properties ui.properties.activiti
mv ui.properties.alfresco ui.properties
cd /root/activiti-5.9
### database connection properties ###
db.driver=org.postgresql.Driver
db.username=alfresco
db.password=123456
db.name=alfresco
db.url=jdbc:postgresql://localhost:5432/${db.name}
Así que con esos datos, accedo al directorio de activiti-explorer y edito los ajustes de la base de datoscd /root/activiti-5.9/setup/build/webapps/activiti-explorer.war/WEB-INF/classes
vim db.properties
El archivo original tiene este contenido:#Tue, 10 Apr 2012 10:28:23 +0200
db=h2
jdbc.driver=org.h2.Driver
jdbc.url=jdbc\:h2\:tcp\://localhost/activiti
jdbc.username=sa
jdbc.password=
Yo lo cambio según mi configuración de Alfresco:#Tue, 10 Apr 2012 10:28:23 +0200
#db=h2
#jdbc.driver=org.h2.Driver
#jdbc.url=jdbc\:h2\:tcp\://localhost/activiti
#jdbc.username=sa
#jdbc.password=
# Alfresco settings
db=alfresco
jdbc.driver=org.postgresql.Driver
jdbc.url=jdbc:postgresql://localhost:5432/${db}
jdbc.username=alfresco
jdbc.password=123456
cp -rp setup/build/webapps/activiti-explorer.war /opt/alfresco-4.0.d/tomcat/webapps/activiti-explorer
10-Apr-2012 11:07:40 org.activiti.engine.impl.db.DbSqlSession dbSchemaUpgrade
INFO: upgrading activiti engine schema from 5.7 to 5.9
10-Apr-2012 11:07:40 org.activiti.engine.impl.db.DbSqlSession executeSchemaResource
INFO: performing upgrade on engine with resource org/activiti/db/upgrade/activiti.postgres.upgradestep.58.to.59.engine.sql
10-Apr-2012 11:07:41 org.activiti.engine.impl.db.DbSqlSession executeSchemaResource
SEVERE: problem during schema upgrade, statement 'update ACT_GE_BYTEARRAY set GENERATED_ = 0
org.postgresql.util.PSQLException: ERROR: column "generated_" is of type boolean but expression is of type integer
Hint: You will need to rewrite or cast the expression.
Es un error de SQL, voy a investigarlo y sigo con el tema 😉
04-10-2012 05:28 AM
update ACT_GE_BYTEARRAY set GENERATED_ = 0
por esto:update ACT_GE_BYTEARRAY set GENERATED_ = false
Voy a ver dónde se cambia y ahora os cuento.
04-10-2012 05:46 AM
04-10-2012 05:57 AM
04-10-2012 09:43 AM
cd /root
wget -c http://activiti.org/downloads/activiti-5.8.zip
unzip activiti-5.8.zip
mkdir /root/activiti-5.8/bak
cp /root/activiti-5.8/setup/build.properties /root/activiti-5.8/bak/
cp /root/activiti-5.8/setup/build.db.properties /root/activiti-5.8/bak/
cp /root/activiti-5.8/setup/files/webapps/activiti-explorer.war/WEB-INF/classes/ui.properties /root/activiti-5.8/bak/
vim /root/activiti-5.8/setup/build.properties
Después ajustamos la conexión con la base de datos.db.driver=org.postgresql.Driver
db.username=alfresco
db.password=123456
db.name=alfresco
db.url=jdbc:postgresql://localhost:5432/${db.name}
Entonces modifico el archivo /root/activiti-5.8/setup/build.db.propertiesdb=h2
jdbc.driver=org.h2.Driver
jdbc.url=jdbc:h2:tcp://localhost/activiti
jdbc.username=sa
jdbc.password=
a esto:db=alfresco
jdbc.driver=org.postgresql.Driver
jdbc.url=jdbc:postgresql://localhost:5432/${db}
jdbc.username=alfresco
jdbc.password=123456
Por último, cambiamos el entorno de activiti a alfrescocd /root/activiti-5.8/setup/files/webapps/activiti-explorer.war/WEB-INF/classes
cat ui.properties.alfresco > ui.properties
cd /root/activiti-5.8/setup
export JAVA_HOME=/opt/alfresco-4.0.d/java
ant internal.build.webapps
cp -r /root/activiti-5.8/setup/build/webapps/activiti-explorer.war /opt/alfresco-4.0.d/tomcat/webapps/activiti-explorer
Con esto ya puedo acceder a http://miservidor:8080/activiti-explorerTags
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.