[kronolith] Switching from mcal to sql

Harry Hoffman hhoffman@ip-solutions.net
Mon, 31 Dec 2001 20:34:05 -0500
Previous message: [kronolith] Switching from mcal to sql
Next message: [kronolith] Switching from mcal to sql
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi Jan,
   Ok I'm feeling quite dumb now. I've tried to switch kronolith's conf.php to 
the following:
$conf['calendar']['driver'] = 'sql';
$conf['calendar']['params'] = array();
$conf['calendar']['params']['driver'] = 'mysql';
$conf['calendar']['params']['phptype'] = 'mysql';
$conf['calendar']['params']['hostspec'] = 'localhost';
$conf['calendar']['params']['username'] = 'myhordeuser';
$conf['calendar']['params']['password'] = 'xxxxxxxxxx';
$conf['calendar']['params']['database'] = 'horde';
$conf['calendar']['params']['table'] = 'turba_objects';

And while I can see the calendar I get half an html page about errors. I can 
post them if you like but essentially I know that I must have something wrong. 
Do you, or anyone else, have a working conf file that they could post?

Thanks,
Harry


Quoting Jan Schneider <jan@horde.org>:

> Oh, this was a misunderstanding. I talked about how to import exported data
> 
> back again.
> 
> The sql driver parameters in conf.php are quite the same as for all other 
> sql drivers. You don't need libmcal if you switch to sql.
> 
> Happy New Year,
> 
> Jan.
> 



-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/


>From jan@horde.org Date: Tue,  1 Jan 2002 14:59:30 +0100
Return-Path: <jan@horde.org>
Mailing-List: contact kronolith-help@lists.horde.org; run by ezmlm
Delivered-To: mailing list kronolith@lists.horde.org
Received: (qmail 76935 invoked from network); 1 Jan 2002 14:01:12 -0000
Received: from mailout09.sul.t-online.com (194.25.134.84)
  by clark.horde.org with SMTP; 1 Jan 2002 14:01:12 -0000
Received: from fwd09.sul.t-online.de 
	by mailout09.sul.t-online.de with smtp 
	id 16LPTZ-0005dj-02; Tue, 01 Jan 2002 15:01:09 +0100
Received: from linux.wg.de (320034214675-0001@[80.130.210.170]) by fmrl09.sul.t-online.com
	with esmtp id 16LPTN-1RNAX2C; Tue, 1 Jan 2002 15:00:57 +0100
Received: from localhost (localhost [127.0.0.1])
	by linux.wg.de (8.11.0/8.11.0/SuSE Linux 8.11.0-0.4) with ESMTP id g01DxV925586
	for <kronolith@lists.horde.org>; Tue, 1 Jan 2002 14:59:31 +0100
Received: from 192.168.60.1 ( [192.168.60.1])
	as user jan@linux by linux.wg.de with HTTP;
	Tue,  1 Jan 2002 14:59:30 +0100
Message-ID: <1009893570.3c31c0c2cfba3@linux.wg.de>
Date: Tue,  1 Jan 2002 14:59:30 +0100
From: Jan Schneider <jan@horde.org>
To: kronolith@lists.horde.org
References: <1009729766.3c2f40e694b9b@192.168.143.3> <1009736879.3c2f5caf6a9ef@linux.wg.de> <1009818417.3c309b310a3c4@192.168.143.3> <1009819238.3c309e665bac7@linux.wg.de> <1009848845.3c31120d57cab@192.168.143.3>
In-Reply-To: <1009848845.3c31120d57cab@192.168.143.3>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 4.0-cvs
X-Sender: 320034214675-0001@t-dialin.net
Subject: Re: [kronolith] Switching from mcal to sql

Zitat von Harry Hoffman <hhoffman@ip-solutions.net>:

> $conf['calendar']['params']['table'] = 'turba_objects';

This should be 'kronolith_events'.

Jan.

::::::::::::::::::::::::::::::::::::::::
AMMMa AG - discover your knowledge
:::::::::::::::::::::::::::
Detmolder Str. 25-33 :: D-33604 Bielefeld
fon +49.521.96878-0 :: fax  +49.521.96878-20
http://www.ammma.de
::::::::::::::::::::::::::::::::::::::::::::::


