Jump to content


Photo

[Solved] Cannot access Cpanel (Postgres)


  • Please log in to reply
27 replies to this topic

#16 Krydos

Krydos

    Rank X Member

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

Posted 26 February 2021 - 04:19 AM

Remote access enabled.



#17 jpsshort

jpsshort

    Rank I Member

  • Members
  • Pip
  • 17 posts

Posted 26 February 2021 - 03:38 PM

Many thanks



#18 jpsshort

jpsshort

    Rank I Member

  • Members
  • Pip
  • 17 posts

Posted 26 February 2021 - 03:58 PM

Hi

 

I can now remotely access my database jpsshort_cms with user jpsshort_admin.  However, I don't seem to have the ability to add any data to the database.  i was hoping to be able to create users who would have access to creating geometry tables.

 

Your assistance would be appreciated.



#19 jpsshort

jpsshort

    Rank I Member

  • Members
  • Pip
  • 17 posts

Posted 27 February 2021 - 02:51 PM

Hi

 

I can now remotely access my database jpsshort_cms with user jpsshort_admin.  However, I don't seem to have the ability to add any data to the database.  i was hoping to be able to create users who would have access to creating geometry tables.

 

When I access this database it states that I have no privileges over any of the tables in the database.

 

Your assistance would be appreciated.



#20 wolstech

wolstech

    Rank X Member

  • Root Admin
  • 13,412 posts
  • Gender:Male
  • Location:Pennsylvania

Posted 27 February 2021 - 03:06 PM

Krydos is the only one who can fix this and he hasn't been online since Thursday. You'll need to wait until he sees this to have it fixed.

Please do not PM me for support. Posting on our forums lets all of us learn.
Do you play Minecraft? | Server Monitors | And the Dumbass of the Decade award goes to...


#21 jpsshort

jpsshort

    Rank I Member

  • Members
  • Pip
  • 17 posts

Posted 27 February 2021 - 04:28 PM

Thanks for the update.  I thought it might have been a stupid error on my part.



#22 Krydos

Krydos

    Rank X Member

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

Posted 28 February 2021 - 05:41 AM

Have you added the user to the database?



#23 jpsshort

jpsshort

    Rank I Member

  • Members
  • Pip
  • 17 posts

Posted 28 February 2021 - 10:25 AM

The only user  jpsshort_admin.  I have granted all privileges to this user but find that within QGIS the database shows this user to have no privileges to add points lines or polygons etc.

 

Your assistance would be appreciated.



#24 jpsshort

jpsshort

    Rank I Member

  • Members
  • Pip
  • 17 posts

Posted 28 February 2021 - 12:16 PM

Looking at the database it is under the public schema which is owned by postgres.  Does postgres need to give me permissions or is there another way to resolve the fact I do not seem to be able to control the database.  I tried to create an additional schema but that just caused the database to fail.  Your help would be appreciated as until I can access the database I cannot do any tests.



#25 jpsshort

jpsshort

    Rank I Member

  • Members
  • Pip
  • 17 posts

Posted 28 February 2021 - 12:28 PM

I have created a second test database and note that it is created with the public schema which is controlled by postgres. 

 

I assume that postgres must therefore give any users within that database privileges such as create delete etc.  If this is the case could the jpsshort_cms database with user jpsshort_admin be granted all privileges needed to operate the database please.



#26 jpsshort

jpsshort

    Rank I Member

  • Members
  • Pip
  • 17 posts

Posted 01 March 2021 - 10:49 AM

I have had another look at QGIS and it shows the owner of the database as postgres and therefore I have no privileges to access the database.  I would appreciate postgres granting me privileges so I can add point, line and polygon layers to the database jpsshort_cms with user jpsshort_admin.

 

Thanks



#27 Krydos

Krydos

    Rank X Member

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

Posted 02 March 2021 - 05:24 AM

Have you added the user to the database?

If you had added the user to the database it should show it under the privileged users column.
6262940538de399123287f6836a054ca.png
Maybe try adding it again?

#28 jpsshort

jpsshort

    Rank I Member

  • Members
  • Pip
  • 17 posts

Posted 02 March 2021 - 12:14 PM

OK Thanks for the update.






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users