[Xastir] Xastir => Mysql

[Mike L]

I recompiled it again, here is the capture from bash:

desktop:~$ cd ~/.xastir
w2swr at w2swr-desktop:~/.xastir$ ./configure --with-mysql
bash: ./configure: No such file or directory
w2swr at w2swr-desktop:~/.xastir$ cd ~/src/xastir
w2swr at w2swr-desktop:~/src/xastir$ ./configure --with-mysql
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for a thread-safe mkdir -p... /bin/mkdir -p
checking for gawk... no
checking for mawk... mawk
checking whether make sets $(MAKE)... yes

Configuring xastir 1.9.7

checking build system type... i686-pc-linux-gnu
checking host system type... i686-pc-linux-gnu
checking for style of include used by make... GNU
checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ISO C89... none needed
checking dependency style of gcc... gcc3
checking how to run the C preprocessor... gcc -E
checking for grep that handles long lines and -e... /bin/grep
checking for egrep... /bin/grep -E
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking minix/config.h usability... no
checking minix/config.h presence... no
checking for minix/config.h... no
checking whether it is safe to define __EXTENSIONS__... yes
checking for gcc... (cached) gcc
checking whether we are using the GNU C compiler... (cached) yes
checking whether gcc accepts -g... (cached) yes
checking for gcc option to accept ISO C89... (cached) none needed
checking dependency style of gcc... (cached) gcc3
checking how to run the C preprocessor... gcc -E
checking whether ln -s works... yes
checking whether make sets $(MAKE)... (cached) yes
checking for gawk... (cached) mawk
checking for ranlib... ranlib
checking for devices... found /dev/ttyS0 and /dev/ttyS1
checking for search paths... done
checking for the pthreads library -lpthreads... no
checking whether pthreads work without any flags... no
checking whether pthreads work with -Kthread... no
checking whether pthreads work with -kthread... no
checking for the pthreads library -llthread... no
checking whether pthreads work with -pthread... yes
checking for joinable pthread attribute... PTHREAD_CREATE_JOINABLE
checking if more special flags are required for pthreads... no
checking for cc_r... gcc
checking whether compiler accepts -Wno-unused-parameter... yes
checking for compiler flags... using -g -O2 -pipe -W -Wall -Wpointer-arith
-Wstrict-prototypes -Wno-unused-parameter
-pthread

checking for system...
Linux

checking for gm...
no

checking for /usr/bin/gm.exe...
no

checking for convert...
/usr/bin/convert

checking for /usr/bin/convert.exe...
no

checking for lpr...
/usr/bin/lpr

checking for gv...
/usr/bin/gv

checking gv version... new, >=
3.6.1

checking for festival...
no

checking for gpsman...
/usr/bin/gpsman

checking for X... libraries ,
headers

checking for gethostbyname...
yes

checking for connect...
yes

checking for remove...
yes

checking for shmat...
yes

checking for IceConnectionNumber in -lICE...
yes
checking for library containing tan...
-lm

checking for XextAddDisplay in -lXext...
yes

checking for XpGetDocumentData in -lXp...
yes
checking for XtDisplay in -lXt...
yes

checking for XmTextFindString in -lXm...
yes

checking for sed...
/bin/sed

checking for mv...
/bin/mv

checking for xfontsel...
/usr/bin/xfontsel

checking curl/curl.h usability...
no

checking curl/curl.h presence...
no

checking for curl/curl.h...
no

checking for wget...
/usr/bin/wget

checking for main in -lcompat...
no

checking for sched_yield in -lrt...
yes

checking whether byte ordering is bigendian...
no
checking for Motif headers... in default
path

checking for Motif libraries... in default
path
checking for working alloca.h...
yes

checking for alloca...
yes

checking for dirent.h that defines DIR...
yes
checking for library containing opendir... none
required
checking for ANSI C header files... (cached)
yes
checking for sys/wait.h that is POSIX.1 compatible...
yes
checking argz.h usability...
yes

checking argz.h presence...
yes

checking for argz.h...
yes

checking arpa/inet.h usability...
yes

checking arpa/inet.h presence...
yes

checking for arpa/inet.h...
yes

checking fcntl.h usability...
yes

checking fcntl.h presence...
yes

checking for fcntl.h...
yes

checking libintl.h usability...
yes

checking libintl.h presence...
yes

checking for libintl.h...
yes

checking limits.h usability...
yes

checking limits.h presence...
yes

checking for limits.h...
yes

checking locale.h usability...
yes

checking locale.h presence...
yes

checking for locale.h...
yes

checking malloc.h usability...
yes

checking malloc.h presence...
yes

checking for malloc.h...
yes

checking math.h usability...
yes

checking math.h presence...
yes

checking for math.h...
yes

checking netdb.h usability...
yes

checking netdb.h presence...
yes

checking for netdb.h...
yes

checking netinet/in.h usability...
yes

checking netinet/in.h presence...
yes

checking for netinet/in.h...
yes

checking nl_types.h usability...
yes

checking nl_types.h presence...
yes

checking for nl_types.h...
yes

checking stdarg.h usability...
yes

checking stdarg.h presence...
yes

checking for stdarg.h...
yes

checking stddef.h usability...
yes

checking stddef.h presence...
yes

checking for stddef.h...
yes

checking for stdlib.h... (cached)
yes

checking for string.h... (cached)
yes

checking for strings.h... (cached)
yes

checking sys/file.h usability...
yes

checking sys/file.h presence...
yes

checking for sys/file.h...
yes

checking sys/ioctl.h usability...
yes

checking sys/ioctl.h presence...
yes

checking for sys/ioctl.h...
yes

checking sys/param.h usability...
yes

checking sys/param.h presence...
yes

checking for sys/param.h...
yes

checking sys/socket.h usability...
yes

checking sys/socket.h presence...
yes

checking for sys/socket.h...
yes

checking sys/time.h usability...
yes

checking sys/time.h presence...
yes

checking for sys/time.h...
yes

checking signal.h usability...
yes

checking signal.h presence...
yes

checking for signal.h...
yes

checking termios.h usability...
yes

checking termios.h presence...
yes

checking for termios.h...
yes

checking for unistd.h... (cached)
yes

checking for an ANSI C-conforming const...
yes
checking for uid_t in sys/types.h...
yes

checking for inline...
inline

checking for pid_t...
yes

checking for size_t...
yes

checking whether time.h and sys/time.h may both be included...
yes
checking return type of signal handlers...
void
checking whether struct tm is in sys/time.h or time.h...
time.h
checking for struct tm.tm_zone...
yes

checking for socklen_t...
yes

checking for sighandler_t...
yes

checking for sig_t...
yes

checking for sigjmp_buf...
yes

checking for gmtoff in struct tm...
yes

checking vfork.h usability...
no

checking vfork.h presence...
no

checking for vfork.h...
no

checking for fork...
yes

checking for vfork...
yes

checking for working fork...
yes

checking for working vfork... (cached)
yes

checking whether gcc needs -traditional...
no
checking whether getpgrp requires zero arguments...
yes
checking for stdlib.h... (cached)
yes

checking for GNU libc compatible malloc...
yes
checking for sys/time.h... (cached)
yes

checking for unistd.h... (cached)
yes

checking for alarm...
yes

checking for working mktime...
yes

checking for stdlib.h... (cached)
yes

checking for unistd.h... (cached)
yes

checking for getpagesize...
yes

checking for working mmap...
yes

checking whether lstat dereferences a symlink specified with a trailing
slash... yes
checking whether stat accepts an empty string...
no
checking for strftime...
yes

checking for working strtod...
yes

checking for __argz_count...
yes

checking for __argz_next...
yes

checking for __argz_stringify...
yes

checking for alarm... (cached)
yes

checking for dcgettext...
yes

checking for getcwd...
yes

checking for getpgrp...
yes

checking for gethostbyname... (cached)
yes

