How to configure an external DB to work with JFrog Artifactory? [Video]

Hanan Kemelman
2021-01-28 09:05

How to configure an external DB in JFrog Artifactory?

Video Transcription

Hi, my name is Hanan from JFrog support. In this video, I will demonstrate how to configure a connection between Artifactory and Stillman database. In my example, I use MySQL, but the process is similar among other databases. But before the how, let’s start with why. Why would I want to use an external database for Artifactory? Artifactory comes with [Derby 00:00:34] embedded built in. [Derby 00:00:35] is a reliable database that can store a large amount of data and metadata efficiently and securely. But [inaudible 00:00:43] you may want to switch to an external database since [Derby 00:00:47] and Artifactory will compete for the same JVM resources. Ready, let’s begin. Now, we’ll go over the necessary steps for configuring a connection between Artifactory and an external database. The first thing that you want to do is to copy the database template from system full template YAML into the system YAML file. Both files are located under different home, Artifactory VAR, ETC. Let’s take a look at my system YAML file.

[inaudible 00:01:22] relevant configuration, in my case, my SQL configuration under shared database. I left the configuration intact since I will not change the password that was encrypted on the first startup of Artifactory, and the only change I made to the template was the IP address. Second step in configuring the connection to the database, spacing the JDBC driver and the Concord with sub directory, the path shown here. The diver is required in order for the job application to communicate with the database. When placing the driver, please make sure it has the same permissions as other files under [inaudible 00:02:00] directory.

After you successfully edited the system YAML file and place your daily BC driver in the right location with the proper permissions. You are probably wondering if Artifactory consumed the configuration is connected to the right database. Well, it’s easy to check. Just need to check the logs. I would check the console log in search for connecting to. Here we can see the log entry that indicates the connection details. In my case, JDBC, my SQL and the IP address. This was my video on configuring the connection between Artifactory and an external database. Thank you for watching and I hope you have enjoyed. If you have any comments, feedback, or questions, please feel free to leave them in the comment section below.