[Xastir] Xastir => Mysql

[Tom Russo]

On Tue, Jan 26, 2010 at 12:19:54PM -0500, we recorded a bogon-computron collision of the <w2swrster at gmail.com> flavor, containing:
> Too bad... I was looking forward to pulling the data from MySQL and building
> a nice php script to display the data online much like UI-View's webserver
> module. I know nothing about postgresql, never used it. I will take some
> time in the near future to read up on postgresql and see if it is worth it.
> Thanks very much for pointing out the issue.
> 
> Hopefully Paul Morris (if he's available, or someone)  can look into the
> MySQL support issue.
> 

I see he already is.  He's fixed the compilation errors, but notes that there
are still run-time errors.  I'd watch this space for a note from him.

> On Sun, Jan 24, 2010 at 1:23 PM, Tom Russo <russo at bogodyn.org> wrote:
> 
> > On Sun, Jan 24, 2010 at 04:25:13AM -0500, we recorded a bogon-computron
> > collision of the <w2swrster at gmail.com> flavor, containing:
> > > I recompiled it again, here is the capture from bash:
> > >
> > [...]
> > >   Spatial database support ............... : yes
> > >   Spatial database Postgresql/Postgis .... : no
> > >   MySQL .................................. : yes
> > >   MySQL Spatial database support ......... : yes
> > >
> > [...]
> > >
> > > 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: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)
> >
> >
> > This appears to be an indication that the MySQL support in Xastir is
> > broken.
> >
> > I have looked over the code in db_gis.c and it is quite clear that it was
> > never really debugged for MySQL, only Postgresql.  There are numerous
> > instances
> > of Postgres data structures being used outside of HAVE_POSTGIS ifdefs, and
> > a number of references to preprocessor macros outside of HAVE_POSTGIS ifefs
> > that
> > are only defined inside HAVE_POSTGIS ifdefs.
> >
> > My suggestion is to give up on MySQL for now and use PostGIS instead.  I
> > suspect that the MySQL code has never been properly tested.  It is possible
> > that
> > the MySQL code can be patched up to remove these errors, but right now it
> > is quite clearly broken.
> >
> > Paul Morris wrote the spatial database code and the Wiki page that
> > describes
> > setting it up.  Perhaps he can comment here on whether he ever actually got
> > MySQL Spatial working.
> >
> > --
> > Tom Russo    KM5VY   SAR502   DM64ux          http://www.swcp.com/~russo/<http://www.swcp.com/%7Erusso/>
> > Tijeras, NM  QRPL#1592 K2#398  SOC#236
> > http://kevan.org/brain.cgi?DDTNM
> >  In some cultures what I do would be considered normal.
> >                                  -- Ineffective daily affirmation
> >
> > _______________________________________________
> > Xastir mailing list
> > Xastir at lists.xastir.org
> > http://lists.xastir.org/cgi-bin/mailman/listinfo/xastir
> >

-- 
Tom Russo    KM5VY   SAR502   DM64ux          http://www.swcp.com/~russo/
Tijeras, NM  QRPL#1592 K2#398  SOC#236        http://kevan.org/brain.cgi?DDTNM
  In some cultures what I do would be considered normal. 
                                  -- Ineffective daily affirmation