amazon web services - AWS RDS on Eclipse -

-

i know question seems repeat, it's not , have tried solutions find

problem:

i running aws rds instance database. works fine when connect using aws ec2 instance(uses linux) when try laptop, doesn't work. want work on eclipse( code on laptop , test on ec2 instance, annoying , very inconvenient). here error.

    com.mysql.jdbc.communicationsexception: communications link failure due underlying exception:   ** begin nested exception **   java.net.connectexception message: connection timed out: connect  stacktrace:  java.net.connectexception: connection timed out: connect     @ java.net.dualstackplainsocketimpl.connect0(native method)     @ java.net.dualstackplainsocketimpl.socketconnect(unknown source)     @ java.net.abstractplainsocketimpl.doconnect(unknown source)     @ java.net.abstractplainsocketimpl.connecttoaddress(unknown source)     @ java.net.abstractplainsocketimpl.connect(unknown source)     @ java.net.plainsocketimpl.connect(unknown source)     @ java.net.sockssocketimpl.connect(unknown source)     @ java.net.socket.connect(unknown source)     @ java.net.socket.connect(unknown source)     @ java.net.socket.<init>(unknown source)     @ java.net.socket.<init>(unknown source)     @ com.mysql.jdbc.standardsocketfactory.connect(standardsocketfactory.java:256)     @ com.mysql.jdbc.mysqlio.<init>(mysqlio.java:271)     @ com.mysql.jdbc.connection.createnewio(connection.java:2771)     @ com.mysql.jdbc.connection.<init>(connection.java:1555)     @ com.mysql.jdbc.nonregisteringdriver.connect(nonregisteringdriver.java:285)     @ java.sql.drivermanager.getconnection(unknown source)     @ java.sql.drivermanager.getconnection(unknown source)     @ execs.connect.main(connect.java:13)   ** end nested exception **    last packet sent server 1 ms ago. conn null.     @ com.mysql.jdbc.connection.createnewio(connection.java:2847)     @ com.mysql.jdbc.connection.<init>(connection.java:1555)     @ com.mysql.jdbc.nonregisteringdriver.connect(nonregisteringdriver.java:285)     @ java.sql.drivermanager.getconnection(unknown source)     @ java.sql.drivermanager.getconnection(unknown source)     @ execs.connect.main(connect.java:13)

what have tried:

  1. i have checked security group rds set accept inbound traffic port 3306 (0.0.0.0/0) , outbound traffic.
  2. i have enabled outbound , inbound traffic eclipse on windows(laptop) firewall.
  3. tried disabling firewall entirely.
  4. tried checking eclipse's network configuration.

nothing happens!

okay, per comments on question, i'm going give answer works around question. in other words, straightforward answer insecure thing (open database public).

here's tldr on answer: create tunnel ec2 instance, tell eclipse open side of tunnel.

here's longer version, given assumptions have ec2 instance with has access database (we'll call instance ec2instance.amazonaws.com), on windows, , know how ssh works. finally, we'll call database dns abc.def.rds.amazonaws.com.

prep

refer stackoverflow answer. ignore plink.exe part, unless works you.

in putty, create connection forwards localhost:3306 abc.def.rds.amazonaws.com:3306. in "putty configuration" graphic @ linked answer, source port 3306, destination "abc.def.rds.amazonaws.com:3306".

on main session screen in putty, set hostname yourusername@ec2instance.amazonaws.com. can hit save , save session ("db tunnel", instance).

open connection. should have blank terminal window. can leave alone, or can use generic command watch -n15 date keep connection open.

now, in eclipse, set connection string localhost:3306. use whatever username/password you've configured on rds mysql database.

the ssh tunnel break if lose network connection. you've saved putty configuration, can log in again.


Comments

Post a Comment

Popular posts from this blog

PHP DOM loadHTML() method unusual warning -

-
i had following code works fine on localhost: $document = new domdocument(); $document->loadhtml($p_result); $form = $document->getelementsbytagname('form')->item(0); // code continues using $form variable after same code updated on outside server, loadhtml() failed , issued warning. warning: domdocument::loadhtml() expects parameter 1 valid path, string given in path/name/to/script.php returned null instead of object code pretty gets fatal error. note contents of $p_result absolutely same on outside server , on localhost. but why displays kind of warning , why not work? doesn't loadhtml() expects argument 1 string in first place? why method expects parameter 1 valid path ? just make clear i'm not calling loadhtmlfile() , i'm calling loadhtml() . thanks. you're affected one of php bugs . issue present in php 5.6.8 , 5.6.9. have affected php version on server, , bug-free version on localhost. the bug forbids null
Read more

python - How to create jsonb index using GIN on SQLAlchemy? -

-
here's current code creating index jsonb. index("mytable_data_idx_id_key", mytable.data['id'].astext, postgresql_using='gin') but got error. sqlalchemy.exc.programmingerror: (psycopg2.programmingerror) data type text has no default operator class access method "gin" hint: must specify operator class index or define default operator class data type. [sql: "create index event_data_idx_id_key on event using gin ((data ->> 'id'))"] is there way create index on sqlalchemy? the postgresql specific sqlalchemy docs @ http://docs.sqlalchemy.org/en/latest/dialects/postgresql.html#operator-classes mention postgresql_ops dictionary provide "operator class" used postgresql, , provide example illustrating use: index('my_index', my_table.c.id, my_table.c.data, postgresql_ops={ 'data': 'text_pattern_ops',
Read more

c# - TransactionScope not rolling back although no complete() is called -

-
i'm using transactionscope rollback transaction fail bool errorreported = false; action<importerrorlog> newerrorcallback = e => { errorreported = true; errorcallback(e); }; using (var transaction = new transactionscope()) { foreach (importtaskdefinition task in taskdefinition) { loader.load(streamfile, newerrorcallback, task.destinationtable, processingtaskid); } if (!errorreported) transaction.complete(); } i'm sure there no transactionscope started ahead or after code. i'm using entity framework insert in db. regardless state of errorreported transaction never rolled in case of error. what missing ? transactionscope sets transaction.current . that's does. wants transacted must @ property. i believe ef each time connection opened reason. probably, connection open when scope installed. open connection inside of scope or enlist manually. ef has nasty "design decision": default opens
Read more