amazon web services - Getting AppHarbor and AWS RDS MySql to play nice -

-

i have app 2 workers (web , background) on appharbor connect mysql database hosted on amazon's rds.

i keep getting "unable connect of specified mysql hosts." exception.

the rds instance in us-east region , have added following appharbor cidr security group.

  • 50.17.211.192/28
  • 54.235.159.192/27

i have added own cidr security group , connect instance fine. when app running on appharbor fails.

my connection string (censored) is:

server=myinstancexxxx.cykjvptrw5xs.us-east-1.rds.amazonaws.com;database=mydatabase;uid=xxxxxx;pwd=xxxxx;

i have tried including port 3306 on server endpoint made no difference.

am missing on getting 2 play nice 1 another?

by default appharbor use amazon's internal dns service resolving hostnames. because of amazon rds instances in same region appharbor resolve private ip addresses rather public ones listed in knowledge base article, setting rules based on public ips not work of time.

in case amazon's dns service becomes unavailable we'll fail on external dns service. means you'll still have configure external ips highest availability external dns service resolve public ips. way can ensure application resilient towards dns failures.

you can set security group based access rules rds security group. we've updated this knowledge base article section amazon rds can find information necessary set up.


Comments

Post a Comment

Popular posts from this blog

c++ - Creating new partition disk winapi -

-
i'am trying create new partition , mount volume new, thought createfile let me this, code : lpctstr lpfilename=l"\\\\.\\device\\harddisk0\\partition3"; handle handl=createfile( lpfilename, generic_read | generic_write, file_share_read | file_share_write, null, create_always, file_attribute_normal, null ); if (handl==invalid_handle_value) { qdebug()<<"handl invalid"<<" error"<<getlasterror();} bool success = definedosdevice(ddd_raw_target_path,l"i:",l"\\device\\harddisk0\\partition3"); if(!success) qdebug()<<" definedosdevice failed "<<getlasterror(); bflag = getvolumenameforvolumemountpoint( l"i:\\", // input volume mount point or directory /** u in dir
Read more

Android Prevent Bluetooth Pairing Dialog -

-
i'm developing internal application uses bluetooth printing. want bluetooth pairing occur without user input. have managed working trapping android.bluetooth.device.action.pairing_request broadcast. in broadcast receiver call setpin method, , pairing works ok, bluetoothpairingdialog displayed second or two, disappears - see link below. https://github.com/android/platform_packages_apps_settings/blob/master/src/com/android/settings/bluetooth/bluetoothpairingdialog.java since broadcast non-ordered, can't call abortbroadcast() , , wondering if there other way prevent pairing dialog appearing. can hook window manager in way? i haven't been able come way without modifying sdk. if you're oem, it's easy (i'm on 4.3): in packages/apps/settings/androidmanifest.xml, comment intent filter pairing dialog: <activity android:name=".bluetooth.bluetoothpairingdialog" android:label="@string/bluetooth_pairing_request"
Read more

VBA function to include CDATA -

-
i have following function include cdata: function cdatasection() dim objdom domdocument dim objkmlrootelement ikmldomelement dim objkmlelement ikmldomelement dim cdata ikmldomcdatasection set objdom = new domdocument set objkmlrootelement = objdom.createelement("balloonstyle") objdom.appendchild objkmlrootelement set objkmlelement = objdom.createelement("text") objkmlrootelement.appendchild objkmlelement set cdata = objdom.createcdatasection("text") cdata.data = "<![cdata[<b>latitude = $[latitude]</b>?]]>;" end function when run above, getting error "user defined data type not found" function. yes ripster says find library reference. vba window tools>references for list of relevant references see... http://msdn.microsoft.com/en-us/library/windows/desktop/ms763701%28v=vs.85%29.aspx however, if have hard time tracking down reference, replace dim sta
Read more