[mapserver-users] mapserver - postgis/postgresql connection problem

[kassandraxx]

Hello!

http://archeogis.myftp.org/pmapper-4.2.0/map_default.phtml

in this example, I can see the data uploaded to the ftp, but I can not see
the data uploaded to the database ( ager Firmanus ) .
In QGIS i can add postgis vector data, then the database is working
properly.

This is part of my map file

LAYER
    NAME 'Ager Firmanus'
    TYPE LINE
    DUMP true
    TEMPLATE void
  EXTENT 325018.498153 4739346.182159 402747.056951 4777108.180989
    CONNECTIONTYPE postgis
    CONNECTION "dbname='db_name' host=archeogis.myftp.org port=5432
user='xxx' password='xxx' sslmode=disable"
    DATA 'the_geom FROM "ager_firmanus" USING UNIQUE gid USING srid=32633'
    METADATA
      'ows_title' 'ager_firmanus'
    END
    STATUS OFF
    TRANSPARENCY 100
    PROJECTION
    'proj=utm'
    'zone=33'
    'datum=WGS84'
    'units=m'
    'no_defs'
    END
    CLASS
       NAME 'ager_firmanus' 
       STYLE
         WIDTH 1 
         COLOR 77 158 104
       END
    END
  END
  

Table ager_firmanus 
gid 	Id 	the_geom
1        0      0102000020797F0000FE0000004979E20BBB4A1841014A22E...

table geometry_columns

f_table_catalog 	f_table_schema 	f_table_name 	f_geometry_column 
coord_dimension 	srid 	type
db_name	              public	         ager_firmanus	  the_geom                    
2                32633 LINESTRING

I can not understand where is the error :(



--
View this message in context: http://osgeo-org.1560.x6.nabble.com/mapserver-postgis-postgresql-connection-problem-tp5181475.html
Sent from the Mapserver - User mailing list archive at Nabble.com.