checking for gethostname...
yes

checking for gettimeofday...
yes

checking for getwd...
yes

checking for inet_ntoa...
yes

checking for memmove...
yes

checking for mempcpy...
yes

checking for memset...
yes

checking for mkdir...
yes

checking for munmap...
yes

checking for pow...
yes

checking for putenv...
yes

checking for select...
yes

checking for setenv...
yes

checking for setlocale...
yes

checking for settimeofday...
yes

checking for signal...
yes

checking for sigignore...
yes

checking for snprintf...
yes

checking for socket...
yes

checking for sqrt...
yes

checking for stpcpy...
yes

checking for strcasecmp...
yes

checking for strchr...
yes

checking for strdup...
yes

checking for strerror...
yes

checking for strncasecmp...
yes

checking for strpbrk...
yes

checking for strptime...
yes

checking for strrchr...
yes

checking for strstr...
yes

checking for strtof...
yes

checking for strtol...
yes

checking for strtoul...
yes

checking for tzset...
yes

checking for vsnprintf...
yes

checking for pthread_mutexattr_setkind_np...
yes
checking for pthread_mutexattr_settype...
yes
checking for strndup...
yes

checking for roundf...
yes

checking for gettext in -lintl...
no

checking shapefil.h usability...
yes

checking shapefil.h presence...
yes

checking for shapefil.h...
yes

checking for DBFOpen in -lshp...
yes

checking for DBFGetFieldIndex in -lshp...
yes
checking pcre.h usability...
yes

checking pcre.h presence...
yes

checking for pcre.h...
yes

checking for pcre_compile in -lpcre...
yes

checking X11/xpm.h usability...
yes

checking X11/xpm.h presence...
yes

checking for X11/xpm.h...
yes

checking for library containing XpmWriteFileFromPixmap...
-lXpm
checking Xm/XpmI.h usability...
no

checking Xm/XpmI.h presence...
no

checking for Xm/XpmI.h...
no

checking for pj_init in -lproj...
yes

checking for TIFFClose in -ltiff...
yes

checking for GTIFNew in -lgeotiff...
yes

checking for mysql_config...
/usr/bin/mysql_config

checking mysql version >= 4.1.2...
yes

checking netax25/ax25.h usability...
yes

checking netax25/ax25.h presence...
yes

checking for netax25/ax25.h...
yes

checking for ax25_config_load_ports in -lax25...
yes
checking for gdal-config...
no

configure: WARNING: *** Cannot find gdal-config:  Checking standard
locations ***
checking gdal.h usability...
no

checking gdal.h presence...
no

checking for gdal.h...
no

checking for runpath switch...
-Wl,-rpath,

checking if db.h is exists and is usable...
yes
checking for a library containing db_create...
-ldb-4.7
checking for GraphicsMagick-config...
no

checking for Magick-config...
/usr/bin/Magick-config

checking magick/api.h usability...
yes

checking magick/api.h presence...
yes

checking for magick/api.h...
yes

checking for library containing WriteImage... none
required
configure: creating
./config.status

config.status: creating
Makefile

config.status: creating
callpass/Makefile

config.status: creating
config/Makefile

config.status: creating
help/Makefile

config.status: creating
m4/Makefile

config.status: creating
scripts/Makefile

config.status: creating
scripts/values

config.status: creating scripts/values.pl

config.status: creating
src/Makefile

config.status: creating
src/rtree/Makefile

config.status: creating
src/shapelib/Makefile

config.status: creating
src/shapelib/contrib/Makefile

config.status: creating
symbols/Makefile

config.status: creating
xastir.spec

config.status: creating
xastir-min.spec

config.status: creating
xastir-lsb.spec

config.status: creating
config.h

config.status: config.h is
unchanged

config.status: executing depfiles
commands

===========================================


xastir 1.9.7 has been configured to use the following
options and external libraries:

MINIMUM OPTIONS:
  ShapeLib (Vector maps) ................. : yes

RECOMMENDED OPTIONS:
  GraphicsMagick/ImageMagick (Raster maps) : yes (ImageMagick)
  pcre (Shapefile customization) ......... : yes
  dbfawk (Shapefile customization) ....... : yes
  rtree indexing (Shapefile speedups) .... : yes
  map caching (Raster map speedups) ...... : yes
  internet map retrieval ................. : yes (wget)

FOR THE ADVENTUROUS:
  AX25 (Linux Kernel I/O Drivers) ........ : yes
  libproj (USGS Topos & Aerial Photos) ... : yes
  GeoTiff (USGS Topos & Aerial Photos) ... : yes
  Festival (Text-to-speech) .............. : no
  GDAL/OGR (Obtuse map formats) .......... : no
  GPSMan/gpsmanshp (GPS downloads) ....... : yes

DEVELOPER OPTIONS:
  ErrorPopups (Old Method) ............... : no
  libgc (Debug memory usage) ............. : no
  profiling (Debug code efficiency) ...... : no
  Linux Standard Base (LSB) .............. : no
  Spatial database support ............... : yes
  Spatial database Postgresql/Postgis .... : no
  MySQL .................................. : yes
  MySQL Spatial database support ......... : yes

xastir will be installed in /usr/local/bin.
Type 'make' to build Xastir (Use 'gmake' instead on some systems).
w2swr at w2swr-desktop:~/src/xastir$ make
make
all-recursive

make[1]: Entering directory
`/home/w2swr/src/xastir'

Making all in
src

make[2]: Entering directory
`/home/w2swr/src/xastir/src'

Making all in
rtree

make[3]: Entering directory
`/home/w2swr/src/xastir/src/rtree'

make[3]: Nothing to be done for
`all'.

make[3]: Leaving directory
`/home/w2swr/src/xastir/src/rtree'

make[3]: Entering directory
`/home/w2swr/src/xastir/src'

gcc -DHAVE_CONFIG_H -I. -I..   -I/usr/local/include -I/usr/include/mysql
-DBIG_JOINS=1 -fno-strict-aliasing -DUNIV_LINUX -I/usr/include/ImageMagick
-DXASTIR_DATA_BASE=\"/usr/local/share/xastir\"  -g -O2 -pipe -W -Wall
-Wpointer-arith -Wstrict-prototypes -Wno-unused-parameter -pthread -MT
db_gis.o -MD -MP -MF .deps/db_gis.Tpo -c -o db_gis.o db_gis.c
db_gis.c: In function
‘initConnections’:

db_gis.c:581: error: ‘Connection’ has no member named
‘phandle’

db_gis.c: In function
‘openConnection’:

db_gis.c:619: error: ‘DB_POSTGIS’ undeclared (first use in this
function)

db_gis.c:619: error: (Each undeclared identifier is reported only
once

db_gis.c:619: error: for each function it appears
in.)

db_gis.c:605: warning: unused variable
‘c’

db_gis.c:603: warning: unused variable
‘start_time’

db_gis.c:600: warning: unused variable
‘connected’

db_gis.c:599: warning: unused variable
‘connection_string’

db_gis.c: In function
‘pingConnection’:

db_gis.c:875: error: ‘ConnStatusType’ undeclared (first use in this
function)

db_gis.c:875: error: expected ‘;’ before
‘psql_status’

db_gis.c: In function
‘testConnection’:

db_gis.c:956: error: ‘ConnStatusType’ undeclared (first use in this
function)

db_gis.c:956: error: expected ‘;’ before
‘psql_status’

db_gis.c:957: error: ‘PGresult’ undeclared (first use in this
function)

db_gis.c:957: error: ‘result’ undeclared (first use in this
function)

db_gis.c:961: warning: passing argument 1 of ‘snprintf’ from incompatible
pointer
type

/usr/include/bits/stdio2.h:62: note: expected ‘char * __restrict__’ but
argument is of type ‘char
**’

db_gis.c:1025: warning: passing argument 1 of ‘snprintf’ from incompatible
pointer
type

