Closed mmf-Github closed 4 years ago
Hi - Just wanted to check if you are using this documentation: https://www.jfrog.com/confluence/display/JFROG/Installing+Artifactory#InstallingArtifactory-DockerComposeInstallation
Also - there are a few templates you can use, but the default one does not carry nginx - please refer to the templates folder for other compose-templates.
Specifically for the issue you have, did you run ./config.sh to set the folders and system.yaml up? If so can you share the system.yaml - it appears to assume the database is postgresql but the url is not initialized and artifactory is trying to use derby in your case.
Hi Prasanna, yes, I also tried this documentation. I succeeded in deploying a simple JFrog Artifactory instance, but compared to how smoothly I could get everything up and running, the official compose install is way off. With XRay I had no luck so far with both RPM and Compose, and I will refrain from further testing due to the complexity of setting this up. Thanks for your comment!
What was the solution to this?
I want to install a fresh artifactory version 7.4.1 with postgres 9.6.11
I combined the example yaml files. The one of artifactroy and postgres and the one of artifactory and nginx! There is no example of the combination artifactory - nginx and postgres? I have the same problem as above. The installation logging says: 2020-04-24T11:53:52.000Z [shell] [INFO ] [] [systemYamlHelper.sh:292 ] [main] - Resolved JF_SHARED_DATABASE_TYPE (postgresql) from environment variable 2020-04-24T11:53:52.000Z [shell] [INFO ] [] [systemYamlHelper.sh:292 ] [main] - Resolved JF_SHARED_DATABASE_USER (artifactory) from environment variable 2020-04-24T11:53:52.000Z [shell] [INFO ] [] [systemYamlHelper.sh:292 ] [main] - Resolved JF_SHARED_DATABASE_PASSWORD (__sensitive_key_hidden___) from environment variable
But I also get later on the message:
2020-04-24T11:54:06.564Z [jfrt ] [INFO ] [e0d553fe7d944b4e] [o.j.s.c.KeyUtils:108 ] [ocalhost-startStop-2] - Master key is missing. Pending for 5 seconds with 60 seconds timeout 2020-04-24T11:54:09.487Z [jfac ] [INFO ] [a2f2bce1d1adbf2d] [s.d.u.AccessJdbcHelperImpl:138] [ocalhost-startStop-1] - Database: Apache Derby 10.14.2.0 - (1828579). Driver: Apache Derby Embedded JDBC Driver 10.14.2.0 - (1828579) 2020-04-24T11:54:09.488Z [jfac ] [INFO ] [a2f2bce1d1adbf2d] [s.d.u.AccessJdbcHelperImpl:141] [ocalhost-startStop-1] - Connection URL: jdbc:derby:{db.home} 2020-04-24T11:54:09.721Z [jfrou] [INFO ] [6feb25ee40b45580] [security_keys.go:114 ] [main ] - Master key is missing. Pending for 15 seconds with 2m0s timeout 2020-04-24T11:54:09.825Z [jfac ] [INFO ] [a2f2bce1d1adbf2d] [s.d.u.AccessJdbcHelperImpl:150] [ocalhost-startStop-1] - Creating database schema 2020-04-24T11:54:10.393Z [jfac ] [ERROR] [a2f2bce1d1adbf2d] [o.j.s.u.DbStatementUtils:66 ] [ocalhost-startStop-1] - Failed to execute query: TYPE 'BYTEA' does not exist.: CREATE TABLE access_permissions_custom_data ( perm_id BIGINT NOT NULL, data BYTEA NOT NULL, CONSTRAINT access_perm_data_pk PRIMARY KEY (perm_id), CONSTRAINT access_perm_data_perms_fk FOREIGN KEY (perm_id) REFERENCES access_permissions (perm_id)
============================================= My .env file: //Docker registry to fetch images from DOCKER_REGISTRY=docker.bintray.io
// Version of artifactory to install ARTIFACTORY_VERSION=7.4.1
// The Installation directory for Artifactory. IF not entered, the script will prompt you for this input. Default [$HOME/.jfrog/artifactory] ROOT_DATA_DIR=/var/appdata/artifactory
//Router external port mapping. This property may be overridden from the system.yaml (router.entrypoints.externalPort) JF_ROUTER_ENTRYPOINTS_EXTERNALPORT=8082
My docker-compose file is
version: '3' services: postgres: image: ${DOCKER_REGISTRY}/postgres:9.6.11 container_name: postgresql environment:
========================= And the logging of the postgres container says: FATAL: role "postgres" does not exist
I had same issue....the problem is that your database connection is not working, probably because the system.yaml is not correct. Alternatively, try to rm your entire filestore dir and restart.
@kad-meedel There is a template with nginx, postgres and artifactory in the templates folder in docker package - have you used that?
I tried many different things :-) For NGINX and Artifactory 7.x, I used this: https://jfrog.com/knowledge-base/what-is-the-recommended-nginx-reverse-proxy-configuration-for-artifactory-7-x-and-above/ This worked like a charm for me.
At the moment I am struggling with replacing the system.yaml (where my database connection is defined) in a custom Dockfile. The problem is that the entry point scripts overwrite whatever you COPY yourself. But after digging into all the scripts, I think I have found a way.
@JfrogPrasanna I used the package from jfrog-artifactory-pro-7.4.1-compose.tar.gz In the directory templates there is a compose-nginx and a compose-postgres. There is no combination of postgres and nginx with artifactory. I have tried it myself combining the two templates, but can't get it worked ok.
my starting point is a clean installation of 7.4.1. So no data at all.
Hi there,
I know that this is deprecated, but the official docker-compose does not include NGINX and I use the port method for a Docker registry. I had this running in the past (6.x).
When I clone the repo and prep / start, I run into a lot of issues. With both Pro and HA I get master.key not found, config not found, etc. I am using the same approach as documented. I then created the master.key in the directory, and it throws a different error. Seems like a lot of files are not prepared by prepareHostEnv. It might be connected to #137
So from my point of view the new version does not work at all and I am curious if anyone can make this work and I would appreciate if someone could help me out here. I wasted hours on this now.