1. MySQL 配置
如当前没有数据库,通过如下语句创建:
CREATE DATABASE artdb CHARACTER SET utf8 COLLATE utf8_bin;
CREATE USER 'artifactory'@'%' IDENTIFIED BY 'password';
GRANT ALL on artdb.* TO 'artifactory'@'%';
FLUSH PRIVILEGES;
下载 MySQL jdbc jar 包,并拷贝至 /root/jfrog/artifactory/var/bootstrap/artifactory/tomcat/lib/:
(下载地址:https://dev.mysql.com/downloads/connector/j/), 以 jdbc 8.0.13 为例:
$ wget https://downloads.mysql.com/archives/get/p/3/file/mysql-connector-java-8.0.13.tar.gz
$ cp mysql-connector-java-8.0.13.jar /root/jfrog/artifactory/var/bootstrap/artifactory/tomcat/lib/
修改数据库配置:
编辑配置文件 /root/jfrog/artifactory/var/etc/system.yaml, 添加 database 部分,完整示例如下:
configVersion: 1
shared:
database:
type: mysql
driver: com.mysql.jdbc.Driver
url: "jdbc:mysql://localhost:3306/artdb?characterEncoding=UTF-8&elideSetAutoCommits=true&useSSL=false"
username: artifactory
password: password
说明:
请以实际配置替换其中的 IP,端口,用户名,密码。
2. PostgreSQL 配置
如当前没有数据库,通过如下语句创建:
CREATE USER artifactory WITH PASSWORD 'password';
CREATE DATABASE artifactory WITH OWNER=artifactory ENCODING='UTF8';
GRANT ALL PRIVILEGES ON DATABASE artifactory TO artifactory;
修改数据库配置:
编辑配置文件 /root/jfrog/artifactory/var/etc/system.yaml, 添加 database 部分,完整示例如下:
configVersion: 1
shared:
database:
type: postgresql
driver: org.postgresql.Driver
url: jdbc:postgresql://localhost:5432/artifactory
username: artifactory
password: password
说明:
请以实际配置替换其中的 IP,端口,用户名,密码。