Command Center FAQ

From Lingoport Wiki
Revision as of 18:23, 16 February 2024 by Olibouban (talk | contribs) (What are the settings for MySQL 8 JDBC connection?)
Jump to: navigation, search

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

Open Source Libraries and Licenses

See: Command Center Open Source Libraries