>From hhoffman@ip Date: Tue,  1 Jan 2002 10:57:42 -0500
Return-Path: <hhoffman@ip-solutions.net>
Mailing-List: contact kronolith-help@lists.horde.org; run by ezmlm
Delivered-To: mailing list kronolith@lists.horde.org
Received: (qmail 79718 invoked from network); 1 Jan 2002 15:57:45 -0000
Received: from pool-151-197-191-23.phil.east.verizon.net (HELO mail.ip-solutions.net) (151.197.191.23)
  by clark.horde.org with SMTP; 1 Jan 2002 15:57:45 -0000
Received: from localhost (localhost.localdomain [127.0.0.1])
	by mail.ip-solutions.net (Postfix) with ESMTP id 7362F2F02A
	for <kronolith@lists.horde.org>; Tue,  1 Jan 2002 10:57:43 -0500 (EST)
Received: by mail.ip-solutions.net (Postfix, from userid 48)
	id BEC892F0C2; Tue,  1 Jan 2002 10:57:42 -0500 (EST)
Received: from 192.168.143.36 ( [192.168.143.36])
	as user hhoffman@127.0.0.1 by 192.168.143.3 with HTTP;
	Tue,  1 Jan 2002 10:57:42 -0500
Message-ID: <1009900662.3c31dc76a5242@192.168.143.3>
Date: Tue,  1 Jan 2002 10:57:42 -0500
From: Harry Hoffman <hhoffman@ip-solutions.net>
To: kronolith@lists.horde.org
References: <1009729766.3c2f40e694b9b@192.168.143.3> <1009736879.3c2f5caf6a9ef@linux.wg.de> <1009818417.3c309b310a3c4@192.168.143.3> <1009819238.3c309e665bac7@linux.wg.de> <1009848845.3c31120d57cab@192.168.143.3> <1009893570.3c31c0c2cfba3@linux.wg.de>
In-Reply-To: <1009893570.3c31c0c2cfba3@linux.wg.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 4.0-cvs
X-Originating-IP: 192.168.143.36
X-Virus-Scanned: by AMaViS snapshot-20010915
Subject: Re: [kronolith] Switching from mcal to sql

Jan,
   Ok, that definitely confirms my stupidity. Thanks for pointing that out.

Regards,
Harry


Quoting Jan Schneider <jan@horde.org>:

> Zitat von Harry Hoffman <hhoffman@ip-solutions.net>:
> 
> > $conf['calendar']['params']['table'] = 'turba_objects';
> 
> This should be 'kronolith_events'.
> 
> Jan.
> 
> ::::::::::::::::::::::::::::::::::::::::
> AMMMa AG - discover your knowledge
> :::::::::::::::::::::::::::
> Detmolder Str. 25-33 :: D-33604 Bielefeld
> fon +49.521.96878-0 :: fax  +49.521.96878-20
> http://www.ammma.de
> ::::::::::::::::::::::::::::::::::::::::::::::
> 
> -- 
> Kronolith mailing list: http://horde.org/kronolith/
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: kronolith-unsubscribe@lists.horde.org
> 
> 




-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/


>From hhoffman@ip Date: Tue,  1 Jan 2002 20:40:07 -0500
Return-Path: <hhoffman@ip-solutions.net>
Mailing-List: contact kronolith-help@lists.horde.org; run by ezmlm
Delivered-To: mailing list kronolith@lists.horde.org
Received: (qmail 8488 invoked from network); 2 Jan 2002 01:40:10 -0000
Received: from pool-151-197-191-23.phil.east.verizon.net (HELO mail.ip-solutions.net) (151.197.191.23)
  by clark.horde.org with SMTP; 2 Jan 2002 01:40:10 -0000
Received: from localhost (localhost.localdomain [127.0.0.1])
	by mail.ip-solutions.net (Postfix) with ESMTP id 6DDB02F02A
	for <kronolith@lists.horde.org>; Tue,  1 Jan 2002 20:40:08 -0500 (EST)
Received: by mail.ip-solutions.net (Postfix, from userid 48)
	id B68132F0C2; Tue,  1 Jan 2002 20:40:07 -0500 (EST)
Received: from 192.168.143.36 ( [192.168.143.36])
	as user hhoffman@127.0.0.1 by 192.168.143.3 with HTTP;
	Tue,  1 Jan 2002 20:40:07 -0500
