8. Ajustes adicionales de Fuse, Tomcat y certificados
Se centraliza el certificado para los en el directorioThe certificate is centralized into the folder: /home/fuseadmin/sii/ssl
Parar en primer lugar el servidor Tomcat Stop the Tomcat server first |
STOPTOMCAT7077
STOPTOMCAT8511 |
2- |
Copiar starCopy star_techedgegroup_es.jks |
en el nuevo directorio intonew folder ssl |
cd ~
mkdir ssl
cp sii/tomcat/apache-tomcat-8.5.11/ssl/star_techedgegroup_es.jks sii/ssl/ |
3- |
Adecuar los respectivos Adjust the respective server.xml |
de Contenidos de Contents of ~/sii/dev/tomcat/apache-tomcat-8.5.11/conf/server.xml |
 Image Modified
|
Editar también el archivo de configuración de FuseEdit also Fuse configuation file org.ops4j.pax.web.cfg |
 Image Modified
|
cd ~
cd sii/dev/fuse/jboss-fuse-6.3.0.redhat-187/etc/
vim org.ops4j.pax.web.cfg |
Contenidos Contents of org.ops4j.pax.web.cfg |
 Image Modified
|
5- |
Añadir al de FuseContenidos de of Fuse |
Contents of ~/sii/fuse/jboss-fuse-6.3.0.redhat-187/bin/setenv |
(...)
echo ''
echo '======================================================='
echo 'Estableciendo variables de Entorno'
echo '======================================================='
set -x
export JAVA_HOME=/usr/local/jdk1.7.0_80
export ANT_HOME=/usr/local/apache-ant-1.9.9
export M2_HOME=/usr/local/apache-maven-3.3.9
export GROOVY_HOME=/usr/local/groovy-2.4.9
export M2=$M2_HOME/bin
export MAVEN_OPTS="-Xms256m -Xmx512m -Dmaven.artifact.threads=3"
export PATH=$JAVA_HOME/bin:$M2:$ANT_HOME/bin:$GROOVY_HOME/bin:$PATH
export EXTRA_JAVA_OPTS="-Dorg.apache.activemq.SERIALIZABLE_PACKAGES=*"
set +x
echo ' '
(...) |
Editar el archivo de configuración de Fuse orgEdit Fuse configuration file org.apache.karaf.management.cfg
|
Importante cambiar Important exchange 0.0.0.0 |
por Contenidos de Contents of ~/sii/fuse/jboss-fuse-6.3.0.redhat-187/etc/org.apache.karaf.management.cfg |
 Image Modified
|
7- |
Crear el servicio de Fuse Create Fuse service fuseSIIprod.service |
Contenidos de Contents of /etc/systemd/system/multi-user.target.wants/fuseSIIprod.service |
 Image Modified |
Probar y habilitar el servicio de Fuse Test and enable the Fuse service |
 Image Modified
|
 Image Modified |
9- |
Aspecto final deFinal aspect of .bashrc |
 Image Modified
|
10- |
Volver a editar Re-edit ~/sii/tomcat/apache-tomcat-8.5.11/conf/server.xml, |
añadiendo la conexión con la base de datosadding the connection to the database. |
<GlobalNamingResources>
<!-- Editable user database that can also be used by
UserDatabaseRealm to authenticate users
-->
<Resource name="UserDatabase" auth="Container"
type="org.apache.catalina.UserDatabase"
description="User database that can be updated and saved"
factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
pathname="conf/tomcat-users.xml" />
<!-- CONEXION BASE DE DATOS SII -->
<Resource auth="Container" driverClassName="oracle.jdbc.OracleDriver" factory="org.apache.tomcat.dbcp.dbcp2.BasicDataSourceFactory" maxActive="200" maxIdle="200" maxWait="-1" name="jdbc/SIIOracle" password="tech2017" testOnBorrow="true" type="javax.sql.DataSource" url="jdbc:oracle:thin:@//172.26.1.71:1521/FACTCLOUD" username="DASHBOARDSII" validationQuery="select 1 from dual" validationQueryTimeout="5"/>
<Resource auth="Container" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" maxActive="200" maxIdle="200" maxOpenPreparedStatements="100" maxWait="-1" name="jdbc/SIISqlserver" password="u2r_da2hb0ard" poolPreparedStatements="true" type="javax.sql.DataSource" url="jdbc:sqlserver://192.168.60.66:1433;databaseName=sii;user=usr_dashboard;password=u2r_da2hb0ard;" username="usr_dashboard" validationQuery="select 1"/>
<Resource auth="Container" driverClassName="org.postgresql.Driver" maxActive="200" maxIdle="200" maxWait="-1" name="jdbc/postgresql" password="PlantillaInstalacion2017%" testOnBorrow="true" type="javax.sql.DataSource" url="jdbc:postgresql://localhost:5432/siiprod_db" username="fuseadmin" validationQuery="select 1"/>
</GlobalNamingResources> |