Remote database using ssh

2022-07-19 Thread 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

Re: Remote database using ssh

2022-07-19 Thread 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

Re: Remote database using ssh

2022-07-19 Thread 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

Re: Remote database using ssh

2022-07-19 Thread 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 conn

Re: Remote database using ssh

2022-07-19 Thread 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 sh

Re: Remote database using ssh

2022-07-20 Thread 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: