Amazon RDS connection issue
Hi,
I think I have an issue that has come up where my app is no longer connecting to my RDS instance from Appharbor. I haven't submitted a new build in a long while... and it used to work?
Is this still your security group # on amazon? 136621386816 with name "web"... I know the post that described this setup mentioned maintenance may be required in the future.
Thanks,
Dane
Comments are currently closed for this discussion. You can start a new one.
Support Staff 2 Posted by friism on 24 Apr, 2012 08:07 PM
Hi Dane, this should still be current and only if you used the AppHarbor IP range to grant access would you require updates. Here's the relevant kb article: http://support.appharbor.com/kb/tips-and-tricks/application-server-...
Have you ruled out other possible problems?
Michael
3 Posted by dane on 25 Apr, 2012 01:49 PM
Hi,
I have found that it is definitely the RDS connection...
System.InvalidOperationException: Connection must be valid and open. at MySql.Data.MySqlClient.MySqlCommand.CheckState() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader() at MySmartFuel.HLdatabaseaccess.login(String un, String pw)
Note: This connection works fine when running the project on my local machine while connecting to RDS.
This worked fine for months on Appharbor...
I'm not sure but I think the change might have been Sunday around 11:30AM PST? That is not definite but I have some other evidence that it could have been then... was there a system update or change around that time?
Thanks,
Dane
Support Staff 4 Posted by friism on 26 Apr, 2012 04:53 AM
Hi Dane, we have not introduced any changes that would affect this. You should probably verify that your application is running with the correct connectionstring (and that AppHarbor is not somehow overwriting or transforming it) and that we're using the mysql-driver versions you expect (you can do this by downloading the build output).
Does it work if you roll back to the previous commit?
Michael
5 Posted by dane on 26 Apr, 2012 04:45 PM
Hi,
Previous commits do not work either.... I've dug a bit deeper... does this look familar to you?
I'm not using NewRelic add-on
Could not load type 'NewRelic.Agent.Core.AgentShim' from assembly 'mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'. at MySql.Data.MySqlClient.MySqlConnection.Open() at MySmartFuel.HLdatabaseaccess.login(String un, String pw) in C:\Users\Dane\Dropbox\MySmartFuel\MySmartFuel\HLclasses\HLdatabaseaccess.vb:line 1185
Support Staff 6 Posted by friism on 26 Apr, 2012 08:41 PM
Thanks for following up -- this is an issue that surfaced last week. Unless New Relic provides a resolution, we'll be removing the offending client today or tomorrow.
Sorry about the breakage.
Michael
7 Posted by dane on 27 Apr, 2012 10:33 PM
We have to have this fixed! Any word!
Support Staff 8 Posted by friism on 27 Apr, 2012 10:57 PM
The New Relic agent is gone now, let us know if that didn't resolve the issue.
Sorry about the breakage.
Michael
9 Posted by dane on 27 Apr, 2012 11:13 PM
Oh, I didn't know it was taken b/c I thought it would automatically come back up. But my MySQL instance started blocking the connection b/c of too many failed attempts. So I had to run FLUSH HOSTS and then it came back! Great news!
Support Staff 10 Posted by friism on 27 Apr, 2012 11:15 PM
Great, glad you're up again.
Again, we apologize for the inconvenience.
Michael
11 Posted by dane on 03 Dec, 2012 11:18 PM
This can be closed.
friism closed this discussion on 03 Dec, 2012 11:31 PM.