Artifactory requires using DB that uses case-sensitivity. If your Artifactory is set up with case-insensitive DB, like MySQL is by default, you may use steps below to repair it. Please note that this solution is written for MySQL.
Also note that there is small downtime needed for making changes to the case sensitivity and restarting each node. Below is updated instructions that makes a use of the REST API method. Below is the complete steps for the path repair and converting database to be case sensitive.1. Discover the issue
mysql> SELECT @@character_set_database, @@collation_database;
If the result has “_ci” it means that it is case-insensitive, and you need to use steps below.
+————————–+———————-+ | @@character_set_database | @@collation_database | +————————–+———————-+ | utf8 | utf8_general_ci | +————————–+———————-+ 1 row in set (0.00 sec)
2. Make a backup of your database
In order to prepare for any failure that may require a roll-back, take a snapshot of the latest database. Or, you may make a back up using Artifactory without the binaries (System Export with “Exclude Content” option - https://www.jfrog.com/confluence/display/RTF/Importing+and+Exporting#ImportingandExporting-SystemImportandExport).
3. Detect the conflicts by running the following REST API (with dry run enabled) for each local repositories