[kronolith] Kronolith2.0.5 + oracle 10g
samer khalil
samerk1 at gmail.com
Thu Nov 24 04:00:53 PST 2005
It's me again,
I reinstalled the hole system and got the same result.
No events are showing in Kronolith alltough they are inserted in the DB.
my kronolith conf.php :
<?php
/* CONFIG START. DO NOT CHANGE ANYTHING IN OR AFTER THIS LINE. */
// $Horde: kronolith/config/conf.xml,v 1.14.10.1 2005/03/04 04:04:31 ben Exp
$
$conf['calendar']['params']['table'] = 'kronolith_events';
$conf['calendar']['params']['driverconfig'] = 'horde';
$conf['calendar']['driver'] = 'sql';
$conf['storage']['params']['table'] = 'kronolith_storage';
$conf['storage']['params']['driverconfig'] = 'horde';
$conf['storage']['driver'] = 'sql';
$conf['metadata']['keywords'] = false;
$conf['reminder']['server_name'] = 'localhost';
$conf['reminder']['from_addr'] = 'imail at aub.edu.lb';
$conf['menu']['print'] = true;
$conf['menu']['import_export'] = true;
$conf['menu']['apps'] = array('imp', 'turba');
/* CONFIG END. DO NOT CHANGE ANYTHING IN OR BEFORE THIS LINE. */
and horde conf.php:
<?php
/* CONFIG START. DO NOT CHANGE ANYTHING IN OR AFTER THIS LINE. */
// $Horde: horde/config/conf.xml,v 1.74.2.14 2005/08/23 17:14:42 mrubinsk
Exp $
$conf['debug_level'] = E_ALL;
$conf['max_exec_time'] = 0;
$conf['use_ssl'] = 2;
$conf['server']['name'] = $_SERVER['SERVER_NAME'];
$conf['server']['port'] = $_SERVER['SERVER_PORT'];
$conf['compress_pages'] = true;
$conf['umask'] = 077;
$conf['session']['name'] = 'Horde';
$conf['session']['cache_limiter'] = 'nocache';
$conf['session']['timeout'] = 0;
$conf['cookie']['domain'] = $_SERVER['SERVER_NAME'];
$conf['cookie']['path'] = '/horde';
$conf['sql']['persistent'] = false;
$conf['sql']['username'] = 'horde';
$conf['sql']['password'] = '*********'; # with the right password
$conf['sql']['hostspec'] = 'europa';
$conf['sql']['charset'] = 'iso-8859-1';
$conf['sql']['phptype'] = 'oci8';
$conf['auth']['admins'] = array('Administrator', 'samerk');
$conf['auth']['checkip'] = true;
$conf['auth']['driver'] = 'composite';
$conf['auth']['params']['drivers'] = array(
'imp' => array('driver' => 'application',
'params' => array('app' => 'imp')),
'mimp' => array('driver' => 'application',
'params' => array('app' => 'mimp')));
$conf['auth']['params']['loginscreen_switch'] = '_horde_select_loginscreen';
if (!function_exists('_horde_select_loginscreen')) {
function _horde_select_loginscreen()
{
require_once 'Horde/Browser.php';
require_once 'Horde/Browser.php';
$browser = &new Browser();
if ($browser->isMobile()) {
return 'mimp';
}
return 'imp';
}
}
$conf['signup']['allow'] = false;
$conf['signup']['approve'] = true;
$conf['signup']['preprocess'] = false;
$conf['signup']['queue'] = false;
$conf['log']['priority'] = PEAR_LOG_DEBUG;
$conf['log']['ident'] = 'HORDE';
$conf['log']['params'] = array();
$conf['log']['name'] = '/tmp/horde.log';
$conf['log']['params']['append'] = true;
$conf['log']['type'] = 'file';
$conf['log']['enabled'] = true;
$conf['log_accesskeys'] = false;
$conf['prefs']['params']['driverconfig'] = 'horde';
$conf['prefs']['driver'] = 'sql';
$conf['datatree']['params']['driverconfig'] = 'horde';
$conf['datatree']['driver'] = 'sql';
$conf['group']['driver'] = 'datatree';
$conf['cache']['default_lifetime'] = 1800;
$conf['cache']['params']['dir'] = Horde::getTempDir();
$conf['cache']['driver'] = 'file';
$conf['token']['driver'] = 'none';
$conf['mailer']['params']['sendmail_path'] = '/usr/lib/sendmail';
$conf['mailer']['params']['sendmail_args'] = '-oi';
$conf['mailer']['type'] = 'sendmail';
$conf['vfs']['params']['vfsroot'] = '/tmp';
$conf['vfs']['type'] = 'file';
$conf['sessionhandler']['type'] = 'none';
$conf['problems']['email'] = 'imail at aub.edu.lb';
$conf['menu']['always'] = false;
$conf['menu']['links']['help'] = 'all';
$conf['menu']['links']['options'] = 'authenticated';
$conf['menu']['links']['problem'] = 'all';
$conf['menu']['links']['login'] = 'all';
$conf['menu']['links']['logout'] = 'authenticated';
$conf['hooks']['username'] = false;
$conf['hooks']['preauthenticate'] = false;
$conf['hooks']['postauthenticate'] = false;
$conf['hooks']['authldap'] = false;
$conf['kolab']['enabled'] = false;
$conf['imsp']['enabled'] = false;
/* CONFIG END. DO NOT CHANGE ANYTHING IN OR BEFORE THIS LINE. */
when i enable PEAR_LOG_DEBUG, i get the following lines in horde.log when i
click on 'Calendar' :
Nov 24 13:38:00 HORDE [debug] [kronolith] Hook _horde_hook_share_init in
application horde not called. [on line 1387 of "/web/horde3/lib/Horde.php"]
Nov 24 13:38:00 HORDE [debug] [kronolith] 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[on line 992 of "/web/horde3/lib/Horde/DataTree/sql.php"]
Nov 24 13:38:00 HORDE [debug] [kronolith] 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 = ?) OR (a1.attribute_name = ? AND a1.attribute_key = ?
AND bitand(a1.attribute_value, ?) = ?) OR (a1.attribute_name = ? AND bitand(
a1.attribute_value, ?) = ?) OR (a1.attribute_name = ? AND bitand(
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[on line 992 of "/web/horde3/lib/Horde/DataTree/sql.php"]
Nov 24 13:38:00 HORDE [debug] [kronolith] SQL Query by
DataTree_sql::_loadById(): SELECT datatree_id, datatree_parents FROM
horde_datatree WHERE datatree_id IN (722, 689) AND group_uid = '
horde.shares.kronolith' ORDER BY datatree_id [on line 275 of
"/web/horde3/lib/Horde/DataTree/sql.php"]
Nov 24 13:38:00 HORDE [debug] [kronolith] SQL Query by
DataTree_sql::_loadById(): SELECT datatree_id, datatree_name,
datatree_parents, datatree_order FROM horde_datatree WHERE datatree_id IN
(?, ?, ?) AND group_uid = ? ORDER BY datatree_id [on line 305 of
"/web/horde3/lib/Horde/DataTree/sql.php"]
Nov 24 13:38:00 HORDE [debug] [kronolith] 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 (722, 689) [on line 889 of
"/web/horde3/lib/Horde/DataTree/sql.php"]
Nov 24 13:38:00 HORDE [debug] [kronolith] 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[on line 992 of "/web/horde3/lib/Horde/DataTree/sql.php"]
Nov 24 13:38:00 HORDE [debug] [kronolith] 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 = ?) OR (a1.attribute_name = ? AND a1.attribute_key = ?
AND bitand(a1.attribute_value, ?) = ?) OR (a1.attribute_name = ? AND bitand(
a1.attribute_value, ?) = ?) OR (a1.attribute_name = ? AND bitand(
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[on line 992 of "/web/horde3/lib/Horde/DataTree/sql.php"]
Nov 24 13:38:00 HORDE [debug] [kronolith] 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 (722, 689) [on line 889 of
"/web/horde3/lib/Horde/DataTree/sql.php"]
Nov 24 13:38:00 HORDE [debug] [kronolith] SQL session setup by samerk: query
= "ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS'" [on line 558
of "/web/horde3/kronolith/lib/Driver/sql.php"]
Nov 24 13:38:00 HORDE [debug] [kronolith] SQL event list by samerk: query =
"SELECT event_id, event_uid, event_description, event_location,
event_status, event_attendees, event_keywords, event_title, event_category,
event_recurtype, event_recurenddate, event_recurinterval, event_recurdays,
event_start, event_end, event_alarm, event_modified, event_exceptions,
event_creator_id FROM kronolith_events WHERE calendar_id = ? AND ((event_end
> ? AND event_start < ?) OR (event_recurenddate >= ? AND event_start <= ?
AND event_recurtype <> ?))" [on line 239 of
"/web/horde3/kronolith/lib/Driver/sql.php"]
Nov 24 13:38:00 HORDE [debug] [nag] Hook _horde_hook_share_init in
application horde not called. [on line 1387 of "/web/horde3/lib/Horde.php"]
Nov 24 13:38:00 HORDE [debug] [nag] 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[on line 992 of "/web/horde3/lib/Horde/DataTree/sql.php"]
Nov 24 13:38:00 HORDE [debug] [nag] 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 = ?) OR (a1.attribute_name = ? AND a1.attribute_key = ?
AND bitand(a1.attribute_value, ?) = ?) OR (a1.attribute_name = ? AND bitand(
a1.attribute_value, ?) = ?) OR (a1.attribute_name = ? AND bitand(
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[on line 992 of "/web/horde3/lib/Horde/DataTree/sql.php"]
Nov 24 13:38:00 HORDE [debug] [nag] SQL Query by DataTree_sql::_loadById():
SELECT datatree_id, datatree_parents FROM horde_datatree WHERE datatree_id
IN (690) AND group_uid = 'horde.shares.nag' ORDER BY datatree_id [on line
275 of "/web/horde3/lib/Horde/DataTree/sql.php"]
Nov 24 13:38:00 HORDE [debug] [nag] SQL Query by DataTree_sql::_loadById():
SELECT datatree_id, datatree_name, datatree_parents, datatree_order FROM
horde_datatree WHERE datatree_id IN (?, ?) AND group_uid = ? ORDER BY
datatree_id [on line 305 of "/web/horde3/lib/Horde/DataTree/sql.php"]
Nov 24 13:38:00 HORDE [debug] [nag] 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 (690) [on line 889 of
"/web/horde3/lib/Horde/DataTree/sql.php"]
Nov 24 13:38:00 HORDE [debug] [nag] Nag_Driver_sql::retrieve(): SELECT *
FROM nag_tasks WHERE task_owner = ? [on line 350 of
"/web/horde3/nag/lib/Driver/sql.php"]
can anyone tell me what am i still missing?
Thanks
Samer
On 11/21/05, Jan Schneider <jan at horde.org> wrote:
>
> Zitat von samer khalil <samerk1 at gmail.com>:
>
> > I know, there is no event_id in the querry, allthough the event ID (the
> > serial) shows in calendar_id field ! while calendar_id should point to
> the
> > username.
> > Please correct me if i am rong.
>
> You are wrong.
>
> Jan.
>
> --
> Do you need professional PHP or Horde consulting?
> http://horde.org/consulting/
> --
> Kronolith mailing list - Join the hunt:
> http://horde.org/bounties/#kronolith
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: kronolith-unsubscribe at lists.horde.org
>
More information about the kronolith
mailing list