Author Topic: Is there a way to connect to the online DB from Yemulator?  (Read 2946 times)

Dechcaudron

  • Jr. Member
  • **
  • Posts: 51
    • View Profile
Is there a way to connect to the online DB from Yemulator?
« on: June 08, 2014, 08:59:03 PM »
Hi GCC,

since me and my team use version control to manage our project, it is quite difficult to share a posgresql common structure since they are saved in a separate address in our computers. Are we able to connect to the online db? I can't seem to do it.

Thanks beforehand,
Dechcaudron

Antoine

  • Global Moderator
  • Newbie
  • *****
  • Posts: 13
    • View Profile
Re: Is there a way to connect to the online DB from Yemulator?
« Reply #1 on: June 09, 2014, 08:59:16 AM »
Hi Dechcaudron,

All you need to do is change the connection string in app.config and it should work fine. Are you sure, you're inputting the correct information there? Maybe you have the host or port wrong, or something like that :) Also, check your firewall settings and make sure that PostgreSQL port is accessible.

Code hard,
Antoine,
The GCC Team

Dechcaudron

  • Jr. Member
  • **
  • Posts: 51
    • View Profile
Re: Is there a way to connect to the online DB from Yemulator?
« Reply #2 on: June 09, 2014, 11:45:46 AM »
Yemulator receives this:

Npgsql.NpgsqlException:
Failed to establish a connection to 'eu02.game-cloud.org'.
  at Npgsql.NpgsqlClosedState.Open (Npgsql.NpgsqlConnector context, Int32 timeout) [0x00000] in <filename unknown>:0
  at Npgsql.NpgsqlConnector.Open () [0x00000] in <filename unknown>:0
  at Npgsql.NpgsqlConnectorPool.GetPooledConnector (Npgsql.NpgsqlConnection Connection) [0x00000] in <filename unknown>:0
ERROR: Db is not working! Please check your connection string and make sure you have running postgresql server 9.1 or 9.2!
Connection string: User ID=postgres;Password=123;Host=eu02.game-cloud.org;Port=8180;Database=game_51;

Happens even with firewall off

Ideas?
« Last Edit: June 09, 2014, 12:06:01 PM by Dechcaudron »

AMarinov

  • Global Moderator
  • Newbie
  • *****
  • Posts: 17
    • View Profile
Re: Is there a way to connect to the online DB from Yemulator?
« Reply #3 on: June 09, 2014, 01:41:58 PM »
Hi, Dechcaudron

There was a misunderstanding about the last question.
At this time, we do not allow databases to be accessed from internet.
We are considering for the future to allow a direct connection to your game databases, however, it will be limited, due to security precautions and it is definitely not an option to be used by multiple users for a shared database.
For your development needs you should setup your own database server accessible by all users of your team.
You could contact us by email for assistance in setting up such a server, we will advice what would be the best option for you depending on your network infrastructure and available hardware.

Regards,
Atanas

Dechcaudron

  • Jr. Member
  • **
  • Posts: 51
    • View Profile
Re: Is there a way to connect to the online DB from Yemulator?
« Reply #4 on: June 09, 2014, 04:20:27 PM »
Hey Amarinov,

It's okay, we understand security measures must be taken at all times. Regarding our "infrastructure" and "hardware" I'll let you know we are a two and a half people team so far, all "full time" students and public transportation travelers, so probably the most we can afford is setting up a Raspberry Pi  ;D

Anyway, thanks for the information GCC,
Dechcaudron