node.js - Sails-mysql refuses to register a connection -


i have sails application on aws instance dependancies installed no apparent issues. however, each time try launch app getting following error.

error: adaptererror: connection registered

i have not managed lift sails yet on instance , sails-mysql freshly installed no connections should registered.

i have taken following steps deploy app..

  • set mysql rds instance (eu-west)
  • created , set ubuntu amd-64 t2.micro ec2 instance (eu-west)
  • installed prerequisites (git, nvm, nodejs, sails, etc.)
  • cloned sails project
  • installed dependencies sails
  • correctly configured connection settings sails use rds instance.

i know connection settings correct have been able run sails on local machine connection rds instance , consistently lift without issues.

i able connect rds instance using sequelpro no problems.

i have had issues dependencies in past have managed fix issues , have not had of them on local machine or ec2 instance.

after searching while have come across few users have had similar issues have managed fix them waterline's teardown methods, however, unsure how achieve this.

i have done best provide information possible , massively appreciated.

sails version: 0.12.11

thank in advance.

i managed fix issue carrying out following:

  • switched environment production in config/bootstrap.js

  • in connections.js add connecttimeout: 20000 make sure request not time out before connection made.

    eg. process.env.node_env = 'development'

  • ensure security group inbounds rules rds allows connections security group associated ec2 instance.

type: mysql/aurora

protocol: tcp

port range: 3306

source: < security group id >

following above points meant overcame issue handshake timeouts when communicating rds.


Comments

Post a Comment

Popular posts from this blog

python - Operations inside variables -

this question has answer here: evaluating mathematical expression in string 12 answers i want make python script finds maximum possible output using 2 operations. problem says there syntax error @ 2nd last line, in b in there. how can fix it? x = 0 = int(input("1st number:")) c = int(input("2nd number:" )) e = int(input("3rd number:" )) in range(4): if == 0: b = "+" elif == 1: b = "-" elif == 2: b = "/" else: b = "*" j in range(4): if j == 0: d = "+" elif j == 1: d = "-" elif j == 2: d = "/" else: d = "*" k = b c d e print(k) if you're after variables e on single line, couldn...
Read more

Generic Map Parameter java -

i having lot of methods of type: public static list<eduusers> getdetails(class c, map<string, integer> params) { list<eduusers> details = null; session session = hibernateutil.getsessionfactory().opensession(); transaction tx = null; try { tx = session.begintransaction(); criteria cr = session.createcriteria(c); (map.entry<string, integer> entry : params.entryset()) { cr.add(restrictions.eq(entry.getkey(), entry.getvalue())); } details = cr.list(); tx.commit(); } catch (exception asd) { log.debug(asd.getmessage()); if (tx != null) { tx.commit(); } } { session.close(); } return details; } i trying have generic method them , have written far: public static <t> list<t> getdetails(class<t> c, class<t> b) { l...
Read more

arrays - What causes a java.lang.ArrayIndexOutOfBoundsException and how do I prevent it? -

what arrayindexoutofboundsexception mean , how rid of it? here code sample triggers exception: string[] name = {"tom", "dick", "harry"}; for(int = 0; i<=name.length; i++) { system.out.print(name[i] +'\n'); } your first port of call should documentation explains reasonably clearly: thrown indicate array has been accessed illegal index. index either negative or greater or equal size of array. so example: int[] array = new int[5]; int boom = array[10]; // throws exception as how avoid it... um, don't that. careful array indexes. one problem people run thinking arrays 1-indexed, e.g. int[] array = new int[5]; // ... populate array here ... (int index = 1; index <= array.length; index++) { system.out.println(array[index]); } that miss out first element (index 0) , throw exception when index 5. valid indexes here 0-4 inclusive. correct, idiomatic for statement here be: for (int index = 0; index <...
Read more