Upgrading gpsdrive - Questions about psql vs mysql

[Cord Beermann-4]

Hello,

I'm tried to move my old (2.9?) mysql-Database with > 100000 Waypoints
into the new database-schema of GPSdrive 2.10pre4 from Debian.

There is a Script which dumps the content of the old database into a
gpx-file and a perl-script called poi-manager for importing it.
Running the latter leads to a 'Segementation Fault' of perl, and no
Waypoint is inserted into the Database.

Running GPSdrive 2.10pre4 doesn't show anything about the data in the
MySQL-Database, or an indication that it tries to use the database.

So, i started to look around and found that you are now on 2.10pre7
and installed the debian-package (2.10svn2448).

(btw: your versioned dependencies are broken:
gpsdrive: gpsdrive-utils (> 2299) but 2.10svn2448 is to be installed
same applies for openstreetmap-utils)

I also want to use OSM, and in the old Debian-Package was a script
which downloaded and inserted OSM-data in the MySQL-Database.

While wading through the documentation i wondered if gpsdrive really
needs a MySQL-Database for POIs and a Postgres for OSM.

I don't want to run two databases, is it possible to have only one
database for POIs AND OSM-data to use by gpsdrive?

Which one is that and how do i have to set it up so gpsdrive
recognizes it?

Thanks,
        Cord
_______________________________________________
GPSdrive mailing list
GPSdrive@...
http://lists.gpsdrivers.org/mailman/listinfo/gpsdrive

[Guenther Meyer]

Am Samstag 18 Juli 2009 schrieb Cord Beermann:

> Hello,
>
> I'm tried to move my old (2.9?) mysql-Database with > 100000 Waypoints
> into the new database-schema of GPSdrive 2.10pre4 from Debian.
>
> There is a Script which dumps the content of the old database into a
> gpx-file and a perl-script called poi-manager for importing it.
> Running the latter leads to a 'Segementation Fault' of perl, and no
> Waypoint is inserted into the Database.
>
> Running GPSdrive 2.10pre4 doesn't show anything about the data in the
> MySQL-Database, or an indication that it tries to use the database.
>
> So, i started to look around and found that you are now on 2.10pre7
> and installed the debian-package (2.10svn2448).
>
> (btw: your versioned dependencies are broken:
> gpsdrive: gpsdrive-utils (> 2299) but 2.10svn2448 is to be installed
> same applies for openstreetmap-utils)
>
> I also want to use OSM, and in the old Debian-Package was a script
> which downloaded and inserted OSM-data in the MySQL-Database.
>
> While wading through the documentation i wondered if gpsdrive really
> needs a MySQL-Database for POIs and a Postgres for OSM.
>
> I don't want to run two databases, is it possible to have only one
> database for POIs AND OSM-data to use by gpsdrive?
>
> Which one is that and how do i have to set it up so gpsdrive
> recognizes it?
>

mysql isn't used anymore.

we have sqlite for POI data, which is part of gpsdrive.
if your gpsdrive runs, the POI database should also work.

to fill the new empty POI database with your exported data from the gpx-file
you should use poi-import.pl, but take care, there is no dupe checking.

to use osm POI data, you have to create a sqlite poi database from a planet
file with osm2poidb.


furthermore we make use of a postgis database to provide the osm data for the
mapnik map rendering. this is not really needed to run gpsdrive, but can be a
nice feature.
if you have the postgis database installed, the script mapnik-osm-updater.sh
should do all the necessary steps to do the setup.




_______________________________________________
GPSdrive mailing list
GPSdrive@...
http://lists.gpsdrivers.org/mailman/listinfo/gpsdrive

[Joerg Ostertag (Tettnang)]

On Saturday 18 July 2009, Cord Beermann wrote:
> Hello,
>
...

> So, i started to look around and found that you are now on 2.10pre7
> and installed the debian-package (2.10svn2448).
>
> (btw: your versioned dependencies are broken:
> gpsdrive: gpsdrive-utils (> 2299) but 2.10svn2448 is to be installed
> same applies for openstreetmap-utils)

The reason is that with the Version 2299 the layout of the debian-packages
changed. So any combination inbetween should be compatible.

-
Joerg

_______________________________________________
GPSdrive mailing list
GPSdrive@...
http://lists.gpsdrivers.org/mailman/listinfo/gpsdrive