Re: Default database name and user name for different OpenMRS installation instances

[Burke Mamlin]

(copying implementers as well as devs, since all would be affected by this change)

Should OpenMRS vary the database name & database user's name like we do for the web application name?  Users will still be able to customize these values via installation steps and runtime properties.

I created a description + poll on OpenMRS Talk for this.  Basically, we would stop assuming that the database and database user's name is "openmrs" and would, instead, default to the name of the web application (usually it's "openmrs", but not always... for example, the standalone uses "openmrs-standalone" and many implementations use their own name).

Please cast your vote or add your voice on OpenMRS Talk.

Cheers,

-Burke

p.s. Thanks Geoffrey for bringing this idea to the community.

On Thu, Jul 31, 2014 at 3:17 PM, Darius Jazayeri <dar...@openmrs.org> wrote:

Hi Geoffrey,

Could you clarify this? Is the problem specifically about the initial setup wizard / installer? That is what creates the database and user, right?

(Doesn't it give you options to specify the user name and database name you want?)

I agree that if I have deployed the openmrs war file under the webapp name "mirebalais", and I ran through the setup scripts, it would make sense for me to end up with a mirebalais_user db user, and a database called mirebalais.

-Darius

On Sun, Jul 27, 2014 at 8:29 AM, Geoffrey Wanjala <geoffre...@gmail.com> wrote:

Hi,

I'm working on a ticket(TRUNK-4015) that will allow different installation instances to have different application data folders, but I have realized that different installations keep on overriding each others database and connection user name. What would be the best way to handle such a scenario? What would be the best defaults(database and connection user name) for the different installation instances?

Regards,
Geoffrey.

--
OpenMRS Developers: http://go.openmrs.org/dev
Post: d...@openmrs.org | Unsubscribe: dev+uns...@openmrs.org
Manage your OpenMRS subscriptions at https://id.openmrs.org/

--
OpenMRS Developers: http://go.openmrs.org/dev
Post: d...@openmrs.org | Unsubscribe: dev+uns...@openmrs.org
Manage your OpenMRS subscriptions at https://id.openmrs.org/

[Geoffrey Wanjala]

Hi Darius,

Yes, the problem is during the setup.

I am able to install multiple instances of openmrs web app, but since all instances use a default database named 'openmrs' and a user 'openmrs_user' only the last installation will run successfully since it was the last to change the password for 'openmrs_user'. And different installation instances will also make changes to the database depending on the version.

Regards
Geoffrey.

--
OpenMRS Implementers: http://go.openmrs.org/implementers
Post: implem...@openmrs.org
Unsubscribe: implementers...@openmrs.org

Manage your OpenMRS subscriptions at https://id.openmrs.org/

To unsubscribe from this group and stop receiving emails from it, send an email to implementers...@openmrs.org.

--
Regards,
Wanjala Geoffrey

[Kaweesi Joseph]

By the way, before i have tried installing different databases, since the installation gives us the ability to change the database name, what am not sure is use a different openmrs_user user name

k-joseph

GSoC 2014 Intern(Chart Search for Ref App)


What we most need now is NOT legal religion BUT true and genuine conversion through Christ our righteousness

[Darius Jazayeri]

Hi Geoffrey,

But just to be clear, you currently can set up multiple OpenMRS instances if you manually give a different database name and user than openmrs. Right?

-Darius

[Geoffrey Wanjala]

Yes Darius,

With the modifications I made I am able to do that. I can create a PR so you can test it out, should I?

[Darius Jazayeri]

So, according to https://wiki.openmrs.org/display/docs/Step+6+-+Configure+OpenMRS (I assume this is the current UI) it is currently possible to change the database name in step 1, but in step 2 you cannot specify the username to create.

Anyway, let's see how the poll Burke created plays out.

-Darius

[Geoffrey Wanjala]

Yeah that's the current UI though that's when using the Advanced option. But what if one chooses the Simple option, none of the configuration will available.

[Terry]

Geoffrey, I have posted in an email a paper on  Protocol Directed Care Plans as I could not download the actual book chapter. The email has gone to you first for assessment. Terry