asp.net - Elastic Beanstalk w/ Associated RDS; Unable to find/access RDS related environment variables -


i've created new elastic-beanstalk environment associated rds (ms sql express). able connect rds instance local machine using microsoft sql server management studio using master account credentials provided @ setup. however, having hard time accessing "rds environment" variables supposed available application.

here example outlined in aws's docs:

  var appconfig = configurationmanager.appsettings;   string dbname = appconfig["rds_db_name"];    if (string.isnullorempty(dbname)) return null;    string username = appconfig["rds_username"];   string password = appconfig["rds_password"];   string hostname = appconfig["rds_hostname"];   string port = appconfig["rds_port"];    return "data source=" + hostname + ";initial catalog=" + dbname + ";user id=" + username + ";password=" + password + ";";

my project asp.net core 1.1 project. when attempt access these values using configuration.getvalue<string>("rds_db_name");, recieve null/empty string values.

here ebs configuration settings:

scaling:

  • environment type: load balanced, auto scaling
  • number instances: 1-4

instances:

  • instance type: t1.micro

software configuration:

  • enable 32-bit applications: false
  • target .net runtime: 4.0

rds:

  • endpoint: xxx:1433
  • engine: sqlserver-ex
  • instance class: db.t2.micro
  • storage: 30gb
  • multi availability zone: false
  • when environment deleted: data lost
  1. how access these values application?
  2. how access these values when rdp'd ec2 instance?
  3. why master account show single database named rdsadmin has tables? application's db???
  4. why aren't these values visible or manageable via eb dashboard?

any , appreciated.

update

create small snippet view configuration key/values. output contained environment variables, none appeared specific rds instance.

 var allkeys = "";  foreach (iconfigurationsection conf in configuration.getchildren().tolist())  {      allkeys += "key: " + conf.key + "; value: " + conf.value + "; path: " + conf.path + "<br />";  }


Comments

Post a Comment

Popular posts from this blog

c# - Update a combobox from a presenter (MVP) -

i using mvp in project, new in mvp. have 2 comboboxes. when select option in combobox, combobox should filled new data. this action in presenter. view 'view1' in presenter, , introduced combobox1 , combobox2 properties in 'view1', because need 'datasource', 'displaymember', 'valuemember' , 'refresh()' in method below. but, when using pattern, enough send property like public string combobox2 { { return combobox1.selectedvalue.tosstring(); } } into presenter not whole combobox. how can solve problem? public void onselectedindexchangedcombobox1() { if (view1.combobox1.selectedindex == -1) { return; } datatable dt = tools.getdatatable("a path"); var query = (from o in dt.asenumerable() o.field<string>("afield") == farmerview.combobox1.selectedvalue.tostring() orderby o.field<string>("anotherfield") select...
Read more

How to understand 2 main() functions after using uftrace to profile the C++ program? -

i trying uftrace profile following simple c++ program: #include <iostream> class { public: a() {std::cout << "a created" << std::endl;} ~a() {std::cout << "a destroyed" << std::endl;} }; int main() { a; return 0; } the profile result this: # uftrace a.out created destroyed # duration tid function 2.026 [ 4828] | __cxa_atexit(); [ 4828] | main() { [ 4828] | __static_initialization_and_destruction_0() { 89.397 [ 4828] | std::ios_base::init::init(); 0.768 [ 4828] | __cxa_atexit(); 93.029 [ 4828] | } /* __static_initialization_and_destruction_0 */ 94.425 [ 4828] | } /* main */ [ 4828] | main() { [ 4828] | a::a() { 11.104 [ 4828] | std::operator <<(); 10.825 [ 4828] | std::basic_ostream::operator <<(); 24.514 [ 4828] | } /* a::a */ [ 4828] | a::~a() { 0.978 [ 4828] | ...
Read more

How to put a lock and transaction on table using spring 4 or above using jdbcTemplate and annotations like @Transactional? -

i trying put lock on table while writing on table , if happened in between roll-back . trying convert below code lock table test_g1 read; lock table test_g write; -- begin; start transaction; insert test_g1 values(143); insert test_g values(145); select * test_g1; select * test_g; rollback; select * test_g; unlock tables; how convert above code @transactional spring jdbctemplate code? @transactional(rollbackfor={dataaccessexception.class}) public void test(){ jdbctemplate.execute("insert test1 (id, nam) values (4, 'a')"); throw new dataaccessexception("error") { }; } here trying throw error, insert statement should rollback it's not happening . thanks edit-1 attaching code , doing in jdbcdaoimpl.java , mentioned problem comment above test() . app.java package com.cgiri.javabrains.spring4; import org.springframework.beans.factory.annotation.autowired; import org.springframework.context.applic...
Read more