Jump to content


Photo

[Solved] remote access requested


  • Please log in to reply
10 replies to this topic

#1 nltrade

nltrade

    Rank I Member

  • Members
  • Pip
  • 17 posts
  • Gender:Male
  • Location:NL, Canada
  • Interests:Mathematics, hockey cards!

Posted 14 February 2021 - 03:28 PM

Hi folks, I have created a postgresql database:

 

 

nltrade_hockey1

 

 

with user:

 

nltrade_rh

 

I would like to request remote access to interact with the database.  

 

(feel free to delete if posted in incorrectly in duplicate!)

 

Best,

RH

 

 



#2 flazepe

flazepe

    Rank X Member

  • Moderators
  • 1,908 posts
  • Gender:Male

Posted 14 February 2021 - 03:37 PM

This support request is being escalated to our root admins.

#3 Krydos

Krydos

    Rank X Member

  • Root Admin
  • 21,950 posts
  • Gender:Male

Posted 14 February 2021 - 08:07 PM

Remote access enabled.



#4 nltrade

nltrade

    Rank I Member

  • Members
  • Pip
  • 17 posts
  • Gender:Male
  • Location:NL, Canada
  • Interests:Mathematics, hockey cards!

Posted 14 February 2021 - 09:49 PM

Remote access enabled.

 

Hi folks, I searched the wiki for remote access documentation but came up empty.  Any pointers? 



#5 Luigi123

Luigi123

    Rank X Member

  • Moderators
  • 2,802 posts
  • Gender:Male
  • Location:Winnipeg, Manitoba, Canada

Posted 14 February 2021 - 10:48 PM

Are you talking about if there is a documentation to enable remote access yourself without you having to request Krydos? If so, users don't have permission to do this on a shared host. It always has to be done manually by Krydos and he does this to other users a lot of times.

I don’t know about the VPS server but I think you could probably do that on your own because you will have a full root admin access and pretty much you can do anything.
Posted ImagePosted ImagePosted Image
Posted ImagePosted ImagePosted Image

#6 nltrade

nltrade

    Rank I Member

  • Members
  • Pip
  • 17 posts
  • Gender:Male
  • Location:NL, Canada
  • Interests:Mathematics, hockey cards!

Posted 15 February 2021 - 12:19 AM

Are you talking about if there is a documentation to enable remote access yourself without you having to request Krydos? If so, users don't have permission to do this on a shared host. It always has to be done manually by Krydos and he does this to other users a lot of times.

I don’t know about the VPS server but I think you could probably do that on your own because you will have a full root admin access and pretty much you can do anything.

 

Thanks for the reply.  No, not looking to enable remote access myself.  Is access through ssh?  If that is the case, just the address/port to use to ssh in would be great. 



#7 Luigi123

Luigi123

    Rank X Member

  • Moderators
  • 2,802 posts
  • Gender:Male
  • Location:Winnipeg, Manitoba, Canada

Posted 15 February 2021 - 01:18 AM

Unfortunately it’s not available on a shared host. You need a VPS if you want to access the SSH and to run it. Check it out: heliohost.org/vps
Posted ImagePosted ImagePosted Image
Posted ImagePosted ImagePosted Image

#8 nltrade

nltrade

    Rank I Member

  • Members
  • Pip
  • 17 posts
  • Gender:Male
  • Location:NL, Canada
  • Interests:Mathematics, hockey cards!

Posted 15 February 2021 - 01:48 AM

Unfortunately it’s not available on a shared host. You need a VPS if you want to access the SSH and to run it. Check it out: heliohost.org/vps

 

Thanks, I think I am missing something.     My goal is to port a postgresql database from my local server to tommy.    I understood that remote access would allow me to do this.  Is there no way to port this database without the "upgrade" to VPS?



#9 Luigi123

Luigi123

    Rank X Member

  • Moderators
  • 2,802 posts
  • Gender:Male
  • Location:Winnipeg, Manitoba, Canada

Posted 15 February 2021 - 02:02 AM

Remote access can be used to connect PostgreSQL DB using host and port:

Host=65.19.143.6 (or tommy.heliohost.org)
Port=5432 (the default postgresql port)

Again, for security reasons, Heliohost does not prove SSH logins for shared hosting accounts
Posted ImagePosted ImagePosted Image
Posted ImagePosted ImagePosted Image

#10 rmurthy

rmurthy

    Rank I Member

  • Members
  • Pip
  • 13 posts
  • Gender:Not Telling

Posted 15 February 2021 - 02:23 PM

Remote access in this case will be access to your PostgreSQL DB using the Host and port provided.

You can use pg_dump to dump an SQL file that you can import into after connecting to the PostgreSQL server remotely or through Cpanel.

Hope this helps and good luck!

#11 nltrade

nltrade

    Rank I Member

  • Members
  • Pip
  • 17 posts
  • Gender:Male
  • Location:NL, Canada
  • Interests:Mathematics, hockey cards!

Posted 15 February 2021 - 02:32 PM

A great help, many thanks. The documentation at: https://www.a2hostin...sql-connections proved useful.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users