Opened 11 years ago

Closed 11 years ago

Last modified 11 years ago

#1060 closed enhancement (fixed)

pre-seed DB credentials for tilemill postgis

Reported by: hamish Owned by: live-demo@…
Priority: minor Milestone: OSGeoLive6.5
Component: OSGeoLive Keywords: 6.5, tilemill



it would be nice if the disc's local PostGIS dbs were already in the favorites list for the tilemill add layer window. less stuff to typo.

thanks, Hamish

Change history (7)

comment:1 by springmeyer, 11 years ago

This can be hacked in by initializing the app.db which TileMill creates on first load and will re-use afterword. It is a json file of key/values. Something like this should work, if run during the install

<pre> mkdir -p ~/Documents/MapBox/ echo '{"key":"/api/Favorite/dbname=osm","val":{"id":"dbname=osm"}}' > ~/Documents/MapBox/app.db </pre>

If you create favorites then they will get serialized to this file so you could get the right params that way....

comment:2 by hamish, 11 years ago


by the way -- tons of dead symlinks on the disc in


and similar in node_modules/. (cruft from a make clean?)


comment:3 by hamish, 11 years ago

attempt made in r9676.


comment:4 by springmeyer, 11 years ago

re: cruft, yeah there is some, known issue:

comment:5 by hamish, 11 years ago

Resolution: fixed
Status: newclosed

tested with the latest nightly iso build, the attempt seems to have worked. I only tried the natural_earth2 DB, not the osm_local and osm_local spherical merc. ones, but the nat earth one seemed to work ok.

minor glitches of note: 1) the layer name box went all white as I was typing in the box so typing blind; it would be nice to have a drop down list of postgres layers containing geometry columns to avoid the typoing. 2) had to drag the window a bit bigger to get to the save button. not much of a problem but glad I wasn't trying it on a shallow-screened netbook.

closing wish


comment:6 by hamish, 11 years ago

ps- in gpsdrive's mapnik osm.xml I replaced the 380mb OSM world coastline shapefile with the much smaller natural earth one, and it seems to work ok, albeit without the detail, but it's better than nothing.

comment:7 by springmeyer, 11 years ago

glad the presets are working.

re: the white disappearing ui bug, yes also seen this as well as others like My sense is this one is likely a webkit bug. To work around try loading up TileMill at http://localhost:20009 in firefox instead.

re: the save button problem, tracked at

Note: See TracTickets for help on using tickets.