[Mapserver-users] need help on use mysql with mapserver

[Litao Wei]

Dear All,

Now I try to install mapserver and use mygis on redhat9, but I got some troubles and hope someone can help me:
My config command:

[root at mylinux mapserver-4.0.1]# ./configure --with-proj  --with-gdal   --with-gd  --with-freetype   --with-ogr --with-mygis

It looks well, no error occured.
but when I try "make", some errors displayed on my screen:

[root at mylinux mapserver-4.0.1]# make
gcc -c -O2  -Wall -DIGNORE_MISSING_DATA  -DUSE_EPPL -DUSE_PROJ -DUSE_PROJ_A
-DUSE_WMS_SVR      -DUSE_TIFF -DUSE_JPEG -DUSE_GD_PNG -DUSE_GD_JPEG -DUSE_G
P -DUSE_GD_FT   -DUSE_OGR -DUSE_GDAL  -DUSE_MYGIS   -I/usr/local/include
 -I/usr/local/include -I/usr/local/include  -I'/usr/include'    mapmygis.c
pmygis.o
mapmygis.c:22:25: mysql/mysql.h: no such file or directory
mapmygis.c:121: parse error before "MYSQL"
mapmygis.c:121: warning: no semicolon at end of struct or union
mapmygis.c:122: warning: type defaults to `int' in declaration of `query_re
mapmygis.c:122: warning: data definition has no type or storage class
mapmygis.c:123: parse error before '*' token
mapmygis.c:123: warning: type defaults to `int' in declaration of `query2_r
'
mapmygis.c:123: warning: data definition has no type or storage class
mapmygis.c:134: parse error before '}' token
mapmygis.c:134: warning: type defaults to `int' in declaration of `msMYGISL
nfo'
mapmygis.c:134: warning: data definition has no type or storage class
mapmygis.c:136: parse error before '*' token
mapmygis.c:136: warning: type defaults to `int' in declaration of `prevconn
mapmygis.c:136: warning: data definition has no type or storage class
mapmygis.c: In function `mysql_NOTICE_HANDLER':
mapmygis.c:150: parse error before ')' token
mapmygis.c:152: parse error before ')' token
mapmygis.c:156: parse error before ')' token
mapmygis.c: At top level:
mapmygis.c:221: parse error before '*' token
mapmygis.c:221: `query' redeclared as different kind of symbol
mapmygis.c:126: previous declaration of `query'
mapmygis.c: In function `query':
mapmygis.c:225: `layer' undeclared (first use in this function)
mapmygis.c:225: (Each undeclared identifier is reported only once
mapmygis.c:225: for each function it appears in.)
mapmygis.c:227: warning: implicit declaration of function `mysql_free_resul
mapmygis.c:229: `qbuf' undeclared (first use in this function)
mapmygis.c:230: warning: implicit declaration of function `mysql_query'
mapmygis.c:231: warning: implicit declaration of function `mysql_close'
mapmygis.c:237: warning: implicit declaration of function `mysql_store_resu
mapmygis.c:247: warning: implicit declaration of function `mysql_affected_r
mapmygis.c: In function `msMYGISLayerOpen':
mapmygis.c:263: `layerinfo' undeclared (first use in this function)
mapmygis.c:282: parse error before ')' token
mapmygis.c:344: warning: implicit declaration of function `mysql_connect'
mapmygis.c:354: warning: implicit declaration of function `mysql_select_db'
mapmygis.c: At top level:
mapmygis.c:418: parse error before "MYSQL_RES"
mapmygis.c: In function `prep_DB':
mapmygis.c:426: `layerinfo' undeclared (first use in this function)
mapmygis.c:433: parse error before ')' token
mapmygis.c:448: `geom_table' undeclared (first use in this function)
mapmygis.c:451: parse error before ')' token
mapmygis.c:480: `layer' undeclared (first use in this function)
mapmygis.c:488: `rect' undeclared (first use in this function)
mapmygis.c: In function `msMYGISLayerWhichShapes':
mapmygis.c:609: `layerinfo' undeclared (first use in this function)
mapmygis.c:613: parse error before ')' token
mapmygis.c: In function `msMYGISLayerClose':
mapmygis.c:651: `layerinfo' undeclared (first use in this function)
mapmygis.c:654: parse error before ')' token
mapmygis.c: At top level:
mapmygis.c:692: parse error before "row"
mapmygis.c: In function `force_to_points':
mapmygis.c:701: `shape' undeclared (first use in this function)
mapmygis.c:703: `row' undeclared (first use in this function)
mapmygis.c:720: warning: implicit declaration of function `mysql_fetch_row'
mapmygis.c:720: `qresult' undeclared (first use in this function)
mapmygis.c: At top level:
mapmygis.c:750: parse error before "row"
mapmygis.c: In function `force_to_lines':
mapmygis.c:759: `shape' undeclared (first use in this function)
mapmygis.c:761: `row' undeclared (first use in this function)
mapmygis.c:770: `qresult' undeclared (first use in this function)
mapmygis.c: At top level:
mapmygis.c:803: parse error before "row"
mapmygis.c: In function `force_to_polygons':
mapmygis.c:813: `shape' undeclared (first use in this function)
mapmygis.c:815: `row' undeclared (first use in this function)
mapmygis.c:830: `qresult' undeclared (first use in this function)
mapmygis.c: At top level:
mapmygis.c:865: parse error before "row"
mapmygis.c: In function `dont_force':
mapmygis.c:875: `row' undeclared (first use in this function)
mapmygis.c:884: `qresult' undeclared (first use in this function)
mapmygis.c:884: `shape' undeclared (first use in this function)
mapmygis.c:884: `cntchar' undeclared (first use in this function)
mapmygis.c: In function `msMYGISLayerNextShape':
mapmygis.c:1187: `layerinfo' undeclared (first use in this function)
mapmygis.c:1189: parse error before ')' token
mapmygis.c: In function `msMYGISLayerGetShapeRandom':
mapmygis.c:1217: `layerinfo' undeclared (first use in this function)
mapmygis.c:1220: `MYSQL_ROW' undeclared (first use in this function)
mapmygis.c:1220: parse error before "row"
mapmygis.c:1225: parse error before ')' token
mapmygis.c:1257: `row' undeclared (first use in this function)
mapmygis.c:1334: warning: int format, long int arg (arg 7)
mapmygis.c:1359: `row_attr' undeclared (first use in this function)
mapmygis.c: In function `msMYGISLayerGetShape':
mapmygis.c:1418: `layerinfo' undeclared (first use in this function)
mapmygis.c:1421: warning: unsigned int format, long int arg (arg 2)
mapmygis.c:1423: parse error before ')' token
mapmygis.c: In function `msMYGISLayerGetItems':
mapmygis.c:1612: `layerinfo' undeclared (first use in this function)
mapmygis.c:1618: `MYSQL_ROW' undeclared (first use in this function)
mapmygis.c:1618: parse error before "row"
mapmygis.c:1628: parse error before ')' token
mapmygis.c:1655: `row' undeclared (first use in this function)
make: *** [mapmygis.o] Error 1

I hope anyone can help me check why I can't install. Thank you.

Litao Wei