# Whitelisting IPs to connect

**URL:** <https://community.dreamfactory.com/t/whitelisting-ips-to-connect/3397>\
**Category:** Connecting to SQL\
**Created:** [November 1, 2016, 6:32pm UTC](https://community.dreamfactory.com/t/whitelisting-ips-to-connect/3397 "2016-11-01T18:32:01Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![stevejohnson](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/stevejohnson/32/861_2.png) [@stevejohnson](https://community.dreamfactory.com/u/stevejohnson)\
**Post date:** [November 1, 2016, 6:32pm UTC](https://community.dreamfactory.com/t/whitelisting-ips-to-connect/3397/1 "2016-11-01T18:32:01Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![DFCommunityManager](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/dfcommunitymanager/32/887_2.png) [@DFCommunityManager](https://community.dreamfactory.com/u/DFCommunityManager)\
**Post date:** [November 1, 2016, 6:50pm UTC](https://community.dreamfactory.com/t/whitelisting-ips-to-connect/3397/2 "2016-11-01T18:50:52Z")

</div>

Hey @stevejohnson

`GET system/environment`

Thanks,  
@AlexBowen

---

<div class="post-metadata">

**Author:** ![stevejohnson](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/stevejohnson/32/861_2.png) [@stevejohnson](https://community.dreamfactory.com/u/stevejohnson)\
**Post date:** [November 1, 2016, 7:13pm UTC](https://community.dreamfactory.com/t/whitelisting-ips-to-connect/3397/3 "2016-11-01T19:13:22Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![stevejohnson](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/stevejohnson/32/861_2.png) [@stevejohnson](https://community.dreamfactory.com/u/stevejohnson)\
**Post date:** [November 1, 2016, 8:39pm UTC](https://community.dreamfactory.com/t/whitelisting-ips-to-connect/3397/4 "2016-11-01T20:39:18Z")

</div>

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,