[postgis-users] "make check" failures w/ 1.3.1 on Mac OS 10.5

[William Kyngesburye]

Possibly a permissions problem?  I just ran the tests on my new  
Leopard build, using GEOS 3, and got 36/37 fails.

Look in that /var/folders/... loader.err.  I got:

BEGIN
psql:/var/folders/sR/[snip]/-Tmp-/loader:2: NOTICE:  CREATE TABLE will  
create implicit sequence "loadedshp_gid_seq" for serial column  
"loadedshp.gid"
psql:/var/folders/sR/[snip]/-Tmp-/loader:2: NOTICE:  CREATE TABLE /  
PRIMARY KEY will create implicit index "loadedshp_pkey" for table  
"loadedshp"
CREATE TABLE
psql:/var/folders/sR/[snip]/-Tmp-/loader:3: ERROR:  permission denied  
for relation geometry_columns
CONTEXT:  SQL statement "DELETE FROM geometry_columns WHERE
		f_table_catalog = '' AND f_table_schema = 'public' AND f_table_name  
= 'loadedshp' AND f_geometry_column = 'the_geom'"
PL/pgSQL function "addgeometrycolumn" line 94 at execute statement
SQL statement "SELECT AddGeometryColumn('', $1 , $2 , $3 , $4 , $5 ,  
$6 )"
PL/pgSQL function "addgeometrycolumn" line 4 at SQL statement

Even though I made my user role the owner of the postgis_reg database,  
the lwpostgis.sql must be run as th postgres role, and it gets  
ownership of the geometry_columns table.  And one big annoyance I've  
had with postgres is that it doesn't inherit privileges like you'd  
think.

After setting up the postgis_reg DB for postgis, grant yourself all  
privileges on the geometry_columns table.  After doing this, I now get  
32/37 fails - still a lot, but it's a start.


On Nov 25, 2007, at 1:22 PM, John Cartwright wrote:

> Hello All,
>
> Trying to compile v1.3.1 on leopard.  Compilation seems to go OK,  
> but 35 out of 37 tests fail on the "make check" prior to  
> installation.  For example:
>
> loader/Point. failed (running shp2pgsql: /var/folders/v1/ 
> v1z9PHeJEvGQIvBCSUU0QE+++TI/-Tmp-//loader.err)
>
> loader.err contains:
> ../loader/shp2pgsql: shape (.shp) or index files (.shx) can not be  
> opened.
>
> The configuration summary is listed below.  Any ideas on what I'm  
> doing wrong here?
>
> Thanks!
>
> --john
>
>
> Config Summary:
> HOST_OS: darwin9.1.0
>
>   PGSQL: /usr/local/pgsql/bin/pg_config
>    GEOS: /usr/local/geos-2.2.3/bin/geos-config (with C-API)
>          (ldflags: -L/usr/local/geos-2.2.3/lib)
>    PROJ: prefix=/usr/local/proj-4.5.0 libdir=/usr/local/proj-4.5.0/lib
>   ICONV: 1 -liconv
>
> PORTNAME: darwin
>   PREFIX: /usr/local/postgis-1.3.1
>  EPREFIX: ${prefix}
>      DOC: ${prefix}/share/doc
>     DATA: ${datarootdir}
>      MAN: ${datarootdir}/man
>      BIN: ${exec_prefix}/bin
>      EXT: ${exec_prefix}/lib (${exec_prefix}/lib)
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-----
William Kyngesburye <kyngchaos*at*kyngchaos*dot*com>
http://www.kyngchaos.com/

"We are at war with them. Neither in hatred nor revenge and with no  
particular pleasure I shall kill every ___ I can until the war is  
over. That is my duty."

"Don't you even hate 'em?"

"What good would it do if I did? If all the many millions of people of  
the allied nations devoted an entire year exclusively to hating the  
____ it wouldn't kill one ___ nor shorten the war one day."

<Ha, ha> "And it might give 'em all stomach ulcers."

- Tarzan, on war