/usr/include/bits/stdio2.h:62: note: expected ‘char * __restrict__’ but
argument is of type ‘char
**’

db_gis.c:1053: warning: passing argument 1 of ‘snprintf’ from incompatible
pointer
type

/usr/include/bits/stdio2.h:62: note: expected ‘char * __restrict__’ but
argument is of type ‘char
**’

db_gis.c:1058: warning: passing argument 1 of ‘snprintf’ from incompatible
pointer
type

/usr/include/bits/stdio2.h:62: note: expected ‘char * __restrict__’ but
argument is of type ‘char
**’

db_gis.c:1097: warning: format ‘%s’ expects type ‘char *’, but argument 4
has type ‘char
**’

db_gis.c:1097: warning: format ‘%s’ expects type ‘char *’, but argument 4
has type ‘char
**’

db_gis.c:958: warning: unused variable
‘postgis_sql’

db_gis.c: In function
‘storeStationToGisDbMysql’:

db_gis.c:1592: warning: unused variable
‘mysqlreturn’

db_gis.c: In function
‘storeCadToGisDbMysql’:

db_gis.c:1625: warning: unused variable
‘mysqlreturn’

db_gis.c: In function
‘storeStationSimplePointToGisDbMysql’:

db_gis.c:1703: warning: passing argument 1 of ‘mysql_stmt_init’ from
incompatible pointer
type

/usr/include/mysql/mysql.h:785: note: expected ‘struct MYSQL *’ but argument
is of type ‘struct MYSQL
**’

db_gis.c:1721: warning: assignment from incompatible pointer
type

db_gis.c:1732: warning: assignment from incompatible pointer
type

db_gis.c:1738: warning: assignment from incompatible pointer
type

db_gis.c:1744: warning: assignment from incompatible pointer
type

db_gis.c:1750: warning: assignment from incompatible pointer
type

db_gis.c:1756: warning: assignment from incompatible pointer
type

db_gis.c:1762: warning: assignment from incompatible pointer
type

db_gis.c:1768: warning: assignment from incompatible pointer
type

db_gis.c:1777: warning: format not a string literal and no format
arguments

db_gis.c:1807: warning: comparison between pointer and
integer

db_gis.c:1814: warning: comparison between pointer and
integer

db_gis.c:1821: warning: comparison between pointer and
integer

db_gis.c:1836: warning: comparison between pointer and
integer

db_gis.c:1866: warning: format ‘%d’ expects type ‘int’, but argument 4 has
type ‘long
int’

db_gis.c:1866: warning: format ‘%d’ expects type ‘int’, but argument 5 has
type ‘long
int’

db_gis.c:1866: warning: format ‘%d’ expects type ‘int’, but argument 4 has
type ‘long
int’

db_gis.c:1866: warning: format ‘%d’ expects type ‘int’, but argument 5 has
type ‘long
int’

db_gis.c: In function
‘getAllSimplePositionsMysqlSpatial’:

db_gis.c:1918: warning: passing argument 1 of ‘snprintf’ from incompatible
pointer
type

/usr/include/bits/stdio2.h:62: note: expected ‘char * __restrict__’ but
argument is of type ‘char
**’

db_gis.c:1919: warning: passing argument 1 of ‘stderr_and_statusline’ from
incompatible pointer
type

main.h:412: note: expected ‘char *’ but argument is of type ‘char
**’

db_gis.c:1923: warning: assignment from incompatible pointer
type

db_gis.c:1936: warning: passing argument 1 of ‘strlen’ from incompatible
pointer
type

/usr/include/string.h:397: note: expected ‘const char *’ but argument is of
type
‘MYSQL_ROW’

db_gis.c:1936: warning: passing argument 2 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1936: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1936: warning: passing argument 2 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1936: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1936: warning: passing argument 1 of ‘strlen’ from incompatible
pointer
type

/usr/include/string.h:397: note: expected ‘const char *’ but argument is of
type
‘MYSQL_ROW’

db_gis.c:1936: warning: passing argument 2 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1936: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1936: warning: passing argument 2 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1936: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1940: warning: passing argument 2 of ‘search_station_name’ from
incompatible pointer
type

database.h:601: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1947: warning: passing argument 3 of ‘snprintf’ from incompatible
pointer
type

/usr/include/bits/stdio2.h:62: note: expected ‘const char * __restrict__’
but argument is of type
‘MYSQL_ROW’

db_gis.c:1947: warning: format not a string literal and no format
arguments

db_gis.c:1947: warning: format not a string literal and no format
arguments

db_gis.c:1956: warning: passing argument 1 of ‘strlen’ from incompatible
pointer
type

/usr/include/string.h:397: note: expected ‘const char *’ but argument is of
type
‘MYSQL_ROW’

db_gis.c:1956: warning: passing argument 1 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1956: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1956: warning: passing argument 1 of ‘strlen’ from incompatible
pointer
type

/usr/include/string.h:397: note: expected ‘const char *’ but argument is of
type
‘MYSQL_ROW’

db_gis.c:1956: warning: passing argument 1 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1956: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1956: warning: passing argument 1 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1956: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1956: warning: passing argument 1 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1956: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1956: warning: passing argument 1 of ‘strlen’ from incompatible
pointer
type

/usr/include/string.h:397: note: expected ‘const char *’ but argument is of
type
‘MYSQL_ROW’

db_gis.c:1956: warning: passing argument 1 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1956: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1956: warning: passing argument 1 of ‘strlen’ from incompatible
pointer
type

/usr/include/string.h:397: note: expected ‘const char *’ but argument is of
type
‘MYSQL_ROW’

db_gis.c:1956: warning: passing argument 1 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1956: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1956: warning: passing argument 1 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1956: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1956: warning: passing argument 1 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1956: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1956: warning: suggest parentheses around comparison in operand of
‘&’

db_gis.c:1959: warning: passing argument 1 of ‘strlen’ from incompatible
pointer
type

/usr/include/string.h:397: note: expected ‘const char *’ but argument is of
type
‘MYSQL_ROW’

db_gis.c:1959: warning: passing argument 1 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1959: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1959: warning: passing argument 1 of ‘strlen’ from incompatible
pointer
type

/usr/include/string.h:397: note: expected ‘const char *’ but argument is of
type
‘MYSQL_ROW’

db_gis.c:1959: warning: passing argument 1 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1959: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1959: warning: passing argument 1 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1959: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1959: warning: passing argument 1 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1959: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1959: warning: passing argument 1 of ‘strlen’ from incompatible
pointer
type

/usr/include/string.h:397: note: expected ‘const char *’ but argument is of
type
‘MYSQL_ROW’

db_gis.c:1959: warning: passing argument 1 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1959: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1959: warning: passing argument 1 of ‘strlen’ from incompatible
pointer
type

/usr/include/string.h:397: note: expected ‘const char *’ but argument is of
type
‘MYSQL_ROW’

db_gis.c:1959: warning: passing argument 1 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1959: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1959: warning: passing argument 1 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1959: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1959: warning: passing argument 1 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1959: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1959: warning: suggest parentheses around comparison in operand of
‘&’

db_gis.c:1966: warning: passing argument 2 of ‘search_station_name’ from
incompatible pointer
type

database.h:601: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1972: warning: passing argument 1 of ‘xastirWKTPointToLatitude’
from incompatible pointer
type

db_gis.h:29: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1973: warning: passing argument 1 of ‘xastirWKTPointToLongitude’
from incompatible pointer
type

db_gis.h:30: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1974: warning: passing argument 1 of ‘strlen’ from incompatible
pointer
type

/usr/include/string.h:397: note: expected ‘const char *’ but argument is of
type
‘MYSQL_ROW’

db_gis.c:1975: warning: passing argument 1 of ‘strptime’ from incompatible
pointer
type

/usr/include/time.h:207: note: expected ‘const char * __restrict__’ but
argument is of type
‘MYSQL_ROW’

