** UnhandledExceptionEventHandler :: OFFICIAL LC / CHATTER THREAD ** - Page 1369 - Computer Technical Help

Two Plus Two Forums Other Topics Computer and Technical Help

** UnhandledExceptionEventHandler :: OFFICIAL LC / CHATTER THREAD **

Post Reply Subscribe

...

Page 1369 of 1603

First

369 869 1169 1269 1319 1349 1359 1364 1365 1366 1367 1368 1369 1370 1371 1372 1373 1374 1379 1389 1419 1469 1569

Last

Page 1369 of 1603

First

369 869 1169 1269 1319 1349 1359 1364 1365 1366 1367 1368 1369 1370 1371 1372 1373 1374 1379 1389 1419 1469 1569

Last

08-04-2018 , 12:30 PM

#34201

CBorders

Carpal \'Tunnel

Join Date: Feb 2008 Posts: 16,498

Quote:

Originally Posted by suzzer99

I set up the IAM CodeDeploy roles and groups like in the tutorial (which there are several). Seems happy. I was able to punch out to github from the deployment wizard thing and at least authorize AWS to make pulls.

How about the Security Groups for your EC2 instance(s)? If you're using the default SG you'll need to open up port 443. Also, double-check to make sure there are no IAM permissions or bucket policies preventing access to the S3 bucket you're using for the deployment.

Quote:

Does CodeDeploy from the console mean using the CLI tool, or something else? In either case I only went through the dashboard. It chugs for 5 minutes+ then comes back and says deploy failed due to HEALTH_CONSTRAINTS. In one video I watched there is an Events link on the failed deployment row itself. But mine doesn't have that.

It's the dashboard, they call it the AWS Console for some reason.

Quote:

I got the zipped up logs on my instance through another dashboard. But it's just var/logs - I don't have a var/aws. Does the deployment all happen on the original instance? It sounded like they spin up special target instances just for deployment. But I could be reading that wrong.

Sorry, I meant /var/log/aws/codedeploy-agent. There should be a CodeDeploy agent on the EC2 instance(s) you spun up. CodeDeploy pushes the app specification file to GitHub/S3 and the agent pulls from them:

Can you run a sudo yum info codedeploy-agent (Red Hat/Amazon Linux) or sudo dpkg -s codedeploy-agent (Ubuntu) on your instance to make sure the agent was installed?

Quote:

I looked into SSHing to my server instance - but the list of prerequisites was like 12 things, most of which I didn't understand or had questions on. Then the actual SSHing was a bunch more things I wasn't clear on. I know how to SSH, but in general my linux-fu is weak. I plan to dig into that part when I get some time.

Did you create a keypair and save the private key to your development machine? When you launched the EC2 instance, did you specify that keypair be used? In the dashboard if you go to EC2 -> Instances you should be able to highlight the instance, click the Connect button, and see the SSH command needed to access the machine, usually ssh -i /path/to/private_key.pem ubuntu@ ec2-ip-address.us-west-2.compute.amazonaws.com or something of that nature. That should be all you need to get into the instance.

Quote

$25m Guaranteed WPM on CoinPoker

Join the action now

Daily Rewards • Splash Pots • CoinRaces

08-04-2018 , 06:02 PM

#34202

Craggoo

banned

Join Date: Sep 2006 Posts: 12,645

Quote:

Originally Posted by suzzer99

So you're basically saying that you're the one ****ing up glassdoor and you know how he can make the problem go away?

Reminds me of my first exposure to my new team at hyper-mega-corp (after they bought out mega-corp and I moved over to the dark side). Their internal employee satisfaction surveys had come back negative. So we had at least 10 punitive meetings with onerous tasks and homework assignments to "brainstorm" how to bring them back up again.

These were mostly bosses of employees who had given low satisfaction scores. But the message was clear - you better all give good reviews, and also punish your employees like this as well - so they know to give better reviews next year or expect the same.

Basically the beatings will continue until morale improves.

Think you read it wrong. I haven't posted a review on glassdoor for my company. My immediate boss mentioned the fact in our team meeting that the glassdoor reviews for our companies suck and, in a roundabout way, was asking how to make it stop.

Quote

08-04-2018 , 06:04 PM

#34203

Craggoo

banned

Join Date: Sep 2006 Posts: 12,645

Quote:

Originally Posted by RustyBrooks

Woah, did I miss how you ended up in this spot (at 1/3 below the pay level for your position?) That's pretty substantial.

