Re: Remote database using ssh

[Wennie Catabay]

No, it is not the same network,  the remote database is MySql, and my 
default database in my Django application is Postgres, I only want is to  
read or get data to the remote database into may Django application. 

On Wednesday, July 20, 2022 at 11:15:05 AM UTC+8 aqoy...@cardaccess.com.au 
wrote:

> We don't know if your DB is in the same network or not as your Django App 
> server but the answer is to open the database port on the database server. 
> If you're using postgresql on the Database, then install a psql client on 
> the app server and test connect from there. If it works, then your Django 
> should also work too.
>
> On Tue, Jul 19, 2022 at 11:32 PM Wennie Catabay  
> wrote:
>
>> Hello,
>>
>> I am stuck on defining how to connect a remote database from another 
>> server using ssh. I am able to connect the remote database with putty using 
>> ssh, but but I don't know how to apply it in django.
>>
>> Thank you.
>>
>> -- 
>>
> You received this message because you are subscribed to the Google Groups 
>> "Django users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to django-users...@googlegroups.com.
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/django-users/d0c2f56f-c739-4508-8529-4c5107f08636n%40googlegroups.com
>>  
>> 
>> .
>>
>
>
> -- 
> Abdul Qoyyuum Bin Haji Abdul Kadir
> HP No: +673 720 8043 <+673%20720%208043>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/a57444a9-b4f4-4273-a8e1-a11fccc539d7n%40googlegroups.com.

Re: Remote database using ssh

[Abdul Qoyyuum]

We don't know if your DB is in the same network or not as your Django App
server but the answer is to open the database port on the database server.
If you're using postgresql on the Database, then install a psql client on
the app server and test connect from there. If it works, then your Django
should also work too.

On Tue, Jul 19, 2022 at 11:32 PM Wennie Catabay 
wrote:

> Hello,
>
> I am stuck on defining how to connect a remote database from another
> server using ssh. I am able to connect the remote database with putty using
> ssh, but but I don't know how to apply it in django.
>
> Thank you.
>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to django-users+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/d0c2f56f-c739-4508-8529-4c5107f08636n%40googlegroups.com
> 
> .
>


-- 
Abdul Qoyyuum Bin Haji Abdul Kadir
HP No: +673 720 8043

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/CAA3DN%3DWPXTKCnK9yS56Rd5zR%3Dqh2FPQbz%3D%3Dr85ayQofnLnjLqA%40mail.gmail.com.

Re: Remote database using ssh

[Sebastian Jung]

Hey,

This is easy and have nothing to do with django. Yoz must make port
forwarding over ssh from postgres port.

https://superuser.com/questions/1213886/how-to-open-port-via-ssh-tunnel

Regards

Wennie Catabay  schrieb am Di., 19. Juli 2022,
17:32:

> Hello,
>
> I am stuck on defining how to connect a remote database from another
> server using ssh. I am able to connect the remote database with putty using
> ssh, but but I don't know how to apply it in django.
>
> Thank you.
>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to django-users+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/d0c2f56f-c739-4508-8529-4c5107f08636n%40googlegroups.com
> 
> .
>

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/CAKGT9my5bZyH_FV%2BpvoHOwHpWrwgB%2BTU%3DNjXm3%2Bnum4tvt_N8Q%40mail.gmail.com.

Re: Remote database using ssh

[Mr.Teapot]

Probably your database is not listening for remote connections for security 
reasons. Do the database and your application server are in the same 
network? Or maybe you are able to set up a VPN for both of these machines. 
Last but not recommended solution you can open a public port and allow only 
specyfic IP to connect and change the database settings to listen not only 
for local connections.
wtorek, 19 lipca 2022 o 17:50:52 UTC+2 bboy...@gmail.com napisał(a):

> Public db port but not recommend for security reason and performance.
>
> On Tue, 19 Jul 2022 at 22:32 Wennie Catabay  wrote:
>
>> Hello,
>>
>> I am stuck on defining how to connect a remote database from another 
>> server using ssh. I am able to connect the remote database with putty using 
>> ssh, but but I don't know how to apply it in django.
>>
>> Thank you.
>>
>> -- 
>> You received this message because you are subscribed to the Google Groups 
>> "Django users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to django-users...@googlegroups.com.
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/django-users/d0c2f56f-c739-4508-8529-4c5107f08636n%40googlegroups.com
>>  
>> 
>> .
>>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/f38a890e-db5d-45a8-a616-16443e9130e5n%40googlegroups.com.

Re: Remote database using ssh

[Anh Nguyen]

Public db port but not recommend for security reason and performance.

On Tue, 19 Jul 2022 at 22:32 Wennie Catabay  wrote:

> Hello,
>
> I am stuck on defining how to connect a remote database from another
> server using ssh. I am able to connect the remote database with putty using
> ssh, but but I don't know how to apply it in django.
>
> Thank you.
>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to django-users+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/d0c2f56f-c739-4508-8529-4c5107f08636n%40googlegroups.com
> 
> .
>

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/CAKaoNbQX6vd0jxVXycJzfOFQCo7t%3Dt887TWs1yduJR7acYykOg%40mail.gmail.com.

Remote database using ssh

[Wennie Catabay]

Hello,

I am stuck on defining how to connect a remote database from another server 
using ssh. I am able to connect the remote database with putty using ssh, 
but but I don't know how to apply it in django.

Thank you.

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/d0c2f56f-c739-4508-8529-4c5107f08636n%40googlegroups.com.