| Re: [udig-devel] not able to connect to PostGIS |
Paul Ramsey wrote:
Probably the "list-o-databases" attempt should fail silently if it cannot connect, instead of failing noisily.P
I agree.
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 afteryou enter the password(because not all dbs are public) but when you putdemo-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_______________________________________________ User-friendly Desktop Internet GIS (uDig) http://udig.refractions.net http://lists.refractions.net/mailman/listinfo/udig-devel