Page 1 of 2

API Express database connection not working after update

Posted: Tue Sep 29, 2015 5:13 pm
by Dandy Ling Kwong

My API Express database connection used to work. However, after the update on September 27, it doesn't work anymore. Has the update changes anything (e.g. the app server ip address etc)


API Express database connection not working after update

Posted: Tue Sep 29, 2015 9:03 pm
by Illya Stepanov

Hi Dandy -

Could you please clarify, are you getting any errors? Could you please show them to us?


API Express database connection not working after update

Posted: Tue Sep 29, 2015 9:46 pm
by square_monster

Hi IIIya,

Sorry to jump into this thread but I seem to be having the same problem. My APIs which are used to grab data from my MySQL database don't seem to work after the update.

I have tried all sorts to get this working but no luck. I keep getting an Internal Server error after the page crashes for a minute or too.

Everything used to work before. I've contacted my host and they have confirmed that the IPs required for the API server to work (52.x.x.x etc) are allowed to connect as they are in the Remote MySQL table and nothing has changed.

I have some screen shots from a post I made here yesterday which may help you understand the problem which we are experiencing.

Please find the link below:

https://getsatisfaction.com/apperyio/...

Thanking you in advance,
Luigi


API Express database connection not working after update

Posted: Wed Sep 30, 2015 5:31 am
by Dandy Ling Kwong

Hi Ilya,

The api express will stuck at this screen for 130 seconds. Image

Then, it will popup says 'Cannot connect to database. Please verify connection credentials and try again.'

Image

In AWS rds, I have white listed Appery.io's app server as follows:
52.7.79.49/32
52.6.213.128/32
52.3.49.193/32

Image

This configuration used to work without problem until after the update. Thus, I was wondering if the app server ip address changed?


API Express database connection not working after update

Posted: Thu Oct 01, 2015 7:16 am
by Dandy Ling Kwong

Hi, can I know how is this problem fix going along? My whole project is stopped because of this, and I cannot continue for 2 days now.


API Express database connection not working after update

Posted: Sat Oct 03, 2015 1:40 am
by Dandy Ling Kwong

I finally confirmed the problem. I whitelisted all ip by setting 0.0.0.0/0 in inbound rules, and I can access the database now.

Thus, it is confirmed that the ip address of app server changed after the update on Sep 27th. This link https://devcenter.appery.io/documenta... is not updated to reflect this


API Express database connection not working after update

Posted: Sat Oct 03, 2015 7:18 pm
by Illya Stepanov

Hi Dandy -

We are sorry for delay here.

We need to check this issue with more details from our side, could you please submit a support request to us at: a href="mailto:support@appery.io" rel="nofollow"support@appery.io/a -- with reference to this forum post.


API Express database connection not working after update

Posted: Mon Oct 05, 2015 1:00 pm
by Illya Stepanov

Hi all -

We apologize, but our application servers DNS for API Express are now codeaex1.appery.io/code and codeaex2.appery.io/code

We have updated our docs -- https://devcenter.appery.io/documenta...


API Express database connection not working after update

Posted: Fri Feb 19, 2016 4:10 pm
by Michael Droll

I'm still getting the same error when trying to connect to the Google SQL.

I have followed the tutorial here: https://devcenter.appery.io/documenta...


API Express database connection not working after update

Posted: Tue Oct 11, 2016 4:49 pm
by Oren Yehezkely

Hello,

It seems to me that the list is not complete as I am not able to connect to my 3rd party provider with the listed hosts.
Thanks!