[Cartoweb-users] PEAR installation

[Oliver Christen]

the important part is what is returned, here $results

because ServerLocation say what it receives is empty.


> Oliver,
> I print my query result from ServMapOverlay.php in queryByIdSelection:
>
> print_r($idAttribute, $query);
>
> and it give me the right result :
> pro_com is my attribute
>
> "pro_com - pro_com IN ('63049')"
>
> Oliver Christen ha scritto:
>> "POST 
>> http://my_server/cartoweb3/htdocs/demoCW3.php?ajaxActionRequest=Search.DoIt&"
>> I presume this is in the Firebug console ?
>> do you have anything in the Response tab ?
>>
>>
>>> Oliver,
>>> thanks for your help.
>>> The problem is that demoCW3 project doesn't work. When I try to access 
>>> the whole application (not only the search functionality) it remains 
>>> blocked on:
>>>
>>> "POST 
>>> http://my_server/cartoweb3/htdocs/demoCW3.php?ajaxActionRequest=Search.DoIt&"
>>>
>>> and I am not able to do nothing !
>>>
>>> I'll send you some shell screenshots.... I have never installed 
>>> php_sqlite.so because also from pear-pecl it names sqlite.so
>>>
>>> PS: my PEAR "include path" is : 
>>> include_path.:/usr/share/php:/usr/share/pear
>>>
>>>
>>> geomarketing:/usr/lib/php5/20060613# ls -la
>>> totale 4576
>>> drwxrwxrwx 2 root root    4096 2008-09-25 19:33 .
>>> drwxrwxrwx 5 root root    4096 2008-09-24 18:45 ..
>>> -rw-r--r-- 1 root root   59976 2008-05-10 12:36 curl.so
>>> -rw-r--r-- 1 root root  131096 2008-05-10 12:36 gd.so
>>> -rw-r--r-- 1 root root  125681 2008-09-25 17:42 pdo_pgsql.so
>>> -rw-r--r-- 1 root root  284901 2008-09-25 17:41 pdo.so
>>> -rw-r--r-- 1 root root 1437640 2008-09-25 18:03 pdo_sqlite.so
>>> -rw-r--r-- 1 root root  106296 2008-05-10 12:36 pgsql.so
>>> lrwxrwxrwx 1 root root      16 2008-09-23 13:23 
>>> php_mapscript_4.10.0.so -> php_mapscript.so
>>> -rwxrwxrwx 1 root root 1142976 2008-09-23 13:23 php_mapscript.so
>>> lrwxrwxrwx 1 root root      32 2008-09-25 19:33 php_sqlite.so -> 
>>> /usr/lib/php5/20060613/sqlite.so
>>> -rwxr-xr-x 1 root root 1213743 2008-09-25 19:24 sqlite.so
>>> -rw-r--r-- 1 root root   90960 2008-05-10 12:36 xmlrpc.so
>>> -rw-r--r-- 1 root root   28440 2008-05-10 12:36 xsl.so
>>>
>>>
>>> geomarketing:/etc/php5/apache2/conf.d# ls -la
>>> totale 48
>>> drwxr-xr-x 2 root root 4096 2008-09-25 19:45 .
>>> drwxr-xr-x 6 root root 4096 2008-09-19 16:52 ..
>>> -rw-r--r-- 1 root root   54 2008-05-10 12:36 curl.ini
>>> -rw-r--r-- 1 root root   50 2008-05-10 12:36 gd.ini
>>> -rw-r--r-- 1 root root   17 2008-09-25 18:08 pdo.ini
>>> -rw-r--r-- 1 root root   23 2008-09-25 18:11 pdo_pgsql.ini
>>> -rw-r--r-- 1 root root   24 2008-09-25 18:08 pdo_sqlite.ini
>>> -rw-r--r-- 1 root root   61 2008-05-10 12:36 pgsql.ini
>>> -rw-r--r-- 1 root root   34 2008-09-23 15:54 php_mapscript.ini
>>> -rw-r--r-- 1 root root   24 2008-09-25 19:45 php_sqlite.ini
>>> -rw-r--r-- 1 root root   59 2008-05-10 12:36 xmlrpc.ini
>>> -rw-r--r-- 1 root root   52 2008-05-10 12:36 xsl.ini
>>>
>>>
>>> geomarketing:/usr/lib/php5/20060613# locate sqlite.so
>>> /usr/lib/libsqlite.so
>>> /usr/lib/libsqlite.so.0
>>> /usr/lib/libsqlite.so.0.8.6
>>> /usr/lib/php5/20060613/pdo_sqlite.so
>>> /usr/lib/php5/20060613/php_sqlite.so
>>> /usr/lib/php5/20060613/sqlite.so
>>> /var/www/cartoweb3/include/pear/PEAR/SQLite-1.0.3/.libs/sqlite.so
>>> /var/www/cartoweb3/include/pear/PEAR/SQLite-1.0.3/modules/sqlite.so
>>>
>>>
>>> Oliver Christen ha scritto:
>>>> Hi
>>>>
>>>> "Recenter Id canceled, unable to find selected Id"
>>>> is NOT related to pear/pecl
>>>>
>>>> it's a DATA problem, mapserver returned NOTHING for the selected id.
>>>>
>>>> put some debug in ServerMapquery.php in function queryByIdSelection to 
>>>> see exactly what may be wrong.
>>>>
>>>> regards
>>>> Oliver
>>>>
>>>>
>>>>
>>>>> Hi Oliver.
>>>>> I uninstalled from Debian sqlite, pdo_sqlite shared objs and I 
>>>>> reinstalled them trought pear-pecl.
>>>>> The error is always the same when I use my plugin function from my 
>>>>> cartoweb project:
>>>>>
>>>>> "Recenter Id canceled, unable to find selected Id"
>>>>>
>>>>> ...while if I test Search funtionality from demoCW3 project I have NO 
>>>>> ERROR!! Before I reintsalled *.so the error for demoCW3 project was:
>>>>>
>>>>> "Can't able to find php_sqlite.so" (something like that....)...
>>>>>
>>>>> Thank you
>>>>>
>>>>> -- 
>>>>> Ing. Fabio D'Ovidio
>>>>>
>>>>> INOVA Open Solutions s.r.l.
>>>>> Web : http://www.inovaos.it
>>>>> Tel.: 081 197 57 600
>>>>> mail: fabiodovidio at gmail.com
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> Oliver Christen ha scritto:
>>>>>> what error do you get ?
>>>>>>
>>>>>>
>>>>>>
>>>>>>> I installed sqlite from php-pecl. Its name is sqlite.so, i renamed 
>>>>>>> it with php_sqlite.so and.... cartoweb doesn't work for search 
>>>>>>> function!
>>>>>>>
>>>>>>> How can I do ?
>>>>>>>
>>>>>>> Thanks.
>>>>>>>
>>>>>>> Oliver Christen ha scritto:
>>>>>>>>>
>>>>>>>>> I know I could install this packages also trought pear command 
>>>>>>>>> line.....
>>>>>>>>>
>>>>>>>>
>>>>>>>> maybe thats why the name is different, PEAR may have expected you 
>>>>>>>> to install it via PEAR's command line.
>>>>>>>>
>>>>>>>> does it work now with a renamed .so ?
>>>>>>>>
>>>>>>>
>>>>>>> -- 
>>>>>>> Ing. Fabio D'Ovidio
>>>>>>>
>>>>>>> INOVA Open Solutions s.r.l.
>>>>>>> Web : http://www.inovaos.it
>>>>>>> Tel.: 081 197 57 600
>>>>>>> mail: fabiodovidio at gmail.com
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>> -- 
>>> Ing. Fabio D'Ovidio
>>>
>>> INOVA Open Solutions s.r.l.
>>> Web : http://www.inovaos.it
>>> Tel.: 081 197 57 600
>>> mail: fabiodovidio at gmail.com
>>>
>>>
>>
>>
>
> -- 
> Ing. Fabio D'Ovidio
>
> INOVA Open Solutions s.r.l.
> Web : http://www.inovaos.it
> Tel.: 081 197 57 600
> mail: fabiodovidio at gmail.com
>
>