subject:"Re\: \[postgis\-users\] PostGIS 2 RPM"

Re: [postgis-users] PostGIS 2 RPM

2012-10-18 Thread Bborie Park

It looks like the linker can't find libpq.  You'll want to add the
following to /etc/ld.so.conf.

/usr/pgsql-9.1/lib

-bborie

On Thu, Oct 18, 2012 at 6:09 AM, Jeff Lake  wrote:
> Is there any reasoning why EL5 does not have a postGIS2_91 RPM ??
> this is on CentOS 5.8 64bit
>
> I have tried numerous times to install from source and keep getting raster
> error
>
> configure params
>
> ./configure --with-raster --with-pgconfig=/usr/pgsql-9.1/bin/pg_config
> --with-geosconfig=/geos-3.3.5/tools/geos-config
>
>   PostGIS is now configured for x86_64-unknown-linux-gnu
>
>  -- Compiler Info -
>   C compiler:   gcc -g -O2
>   C++ compiler: g++ -g -O2
>   SQL preprocessor: /usr/bin/cpp -traditional-cpp -P
>
>  -- Dependencies --
>   GEOS config:  /geos-3.3.5/tools/geos-config
>   GEOS version: 3.3.5
>   GDAL config:  /usr/local/bin/gdal-config
>   GDAL version: 1.9.1
>   PostgreSQL config:/usr/pgsql-9.1/bin/pg_config
>   PostgreSQL version:   PostgreSQL 9.1.6
>   PROJ4 version:48
>   Libxml2 config:   /usr/bin/xml2-config
>   Libxml2 version:  2.6.26
>   JSON-C support:   no
>   PostGIS debug level:  0
>   Perl: /usr/bin/perl
>
>  --- Extensions ---
>   PostGIS Raster:   enabled
>   PostGIS Topology: enabled
>
>   Documentation Generation 
>   xsltproc: /usr/bin/xsltproc
>   xsl style sheets:
>   dblatex:
>   convert:  /usr/bin/convert
>   mathml2.dtd:  http://www.w3.org/Math/DTD/mathml2/mathml2.dtd
>
>
> Entering directory `/postgis-2.0.1/raster/loader'
> /bin/sh ../../libtool --mode=link gcc -g -O2  -fPIC -DPIC  -Wall
> -Wmissing-prototypes -I../rt_core -I../../liblwgeom  -I/usr/local/include
> -I/usr/local/include   raster2pgsql.o ../rt_core/librtcore.a
> ../rt_core/librtcore.a ../../liblwgeom/liblwgeom.la -L/usr/local/lib -lgdal
> -L/usr/local/lib -lgeos_c  -lc -lm -o raster2pgsql
> libtool: link: gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes
> -I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include
> raster2pgsql.o -o .libs/raster2pgsql  ../rt_core/librtcore.a
> ../../liblwgeom/.libs/liblwgeom.so -L/usr/local/lib
> /usr/local/lib/libproj.so /usr/local/lib/libgdal.so -L/usr/lib64
> -L/usr/kerberos/lib64 -L/usr/lib64/mysql -lsqlite3 /usr/lib64/libexpat.so
> -lgif -ljpeg -lpng -lpq -lcurl -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err
> -lidn -lz -lmysqlclient -lpthread -lrt -lssl -lcrypto -ldl
> /usr/local/lib/libgeos_c.so /usr/local/lib/libgeos.so -lc -lm -Wl,-rpath
> -Wl,/usr/local/lib -Wl,-rpath -Wl,/usr/lib64
> /usr/bin/ld: cannot find -lpq
> collect2: ld returned 1 exit status
> make[2]: *** [raster2pgsql] Error 1
> make[2]: Leaving directory `/postgis-2.0.1/raster/loader'
> make[1]: *** [rtloader] Error 2
> make[1]: Leaving directory `/postgis-2.0.1/raster'
> make: *** [all] Error 1
>
>
> --
> Jeff Lake
> MichiganWxSystem
> AllisonHouse
> GRLevelXStuff
>
> ___
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-- 
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkp...@ucdavis.edu
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] PostGIS 2 RPM

2012-10-18 Thread Jeff Lake


Well that sounded promising
but no joy,
even tried  --without-raster
and got error's galore when I tried to apply postgis.sql to my tables



*Jeff Lake*
MichiganWxSystem 
AllisonHouse 
GRLevelXStuff 
On 10/18/2012 10:24, Bborie Park wrote:

It looks like the linker can't find libpq.  You'll want to add the
following to /etc/ld.so.conf.

/usr/pgsql-9.1/lib

-bborie

On Thu, Oct 18, 2012 at 6:09 AM, Jeff Lake  wrote:

Is there any reasoning why EL5 does not have a postGIS2_91 RPM ??
this is on CentOS 5.8 64bit

I have tried numerous times to install from source and keep getting raster
error

configure params

./configure --with-raster --with-pgconfig=/usr/pgsql-9.1/bin/pg_config
--with-geosconfig=/geos-3.3.5/tools/geos-config

   PostGIS is now configured for x86_64-unknown-linux-gnu

  -- Compiler Info -
   C compiler:   gcc -g -O2
   C++ compiler: g++ -g -O2
   SQL preprocessor: /usr/bin/cpp -traditional-cpp -P

  -- Dependencies --
   GEOS config:  /geos-3.3.5/tools/geos-config
   GEOS version: 3.3.5
   GDAL config:  /usr/local/bin/gdal-config
   GDAL version: 1.9.1
   PostgreSQL config:/usr/pgsql-9.1/bin/pg_config
   PostgreSQL version:   PostgreSQL 9.1.6
   PROJ4 version:48
   Libxml2 config:   /usr/bin/xml2-config
   Libxml2 version:  2.6.26
   JSON-C support:   no
   PostGIS debug level:  0
   Perl: /usr/bin/perl

  --- Extensions ---
   PostGIS Raster:   enabled
   PostGIS Topology: enabled

   Documentation Generation 
   xsltproc: /usr/bin/xsltproc
   xsl style sheets:
   dblatex:
   convert:  /usr/bin/convert
   mathml2.dtd:  http://www.w3.org/Math/DTD/mathml2/mathml2.dtd


Entering directory `/postgis-2.0.1/raster/loader'
/bin/sh ../../libtool --mode=link gcc -g -O2  -fPIC -DPIC  -Wall
-Wmissing-prototypes -I../rt_core -I../../liblwgeom  -I/usr/local/include
-I/usr/local/include   raster2pgsql.o ../rt_core/librtcore.a
../rt_core/librtcore.a ../../liblwgeom/liblwgeom.la -L/usr/local/lib -lgdal
-L/usr/local/lib -lgeos_c  -lc -lm -o raster2pgsql
libtool: link: gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes
-I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include
raster2pgsql.o -o .libs/raster2pgsql  ../rt_core/librtcore.a
../../liblwgeom/.libs/liblwgeom.so -L/usr/local/lib
/usr/local/lib/libproj.so /usr/local/lib/libgdal.so -L/usr/lib64
-L/usr/kerberos/lib64 -L/usr/lib64/mysql -lsqlite3 /usr/lib64/libexpat.so
-lgif -ljpeg -lpng -lpq -lcurl -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err
-lidn -lz -lmysqlclient -lpthread -lrt -lssl -lcrypto -ldl
/usr/local/lib/libgeos_c.so /usr/local/lib/libgeos.so -lc -lm -Wl,-rpath
-Wl,/usr/local/lib -Wl,-rpath -Wl,/usr/lib64
/usr/bin/ld: cannot find -lpq
collect2: ld returned 1 exit status
make[2]: *** [raster2pgsql] Error 1
make[2]: Leaving directory `/postgis-2.0.1/raster/loader'
make[1]: *** [rtloader] Error 2
make[1]: Leaving directory `/postgis-2.0.1/raster'
make: *** [all] Error 1


--
Jeff Lake
MichiganWxSystem
AllisonHouse
GRLevelXStuff

___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users






___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] PostGIS 2 RPM

2012-10-18 Thread Bborie Park

Did you run "ldconfig" after adding the lib path to ld.so.conf?

-bborie

On 10/18/2012 08:20 AM, Jeff Lake wrote:
> Well that sounded promising
> but no joy,
> even tried  --without-raster
> and got error's galore when I tried to apply postgis.sql to my tables
> 
> 
> 
> *Jeff Lake*
> MichiganWxSystem 
> AllisonHouse 
> GRLevelXStuff 
> On 10/18/2012 10:24, Bborie Park wrote:
>> It looks like the linker can't find libpq.  You'll want to add the
>> following to /etc/ld.so.conf.
>>
>> /usr/pgsql-9.1/lib
>>
>> -bborie
>>
>> On Thu, Oct 18, 2012 at 6:09 AM, Jeff Lake 
>> wrote:
>>> Is there any reasoning why EL5 does not have a postGIS2_91 RPM ??
>>> this is on CentOS 5.8 64bit
>>>
>>> I have tried numerous times to install from source and keep getting
>>> raster
>>> error
>>>
>>> configure params
>>>
>>> ./configure --with-raster --with-pgconfig=/usr/pgsql-9.1/bin/pg_config
>>> --with-geosconfig=/geos-3.3.5/tools/geos-config
>>>
>>>PostGIS is now configured for x86_64-unknown-linux-gnu
>>>
>>>   -- Compiler Info -
>>>C compiler:   gcc -g -O2
>>>C++ compiler: g++ -g -O2
>>>SQL preprocessor: /usr/bin/cpp -traditional-cpp -P
>>>
>>>   -- Dependencies --
>>>GEOS config:  /geos-3.3.5/tools/geos-config
>>>GEOS version: 3.3.5
>>>GDAL config:  /usr/local/bin/gdal-config
>>>GDAL version: 1.9.1
>>>PostgreSQL config:/usr/pgsql-9.1/bin/pg_config
>>>PostgreSQL version:   PostgreSQL 9.1.6
>>>PROJ4 version:48
>>>Libxml2 config:   /usr/bin/xml2-config
>>>Libxml2 version:  2.6.26
>>>JSON-C support:   no
>>>PostGIS debug level:  0
>>>Perl: /usr/bin/perl
>>>
>>>   --- Extensions ---
>>>PostGIS Raster:   enabled
>>>PostGIS Topology: enabled
>>>
>>>    Documentation Generation 
>>>xsltproc: /usr/bin/xsltproc
>>>xsl style sheets:
>>>dblatex:
>>>convert:  /usr/bin/convert
>>>mathml2.dtd:  http://www.w3.org/Math/DTD/mathml2/mathml2.dtd
>>>
>>>
>>> Entering directory `/postgis-2.0.1/raster/loader'
>>> /bin/sh ../../libtool --mode=link gcc -g -O2  -fPIC -DPIC  -Wall
>>> -Wmissing-prototypes -I../rt_core -I../../liblwgeom 
>>> -I/usr/local/include
>>> -I/usr/local/include   raster2pgsql.o ../rt_core/librtcore.a
>>> ../rt_core/librtcore.a ../../liblwgeom/liblwgeom.la -L/usr/local/lib
>>> -lgdal
>>> -L/usr/local/lib -lgeos_c  -lc -lm -o raster2pgsql
>>> libtool: link: gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes
>>> -I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include
>>> raster2pgsql.o -o .libs/raster2pgsql  ../rt_core/librtcore.a
>>> ../../liblwgeom/.libs/liblwgeom.so -L/usr/local/lib
>>> /usr/local/lib/libproj.so /usr/local/lib/libgdal.so -L/usr/lib64
>>> -L/usr/kerberos/lib64 -L/usr/lib64/mysql -lsqlite3
>>> /usr/lib64/libexpat.so
>>> -lgif -ljpeg -lpng -lpq -lcurl -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err
>>> -lidn -lz -lmysqlclient -lpthread -lrt -lssl -lcrypto -ldl
>>> /usr/local/lib/libgeos_c.so /usr/local/lib/libgeos.so -lc -lm -Wl,-rpath
>>> -Wl,/usr/local/lib -Wl,-rpath -Wl,/usr/lib64
>>> /usr/bin/ld: cannot find -lpq
>>> collect2: ld returned 1 exit status
>>> make[2]: *** [raster2pgsql] Error 1
>>> make[2]: Leaving directory `/postgis-2.0.1/raster/loader'
>>> make[1]: *** [rtloader] Error 2
>>> make[1]: Leaving directory `/postgis-2.0.1/raster'
>>> make: *** [all] Error 1
>>>
>>>
>>> -- 
>>> Jeff Lake
>>> MichiganWxSystem
>>> AllisonHouse
>>> GRLevelXStuff
>>>
>>> ___
>>> postgis-users mailing list
>>> postgis-users@postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>
>>
>>
> 
> 
> 
> 
> ___
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 

-- 
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkp...@ucdavis.edu
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] PostGIS 2 RPM

2012-10-18 Thread Jeff Lake


Yes I did ..

#vim /etc/ld.so.conf
include /etc/ld.so.conf.d/*.conf


#dir /etc/ld.so.conf.d
atlas-x86_64.conf kernelcap-2.6.18-308.16.1.el5.conf  mysql-x86_64.conf 
xulrunner-32.conf
kernelcap-2.6.18-308.13.1.el5.conf mysqlclient15-x86_64.conf   
postgresql-pgdg-libs.conf xulrunner-64.conf


#vim postgresql-pgdg-libs.conf
/usr/pgsql-9.1/lib

here is log files of configure and make

http://www2.michiganwxsystem.net/configure.log
http://www2.michiganwxsystem.net/make.log








*Jeff Lake*
MichiganWxSystem 
AllisonHouse 
GRLevelXStuff 
On 10/18/2012 11:33, Bborie Park wrote:

Did you run "ldconfig" after adding the lib path to ld.so.conf?

-bborie

On 10/18/2012 08:20 AM, Jeff Lake wrote:

Well that sounded promising
but no joy,
even tried  --without-raster
and got error's galore when I tried to apply postgis.sql to my tables



*Jeff Lake*
MichiganWxSystem 
AllisonHouse 
GRLevelXStuff 
On 10/18/2012 10:24, Bborie Park wrote:

It looks like the linker can't find libpq.  You'll want to add the
following to /etc/ld.so.conf.

/usr/pgsql-9.1/lib

-bborie

On Thu, Oct 18, 2012 at 6:09 AM, Jeff Lake 
wrote:

Is there any reasoning why EL5 does not have a postGIS2_91 RPM ??
this is on CentOS 5.8 64bit

I have tried numerous times to install from source and keep getting
raster
error

configure params

./configure --with-raster --with-pgconfig=/usr/pgsql-9.1/bin/pg_config
--with-geosconfig=/geos-3.3.5/tools/geos-config

PostGIS is now configured for x86_64-unknown-linux-gnu

   -- Compiler Info -
C compiler:   gcc -g -O2
C++ compiler: g++ -g -O2
SQL preprocessor: /usr/bin/cpp -traditional-cpp -P

   -- Dependencies --
GEOS config:  /geos-3.3.5/tools/geos-config
GEOS version: 3.3.5
GDAL config:  /usr/local/bin/gdal-config
GDAL version: 1.9.1
PostgreSQL config:/usr/pgsql-9.1/bin/pg_config
PostgreSQL version:   PostgreSQL 9.1.6
PROJ4 version:48
Libxml2 config:   /usr/bin/xml2-config
Libxml2 version:  2.6.26
JSON-C support:   no
PostGIS debug level:  0
Perl: /usr/bin/perl

   --- Extensions ---
PostGIS Raster:   enabled
PostGIS Topology: enabled

    Documentation Generation 
xsltproc: /usr/bin/xsltproc
xsl style sheets:
dblatex:
convert:  /usr/bin/convert
mathml2.dtd:  http://www.w3.org/Math/DTD/mathml2/mathml2.dtd


Entering directory `/postgis-2.0.1/raster/loader'
/bin/sh ../../libtool --mode=link gcc -g -O2  -fPIC -DPIC  -Wall
-Wmissing-prototypes -I../rt_core -I../../liblwgeom
-I/usr/local/include
-I/usr/local/include   raster2pgsql.o ../rt_core/librtcore.a
../rt_core/librtcore.a ../../liblwgeom/liblwgeom.la -L/usr/local/lib
-lgdal
-L/usr/local/lib -lgeos_c  -lc -lm -o raster2pgsql
libtool: link: gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes
-I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include
raster2pgsql.o -o .libs/raster2pgsql  ../rt_core/librtcore.a
../../liblwgeom/.libs/liblwgeom.so -L/usr/local/lib
/usr/local/lib/libproj.so /usr/local/lib/libgdal.so -L/usr/lib64
-L/usr/kerberos/lib64 -L/usr/lib64/mysql -lsqlite3
/usr/lib64/libexpat.so
-lgif -ljpeg -lpng -lpq -lcurl -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err
-lidn -lz -lmysqlclient -lpthread -lrt -lssl -lcrypto -ldl
/usr/local/lib/libgeos_c.so /usr/local/lib/libgeos.so -lc -lm -Wl,-rpath
-Wl,/usr/local/lib -Wl,-rpath -Wl,/usr/lib64
/usr/bin/ld: cannot find -lpq
collect2: ld returned 1 exit status
make[2]: *** [raster2pgsql] Error 1
make[2]: Leaving directory `/postgis-2.0.1/raster/loader'
make[1]: *** [rtloader] Error 2
make[1]: Leaving directory `/postgis-2.0.1/raster'
make: *** [all] Error 1