The last time I brought up pay in our one on one, he quickly changed the subject so read into that what you will.

Quote

08-04-2018 , 07:47 PM

#34204

Larry Legend

Celtic Pride

Join Date: Jul 2009 Posts: 42,243

That's weak sauce on his part.

Quote

08-04-2018 , 07:54 PM

#34205

suzzer99

Save the Cheerleader, Save the World

Join Date: Nov 2005 Posts: 101,163

Does anyone know a super simple way to just create an instance and connect to a hosted SQL server somewhere? I'm trying to use google cloud but the docs are super confusing and I can't figure out they're referencing a local node instance (which I want) or a hosted node instance.

What is an app engine and why do I need it? I just want a hosted DB to connect to. I followed the instructions and I get -bash: gcloud: command not found on my local. Stuck on 3rd step.

I'm trying to do this for a programing take home assignment and basically spending all my time trying to get something hosted to work - which isn't even part of the assignment. I gave up on AWS for now.

Quote

08-04-2018 , 08:08 PM

#34206

blacklab

old hand

Join Date: Jan 2005 Posts: 1,296

suzzer, I have some servers running with mysql on them that I could let you use.
pm me the ip address of your server and I'll open it up to you.

Quote

08-04-2018 , 08:13 PM

#34207

jjshabado

Carpal Tunnel

Join Date: Jul 2006 Posts: 22,732

I’ve always found rds pretty easy to use. I’m sure there are a bunch of getting started tutorials you could follow.

Edit: https://aws.amazon.com/getting-start...rosoft-sql-db/

Quote

08-04-2018 , 08:29 PM

#34208

blackize5

old hand

Join Date: Sep 2012 Posts: 1,358

Why not just use heroku and be done with it?

Quote

08-04-2018 , 09:12 PM

#34209

suzzer99

Save the Cheerleader, Save the World

Join Date: Nov 2005 Posts: 101,163

I need to make a node app that connects to a SQL DB as a take home assignment for a job. I thought I'd just connect up a hosted DB somewhere.

I've connected to plenty of remote SQL DBs before. I just need to find the right options for this block of code in node:

Code:

const mysql = require('mysql');
const connection = mysql.createConnection({
  host: '35.230.53.47/seraphic-lock-189423:us-west1:bear-sightings',
  user: 'bearsightings',
  // password: 'password',
  database: 'bearsightings'
});
connection.connect((err) => {
  if (err) throw err;
  console.log('Connected!');
});

Host is my google cloud instance. Not working yet obviously.

Quote

08-04-2018 , 09:13 PM

#34210

suzzer99

Save the Cheerleader, Save the World

Join Date: Nov 2005 Posts: 101,163

Quote:

Originally Posted by blacklab

suzzer, I have some servers running with mysql on them that I could let you use.
pm me the ip address of your server and I'll open it up to you.

The app is going to be run from various local dev boxes probably.

Quote

08-04-2018 , 09:26 PM

#34211

suzzer99

Save the Cheerleader, Save the World

Join Date: Nov 2005 Posts: 101,163

I guess hosted DBs just aren't set up to allow access from any IP - even with username and password?

Quote

08-04-2018 , 09:31 PM

#34212

OmgGlutten!

Pooh-Bah

Join Date: Aug 2016 Posts: 5,273

i'm surprised that people thought Suzzer's JS this question was dumb or trivia. i thought it was decent.

Quote

08-04-2018 , 09:34 PM

#34213

iversonian

Carpal \'Tunnel

Join Date: Sep 2003 Posts: 21,447

Why don’t you just use a SQLite dB?

Quote

08-04-2018 , 09:43 PM

#34214

jjshabado

Carpal Tunnel

Join Date: Jul 2006 Posts: 22,732

Quote:

Originally Posted by suzzer99

I guess hosted DBs just aren't set up to allow access from any IP - even with username and password?

They are. You need to make sure the security group (or equivalent in gcp) allows ingress from whatever ip or instance you’re trying to connect from.

Quote

08-04-2018 , 10:04 PM

#34215

maxtower

Carpal \'Tunnel

Join Date: Sep 2005 Posts: 7,996

Do a one-click app install on a DigitalOcean droplet. It will cost you $5-10 and you can use LEMP or LAMP to get MySQL in one-click. They also have one for MySQL alone.

https://www.digitalocean.com/products/one-click-apps/