db_gis.c:1995: warning: passing argument 1 of ‘xastirWKTPointToLatitude’
from incompatible pointer
type

db_gis.h:29: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1996: warning: passing argument 1 of ‘xastirWKTPointToLongitude’
from incompatible pointer
type

db_gis.h:30: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1997: warning: passing argument 1 of ‘snprintf’ from incompatible
pointer
type

/usr/include/bits/stdio2.h:62: note: expected ‘char * __restrict__’ but
argument is of type ‘char
**’

db_gis.c:1998: warning: passing argument 1 of ‘snprintf’ from incompatible
pointer
type

/usr/include/bits/stdio2.h:62: note: expected ‘char * __restrict__’ but
argument is of type ‘char
**’

db_gis.c:1999: warning: passing argument 2 of ‘add_simple_station’ from
incompatible pointer
type

database.h:660: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1999: warning: passing argument 3 of ‘add_simple_station’ from
incompatible pointer
type

database.h:660: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1999: warning: passing argument 4 of ‘add_simple_station’ from
incompatible pointer
type

database.h:660: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1999: warning: passing argument 5 of ‘add_simple_station’ from
incompatible pointer
type

database.h:660: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1999: warning: passing argument 6 of ‘add_simple_station’ from
incompatible pointer
type

database.h:660: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1999: warning: passing argument 7 of ‘add_simple_station’ from
incompatible pointer
type

database.h:660: note: expected ‘char *’ but argument is of type ‘char
**’

db_gis.c:1999: warning: passing argument 8 of ‘add_simple_station’ from
incompatible pointer
type

database.h:660: note: expected ‘char *’ but argument is of type ‘char
**’

db_gis.c:1999: warning: passing argument 9 of ‘add_simple_station’ from
incompatible pointer
type

database.h:660: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1999: warning: passing argument 10 of ‘add_simple_station’ from
incompatible pointer
type

database.h:660: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1999: warning: passing argument 11 of ‘add_simple_station’ from
incompatible pointer
type

database.h:660: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1999: warning: passing argument 12 of ‘add_simple_station’ discards
qualifiers from pointer target
type
database.h:660: note: expected ‘char *’ but argument is of type ‘const char
*’

db_gis.c:2005: warning: assignment from incompatible pointer
type

db_gis.c:2012: warning: passing argument 1 of ‘snprintf’ from incompatible
pointer
type

/usr/include/bits/stdio2.h:62: note: expected ‘char * __restrict__’ but
argument is of type ‘char
**’

db_gis.c:2013: warning: passing argument 1 of ‘stderr_and_statusline’ from
incompatible pointer
type

main.h:412: note: expected ‘char *’ but argument is of type ‘char
**’

db_gis.c:1892: warning: unused variable
‘mysqlreturn’

db_gis.c: In function
‘getAllCadFromGisDbMysql’:

db_gis.c:2031: warning: unused variable
‘conn’

db_gis.c:2030: warning: unused variable
‘mysqlreturn’

db_gis.c: In function
‘getAllSimplePositionsMysqlSpatialInBoundingBox’:

db_gis.c:2043: warning: unused variable
‘conn’

db_gis.c:2042: warning: unused variable
‘mysqlreturn’

db_gis.c: In function
‘storeStationSimplePointToDbMysql’:

db_gis.c:2191: warning: comparison between pointer and
integer

db_gis.c:2195: warning: passing argument 2 of ‘mysql_real_escape_string’
from incompatible pointer
type

/usr/include/mysql/mysql.h:556: note: expected ‘char *’ but argument is of
type ‘char
(*)[3]’

db_gis.c:2197: warning: comparison between pointer and
integer

db_gis.c:2201: warning: passing argument 2 of ‘mysql_real_escape_string’
from incompatible pointer
type

/usr/include/mysql/mysql.h:556: note: expected ‘char *’ but argument is of
type ‘char
(*)[3]’

db_gis.c:2203: warning: comparison between pointer and
integer

db_gis.c:2207: warning: passing argument 2 of ‘mysql_real_escape_string’
from incompatible pointer
type

/usr/include/mysql/mysql.h:556: note: expected ‘char *’ but argument is of
type ‘char
(*)[3]’

db_gis.c:2213: warning: passing argument 2 of ‘mysql_real_escape_string’
from incompatible pointer
type

/usr/include/mysql/mysql.h:556: note: expected ‘char *’ but argument is of
type ‘char
(*)[19]’

db_gis.c:2213: warning: passing argument 3 of ‘mysql_real_escape_string’
from incompatible pointer
type

/usr/include/mysql/mysql.h:556: note: expected ‘const char *’ but argument
is of type ‘char
(*)[10]’

db_gis.c:2215: warning: comparison between pointer and
integer

db_gis.c:2218: warning: passing argument 1 of ‘strlen’ makes pointer from
integer without a
cast

/usr/include/string.h:397: note: expected ‘const char *’ but argument is of
type
‘char’

db_gis.c:2218: warning: passing argument 2 of ‘mysql_real_escape_string’
from incompatible pointer
type

/usr/include/mysql/mysql.h:556: note: expected ‘char *’ but argument is of
type ‘char
(*)[3]’

db_gis.c:2222: warning: passing argument 2 of ‘mysql_real_escape_string’
from incompatible pointer
type

/usr/include/mysql/mysql.h:556: note: expected ‘char *’ but argument is of
type ‘char
(*)[19]’

db_gis.c:2222: warning: passing argument 3 of ‘mysql_real_escape_string’
from incompatible pointer
type

/usr/include/mysql/mysql.h:556: note: expected ‘const char *’ but argument
is of type ‘char
(*)[10]’

db_gis.c:2233: warning: format ‘%c’ expects type ‘int’, but argument 12 has
type ‘char
*’

db_gis.c:2233: warning: format ‘%c’ expects type ‘int’, but argument 12 has
type ‘char
*’

db_gis.c:2243: warning: format not a string literal and no format
arguments

db_gis.c: In function
‘testXastirVersionMysql’:

db_gis.c:2292: warning: assignment from incompatible pointer
type

db_gis.c:2294: warning: passing argument 1 of ‘atoi’ from incompatible
pointer
type

/usr/include/stdlib.h:284: note: expected ‘const char *’ but argument is of
type
‘MYSQL_ROW’

db_gis.c:2299: warning: passing argument 1 of ‘atoi’ from incompatible
pointer
type

/usr/include/stdlib.h:284: note: expected ‘const char *’ but argument is of
type
‘MYSQL_ROW’

db_gis.c: In function
‘getAllSimplePositionsMysql’:

db_gis.c:2382: warning: passing argument 1 of ‘snprintf’ from incompatible
pointer
type

/usr/include/bits/stdio2.h:62: note: expected ‘char * __restrict__’ but
argument is of type ‘char
**’

db_gis.c:2383: warning: passing argument 1 of ‘stderr_and_statusline’ from
incompatible pointer
type

main.h:412: note: expected ‘char *’ but argument is of type ‘char
**’

db_gis.c:2387: warning: assignment from incompatible pointer
type

db_gis.c:2395: warning: passing argument 2 of ‘search_station_name’ from
incompatible pointer
type

database.h:601: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:2401: warning: passing argument 2 of ‘add_simple_station’ from
incompatible pointer
type

database.h:660: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:2401: warning: passing argument 3 of ‘add_simple_station’ from
incompatible pointer
type

database.h:660: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:2401: warning: passing argument 4 of ‘add_simple_station’ from
incompatible pointer
type

database.h:660: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:2401: warning: passing argument 5 of ‘add_simple_station’ from
incompatible pointer
type

database.h:660: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:2401: warning: passing argument 6 of ‘add_simple_station’ from
incompatible pointer
type

database.h:660: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:2401: warning: passing argument 7 of ‘add_simple_station’ from
incompatible pointer
type