--
Jeff Lake
MichiganWxSystem
AllisonHouse
GRLevelXStuff

___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users







___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users



___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] PostGIS 2 RPM

2012-10-18 Thread Bborie Park

Your initial email message indicated an error in the "raster/loader"
make step but that step has no errors in the make.log (bottom of the file).

-bborie

On 10/18/2012 02:14 PM, Jeff Lake wrote:
> Yes I did ..
> 
> #vim /etc/ld.so.conf
> include /etc/ld.so.conf.d/*.conf
> 
> 
> #dir /etc/ld.so.conf.d
> atlas-x86_64.conf kernelcap-2.6.18-308.16.1.el5.conf  mysql-x86_64.conf
> xulrunner-32.conf
> kernelcap-2.6.18-308.13.1.el5.conf mysqlclient15-x86_64.conf  
> postgresql-pgdg-libs.conf xulrunner-64.conf
> 
> #vim postgresql-pgdg-libs.conf
> /usr/pgsql-9.1/lib
> 
> here is log files of configure and make
> 
> http://www2.michiganwxsystem.net/configure.log
> http://www2.michiganwxsystem.net/make.log
> 
> 
> 
> 
> 
> 
> 
> 
> *Jeff Lake*
> MichiganWxSystem 
> AllisonHouse 
> GRLevelXStuff 
> On 10/18/2012 11:33, Bborie Park wrote:
>> Did you run "ldconfig" after adding the lib path to ld.so.conf?
>>
>> -bborie
>>
>> On 10/18/2012 08:20 AM, Jeff Lake wrote:
>>> Well that sounded promising
>>> but no joy,
>>> even tried  --without-raster
>>> and got error's galore when I tried to apply postgis.sql to my tables
>>>
>>>
>>>
>>> *Jeff Lake*
>>> MichiganWxSystem 
>>> AllisonHouse 
>>> GRLevelXStuff 
>>> On 10/18/2012 10:24, Bborie Park wrote:
 It looks like the linker can't find libpq.  You'll want to add the
 following to /etc/ld.so.conf.

 /usr/pgsql-9.1/lib

 -bborie

 On Thu, Oct 18, 2012 at 6:09 AM, Jeff Lake 
 wrote:
> Is there any reasoning why EL5 does not have a postGIS2_91 RPM ??
> this is on CentOS 5.8 64bit
>
> I have tried numerous times to install from source and keep getting
> raster
> error
>
> configure params
>
> ./configure --with-raster --with-pgconfig=/usr/pgsql-9.1/bin/pg_config
> --with-geosconfig=/geos-3.3.5/tools/geos-config
>
> PostGIS is now configured for x86_64-unknown-linux-gnu
>
>-- Compiler Info -
> C compiler:   gcc -g -O2
> C++ compiler: g++ -g -O2
> SQL preprocessor: /usr/bin/cpp -traditional-cpp -P
>
>-- Dependencies --
> GEOS config:  /geos-3.3.5/tools/geos-config
> GEOS version: 3.3.5
> GDAL config:  /usr/local/bin/gdal-config
> GDAL version: 1.9.1
> PostgreSQL config:/usr/pgsql-9.1/bin/pg_config
> PostgreSQL version:   PostgreSQL 9.1.6
> PROJ4 version:48
> Libxml2 config:   /usr/bin/xml2-config
> Libxml2 version:  2.6.26
> JSON-C support:   no
> PostGIS debug level:  0
> Perl: /usr/bin/perl
>
>--- Extensions ---
> PostGIS Raster:   enabled
> PostGIS Topology: enabled
>
> Documentation Generation 
> xsltproc: /usr/bin/xsltproc
> xsl style sheets:
> dblatex:
> convert:  /usr/bin/convert
> mathml2.dtd: 
> http://www.w3.org/Math/DTD/mathml2/mathml2.dtd
>
>
> Entering directory `/postgis-2.0.1/raster/loader'
> /bin/sh ../../libtool --mode=link gcc -g -O2  -fPIC -DPIC  -Wall
> -Wmissing-prototypes -I../rt_core -I../../liblwgeom
> -I/usr/local/include
> -I/usr/local/include   raster2pgsql.o ../rt_core/librtcore.a
> ../rt_core/librtcore.a ../../liblwgeom/liblwgeom.la -L/usr/local/lib
> -lgdal
> -L/usr/local/lib -lgeos_c  -lc -lm -o raster2pgsql
> libtool: link: gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes
> -I../rt_core -I../../liblwgeom -I/usr/local/include
> -I/usr/local/include
> raster2pgsql.o -o .libs/raster2pgsql  ../rt_core/librtcore.a
> ../../liblwgeom/.libs/liblwgeom.so -L/usr/local/lib
> /usr/local/lib/libproj.so /usr/local/lib/libgdal.so -L/usr/lib64
> -L/usr/kerberos/lib64 -L/usr/lib64/mysql -lsqlite3
> /usr/lib64/libexpat.so
> -lgif -ljpeg -lpng -lpq -lcurl -lgssapi_krb5 -lkrb5 -lk5crypto
> -lcom_err
> -lidn -lz -lmysqlclient -lpthread -lrt -lssl -lcrypto -ldl
> /usr/local/lib/libgeos_c.so /usr/local/lib/libgeos.so -lc -lm
> -Wl,-rpath
> -Wl,/usr/local/lib -Wl,-rpath -Wl,/usr/lib64
> /usr/bin/ld: cannot find -lpq
> collect2: ld returned 1 exit status
> make[2]: *** [raster2pgsql] Error 1
> make[2]: Leaving directory `/postgis-2.0.1/raster/loader'
> make[1]: *** [rtloader] Error 2
> make[1]: Leaving directory `/postgis-2.0.1/raster'
> make: *** [all] Error 1
>
>
> -- 
> Jeff Lake
> MichiganWxSystem
> AllisonHouse
> GRLevelXStuff
>
> ___
> postgis-

Re: [postgis-users] PostGIS 2 RPM

2012-10-18 Thread Jeff Lake


the log doesnt show it,
but

#make > make.log
Can't fetch local revision (neither .svn nor .git found)
Not updating existing rev file at 9979
/usr/bin/ld: cannot find -lpq
collect2: ld returned 1 exit status
make[2]: *** [raster2pgsql] Error 1
make[1]: *** [rtloader] Error 2
make: *** [all] Error 1




*Jeff Lake*
MichiganWxSystem 
AllisonHouse 
GRLevelXStuff 
On 10/18/2012 17:22, Bborie Park wrote:

Your initial email message indicated an error in the "raster/loader"
make step but that step has no errors in the make.log (bottom of the file).

-bborie

On 10/18/2012 02:14 PM, Jeff Lake wrote:

Yes I did ..

#vim /etc/ld.so.conf
include /etc/ld.so.conf.d/*.conf


#dir /etc/ld.so.conf.d
atlas-x86_64.conf kernelcap-2.6.18-308.16.1.el5.conf  mysql-x86_64.conf
xulrunner-32.conf
kernelcap-2.6.18-308.13.1.el5.conf mysqlclient15-x86_64.conf
postgresql-pgdg-libs.conf xulrunner-64.conf

#vim postgresql-pgdg-libs.conf
/usr/pgsql-9.1/lib

here is log files of configure and make

http://www2.michiganwxsystem.net/configure.log
http://www2.michiganwxsystem.net/make.log








*Jeff Lake*
MichiganWxSystem 
AllisonHouse 
GRLevelXStuff 
On 10/18/2012 11:33, Bborie Park wrote:

Did you run "ldconfig" after adding the lib path to ld.so.conf?

-bborie

On 10/18/2012 08:20 AM, Jeff Lake wrote:

Well that sounded promising
but no joy,
even tried  --without-raster
and got error's galore when I tried to apply postgis.sql to my tables



*Jeff Lake*
MichiganWxSystem 
AllisonHouse 
GRLevelXStuff 
On 10/18/2012 10:24, Bborie Park wrote:

It looks like the linker can't find libpq.  You'll want to add the
following to /etc/ld.so.conf.

/usr/pgsql-9.1/lib

-bborie

On Thu, Oct 18, 2012 at 6:09 AM, Jeff Lake 
wrote:

Is there any reasoning why EL5 does not have a postGIS2_91 RPM ??
this is on CentOS 5.8 64bit

I have tried numerous times to install from source and keep getting
raster
error

configure params

./configure --with-raster --with-pgconfig=/usr/pgsql-9.1/bin/pg_config
--with-geosconfig=/geos-3.3.5/tools/geos-config

 PostGIS is now configured for x86_64-unknown-linux-gnu

-- Compiler Info -
 C compiler:   gcc -g -O2
 C++ compiler: g++ -g -O2
 SQL preprocessor: /usr/bin/cpp -traditional-cpp -P

-- Dependencies --
 GEOS config:  /geos-3.3.5/tools/geos-config
 GEOS version: 3.3.5
 GDAL config:  /usr/local/bin/gdal-config
 GDAL version: 1.9.1
 PostgreSQL config:/usr/pgsql-9.1/bin/pg_config
 PostgreSQL version:   PostgreSQL 9.1.6
 PROJ4 version:48
 Libxml2 config:   /usr/bin/xml2-config
 Libxml2 version:  2.6.26
 JSON-C support:   no
 PostGIS debug level:  0
 Perl: /usr/bin/perl

--- Extensions ---
 PostGIS Raster:   enabled
 PostGIS Topology: enabled

 Documentation Generation 
 xsltproc: /usr/bin/xsltproc
 xsl style sheets:
 dblatex:
 convert:  /usr/bin/convert
 mathml2.dtd:
http://www.w3.org/Math/DTD/mathml2/mathml2.dtd


Entering directory `/postgis-2.0.1/raster/loader'
/bin/sh ../../libtool --mode=link gcc -g -O2  -fPIC -DPIC  -Wall
-Wmissing-prototypes -I../rt_core -I../../liblwgeom
-I/usr/local/include
-I/usr/local/include   raster2pgsql.o ../rt_core/librtcore.a
../rt_core/librtcore.a ../../liblwgeom/liblwgeom.la -L/usr/local/lib
-lgdal
-L/usr/local/lib -lgeos_c  -lc -lm -o raster2pgsql
libtool: link: gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes
-I../rt_core -I../../liblwgeom -I/usr/local/include
-I/usr/local/include
raster2pgsql.o -o .libs/raster2pgsql  ../rt_core/librtcore.a
../../liblwgeom/.libs/liblwgeom.so -L/usr/local/lib
/usr/local/lib/libproj.so /usr/local/lib/libgdal.so -L/usr/lib64
-L/usr/kerberos/lib64 -L/usr/lib64/mysql -lsqlite3
/usr/lib64/libexpat.so
-lgif -ljpeg -lpng -lpq -lcurl -lgssapi_krb5 -lkrb5 -lk5crypto
-lcom_err
-lidn -lz -lmysqlclient -lpthread -lrt -lssl -lcrypto -ldl
/usr/local/lib/libgeos_c.so /usr/local/lib/libgeos.so -lc -lm
-Wl,-rpath
-Wl,/usr/local/lib -Wl,-rpath -Wl,/usr/lib64
/usr/bin/ld: cannot find -lpq
collect2: ld returned 1 exit status
make[2]: *** [raster2pgsql] Error 1
make[2]: Leaving directory `/postgis-2.0.1/raster/loader'
make[1]: *** [rtloader] Error 2
make[1]: Leaving directory `/postgis-2.0.1/raster'
make: *** [all] Error 1


--
Jeff Lake
MichiganWxSystem
AllisonHouse
GRLevelXStuff

___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users




_

Re: [postgis-users] PostGIS 2 RPM

2012-10-18 Thread Bborie Park

I'm going to need some background regarding your PostgreSQL installation.

1. Are there multiple instances of PostgreSQL installed?

2. What version are you running?

3. What is the output of pg_config?  Specifically, "LIBDIR".

Since the error states that ld can't find libpq, something is up with
the environment.  That probably explains why you had issues with
"--without-raster" and errors happened when applying postgis.sql.

-bborie

On 10/18/2012 02:37 PM, Jeff Lake wrote:
> the log doesnt show it,
> but
> 
> #make > make.log
> Can't fetch local revision (neither .svn nor .git found)
> Not updating existing rev file at 9979
> /usr/bin/ld: cannot find -lpq
> collect2: ld returned 1 exit status
> make[2]: *** [raster2pgsql] Error 1
> make[1]: *** [rtloader] Error 2
> make: *** [all] Error 1
> 
> 
> 
> 
> *Jeff Lake*
> MichiganWxSystem 
> AllisonHouse 
> GRLevelXStuff 
> On 10/18/2012 17:22, Bborie Park wrote:
>> Your initial email message indicated an error in the "raster/loader"
>> make step but that step has no errors in the make.log (bottom of the
>> file).
>>
>> -bborie
>>
>> On 10/18/2012 02:14 PM, Jeff Lake wrote:
>>> Yes I did ..
>>>
>>> #vim /etc/ld.so.conf
>>> include /etc/ld.so.conf.d/*.conf
>>>
>>>
>>> #dir /etc/ld.so.conf.d
>>> atlas-x86_64.conf kernelcap-2.6.18-308.16.1.el5.conf  mysql-x86_64.conf
>>> xulrunner-32.conf
>>> kernelcap-2.6.18-308.13.1.el5.conf mysqlclient15-x86_64.conf
>>> postgresql-pgdg-libs.conf xulrunner-64.conf
>>>
>>> #vim postgresql-pgdg-libs.conf
>>> /usr/pgsql-9.1/lib
>>>
>>> here is log files of configure and make
>>>
>>> http://www2.michiganwxsystem.net/configure.log
>>> http://www2.michiganwxsystem.net/make.log
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> *Jeff Lake*
>>> MichiganWxSystem 
>>> AllisonHouse 
>>> GRLevelXStuff 
>>> On 10/18/2012 11:33, Bborie Park wrote:
 Did you run "ldconfig" after adding the lib path to ld.so.conf?

 -bborie

 On 10/18/2012 08:20 AM, Jeff Lake wrote:
> Well that sounded promising
> but no joy,
> even tried  --without-raster
> and got error's galore when I tried to apply postgis.sql to my tables
>
>
>
> *Jeff Lake*
> MichiganWxSystem 
> AllisonHouse 
> GRLevelXStuff 
> On 10/18/2012 10:24, Bborie Park wrote:
>> It looks like the linker can't find libpq.  You'll want to add the
>> following to /etc/ld.so.conf.
>>
>> /usr/pgsql-9.1/lib
>>
>> -bborie
>>
>> On Thu, Oct 18, 2012 at 6:09 AM, Jeff Lake
>> 
>> wrote:
>>> Is there any reasoning why EL5 does not have a postGIS2_91 RPM ??
>>> this is on CentOS 5.8 64bit
>>>
>>> I have tried numerous times to install from source and keep getting
>>> raster
>>> error
>>>
>>> configure params
>>>
>>> ./configure --with-raster
>>> --with-pgconfig=/usr/pgsql-9.1/bin/pg_config
>>> --with-geosconfig=/geos-3.3.5/tools/geos-config
>>>
>>>  PostGIS is now configured for x86_64-unknown-linux-gnu
>>>
>>> -- Compiler Info -
>>>  C compiler:   gcc -g -O2
>>>  C++ compiler: g++ -g -O2
>>>  SQL preprocessor: /usr/bin/cpp -traditional-cpp -P
>>>
>>> -- Dependencies --
>>>  GEOS config:  /geos-3.3.5/tools/geos-config
>>>  GEOS version: 3.3.5
>>>  GDAL config:  /usr/local/bin/gdal-config
>>>  GDAL version: 1.9.1
>>>  PostgreSQL config:/usr/pgsql-9.1/bin/pg_config
>>>  PostgreSQL version:   PostgreSQL 9.1.6
>>>  PROJ4 version:48
>>>  Libxml2 config:   /usr/bin/xml2-config
>>>  Libxml2 version:  2.6.26
>>>  JSON-C support:   no
>>>  PostGIS debug level:  0
>>>  Perl: /usr/bin/perl
>>>
>>> --- Extensions ---
>>>  PostGIS Raster:   enabled
>>>  PostGIS Topology: enabled
>>>
>>>  Documentation Generation 
>>>  xsltproc: /usr/bin/xsltproc
>>>  xsl style sheets:
>>>  dblatex:
>>>  convert:  /usr/bin/convert
>>>  mathml2.dtd:
>>> http://www.w3.org/Math/DTD/mathml2/mathml2.dtd
>>>
>>>
>>> Entering directory `/postgis-2.0.1/raster/loader'
>>> /bin/sh ../../libtool --mode=link gcc -g -O2  -fPIC -DPIC  -Wall
>>> -Wmissing-prototypes -I../rt_core -I../../liblwgeom
>>> -I/usr/local/include
>>> -I/usr/local/include   raster2pgsql.o ../rt_core/librtcore.a
>>> ../rt_core/librtcore.a ../../liblwgeom/liblwgeom.la -L/usr/local/lib
>>> -lgda

Re: [postgis-users] PostGIS 2 RPM

2012-10-18 Thread Jeff Lake

No other installs, had 8.4, but completely wiped it before 9.1.6 was 
installed


[root@ldm postgis-2.0.1]# /usr/pgsql-9.1/bin/pg_config
BINDIR = /usr/pgsql-9.1/bin
DOCDIR = /usr/share/doc/pgsql
HTMLDIR = /usr/share/doc/pgsql
INCLUDEDIR = /usr/pgsql-9.1/include
PKGINCLUDEDIR = /usr/pgsql-9.1/include
INCLUDEDIR-SERVER = /usr/pgsql-9.1/include/server
LIBDIR = /usr/pgsql-9.1/lib
PKGLIBDIR = /usr/pgsql-9.1/lib
LOCALEDIR = /usr/pgsql-9.1/share/locale
MANDIR = /usr/pgsql-9.1/share/man
SHAREDIR = /usr/pgsql-9.1/share
SYSCONFDIR = /etc/sysconfig/pgsql
PGXS = /usr/pgsql-9.1/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--disable-rpath' '--prefix=/usr/pgsql-9.1' 
'--includedir=/usr/pgsql-9.1/include' 
'--mandir=/usr/pgsql-9.1/share/man' '--datadir=/usr/pgsql-9.1/share' 
'--with-perl' '--with-python' '--with-tcl' '--with-tclconfig=/usr/lib64' 
'--with-openssl' '--with-pam' '--with-krb5' '--with-gssapi' 
'--with-includes=/usr/include' '--with-libraries=/usr/lib64' 
'--enable-nls' '--with-ossp-uuid' '--with-libxml' '--with-libxslt' 
'--with-ldap' '--with-system-tzdata=/usr/share/zoneinfo' 
'--sysconfdir=/etc/sysconfig/pgsql' '--docdir=/usr/share/doc' 
'CFLAGS=-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions 
-fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic 
-I/usr/include/et' 'CPPFLAGS= -I/usr/include/et'

CC = gcc
CPPFLAGS = -I/usr/include/et -D_GNU_SOURCE -I/usr/include/libxml2 
-I/usr/include
CFLAGS = -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions 
-fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic 
-I/usr/include/et -Wall -Wmissing-prototypes -Wpointer-arith 
-Wdeclaration-after-statement -Wendif-labels -Wformat-security 
-fno-strict-aliasing -fwrapv

CFLAGS_SL = -fpic
LDFLAGS = -L/usr/lib64
LDFLAGS_EX =
LDFLAGS_SL =
LIBS = -lpgport -lxslt -lxml2 -lpam -lssl -lcrypto -lgssapi_krb5 -lz 
-lreadline -ltermcap -lcrypt -ldl -lm

VERSION = PostgreSQL 9.1.6




*Jeff Lake*
MichiganWxSystem 
AllisonHouse 
GRLevelXStuff 
On 10/18/2012 17:43, Bborie Park wrote:

I'm going to need some background regarding your PostgreSQL installation.

1. Are there multiple instances of PostgreSQL installed?

2. What version are you running?

3. What is the output of pg_config?  Specifically, "LIBDIR".

Since the error states that ld can't find libpq, something is up with
the environment.  That probably explains why you had issues with
"--without-raster" and errors happened when applying postgis.sql.

-bborie

On 10/18/2012 02:37 PM, Jeff Lake wrote:

the log doesnt show it,
but

#make > make.log
Can't fetch local revision (neither .svn nor .git found)
Not updating existing rev file at 9979
/usr/bin/ld: cannot find -lpq
collect2: ld returned 1 exit status
make[2]: *** [raster2pgsql] Error 1
make[1]: *** [rtloader] Error 2
make: *** [all] Error 1




*Jeff Lake*
MichiganWxSystem 
AllisonHouse 
GRLevelXStuff 
On 10/18/2012 17:22, Bborie Park wrote:

Your initial email message indicated an error in the "raster/loader"
make step but that step has no errors in the make.log (bottom of the
file).

-bborie

On 10/18/2012 02:14 PM, Jeff Lake wrote:

Yes I did ..

#vim /etc/ld.so.conf
include /etc/ld.so.conf.d/*.conf


#dir /etc/ld.so.conf.d
atlas-x86_64.conf kernelcap-2.6.18-308.16.1.el5.conf  mysql-x86_64.conf
xulrunner-32.conf
kernelcap-2.6.18-308.13.1.el5.conf mysqlclient15-x86_64.conf
postgresql-pgdg-libs.conf xulrunner-64.conf

#vim postgresql-pgdg-libs.conf
/usr/pgsql-9.1/lib

here is log files of configure and make

http://www2.michiganwxsystem.net/configure.log
http://www2.michiganwxsystem.net/make.log








*Jeff Lake*
MichiganWxSystem 
AllisonHouse 
GRLevelXStuff 
On 10/18/2012 11:33, Bborie Park wrote:

Did you run "ldconfig" after adding the lib path to ld.so.conf?

-bborie

On 10/18/2012 08:20 AM, Jeff Lake wrote:

Well that sounded promising
but no joy,
even tried  --without-raster
and got error's galore when I tried to apply postgis.sql to my tables



*Jeff Lake*
MichiganWxSystem 
AllisonHouse 
GRLevelXStuff 
On 10/18/2012 10:24, Bborie Park wrote:

It looks like the linker can't find libpq.  You'll want to add the
following to /etc/ld.so.conf.

/usr/pgsql-9.1/lib

-bborie

On Thu, Oct 18, 2012 at 6:09 AM, Jeff Lake

wrote:

Is there any reasoning why EL5 does not have a postGIS2_91 RPM ??
this is on CentOS 5.8 64bit

I have tried numerous times to install from source and keep getting
raster
error

configure params

./configure --with-raster
--with-pgconfig=/usr/pgsql-9.1/bin/pg_config
--with-geosconfig=/geos-3.3.5/tools/geos-config

  PostGIS is now configured for x86_64-unknown-linux-gnu

 -- Compiler Info --

Re: [postgis-users] PostGIS 2 RPM

2012-10-18 Thread Bborie Park

See if you can run make setting LD_LIBRARY_PATH.  Something like the
following.

LD_LIBRARY_PATH=/usr/pgsql-9.1/lib make

-bborie

On 10/18/2012 03:39 PM, Jeff Lake wrote:
> No other installs, had 8.4, but completely wiped it before 9.1.6 was
> installed
> 
> [root@ldm postgis-2.0.1]# /usr/pgsql-9.1/bin/pg_config
> BINDIR = /usr/pgsql-9.1/bin
> DOCDIR = /usr/share/doc/pgsql
> HTMLDIR = /usr/share/doc/pgsql
> INCLUDEDIR = /usr/pgsql-9.1/include
> PKGINCLUDEDIR = /usr/pgsql-9.1/include
> INCLUDEDIR-SERVER = /usr/pgsql-9.1/include/server
> LIBDIR = /usr/pgsql-9.1/lib
> PKGLIBDIR = /usr/pgsql-9.1/lib
> LOCALEDIR = /usr/pgsql-9.1/share/locale
> MANDIR = /usr/pgsql-9.1/share/man
> SHAREDIR = /usr/pgsql-9.1/share
> SYSCONFDIR = /etc/sysconfig/pgsql
> PGXS = /usr/pgsql-9.1/lib/pgxs/src/makefiles/pgxs.mk
> CONFIGURE = '--disable-rpath' '--prefix=/usr/pgsql-9.1'
> '--includedir=/usr/pgsql-9.1/include'
> '--mandir=/usr/pgsql-9.1/share/man' '--datadir=/usr/pgsql-9.1/share'
> '--with-perl' '--with-python' '--with-tcl' '--with-tclconfig=/usr/lib64'
> '--with-openssl' '--with-pam' '--with-krb5' '--with-gssapi'
> '--with-includes=/usr/include' '--with-libraries=/usr/lib64'
> '--enable-nls' '--with-ossp-uuid' '--with-libxml' '--with-libxslt'
> '--with-ldap' '--with-system-tzdata=/usr/share/zoneinfo'
> '--sysconfdir=/etc/sysconfig/pgsql' '--docdir=/usr/share/doc'
> 'CFLAGS=-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions
> -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic
> -I/usr/include/et' 'CPPFLAGS= -I/usr/include/et'
> CC = gcc
> CPPFLAGS = -I/usr/include/et -D_GNU_SOURCE -I/usr/include/libxml2
> -I/usr/include
> CFLAGS = -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions
> -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic
> -I/usr/include/et -Wall -Wmissing-prototypes -Wpointer-arith
> -Wdeclaration-after-statement -Wendif-labels -Wformat-security
> -fno-strict-aliasing -fwrapv
> CFLAGS_SL = -fpic
> LDFLAGS = -L/usr/lib64
> LDFLAGS_EX =
> LDFLAGS_SL =
> LIBS = -lpgport -lxslt -lxml2 -lpam -lssl -lcrypto -lgssapi_krb5 -lz
> -lreadline -ltermcap -lcrypt -ldl -lm
> VERSION = PostgreSQL 9.1.6
> 
> 
> 
> 
> *Jeff Lake*
> MichiganWxSystem 
> AllisonHouse 
> GRLevelXStuff 
> On 10/18/2012 17:43, Bborie Park wrote:
>> I'm going to need some background regarding your PostgreSQL installation.
>>
>> 1. Are there multiple instances of PostgreSQL installed?
>>
>> 2. What version are you running?
>>
>> 3. What is the output of pg_config?  Specifically, "LIBDIR".
>>
>> Since the error states that ld can't find libpq, something is up with
>> the environment.  That probably explains why you had issues with
>> "--without-raster" and errors happened when applying postgis.sql.
>>
>> -bborie
>>
>> On 10/18/2012 02:37 PM, Jeff Lake wrote:
>>> the log doesnt show it,
>>> but
>>>
>>> #make > make.log
>>> Can't fetch local revision (neither .svn nor .git found)
>>> Not updating existing rev file at 9979
>>> /usr/bin/ld: cannot find -lpq
>>> collect2: ld returned 1 exit status
>>> make[2]: *** [raster2pgsql] Error 1
>>> make[1]: *** [rtloader] Error 2
>>> make: *** [all] Error 1
>>>
>>>
>>>
>>>
>>> *Jeff Lake*
>>> MichiganWxSystem 
>>> AllisonHouse 
>>> GRLevelXStuff 
>>> On 10/18/2012 17:22, Bborie Park wrote:
 Your initial email message indicated an error in the "raster/loader"
 make step but that step has no errors in the make.log (bottom of the
 file).

 -bborie

 On 10/18/2012 02:14 PM, Jeff Lake wrote:
> Yes I did ..
>
> #vim /etc/ld.so.conf
> include /etc/ld.so.conf.d/*.conf
>
>
> #dir /etc/ld.so.conf.d
> atlas-x86_64.conf kernelcap-2.6.18-308.16.1.el5.conf 
> mysql-x86_64.conf
> xulrunner-32.conf
> kernelcap-2.6.18-308.13.1.el5.conf mysqlclient15-x86_64.conf
> postgresql-pgdg-libs.conf xulrunner-64.conf
>
> #vim postgresql-pgdg-libs.conf
> /usr/pgsql-9.1/lib
>
> here is log files of configure and make
>
> http://www2.michiganwxsystem.net/configure.log
> http://www2.michiganwxsystem.net/make.log
>
>
>
>
>
>
>
>
> *Jeff Lake*
> MichiganWxSystem 
> AllisonHouse 
> GRLevelXStuff 
> On 10/18/2012 11:33, Bborie Park wrote:
>> Did you run "ldconfig" after adding the lib path to ld.so.conf?
>>
>> -bborie
>>
>> On 10/18/2012 08:20 AM, Jeff Lake wrote:
>>> Well that sounded promising
>>> but no joy,
>>> even tried  --without-raster
>>> and got error's galore when I tried to apply postgis.sql to my
>>> tables
>>>
>>>
>>>
>>> *Jeff Lake*
>>> MichiganWxSystem 
>>> AllisonHouse

Re: [postgis-users] PostGIS 2 RPM

2012-10-18 Thread Devrim GÜNDÜZ


Hi,

On Thu, 2012-10-18 at 09:09 -0400, Jeff Lake wrote:
> Entering directory `/postgis-2.0.1/raster/loader'
> /bin/sh ../../libtool --mode=link gcc -g -O2  -fPIC -DPIC  -Wall 
> -Wmissing-prototypes -I../rt_core -I../../liblwgeom
> -I/usr/local/include 
> -I/usr/local/include   raster2pgsql.o ../rt_core/librtcore.a 
> ../rt_core/librtcore.a ../../liblwgeom/liblwgeom.la -L/usr/local/lib 
> -lgdal -L/usr/local/lib -lgeos_c  -lc -lm -o raster2pgsql
> libtool: link: gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes 
> -I../rt_core -I../../liblwgeom -I/usr/local/include
> -I/usr/local/include 
> raster2pgsql.o -o .libs/raster2pgsql ../rt_core/librtcore.a 
> ../../liblwgeom/.libs/liblwgeom.so -L/usr/local/lib 
> /usr/local/lib/libproj.so /usr/local/lib/libgdal.so -L/usr/lib64 
> -L/usr/kerberos/lib64 -L/usr/lib64/mysql -lsqlite3 
> /usr/lib64/libexpat.so -lgif -ljpeg -lpng -lpq -lcurl -lgssapi_krb5 
> -lkrb5 -lk5crypto -lcom_err -lidn -lz -lmysqlclient -lpthread -lrt
> -lssl 
> -lcrypto -ldl /usr/local/lib/libgeos_c.so /usr/local/lib/libgeos.so
> -lc 
> -lm -Wl,-rpath -Wl,/usr/local/lib -Wl,-rpath -Wl,/usr/lib64
> /usr/bin/ld: cannot find -lpq

RPM packager is speaking:

IIRC this error does not mean that it is not finding the PostgreSQL
libs, but one of the dependencies are not built with PostgreSQL support
(which I don't remember now).

Please upgrade to RHEL6 -- it will be less painful as compared to trying
to build PostGIS 2.0 with raster support.

Regards,

>  
-- 
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz


signature.asc
Description: This is a digitally signed message part
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] PostGIS 2 RPM

2012-10-18 Thread Jeff Lake


well I guess I'm stuck at 1.5.5

this server is relied on to much to be taken offline for OS upgrade

*Jeff Lake*
MichiganWxSystem 
AllisonHouse 
GRLevelXStuff 
On 10/18/2012 19:26, Devrim GÜNDÜZ wrote:

Hi,

On Thu, 2012-10-18 at 09:09 -0400, Jeff Lake wrote:

Entering directory `/postgis-2.0.1/raster/loader'
/bin/sh ../../libtool --mode=link gcc -g -O2  -fPIC -DPIC  -Wall
-Wmissing-prototypes -I../rt_core -I../../liblwgeom
-I/usr/local/include
-I/usr/local/include   raster2pgsql.o ../rt_core/librtcore.a
../rt_core/librtcore.a ../../liblwgeom/liblwgeom.la -L/usr/local/lib
-lgdal -L/usr/local/lib -lgeos_c  -lc -lm -o raster2pgsql
libtool: link: gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes
-I../rt_core -I../../liblwgeom -I/usr/local/include
-I/usr/local/include
raster2pgsql.o -o .libs/raster2pgsql ../rt_core/librtcore.a
../../liblwgeom/.libs/liblwgeom.so -L/usr/local/lib
/usr/local/lib/libproj.so /usr/local/lib/libgdal.so -L/usr/lib64
-L/usr/kerberos/lib64 -L/usr/lib64/mysql -lsqlite3
/usr/lib64/libexpat.so -lgif -ljpeg -lpng -lpq -lcurl -lgssapi_krb5
-lkrb5 -lk5crypto -lcom_err -lidn -lz -lmysqlclient -lpthread -lrt
-lssl
-lcrypto -ldl /usr/local/lib/libgeos_c.so /usr/local/lib/libgeos.so
-lc
-lm -Wl,-rpath -Wl,/usr/local/lib -Wl,-rpath -Wl,/usr/lib64
/usr/bin/ld: cannot find -lpq

RPM packager is speaking:

IIRC this error does not mean that it is not finding the PostgreSQL
libs, but one of the dependencies are not built with PostgreSQL support
(which I don't remember now).

Please upgrade to RHEL6 -- it will be less painful as compared to trying
to build PostGIS 2.0 with raster support.

Regards,

  



___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] PostGIS 2 RPM

2012-10-18 Thread Bborie Park

Before you give up, can you run "ldd" on libpq?  Also, what OS and version?

-bborie

On Thu, Oct 18, 2012 at 6:51 PM, Jeff Lake  wrote:
> well I guess I'm stuck at 1.5.5
>
> this server is relied on to much to be taken offline for OS upgrade
>
>
> Jeff Lake
> MichiganWxSystem
> AllisonHouse
> GRLevelXStuff
> On 10/18/2012 19:26, Devrim GÜNDÜZ wrote:
>
> Hi,
>
> On Thu, 2012-10-18 at 09:09 -0400, Jeff Lake wrote:
>
> Entering directory `/postgis-2.0.1/raster/loader'
> /bin/sh ../../libtool --mode=link gcc -g -O2  -fPIC -DPIC  -Wall
> -Wmissing-prototypes -I../rt_core -I../../liblwgeom
> -I/usr/local/include
> -I/usr/local/include   raster2pgsql.o ../rt_core/librtcore.a
> ../rt_core/librtcore.a ../../liblwgeom/liblwgeom.la -L/usr/local/lib
> -lgdal -L/usr/local/lib -lgeos_c  -lc -lm -o raster2pgsql
> libtool: link: gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes
> -I../rt_core -I../../liblwgeom -I/usr/local/include
> -I/usr/local/include
> raster2pgsql.o -o .libs/raster2pgsql ../rt_core/librtcore.a
> ../../liblwgeom/.libs/liblwgeom.so -L/usr/local/lib
> /usr/local/lib/libproj.so /usr/local/lib/libgdal.so -L/usr/lib64
> -L/usr/kerberos/lib64 -L/usr/lib64/mysql -lsqlite3
> /usr/lib64/libexpat.so -lgif -ljpeg -lpng -lpq -lcurl -lgssapi_krb5
> -lkrb5 -lk5crypto -lcom_err -lidn -lz -lmysqlclient -lpthread -lrt
> -lssl
> -lcrypto -ldl /usr/local/lib/libgeos_c.so /usr/local/lib/libgeos.so
> -lc
> -lm -Wl,-rpath -Wl,/usr/local/lib -Wl,-rpath -Wl,/usr/lib64
> /usr/bin/ld: cannot find -lpq
>
> RPM packager is speaking:
>
> IIRC this error does not mean that it is not finding the PostgreSQL
> libs, but one of the dependencies are not built with PostgreSQL support
> (which I don't remember now).
>
> Please upgrade to RHEL6 -- it will be less painful as compared to trying
> to build PostGIS 2.0 with raster support.
>
> Regards,
>
>
>
>
>
> ___
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
> ___
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-- 
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkp...@ucdavis.edu
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] PostGIS 2 RPM

2012-10-18 Thread Jeff Lake


[root@ldm /]# ldd /usr/pgsql-9.1/lib/libpq.so.5.4
linux-vdso.so.1 =>  (0x7fff68bfd000)
libssl.so.6 => /lib64/libssl.so.6 (0x2acdf6791000)
libcrypto.so.6 => /lib64/libcrypto.so.6 (0x2acdf69de000)
libgssapi_krb5.so.2 => /usr/lib64/libgssapi_krb5.so.2 
(0x2acdf6d2f000)

libcrypt.so.1 => /lib64/libcrypt.so.1 (0x2acdf6f5d000)
libldap_r-2.3.so.0 => /usr/lib64/libldap_r-2.3.so.0 
(0x2acdf7196000)

libpthread.so.0 => /lib64/libpthread.so.0 (0x2acdf73e)
libc.so.6 => /lib64/libc.so.6 (0x2acdf75fb000)
libkrb5.so.3 => /usr/lib64/libkrb5.so.3 (0x2acdf7953000)
libcom_err.so.2 => /lib64/libcom_err.so.2 (0x2acdf7be8000)
libk5crypto.so.3 => /usr/lib64/libk5crypto.so.3 
(0x2acdf7dea000)

libdl.so.2 => /lib64/libdl.so.2 (0x2acdf801)
libz.so.1 => /lib64/libz.so.1 (0x2acdf8214000)
libkrb5support.so.0 => /usr/lib64/libkrb5support.so.0 
(0x2acdf8428000)

libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x2acdf8631000)
libresolv.so.2 => /lib64/libresolv.so.2 (0x2acdf8833000)
liblber-2.3.so.0 => /usr/lib64/liblber-2.3.so.0 
(0x2acdf8a48000)

libsasl2.so.2 => /usr/lib64/libsasl2.so.2 (0x2acdf8c57000)
/lib64/ld-linux-x86-64.so.2 (0x003f2d80)
libselinux.so.1 => /lib64/libselinux.so.1 (0x2acdf8e7)
libsepol.so.1 => /lib64/libsepol.so.1 (0x2acdf9089000)
[root@ldm /]# ldd /usr/pgsql-9.1/lib/libpq.so
linux-vdso.so.1 =>  (0x7fff319fd000)
libssl.so.6 => /lib64/libssl.so.6 (0x2aff2071)
libcrypto.so.6 => /lib64/libcrypto.so.6 (0x2aff2095d000)
libgssapi_krb5.so.2 => /usr/lib64/libgssapi_krb5.so.2 
(0x2aff20cae000)

libcrypt.so.1 => /lib64/libcrypt.so.1 (0x2aff20edc000)
libldap_r-2.3.so.0 => /usr/lib64/libldap_r-2.3.so.0 
(0x2aff21115000)

libpthread.so.0 => /lib64/libpthread.so.0 (0x2aff2135f000)
libc.so.6 => /lib64/libc.so.6 (0x2aff2157a000)
libkrb5.so.3 => /usr/lib64/libkrb5.so.3 (0x2aff218d2000)
libcom_err.so.2 => /lib64/libcom_err.so.2 (0x2aff21b67000)
libk5crypto.so.3 => /usr/lib64/libk5crypto.so.3 
(0x2aff21d69000)

libdl.so.2 => /lib64/libdl.so.2 (0x2aff21f8f000)
libz.so.1 => /lib64/libz.so.1 (0x2aff22193000)
libkrb5support.so.0 => /usr/lib64/libkrb5support.so.0 
(0x2aff223a7000)

libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x2aff225b)
libresolv.so.2 => /lib64/libresolv.so.2 (0x2aff227b2000)
liblber-2.3.so.0 => /usr/lib64/liblber-2.3.so.0 
(0x2aff229c7000)

libsasl2.so.2 => /usr/lib64/libsasl2.so.2 (0x2aff22bd6000)
/lib64/ld-linux-x86-64.so.2 (0x003f2d80)
libselinux.so.1 => /lib64/libselinux.so.1 (0x2aff22def000)
libsepol.so.1 => /lib64/libsepol.so.1 (0x2aff23008000)


CentOS 5.8 64bit
*Jeff Lake*
MichiganWxSystem 
AllisonHouse 
GRLevelXStuff 
On 10/18/2012 22:58, Bborie Park wrote:

Before you give up, can you run "ldd" on libpq?  Also, what OS and version?

-bborie

On Thu, Oct 18, 2012 at 6:51 PM, Jeff Lake  wrote:

well I guess I'm stuck at 1.5.5

this server is relied on to much to be taken offline for OS upgrade


Jeff Lake
MichiganWxSystem
AllisonHouse
GRLevelXStuff
On 10/18/2012 19:26, Devrim GÜNDÜZ wrote:

Hi,

On Thu, 2012-10-18 at 09:09 -0400, Jeff Lake wrote:

Entering directory `/postgis-2.0.1/raster/loader'
/bin/sh ../../libtool --mode=link gcc -g -O2  -fPIC -DPIC  -Wall
-Wmissing-prototypes -I../rt_core -I../../liblwgeom
-I/usr/local/include
-I/usr/local/include   raster2pgsql.o ../rt_core/librtcore.a
../rt_core/librtcore.a ../../liblwgeom/liblwgeom.la -L/usr/local/lib
-lgdal -L/usr/local/lib -lgeos_c  -lc -lm -o raster2pgsql
libtool: link: gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes
-I../rt_core -I../../liblwgeom -I/usr/local/include
-I/usr/local/include
raster2pgsql.o -o .libs/raster2pgsql ../rt_core/librtcore.a
../../liblwgeom/.libs/liblwgeom.so -L/usr/local/lib
/usr/local/lib/libproj.so /usr/local/lib/libgdal.so -L/usr/lib64
-L/usr/kerberos/lib64 -L/usr/lib64/mysql -lsqlite3
/usr/lib64/libexpat.so -lgif -ljpeg -lpng -lpq -lcurl -lgssapi_krb5
-lkrb5 -lk5crypto -lcom_err -lidn -lz -lmysqlclient -lpthread -lrt
-lssl
-lcrypto -ldl /usr/local/lib/libgeos_c.so /usr/local/lib/libgeos.so
-lc
-lm -Wl,-rpath -Wl,/usr/local/lib -Wl,-rpath -Wl,/usr/lib64
/usr/bin/ld: cannot find -lpq

RPM packager is speaking:

IIRC this error does not mean that it is not finding the PostgreSQL
libs, but one of the dependencies are not built with PostgreSQL support
(which I don't remember now).

Please upgrade to RHEL6 -- it will be less painful as compared to trying
to build PostGIS 2.0 with raster support.

Regards,





___

Re: [postgis-users] PostGIS 2 RPM

2012-10-19 Thread Bborie Park

Heh.  ldd looks good.  I suspect the only possibility is to set up a
similar environment using CentOS 5.8 and see what happens.

-bborie

On 10/18/2012 08:19 PM, Jeff Lake wrote:
> [root@ldm /]# ldd /usr/pgsql-9.1/lib/libpq.so.5.4
> linux-vdso.so.1 =>  (0x7fff68bfd000)
> libssl.so.6 => /lib64/libssl.so.6 (0x2acdf6791000)
> libcrypto.so.6 => /lib64/libcrypto.so.6 (0x2acdf69de000)
> libgssapi_krb5.so.2 => /usr/lib64/libgssapi_krb5.so.2
> (0x2acdf6d2f000)
> libcrypt.so.1 => /lib64/libcrypt.so.1 (0x2acdf6f5d000)
> libldap_r-2.3.so.0 => /usr/lib64/libldap_r-2.3.so.0
> (0x2acdf7196000)
> libpthread.so.0 => /lib64/libpthread.so.0 (0x2acdf73e)
> libc.so.6 => /lib64/libc.so.6 (0x2acdf75fb000)
> libkrb5.so.3 => /usr/lib64/libkrb5.so.3 (0x2acdf7953000)
> libcom_err.so.2 => /lib64/libcom_err.so.2 (0x2acdf7be8000)
> libk5crypto.so.3 => /usr/lib64/libk5crypto.so.3
> (0x2acdf7dea000)
> libdl.so.2 => /lib64/libdl.so.2 (0x2acdf801)
> libz.so.1 => /lib64/libz.so.1 (0x2acdf8214000)
> libkrb5support.so.0 => /usr/lib64/libkrb5support.so.0
> (0x2acdf8428000)
> libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x2acdf8631000)
> libresolv.so.2 => /lib64/libresolv.so.2 (0x2acdf8833000)
> liblber-2.3.so.0 => /usr/lib64/liblber-2.3.so.0
> (0x2acdf8a48000)
> libsasl2.so.2 => /usr/lib64/libsasl2.so.2 (0x2acdf8c57000)
> /lib64/ld-linux-x86-64.so.2 (0x003f2d80)
> libselinux.so.1 => /lib64/libselinux.so.1 (0x2acdf8e7)
> libsepol.so.1 => /lib64/libsepol.so.1 (0x2acdf9089000)
> [root@ldm /]# ldd /usr/pgsql-9.1/lib/libpq.so
> linux-vdso.so.1 =>  (0x7fff319fd000)
> libssl.so.6 => /lib64/libssl.so.6 (0x2aff2071)
> libcrypto.so.6 => /lib64/libcrypto.so.6 (0x2aff2095d000)
> libgssapi_krb5.so.2 => /usr/lib64/libgssapi_krb5.so.2
> (0x2aff20cae000)
> libcrypt.so.1 => /lib64/libcrypt.so.1 (0x2aff20edc000)
> libldap_r-2.3.so.0 => /usr/lib64/libldap_r-2.3.so.0
> (0x2aff21115000)
> libpthread.so.0 => /lib64/libpthread.so.0 (0x2aff2135f000)
> libc.so.6 => /lib64/libc.so.6 (0x2aff2157a000)
> libkrb5.so.3 => /usr/lib64/libkrb5.so.3 (0x2aff218d2000)
> libcom_err.so.2 => /lib64/libcom_err.so.2 (0x2aff21b67000)
> libk5crypto.so.3 => /usr/lib64/libk5crypto.so.3
> (0x2aff21d69000)
> libdl.so.2 => /lib64/libdl.so.2 (0x2aff21f8f000)
> libz.so.1 => /lib64/libz.so.1 (0x2aff22193000)
> libkrb5support.so.0 => /usr/lib64/libkrb5support.so.0
> (0x2aff223a7000)
> libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x2aff225b)
> libresolv.so.2 => /lib64/libresolv.so.2 (0x2aff227b2000)
> liblber-2.3.so.0 => /usr/lib64/liblber-2.3.so.0
> (0x2aff229c7000)
> libsasl2.so.2 => /usr/lib64/libsasl2.so.2 (0x2aff22bd6000)
> /lib64/ld-linux-x86-64.so.2 (0x003f2d80)
> libselinux.so.1 => /lib64/libselinux.so.1 (0x2aff22def000)
> libsepol.so.1 => /lib64/libsepol.so.1 (0x2aff23008000)
> 
> 
> CentOS 5.8 64bit
> *Jeff Lake*
> MichiganWxSystem 
> AllisonHouse 
> GRLevelXStuff 
> On 10/18/2012 22:58, Bborie Park wrote:
>> Before you give up, can you run "ldd" on libpq?  Also, what OS and
>> version?
>>
>> -bborie
>>
>> On Thu, Oct 18, 2012 at 6:51 PM, Jeff Lake 
>> wrote:
>>> well I guess I'm stuck at 1.5.5
>>>
>>> this server is relied on to much to be taken offline for OS upgrade
>>>
>>>
>>> Jeff Lake
>>> MichiganWxSystem
>>> AllisonHouse
>>> GRLevelXStuff
>>> On 10/18/2012 19:26, Devrim GÜNDÜZ wrote:
>>>
>>> Hi,
>>>
>>> On Thu, 2012-10-18 at 09:09 -0400, Jeff Lake wrote:
>>>
>>> Entering directory `/postgis-2.0.1/raster/loader'
>>> /bin/sh ../../libtool --mode=link gcc -g -O2  -fPIC -DPIC  -Wall
>>> -Wmissing-prototypes -I../rt_core -I../../liblwgeom
>>> -I/usr/local/include
>>> -I/usr/local/include   raster2pgsql.o ../rt_core/librtcore.a
>>> ../rt_core/librtcore.a ../../liblwgeom/liblwgeom.la -L/usr/local/lib
>>> -lgdal -L/usr/local/lib -lgeos_c  -lc -lm -o raster2pgsql
>>> libtool: link: gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes
>>> -I../rt_core -I../../liblwgeom -I/usr/local/include
>>> -I/usr/local/include
>>> raster2pgsql.o -o .libs/raster2pgsql ../rt_core/librtcore.a
>>> ../../liblwgeom/.libs/liblwgeom.so -L/usr/local/lib
>>> /usr/local/lib/libproj.so /usr/local/lib/libgdal.so -L/usr/lib64
>>> -L/usr/kerberos/lib64 -L/usr/lib64/mysql -lsqlite3
>>> /usr/lib64/libexpat.so -lgif -ljpeg -lpng -lpq -lcurl -lgssapi_krb5
>>> -lkrb5 -lk5crypto -lcom_err -lidn -lz -lmysqlclient -lpthread -lrt
>>> -lssl
>>> -lcrypto -ldl /usr/local/lib/libgeos_c.so /usr/local/lib/libgeos.so
>>> -

Re: [postgis-users] PostGIS 2 RPM

2012-10-19 Thread Jeff Lake


There is something messed up
I see this in configure
'checking for PQserverVersion in -lpq... yes'

but yet make complains it can't find -lpq
'/usr/bin/ld: cannot find -lpq
collect2: ld returned 1 exit status'


huh 



*Jeff Lake*
MichiganWxSystem 
AllisonHouse 
GRLevelXStuff 
On 10/19/2012 12:16, Bborie Park wrote:

Heh.  ldd looks good.  I suspect the only possibility is to set up a
similar environment using CentOS 5.8 and see what happens.

-bborie

On 10/18/2012 08:19 PM, Jeff Lake wrote:

[root@ldm /]# ldd /usr/pgsql-9.1/lib/libpq.so.5.4
 linux-vdso.so.1 =>  (0x7fff68bfd000)
 libssl.so.6 => /lib64/libssl.so.6 (0x2acdf6791000)
 libcrypto.so.6 => /lib64/libcrypto.so.6 (0x2acdf69de000)
 libgssapi_krb5.so.2 => /usr/lib64/libgssapi_krb5.so.2
(0x2acdf6d2f000)
 libcrypt.so.1 => /lib64/libcrypt.so.1 (0x2acdf6f5d000)
 libldap_r-2.3.so.0 => /usr/lib64/libldap_r-2.3.so.0
(0x2acdf7196000)
 libpthread.so.0 => /lib64/libpthread.so.0 (0x2acdf73e)
 libc.so.6 => /lib64/libc.so.6 (0x2acdf75fb000)
 libkrb5.so.3 => /usr/lib64/libkrb5.so.3 (0x2acdf7953000)
 libcom_err.so.2 => /lib64/libcom_err.so.2 (0x2acdf7be8000)
 libk5crypto.so.3 => /usr/lib64/libk5crypto.so.3
(0x2acdf7dea000)
 libdl.so.2 => /lib64/libdl.so.2 (0x2acdf801)
 libz.so.1 => /lib64/libz.so.1 (0x2acdf8214000)
 libkrb5support.so.0 => /usr/lib64/libkrb5support.so.0
(0x2acdf8428000)
 libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x2acdf8631000)
 libresolv.so.2 => /lib64/libresolv.so.2 (0x2acdf8833000)
 liblber-2.3.so.0 => /usr/lib64/liblber-2.3.so.0
(0x2acdf8a48000)
 libsasl2.so.2 => /usr/lib64/libsasl2.so.2 (0x2acdf8c57000)
 /lib64/ld-linux-x86-64.so.2 (0x003f2d80)
 libselinux.so.1 => /lib64/libselinux.so.1 (0x2acdf8e7)
 libsepol.so.1 => /lib64/libsepol.so.1 (0x2acdf9089000)
[root@ldm /]# ldd /usr/pgsql-9.1/lib/libpq.so
 linux-vdso.so.1 =>  (0x7fff319fd000)
 libssl.so.6 => /lib64/libssl.so.6 (0x2aff2071)
 libcrypto.so.6 => /lib64/libcrypto.so.6 (0x2aff2095d000)
 libgssapi_krb5.so.2 => /usr/lib64/libgssapi_krb5.so.2
(0x2aff20cae000)
 libcrypt.so.1 => /lib64/libcrypt.so.1 (0x2aff20edc000)
 libldap_r-2.3.so.0 => /usr/lib64/libldap_r-2.3.so.0
(0x2aff21115000)
 libpthread.so.0 => /lib64/libpthread.so.0 (0x2aff2135f000)
 libc.so.6 => /lib64/libc.so.6 (0x2aff2157a000)
 libkrb5.so.3 => /usr/lib64/libkrb5.so.3 (0x2aff218d2000)
 libcom_err.so.2 => /lib64/libcom_err.so.2 (0x2aff21b67000)
 libk5crypto.so.3 => /usr/lib64/libk5crypto.so.3
(0x2aff21d69000)
 libdl.so.2 => /lib64/libdl.so.2 (0x2aff21f8f000)
 libz.so.1 => /lib64/libz.so.1 (0x2aff22193000)
 libkrb5support.so.0 => /usr/lib64/libkrb5support.so.0
(0x2aff223a7000)
 libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x2aff225b)
 libresolv.so.2 => /lib64/libresolv.so.2 (0x2aff227b2000)
 liblber-2.3.so.0 => /usr/lib64/liblber-2.3.so.0
(0x2aff229c7000)
 libsasl2.so.2 => /usr/lib64/libsasl2.so.2 (0x2aff22bd6000)
 /lib64/ld-linux-x86-64.so.2 (0x003f2d80)
 libselinux.so.1 => /lib64/libselinux.so.1 (0x2aff22def000)
 libsepol.so.1 => /lib64/libsepol.so.1 (0x2aff23008000)


CentOS 5.8 64bit
*Jeff Lake*
MichiganWxSystem 
AllisonHouse 
GRLevelXStuff 
On 10/18/2012 22:58, Bborie Park wrote:

Before you give up, can you run "ldd" on libpq?  Also, what OS and
version?

-bborie

On Thu, Oct 18, 2012 at 6:51 PM, Jeff Lake 
wrote:

well I guess I'm stuck at 1.5.5

this server is relied on to much to be taken offline for OS upgrade


Jeff Lake
MichiganWxSystem
AllisonHouse
GRLevelXStuff
On 10/18/2012 19:26, Devrim GÜNDÜZ wrote:

Hi,

On Thu, 2012-10-18 at 09:09 -0400, Jeff Lake wrote:

Entering directory `/postgis-2.0.1/raster/loader'
/bin/sh ../../libtool --mode=link gcc -g -O2  -fPIC -DPIC  -Wall
-Wmissing-prototypes -I../rt_core -I../../liblwgeom
-I/usr/local/include
-I/usr/local/include   raster2pgsql.o ../rt_core/librtcore.a
../rt_core/librtcore.a ../../liblwgeom/liblwgeom.la -L/usr/local/lib
-lgdal -L/usr/local/lib -lgeos_c  -lc -lm -o raster2pgsql
libtool: link: gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes
-I../rt_core -I../../liblwgeom -I/usr/local/include
-I/usr/local/include
raster2pgsql.o -o .libs/raster2pgsql ../rt_core/librtcore.a
../../liblwgeom/.libs/liblwgeom.so -L/usr/local/lib
/usr/local/lib/libproj.so /usr/local/lib/libgdal.so -L/usr/lib64
-L/usr/kerberos/lib64 -L/usr/lib64/mysql -lsqlite3
/usr/lib64/libexpat.s

Re: [postgis-users] PostGIS 2 RPM

2012-10-19 Thread Bborie Park

Yeah.  I noticed that as well.  I took a look at my config.log and it
looked fine.  You may want to check your config.log as well.

-bborie

On 10/19/2012 09:34 AM, Jeff Lake wrote:
> There is something messed up
> I see this in configure
> 'checking for PQserverVersion in -lpq... yes'
> 
> but yet make complains it can't find -lpq
> '/usr/bin/ld: cannot find -lpq
> collect2: ld returned 1 exit status'
> 
> 
> huh 
> 
> 
> 
> *Jeff Lake*
> MichiganWxSystem 
> AllisonHouse 
> GRLevelXStuff 
> On 10/19/2012 12:16, Bborie Park wrote:
>> Heh.  ldd looks good.  I suspect the only possibility is to set up a
>> similar environment using CentOS 5.8 and see what happens.
>>
>> -bborie
>>
>> On 10/18/2012 08:19 PM, Jeff Lake wrote:
>>> [root@ldm /]# ldd /usr/pgsql-9.1/lib/libpq.so.5.4
>>>  linux-vdso.so.1 =>  (0x7fff68bfd000)
>>>  libssl.so.6 => /lib64/libssl.so.6 (0x2acdf6791000)
>>>  libcrypto.so.6 => /lib64/libcrypto.so.6 (0x2acdf69de000)
>>>  libgssapi_krb5.so.2 => /usr/lib64/libgssapi_krb5.so.2
>>> (0x2acdf6d2f000)
>>>  libcrypt.so.1 => /lib64/libcrypt.so.1 (0x2acdf6f5d000)
>>>  libldap_r-2.3.so.0 => /usr/lib64/libldap_r-2.3.so.0
>>> (0x2acdf7196000)
>>>  libpthread.so.0 => /lib64/libpthread.so.0 (0x2acdf73e)
>>>  libc.so.6 => /lib64/libc.so.6 (0x2acdf75fb000)
>>>  libkrb5.so.3 => /usr/lib64/libkrb5.so.3 (0x2acdf7953000)
>>>  libcom_err.so.2 => /lib64/libcom_err.so.2 (0x2acdf7be8000)
>>>  libk5crypto.so.3 => /usr/lib64/libk5crypto.so.3
>>> (0x2acdf7dea000)
>>>  libdl.so.2 => /lib64/libdl.so.2 (0x2acdf801)
>>>  libz.so.1 => /lib64/libz.so.1 (0x2acdf8214000)
>>>  libkrb5support.so.0 => /usr/lib64/libkrb5support.so.0
>>> (0x2acdf8428000)
>>>  libkeyutils.so.1 => /lib64/libkeyutils.so.1
>>> (0x2acdf8631000)
>>>  libresolv.so.2 => /lib64/libresolv.so.2 (0x2acdf8833000)
>>>  liblber-2.3.so.0 => /usr/lib64/liblber-2.3.so.0
>>> (0x2acdf8a48000)
>>>  libsasl2.so.2 => /usr/lib64/libsasl2.so.2 (0x2acdf8c57000)
>>>  /lib64/ld-linux-x86-64.so.2 (0x003f2d80)
>>>  libselinux.so.1 => /lib64/libselinux.so.1 (0x2acdf8e7)
>>>  libsepol.so.1 => /lib64/libsepol.so.1 (0x2acdf9089000)
>>> [root@ldm /]# ldd /usr/pgsql-9.1/lib/libpq.so
>>>  linux-vdso.so.1 =>  (0x7fff319fd000)
>>>  libssl.so.6 => /lib64/libssl.so.6 (0x2aff2071)
>>>  libcrypto.so.6 => /lib64/libcrypto.so.6 (0x2aff2095d000)
>>>  libgssapi_krb5.so.2 => /usr/lib64/libgssapi_krb5.so.2
>>> (0x2aff20cae000)
>>>  libcrypt.so.1 => /lib64/libcrypt.so.1 (0x2aff20edc000)
>>>  libldap_r-2.3.so.0 => /usr/lib64/libldap_r-2.3.so.0
>>> (0x2aff21115000)
>>>  libpthread.so.0 => /lib64/libpthread.so.0 (0x2aff2135f000)
>>>  libc.so.6 => /lib64/libc.so.6 (0x2aff2157a000)
>>>  libkrb5.so.3 => /usr/lib64/libkrb5.so.3 (0x2aff218d2000)
>>>  libcom_err.so.2 => /lib64/libcom_err.so.2 (0x2aff21b67000)
>>>  libk5crypto.so.3 => /usr/lib64/libk5crypto.so.3
>>> (0x2aff21d69000)
>>>  libdl.so.2 => /lib64/libdl.so.2 (0x2aff21f8f000)
>>>  libz.so.1 => /lib64/libz.so.1 (0x2aff22193000)
>>>  libkrb5support.so.0 => /usr/lib64/libkrb5support.so.0
>>> (0x2aff223a7000)
>>>  libkeyutils.so.1 => /lib64/libkeyutils.so.1
>>> (0x2aff225b)
>>>  libresolv.so.2 => /lib64/libresolv.so.2 (0x2aff227b2000)
>>>  liblber-2.3.so.0 => /usr/lib64/liblber-2.3.so.0
>>> (0x2aff229c7000)
>>>  libsasl2.so.2 => /usr/lib64/libsasl2.so.2 (0x2aff22bd6000)
>>>  /lib64/ld-linux-x86-64.so.2 (0x003f2d80)
>>>  libselinux.so.1 => /lib64/libselinux.so.1 (0x2aff22def000)
>>>  libsepol.so.1 => /lib64/libsepol.so.1 (0x2aff23008000)
>>>
>>>
>>> CentOS 5.8 64bit
>>> *Jeff Lake*
>>> MichiganWxSystem 
>>> AllisonHouse 
>>> GRLevelXStuff 
>>> On 10/18/2012 22:58, Bborie Park wrote:
 Before you give up, can you run "ldd" on libpq?  Also, what OS and
 version?

 -bborie

 On Thu, Oct 18, 2012 at 6:51 PM, Jeff Lake 
 wrote:
> well I guess I'm stuck at 1.5.5
>
> this server is relied on to much to be taken offline for OS upgrade
>
>
> Jeff Lake
> MichiganWxSystem
> AllisonHouse
> GRLevelXStuff
> On 10/18/2012 19:26, Devrim GÜNDÜZ wrote:
>
> Hi,
>
> On Thu, 2012-10-18 at 09:09 -0400, Jeff Lake wrote:
>
> Entering directory `/postgis-2.0.1/raster/loader'
> /bin/sh ../../libtool --mode=link gcc -g -O2  -fPIC -DPIC  -Wall
> -Wmissing-prototypes -I../rt_c

Re: [postgis-users] PostGIS 2 RPM

2012-10-19 Thread Bborie Park

Oh yeah.  Did you trying running make like the following?

LD_LIBRARY_PATH=/usr/pgsql-9.1/lib make

Another approach is to run just "make" in the base directory.  Once it
fails, go into raster/loader and run the above "make".  That way we can
focus on just that step.

-bborie

On 10/19/2012 09:34 AM, Jeff Lake wrote:
> There is something messed up
> I see this in configure
> 'checking for PQserverVersion in -lpq... yes'
> 
> but yet make complains it can't find -lpq
> '/usr/bin/ld: cannot find -lpq
> collect2: ld returned 1 exit status'
> 
> 
> huh 
> 
> 
> 
> *Jeff Lake*
> MichiganWxSystem 
> AllisonHouse 
> GRLevelXStuff 
> On 10/19/2012 12:16, Bborie Park wrote:
>> Heh.  ldd looks good.  I suspect the only possibility is to set up a
>> similar environment using CentOS 5.8 and see what happens.
>>
>> -bborie
>>
>> On 10/18/2012 08:19 PM, Jeff Lake wrote:
>>> [root@ldm /]# ldd /usr/pgsql-9.1/lib/libpq.so.5.4
>>>  linux-vdso.so.1 =>  (0x7fff68bfd000)
>>>  libssl.so.6 => /lib64/libssl.so.6 (0x2acdf6791000)
>>>  libcrypto.so.6 => /lib64/libcrypto.so.6 (0x2acdf69de000)
>>>  libgssapi_krb5.so.2 => /usr/lib64/libgssapi_krb5.so.2
>>> (0x2acdf6d2f000)
>>>  libcrypt.so.1 => /lib64/libcrypt.so.1 (0x2acdf6f5d000)
>>>  libldap_r-2.3.so.0 => /usr/lib64/libldap_r-2.3.so.0
>>> (0x2acdf7196000)
>>>  libpthread.so.0 => /lib64/libpthread.so.0 (0x2acdf73e)
>>>  libc.so.6 => /lib64/libc.so.6 (0x2acdf75fb000)
>>>  libkrb5.so.3 => /usr/lib64/libkrb5.so.3 (0x2acdf7953000)
>>>  libcom_err.so.2 => /lib64/libcom_err.so.2 (0x2acdf7be8000)
>>>  libk5crypto.so.3 => /usr/lib64/libk5crypto.so.3
>>> (0x2acdf7dea000)
>>>  libdl.so.2 => /lib64/libdl.so.2 (0x2acdf801)
>>>  libz.so.1 => /lib64/libz.so.1 (0x2acdf8214000)
>>>  libkrb5support.so.0 => /usr/lib64/libkrb5support.so.0
>>> (0x2acdf8428000)
>>>  libkeyutils.so.1 => /lib64/libkeyutils.so.1
>>> (0x2acdf8631000)
>>>  libresolv.so.2 => /lib64/libresolv.so.2 (0x2acdf8833000)
>>>  liblber-2.3.so.0 => /usr/lib64/liblber-2.3.so.0
>>> (0x2acdf8a48000)
>>>  libsasl2.so.2 => /usr/lib64/libsasl2.so.2 (0x2acdf8c57000)
>>>  /lib64/ld-linux-x86-64.so.2 (0x003f2d80)
>>>  libselinux.so.1 => /lib64/libselinux.so.1 (0x2acdf8e7)
>>>  libsepol.so.1 => /lib64/libsepol.so.1 (0x2acdf9089000)
>>> [root@ldm /]# ldd /usr/pgsql-9.1/lib/libpq.so
>>>  linux-vdso.so.1 =>  (0x7fff319fd000)
>>>  libssl.so.6 => /lib64/libssl.so.6 (0x2aff2071)
>>>  libcrypto.so.6 => /lib64/libcrypto.so.6 (0x2aff2095d000)
>>>  libgssapi_krb5.so.2 => /usr/lib64/libgssapi_krb5.so.2
>>> (0x2aff20cae000)
>>>  libcrypt.so.1 => /lib64/libcrypt.so.1 (0x2aff20edc000)
>>>  libldap_r-2.3.so.0 => /usr/lib64/libldap_r-2.3.so.0
>>> (0x2aff21115000)
>>>  libpthread.so.0 => /lib64/libpthread.so.0 (0x2aff2135f000)
>>>  libc.so.6 => /lib64/libc.so.6 (0x2aff2157a000)
>>>  libkrb5.so.3 => /usr/lib64/libkrb5.so.3 (0x2aff218d2000)
>>>  libcom_err.so.2 => /lib64/libcom_err.so.2 (0x2aff21b67000)
>>>  libk5crypto.so.3 => /usr/lib64/libk5crypto.so.3
>>> (0x2aff21d69000)
>>>  libdl.so.2 => /lib64/libdl.so.2 (0x2aff21f8f000)
>>>  libz.so.1 => /lib64/libz.so.1 (0x2aff22193000)
>>>  libkrb5support.so.0 => /usr/lib64/libkrb5support.so.0
>>> (0x2aff223a7000)
>>>  libkeyutils.so.1 => /lib64/libkeyutils.so.1
>>> (0x2aff225b)
>>>  libresolv.so.2 => /lib64/libresolv.so.2 (0x2aff227b2000)
>>>  liblber-2.3.so.0 => /usr/lib64/liblber-2.3.so.0
>>> (0x2aff229c7000)
>>>  libsasl2.so.2 => /usr/lib64/libsasl2.so.2 (0x2aff22bd6000)
>>>  /lib64/ld-linux-x86-64.so.2 (0x003f2d80)
>>>  libselinux.so.1 => /lib64/libselinux.so.1 (0x2aff22def000)
>>>  libsepol.so.1 => /lib64/libsepol.so.1 (0x2aff23008000)
>>>
>>>
>>> CentOS 5.8 64bit
>>> *Jeff Lake*
>>> MichiganWxSystem 
>>> AllisonHouse 
>>> GRLevelXStuff 
>>> On 10/18/2012 22:58, Bborie Park wrote:
 Before you give up, can you run "ldd" on libpq?  Also, what OS and
 version?

 -bborie

 On Thu, Oct 18, 2012 at 6:51 PM, Jeff Lake 
 wrote:
> well I guess I'm stuck at 1.5.5
>
> this server is relied on to much to be taken offline for OS upgrade
>
>
> Jeff Lake
> MichiganWxSystem
> AllisonHouse
> GRLevelXStuff
> On 10/18/2012 19:26, Devrim GÜNDÜZ wrote:
>
> Hi,
>
> On Thu, 2012-10-18 at 09:09 -0400, Jeff Lake wrote:
>
> Entering directory `

Re: [postgis-users] PostGIS 2 RPM

2012-10-19 Thread Jeff Lake


LD_LIBRARY_PATH=/usr/pgsql-9.1/lib make

same results  can't find -lpq



running make in raster/loader

/bin/sh ../../libtool --mode=link gcc -g -O2  -fPIC -DPIC  -Wall 
-Wmissing-prototypes -I../rt_core -I../../liblwgeom  -I/usr/local/include 
-I/usr/local/include   raster2pgsql.o ../rt_core/librtcore.a 
../rt_core/librtcore.a ../../liblwgeom/liblwgeom.la -L/usr/local/lib -lgdal 
-L/usr/local/lib -lgeos_c  -lc -lm -o raster2pgsql
libtool: link: gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes -I../rt_core 
-I../../liblwgeom -I/usr/local/include -I/usr/local/include raster2pgsql.o -o 
.libs/raster2pgsql  ../rt_core/librtcore.a ../../liblwgeom/.libs/liblwgeom.so 
-L/usr/local/lib /usr/local/lib/libproj.so /usr/local/lib/libgdal.so 
-L/usr/lib64 -L/usr/kerberos/lib64 -L/usr/lib64/mysql -lsqlite3 
/usr/lib64/libexpat.so -lgif -ljpeg -lpng -lpq -lcurl -lgssapi_krb5 -lkrb5 
-lk5crypto -lcom_err -lidn -lz -lmysqlclient -lpthread -lrt -lssl -lcrypto -ldl 
/usr/local/lib/libgeos_c.so /usr/local/lib/libgeos.so -lc -lm -Wl,-rpath 
-Wl,/usr/local/lib -Wl,-rpath -Wl,/usr/lib64
/usr/bin/ld: cannot find -lpq
collect2: ld returned 1 exit status
make: *** [raster2pgsql] Error 1


*Jeff Lake*
MichiganWxSystem 
AllisonHouse 
GRLevelXStuff 
On 10/19/2012 12:43, Bborie Park wrote:

LD_LIBRARY_PATH=/usr/pgsql-9.1/lib make


___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] PostGIS 2 RPM

2012-10-19 Thread Bborie Park

A ticket was made for this issue.

http://trac.osgeo.org/postgis/ticket/2057

>From digging at my dev box, I'm wondering if you can give me the output
from gdal-config...

gdal-config --dep-libs

Looking at libtool's debug output when linking raster2pgsql, the -lpq is
coming from GDAL's dependency...

-bborie

On 10/19/2012 10:02 AM, Jeff Lake wrote:
> LD_LIBRARY_PATH=/usr/pgsql-9.1/lib make
> 
> same results  can't find -lpq
> 
> 
> 
> running make in raster/loader
> 
> /bin/sh ../../libtool --mode=link gcc -g -O2  -fPIC -DPIC  -Wall
> -Wmissing-prototypes -I../rt_core -I../../liblwgeom 
> -I/usr/local/include -I/usr/local/include   raster2pgsql.o
> ../rt_core/librtcore.a ../rt_core/librtcore.a
> ../../liblwgeom/liblwgeom.la -L/usr/local/lib -lgdal -L/usr/local/lib
> -lgeos_c  -lc -lm -o raster2pgsql
> libtool: link: gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes
> -I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include
> raster2pgsql.o -o .libs/raster2pgsql  ../rt_core/librtcore.a
> ../../liblwgeom/.libs/liblwgeom.so -L/usr/local/lib
> /usr/local/lib/libproj.so /usr/local/lib/libgdal.so -L/usr/lib64
> -L/usr/kerberos/lib64 -L/usr/lib64/mysql -lsqlite3
> /usr/lib64/libexpat.so -lgif -ljpeg -lpng -lpq -lcurl -lgssapi_krb5
> -lkrb5 -lk5crypto -lcom_err -lidn -lz -lmysqlclient -lpthread -lrt -lssl
> -lcrypto -ldl /usr/local/lib/libgeos_c.so /usr/local/lib/libgeos.so -lc
> -lm -Wl,-rpath -Wl,/usr/local/lib -Wl,-rpath -Wl,/usr/lib64
> /usr/bin/ld: cannot find -lpq
> collect2: ld returned 1 exit status
> make: *** [raster2pgsql] Error 1
> 
> 
> *Jeff Lake*
> MichiganWxSystem 
> AllisonHouse 
> GRLevelXStuff 
> On 10/19/2012 12:43, Bborie Park wrote:
>> LD_LIBRARY_PATH=/usr/pgsql-9.1/lib make
> 
> 
> 
> 
> ___
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 

-- 
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkp...@ucdavis.edu
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] PostGIS 2 RPM

2012-10-19 Thread Jeff Lake


[root@ldm /]# gdal-config --dep-libs
-L/usr/lib64 -lgeos_c -lsqlite3 -lexpat -lgif -ljpeg -lpng -L/usr/lib64 
-lpq -lz -lpthread -lm -lrt -ldl -L/usr/kerberos/lib64 -lcurl -ldl 
-lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lidn -lssl -lcrypto -lz 
-L/usr/lib64/mysql -lmysqlclient -lpthread -lm -lrt -lssl -lcrypto -ldl







*Jeff Lake*
MichiganWxSystem 
AllisonHouse 
GRLevelXStuff 
On 10/19/2012 14:23, Bborie Park wrote:

gdal-config --dep-libs


___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] PostGIS 2 RPM

2012-10-19 Thread Bborie Park

Are the versions of GDAL and PostgreSQL from packages or ones you built?

Thanks for providing all the feedback... I'm trying to see what the best
way to fix this is.

-bborie

On 10/19/2012 11:31 AM, Jeff Lake wrote:
> [root@ldm /]# gdal-config --dep-libs
> -L/usr/lib64 -lgeos_c -lsqlite3 -lexpat -lgif -ljpeg -lpng -L/usr/lib64
> -lpq -lz -lpthread -lm -lrt -ldl -L/usr/kerberos/lib64 -lcurl -ldl
> -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lidn -lssl -lcrypto -lz
> -L/usr/lib64/mysql -lmysqlclient -lpthread -lm -lrt -lssl -lcrypto -ldl
> 
> 
> 
> 
> 
> 
> *Jeff Lake*
> MichiganWxSystem 
> AllisonHouse 
> GRLevelXStuff 
> On 10/19/2012 14:23, Bborie Park wrote:
>> gdal-config --dep-libs
> 
> 
> 
> 
> ___
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 

-- 
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkp...@ucdavis.edu
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] PostGIS 2 RPM

2012-10-19 Thread Jeff Lake


GDAL was built from source (1.9.1)

PostgreSQL (-contrib|-server|-devel|-libs) were built from RPM's (9.1.6)


*Jeff Lake*
MichiganWxSystem 
AllisonHouse 
GRLevelXStuff 
On 10/19/2012 14:36, Bborie Park wrote:

Are the versions of GDAL and PostgreSQL from packages or ones you built?

Thanks for providing all the feedback... I'm trying to see what the best
way to fix this is.

-bborie

On 10/19/2012 11:31 AM, Jeff Lake wrote:

[root@ldm /]# gdal-config --dep-libs
-L/usr/lib64 -lgeos_c -lsqlite3 -lexpat -lgif -ljpeg -lpng -L/usr/lib64
-lpq -lz -lpthread -lm -lrt -ldl -L/usr/kerberos/lib64 -lcurl -ldl
-lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lidn -lssl -lcrypto -lz
-L/usr/lib64/mysql -lmysqlclient -lpthread -lm -lrt -lssl -lcrypto -ldl






*Jeff Lake*
MichiganWxSystem 
AllisonHouse 
GRLevelXStuff 
On 10/19/2012 14:23, Bborie Park wrote:

gdal-config --dep-libs




___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users



___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] PostGIS 2 RPM

2012-10-19 Thread Bborie Park

Was GDAL built against that 9.1.6 RPM?  I've committed some changes for
2.0 branch in r10484 so feel free to use that.  That'll ame sure the
linking goes correctly.

I was expecting that your output of gdal-config --dep-libs would include
a -L to the your libpq since your libpq is in /usr/pgsql-9.1/lib/

-bborie

On 10/19/2012 11:44 AM, Jeff Lake wrote:
> GDAL was built from source (1.9.1)
> 
> PostgreSQL (-contrib|-server|-devel|-libs) were built from RPM's (9.1.6)
> 
> 
> *Jeff Lake*
> MichiganWxSystem 
> AllisonHouse 
> GRLevelXStuff 
> On 10/19/2012 14:36, Bborie Park wrote:
>> Are the versions of GDAL and PostgreSQL from packages or ones you built?
>>
>> Thanks for providing all the feedback... I'm trying to see what the best
>> way to fix this is.
>>
>> -bborie
>>
>> On 10/19/2012 11:31 AM, Jeff Lake wrote:
>>> [root@ldm /]# gdal-config --dep-libs
>>> -L/usr/lib64 -lgeos_c -lsqlite3 -lexpat -lgif -ljpeg -lpng -L/usr/lib64
>>> -lpq -lz -lpthread -lm -lrt -ldl -L/usr/kerberos/lib64 -lcurl -ldl
>>> -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lidn -lssl -lcrypto -lz
>>> -L/usr/lib64/mysql -lmysqlclient -lpthread -lm -lrt -lssl -lcrypto -ldl
>>>
>>>
>>>
>>>
>>>
>>>
>>> *Jeff Lake*
>>> MichiganWxSystem 
>>> AllisonHouse 
>>> GRLevelXStuff 
>>> On 10/19/2012 14:23, Bborie Park wrote:
 gdal-config --dep-libs
>>>
>>>
>>>
>>> ___
>>> postgis-users mailing list
>>> postgis-users@postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>
> 
> 
> 
> 
> ___
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 

-- 
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkp...@ucdavis.edu
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] PostGIS 2 RPM

2012-10-19 Thread Jeff Lake


I was just going to ask if I should rebuild GDAL
GDAL was built before 9.1.6 was ...



*Jeff Lake*
MichiganWxSystem 
AllisonHouse 
GRLevelXStuff 
On 10/19/2012 14:48, Bborie Park wrote:

Was GDAL built against that 9.1.6 RPM?  I've committed some changes for
2.0 branch in r10484 so feel free to use that.  That'll ame sure the
linking goes correctly.

I was expecting that your output of gdal-config --dep-libs would include
a -L to the your libpq since your libpq is in /usr/pgsql-9.1/lib/

-bborie

On 10/19/2012 11:44 AM, Jeff Lake wrote:

GDAL was built from source (1.9.1)

PostgreSQL (-contrib|-server|-devel|-libs) were built from RPM's (9.1.6)


*Jeff Lake*
MichiganWxSystem 
AllisonHouse 
GRLevelXStuff 
On 10/19/2012 14:36, Bborie Park wrote:

Are the versions of GDAL and PostgreSQL from packages or ones you built?

Thanks for providing all the feedback... I'm trying to see what the best
way to fix this is.

-bborie

On 10/19/2012 11:31 AM, Jeff Lake wrote:

[root@ldm /]# gdal-config --dep-libs
-L/usr/lib64 -lgeos_c -lsqlite3 -lexpat -lgif -ljpeg -lpng -L/usr/lib64
-lpq -lz -lpthread -lm -lrt -ldl -L/usr/kerberos/lib64 -lcurl -ldl
-lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lidn -lssl -lcrypto -lz
-L/usr/lib64/mysql -lmysqlclient -lpthread -lm -lrt -lssl -lcrypto -ldl






*Jeff Lake*
MichiganWxSystem 
AllisonHouse 
GRLevelXStuff 
On 10/19/2012 14:23, Bborie Park wrote:

gdal-config --dep-libs



___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users





___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users



___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] PostGIS 2 RPM

2012-10-19 Thread Bborie Park

So, GDAL was built using the prior PostgreSQL (8.4 series).  I wonder
what happens if you call "gdalinfo" without any arguments.  Usually,
there will be error messages about missing libraries if what GDAL was
built against is missing.  If you're not getting any error messages,
just use the changed Makefile.in from r10484

-bborie

On 10/19/2012 11:54 AM, Jeff Lake wrote:
> I was just going to ask if I should rebuild GDAL
> GDAL was built before 9.1.6 was ...
> 
> 
> 
> *Jeff Lake*
> MichiganWxSystem 
> AllisonHouse 
> GRLevelXStuff 
> On 10/19/2012 14:48, Bborie Park wrote:
>> Was GDAL built against that 9.1.6 RPM?  I've committed some changes for
>> 2.0 branch in r10484 so feel free to use that.  That'll ame sure the
>> linking goes correctly.
>>
>> I was expecting that your output of gdal-config --dep-libs would include
>> a -L to the your libpq since your libpq is in /usr/pgsql-9.1/lib/
>>
>> -bborie
>>
>> On 10/19/2012 11:44 AM, Jeff Lake wrote:
>>> GDAL was built from source (1.9.1)
>>>
>>> PostgreSQL (-contrib|-server|-devel|-libs) were built from RPM's (9.1.6)
>>>
>>>
>>> *Jeff Lake*
>>> MichiganWxSystem 
>>> AllisonHouse 
>>> GRLevelXStuff 
>>> On 10/19/2012 14:36, Bborie Park wrote:
 Are the versions of GDAL and PostgreSQL from packages or ones you
 built?

 Thanks for providing all the feedback... I'm trying to see what the
 best
 way to fix this is.

 -bborie

 On 10/19/2012 11:31 AM, Jeff Lake wrote:
> [root@ldm /]# gdal-config --dep-libs
> -L/usr/lib64 -lgeos_c -lsqlite3 -lexpat -lgif -ljpeg -lpng
> -L/usr/lib64
> -lpq -lz -lpthread -lm -lrt -ldl -L/usr/kerberos/lib64 -lcurl -ldl
> -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lidn -lssl -lcrypto -lz
> -L/usr/lib64/mysql -lmysqlclient -lpthread -lm -lrt -lssl -lcrypto
> -ldl
>
>
>
>
>
>
> *Jeff Lake*
> MichiganWxSystem 
> AllisonHouse 
> GRLevelXStuff 
> On 10/19/2012 14:23, Bborie Park wrote:
>> gdal-config --dep-libs
>
>
> ___
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>>>
>>>
>>>
>>> ___
>>> postgis-users mailing list
>>> postgis-users@postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>
> 
> 
> 
> 
> ___
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 

-- 
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkp...@ucdavis.edu
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] PostGIS 2 RPM

2012-10-19 Thread Jeff Lake


the Makefile from r10484 gets rid of the original error
can I build postGIS without-mysql ??

didn't even know mysql was an option
cause now I get ...

/usr/bin/ld: cannot find -lmysqlclient
collect2: ld returned 1 exit status
make[2]: *** [raster2pgsql] Error 1
make[2]: Leaving directory `/postgis-2.0.1/raster/loader'
make[1]: *** [rtloader] Error 2
make[1]: Leaving directory `/postgis-2.0.1/raster'
make: *** [all] Error 1





*Jeff Lake*
MichiganWxSystem 
AllisonHouse 
GRLevelXStuff 
On 10/19/2012 14:57, Bborie Park wrote:

So, GDAL was built using the prior PostgreSQL (8.4 series).  I wonder
what happens if you call "gdalinfo" without any arguments.  Usually,
there will be error messages about missing libraries if what GDAL was
built against is missing.  If you're not getting any error messages,
just use the changed Makefile.in from r10484

-bborie

On 10/19/2012 11:54 AM, Jeff Lake wrote:

I was just going to ask if I should rebuild GDAL
GDAL was built before 9.1.6 was ...



*Jeff Lake*
MichiganWxSystem 
AllisonHouse 
GRLevelXStuff 
On 10/19/2012 14:48, Bborie Park wrote:

Was GDAL built against that 9.1.6 RPM?  I've committed some changes for
2.0 branch in r10484 so feel free to use that.  That'll ame sure the
linking goes correctly.

I was expecting that your output of gdal-config --dep-libs would include
a -L to the your libpq since your libpq is in /usr/pgsql-9.1/lib/

-bborie

On 10/19/2012 11:44 AM, Jeff Lake wrote:

GDAL was built from source (1.9.1)

PostgreSQL (-contrib|-server|-devel|-libs) were built from RPM's (9.1.6)


*Jeff Lake*
MichiganWxSystem 
AllisonHouse 
GRLevelXStuff 
On 10/19/2012 14:36, Bborie Park wrote:

Are the versions of GDAL and PostgreSQL from packages or ones you
built?

Thanks for providing all the feedback... I'm trying to see what the
best
way to fix this is.

-bborie

On 10/19/2012 11:31 AM, Jeff Lake wrote:

[root@ldm /]# gdal-config --dep-libs
-L/usr/lib64 -lgeos_c -lsqlite3 -lexpat -lgif -ljpeg -lpng
-L/usr/lib64
-lpq -lz -lpthread -lm -lrt -ldl -L/usr/kerberos/lib64 -lcurl -ldl
-lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lidn -lssl -lcrypto -lz
-L/usr/lib64/mysql -lmysqlclient -lpthread -lm -lrt -lssl -lcrypto
-ldl






*Jeff Lake*
MichiganWxSystem 
AllisonHouse 
GRLevelXStuff 
On 10/19/2012 14:23, Bborie Park wrote:

gdal-config --dep-libs


___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users




___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users





___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users



___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] PostGIS 2 RPM

2012-10-19 Thread Bborie Park

It's not.  That would once again be from GDAL's dependency on MySQL.

-bborie

On 10/19/2012 02:26 PM, Jeff Lake wrote:
> the Makefile from r10484 gets rid of the original error
> can I build postGIS without-mysql ??
> 
> didn't even know mysql was an option
> cause now I get ...
> 
> /usr/bin/ld: cannot find -lmysqlclient
> collect2: ld returned 1 exit status
> make[2]: *** [raster2pgsql] Error 1
> make[2]: Leaving directory `/postgis-2.0.1/raster/loader'
> make[1]: *** [rtloader] Error 2
> make[1]: Leaving directory `/postgis-2.0.1/raster'
> make: *** [all] Error 1
> 
> 
> 
> 
> 
> *Jeff Lake*
> MichiganWxSystem 
> AllisonHouse 
> GRLevelXStuff 
> On 10/19/2012 14:57, Bborie Park wrote:
>> So, GDAL was built using the prior PostgreSQL (8.4 series).  I wonder
>> what happens if you call "gdalinfo" without any arguments.  Usually,
>> there will be error messages about missing libraries if what GDAL was
>> built against is missing.  If you're not getting any error messages,
>> just use the changed Makefile.in from r10484
>>
>> -bborie
>>
>> On 10/19/2012 11:54 AM, Jeff Lake wrote:
>>> I was just going to ask if I should rebuild GDAL
>>> GDAL was built before 9.1.6 was ...
>>>
>>>
>>>
>>> *Jeff Lake*
>>> MichiganWxSystem 
>>> AllisonHouse 
>>> GRLevelXStuff 
>>> On 10/19/2012 14:48, Bborie Park wrote:
 Was GDAL built against that 9.1.6 RPM?  I've committed some changes for
 2.0 branch in r10484 so feel free to use that.  That'll ame sure the
 linking goes correctly.

 I was expecting that your output of gdal-config --dep-libs would
 include
 a -L to the your libpq since your libpq is in /usr/pgsql-9.1/lib/

 -bborie

 On 10/19/2012 11:44 AM, Jeff Lake wrote:
> GDAL was built from source (1.9.1)
>
> PostgreSQL (-contrib|-server|-devel|-libs) were built from RPM's
> (9.1.6)
>
>
> *Jeff Lake*
> MichiganWxSystem 
> AllisonHouse 
> GRLevelXStuff 
> On 10/19/2012 14:36, Bborie Park wrote:
>> Are the versions of GDAL and PostgreSQL from packages or ones you
>> built?
>>
>> Thanks for providing all the feedback... I'm trying to see what the
>> best
>> way to fix this is.
>>
>> -bborie
>>
>> On 10/19/2012 11:31 AM, Jeff Lake wrote:
>>> [root@ldm /]# gdal-config --dep-libs
>>> -L/usr/lib64 -lgeos_c -lsqlite3 -lexpat -lgif -ljpeg -lpng
>>> -L/usr/lib64
>>> -lpq -lz -lpthread -lm -lrt -ldl -L/usr/kerberos/lib64 -lcurl -ldl
>>> -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lidn -lssl -lcrypto -lz
>>> -L/usr/lib64/mysql -lmysqlclient -lpthread -lm -lrt -lssl -lcrypto
>>> -ldl
>>>
>>>
>>>
>>>
>>>
>>>
>>> *Jeff Lake*
>>> MichiganWxSystem 
>>> AllisonHouse 
>>> GRLevelXStuff 
>>> On 10/19/2012 14:23, Bborie Park wrote:
 gdal-config --dep-libs
>>>
>>> ___
>>> postgis-users mailing list
>>> postgis-users@postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>
>
>
> ___
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>>>
>>>
>>>
>>> ___
>>> postgis-users mailing list
>>> postgis-users@postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>
> 
> 
> 
> 
> ___
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 

-- 
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkp...@ucdavis.edu
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] PostGIS 2 RPM

2012-10-19 Thread Jeff Lake


I appreciate the assistance.
but seeings how GDAL only supports libmysql15, and the latest is libmysql18
I can't build GDAL against it, and hence postGIS 2.0 fails

I'm really not in the mood to go backwards with mySQL and/or libmysql
just to obtain the little I will


(already been though this with GDAL .. I can see supporting libmysql15 + 
not JUST 15



*Jeff Lake*
MichiganWxSystem 
AllisonHouse 
GRLevelXStuff 
On 10/19/2012 14:57, Bborie Park wrote:

So, GDAL was built using the prior PostgreSQL (8.4 series).  I wonder
what happens if you call "gdalinfo" without any arguments.  Usually,
there will be error messages about missing libraries if what GDAL was
built against is missing.  If you're not getting any error messages,
just use the changed Makefile.in from r10484

-bborie

On 10/19/2012 11:54 AM, Jeff Lake wrote:

I was just going to ask if I should rebuild GDAL
GDAL was built before 9.1.6 was ...



*Jeff Lake*
MichiganWxSystem 
AllisonHouse 
GRLevelXStuff 
On 10/19/2012 14:48, Bborie Park wrote:

Was GDAL built against that 9.1.6 RPM?  I've committed some changes for
2.0 branch in r10484 so feel free to use that.  That'll ame sure the
linking goes correctly.

I was expecting that your output of gdal-config --dep-libs would include
a -L to the your libpq since your libpq is in /usr/pgsql-9.1/lib/

-bborie

On 10/19/2012 11:44 AM, Jeff Lake wrote:

GDAL was built from source (1.9.1)

PostgreSQL (-contrib|-server|-devel|-libs) were built from RPM's (9.1.6)


*Jeff Lake*
MichiganWxSystem 
AllisonHouse 
GRLevelXStuff 
On 10/19/2012 14:36, Bborie Park wrote:

Are the versions of GDAL and PostgreSQL from packages or ones you
built?

Thanks for providing all the feedback... I'm trying to see what the
best
way to fix this is.

-bborie

On 10/19/2012 11:31 AM, Jeff Lake wrote:

[root@ldm /]# gdal-config --dep-libs
-L/usr/lib64 -lgeos_c -lsqlite3 -lexpat -lgif -ljpeg -lpng
-L/usr/lib64
-lpq -lz -lpthread -lm -lrt -ldl -L/usr/kerberos/lib64 -lcurl -ldl
-lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lidn -lssl -lcrypto -lz
-L/usr/lib64/mysql -lmysqlclient -lpthread -lm -lrt -lssl -lcrypto
-ldl






*Jeff Lake*
MichiganWxSystem 
AllisonHouse 
GRLevelXStuff 
On 10/19/2012 14:23, Bborie Park wrote:

gdal-config --dep-libs


___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users




___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users





___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users



___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] PostGIS 2 RPM

2012-10-19 Thread Bborie Park

Can you rebuild your GDAL?  I'm going to have to poke a few machines
to see how they all respond to gdal-config --dep-libs

-bborie

On Fri, Oct 19, 2012 at 6:38 PM, Jeff Lake  wrote:
> I appreciate the assistance.
> but seeings how GDAL only supports libmysql15, and the latest is libmysql18
> I can't build GDAL against it, and hence postGIS 2.0 fails
>
> I'm really not in the mood to go backwards with mySQL and/or libmysql
> just to obtain the little I will
>
>
> (already been though this with GDAL .. I can see supporting libmysql15 + not
> JUST 15
>
>
>
> Jeff Lake
> MichiganWxSystem
> AllisonHouse
> GRLevelXStuff
> On 10/19/2012 14:57, Bborie Park wrote:
>
> So, GDAL was built using the prior PostgreSQL (8.4 series).  I wonder
> what happens if you call "gdalinfo" without any arguments.  Usually,
> there will be error messages about missing libraries if what GDAL was
> built against is missing.  If you're not getting any error messages,
> just use the changed Makefile.in from r10484
>
> -bborie
>
> On 10/19/2012 11:54 AM, Jeff Lake wrote:
>
> I was just going to ask if I should rebuild GDAL
> GDAL was built before 9.1.6 was ...
>
>
>
> *Jeff Lake*
> MichiganWxSystem 
> AllisonHouse 
> GRLevelXStuff 
> On 10/19/2012 14:48, Bborie Park wrote:
>
> Was GDAL built against that 9.1.6 RPM?  I've committed some changes for
> 2.0 branch in r10484 so feel free to use that.  That'll ame sure the
> linking goes correctly.
>
> I was expecting that your output of gdal-config --dep-libs would include
> a -L to the your libpq since your libpq is in /usr/pgsql-9.1/lib/
>
> -bborie
>
> On 10/19/2012 11:44 AM, Jeff Lake wrote:
>
> GDAL was built from source (1.9.1)
>
> PostgreSQL (-contrib|-server|-devel|-libs) were built from RPM's (9.1.6)
>
>
> *Jeff Lake*
> MichiganWxSystem 
> AllisonHouse 
> GRLevelXStuff 
> On 10/19/2012 14:36, Bborie Park wrote:
>
> Are the versions of GDAL and PostgreSQL from packages or ones you
> built?
>
> Thanks for providing all the feedback... I'm trying to see what the
> best
> way to fix this is.
>
> -bborie
>
> On 10/19/2012 11:31 AM, Jeff Lake wrote:
>
> [root@ldm /]# gdal-config --dep-libs
> -L/usr/lib64 -lgeos_c -lsqlite3 -lexpat -lgif -ljpeg -lpng
> -L/usr/lib64
> -lpq -lz -lpthread -lm -lrt -ldl -L/usr/kerberos/lib64 -lcurl -ldl
> -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lidn -lssl -lcrypto -lz
> -L/usr/lib64/mysql -lmysqlclient -lpthread -lm -lrt -lssl -lcrypto
> -ldl
>
>
>
>
>
>
> *Jeff Lake*
> MichiganWxSystem 
> AllisonHouse 
> GRLevelXStuff 
> On 10/19/2012 14:23, Bborie Park wrote:
>
> gdal-config --dep-libs
>
> ___
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
> ___
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
>
> ___
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
> ___
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-- 
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkp...@ucdavis.edu
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] PostGIS 2 RPM

2012-10-19 Thread Jeff Lake


I tried
but because I have upgraded libmysql and mySQL after I first built GDAL
GDAL fails I imagine if I go back a few versions on libmysql and mySQL to
the required libmysql.15 GDAL will install no problem


*Jeff Lake*
MichiganWxSystem 
AllisonHouse 
GRLevelXStuff 
On 10/19/2012 22:00, Bborie Park wrote:

Can you rebuild your GDAL?  I'm going to have to poke a few machines
to see how they all respond to gdal-config --dep-libs

-bborie

On Fri, Oct 19, 2012 at 6:38 PM, Jeff Lake  wrote:

I appreciate the assistance.
but seeings how GDAL only supports libmysql15, and the latest is libmysql18
I can't build GDAL against it, and hence postGIS 2.0 fails

I'm really not in the mood to go backwards with mySQL and/or libmysql
just to obtain the little I will


(already been though this with GDAL .. I can see supporting libmysql15 + not
JUST 15



Jeff Lake
MichiganWxSystem
AllisonHouse
GRLevelXStuff
On 10/19/2012 14:57, Bborie Park wrote:

So, GDAL was built using the prior PostgreSQL (8.4 series).  I wonder
what happens if you call "gdalinfo" without any arguments.  Usually,
there will be error messages about missing libraries if what GDAL was
built against is missing.  If you're not getting any error messages,
just use the changed Makefile.in from r10484

-bborie

On 10/19/2012 11:54 AM, Jeff Lake wrote:

I was just going to ask if I should rebuild GDAL
GDAL was built before 9.1.6 was ...



*Jeff Lake*
MichiganWxSystem 
AllisonHouse 
GRLevelXStuff 
On 10/19/2012 14:48, Bborie Park wrote:

Was GDAL built against that 9.1.6 RPM?  I've committed some changes for
2.0 branch in r10484 so feel free to use that.  That'll ame sure the
linking goes correctly.

I was expecting that your output of gdal-config --dep-libs would include
a -L to the your libpq since your libpq is in /usr/pgsql-9.1/lib/

-bborie

On 10/19/2012 11:44 AM, Jeff Lake wrote:

GDAL was built from source (1.9.1)

PostgreSQL (-contrib|-server|-devel|-libs) were built from RPM's (9.1.6)


*Jeff Lake*
MichiganWxSystem 
AllisonHouse 
GRLevelXStuff 
On 10/19/2012 14:36, Bborie Park wrote:

Are the versions of GDAL and PostgreSQL from packages or ones you
built?

Thanks for providing all the feedback... I'm trying to see what the
best
way to fix this is.

-bborie

On 10/19/2012 11:31 AM, Jeff Lake wrote:

[root@ldm /]# gdal-config --dep-libs
-L/usr/lib64 -lgeos_c -lsqlite3 -lexpat -lgif -ljpeg -lpng
-L/usr/lib64
-lpq -lz -lpthread -lm -lrt -ldl -L/usr/kerberos/lib64 -lcurl -ldl
-lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lidn -lssl -lcrypto -lz
-L/usr/lib64/mysql -lmysqlclient -lpthread -lm -lrt -lssl -lcrypto
-ldl






*Jeff Lake*
MichiganWxSystem 
AllisonHouse 
GRLevelXStuff 
On 10/19/2012 14:23, Bborie Park wrote:

gdal-config --dep-libs

___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users



___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users




___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users



___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users






___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] PostGIS 2 RPM

2012-10-22 Thread Jeff Lake


persistence pays off !!!

I threw the directions from the postgresql page that deals with 
upgrading 8.4 to 9.1 away

that is where 90% of my problems came from.
Trying to update a re-constructed 8.4 database to postGIS2 was causing 
all kinds of trouble


started from scratch..
mysql 5.0.95
fresh install pgsql 9.1.6
GDAL 1.9.2
GEOS 3.3.5
python 2.4
php 5.4.8
postGIS-2.01
on CentOS 5.8 64bit


I kept restoring my 8.4 db in 9.1.6
and the errors where to many to keep track of trying to upgrade the db 
to postGIS-2

so I started from zero, no tables..
recreated the tables on at a time, applied the postgis sql files as needed
then simply re-imported my shape files, and other data I had in there to 
begin with


so .. one server down ... 2 more to go
Thanks for the help

-Jeff








*Jeff Lake*
MichiganWxSystem 
AllisonHouse 
GRLevelXStuff 
On 10/19/2012 22:06, Jeff Lake wrote:

I tried
but because I have upgraded libmysql and mySQL after I first built GDAL
GDAL fails I imagine if I go back a few versions on libmysql and mySQL to
the required libmysql.15 GDAL will install no problem


*Jeff Lake*
MichiganWxSystem 
AllisonHouse 
GRLevelXStuff 
On 10/19/2012 22:00, Bborie Park wrote:

Can you rebuild your GDAL?  I'm going to have to poke a few machines
to see how they all respond to gdal-config --dep-libs

-bborie

On Fri, Oct 19, 2012 at 6:38 PM, Jeff Lake  wrote:

I appreciate the assistance.
but seeings how GDAL only supports libmysql15, and the latest is libmysql18
I can't build GDAL against it, and hence postGIS 2.0 fails

I'm really not in the mood to go backwards with mySQL and/or libmysql
just to obtain the little I will


(already been though this with GDAL .. I can see supporting libmysql15 + not
JUST 15



Jeff Lake
MichiganWxSystem
AllisonHouse
GRLevelXStuff
On 10/19/2012 14:57, Bborie Park wrote:

So, GDAL was built using the prior PostgreSQL (8.4 series).  I wonder
what happens if you call "gdalinfo" without any arguments.  Usually,
there will be error messages about missing libraries if what GDAL was
built against is missing.  If you're not getting any error messages,
just use the changed Makefile.in from r10484

-bborie

On 10/19/2012 11:54 AM, Jeff Lake wrote:

I was just going to ask if I should rebuild GDAL
GDAL was built before 9.1.6 was ...



*Jeff Lake*
MichiganWxSystem
AllisonHouse
GRLevelXStuff
On 10/19/2012 14:48, Bborie Park wrote:

Was GDAL built against that 9.1.6 RPM?  I've committed some changes for
2.0 branch in r10484 so feel free to use that.  That'll ame sure the
linking goes correctly.

I was expecting that your output of gdal-config --dep-libs would include
a -L to the your libpq since your libpq is in /usr/pgsql-9.1/lib/

-bborie

On 10/19/2012 11:44 AM, Jeff Lake wrote:

GDAL was built from source (1.9.1)

PostgreSQL (-contrib|-server|-devel|-libs) were built from RPM's (9.1.6)


*Jeff Lake*
MichiganWxSystem
AllisonHouse
GRLevelXStuff
On 10/19/2012 14:36, Bborie Park wrote:

Are the versions of GDAL and PostgreSQL from packages or ones you
built?

Thanks for providing all the feedback... I'm trying to see what the
best
way to fix this is.

-bborie

On 10/19/2012 11:31 AM, Jeff Lake wrote:

[root@ldm /]# gdal-config --dep-libs
-L/usr/lib64 -lgeos_c -lsqlite3 -lexpat -lgif -ljpeg -lpng
-L/usr/lib64
-lpq -lz -lpthread -lm -lrt -ldl -L/usr/kerberos/lib64 -lcurl -ldl
-lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lidn -lssl -lcrypto -lz
-L/usr/lib64/mysql -lmysqlclient -lpthread -lm -lrt -lssl -lcrypto
-ldl






*Jeff Lake*
MichiganWxSystem
AllisonHouse
GRLevelXStuff
On 10/19/2012 14:23, Bborie Park wrote:

gdal-config --dep-libs

___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users



___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users




___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users



___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users







___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] PostGIS 2 RPM

Re: [postgis-users] PostGIS 2 RPM

Re: [postgis-users] PostGIS 2 RPM

Re: [postgis-users] PostGIS 2 RPM

Re: [postgis-users] PostGIS 2 RPM

Re: [postgis-users] PostGIS 2 RPM

Re: [postgis-users] PostGIS 2 RPM

Re: [postgis-users] PostGIS 2 RPM

Re: [postgis-users] PostGIS 2 RPM

Re: [postgis-users] PostGIS 2 RPM

Re: [postgis-users] PostGIS 2 RPM

Re: [postgis-users] PostGIS 2 RPM

Re: [postgis-users] PostGIS 2 RPM

Re: [postgis-users] PostGIS 2 RPM

Re: [postgis-users] PostGIS 2 RPM

Re: [postgis-users] PostGIS 2 RPM

Re: [postgis-users] PostGIS 2 RPM

Re: [postgis-users] PostGIS 2 RPM

Re: [postgis-users] PostGIS 2 RPM

Re: [postgis-users] PostGIS 2 RPM

Re: [postgis-users] PostGIS 2 RPM

Re: [postgis-users] PostGIS 2 RPM

Re: [postgis-users] PostGIS 2 RPM

Re: [postgis-users] PostGIS 2 RPM

Re: [postgis-users] PostGIS 2 RPM

Re: [postgis-users] PostGIS 2 RPM

Re: [postgis-users] PostGIS 2 RPM

Re: [postgis-users] PostGIS 2 RPM

Re: [postgis-users] PostGIS 2 RPM

Re: [postgis-users] PostGIS 2 RPM

Re: [postgis-users] PostGIS 2 RPM

31 matches

Site Navigation

Mail list logo

Footer information