Difference between revisions of "Command Center FAQ"

From Lingoport Wiki
Jump to: navigation, search
(Created page with "= Why am I not seeing all the projects? = (Manager, Developer, Translator, chips, search, favorites, tags...]")
 
Line 1: Line 1:
 
= Why am I not seeing all the projects? =
 
= Why am I not seeing all the projects? =
 
(Manager, Developer, Translator, chips, search, favorites, tags...]
 
(Manager, Developer, Translator, chips, search, favorites, tags...]
  +
  +
= What setting for MySQL 8 ? =
  +
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:
  +
* 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 necessary:
  +
* ServerRSAPublicKeyFile
  +
* allowPublicKeyRetrieval

Revision as of 18:58, 27 June 2023

Why am I not seeing all the projects?

(Manager, Developer, Translator, chips, search, favorites, tags...]

What setting for MySQL 8 ?

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