[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
Re: [udig-devel] not able to connect to PostGIS
|
Probably the "list-o-databases" attempt should fail silently if it
cannot connect, instead of failing noisily.
P
On 27-Aug-05, at 11:51 AM, Paul Ramsey wrote:
The strange bit of behavior is a result of how the wizard/driver
tries to populate the "list-o-databases" drop down. Behind the
scenes, it attempts to connect to the "template1" database and
query the system tables for a list of databases. But in a
privilege-constrained world (like our open database, or really any
managed system) access to template1 is not blanket allowed to all
user accounts. So the attempt to populate the drop down fails with
an access denied. But that doesn't mean that you can't still
connect to databases you know about and have privileges for (like
demo-bc).
WRT the driver, the line protocol did not change between 7.4 and
8.0 so the old driver works on the new database. Regardless, it
would be good for uDig to ship with the new driver, since backwards
compatibility is guaranteed more than forward over the long run.
Paul
On 27-Aug-05, at 11:10 AM, William Kyngesburye wrote:
Ah. I coulda swore I used a hyphen - I remember noticing that and
backing up to correct it. Oh well, it works.
I also noticed that 'strange behaviour'. That's probably what
made me think it wasn't working the first time (in the RC
versions) - it failed after the password, so I didn't try entering
a DB name.
I then tried the original postgres 7.4 jar, and demo-bc still
works. I wonder what I'm doing with my postgis setup that it
doesn't work with the older driver?
Well, here's the postgres driver download link:
<http://jdbc.postgresql.org/download.html>
On Aug 27, 2005, at 10:36 AM, Jesse Eichar wrote:
Thanks Paul, you are right.
I've just noticed a strange bit of behaviour. You get an error
after
you enter the password(because not all dbs are public) but when
you put
demo-bc in the database part all goes well.
Jesse
On Sat, 2005-08-27 at 07:37 -0700, Paul Ramsey wrote:
Jesse said "demo-bc" and you said "demo_bc"... are you using the
right database name?
On Aug 26, 2005, at 9:43 PM, William Kyngesburye wrote:
The postgres library is supposed to be backwards compatible, I
believe. Somewhere in the readme or documentation, I think, or on
the download page.
I still can't connect to the refractions postgres, same as before:
org.geotools.data.DataSourceException: Connection
failed:org.postgresql.util.PSQLException: Connection rejected:
FATAL: no pg_hba.conf entry for host "24.159.243.19", user
"postgres", database "demo_bc".
that postgres configuration problem to let any IP address connect.
(that host IP is my current home IP, I've also tried from work)
But, how does that verify backwards compatibility, if refractions
uses pgsql 8.0.3 also? Or were those 2 separate questions?
On Aug 26, 2005, at 6:35 PM, Jesse Eichar wrote:
So... do you know if it is backward compatible? Does it work
with
the
www.refractions.net
postgres/postgres
demo-bc
public
database? That one is postgres 8.0.3 postgis 1.0.1.
Jesse
William Kyngesburye wrote:
Woohoo! I found the jdbc.postgresql.org site and downloaded the
jdbc3 driver for postgres 8. I replaced the
postgresql-74.213.jar in the udig plugins folder. Success in
connecting to my postgres 8/ postgis data!
On Aug 24, 2005, at 10:23 AM, William Kyngesburye wrote:
I reported this also in the RC stages for Mac OS X. Can't
connect to pgsql. And no, your refractions postgres is still
not public.
FWIW, I'm trying to connect to postgres 8.0.3/postgid 1.0.3. I
noticed in the udig plugins that the postgres library is for
postgres 7.4.
-----
William Kyngesburye <kyngchaos@xxxxxxxxxxxxx>
http://www.kyngchaos.com/
Theory of the Universe
There is a theory which states that if ever anyone discovers
exactly what the universe is for and why it is here, it will
instantly disappear and be replaced by something even more
bizarrely inexplicable. There is another theory which states that
this has already happened.
-Hitchhiker's Guide to the Galaxy 2nd season intro
_______________________________________________
User-friendly Desktop Internet GIS (uDig)
http://udig.refractions.net
http://lists.refractions.net/mailman/listinfo/udig-devel
_______________________________________________
User-friendly Desktop Internet GIS (uDig)
http://udig.refractions.net
http://lists.refractions.net/mailman/listinfo/udig-devel
_______________________________________________
User-friendly Desktop Internet GIS (uDig)
http://udig.refractions.net
http://lists.refractions.net/mailman/listinfo/udig-devel
-----
William Kyngesburye <kyngchaos@xxxxxxxxxxxxx>
http://www.kyngchaos.com/
"Time is an illusion - lunchtime doubly so."
- Ford Prefect
_______________________________________________
User-friendly Desktop Internet GIS (uDig)
http://udig.refractions.net
http://lists.refractions.net/mailman/listinfo/udig-devel
_______________________________________________
User-friendly Desktop Internet GIS (uDig)
http://udig.refractions.net
http://lists.refractions.net/mailman/listinfo/udig-devel