jpsshort

Thanks for the update.  I am a little confused.  If we have json_c installed why am I getting this error?

Hi

I have postgis enabled on my postgresql database: jpsshort_cms.    The version is 2.07.  I am getting an error when trying to create point data.  The message states that I need JSON-C for ST_GeomFromGeoJSON.

The postgis version 2.07 needs JSON-C enabled in order for GeoJSON to work.

On my computer using localhost  I am using postgis version 2.5.2 which works OK because JSON-C is automatically installed.

Is it possible to have the later version of postgis if it is not possible to enable JSON-C on the current version 2.07 of postgis?

Thanks

OK Thanks for the update.

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

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.

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.

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.

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

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.

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.

Many thanks

Hi

The database user is  jpsshort_admin.

Thanks for enabling posfgis.

I would like to access jpsshort_cms from QGIS on my desktop.  Is this possible?

Thanks again for your prompt assistance.

Hi

My database is called jpsshort_cms and username is jpsshort_admin.

Thanks for your assistance.

Hi

Thanks for the update.

Do I have to contact Krydos to install postgis?

If so how do I do that?

Perhaps this is a silly question but can I unblock port 2083 myself or is it being used by some software on my computer and that is why it is blocked.

Many thanks again for responding to my numerous requests.  

Hi

I have now set up a postgresql  database and tried to enable postgis with the CREATE extension postgis.

Unfortunately this did not work as anticipated. 

SQL error:

ERROR: syntax error at or near "create"
LINE 1: SELECT COUNT(*) AS total FROM (create extension postgis) AS ...
^

In statement:
SELECT COUNT(*) AS total FROM (create extension postgis) AS sub

Could you please let me know if it is possible to enable postgis.

Many thanks

Hi

Many thanks for sorting this problem.

https://tommy.heliohost.org.2083 does not work.  However, when I went to https://cpanel.tommy,heliohost.org/  I was able to log in.

Not sure why I cannot login in the other way.

Thanks again for your help.

Hi 

Thanks for you for your prompt advice.

I have just tried the insecure login option and it also comes up with this site cannot be reached. I am currently using a laptop with Windows 10 and I  using this from my home address.

I only recently signed up with a Tommy invite. 

Is it possible that I may not have set up my account properly?  The suggested login name was jpsshort on the first page of the sign up which I switched to jps47 on the second page.  I note however that this change did not happen to take effect.   However, is it a possible reason for the failure to connect.

Sorry to be of trouble.

Hi

I recently signed up to the Tommy server.

I can login and see the the Helihost Tools page.  However, when I try to access the Cpanel option  I get a Site cannot be reached message.

Any suggestions would help.