tag:support.appharbor.com,2010-11-23:/discussions/problems/3793-amazon-rds-connection-issueAppHarbor: Discussion 2018-10-19T03:06:40Ztag:support.appharbor.com,2010-11-23:Comment/155216222012-04-24T20:07:41Z2012-04-24T20:07:41ZAmazon RDS connection issue <div><p>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: <a href=
"http://support.appharbor.com/kb/tips-and-tricks/application-server-ips-ec2-configuration">
http://support.appharbor.com/kb/tips-and-tricks/application-server-...</a></p>
<p>Have you ruled out other possible problems?<br>
Michael</p></div>friismtag:support.appharbor.com,2010-11-23:Comment/155216222012-04-25T13:49:08Z2012-04-25T13:49:08ZAmazon RDS connection issue <div><p>Hi,</p>
<p>I have found that it is definitely the RDS connection...</p>
<p>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)</p>
<p>Note: This connection works fine when running the project on my
local machine while connecting to RDS.</p>
<p>This worked fine for months on Appharbor...</p>
<p>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?</p>
<p>Thanks,<br>
Dane</p></div>danetag:support.appharbor.com,2010-11-23:Comment/155216222012-04-26T04:53:10Z2012-04-26T04:53:10ZAmazon RDS connection issue <div><p>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).</p>
<p>Does it work if you roll back to the previous commit?</p>
<p>Michael</p></div>friismtag:support.appharbor.com,2010-11-23:Comment/155216222012-04-26T16:45:08Z2012-04-26T16:45:08ZAmazon RDS connection issue <div><p>Hi,<br>
Previous commits do not work either.... I've dug a bit deeper...
does this look familar to you?</p>
<p>I'm not using NewRelic add-on</p>
<p>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</p></div>danetag:support.appharbor.com,2010-11-23:Comment/155216222012-04-26T20:41:31Z2012-04-26T20:41:31ZAmazon RDS connection issue <div><p>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.</p>
<p>Sorry about the breakage.<br>
Michael</p></div>friismtag:support.appharbor.com,2010-11-23:Comment/155216222012-04-27T22:33:41Z2012-04-27T22:33:41ZAmazon RDS connection issue <div><p>We have to have this fixed! Any word!</p></div>danetag:support.appharbor.com,2010-11-23:Comment/155216222012-04-27T22:57:37Z2012-04-27T22:57:37ZAmazon RDS connection issue <div><p>The New Relic agent is gone now, let us know if that didn't
resolve the issue.</p>
<p>Sorry about the breakage.<br>
Michael</p></div>friismtag:support.appharbor.com,2010-11-23:Comment/155216222012-04-27T23:13:20Z2012-04-27T23:13:20ZAmazon RDS connection issue <div><p>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!</p></div>danetag:support.appharbor.com,2010-11-23:Comment/155216222012-04-27T23:15:46Z2012-04-27T23:15:46ZAmazon RDS connection issue <div><p>Great, glad you're up again.</p>
<p>Again, we apologize for the inconvenience.</p>
<p>Michael</p></div>friismtag:support.appharbor.com,2010-11-23:Comment/155216222012-12-03T23:18:23Z2012-12-03T23:18:23ZAmazon RDS connection issue <div><p>This can be closed.</p></div>dane