[ELGIS] /usr/lib64/libspatialite.so.2: undefined symbol: sqlite3_clear_bindings in Unknown on line 0

[Pavel Iacovlev]

PostgreSQL 8.4.9
PHP: 5.3.3
php53-pgsql is installed

On Mon, Dec 26, 2011 at 7:24 PM, Jeff Lake <admin at michiganwxsystem.com> wrote:
> this may have been asked ..
> but ..
> -what version of postgresql
> -what version of php
> -is the postgresql php extension installed ??
>
> -Jeff Lake
> MichiganWxSystem.com
> WeatherMichigan.net
> TheWeatherCenter.net
> GRLevelXStuff.com
>
>
>
> On 12/26/2011 12:04 PM, Pavel Iacovlev wrote:
>>
>> Sorry to bring attention to this thread again, but I still cant get
>> php-mapserver working properly in ELGIS 5 stable.
>> My steps are:
>>  * Install a fresh CentOS 5 distribution
>>   * Add the ELGIS 5 repo
>>   * Enable elgis-plus  in /etc/yum.repos.d/elgis.repo (thats because
>> php-mapserver does on work with just elgis due to  spatialite errors)
>>   * Install php-mapserver
>>
>> After this php runs fine, with no errors about spatialite, BUT then I
>> try to connect to the database apache crashes with the following
>> message: [Tue Dec 13 11:49:53 2011] [notice] child pid 6502 exit
>> signal Segmentation fault (11)
>>
>> The php script to reproduce is rather simple:
>> <?php
>> $conn = pg_connect("dbname=gis username=user password=pass
>> host=localhost");
>>
>> Any ideas how to get php-mapserver working on CentOS 5 ?
>>
>> On Fri, Dec 16, 2011 at 2:34 PM, Pavel Iacovlev
>> <iacovlev.pavel at gmail.com>  wrote:
>>>
>>> Just a reminder, this problem is still not fixed, and php-mapscript
>>> does not work at all after installing from elgis repo.
>>>
>>> adding elgis-plus repo and updating fixes the problem.
>>>
>>> On Tue, Oct 11, 2011 at 11:30 AM, Mathieu Baudier<mbaudier at argeo.org>
>>>  wrote:
>>>>>
>>>>> [root at localhost etc]# rpm -qa | grep sqlite
>>>>> sqlite-3.3.6-5
>>>>> python-sqlite-1.1.7-1.2.1
>>>>> sqlite-3.3.6-5
>>>>
>>>> There is a known issue with libspatialite/sqlite in ELGIS5:
>>>> libspatialite, although in ELGIS (non Plus), has been built by mistake
>>>> against the sqlite from ELGIS Plus:
>>>> http://trac.osgeo.org/el/ticket/7
>>>>
>>>> Until a fix is available, a workaround is to install sqlite from ELGIS
>>>> Plus (just enable elgis-plus in the elgis.repo file and it will be
>>>> updated).
>>>>
>>>> Although I have never experienced any issue with this updated version
>>>> of sqlite, please note that this is quite an important component of
>>>> the base OS since many software rely on it (e.g. yum).
>>>>
>>>> I will try to fix this when I do a batch of updates for ELGIS5.
>>>> Unfortunately we may have to disable libspatialite support in GDAL
>>>> because of that.
>>>>
>>>> I'm sorry for the inconvenience.
>>>>
>>>> Cheers,
>>>>
>>>> Mathieu
>>
>> _______________________________________________
>>
>> el mailing list
>> el at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/el
>>
> _______________________________________________
> el mailing list
> el at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/el