Database bridge: ERROR: http/1.1 503 service unavailable

Database bridge: ERROR: http/1.1 503 service unavailable

Avatar image
Aug 21, 2014
Jay Penney wrote
Hello,

I recently upgraded my Magento installation from 1.8 to 1.9.0.1 and about the same time implemented varnish cache.

When I try and "Get data from web" it returns http/1.1 503 service unavailable. I tried to import products with a direct connection but the program hangs.

The port to talk directly to the apache server is 8080, not sure if that helps.

Please guide me on fixing this issue.

Thank you kindly in advance,

Jay
Reply
7 Answers
Avatar image
Aug 22, 2014
Tania Hetman agent wrote
Error code 503 is returned by you Server itself. It means that we cannot reach your server via provided port with provided settings. To make sure that the server is configured correctly, you should try to connect with same settings using any other MySQL client.

In case you can connect with any other application, please provide us with the screen of your settings (from the application you use to test) and a screen of same settings in Store Manager via contact@emagicone.com to check it.

You may also try to use different type of connection to your database that doesn't require port 3306 and direct MySQL access - tunnel or bridge.
Avatar image
Aug 22, 2014
Jay Penney wrote
Thank you for your reply but your assumption is incorrect.

The error clearly says http not an MySQL error and this is from your software.

If I connect directly without the bridge there is no issue until I try and import products because I have a large database.

I believe the problem is that for some reason store manager does some sort of check on port 80 (web) and because I am using a reverse proxy (varnish cache) it is not getting the expected response.

To confirm this, I stopped my varnish cache service (which was on port 80), httpd service and change the httpd back to port 80 so that store manager will speak to the server directly. Once I did this the database bridge began to work.

I cannot do this every time I need to do something on the bridge, I would really appreciate if you guys could try setting up a similar environment to confirm what I am telling you.

The server and website were working just fine with varnish installed, the only problem is with the bridge.

Kindly let me know,

Jay
Avatar image
Aug 25, 2014
Support Manager agent wrote
Hello Jay,

Thank you for your reply

Actually you are correct that issue is related to caching that is setup at your server - Store Manager is trying to retrieve the data, but your server cached the information that prevent bridge to complete getting data.

Please ask your hosting provider or store developer to exclude bridge.php from caching - in other case, you have to disable cache each time you want to perform Get data from web.

Let us know how it goes
Dec 31, 2014
Dan wrote
I'm having the same problem. I have excluded both the tmp directory and the bridge file from varnish but I'm still getting a 503 when trying to fetch the data from the web.

Thanks,
Dan
Avatar image
Jan 02, 2015
Andrii Yanosh agent wrote
Hello Dan,

Please submit a ticket at: http://support.emagicone.com/submit_ticket and provide us with your store configuration file, so we could check possible connection options for you.

*You can save you store configuration file at: Store Manager > Preferences(F12) > Database Connection tab > Store Configuration section > Actions... > Save current configuration: http://screencast.com/t/Hmy0nUDBsHJc
Jan 02, 2015
Dan wrote
I figured out the problem so I'll post it here in case anyone else needs it. The issue was with a timeout in varnish. I simply added .first_byte_timeout = 300s; to the appropriate backend definition in varnish and it works great.

Thanks for the response.
Dan
Avatar image
Jan 05, 2015
Support Manager agent wrote
Hello Dan

Thank you for letting us know.

Hope this solution will help other customers as well

Feel free to contact us if you have more questions