DSP Remote SQL DB went down on Amazon EC2

[praveen]

Hi,

I use DSP for my mobile APP and my DSP is hosted on Bitnami LAMP stack on Amazon.
Today suddenly I noticed that my Remote SQL stopped working.

Nothing we did. For no reason suddenly it stopped.

I restarted my Apache. Did not help.
I restarted my EC2 instance, and that sorted the issue.

The error I was getting is the very well known DB connection error, which I face on my Locally installed DSP, which I have still not been able to run.

Can't connect to PostgreSQL using Remote DB SQL option. (PGSql installed locally)

I have installed the DSP locally on my Mac Book Pro using Bitnani. I have a PostGreSQL server running locally on my Macbook, which I want to connect to using the DSP. I am successfully able to connect to my PostGreSQL server from other applications, which essentially means that there is no problem with the setup. However, on trying to connect the same from DSP I get the error:- “Failed to launch service “sql”: CDbConnection failed to open the DB connection.” My connection string is :- "pgsql…

I don’t want this incident to go waste, and want some guidance for the future.
If you can put some light as to what could be the probable error, or if you need some log files etc, please let me know.

I really want to know the cause and remedy so that I can minimize my downtime.

[jeffreystables]

It’s entirely possible something crashed in your LAMP stack. I recommend looking at DSP logs (not likely to be terribly helpful), then Apache logs (where PHP crashes are generally also logged). Apache is likely to provide the most insight.