Difference between revisions of "Command Center FAQ"
(→What setting for MySQL 8 ?) |
|||
| Line 2: | Line 2: | ||
(Manager, Developer, Translator, chips, search, favorites, tags...] |
(Manager, Developer, Translator, chips, search, favorites, tags...] |
||
| − | = What |
+ | = What are the settings for MySQL 8 JDBC connection? = |
Deploying Command Center entails installing two Docker containers, one for the Web application, one for the MySQL 8 database. Both are on the same system and communicate via a Docker network. Command Center is reachable via its URL behind HTTPS. One cannot reach the database from outside the VM on which it is installed. Based on the above, the JDBC URL going from the Web application container to the MySQL container is configured as follows: |
Deploying Command Center entails installing two Docker containers, one for the Web application, one for the MySQL 8 database. Both are on the same system and communicate via a Docker network. Command Center is reachable via its URL behind HTTPS. One cannot reach the database from outside the VM on which it is installed. Based on the above, the JDBC URL going from the Web application container to the MySQL container is configured as follows: |
||
Revision as of 18:58, 27 June 2023
Why am I not seeing all the projects?
(Manager, Developer, Translator, chips, search, favorites, tags...]
What are the settings for MySQL 8 JDBC connection?
Deploying Command Center entails installing two Docker containers, one for the Web application, one for the MySQL 8 database. Both are on the same system and communicate via a Docker network. Command Center is reachable via its URL behind HTTPS. One cannot reach the database from outside the VM on which it is installed. Based on the above, the JDBC URL going from the Web application container to the MySQL container is configured as follows:
app.database.url=jdbc:mysql://mysqlservercommand:3306/LRM?characterEncoding=utf8&permitMysqlScheme&restrictedAuth=mysql_native_password,client_ed25519,auth_gssapi_client,caching_sha2_password,dialog,mysql_clear_password
If LRM, the Localyzer engine, requires another configuration, that will be up to the customer IT to make that determination. For reference, the following parameters can be set on the JDBC connection:
In particular, if the MySQL 8 is installed in a non-default way and the VM on which the database is setup is not the same as the VM from which the connection is made or is exposed to a public network, the following attributes may be necessary:
- ServerRSAPublicKeyFile
- allowPublicKeyRetrieval