database.h:660: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:2401: warning: passing argument 8 of ‘add_simple_station’ from
incompatible pointer
type

database.h:660: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:2401: warning: passing argument 9 of ‘add_simple_station’ from
incompatible pointer
type

database.h:660: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:2401: warning: passing argument 10 of ‘add_simple_station’ from
incompatible pointer
type

database.h:660: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:2401: warning: passing argument 11 of ‘add_simple_station’ from
incompatible pointer
type

database.h:660: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:2401: warning: passing argument 12 of ‘add_simple_station’ discards
qualifiers from pointer target
type
database.h:660: note: expected ‘char *’ but argument is of type ‘const char
*’

db_gis.c:2407: warning: assignment from incompatible pointer
type

db_gis.c:2414: warning: passing argument 1 of ‘snprintf’ from incompatible
pointer
type

/usr/include/bits/stdio2.h:62: note: expected ‘char * __restrict__’ but
argument is of type ‘char
**’

db_gis.c:2415: warning: passing argument 1 of ‘stderr_and_statusline’ from
incompatible pointer
type

main.h:412: note: expected ‘char *’ but argument is of type ‘char
**’

make[3]: *** [db_gis.o] Error
1

make[3]: Leaving directory
`/home/w2swr/src/xastir/src'

make[2]: *** [all-recursive] Error
1

make[2]: Leaving directory
`/home/w2swr/src/xastir/src'

make[1]: *** [all-recursive] Error
1

make[1]: Leaving directory
`/home/w2swr/src/xastir'

make: *** [all] Error
2

w2swr at w2swr-desktop:~/src/xastir$ sudo make
install

[sudo] password for
w2swr:

Making install in
src

make[1]: Entering directory
`/home/w2swr/src/xastir/src'

Making install in
rtree

make[2]: Entering directory
`/home/w2swr/src/xastir/src/rtree'

make[3]: Entering directory
`/home/w2swr/src/xastir/src/rtree'

make[3]: Nothing to be done for
`install-exec-am'.

make[3]: Nothing to be done for
`install-data-am'.

make[3]: Leaving directory
`/home/w2swr/src/xastir/src/rtree'

make[2]: Leaving directory
`/home/w2swr/src/xastir/src/rtree'

