[Cartoweb-users] PEAR installation

Mon Sep 29 04:47:15 EDT 2008

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