web stats
Custom PostgreSQL Database Missing Username - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 09-30-2014, 06:32 AM
hightorm hightorm is offline
Mirth Newb
 
Join Date: Nov 2013
Location: South Carolina
Posts: 6
hightorm is on a distinguished road
Default Custom PostgreSQL Database Missing Username

We have a custom PostgreSQL database installed on the Mirth appliance. It did have a username, or database owner; however, in the Database Management section of the Mirth appliance web interface, the username has disappeared.

I am trying to connect to the database using pgAdmin, but without the username, I cannot connect to the server.

Is there a way to add the username back to the database?

Thanks.
Reply With Quote
  #2  
Old 09-30-2014, 06:55 AM
cory_cole cory_cole is offline
Mirth Guru
 
Join Date: Mar 2012
Posts: 1,277
cory_cole is on a distinguished road
Default

From the Mirth Appliance, under Services, select Database. That will have the username and a place to reset the password.
Reply With Quote
  #3  
Old 09-30-2014, 07:00 AM
hightorm hightorm is offline
Mirth Newb
 
Join Date: Nov 2013
Location: South Carolina
Posts: 6
hightorm is on a distinguished road
Default

There is no input field for the username; there is a field for the password.
Reply With Quote
  #4  
Old 09-30-2014, 07:03 AM
hightorm hightorm is offline
Mirth Newb
 
Join Date: Nov 2013
Location: South Carolina
Posts: 6
hightorm is on a distinguished road
Default

I tried enabling Read-Only User, but it won't let me make the change without a username.
Reply With Quote
  #5  
Old 09-30-2014, 07:13 AM
cory_cole cory_cole is offline
Mirth Guru
 
Join Date: Mar 2012
Posts: 1,277
cory_cole is on a distinguished road
Default

The username is already there. You can also add a DB, and create a new username.
Reply With Quote
  #6  
Old 09-30-2014, 09:11 AM
hightorm hightorm is offline
Mirth Newb
 
Join Date: Nov 2013
Location: South Carolina
Posts: 6
hightorm is on a distinguished road
Default

In the HTML for the page:
<tr>
<td class="label">Database Username:</td>
<td>
<input type="hidden" name="dbuser" value="">
<span class="hint-container"><span class="hint">Name of the Database User.<span class="hint-pointer">&nbsp;</span></span></span>
</td>

myform.dbname has the value "TransDB"

For the mirthdb database, the username field has the value "mirthdb"

This is the error that I'm getting:
...
} else if (document.myform.dbuser.value == "") {
errormessage = "You must provide a username.";
}
Reply With Quote
Reply

Tags
administrator, postgresql

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 07:24 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Mirth Corporation