[postgis-users] PostGIS/PostGres Configuration

[Steffan Chmuryk]

Thanks,

So now, I have set up the connection, and have tried to connect via all three applications. Here are the errors:

* Udig will connect, and seems to load the data, but then gives this message: RenderingException(s) occurred during rendering: Must call hasNext before calling next
	*Seems to be a java error.
* OpenJump connects to the db, but gives this message: Error: syntax error at or near "ST_GeomFromText" (PSQL Exception)
	*Seems to require a plugin.
* QGIS seems to work fine.

More to come...

Steffan Chmuryk
Technical Services Coordinator, ICIS
www.icisociety.ca
 
Office: (250) 381-9295
Cell:     (250) 516-2481
-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Paul Ramsey
Sent: Monday, March 15, 2010 12:15 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] PostGIS/PostGres Configuration

Steffan,
Leave your localhost entry in place, it's useful. Make a copy of the
line and edit the copy.
Change localhost to 192.168.0.0 and change 32 to 16.
Ensure that listen_addresses = '*' in your postgresql.conf file.
Restart the database
Try again.
P

On Mon, Mar 15, 2010 at 11:50 AM, Steffan Chmuryk
<schmuryk at icisociety.ca> wrote:
> Hello,
>
> This is my first post, so please go easy ;)
>
> I have built a PostGIS/PostGres spatial database, and have successfully
> imported a shapefile. Now when I try to connect to the database via
> Udig, OpenJump, or Qgis, I the following error:
>
> Fatal: no pg_hba.conf entry for host "192.168.x.xxx", user "postgres",
> database "postgis1', SSL off (PSQL Exception)
>
> Now I have tried every combination of the following:
>
> * Edit pg_hba.conf so that the default 127.0.0.1/32 is replaced by the
> 192... ip
> * Add another access configuration to the file, so that the 192... ip,
> the postgres user, and the database are all included
> * Enable the SSL off configuration in the postgres.conf file, and
> restart the machine
> * I have even explored the JDBC stuff... argh!
>
> The error message in the application (Udig, OpenJump, or Qgis) does not
> change. But upon changing the files to reflect any of the above
> configurations, I am then unable to connect to the db within pgadminIII,
> due to an error in loading the pg_hba.conf file.
>
>
> Regarding the environment:
> * Server used to host MSSQL and SDE;
> * Server is Windows Server 2003 (not R2);
>
>
> Steffan Chmuryk
> Technical Services Coordinator, ICIS
> www.icisociety.ca
>
> Office:   (250) 381-9295
> Cell:     (250) 516-2481
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

No virus found in this incoming message.
Checked by AVG - www.avg.com 
Version: 9.0.733 / Virus Database: 271.1.1/2748 - Release Date: 03/15/10 00:33:00