Estou tentando conectar com uma camada postgis, e informa o seguinte erro:
Problemas ao gerar o mapa Error in %s: %s msDrawMap()Failed to draw layer named 'rip_'. Error in %s: %s msPostGISLayerOpen()Database connection failed (FATAL: no pg_hba.conf entry for host "::1", user "usuario", database "spu", SSL off ) with connect string 'user=usuario password=*** dbname=spu host=localhost port=5432'
Is the database running? Is it allowing connections? Does the specified user exist? Is the password valid? Is the database on the standard port?
MAP
FONTSET "../symbols/fontes.txt"
SYMBOLSET "../symbols/simbolosv6.sym"
LAYER
CONNECTION "user=usuario password=teste dbname=spu host=localhost port=5432"
CONNECTIONTYPE POSTGIS
DATA "the_geom FROM (SELECT * FROM rip_) as foo USING UNIQUE gid USING SRID=29194"
METADATA
"METAESTAT_ID_MEDIDA_VARIAVEL" ""
"cache" ""
"CLASSE" "SIM"
"permitekmz" ""
"iconetema" ""
"METAESTAT_CODIGO_TIPO_REGIAO" ""
"permitedownload" ""
"metaestat" ""
"permitekml" ""
"permiteogc" ""
"TEMA" "rip_"
"convcaracter" ""
END # METADATA
NAME "rip_"
STATUS OFF
TEMPLATE "none.htm"
TYPE POLYGON
UNITS METERS
CLASS
NAME ""
STYLE
ANGLE 0
COLOR 0 0 0
OFFSET 0 0
END # STYLE
END # CLASS
END # LAYER
END # MAP
Autor: dario neto
66 comentários
msDrawMap()Failed to draw layer named 'bahia'.
Error in %s: %s
msPostGISLayerWhichShapes()Error executing query: ERROR: column "the_geom" does not exist
LINE 1: select encode(ST_AsBinary(ST_Force_2D("the_geom"),'NDR'),'he...