# Creating a new user Acount on mdsBuilder server

**URL:** <https://talk.openmrs.org/t/creating-a-new-user-acount-on-mdsbuilder-server/25044>\
**Category:** Software\
**Tags:** release-process\
**Created:** [October 11, 2019, 10:48am UTC](https://talk.openmrs.org/t/creating-a-new-user-acount-on-mdsbuilder-server/25044 "2019-10-11T10:48:52Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![mozzy](https://talk.openmrs.org/user_avatar/talk.openmrs.org/mozzy/32/11815_2.png) [@mozzy](https://talk.openmrs.org/u/mozzy)\
**Post date:** [October 11, 2019, 10:48am UTC](https://talk.openmrs.org/t/creating-a-new-user-acount-on-mdsbuilder-server/25044/1 "2019-10-11T10:48:52Z")

</div>

Am folowing this document [here](https://wiki.openmrs.org/display/docs/OpenMRS+Reference+Application+Release+Process) , and am supposed to do some work in the mdsBuilder server. I have a valid ssh key and can login in into the serverside.  
**Step 2** requires loging into the server (as a client) via the login page ,and i have no login credentials. How is the user account supposed to be created ?

I Created case at help desk , and i was told to

`Can you raise a topic in talk and ask clarification on how your user in mdsBuilder is supposed to be created?`

cc @dkayiwa @raff@cintiadr

---

<div class="post-metadata">

**Author:** ![mozzy](https://talk.openmrs.org/user_avatar/talk.openmrs.org/mozzy/32/11815_2.png) [@mozzy](https://talk.openmrs.org/u/mozzy)\
**Post date:** [October 14, 2019, 5:18pm UTC](https://talk.openmrs.org/t/creating-a-new-user-acount-on-mdsbuilder-server/25044/2 "2019-10-14T17:18:41Z")

</div>

cc @dkayiwa @cintiadrAny updates on how i could get a user account on the mdsBuilder server, ? i need to be able to

- Update Metadata Sharing packages and also
- Export concepts using data exchange to preserve IDs for later updates of CIEL.

---

<div class="post-metadata">

**Author:** ![cintiadr](https://talk.openmrs.org/user_avatar/talk.openmrs.org/cintiadr/32/8081_2.png) [@cintiadr](https://talk.openmrs.org/u/cintiadr)\
**Post date:** [October 15, 2019, 2:50am UTC](https://talk.openmrs.org/t/creating-a-new-user-acount-on-mdsbuilder-server/25044/3 "2019-10-15T02:50:21Z")

</div>

For full context, I asked this question. [https://wiki.openmrs.org/display/ISM/OpenMRS+environments](https://wiki.openmrs.org/display/ISM/OpenMRS+environments)

mdsbuilder has no clear owner, I have no idea who should have access to it (or if we should grant access to every release manager). That’s not something that was asked before, so I’d like clarification.

What’s the process?

---

<div class="post-metadata">

**Author:** ![cintiadr](https://talk.openmrs.org/user_avatar/talk.openmrs.org/cintiadr/32/8081_2.png) [@cintiadr](https://talk.openmrs.org/u/cintiadr)\
**Post date:** [October 15, 2019, 9:13pm UTC](https://talk.openmrs.org/t/creating-a-new-user-acount-on-mdsbuilder-server/25044/4 "2019-10-15T21:13:18Z")

</div>

@c.antwi or @dkayiwa, would you know anything about this?

---

<div class="post-metadata">

**Author:** ![dkayiwa](https://talk.openmrs.org/user_avatar/talk.openmrs.org/dkayiwa/32/179_2.png) [@dkayiwa](https://talk.openmrs.org/u/dkayiwa)\
**Post date:** [October 15, 2019, 10:35pm UTC](https://talk.openmrs.org/t/creating-a-new-user-acount-on-mdsbuilder-server/25044/5 "2019-10-15T22:35:25Z")

</div>

@cintiadr are you asking for whether every release manager should be granted access?

---

<div class="post-metadata">

**Author:** ![cintiadr](https://talk.openmrs.org/user_avatar/talk.openmrs.org/cintiadr/32/8081_2.png) [@cintiadr](https://talk.openmrs.org/u/cintiadr)\
**Post date:** [October 16, 2019, 10:05am UTC](https://talk.openmrs.org/t/creating-a-new-user-acount-on-mdsbuilder-server/25044/6 "2019-10-16T10:05:48Z")

</div>

Yes, @dkayiwa

And if the answer is yes, should it be raised on the helpdesk? If that’s the case, it would be nice to document the permissions to grant (so otherw could do too)

---

<div class="post-metadata">

**Author:** ![mozzy](https://talk.openmrs.org/user_avatar/talk.openmrs.org/mozzy/32/11815_2.png) [@mozzy](https://talk.openmrs.org/u/mozzy)\
**Post date:** [October 18, 2019, 6:38am UTC](https://talk.openmrs.org/t/creating-a-new-user-acount-on-mdsbuilder-server/25044/7 "2019-10-18T06:38:23Z")

</div>

> [@mozzy](#):
>
> - Update Metadata Sharing packages and also
> - Export concepts using data exchange to preserve IDs for later updates of CIEL.

hi @cintiadr , can i now get the credentials , i need to get the above done by this week at latest. we are already behind time

---

<div class="post-metadata">

**Author:** ![dkayiwa](https://talk.openmrs.org/user_avatar/talk.openmrs.org/dkayiwa/32/179_2.png) [@dkayiwa](https://talk.openmrs.org/u/dkayiwa)\
**Post date:** [October 18, 2019, 8:30am UTC](https://talk.openmrs.org/t/creating-a-new-user-acount-on-mdsbuilder-server/25044/8 "2019-10-18T08:30:54Z")

</div>

> [@mozzy](#):
>
> can i now get the credentials

Account created and sent to you via a private message.

---

<div class="post-metadata">

**Author:** ![mozzy](https://talk.openmrs.org/user_avatar/talk.openmrs.org/mozzy/32/11815_2.png) [@mozzy](https://talk.openmrs.org/u/mozzy)\
**Post date:** [October 18, 2019, 8:34am UTC](https://talk.openmrs.org/t/creating-a-new-user-acount-on-mdsbuilder-server/25044/9 "2019-10-18T08:34:20Z")

</div>

Thanks @dkayiwa

---

<div class="post-metadata">

**Author:** ![mozzy](https://talk.openmrs.org/user_avatar/talk.openmrs.org/mozzy/32/11815_2.png) [@mozzy](https://talk.openmrs.org/u/mozzy)\
**Post date:** [October 18, 2019, 11:51am UTC](https://talk.openmrs.org/t/creating-a-new-user-acount-on-mdsbuilder-server/25044/10 "2019-10-18T11:51:05Z")

</div>

Hi @cintiadr , i followed the steps here to Update CIEL on the mdsbuilder to the latest version , and ofcourse i was replacing the sql dump in the example below with the latest version i downloaded from drop box

```
`scp` `openmrs_concepts_2.0_20181012.sql.zip <username>@mdsbuilder.openmrs.org:` `/tmp/openmrs_concepts_2` `.0_20181012.sql.zip`

`ssh` `<username>@mdsbuilder.openmrs.org`

`cd` `/tmp`

`unzip openmrs_concepts_2.0_20181012.sql.zip`

`sudo` `-i`

`cd` `/root/docker/mdsbuilder`

`docker ` `cp` `/tmp/openmrs_concepts_2` `.0_20181012.sql mdsbuilder_db_1:` `/tmp/`

`docker ` `exec` `-it mdsbuilder_db_1 ` `/bin/bash`

`# copy as is, do not attempt to replace it`

`mysql -u ${MYSQL_USER} -p${MYSQL_PASSWORD} ${MYSQL_DATABASE} < ` `/tmp/openmrs_concepts_2` `.0_20181012.sql`

`exit`

```

Am trying to test out the Concept dictionary on the mdsBuilder server by searching a concept, to see whether it was updated with the Latest CIEL that i uploaded. However every concept i search out , i get this error

`Error while attempting to find concepts - could not extract ResultSet`

.  
i followed the script step by step. and i can check and see that the sql dump i uploaded exists in the /tmp directory

i have downloaded the concept dictionary from the mdsBuilder server and its empty. i there any command that needs to get updated in the above script for the sql file to be loaded in the database ?.

---

<div class="post-metadata">

**Author:** ![mozzy](https://talk.openmrs.org/user_avatar/talk.openmrs.org/mozzy/32/11815_2.png) [@mozzy](https://talk.openmrs.org/u/mozzy)\
**Post date:** [October 18, 2019, 12:25pm UTC](https://talk.openmrs.org/t/creating-a-new-user-acount-on-mdsbuilder-server/25044/11 "2019-10-18T12:25:35Z")

</div>

And from the above issue , i cant update metadata sharing packages for the Reference Application Concepts. i get this error on creating a new version of the packge [https://pastebin.com/rvmhFuan](https://pastebin.com/rvmhFuan)

---

<div class="post-metadata">

**Author:** ![mozzy](https://talk.openmrs.org/user_avatar/talk.openmrs.org/mozzy/32/11815_2.png) [@mozzy](https://talk.openmrs.org/u/mozzy)\
**Post date:** [October 18, 2019, 1:22pm UTC](https://talk.openmrs.org/t/creating-a-new-user-acount-on-mdsbuilder-server/25044/12 "2019-10-18T13:22:07Z")

</div>

Actually , when i query the databse directly via command line , using the credentaials here

> [@mozzy](#):
>
> mysql -u ${MYSQL\_USER} -p${MYSQL\_PASSWORD} ${MYSQL\_DATABASE}

, i can see the database is updated with the latest CIEL that i have uploaded.  
However i cant understand why i cant see a single concept when i search it via the UI

 ![image](https://talk.openmrs.org/uploads/default/original/2X/2/219f46c4abcc7cfdb70caef4bbd0eeb33597bf94.png)

---

<div class="post-metadata">

**Author:** ![burke](https://talk.openmrs.org/user_avatar/talk.openmrs.org/burke/32/17_2.png) [@burke](https://talk.openmrs.org/u/burke)\
**Post date:** [October 18, 2019, 1:37pm UTC](https://talk.openmrs.org/t/creating-a-new-user-acount-on-mdsbuilder-server/25044/13 "2019-10-18T13:37:01Z")

</div>

> [@mozzy](#):
>
> However i cant understand why i cant see a single concept when i search it via the UI

Has the concept dictionary been indexed?

---

<div class="post-metadata">

**Author:** ![mozzy](https://talk.openmrs.org/user_avatar/talk.openmrs.org/mozzy/32/11815_2.png) [@mozzy](https://talk.openmrs.org/u/mozzy)\
**Post date:** [October 18, 2019, 1:47pm UTC](https://talk.openmrs.org/t/creating-a-new-user-acount-on-mdsbuilder-server/25044/14 "2019-10-18T13:47:46Z")

</div>

> [@burke](#):
>
> Has the concept dictionary been indexed?

Hi @burke , are you talking about [this](https://wiki.openmrs.org/display/docs/Concept+Indexing) ?

i seem not able to see this functionality here

`Administration -> Update Concept Index.`

---

<div class="post-metadata">

**Author:** ![mozzy](https://talk.openmrs.org/user_avatar/talk.openmrs.org/mozzy/32/11815_2.png) [@mozzy](https://talk.openmrs.org/u/mozzy)\
**Post date:** [October 18, 2019, 2:07pm UTC](https://talk.openmrs.org/t/creating-a-new-user-acount-on-mdsbuilder-server/25044/15 "2019-10-18T14:07:17Z")

</div>

i tried to rebuild the search index

`Administration >> search index`  
but i still get the same issue when searching for a concept via UI

here are the Logs on trying torebuild search index [https://pastebin.com/2k7Vb8N5](https://pastebin.com/2k7Vb8N5)

and this is the server log when i try to search for a concept

```
|ERROR - SqlExceptionHelper.logExceptions(146) |2019-10-18 14:17:49,944| Unknown column 'concept0_1_.precise' in 'field list'|
| --- | --- | --- |
|ERROR - SqlExceptionHelper.logExceptions(146) |2019-10-18 14:17:49,941| Unknown column 'concept0_1_.precise' in 'field list'|
|ERROR - SqlExceptionHelper.logExceptions(146) |2019-10-18 14:17:49,939| Unknown column 'concept0_1_.precise' in 'field list'|
|ERROR - SqlExceptionHelper.logExceptions(146) |2019-10-18 14:17:49,938| Unknown column 'concept0_1_.precise' in 'field list'|
```

---

<div class="post-metadata">

**Author:** ![dkayiwa](https://talk.openmrs.org/user_avatar/talk.openmrs.org/dkayiwa/32/179_2.png) [@dkayiwa](https://talk.openmrs.org/u/dkayiwa)\
**Post date:** [October 18, 2019, 2:26pm UTC](https://talk.openmrs.org/t/creating-a-new-user-acount-on-mdsbuilder-server/25044/16 "2019-10-18T14:26:17Z")

</div>

What is the name of the CIEL file that you used to update the database?

---

<div class="post-metadata">

**Author:** ![mozzy](https://talk.openmrs.org/user_avatar/talk.openmrs.org/mozzy/32/11815_2.png) [@mozzy](https://talk.openmrs.org/u/mozzy)\
**Post date:** [October 18, 2019, 2:30pm UTC](https://talk.openmrs.org/t/creating-a-new-user-acount-on-mdsbuilder-server/25044/17 "2019-10-18T14:30:00Z")

</div>

openmrs\_concepts\_2.2\_20190701.sql

i downloaded it from openrs account on drop box

---

<div class="post-metadata">

**Author:** ![dkayiwa](https://talk.openmrs.org/user_avatar/talk.openmrs.org/dkayiwa/32/179_2.png) [@dkayiwa](https://talk.openmrs.org/u/dkayiwa)\
**Post date:** [October 18, 2019, 2:40pm UTC](https://talk.openmrs.org/t/creating-a-new-user-acount-on-mdsbuilder-server/25044/18 "2019-10-18T14:40:46Z")

</div>

That is the cause of the problem. mdsbuilder is running platform 2.0.6 instead of 2.2

So you need to use the CIEL file for platform 2.0.6

---

<div class="post-metadata">

**Author:** ![mozzy](https://talk.openmrs.org/user_avatar/talk.openmrs.org/mozzy/32/11815_2.png) [@mozzy](https://talk.openmrs.org/u/mozzy)\
**Post date:** [October 18, 2019, 2:47pm UTC](https://talk.openmrs.org/t/creating-a-new-user-acount-on-mdsbuilder-server/25044/19 "2019-10-18T14:47:10Z")

</div>

here are the versions updated

```
1.6.6, 1.9.9, 1.10.2, 1.11.4 and 2.0, 2.1 and 2.2!

```

So i instead update with this `openmrs_concepts_2.0_20190701.sql` ??

 ![image](https://talk.openmrs.org/uploads/default/original/2X/b/be8393286232a41bf175109536f7e99477500360.png)

---

<div class="post-metadata">

**Author:** ![dkayiwa](https://talk.openmrs.org/user_avatar/talk.openmrs.org/dkayiwa/32/179_2.png) [@dkayiwa](https://talk.openmrs.org/u/dkayiwa)\
**Post date:** [October 18, 2019, 3:00pm UTC](https://talk.openmrs.org/t/creating-a-new-user-acount-on-mdsbuilder-server/25044/20 "2019-10-18T15:00:05Z")

</div>

> [@mozzy](#):
>
> So i instead update with this `openmrs_concepts_2.0_20190701.sql` ??

Yes that is the one.

[Next page](https://talk.openmrs.org/t/creating-a-new-user-acount-on-mdsbuilder-server/25044.md?page=2)