[postgis-users] 2.1.0beta3dev upgrade error

[Bborie Park]

Steve,

Which version of the json library are you using?

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

-bborie

On Wed, May 22, 2013 at 10:22 PM, Stephen Woodbridge
<woodbri at swoodbridge.com> wrote:
> Some more data points. I also created a new database and tried:
>
> pgis21=# create extension postgis;
>
> ERROR:  could not load library "/usr/lib/postgresql/9.2/lib/postgis-2.1.so":
> /usr/lib/postgresql/9.2/lib/postgis-2.1.so: undefined symbol:
> json_tokener_errors
> pgis21=# create extension postgis version '2.0.3';
> ERROR:  could not load library
> "/usr/lib/postgresql/9.2/lib/rtpostgis-2.0.so": libgdal1.6.0.so.1: cannot
> open shared object file: No such file or directory
>
> So I rebuilt postgis 2.0.3 to use the new gdal that I installed for 2.1 and
> tried "create extension postgis;" and this installed 2.0.3 by default.
>
> pgis21=# drop extension postgis ;
> DROP EXTENSION
>
> pgis21=# create extension postgis version '2.1.0beta3dev';
> CREATE EXTENSION
>
> and now it loaded 2.1 ok.
>
> Not sure what caused the strangeness, but it seems to be working there, but
> when I run my pgrouting test script:
>
> woodbri at maps:~/work/pgrouting$ tools/test-runner.pl
> RUNNING: test-runner.pl
> ERROR:  could not load library "/usr/lib/postgresql/9.2/lib/postgis-2.0.so":
> /usr/lib/postgresql/9.2/lib/postgis-2.0.so: undefined symbol:
> json_tokener_errors
> ERROR:  required extension "postgis" is not installed
>
> This creates a new database, adds postgis and pgrouting and then runs tests
> in that database.
>
> -Steve
>
>
> On 5/23/2013 1:01 AM, Stephen Woodbridge wrote:
>>
>> Hi all,
>>
>> I just tried to upgrade postgis from 2.0.3 -> 2.1.0beta3dev and got the
>> following error:
>>
>> pgr_test=# alter extension postgis update to '2.1.0beta3dev';
>> ERROR:  could not load library
>> "/usr/lib/postgresql/9.2/lib/postgis-2.1.so":
>> /usr/lib/postgresql/9.2/lib/postgis-2.1.so: undefined symbol:
>> json_tokener_errors
>>
>> Did I forget a step or do something wrong?
>>
>> -Steve
>>
>> I have json-c-0.11 built and installed. In fact is is the ./configure
>> report:
>>
>>    PostGIS is now configured for i686-pc-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:          /usr/local/bin/geos-config
>>    GEOS version:         3.3.8
>>    GDAL config:          /usr/local/bin/gdal-config
>>    GDAL version:         1.9.2
>>    PostgreSQL config:    /usr/lib/postgresql/9.2/bin/pg_config
>>    PostgreSQL version:   PostgreSQL 9.2.4
>>    PROJ4 version:        47
>>    Libxml2 config:       /usr/bin/xml2-config
>>    Libxml2 version:      2.7.8
>>    JSON-C support:       yes
>>    PostGIS debug level:  0
>>    Perl:                 /usr/bin/perl
>>
>>   --------------- Extensions ---------------
>>    PostGIS Raster:       enabled
>>    PostGIS Topology:     enabled
>>    SFCGAL support:       disabled
>>
>>   -------- Documentation Generation --------
>>    xsltproc:             /usr/bin/xsltproc
>>    xsl style sheets:
>>    dblatex:
>>    convert:
>>    mathml2.dtd:          http://www.w3.org/Math/DTD/mathml2/mathml2.dtd
>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users