|
Ahah don't worry. I'm more than happy to help wherever I can 
Answering your question, yes you do need to open the putty connection before running your app otherwise it will not be able to connect to the database. You only need to do this once (when you turn on your PC for example) and then leave it open.
|
|
|
|
|
Hi there, I'm unsure about what I need to port forward in my router and Putty, I see in your screenshot you have 127.0.0.1:5432 ; does that mean I need to port forward 5432 in my router to my database server ? and also put my public ip address in the host text box in Putty ? sorry for all the questions but I've not worked with tunneling before 
Edit
I think I've done it though maybe not the way you suggested - this is what I've done
Forwarded port 22 in my router to my local Linux box
Forwarded a port xxx in my Putty connection to my local Linux box
Changed the port number in my connection string to xxx
It worked !!! I'm amazed - thanks for all your help
"We can't stop here - this is bat country" - Hunter S Thompson - RIP
modified 1-Feb-20 9:41am.
|
|
|
|
|
Hi, sorry for taking so long to reply (looong weekend..).
If I understand correctly then yes, that setup should work both locally on your network as well as remotely 
I should probably make a guide on how to set this up because with all the forwarding going on it gets really confusing really fast.
Anyway let me know if you have any more trouble And if you want to make everything a little bit more secure, checkout how to connect using a key pair instead of a username/password
modified 3-Feb-20 4:43am.
|
|
|
|
|
Hi and thanks again, I already use keys - I’ve been using SSH for years it just never occurred to me to use port forwarding in Putty - I run SSH and PostgreSQL on non standard ports which is an added complication- what I used to do was forward the Postgres port in my router which is not ideal - with your method I have the added benefit of SSH security - and as you say it works remotely
"We can't stop here - this is bat country" - Hunter S Thompson - RIP
|
|
|
|
|
Ah! Sorry for some reason I thought you didn't know about ssh keys 
Anyway I'm glad it works It's amazing what PuTTY and SSH can do for such "simple" programs.
On a side note, be carefull about not running ssh on a standard port. You are giving up some linux protections when doing that.
|
|
|
|
|
Oh really what exactly ?
"We can't stop here - this is bat country" - Hunter S Thompson - RIP
|
|
|
|
|
This is only true if you use a port above 1024.
Ports bellow 1024 are given some extra "protections" by Linux, one of them being that your program must be executed as root to be able to bind to them. This means that if you use a port >1024 and get infected by something, that something can bind to that port, act like a ssh server and capture everything you are doing.
As usual there are tons of discussions and opinions about this if you want to take a look:
- Why not move SSH to another port? - BSD How To[^]
- Why putting SSH on another port than 22 is bad idea[^]
- Why putting SSH on another port than 22 is bad idea | Hacker News[^]
This is probably overkill for what you and I do but I like to keep it safe (and I had to worry about this kind of stuff on a previous job although I'm not a security expert, not even close, so keep that in mind).
One way to keep both benefits is to keep ssh on port 22 on your linux box but port-forward a random >1024 port on your router to port 22.
Is this worth it? I'm not sure but at least it's one less thing to worry about.
|
|
|
|
|
If it's only for you, consider SSH. You can use putty on a Windows machine to do port redirection if you need to. On linux its not much harder. Depends a little on how permanent it needs to be.
|
|
|
|
|
I Camembert it when people ignore cheese – it's unbrieleivable!
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
This TOTD is Edam Gouda one!
I, for one, like Roman Numerals.
|
|
|
|
|
When I see 'em I Edam. Havarti and be kind to cheese - it curd be for someone you know.
| Ravings en masse^ |
|---|
| "The difference between genius and stupidity is that genius has its limits." - Albert Einstein | | "If you are searching for perfection in others, then you seek disappointment. If you seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
This bleu me away. I rennet by my spouse, and he is cheesed at the pun.
Real programmers use butterflies
|
|
|
|
|
Just when I thought your TotD posts couldn't get cheesier...
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
I wish I understood him
Real programmers use butterflies
|
|
|
|
|
And he wishes you understood him too!
|
|
|
|
|
Then how do you know?
#SupportHeForShe
Government can give you nothing but what it takes from somebody else. A government big enough to give you everything you want is big enough to take everything you've got, including your freedom.-Ezra Taft Benson
You must accept 1 of 2 basic premises: Either we are alone in the universe or we are not alone. Either way, the implications are staggering!-Wernher von Braun
|
|
|
|
|
He chirps and squeaks them at me incessantly.
Real programmers use butterflies
|
|
|
|
|
honey the codewitch wrote: He chirps and squeaks
Blimey, what is he: bird, mouse ... ?
|
|
|
|
|
We have a bird in the tree outside my window that mimics the cat's meow. He's pretty good - he fools me pretty often that "Dij Wants In".
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
He's a chantily. They chirp and squeak
Real programmers use butterflies
|
|
|
|
|
Um, you do know that cats only make noises to humans because they're predators, don't you? They interact with each other in complete silence
Have you never seen your cat stretching itself up a wall and making funny, squeaky, screechy noises at a moth, fluttering away above it?
Those funny noises are the human-hearable residue of the cat imitating the sounds that the moth is making (which the cat can hear, but we can't).
So cats only "talk" and make cute noises at you because you're their victim.
I speak as someone who hasn't lived without a cat for the better part of forty years, despite the sh1t-f***-buggery mess cat fur makes of your vocal chords (so don't ask me to sing unless I've been away from home for at least three days, because I won't be able to hit a note).
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
So kittens in a litter that haven't seen a human are completely silent?
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
Eddy Vluggen wrote: So kittens in a litter that haven't seen a human are completely silent?
This something that's really cool to analyse. It's too complicated and messy (and phenomenally/inspiringly educational) to go into it in the CP Lounge, but if you're interested in how animals' (including humans') brains work, it's a fascinating field of research.
I know this because I researched it thirty years ago 
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
Mark_Wallace wrote: I know this because I researched it thirty years ago
And cats only meow because of "humans"? So before humans, cats were completely silent?
Lions do not roar either, except for humans?
It's a nice myth, which does explain something interesting about the arrogance of our species and brain.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
With cats, it's a major predator thing, the same as when people use duck-quacky-things to make ducks stick their heads up to be shot off -- cats have more cranial processing space than ducks.
You might notice that every cat makes a different noise to get food, get rubbed, or get dried off after they've been out in the rain. It's all because their predatory instincts have pointed in the directions for doing so, that works in their current situation.
As for kitten noises, I confess I haven't looked into that, so I don't know, and therefore won't comment on it. Gimme a couple of months, when I find the time.
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
