This appendix applies to EKM servers using the MySQL database server.
By default, the MySQL database server listens for client connections
on TCP port 3306. If the default port is
already used by another process, it is necessary to change the port
used by the MySQL database server. If this port is changed, it is
also necessary to reconfigure EKM to use the new port.
To change the MySQL database server port:
On each EKM cluster node, stop the EKM server.
Stop the database server (MySQL).
Perform the following modifications to the MySQL and EKM configuration:
MySQL Configuration:
Edit MYSQL_HOME/my.(cnf|ini) and update
all occurrences of the port setting to the new port number (value
shown below in bold).
[client] port=3306 user=root password=root123 [mysqladmin] port=3306 user=root password=root123 [mysqld] port=3306 default_storage_engine=INNODB transaction_isolation=READ-COMMITTED max_allowed_packet=128m
EKM Configuration:
Update the MySQL database server port in the JBoss domain configuration (see JBoss Domain Mode and Configuration):
Find the datasources subsystem
configuration element:
<subsystem xmlns="urn:jboss:domain:datasources:4.0">
Find the datasources child
element, then find its datasource child element
whose pool-name attribute value is ekmds:
<datasource jndi-name="java:jboss/datasources/ekmds"
pool-name="ekmds" enabled="true" use-java-context="true">
<connection-url>jdbc:mysql://localhost:3306/ekm</connection-url>
<driver>org.mariadb.jdbc</driver>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
...
...
</datasource>Modify the value of the connection-url element (shown above in bold) to
the new MySQL JDBC URL for the MySQL database
server, to reflect the new port number.
MySQL JDBC URLs follow the form:
jdbc:mysql://[host][:port]/[database]
where:
host: the
database server host. If host is not specified, 127.0.0.1 (localhost) is used.
port: the database server port. If port is not specified, the default port of 3306 is used.
database: the name of the database to connect to. The default name is ekm.
Start the cluster database server (MySQL).
On each EKM cluster node, start the EKM server.