Message-ID: <1009935607.3c3264f79d808@192.168.143.3>
Date: Tue,  1 Jan 2002 20:40:07 -0500
From: Harry Hoffman <hhoffman@ip-solutions.net>
To: kronolith@lists.horde.org
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 4.0-cvs
X-Originating-IP: 192.168.143.36
X-Virus-Scanned: by AMaViS snapshot-20010915
Subject: Imported csv doesn't show up in Calendar

Hey All,
  I got the move done from mcal to sql. I had exported all events from mcal and 
am now trying to import to sql. I can see the data in the db, but no events 
show up on the calendar. Where do I go from here?

Thanks,
Harry



-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/


>From jan@horde.org Date: Wed,  2 Jan 2002 02:53:26 +0100
Return-Path: <jan@horde.org>
Mailing-List: contact kronolith-help@lists.horde.org; run by ezmlm
Delivered-To: mailing list kronolith@lists.horde.org
Received: (qmail 9165 invoked from network); 2 Jan 2002 02:00:58 -0000
Received: from mailout11.sul.t-online.com (194.25.134.85)
  by clark.horde.org with SMTP; 2 Jan 2002 02:00:58 -0000
Received: from fwd01.sul.t-online.de 
	by mailout11.sul.t-online.de with smtp 
	id 16Lai8-00050z-00; Wed, 02 Jan 2002 03:00:56 +0100
Received: from linux.wg.de (320034214675-0001@[80.130.210.170]) by fmrl01.sul.t-online.com
	with esmtp id 16Lai1-0IzCN6C; Wed, 2 Jan 2002 03:00:49 +0100
Received: from localhost (localhost [127.0.0.1])
	by linux.wg.de (8.11.0/8.11.0/SuSE Linux 8.11.0-0.4) with ESMTP id g021rR931561
	for <kronolith@lists.horde.org>; Wed, 2 Jan 2002 02:53:27 +0100
Received: from 192.168.60.1 ( [192.168.60.1])
	as user jan@linux by linux.wg.de with HTTP;
	Wed,  2 Jan 2002 02:53:26 +0100
Message-ID: <1009936406.3c326816b7500@linux.wg.de>
Date: Wed,  2 Jan 2002 02:53:26 +0100
From: Jan Schneider <jan@horde.org>
To: kronolith@lists.horde.org
References: <1009935607.3c3264f79d808@192.168.143.3>
In-Reply-To: <1009935607.3c3264f79d808@192.168.143.3>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 4.0-cvs
X-Sender: 320034214675-0001@t-dialin.net
Subject: Re: [kronolith] Imported csv doesn't show up in Calendar

Zitat von Harry Hoffman <hhoffman@ip-solutions.net>:

> Hey All,
>   I got the move done from mcal to sql. I had exported all events from
> mcal and 
> am now trying to import to sql. I can see the data in the db, but no
> events 
> show up on the calendar. Where do I go from here?

No idea. You have to dig a bit on your own: Do the db entries make sense, 
do manually created events work, is there a difference between created and 
imported event, ...

Jan.

::::::::::::::::::::::::::::::::::::::::
AMMMa AG - discover your knowledge
:::::::::::::::::::::::::::
Detmolder Str. 25-33 :: D-33604 Bielefeld
fon +49.521.96878-0 :: fax  +49.521.96878-20
http://www.ammma.de
::::::::::::::::::::::::::::::::::::::::::::::


>From hhoffman@ip Date: Wed,  2 Jan 2002 15:43:33 -0500
Return-Path: <hhoffman@ip-solutions.net>
Mailing-List: contact kronolith-help@lists.horde.org; run by ezmlm
Delivered-To: mailing list kronolith@lists.horde.org
Received: (qmail 63235 invoked from network); 2 Jan 2002 20:43:36 -0000
Received: from pool-151-197-191-23.phil.east.verizon.net (HELO mail.ip-solutions.net) (151.197.191.23)
  by clark.horde.org with SMTP; 2 Jan 2002 20:43:36 -0000
Received: from localhost (localhost.localdomain [127.0.0.1])
	by mail.ip-solutions.net (Postfix) with ESMTP id 357502F019
	for <kronolith@lists.horde.org>; Wed,  2 Jan 2002 15:43:33 -0500 (EST)
