Studio Developer Manual / Version 2506.0
Table Of ContentsCoreMedia Studio Server stores Editorial Comments in an SQL database, so it needs to be configured accordingly.
The default schema, username and password is: cm_editorial_comments.
In case you want to provide a schema or username, different to cm_editorial_comments, use the properties
editorial.comments.db.username, editorial.comments.db.schema and editorial.comments.db.password.
The datasource url has to be set for the respective database with the property editorial.comments.datasource.url like this:
- MySQL
jdbc:mysql://${host}:${port}/cm_editorial_comments- PostgreSQL
jdbc:postgresql://${host}:${port}/coremedia- MariaDB
jdbc:mariadb://${host}:${port}/cm_editorial_comments- Microsoft SQL Server
jdbc:sqlserver://${host}:${db.port};DatabaseName=cm_editorial_comments;username=sa;password=admin- Oracle
jdbc:oracle:thin:@${host}:${port}:COMMENTS
MySQL / MariaDB: Ensure Proper Character Set And Collation
To ensure proper encoding and collation behavior, ensure using
character set utf8mb4 and collation
utf8mb4_bin for your created database.
MariaDB: Respect Password Check Plugins
MariaDB Enterprise Server comes with a password check plugin enabled by default. Ensure, that your password meets the requirements of that password check plugin.
PostgreSQL on Azure
Should you use PostgreSQL hosted on Azure, it is necessary to provide a postfix with the domain to the username.
Use editorial.comments.db.username to set the username with the postfix:
editorial.comments.db.username=cm_editorial_comments@domain |
editorial.comments.db.schema=cm_editorial_comments |
