/
1.3.8. Additional setup for Fuse, Tomcat and certificates.

1.3.8. Additional setup for Fuse, Tomcat and certificates.

The certificate is centralized into the folder: /home/fuseadmin/sii/ssl

1-      Stop the Tomcat server first

STOPTOMCAT7077
STOPTOMCAT8511

2-      Copy star_techedgegroup_es.jks intonew folder ssl

cd ~
mkdir ssl
cp sii/tomcat/apache-tomcat-8.5.11/ssl/star_techedgegroup_es.jks sii/ssl/

3-      Adjust the respective server.xml of Tomcat

Contents of ~/sii/dev/tomcat/apache-tomcat-8.5.11/conf/server.xml


4-      Edit also Fuse configuation file org.ops4j.pax.web.cfg

cd ~
cd sii/dev/fuse/jboss-fuse-6.3.0.redhat-187/etc/
vim org.ops4j.pax.web.cfg

Contents of org.ops4j.pax.web.cfg

5-      Add script setenv 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 ' '
(...)


6-      Edit Fuse configuration file org.apache.karaf.management.cfg
Important exchange 0.0.0.0 for 127.0.0.1

Contents of ~/sii/fuse/jboss-fuse-6.3.0.redhat-187/etc/org.apache.karaf.management.cfg

7-     Create Fuse service fuseSIIprod.service

Contents of /etc/systemd/system/multi-user.target.wants/fuseSIIprod.service

 


8-     Test and enable the Fuse service

 

9-      Final aspect of .bashrc

10- Re-edit ~/sii/tomcat/apache-tomcat-8.5.11/conf/server.xml, adding 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>



Avvale 2024