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?

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:

# E-Mail
email_delivery_method=smtp
smtp_address=server1.xxxx.de
smtp_port=587
smtp_domain=xxxx.de
smtp_authentication=login
smtp_user_name=webmaster@xxxx.de
smtp_password=mypassword
smtp_enable_starttls_auto=true

# SVN
OPENPROJECT_SCM_SUBVERSION_CLIENT__COMMAND=/usr/bin/svn
OPENPROJECT_SCM_SUBVERSION_TRUSTEDSSL=true

After that I added a SVN repository with existing commits to the Demo project with the following settings:

Source control management system: Subversion
URL to repository: https://dev.xxxx.de/scm/svn/kosis-app/trunk
Repository username: myusername
Repository Password: mypassword

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:

<?xml version="1.0" encoding="UTF-8"?>
<info>
<entry
   kind="dir"
   path="trunk"
   revision="4">
<url>https://dev.xxxx.de/scm/svn/xxxx/trunk</url>
<relative-url>^/trunk</relative-url>
<repository>
<root>https://dev.xxxx.de/scm/svn/xxxx</root>
<uuid>acc85fc6-5c01-0010-abc5-63148432e5ce</uuid>
</repository>
<commit
   revision="4">
<author>xxxx</author>
<date>2017-06-20T18:22:45.966000Z</date>
</commit>
</entry>
</info>

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)