Difference between revisions of "Command Center FAQ"
(→What setting for MySQL 8 ?) |
|||
| Line 5: | Line 5: | ||
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: |
||
| − | 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 |
+ | 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&allowPublicKeyRetrieval=true |
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: |
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: |
||
* https://mysqlconnector.net/connection-options/ |
* https://mysqlconnector.net/connection-options/ |
||
| − | 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 |
+ | 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 values for the following attributes may be of particular interest: |
* ServerRSAPublicKeyFile |
* ServerRSAPublicKeyFile |
||
* allowPublicKeyRetrieval |
* allowPublicKeyRetrieval |
||
Revision as of 19:28, 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&allowPublicKeyRetrieval=true
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 values for the following attributes may be of particular interest:
- ServerRSAPublicKeyFile
- allowPublicKeyRetrieval
