[Xastir] LaCrosse database program --- open2300db2APRS

[Tate - KA7O]

YES!

My Lacross station has been offlined for several months now. I would 
love to get it back up again.

Thanks!

On 11/26/2009 01:20 AM, Tom Russo wrote:
> Is anyone here besides me actually using a (lousy) LaCrosse 23xx weather
> station and the open2300db2APRS program we have bundled in the Xastir source?
>
> I just upgraded the OS on my primary system and discovered that
> open2300db2APRS started segfaulting afterwards.  Turns out there's a huge
> error in how that code accesses the mysql database, and I'm amazed it ever
> worked at all --- but it did for me for several years until tonight's upgrade.
> Specifically, the code never actually issued the mysql_fetch_row command after
> querying the database for weather data --- and then started pulling data out
> of the row datastructure, and apparently got what it was expecting.  This
> definitely doesn't work in the version of os that I updated to (MySQL 5.1.41
> on FreeBSD 7.2, previously running MySQL 5.1.41 on FreeBSD 6.4 --- all I did
> was recompile mysql on the new system, and boom, segfaults from
> open2300db2APRS).
>
> I'm pretty sure that the changes I had to make to my local copy of
> open2300db2APRS to get it to work after the upgrade would be correct even for
> older versions of mysql, and that it's likely it only worked because of a
> fluke.  My change is merely to fetch the row after the query.
>
> If anyone else is actually using this code now, lemme know.  I'll commit my
> changes and work with you to make sure they don't break your currently working
> build.  I can't imagine it will, but I figure a head's up is in order first.
>