make[2]: Entering directory
`/home/w2swr/src/xastir/src'

gcc -DHAVE_CONFIG_H -I. -I..   -I/usr/local/include -I/usr/include/mysql
-DBIG_JOINS=1 -fno-strict-aliasing -DUNIV_LINUX -I/usr/include/ImageMagick
-DXASTIR_DATA_BASE=\"/usr/local/share/xastir\"  -g -O2 -pipe -W -Wall
-Wpointer-arith -Wstrict-prototypes -Wno-unused-parameter -pthread -MT
db_gis.o -MD -MP -MF .deps/db_gis.Tpo -c -o db_gis.o db_gis.c
db_gis.c: In function
‘initConnections’:

db_gis.c:581: error: ‘Connection’ has no member named
‘phandle’

db_gis.c: In function
‘openConnection’:

db_gis.c:619: error: ‘DB_POSTGIS’ undeclared (first use in this
function)

db_gis.c:619: error: (Each undeclared identifier is reported only
once

db_gis.c:619: error: for each function it appears
in.)

db_gis.c:605: warning: unused variable
‘c’

db_gis.c:603: warning: unused variable
‘start_time’

db_gis.c:600: warning: unused variable
‘connected’

db_gis.c:599: warning: unused variable
‘connection_string’

db_gis.c: In function
‘pingConnection’:

db_gis.c:875: error: ‘ConnStatusType’ undeclared (first use in this
function)

db_gis.c:875: error: expected ‘;’ before
‘psql_status’

db_gis.c: In function
‘testConnection’:

db_gis.c:956: error: ‘ConnStatusType’ undeclared (first use in this
function)

db_gis.c:956: error: expected ‘;’ before
‘psql_status’

db_gis.c:957: error: ‘PGresult’ undeclared (first use in this
function)

db_gis.c:957: error: ‘result’ undeclared (first use in this
function)

db_gis.c:961: warning: passing argument 1 of ‘snprintf’ from incompatible
pointer
type

/usr/include/bits/stdio2.h:62: note: expected ‘char * __restrict__’ but
argument is of type ‘char
**’

db_gis.c:1025: warning: passing argument 1 of ‘snprintf’ from incompatible
pointer
type

/usr/include/bits/stdio2.h:62: note: expected ‘char * __restrict__’ but
argument is of type ‘char
**’

db_gis.c:1053: warning: passing argument 1 of ‘snprintf’ from incompatible
pointer
type

/usr/include/bits/stdio2.h:62: note: expected ‘char * __restrict__’ but
argument is of type ‘char
**’

db_gis.c:1058: warning: passing argument 1 of ‘snprintf’ from incompatible
pointer
type

/usr/include/bits/stdio2.h:62: note: expected ‘char * __restrict__’ but
argument is of type ‘char
**’

db_gis.c:1097: warning: format ‘%s’ expects type ‘char *’, but argument 4
has type ‘char
**’

db_gis.c:1097: warning: format ‘%s’ expects type ‘char *’, but argument 4
has type ‘char
**’

db_gis.c:958: warning: unused variable
‘postgis_sql’

db_gis.c: In function
‘storeStationToGisDbMysql’:

db_gis.c:1592: warning: unused variable
‘mysqlreturn’

db_gis.c: In function
‘storeCadToGisDbMysql’:

db_gis.c:1625: warning: unused variable
‘mysqlreturn’

db_gis.c: In function
‘storeStationSimplePointToGisDbMysql’:

db_gis.c:1703: warning: passing argument 1 of ‘mysql_stmt_init’ from
incompatible pointer
type

/usr/include/mysql/mysql.h:785: note: expected ‘struct MYSQL *’ but argument
is of type ‘struct MYSQL
**’

db_gis.c:1721: warning: assignment from incompatible pointer
type

db_gis.c:1732: warning: assignment from incompatible pointer
type

db_gis.c:1738: warning: assignment from incompatible pointer
type

db_gis.c:1744: warning: assignment from incompatible pointer
type

db_gis.c:1750: warning: assignment from incompatible pointer
type

db_gis.c:1756: warning: assignment from incompatible pointer
type

db_gis.c:1762: warning: assignment from incompatible pointer
type

db_gis.c:1768: warning: assignment from incompatible pointer
type

db_gis.c:1777: warning: format not a string literal and no format
arguments

db_gis.c:1807: warning: comparison between pointer and
integer

db_gis.c:1814: warning: comparison between pointer and
integer

db_gis.c:1821: warning: comparison between pointer and
integer

db_gis.c:1836: warning: comparison between pointer and
integer

db_gis.c:1866: warning: format ‘%d’ expects type ‘int’, but argument 4 has
type ‘long
int’

db_gis.c:1866: warning: format ‘%d’ expects type ‘int’, but argument 5 has
type ‘long
int’

db_gis.c:1866: warning: format ‘%d’ expects type ‘int’, but argument 4 has
type ‘long
int’

db_gis.c:1866: warning: format ‘%d’ expects type ‘int’, but argument 5 has
type ‘long
int’

db_gis.c: In function
‘getAllSimplePositionsMysqlSpatial’:

db_gis.c:1918: warning: passing argument 1 of ‘snprintf’ from incompatible
pointer
type

/usr/include/bits/stdio2.h:62: note: expected ‘char * __restrict__’ but
argument is of type ‘char
**’

db_gis.c:1919: warning: passing argument 1 of ‘stderr_and_statusline’ from
incompatible pointer
type

main.h:412: note: expected ‘char *’ but argument is of type ‘char
**’

db_gis.c:1923: warning: assignment from incompatible pointer
type

db_gis.c:1936: warning: passing argument 1 of ‘strlen’ from incompatible
pointer
type

/usr/include/string.h:397: note: expected ‘const char *’ but argument is of
type
‘MYSQL_ROW’

db_gis.c:1936: warning: passing argument 2 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1936: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1936: warning: passing argument 2 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1936: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1936: warning: passing argument 1 of ‘strlen’ from incompatible
pointer
type

/usr/include/string.h:397: note: expected ‘const char *’ but argument is of
type
‘MYSQL_ROW’

db_gis.c:1936: warning: passing argument 2 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1936: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1936: warning: passing argument 2 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1936: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1940: warning: passing argument 2 of ‘search_station_name’ from
incompatible pointer
type

database.h:601: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1947: warning: passing argument 3 of ‘snprintf’ from incompatible
pointer
type

/usr/include/bits/stdio2.h:62: note: expected ‘const char * __restrict__’
but argument is of type
‘MYSQL_ROW’

db_gis.c:1947: warning: format not a string literal and no format
arguments

db_gis.c:1947: warning: format not a string literal and no format
arguments

db_gis.c:1956: warning: passing argument 1 of ‘strlen’ from incompatible
pointer
type

/usr/include/string.h:397: note: expected ‘const char *’ but argument is of
type
‘MYSQL_ROW’

db_gis.c:1956: warning: passing argument 1 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1956: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1956: warning: passing argument 1 of ‘strlen’ from incompatible
pointer
type

/usr/include/string.h:397: note: expected ‘const char *’ but argument is of
type
‘MYSQL_ROW’

db_gis.c:1956: warning: passing argument 1 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1956: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1956: warning: passing argument 1 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1956: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1956: warning: passing argument 1 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1956: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1956: warning: passing argument 1 of ‘strlen’ from incompatible
pointer
type

/usr/include/string.h:397: note: expected ‘const char *’ but argument is of
type
‘MYSQL_ROW’

db_gis.c:1956: warning: passing argument 1 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1956: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1956: warning: passing argument 1 of ‘strlen’ from incompatible
pointer
type

/usr/include/string.h:397: note: expected ‘const char *’ but argument is of
type
‘MYSQL_ROW’

db_gis.c:1956: warning: passing argument 1 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1956: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1956: warning: passing argument 1 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1956: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1956: warning: passing argument 1 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1956: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1956: warning: suggest parentheses around comparison in operand of
‘&’

db_gis.c:1959: warning: passing argument 1 of ‘strlen’ from incompatible
pointer
type

/usr/include/string.h:397: note: expected ‘const char *’ but argument is of
type
‘MYSQL_ROW’

db_gis.c:1959: warning: passing argument 1 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1959: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1959: warning: passing argument 1 of ‘strlen’ from incompatible
pointer
type

/usr/include/string.h:397: note: expected ‘const char *’ but argument is of
type
‘MYSQL_ROW’

db_gis.c:1959: warning: passing argument 1 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1959: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1959: warning: passing argument 1 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1959: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1959: warning: passing argument 1 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1959: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1959: warning: passing argument 1 of ‘strlen’ from incompatible
pointer
type

/usr/include/string.h:397: note: expected ‘const char *’ but argument is of
type
‘MYSQL_ROW’

db_gis.c:1959: warning: passing argument 1 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1959: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1959: warning: passing argument 1 of ‘strlen’ from incompatible
pointer
type

/usr/include/string.h:397: note: expected ‘const char *’ but argument is of
type
‘MYSQL_ROW’

db_gis.c:1959: warning: passing argument 1 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1959: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1959: warning: passing argument 1 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1959: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1959: warning: passing argument 1 of ‘__builtin_strcmp’ from
incompatible pointer
type

db_gis.c:1959: note: expected ‘const char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1959: warning: suggest parentheses around comparison in operand of
‘&’

db_gis.c:1966: warning: passing argument 2 of ‘search_station_name’ from
incompatible pointer
type

database.h:601: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1972: warning: passing argument 1 of ‘xastirWKTPointToLatitude’
from incompatible pointer
type

db_gis.h:29: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1973: warning: passing argument 1 of ‘xastirWKTPointToLongitude’
from incompatible pointer
type

db_gis.h:30: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1974: warning: passing argument 1 of ‘strlen’ from incompatible
pointer
type

/usr/include/string.h:397: note: expected ‘const char *’ but argument is of
type
‘MYSQL_ROW’

db_gis.c:1975: warning: passing argument 1 of ‘strptime’ from incompatible
pointer
type

/usr/include/time.h:207: note: expected ‘const char * __restrict__’ but
argument is of type
‘MYSQL_ROW’

db_gis.c:1995: warning: passing argument 1 of ‘xastirWKTPointToLatitude’
from incompatible pointer
type

db_gis.h:29: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1996: warning: passing argument 1 of ‘xastirWKTPointToLongitude’
from incompatible pointer
type

db_gis.h:30: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1997: warning: passing argument 1 of ‘snprintf’ from incompatible
pointer
type

/usr/include/bits/stdio2.h:62: note: expected ‘char * __restrict__’ but
argument is of type ‘char
**’

db_gis.c:1998: warning: passing argument 1 of ‘snprintf’ from incompatible
pointer
type

/usr/include/bits/stdio2.h:62: note: expected ‘char * __restrict__’ but
argument is of type ‘char
**’

db_gis.c:1999: warning: passing argument 2 of ‘add_simple_station’ from
incompatible pointer
type

database.h:660: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1999: warning: passing argument 3 of ‘add_simple_station’ from
incompatible pointer
type

database.h:660: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1999: warning: passing argument 4 of ‘add_simple_station’ from
incompatible pointer
type

database.h:660: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1999: warning: passing argument 5 of ‘add_simple_station’ from
incompatible pointer
type

database.h:660: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1999: warning: passing argument 6 of ‘add_simple_station’ from
incompatible pointer
type

database.h:660: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1999: warning: passing argument 7 of ‘add_simple_station’ from
incompatible pointer
type

database.h:660: note: expected ‘char *’ but argument is of type ‘char
**’

db_gis.c:1999: warning: passing argument 8 of ‘add_simple_station’ from
incompatible pointer
type

database.h:660: note: expected ‘char *’ but argument is of type ‘char
**’

db_gis.c:1999: warning: passing argument 9 of ‘add_simple_station’ from
incompatible pointer
type

database.h:660: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1999: warning: passing argument 10 of ‘add_simple_station’ from
incompatible pointer
type

database.h:660: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1999: warning: passing argument 11 of ‘add_simple_station’ from
incompatible pointer
type

database.h:660: note: expected ‘char *’ but argument is of type
‘MYSQL_ROW’

db_gis.c:1999: warning: passing argument 12 of ‘add_simple_station’ discards
qualifiers from pointer target
type
database.h:660: note: expected ‘char *’ but argument is of type ‘const char
*’

db_gis.c:2005: warning: assignment from incompatible pointer
type

db_gis.c:2012: warning: passing argument 1 of ‘snprintf’ from incompatible
pointer
type

/usr/include/bits/stdio2.h:62: note: expected ‘char * __restrict__’ but
argument is of type ‘char
**’

db_gis.c:2013: warning: passing argument 1 of ‘stderr_and_statusline’ from
incompatible pointer
type

main.h:412: note: expected ‘char *’ but argument is of type ‘char
**’

db_gis.c:1892: warning: unused variable
‘mysqlreturn’

db_gis.c: In function
‘getAllCadFromGisDbMysql’:

db_gis.c:2031: warning: unused variable
‘conn’

db_gis.c:2030: warning: unused variable
‘mysqlreturn’

db_gis.c: In function
‘getAllSimplePositionsMysqlSpatialInBoundingBox’:

db_gis.c:2043: warning: unused variable
‘conn’

db_gis.c:2042: warning: unused variable
‘mysqlreturn’

db_gis.c: In function
‘storeStationSimplePointToDbMysql’:

db_gis.c:2191: warning: comparison between pointer and
integer

db_gis.c:2195: warning: passing argument 2 of ‘mysql_real_escape_string’
from incompatible pointer
type

/usr/include/mysql/mysql.h:556: note: expected ‘char *’ but argument is of
type ‘char
(*)[3]’

db_gis.c:2197: warning: comparison between pointer and
integer

db_gis.c:2201: warning: passing argument 2 of ‘mysql_real_escape_string’
from incompatible pointer
type

/usr/include/mysql/mysql.h:556: note: expected ‘char *’ but argument is of
type ‘char
(*)[3]’

db_gis.c:2203: warning: comparison between pointer and
integer

db_gis.c:2207: warning: passing argument 2 of ‘mysql_real_escape_string’
from incompatible pointer
type

/usr/include/mysql/mysql.h:556: note: expected ‘char *’ but argument is of
type ‘char
(*)[3]’

db_gis.c:2213: warning: passing argument 2 of ‘mysql_real_escape_string’
from incompatible pointer
type

/usr/include/mysql/mysql.h:556: note: expected ‘char *’ but argument is of
type ‘char
(*)[19]’

db_gis.c:2213: warning: passing argument 3 of ‘mysql_real_escape_string’
from incompatible pointer type
/usr/include/mysql/mysql.h:556: note: expected ‘const char *’ but argument
is of type ‘char (*)[10]’
db_gis.c:2215: warning: comparison between pointer and integer
db_gis.c:2218: warning: passing argument 1 of ‘strlen’ makes pointer from
integer without a cast
/usr/include/string.h:397: note: expected ‘const char *’ but argument is of
type ‘char’
db_gis.c:2218: warning: passing argument 2 of ‘mysql_real_escape_string’
from incompatible pointer type
/usr/include/mysql/mysql.h:556: note: expected ‘char *’ but argument is of
type ‘char (*)[3]’
db_gis.c:2222: warning: passing argument 2 of ‘mysql_real_escape_string’
from incompatible pointer type
/usr/include/mysql/mysql.h:556: note: expected ‘char *’ but argument is of
type ‘char (*)[19]’
db_gis.c:2222: warning: passing argument 3 of ‘mysql_real_escape_string’
from incompatible pointer type
/usr/include/mysql/mysql.h:556: note: expected ‘const char *’ but argument
is of type ‘char (*)[10]’
db_gis.c:2233: warning: format ‘%c’ expects type ‘int’, but argument 12 has
type ‘char *’
db_gis.c:2233: warning: format ‘%c’ expects type ‘int’, but argument 12 has
type ‘char *’
db_gis.c:2243: warning: format not a string literal and no format arguments
db_gis.c: In function ‘testXastirVersionMysql’:
db_gis.c:2292: warning: assignment from incompatible pointer type
db_gis.c:2294: warning: passing argument 1 of ‘atoi’ from incompatible
pointer type
/usr/include/stdlib.h:284: note: expected ‘const char *’ but argument is of
type ‘MYSQL_ROW’
db_gis.c:2299: warning: passing argument 1 of ‘atoi’ from incompatible
pointer type
/usr/include/stdlib.h:284: note: expected ‘const char *’ but argument is of
type ‘MYSQL_ROW’
db_gis.c: In function ‘getAllSimplePositionsMysql’:
db_gis.c:2382: warning: passing argument 1 of ‘snprintf’ from incompatible
pointer type
/usr/include/bits/stdio2.h:62: note: expected ‘char * __restrict__’ but
argument is of type ‘char **’
db_gis.c:2383: warning: passing argument 1 of ‘stderr_and_statusline’ from
incompatible pointer type
main.h:412: note: expected ‘char *’ but argument is of type ‘char **’
db_gis.c:2387: warning: assignment from incompatible pointer type
db_gis.c:2395: warning: passing argument 2 of ‘search_station_name’ from
incompatible pointer type
database.h:601: note: expected ‘char *’ but argument is of type ‘MYSQL_ROW’
db_gis.c:2401: warning: passing argument 2 of ‘add_simple_station’ from
incompatible pointer type
database.h:660: note: expected ‘char *’ but argument is of type ‘MYSQL_ROW’
db_gis.c:2401: warning: passing argument 3 of ‘add_simple_station’ from
incompatible pointer type
database.h:660: note: expected ‘char *’ but argument is of type ‘MYSQL_ROW’
db_gis.c:2401: warning: passing argument 4 of ‘add_simple_station’ from
incompatible pointer type
database.h:660: note: expected ‘char *’ but argument is of type ‘MYSQL_ROW’
db_gis.c:2401: warning: passing argument 5 of ‘add_simple_station’ from
incompatible pointer type
database.h:660: note: expected ‘char *’ but argument is of type ‘MYSQL_ROW’
db_gis.c:2401: warning: passing argument 6 of ‘add_simple_station’ from
incompatible pointer type
database.h:660: note: expected ‘char *’ but argument is of type ‘MYSQL_ROW’
db_gis.c:2401: warning: passing argument 7 of ‘add_simple_station’ from
incompatible pointer type
database.h:660: note: expected ‘char *’ but argument is of type ‘MYSQL_ROW’
db_gis.c:2401: warning: passing argument 8 of ‘add_simple_station’ from
incompatible pointer type
database.h:660: note: expected ‘char *’ but argument is of type ‘MYSQL_ROW’
db_gis.c:2401: warning: passing argument 9 of ‘add_simple_station’ from
incompatible pointer type
database.h:660: note: expected ‘char *’ but argument is of type ‘MYSQL_ROW’
db_gis.c:2401: warning: passing argument 10 of ‘add_simple_station’ from
incompatible pointer type
database.h:660: note: expected ‘char *’ but argument is of type ‘MYSQL_ROW’
db_gis.c:2401: warning: passing argument 11 of ‘add_simple_station’ from
incompatible pointer type
database.h:660: note: expected ‘char *’ but argument is of type ‘MYSQL_ROW’
db_gis.c:2401: warning: passing argument 12 of ‘add_simple_station’ discards
qualifiers from pointer target type
database.h:660: note: expected ‘char *’ but argument is of type ‘const char
*’
db_gis.c:2407: warning: assignment from incompatible pointer type
db_gis.c:2414: warning: passing argument 1 of ‘snprintf’ from incompatible
pointer type
/usr/include/bits/stdio2.h:62: note: expected ‘char * __restrict__’ but
argument is of type ‘char **’
db_gis.c:2415: warning: passing argument 1 of ‘stderr_and_statusline’ from
incompatible pointer type
main.h:412: note: expected ‘char *’ but argument is of type ‘char **’
make[2]: *** [db_gis.o] Error 1
make[2]: Leaving directory `/home/w2swr/src/xastir/src'
make[1]: *** [install-recursive] Error 1
make[1]: Leaving directory `/home/w2swr/src/xastir/src'
make: *** [install-recursive] Error 1


On Sun, Jan 24, 2010 at 2:06 AM, Alex Carver <kf4lvz at yahoo.com> wrote:

> You may have used the --with-mysql compiler directive but it may not have
> compiled support into Xastir if the MySQL development headers and libraries
> are not installed on the system.  You would have to install the MySQL
> package as well as the MySQL development package (something like mysql-dev,
> I don't know what Kubuntu calls it).
>
> --- On Sun, 1/24/10, Mike L <w2swrster at gmail.com> wrote:
>
> > From: Mike L <w2swrster at gmail.com>
> > Subject: Re: [Xastir] Xastir => Mysql
> > To: "Xastir - APRS client software discussion" <xastir at lists.xastir.org>
> > Date: Sunday, January 24, 2010, 12:01 AM
> > Yes I recompiled it with that phrase.
> > I am using a version of
> > xastir(1.9.7)/Kubuntu(9.10) from a disk image. So xastir
> > was basically
> > installed with the os.
> > MIke
> > --
> >
> > On Sat, Jan 23, 2010 at 11:55 PM, Alex Carver <kf4lvz at yahoo.com>
> > wrote:
> >
> > > In the wiki it does say to edit the db_gis_mysql.sql
> > file but it doesn't
> > > mention more than adding an SQL interface.  I
> > would hazard a guess that if
> > > your copy of Xastir has not been compiled using the
> > --with-mysql flag then
> > > it won't show that interface.  Double check that
> > your copy was compiled with
> > > MySQL support.
> > >
> > > --- On Sat, 1/23/10, Mike L <w2swrster at gmail.com>
> > wrote:
> > >
> > > > From: Mike L <w2swrster at gmail.com>
> > > > Subject: Re: [Xastir] Xastir => Mysql
> > > > To: "Xastir - APRS client software discussion"
> > <xastir at lists.xastir.org>
> > > > Date: Saturday, January 23, 2010, 11:51 PM
> > > > ok I guess its the "Networked
> > > > Database (Not Implemented Yet)". I saw that
> > > > and thought it might be, but the settings don't
> > include the
> > > > user, only
> > > > host,port and pass.
> > > > Mike
> > > >
> > > > --
> > > >
> > > > On Sat, Jan 23, 2010 at 11:37 PM, Alex Carver
> > <kf4lvz at yahoo.com>
> > > > wrote:
> > > >
> > > > > I haven't looked at the latest version of
> > Xastir yet
> > > > but it should be
> > > > > present in the interface configuration
> > window when you
> > > > create the MySQL
> > > > > interface.  If it's not there then it
> > would
> > > > likely show up in the xastir.cnf
> > > > > file
> > > > >
> > > > > --- On Sat, 1/23/10, Mike L <w2swrster at gmail.com>
> > > > wrote:
> > > > >
> > > > > > From: Mike L <w2swrster at gmail.com>
> > > > > > Subject: Re: [Xastir] Xastir =>
> > Mysql
> > > > > > To: "Xastir - APRS client software
> > discussion"
> > > > <xastir at lists.xastir.org>
> > > > > > Date: Saturday, January 23, 2010, 11:14
> > PM
> > > > > > Hi Alex,
> > > > > > Tnx for the reply. I have a user and
> > pass setup
> > > > in MySQL
> > > > > > but where do I set
> > > > > > those parameters up in xastir?
> > > > > > Mike
> > > > > > --
> > > > > >
> > > > > > On Sat, Jan 23, 2010 at 8:15 PM, Alex
> > Carver
> > > > <kf4lvz at yahoo.com>
> > > > > > wrote:
> > > > > >
> > > > > > > The username and password it talks
> > about is
> > > > the one
> > > > > > you add to MySQL.  You
> > > > > > > need to put in a user that Xastir
> > will use
> > > > when
> > > > > > connecting to the MySQL
> > > > > > > server and give it the
> > appropriate
> > > > permissions as
> > > > > > dictated by the "user"
> > > > > > > table in the "mysql"
> > database.  By
> > > > default MySQL
> > > > > > sets up "root" as a user.
> > > > > > >  You can use that account to
> > test
> > > > things out
> > > > > > first and then later make a
> > > > > > > separate user for Xastir.  In
> > general
> > > > it's a good
> > > > > > idea (especially when
> > > > > > > using PHP and MySQL) to create
> > users that
> > > > have limited
> > > > > > database access
> > > > > > > instead of the root superuser just
> > as it is
> > > > with Linux
> > > > > > machines and user
> > > > > > > accounts versus root.
> > > > > > >
> > > > > > > --- On Sat, 1/23/10, Mike <w2swrster at gmail.com>
> > > > > > wrote:
> > > > > > >
> > > > > > > > From: Mike <w2swrster at gmail.com>
> > > > > > > > Subject: [Xastir] Xastir
> > => Mysql
> > > > > > > > To: Xastir at lists.xastir.org
> > > > > > > > Date: Saturday, January 23,
> > 2010, 6:03
> > > > PM
> > > > > > > > Hi All,
> > > > > > > >
> > > > > > > > I am knee deep in trying to
> > get data
> > > > collected
> > > > > > from Xastir
> > > > > > > > to MySQL. I have MySQL 5.1.37
> > and PHP
> > > > 5.2.10
> > > > > > installed with
> > > > > > > > Xastir 1.9.7.  I have
> > followed the
> > > > MySQL
> > > > > > Persistence
> > > > > > > > directions [http://www.xastir.org/wiki/index.php/Persistence
> ]
> > > > > > > > closely with the execption of
> > using the
> > > > included
> > > > > > sql dump
> > > > > > > > (db_gis_postgis.sql) which
> > has a lot of
> > > > syntax
> > > > > > errors no
> > > > > > > > matter  which SQL
> > compatibility
> > > > mode I use.
> > > > > > So I
> > > > > > > > built the databases and
> > tables manually
> > > > using the
> > > > > > SQL dump
> > > > > > > > as a road map. With that
> > said, I can
> > > > only say
> > > > > > that I am 90%
> > > > > > > > sure I did them all
> > correctly. What I
> > > > havn't done
> > > > > > so far is
> > > > > > > > (and I quote): "Run xastir
> > and add a
> > > > SQL Database
> > > > > > interface,
> > > > > > > > start with the MySQL
> > defaults, add the
> > > > username
> > > > > > and password
> > > > > > > > of the xastir user." This I
> > am not too
> > > > sure what
> > > > > > Im being
> > > > > > > > told to do here. I am a newbe
> > to PHP
> > > > and MySQL
> > > > > > ive only used
> > > > > > > > them for some small web
> > related stuff
> > > > as a user
> > > > > > and never on
> > > > > > > > a dev end of it, but I have
> > my nose
> > > > deep into PHP
> > > > > > &
> > > > > > > > MySQL for Dummies and I am
> > slowly
> > > > learning.
> > > > > > > >
> > > > > > > > If anyone can help, I would
> > deeply
> > > > appreciate
> > > > > > it.
> > > > > > > >
> > > > > > > > Mike, W2SWR
> > > > > > > >
> > > > > > > > P.S. if it helps, I use
> > phpMyAdmin to
> > > > drive
> > > > > > MySQL
> > > > > > > >
> > > > _______________________________________________
> > > > > > > > Xastir mailing list
> > > > > > > > Xastir at lists.xastir.org
> > > > > > > > http://lists.xastir.org/cgi-bin/mailman/listinfo/xastir
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > _______________________________________________
> > > > > > > Xastir mailing list
> > > > > > > Xastir at lists.xastir.org
> > > > > > > http://lists.xastir.org/cgi-bin/mailman/listinfo/xastir
> > > > > > >
> > > > > >
> > _______________________________________________
> > > > > > Xastir mailing list
> > > > > > Xastir at lists.xastir.org
> > > > > > http://lists.xastir.org/cgi-bin/mailman/listinfo/xastir
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > _______________________________________________
> > > > > Xastir mailing list
> > > > > Xastir at lists.xastir.org
> > > > > http://lists.xastir.org/cgi-bin/mailman/listinfo/xastir
> > > > >
> > > > _______________________________________________
> > > > Xastir mailing list
> > > > Xastir at lists.xastir.org
> > > > http://lists.xastir.org/cgi-bin/mailman/listinfo/xastir
> > > >
> > >
> > >
> > >
> > > _______________________________________________
> > > Xastir mailing list
> > > Xastir at lists.xastir.org
> > > http://lists.xastir.org/cgi-bin/mailman/listinfo/xastir
> > >
> > _______________________________________________
> > Xastir mailing list
> > Xastir at lists.xastir.org
> > http://lists.xastir.org/cgi-bin/mailman/listinfo/xastir
> >
>
>
>
> _______________________________________________
> Xastir mailing list
> Xastir at lists.xastir.org
> http://lists.xastir.org/cgi-bin/mailman/listinfo/xastir
>