[ gpsdrive ] Problem with create.sql script??

[Deric Stowell]

Hello, everyone

i am trying to set up gpsdrive to use the mysql database but i keep getting thios errors:

<snip>

deric at barney:~$ gpsdrive &
[1] 13606
deric at barney:~$ Gtk-Message: Failed to load module "atk-bridge": libatk-bridge.so: cannot open shared object file: No such file or directory
SQL: connected to localhost as gast using geoinfo
Creating main window
Using Mapnik config-file: /usr/share/gpsdrive/mapnik/osm.xml
cannot read shape file
cannot read shape file
cannot read shape file
cannot read shape file
cannot read shape file
cannot read shape file
cannot read shape file
cannot read shape file
cannot read shape file
cannot read shape file
connection to host=/var/run/postgresql dbname=gis user=deric password= connect_timeout=4 failed
could not connect to server: No such file or directory
	Is the server running locally and accepting
	connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

connection to host=/var/run/postgresql dbname=gis user=deric password= connect_timeout=4 failed
could not connect to server: No such file or directory
	Is the server running locally and accepting
	connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

connection to host=/var/run/postgresql dbname=gis user=deric password= connect_timeout=4 failed
could not connect to server: No such file or directory
	Is the server running locally and accepting
	connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

connection to host=/var/run/postgresql dbname=gis user=deric password= connect_timeout=4 failed
could not connect to server: No such file or directory
	Is the server running locally and accepting
	connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

connection to host=/var/run/postgresql dbname=gis user=deric password= connect_timeout=4 failed
could not connect to server: No such file or directory
	Is the server running locally and accepting
	connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

connection to host=/var/run/postgresql dbname=gis user=deric password= connect_timeout=4 failed
could not connect to server: No such file or directory
	Is the server running locally and accepting
	connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

connection to host=/var/run/postgresql dbname=gis user=deric password= connect_timeout=4 failed
could not connect to server: No such file or directory
	Is the server running locally and accepting
	connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

connection to host=/var/run/postgresql dbname=gis user=deric password= connect_timeout=4 failed
could not connect to server: No such file or directory
	Is the server running locally and accepting
	connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

connection to host=/var/run/postgresql dbname=gis user=deric password= connect_timeout=4 failed
could not connect to server: No such file or directory
	Is the server running locally and accepting
	connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

cannot read shape file
cannot read shape file
Read 503 POI-Types from /usr/share/gpsdrive/map-icons/icons.xml
poi_rebuild_list: Error in query: 
poi_rebuild_list: Error in query: Table 'geoinfo.poi_type' doesn't exist
poi_rebuild_list: Error in query: 
poi_rebuild_list: Error in query: Table 'geoinfo.poi_type' doesn't exist
poi_rebuild_list: Error in query: 
poi_rebuild_list: Error in query: Table 'geoinfo.poi_type' doesn't exist
poi_rebuild_list: Error in query: 
poi_rebuild_list: Error in query: Table 'geoinfo.poi_type' doesn't exist
poi_rebuild_list: Error in query: 
poi_rebuild_list: Error in query: Table 'geoinfo.poi_type' doesn't exist
poi_rebuild_list: Error in query: 
poi_rebuild_list: Error in query: Table 'geoinfo.poi_type' doesn't exist
poi_rebuild_list: Error in query: 
poi_rebuild_list: Error in query: Table 'geoinfo.poi_type' doesn't exist
poi_rebuild_list: Error in query: 
poi_rebuild_list: Error in query: Table 'geoinfo.poi_type' doesn't exist
poi_rebuild_list: Error in query: 
poi_rebuild_list: Error in query: Table 'geoinfo.poi_type' doesn't exist
poi_rebuild_list: Error in query: 
poi_rebuild_list: Error in query: Table 'geoinfo.poi_type' doesn't exist
poi_rebuild_list: Error in query: 
poi_rebuild_list: Error in query: Table 'geoinfo.poi_type' doesn't exist
poi_rebuild_list: Error in query: 
poi_rebuild_list: Error in query: Table 'geoinfo.poi_type' doesn't exist
poi_rebuild_list: Error in query: 
poi_rebuild_list: Error in query: Table 'geoinfo.poi_type' doesn't exist
poi_rebuild_list: Error in query: 
poi_rebuild_list: Error in query: Table 'geoinfo.poi_type' doesn't exist
map_koord.txt reloaded
ERROR BAD FORMAT in coordinate_string2gdouble(�D4�)-->-1002.000000
ERROR BAD FORMAT in coordinate_string2gdouble()-->-1002.000000
/home/deric/.gpsdrive/way.txt reloaded
poi_rebuild_list: Error in query: 
poi_rebuild_list: Error in query: Table 'geoinfo.poi_type' doesn't exist
poi_rebuild_list: Error in query: 
poi_rebuild_list: Error in query: Table 'geoinfo.poi_type' doesn't exist
poi_rebuild_list: Error in query: 
poi_rebuild_list: Error in query: Table 'geoinfo.poi_type' doesn't exist
getsqlextradata: Error in query: Table 'geoinfo.poi_extra' doesn't exist
Error while using mysql
Unknown column 'poi_type_id' in 'field list'

[1]+  Exit 3                  gpsdrive


</snip>