Received: by mail.ip-solutions.net (Postfix, from userid 48)
	id 1B8FE2F0C2; Wed,  2 Jan 2002 15:43:33 -0500 (EST)
Received: from 129.25.9.99 ( [129.25.9.99])
	as user hhoffman@127.0.0.1 by ip-solutions.net with HTTP;
	Wed,  2 Jan 2002 15:43:33 -0500
Message-ID: <1010004213.3c3370f5089fe@ip-solutions.net>
Date: Wed,  2 Jan 2002 15:43:33 -0500
From: Harry Hoffman <hhoffman@ip-solutions.net>
To: kronolith@lists.horde.org
MIME-Version: 1.0
Content-Type: text/plain; charset=windows-1252;q=1.0
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 4.0-cvs
X-Originating-IP: 129.25.9.99
X-Virus-Scanned: by AMaViS snapshot-20010915
Subject: ? about showing tasks in calendar

Hi all,
   I've selected the option under Kronolith to show due tasks under the calendar. The task shows up on the main Horde page and the daily view but not under the monthly calendar view of kronolith. Is this the way it's supposed to work or should I actually see an event under the monthly view as well?

Thanks,
Harry



-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/


>From jan@horde.org Date: Wed,  2 Jan 2002 21:55:06 +0100
Return-Path: <jan@horde.org>
Mailing-List: contact kronolith-help@lists.horde.org; run by ezmlm
Delivered-To: mailing list kronolith@lists.horde.org
Received: (qmail 64589 invoked from network); 2 Jan 2002 21:00:57 -0000
Received: from mailout02.sul.t-online.com (194.25.134.17)
  by clark.horde.org with SMTP; 2 Jan 2002 21:00:57 -0000
Received: from fwd11.sul.t-online.de 
	by mailout02.sul.t-online.de with smtp 
	id 16LsVM-0007ex-0F; Wed, 02 Jan 2002 22:00:56 +0100
Received: from linux.wg.de (320034214675-0001@[80.130.218.150]) by fmrl11.sul.t-online.com
	with esmtp id 16LsVK-28K69QC; Wed, 2 Jan 2002 22:00:54 +0100
Received: from localhost (localhost [127.0.0.1])
	by linux.wg.de (8.11.0/8.11.0/SuSE Linux 8.11.0-0.4) with ESMTP id g02Kt7909945
	for <kronolith@lists.horde.org>; Wed, 2 Jan 2002 21:55:07 +0100
Received: from 192.168.60.1 ( [192.168.60.1])
	as user jan@linux by linux.wg.de with HTTP;
	Wed,  2 Jan 2002 21:55:06 +0100
Message-ID: <1010004906.3c3373aacc1e3@linux.wg.de>
Date: Wed,  2 Jan 2002 21:55:06 +0100
From: Jan Schneider <jan@horde.org>
To: kronolith@lists.horde.org
References: <1010004213.3c3370f5089fe@ip-solutions.net>
In-Reply-To: <1010004213.3c3370f5089fe@ip-solutions.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 4.0-cvs
X-Sender: 320034214675-0001@t-dialin.net
Subject: Re: [kronolith] ? about showing tasks in calendar

Zitat von Harry Hoffman <hhoffman@ip-solutions.net>:

> Hi all,
>    I've selected the option under Kronolith to show due tasks under the
> calendar. The task shows up on the main Horde page and the daily view but
> not under the monthly calendar view of kronolith. Is this the way it's
> supposed to work or should I actually see an event under the monthly view
> as well?

The api for the month view is rather different to the other views. This is 
why it's not that easy to implement the task display in the month view. In 
short words: It's not a bug but a missing feature.

Jan.

::::::::::::::::::::::::::::::::::::::::
AMMMa AG - discover your knowledge
:::::::::::::::::::::::::::
Detmolder Str. 25-33 :: D-33604 Bielefeld
fon +49.521.96878-0 :: fax  +49.521.96878-20
http://www.ammma.de
::::::::::::::::::::::::::::::::::::::::::::::
Previous message: [kronolith] Switching from mcal to sql
Next message: [kronolith] Switching from mcal to sql
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]