# Installation error

**URL:** <https://forum.metasfresh.org/t/installation-error/959>\
**Category:** Setup\
**Tags:** english\
**Created:** [March 13, 2018, 10:08am UTC](https://forum.metasfresh.org/t/installation-error/959 "2018-03-13T10:08:56Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![from](https://forum.metasfresh.org/letter_avatar_proxy/v4/letter/f/838e76/32.png) [@from](https://forum.metasfresh.org/u/from)\
**Post date:** [March 13, 2018, 10:08am UTC](https://forum.metasfresh.org/t/installation-error/959/1 "2018-03-13T10:08:56Z")

</div>

Hi,  
I am receiving an error when trying to connect to the database. I can ping from my Windows client to the IP address of the cloud server on which I installed Metasfresh.  
See attached screenshot of the error.

 ![](https://forum.metasfresh.org/uploads/default/original/1X/8285bfe704d951d9b6a3f7a69a378818a69b2247.jpg)  
Does anybody has an idea on how to solve this?

Thank you.

---

<div class="post-metadata">

**Author:** ![julian.bischof](https://forum.metasfresh.org/user_avatar/forum.metasfresh.org/julian.bischof/32/36_2.png) [@julian.bischof](https://forum.metasfresh.org/u/julian.bischof)\
**Post date:** [March 14, 2018, 9:28am UTC](https://forum.metasfresh.org/t/installation-error/959/2 "2018-03-14T09:28:01Z")

</div>

Hi @from

Using the Java application, a hostname is required instead of an IP address (basically, there are not `.` allowed in the fields where you define the application- and database-hostname).  
This can be solved by eg. adding the hostname of your server (the actual hostname that is being displayed, when you enter `hostname` on your server) to your hosts file on Windows or by using an internal DNS-Server.

Also be sure you can access these ports from your client to your server:  
`5432/TCP` - for the database connection  
`8282/TCP` - for the application  
`61616/TCP` - for the application as well

Also as heads up, I would not recommend using the Java client if your server is located in a remote datacenter.  
The connection using JDBC is not optimized for latencies which are not LAN. You CAN use it - but you might get timeouts or random disconnects or at least a veeery slow response time from the application, which does not reflect the performance of metasfresh at all.

---

<div class="post-metadata">

**Author:** ![from](https://forum.metasfresh.org/letter_avatar_proxy/v4/letter/f/838e76/32.png) [@from](https://forum.metasfresh.org/u/from)\
**Post date:** [March 19, 2018, 11:16am UTC](https://forum.metasfresh.org/t/installation-error/959/3 "2018-03-19T11:16:39Z")

</div>

Hello Julian,

Thank you for your reply!  
I have checked the ports and hostname and they are all correct (See attached)  
 ![](https://forum.metasfresh.org/uploads/default/original/1X/f5fa76146e4a10276468ab69c569f4d9c834f81e.png)

I can connect to the application server but using the test database button is not working.  
I however can connect to the metasfresh database and see all the tables using Valentina studio.

I hope you can still provide a solution so I can start testing metasfresh.

Thank you

---

<div class="post-metadata">

**Author:** ![rajan\_jain](https://forum.metasfresh.org/letter_avatar_proxy/v4/letter/r/b77776/32.png) [@rajan\_jain](https://forum.metasfresh.org/u/rajan_jain)\
**Post date:** [September 19, 2019, 12:01pm UTC](https://forum.metasfresh.org/t/installation-error/959/4 "2019-09-19T12:01:33Z")

</div>

Hello Guys,

I have a similar error.  
I am trying to install java client on my windows system. There is no problem in establishing connection with server but when i try to connect to database, I get an error. Please refer to the screen shot attached.

I will really appreciate if somebody could help me with this.

[  
database\_connection\_error.PNG1761×696 332 KB  
 ](https://forum.metasfresh.org/uploads/default/original/1X/a3e92ca78a00e1c608ae29eae6e5627416c6aa6f.png)

Thanks

---

<div class="post-metadata">

**Author:** ![julian.bischof](https://forum.metasfresh.org/user_avatar/forum.metasfresh.org/julian.bischof/32/36_2.png) [@julian.bischof](https://forum.metasfresh.org/u/julian.bischof)\
**Post date:** [September 20, 2019, 10:02am UTC](https://forum.metasfresh.org/t/installation-error/959/5 "2019-09-20T10:02:04Z")

</div>

Hi @rajan_jain

It looks like you’re using the docker installation for running the metasfresh server side.

Please note if not already done, you will also need to port-bind `5432` from the db-container to your dockerhost.

The main issue for connecting via Java client are these:

- you will need to avoid clicking that “Test Application Server” Button so it won’t autofill the `Database` fields
- remove the Hostname for `Application Host`
- remove `Application Port` (61616)
- manually (!) enter following fields to `Database` entries (note if you mistakenly hit the “Test Application Server Button” the fields are greyed out and can’t be modified. so don’t click the button):
  - `Database-Host:` -\> Hostname of your dockerhost/server
  - `Database-Port:` -\> “5432” (or whatever Port you docker-port-bound to your dockerhost)
  - `Database Name:` -\> “metasfresh”
  - `User/Password:` -\> “metasfresh”/“metasfresh”

- Do NOT click the “Test Database” Button
- Just click on the “Checkmark” Button on lower right hand side of the window
- Connect with your User and Password

Please note:

- using the swing client is deprecated and nowadays only used for developing purposes - for normal production usage, please use the WebUI
- you won’t benefit from Notifications and other Application-Server related features since you don’t connect to the application server at all

Important:  
You still might get errors when connecting to the server. This is due to the fact that the Java Client can’t handle “.” (dots) in hostnames very well.  
You might want to add a new `hosts` entry in your windows config to keep the hostname simple (eg: `myserver` instead of `my.server.com`) or change your DNS accordingly.

---

<div class="post-metadata">

**Author:** ![rajan\_jain](https://forum.metasfresh.org/letter_avatar_proxy/v4/letter/r/b77776/32.png) [@rajan\_jain](https://forum.metasfresh.org/u/rajan_jain)\
**Post date:** [September 23, 2019, 9:45am UTC](https://forum.metasfresh.org/t/installation-error/959/6 "2019-09-23T09:45:47Z")

</div>

Hi Julian,

Thanks a lot for your quick response, I am now able to connect. I am past that error but now I am encountering different error. After authorising userID and password. And clicking the check button on Default tab I encounter the error. Please refer my screenshots.  
Please let me know if you have any idea about this error.

 ![before_error](https://forum.metasfresh.org/uploads/default/original/1X/2478cbbfe2a80573815c7db8a2be54eadc9552f0.png) ![error](https://forum.metasfresh.org/uploads/default/original/1X/3fe88591f496b5fe1d976f69ffa4a622f3ecafcf.png)

---

<div class="post-metadata">

**Author:** ![Santosh\_Easale](https://forum.metasfresh.org/user_avatar/forum.metasfresh.org/santosh_easale/32/951_2.png) [@Santosh\_Easale](https://forum.metasfresh.org/u/Santosh_Easale)\
**Post date:** [January 26, 2024, 6:17am UTC](https://forum.metasfresh.org/t/installation-error/959/7 "2024-01-26T06:17:21Z")

</div>

Hi Julian, we are seeing the same error but for ubuntu machine. Can you suggest few solutions to it.
