Re: [Qgis-user] Quantum Connect to PostgreSQL
also make sure that the SSL mode setting is correct - not to mention user/pw of course ... Can you connect from other machines with other software (e.g. pgadmin3) using the same settings? Andreas On Mon, September 14, 2009 5:42 am, pcr...@pcreso.com wrote: Hi Chris, Have you enabled TCP/IP access in pg_hba.conf? QGIS uses a network socket connection whether or not it is on a local host, so Postgres needs to enable such connections. Brent Wood --- On Mon, 9/14/09, chris Wild chrismw...@gmail.com wrote: From: chris Wild chrismw...@gmail.com Subject: [Qgis-user] Quantum Connect to PostgreSQL To: qgis-user@lists.osgeo.org Date: Monday, September 14, 2009, 3:29 PM Dear All We are trying to set up a Quantum connection to a POSTGIS database using Port 5432. The connection comes back Refused each time. We have also tried an ODBC driver based connection to the database and it also is refused. The exact message is: The database said: Could not connect to server: Connection Refused All firewalls are open for Port 5432 and the server router is logging packets getting through it. Can anyone help? Best Wishes Tony Lindsay -Inline Attachment Follows- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- Andreas Neumann http://www.carto.net/neumann/ http://www.svgopen.org/ ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Genealogy Related
Hi Dion, QGIS has a georeferencer plugin for that purpose: see QGIS manual (http://download.osgeo.org/qgis/doc/manual/qgis-1.1.0_user_guide_en.pdf) - p. 122-125 - you need to know the coordinates of individual features (3-5 per map sheet) of the target coordinate system. You have to register raster images individually though. The gdal_merge tool (command line) allows to later merge the files into a single file, once they are georeferenced. See: http://www.gdal.org/gdal_merge.html It shouldn't matter which operating system you choose. All should be equally well supported. Hope this helps to get started, Andreas On Mon, September 14, 2009 2:23 am, Houston, Dion A Sr CPT MIL USA TRADOC wrote: Hi all, I apologize if this is a GIS 101 kind of question. I am slightly above neophyte when it comes to GIS. I am trying to track down where some ancestors of mine lived. I recently acquired JPG#8217;s of old township maps showing my relatives from the early-mid 1800#8217;s. Of course these JPG#8217;s aren#8217;t geo-rectified, each township is in a separate file, and they#8217;re not necessarily north facing. The also have limited features I can identify on modern maps, specifically I was attempting to use hydrology, but there are now several reservoirs in the area so much of the hydrology has changed. What I hope to do is to merge several township maps together basically like a jigsaw puzzle and use churches to georectify. I downloaded QGIS hoping it would be easy to do so, but it seems like raster layers are tied together by coordinate system, so it puts the upper left corners of my township maps together and doesn#8217;t allow me to move them. If someone can tell me what tool(s) will do what I want, and/or how to do it in QGIS I#8217;d appreciate it. I am (as of this week) running a Mac with Windows and Kubuntu running virtually so (practically) any operating system will work. I am currently using GeoRect from FalconView to georectify, but I noticed QGIS has that capability as well so I may try that. My preference is to use free or cheap software, as I can#8217;t justify spending hundreds of dollars on Photoshop just to find some old ancestors :) Thanks in advance, Dion ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- Andreas Neumann http://www.carto.net/neumann/ http://www.svgopen.org/ ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Quantum Connect to PostgreSQL
Hi, I am joining to this subject because I have just the same problem... I can't connect since a remote QGis neither Pgadmin. Do you have a sample of pg_hba.conf ? Can you explain how to know the SSL mode set in our server ? thx, Enzo Andreas Neumann a écrit : also make sure that the SSL mode setting is correct - not to mention user/pw of course ... Can you connect from other machines with other software (e.g. pgadmin3) using the same settings? Andreas On Mon, September 14, 2009 5:42 am, pcr...@pcreso.com wrote: Hi Chris, Have you enabled TCP/IP access in pg_hba.conf? QGIS uses a network socket connection whether or not it is on a local host, so Postgres needs to enable such connections. Brent Wood --- On Mon, 9/14/09, chris Wild chrismw...@gmail.com wrote: From: chris Wild chrismw...@gmail.com Subject: [Qgis-user] Quantum Connect to PostgreSQL To: qgis-user@lists.osgeo.org Date: Monday, September 14, 2009, 3:29 PM Dear All We are trying to set up a Quantum connection to a POSTGIS database using Port 5432. The connection comes back Refused each time. We have also tried an ODBC driver based connection to the database and it also is refused. The exact message is: The database said: Could not connect to server: Connection Refused All firewalls are open for Port 5432 and the server router is logging packets getting through it. Can anyone help? Best Wishes Tony Lindsay -Inline Attachment Follows- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user attachment: vincent_blanque.vcf___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Quantum Connect to PostgreSQL
Hi, If pgadmin3 can't connect then it is not a QGIS issue. I would guess it is either an incorrectly specified postgresql.conf or pg_hba.conf or a firewall blocking access. In order to allow network access to your database you need to do the following: in postgresql.conf set: listen_addresses = '*' This is in the CONNECTIONS AND AUTHENTICATION section of the config file Also make sure the standard port 5432 is set (or use a different port, but use it everywhere where needed) See http://www.postgresql.org/docs/8.4/interactive/runtime-config-connection.html for more information. in pg_hba.conf set: hostallall0.0.0.0/0md5 See http://www.postgresql.org/docs/8.4/interactive/auth-pg-hba-conf.html In both files you can limit it to subnets instead of '*' or '0.0.0.0/0' - which would allow connections from everywhere. Make sure you restart or reload the postgresql server after you changed the config files. Also, make sure that your firewall is not blocking port 5432. Regarding SSL: by default, SSL is not activated in PostgreSQL, so I guess this shouldn't be the problem. Hope this helps, Andreas Vincent Blanqué wrote: Hi, I am joining to this subject because I have just the same problem... I can't connect since a remote QGis neither Pgadmin. Do you have a sample of pg_hba.conf ? Can you explain how to know the SSL mode set in our server ? thx, Enzo ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Value Tool does not work on 1.3.0
Using ubuntu jaunty, Value tool does not work with latest 1.3.0 from the ubuntugis repository. No error, just does not print the raster values. This is a very important tool, displaying raster values is essential. Any help? Thanks Agus attachment: alobolistas.vcf___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Quantum Connect to PostgreSQ
Thanks Andreas and Brent, We are connecting remotely now after altering the postgresql.conf and pg_hba.conf files. Much appreciated. Regards Chris ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
