Added by Torsten Hees over 8 years ago
Hello,
I’ll take my first steps with OpenProject. It works good, but I can’t find a way to connect my existing subversion repositorys to OpenProject.
I running OpenProject on Ubuntu-Server 16.04 and on another machine CollabNet Subversion Edge.
I don’t know how to connect it together. I not sure but I think it is not possible, because OpenProject need the subversion instance on the same machine. Is this correct?
Replies (3)
Hi Torsten,
OpenProject allows you to link existing SVN repositories using a remotely authorized repository.
If you’re using that setup, you will only be able to browse the repository through OpenProject, but checking out / committing with the user credentials of OpenProject will not be possible. You can use both types of repositories in your installation, however. Each project can either have:
- if configured: a managed repository (owned and user permissions handled by OpenProject, check out possible with OpenProject permissions)
- if enabled: an existing repository, either local or remote. Browsing only through OpenProject.
For more information, see:
https://github.com/opf/openproject/tree/dev/docs/repositories
https://www.openproject.org/help/system-settings/repositories-settings/
Best,
Oliver
Thanks a lot. That helps me, but now I running in another error.
I configured my svn configuration, but I got the following error:
“500 An error occurred when trying to access the repository: The repository is unavailable.”
The repository is not unavailable, on the same machine I can checkout the repository with the same user and repository url:
My Settings:
Project settings -> Repository
Source control management system: Subversion
URL: https://192.168.178.23:3690/svn/Test/trunk
Repository username: openprojectsvnuser
Password: openprojectsvnuser
I have the same problem. I use the Docker version of OpenProject (openproject/community:7) and set SMTP and two subversion settings via environment variables:
After that I added a SVN repository with existing commits to the Demo project with the following settings:
I already set the log level to “:debug” and checked log/supervisor/web-stdout.log. I found there the svn command that OpenProject use. If I run this command on the shell (Host and docker container bash) I get the correct return.
This ist the return:
This is the log output:
App 337 stdout: Started GET "/projects/demo-project/repository" for 127.0.0.1 at 2017-06-26 19:46:14 +0200 App 337 stdout: You are setting a key that conflicts with a built-in method OmniAuth::Strategy::Options#display defined in Kernel. This can cause unexpected behavior when accessing the key via as a property. You can still access the key via the #[] method. App 337 stdout: You are setting a key that conflicts with a built-in method OmniAuth::Strategy::Options#display defined in Kernel. This can cause unexpected behavior when accessing the key via as a property. You can still access the key via the #[] method. App 337 stdout: Processing by RepositoriesController#show as HTML App 337 stdout: Parameters: {"project_id"=>"demo-project"} App 337 stdout: Cache read: _session_id:ad08d9e20308c32641cbe9dbfb19dffe App 337 stdout: ^[[1m^[[36mUser Load (1.1ms)^[[0m ^[[1m^[[34mSELECT "users".* FROM "users" WHERE "users"."type" IN ('User', 'AnonymousUser', 'DeletedUser', 'SystemUser') AND "users"."status" = $1 AND "users"."id" = $2 LIMIT $3^[[0m [["status", 1], ["id", 1], ["LIMIT", 1]] App 337 stdout: ^[[1m^[[35m (0.9ms)^[[0m ^[[1m^[[34mSELECT MAX("settings"."updated_on") FROM "settings"^[[0m App 337 stdout: Cache read: /openproject/settings/all/1498389120 App 337 stdout: Cache fetch_hit: /openproject/settings/all/1498389120 App 337 stdout: ^[[1m^[[36mProject Load (0.9ms)^[[0m ^[[1m^[[34mSELECT "projects".* FROM "projects" WHERE "projects"."identifier" = $1 LIMIT $2^[[0m [["identifier", "demo-project"], ["LIMIT", 1]] App 337 stdout: ^[[1m^[[35m (0.9ms)^[[0m ^[[1m^[[34mSELECT "enabled_modules"."name" FROM "enabled_modules" WHERE "enabled_modules"."project_id" = $1^[[0m [["project_id", 1]] App 337 stdout: ^[[1m^[[36mRepository Load (0.8ms)^[[0m ^[[1m^[[34mSELECT "repositories".* FROM "repositories" WHERE "repositories"."project_id" = $1 LIMIT $2^[[0m [["project_id", 1], ["LIMIT", 1]] App 337 stdout: Shelling out: `/usr/bin/svn info --xml https://dev.xxxx.de/scm/svn/xxxx/trunk/ --username xxxx --password xxxx --trust-server-cert --no-auth-cache --non-interactive` App 337 stdout: Rendering common/error.html.erb within layouts/base App 337 stdout: Rendered common/_error_base.html.erb (1.6ms) App 337 stdout: Rendered common/error.html.erb within layouts/base (30.5ms) App 337 stdout: ^[[1m^[[36mUserPreference Load (0.8ms)^[[0m ^[[1m^[[34mSELECT "user_preferences".* FROM "user_preferences" WHERE "user_preferences"."user_id" = $1 LIMIT $2^[[0m [["user_id", 1], ["LIMIT", 1]] App 337 stdout: Rendered common/_favicons.html.erb (0.8ms) App 337 stdout: ^[[1m^[[36mEnterpriseToken Load (0.9ms)^[[0m ^[[1m^[[34mSELECT "enterprise_tokens".* FROM "enterprise_tokens" ORDER BY created_at DESC LIMIT $1^[[0m [["LIMIT", 1]] App 337 stdout: ^[[1m^[[36mEnabledModule Load (0.9ms)^[[0m ^[[1m^[[34mSELECT "enabled_modules".* FROM "enabled_modules" WHERE "enabled_modules"."project_id" = $1^[[0m [["project_id", 1]] App 337 stdout: ^[[1m^[[36mWiki Load (0.9ms)^[[0m ^[[1m^[[34mSELECT "wikis".* FROM "wikis" WHERE "wikis"."project_id" = $1 LIMIT $2^[[0m [["project_id", 1], ["LIMIT", 1]] App 337 stdout: ^[[1m^[[36mMenuItems::WikiMenuItem Load (1.0ms)^[[0m ^[[1m^[[34mSELECT "menu_items".* FROM "menu_items" WHERE "menu_items"."type" IN ('MenuItems::WikiMenuItem') AND "menu_items"."navigatable_id" = 1 AND "menu_items"."parent_id" IS NULL ORDER BY id ASC^[[0m App 337 stdout: ^[[1m^[[36mMenuItem Load (0.9ms)^[[0m ^[[1m^[[34mSELECT "menu_items".* FROM "menu_items" WHERE "menu_items"."parent_id" = 7 ORDER BY id ASC^[[0m App 337 stdout: ^[[1m^[[36mQuery Load (1.0ms)^[[0m ^[[1m^[[34mSELECT "queries"."id", "queries"."name", "queries"."is_public", "queries"."project_id" FROM "queries" WHERE ("queries"."is_public" = $1 OR "queries"."user_id" = $2) AND "queries"."project_id" = 1 ORDER BY name ASC^[[0m [["is_public", "t"], ["user_id", 1]] App 337 stdout: ^[[1m^[[36mMenuItems::QueryMenuItem Load (1.0ms)^[[0m ^[[1m^[[34mSELECT "menu_items".* FROM "menu_items" WHERE "menu_items"."type" IN ('MenuItems::QueryMenuItem') AND "menu_items"."navigatable_id" IN (2, 3, 4, 5, 1, 6) ORDER BY name^[[0m App 337 stdout: ^[[1m^[[35m (1.5ms)^[[0m ^[[1m^[[34mSELECT DISTINCT COUNT(DISTINCT "versions"."id") FROM "versions" LEFT OUTER JOIN "projects" ON "projects"."id" = "versions"."project_id" WHERE (projects.id = 1 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 1 AND projects.rgt <= 2 AND versions.sharing = 'tree') OR (projects.lft < 1 AND projects.rgt > 2 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 1 AND projects.rgt < 2 AND versions.sharing = 'hierarchy'))))^[[0m App 337 stdout: ^[[1m^[[36mCACHE (0.0ms)^[[0m ^[[1m^[[34mSELECT DISTINCT COUNT(DISTINCT "versions"."id") FROM "versions" LEFT OUTER JOIN "projects" ON "projects"."id" = "versions"."project_id" WHERE (projects.id = 1 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 1 AND projects.rgt <= 2 AND versions.sharing = 'tree') OR (projects.lft < 1 AND projects.rgt > 2 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 1 AND projects.rgt < 2 AND versions.sharing = 'hierarchy'))))^[[0m App 337 stdout: ^[[1m^[[36mBoard Exists (0.9ms)^[[0m ^[[1m^[[34mSELECT 1 AS one FROM "boards" WHERE "boards"."project_id" = $1 LIMIT $2^[[0m [["project_id", 1], ["LIMIT", 1]] App 337 stdout: ^[[1m^[[36mBoard Exists (0.9ms)^[[0m ^[[1m^[[34mSELECT 1 AS one FROM "boards" WHERE "boards"."project_id" = $1 LIMIT $2^[[0m [["project_id", 1], ["LIMIT", 1]] App 337 stdout: Rendered search/_mini_form.html.erb (1.4ms) App 337 stdout: Cache read: openproject/7.0.2/help_top_menu_node/de/href=https://www.openproject.org/help//label=homescreen.links.user_guides App 337 stdout: Cache fetch_hit: openproject/7.0.2/help_top_menu_node/de/href=https://www.openproject.org/help//label=homescreen.links.user_guides App 337 stdout: ^[[1m^[[36mAttachment Load (1.0ms)^[[0m ^[[1m^[[34mSELECT "attachments".* FROM "attachments" WHERE "attachments"."container_id" = $1 AND "attachments"."container_type" = $2 AND "attachments"."description" = $3 ORDER BY attachments.created_on LIMIT $4^[[0m [["container_id", 1], ["container_type", "Principal"], ["description", "avatar"], ["LIMIT", 1]] App 337 stdout: Rendered layouts/_action_menu.html.erb (0.3ms) App 337 stdout: Completed 500 Internal Server Error in 213ms (Views: 145.1ms | ActiveRecord: 16.2ms)