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.
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 ;-)
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.
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-explorerContent from pre 2016 and from language groups that have been closed.
Content is read-only.
By using this site, you are agreeing to allow us to collect and use cookies as outlined in Alfresco’s Cookie Statement and Terms of Use (and you have a legitimate interest in Alfresco and our products, authorizing us to contact you in such methods). If you are not ok with these terms, please do not use this website.