How two Redmine instances access the same Database

Added by Mei Zhen Koh almost 4 years ago

Hi All Redmine Users,

Due to security considerations and restrictions on our public web server, we are thinking about running two instances of Redmine, one publicly accessible for external user running over https and the internal accessible for internal user running over http sitting in the same server.

Everything that is posted to the public Redmine instance should automatically also appear in the internal Redmine instance. All updates to entries in the internal Redmine instance which have been initially created through the public instance change/update should be reflected in the public instance.

Scenario 1: One of our internal members creates a new issue using the internal Redmine instance. This issue should only appears in the internal redmine web portal and shall not be reflected in the public redmine web portal.
Scenario 2: An external user of the external Redmine instance creates a new issue using the public Redmine instance. This issue should be integrated in the same database such that it is accessible via the internal redmine web portal for edit/update of issue. Otherwise, internal user would need to check two project pages for updates.

Any ideas on how this could be achieved or similar concept available for reference?

Thank you

Replies (4)

RE: How two Redmine instances access the same Database - Added by Jan Niggemann (redmine.org team member) almost 4 years ago

It's not possible for 2 instances to share a database.
Anyway, if you already have an instance that's accessible for external users, why can't your internal users use the same one?

RE: How two Redmine instances access the same Database - Added by Scott H almost 4 years ago

This seems like something you'd just want to do with access rights and permissions. Unless you're set on the internal/external difference, which seems odd. Like, if an administrator was logging in from home, he shouldn't be able to see anything even though he's got full rights?

Without digging into the code, I think it might be possible to use a custom field to mark issues as internal/externally viewable, and if an external ip tries to view an 'internal' issue it gets redirected.

RE: How two Redmine instances access the same Database - Added by Mei Zhen Koh almost 4 years ago

Jan Niggemann (redmine.org team member) wrote:

It's not possible for 2 instances to share a database.
Anyway, if you already have an instance that's accessible for external users, why can't your internal users use the same one?

Scott H wrote:

This seems like something you'd just want to do with access rights and permissions. Unless you're set on the internal/external difference, which seems odd. Like, if an administrator was logging in from home, he shouldn't be able to see anything even though he's got full rights?

Without digging into the code, I think it might be possible to use a custom field to mark issues as internal/externally viewable, and if an external ip tries to view an 'internal' issue it gets redirected.

Thanks all for the input =)

(1-4/4)