PostgreSQL [#560586]

Is it the actual database that Drupal uses that needs to be PostgreSQL Postgis enabled to use the geodata plugin, or can you use a MySQL database for Drupal and link to a spatial database with the GeoData module? Its not clear! I have a spatially enabled PostgreSQL db, but the geodata module does not seem to like my connection string.

Thanks.

Comments

Comment #1

jpulles CreditAttribution: jpulles commented 27 August 2009 at 19:05

You can't use a MySQL database for Drupal together with a PostgreSQL database; the database abstraction layer can't handle this.

In case you use PostgreSQL, the drupal database does not need to be PostGIS enabled. You can specify additional databases (PostGIS enabled) in your settings.php or the geodata admin page.

Comment #2

tsfftf CreditAttribution: tsfftf commented 28 August 2009 at 21:19

right, cheers jp. after a while i've managed to get this module do what I want; overlay gpx files onto osm. that's all i want it to do at the moment. turns out (for anyone else trying to do this) that the permissions are critical, as with most things. that's what was stopping it from displaying. I was also trying to refer to a file above the web root (using ../) i'm not sure whether the syntax supports this. maybe some light can be shed on that? thanks for the response.

Comment #3

tsfftf CreditAttribution: tsfftf commented 28 August 2009 at 21:26

does the star.png graphic only display once every x miles? is there a way of controlling this? on my gpx overlay that I recorded, I only see the green slash line, no star.png, however the distance is not more than 1.2m. please advise.

Comment #4

jpulles CreditAttribution: jpulles commented 31 August 2009 at 14:29

Status:

Active

» Fixed

I'll change this one to fixed then, since your star.png question is different.
The graphic can be displayed at many locations. You could check with firebug which path to star.png is used by your page. Does the star.png file exist on your system, do you use a valid path? Is your page reachable by web? Which [map /] definition do you use for your map?

Comment #5

tsfftf CreditAttribution: tsfftf commented 2 September 2009 at 21:29

yeah - i've got it overlaying stuff to a degree! here is my context:

[map context="node/295/context" layers="a" a="gpx|sites/default/files/tracks.gpx|Work|sites/default/files/star.png|style={strokeColor:#00ff00,strokeWidth:5,strokeOpacity:0.4,strokeDashstyle:dash}" /]

Strangely when I have the example from your site in my map, it shows the star.png, but when I use that as part of the syntax for layer a it does not show up. Unfortunately my map is not accessible over the web sorry. The track is marked, but only by a green dotted line (as expected by the style argument). Hmm...