Quote

08-05-2018 , 01:30 AM

#34216

Craggoo

banned

Join Date: Sep 2006 Posts: 12,645

Quote:

Originally Posted by OmgGlutten!

i'm surprised that people thought Suzzer's JS this question was dumb or trivia. i thought it was decent.

A question that has different answers in different environments is, by definition, a bad question imo.

Quote

08-05-2018 , 01:36 PM

#34217

Victor

Carpal \'Tunnel

Join Date: Jul 2003 Posts: 81,657

Quote:

Originally Posted by OmgGlutten!

i'm surprised that people thought Suzzer's JS this question was dumb or trivia. i thought it was decent.

why? I mean, how is understanding that helpful for a job?

Quote

08-05-2018 , 01:52 PM

#34218

suzzer99

Save the Cheerleader, Save the World

Join Date: Nov 2005 Posts: 101,163

Quote:

Originally Posted by jjshabado

They are. You need to make sure the security group (or equivalent in gcp) allows ingress from whatever ip or instance you’re trying to connect from.

Right. But when I turn this over they'll be running it on their local dev machines, and I don't know the IP. I can always have them tell me and then open it up, but that seems sub-optimal.

As far as the other questions - the app needs to be on node, but I can use any SQL db.

I thought I could maybe use a hosted DB so they wouldn't have to install one locally to run the project. But it seems like maybe hosted DBs aren't designed to just open up to any app with credentials.

Quote

08-05-2018 , 01:52 PM

#34219

PJo336

THRILLHOUSE!

Join Date: Mar 2007 Posts: 22,158

Quote:

Originally Posted by Victor

why? I mean, how is understanding that helpful for a job?

The arguments part was really, really dumb, but knowing the scoping of this seems like a foundational thing to know

Quote

08-05-2018 , 01:53 PM

#34220

PJo336

THRILLHOUSE!

Join Date: Mar 2007 Posts: 22,158

Quote:

Originally Posted by suzzer99

If they're running it locally, it shouldn't be connecting to a remote DB. Make your app a docker container and provide a docker-compose.yml. That's a perfect application of docker right there, and how we generally do dev projects. They just build and run

Quote

08-05-2018 , 02:01 PM

#34221

suzzer99

Save the Cheerleader, Save the World

Join Date: Nov 2005 Posts: 101,163

Geez - this is now the second time I've installed the client tools - google cloud and now mysql shell - and I just get -bash: mysql: command not found. Why is this stuff so hard? I tried sudo and as me.

Quote

08-05-2018 , 02:03 PM

#34222

suzzer99

Save the Cheerleader, Save the World

Join Date: Nov 2005 Posts: 101,163

Quote:

Originally Posted by PJo336

Yeah that's a great idea. Unfortunately I will probably spend all day getting docker to work locally and I have to turn it in tonight. But I'll give it a try. Eagerly awaiting -bash: docker: command not found.

Actually reading the instructions they want it as a zipped node app without the node_modules directory. But they don't really say how the DB stuff is supposed to work. Weird.

Quote

08-05-2018 , 02:23 PM

#34223

suzzer99

Save the Cheerleader, Save the World

Join Date: Nov 2005 Posts: 101,163

Moving on to SQL Lite. Wish me luck.

Hmmm not even clear if it can be run on Mac, client tools yes - but the DB? https://www.sqlite.org/download.html

GAHHHHHHH - it's already pre-installed on my Mac?

Ok following a tutorial on creating a table. I seem to be in some unexitable prompt?

Code:

sqlite> create table sightings (species str, subspecies str, num_sighted int, zip_code str notes str)
   ...> remove table sightings
   ...> .databases
   ...> .schema
   ...> exit
exit
   ...> .q
   ...> quit
   ...> .exit
   ...> 
   ...> sqlite
   ...> .exit
   ...>

This is always the absolute hardest part on this stuff. When you're too stupid about it to even know what to google or what's going on.

Yay google - https://stackoverflow.com/questions/...lite3-database

Last edited by suzzer99; 08-05-2018 at 02:50 PM.

Quote

08-05-2018 , 03:06 PM

#34224

Grue

Pooh-Bah

Join Date: Mar 2004 Posts: 5,667

Yesterday I set up an mlab free sandbox and it says oh do `mongo blahblahblah -u (username) -p (password)` to connect to this database and nowhere did I give it a password or was provided a default password so I gave up.