Whitelisting IPs to connect


#1

Hello,
For the limited developer Instance (non production)
I am trying to connect to VPSs Database, but since it has a firewall, i guess i need to whitelist DreamFactory’s IP

Where can i find the IP for the developer instances?
Thanks


#2

Hey @stevejohnson

GET system/environment

Thanks,
@AlexBowen


#3

Hi,
Sorry noob here.
Just figured that GET system/environment is in the API Docs tab > Systems option

On doing a “try it” for this API call, i get -

“client”: {
“user_agent”: “Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/54.0.2840.71 Safari/537.36”,
“ip_address”: “xxx.xxx.xx.xx”,
“locale”: “en”
},

Just wanted to confirm if this the right location for dreamfactory’s IP for my hosted instance?
Thanks


#4

Whitelisted this IP, cannot connect
(my mysql DB is open to receive external connections)

What i did :

  • Created a mysql service, and put all necessary values including host and all DB information
  • On the API docs, tried the “GET /mysqlservicename/_table” … i get this -
    {
    “error”: {
    “context”: null,
    “message”: “SQLSTATE[HY000] [2003] Can’t connect to MySQL server on ‘xx.xx.xx.xx’ (4)”,
    “code”: 2003,