[turba] There are no clients which you have access to (TURBA and HERMES)

Claudio Baeza Retamal claudio at udec.cl
Wed Sep 5 20:47:21 UTC 2007


Hi, 

I have problem between TURBA and HERMES.

I have followed the instructions of:
http://wiki.horde.org/HermesAddressBook?referrer=HowTo
 
When attempt to enter an entrance:
(Office-> Time Tracking -> Enter Time)
 
it appears

* Client     There are no clients which you have access to. 

I have some entries in my Turba address book and I also tried it with 
the separate DB  without any difference.

My configuration: 

charset UTF-8
Horde CVS (3.2-cvs) at 09-03-2007 
Turba CVS (2.2-cvs) at 09-03-2007 
Hermes CVS (1.0-cvs) at 09-03-2007 
Whups CVS (1.0-cvs) at 09-03-2007
Postgres SQL Data Base 8.1.9 
PHP 5.1.6 
PEAR 1.4.9 
Centos 5



claudio


The log:

Sep 05 16:37:11 HORDE [debug] [turba] Hook _horde_hook_share_init in
application horde not called. [on line 1484 of
"/usr/share/pear/Horde.php"]
Sep 05 16:37:11 HORDE [debug] [turba] SQL Query by
DataTree_sql::getByAttributes(): SELECT c.datatree_id, c.datatree_name
FROM horde_datatree c LEFT JOIN horde_datatree_attributes a1 ON
a1.datatree_id = c.datatree_id WHERE c.group_uid = ? AND
(a1.attribute_name = ? AND a1.attribute_key = ?)   GROUP BY
c.datatree_id, c.datatree_name, c.datatree_order ORDER BY
c.datatree_order, c.datatree_name, c.datatree_id Values:
horde.groups,user,fcfm [on line 1247 of
"/usr/share/pear/Horde/DataTree/sql.php"]
Sep 05 16:37:11 HORDE [debug] [turba] SQL Query by
DataTree_sql::_loadById(): SELECT datatree_id, datatree_parents FROM
horde_datatree WHERE datatree_id IN (2) AND group_uid = 'horde.groups'
ORDER BY datatree_id [on line 341 of
"/usr/share/pear/Horde/DataTree/sql.php"]
Sep 05 16:37:11 HORDE [debug] [turba] SQL Query by
DataTree_sql::getByAttributes(): SELECT c.datatree_id, c.datatree_name
FROM horde_datatree c LEFT JOIN horde_datatree_attributes a1 ON
a1.datatree_id = c.datatree_id WHERE c.group_uid = ? AND
(a1.attribute_name = ? AND a1.attribute_value = ?)   GROUP BY
c.datatree_id, c.datatree_name, c.datatree_order ORDER BY
c.datatree_order, c.datatree_name, c.datatree_id Values:
horde.shares.turba,owner,fcfm [on line 1212 of
"/usr/share/pear/Horde/DataTree/sql.php"]
Sep 05 16:37:11 HORDE [debug] [turba] SQL Query by
DataTree_sql::getByAttributes(): SELECT c.datatree_id, c.datatree_name
FROM horde_datatree c LEFT JOIN horde_datatree_attributes a1 ON
a1.datatree_id = c.datatree_id WHERE c.group_uid = ? AND
(a1.attribute_name = ? AND a1.attribute_key = ? AND CASE WHEN
CAST(a1.attribute_value AS VARCHAR) ~ '^-\?[0-9]+$' THEN
(CAST(a1.attribute_value AS INTEGER) \& ?) <> 0 ELSE FALSE END)   GROUP
BY c.datatree_id, c.datatree_name, c.datatree_order ORDER BY
c.datatree_order, c.datatree_name, c.datatree_id Values:
horde.shares.turba,perm_users,fcfm,4 [on line 1212 of
"/usr/share/pear/Horde/DataTree/sql.php"]
Sep 05 16:37:11 HORDE [debug] [turba] SQL Query by
DataTree_sql::getByAttributes(): SELECT c.datatree_id, c.datatree_name
FROM horde_datatree c LEFT JOIN horde_datatree_attributes a1 ON
a1.datatree_id = c.datatree_id WHERE c.group_uid = ? AND
(a1.attribute_name = ? AND CASE WHEN CAST(a1.attribute_value AS VARCHAR)
~ '^-\?[0-9]+$' THEN (CAST(a1.attribute_value AS INTEGER) \& ?) <> 0
ELSE FALSE END)   GROUP BY c.datatree_id, c.datatree_name,
c.datatree_order ORDER BY c.datatree_order, c.datatree_name,
c.datatree_id Values: horde.shares.turba,perm_creator,4 [on line 1212 of
"/usr/share/pear/Horde/DataTree/sql.php"]
Sep 05 16:37:11 HORDE [debug] [turba] SQL Query by
DataTree_sql::getByAttributes(): SELECT c.datatree_id, c.datatree_name
FROM horde_datatree c LEFT JOIN horde_datatree_attributes a1 ON
a1.datatree_id = c.datatree_id WHERE c.group_uid = ? AND
(a1.attribute_name = ? AND CASE WHEN CAST(a1.attribute_value AS VARCHAR)
~ '^-\?[0-9]+$' THEN (CAST(a1.attribute_value AS INTEGER) \& ?) <> 0
ELSE FALSE END)   GROUP BY c.datatree_id, c.datatree_name,
c.datatree_order ORDER BY c.datatree_order, c.datatree_name,
c.datatree_id Values: horde.shares.turba,perm_default,4 [on line 1212 of
"/usr/share/pear/Horde/DataTree/sql.php"]
Sep 05 16:37:11 HORDE [debug] [turba] SQL Query by
DataTree_sql::getByAttributes(): SELECT c.datatree_id, c.datatree_name
FROM horde_datatree c LEFT JOIN horde_datatree_attributes a1 ON
a1.datatree_id = c.datatree_id WHERE c.group_uid = ? AND
(a1.attribute_name = ? AND a1.attribute_key IN (?) AND CASE WHEN
CAST(a1.attribute_value AS VARCHAR) ~ '^-\?[0-9]+$' THEN
(CAST(a1.attribute_value AS INTEGER) \& ?) <> 0 ELSE FALSE END)   GROUP
BY c.datatree_id, c.datatree_name, c.datatree_order ORDER BY
c.datatree_order, c.datatree_name, c.datatree_id Values:
horde.shares.turba,perm_groups,2,4 [on line 1212 of
"/usr/share/pear/Horde/DataTree/sql.php"]
Sep 05 16:37:11 HORDE [debug] [turba] SQL Query by
DataTree_sql::_loadById(): SELECT datatree_id, datatree_parents FROM
horde_datatree WHERE datatree_id IN (1) AND group_uid =
'horde.shares.turba' ORDER BY datatree_id [on line 341 of
"/usr/share/pear/Horde/DataTree/sql.php"]
Sep 05 16:37:11 HORDE [debug] [turba] SQL Query by
DataTree_sql::getAttributes(): SELECT datatree_id, attribute_name AS
name, attribute_key AS "key", attribute_value AS value FROM
horde_datatree_attributes WHERE datatree_id IN (1) [on line 1083 of
"/usr/share/pear/Horde/DataTree/sql.php"]
Sep 05 16:37:11 HORDE [debug] [hermes] SELECT jobtype_id, jobtype_name,
jobtype_enabled, jobtype_rate FROM hermes_jobtypes WHERE jobtype_enabled
= ? ORDER BY jobtype_name Values: 1 [on line 381 of
"/var/www/html/horde/hermes/lib/Driver/sql.php"]




More information about the turba mailing list