make check RUNTESTFLAGS=--extension can't run on debbie

[robe]

strk,

I was unable to get make check runtestflags to run on debbie so had to remark it out.

Keeps on giving this error:

psql: FATAL:  role "jenkins" does not exist
Creating database 'postgis_reg' 
createdb: could not connect to database template1: FATAL:  role "jenkins" does not exist
psql: FATAL:  role "jenkins" does not exist
Preparing db 'postgis_reg' using 'CREATE EXTENSION'

I don't know why this is an issue since I have a line

export PGUSER=postgres

and the regular regress in theory would be running into the same issue.

Anyrate she pulls this script:

​http://svn.osgeo.org/postgis/buildbots/debian/scripts/postgis_regress.sh

I remarked out the extension install piece since it wasn't working.

Fill free to change it and then she should run it on next postgis regress run.

[strk]

The script exports PGUSER too late, only for "extension" but after it runs "make check" once before. Why not exporting it once upfront ?

(if this is not an issue anymore, please close)

PS: buildbot scripts are another good candidate to move to git …

[strk]

Robe any news here ? I'd love to get the bots to test with the EXTENSION, and even more with the —extension —upgrade (which I think I broke today)

[robe]

no not yet. Tied up thru mid-March so probably won't have time to devote to this before then.

[robe]

strk — how do I get this thing to not try to install in protected areas?

Get this error now on debbie when I try to install

make[1]: Entering directory `/var/lib/jenkins/workspace/postgis/branches/2.2/liblwgeom'
/bin/bash ../libtool --mode=install /bin/bash ../install-sh liblwgeom.la "/usr/local/lib/liblwgeom.la"
libtool: install: /bin/bash ../install-sh .libs/liblwgeom-2.2.0dev.so /usr/local/lib/liblwgeom-2.2.0dev.so
cp: cannot create regular file `/usr/local/lib/_inst.27454_': Permission denied
make[1]: *** [install-liblwgeom] Error 1
make[1]: Leaving directory `/var/lib/jenkins/workspace/postgis/branches/2.2/liblwgeom'
make: *** [install] Error 1
Build step 'Execute shell' marked build as failure

[strk]

I guess it'd take properly supporting —prefix (#635) but you can try with setting the DESTDIR env variable

[strk]

Robe what about creating a "postgresql" group and adding "jenkins" user to it, then make the postgresql system directories writeable by the "postgresql" group ?

[robe]

Well the thing is that the postgresql directories are under jenkins so they are already writeable. The issue last I recall was that stuff tries to be installed in system.

/usr/local/lib

We might have fixed that issue though, cause as I recall on winnie, I think I'm using dest or something to prevent it from writing into /usr/local/lib. So perhaps that is the solution.

[strk]

That's probably liblwgeom. Did you try —prefix too ? I'm just trying to close dangling tickets

[robe]

(In [14721]) Try to fix make install issue using —prefix references #2688

[robe]

Okay that seems to have fixed it - using —prefix

[robe]

Milestone renamed