[postgis-users] I have a problem? and need help

[Gregory Williamson]

The user you are connecting as ("sigtrujo" ?) does not have permission to do a select on the "sitios" table; you'll need to get the database admin to do something along the lines of "GRANT SELECT ON sitios TO <username>;".

You may also need to add that user, the IP of the server the MMS is at and the database to allow remote connections to the pg_hba.conf file and then reload the postmaster. 

HTH,

Greg Williamson
Senior DBA
DigitalGlobe

Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information and must be protected in accordance with those provisions. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

(My corporate masters made me say this.)



-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net on behalf of jeviloria at cantv.net
Sent: Mon 7/21/2008 7:01 PM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] I have a problem? and need help
 
Hello friends,


When requesting a service WMS, 
http://www.sigtruj.org.ve/cgi-sys/mapserv?map=/home/sigtrujo/www/map/pru eba2.map&layers=mun&mode=map
gives me the following error:
msDrawMap(): Image handling error. Failed to draw layer named 'prueba'. prepare_database(): Query error. Error declaring cursor: ERROR: permission denied for relation sitios With query string: DECLARE mycursor BINARY CURSOR FOR SELECT asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text from sitios WHERE the_geom && setSRID('BOX3D(-74.65 -2.465,-56.89 15.295)'::BOX3D, find_srid('','sitios','the_geom') )


The file Map.


MAP
  NAME ven_vias
  SIZE 400 400
  UNITS dd

INTERLACE ON

  EXTENT -74.65 -2.465 -56.89 15.295
 
PROJECTION
    'init=EPSG:4189'
  END
  FONTSET
'../fonts/fonts.txt'
  SYMBOLSET '../simbolo/simbolo.txt'
  

	WEB
		TEMPLATE "../plantilla.html"
		IMAGEPATH
"/home/sigtrujo/www/tmp/ms_tmp/"
		IMAGEURL "/tmp/ms_tmp/"
		#EMPTY 
"http://www.sigtruj.org.ve/plantilla.html"
		LOG
"../mapservEdenWfsIow.log" 

		METADATA
			"wms_title" 	     "WMS
Demo Server" ##REQUIRED - generates warning in xml output if
missing
			"wms_onlineresourse"
"http://localhost/cgi-bin/mapserv"
			"wms_srs"           
"init=epsg:24719"	
		END 
	END #end web

LAYER
    NAME
"prueba"
    TYPE point
    CONNECTIONTYPE postgis
    CONNECTION
"host=localhost port=5432 user=sigtrujo_test password=andrea08
dbname=sigtrujo_ve"
    DATA "the_geom FROM sitios"
    STATUS
DEFAULT
    METADATA
      'wms_title' 'sitios'
    END
   
PROJECTION
    'init=EPSG:4189'
    END
    CLASS
       NAME
'VALOR' 
       STYLE
          COLOR 255 0 0
          SYMBOL
0
       END
     END
END
IMAGETYPE PNG
OUTPUTFORMAT
  
NAME PNG
   DRIVER "GD/PNG"
   MIMETYPE "image/png"
   IMAGEMODE
PC256
   EXTENSION "png"
   TRANSPARENT ON
 END
END
The tables were generated with the BD: 
shp2pgsql -I -s 4019 D:\POSTGRADO\TFM\DATOS\SIGTRUJ\cit_tur_truj.shp sit_tur_truj sigtruj> sit_tur_truj.sql

I am using MS4W and everything works well, so local,  but to stay at my web server (www.sigtruj.org.ve) gives me the error.


I can help solve this problem?. Thank you.







-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080721/43b2dd31/attachment.html>