Hello Marcin,
I agree with Mats; your user has to be the owner of all these tables. As I
set up the database, I did:
* sudo -u postgres -i
* createuser osmdb # answer yes for superuser
* createdb -E UTF8 -O osmdb gis
* psql -d gis -f /opt/PostgreSQL/8.3/share/lwpostgis.sql
* * echo "ALTER TABLE geometry_columns OWNER TO osmdb; ALTER TABLE
spatial_ref_sys OWNER TO osmdb;" | psql -d gis*
* psql gis <
/opt/PostgreSQL/8.3/share/postgresql/contrib/_int.sql
I guess the step you might have been missing was the second last one, which
changes the owner of the tables to '"osmdb" in this example instead of
"postgres", who created them (step 3 and4).
Let me know if this helps!
Dom
On Mon, Mar 29, 2010 at 2:09 AM, MatsH <mapnik-users.openstreetmap.org@
mats-hecking.de> wrote:
> Hi Marcin,
>
> first thing when comparing your output of \dt to mine (I use Ubuntu 9.10
> also) was that the owner of the tables planet_osm_line, planet_osm_point
> (...) isn't postgres, but my username. I followed the steps described at
> http://weait.com/content/build-your-own-openstreetmap-server. You should
> compare those steps to what you did; maybe there's a hint on what you did
> wrong.
>
> First guess is you have some database user issue. Maybe you have to make
> sure those tables that contain the OSM data (anything else than shorelines
> that is) are owned by the correct user.
>
> Good luck,
>
> Mats
>
> On Sun, 28 Mar 2010 16:08:40 +0200, Marcin Waniek <[email protected]> wrote:
> > Hello everyone,
> >
> > I've just started using Mapnik and I've already encountered some major
> > problems.
> > I'm using Ubuntu 9.10 and during installations I generally followed
> steps
> > from OSM wiki (http://wiki.openstreetmap.org/wiki/Mapnik) .
> > Unfortunately, when I'm trying to use generate_tiles.py script, I can
> see
> > nothing but shorelines on my tiles and when zoom values are higher, I
> get
> > nothing but empty tiles.
> >
> > Troubleshooting from wiki says:
> > "If the generated tiles or image show coastlines, but lack streets,
> street
> > names, cities, and other features, please verify that the database user
> can
> > indeed login. The scripts and Mapnik may quietly fail to read the data
> and
> > thus render with coastlines, but no other data. Another cause is
> building
> > Mapnik without PostGIS support."
> > But it doesn't give any clues how to fix the problem.
> > As far as I'm concerned, I am able to login to database (through psql -d
> > gis -U marcin, where "marcin" is my user name) and when I try \dt I get:
> >
> > List of relations
> > Schema | Name | Type | Owner
> > --------+--------------------+-------+----------
> > public | geometry_columns | table | marcin
> > public | planet_osm_line | table | postgres
> > public | planet_osm_point | table | postgres
> > public | planet_osm_polygon | table | postgres
> > public | planet_osm_roads | table | postgres
> > public | spatial_ref_sys | table | marcin
> > (6 rows)
> >
> > so database isn't empty also.
> > I've already tried setting non-empty password for my user (giving it to
> > the generate_xml.py script) and modifying trust settings in pg_hba.conf,
> > but nothing helped.
> >
> > I would be grateful for any help.
> >
> > Kind regards,
> > Marcin Waniek
> > _______________________________________________
> > Mapnik-users mailing list
> > [email protected]
> > https://lists.berlios.de/mailman/listinfo/mapnik-users
> _______________________________________________
> Mapnik-users mailing list
> [email protected]
> https://lists.berlios.de/mailman/listinfo/mapnik-users
>
_______________________________________________
Mapnik-users mailing list
[email protected]
https://lists.berlios.de/mailman/listinfo/mapnik-users
