Sebastian Arcus | 1 Apr 22:50 2012
Picon

How to debug the import of ics calendars?

I have Kronolith 3.0.16 installed and working fine with SQL backend. I 
am trying to import a large (over 4000 appointments) iCal/ics file which 
was exported from Thunderbird/Lightning. The import fails silently. When 
I query the SQL back-end - I can see that 157 appointments have been 
imported - no matter how many times I repeat the process. I need to find 
out a bit more about what is going on, so that I can amend the .ics file 
and fix whatever is stopping the import.

I've enabled logging in Horde -> Logging, set the priority to "Debug" 
and type to "File". However, there doesn't seem to be anything in the 
resulting log relating to the import. Maybe the import module doesn't 
log to the main log? Any other way that I can extract some useful 
information as to what is going on?

It would be really good if the import process would spit errors straight 
into the web interface. When I've imported address books into Turba - I 
got straight SQL error message back thrown at me - which was very useful 
in tracking down where things got jammed.

Any hints are appreciated.

Sebastian
--

-- 
kronolith mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
To unsubscribe, mail: kronolith-unsubscribe <at> lists.horde.org

Sebastian Arcus | 2 Apr 20:14 2012
Picon

Re: How to debug the import of ics calendars?

On 01/04/12 21:50, Sebastian Arcus wrote:
> I have Kronolith 3.0.16 installed and working fine with SQL backend. I
> am trying to import a large (over 4000 appointments) iCal/ics file which
> was exported from Thunderbird/Lightning. The import fails silently. When
> I query the SQL back-end - I can see that 157 appointments have been
> imported - no matter how many times I repeat the process. I need to find
> out a bit more about what is going on, so that I can amend the .ics file
> and fix whatever is stopping the import.
>
> I've enabled logging in Horde -> Logging, set the priority to "Debug"
> and type to "File". However, there doesn't seem to be anything in the
> resulting log relating to the import. Maybe the import module doesn't
> log to the main log? Any other way that I can extract some useful
> information as to what is going on?

OK - I'm replying to my own post in case it helps somebody out there. 
After re-reading carefully the PostgreSQL documentation (that's what I 
use in the back end) I reconfigured again logging and I started to see 
some useful messages. They were mainly similar to:

ERROR:  character 0xe2809a of encoding "UTF8" has no equivalent in "LATIN1"

On further investigation it turns out that the database (and database 
cluster) has been created with the Latin1 encoding. I followed the 
instructions below (which apply only to Postgresql):

http://archives.postgresql.org/pgsql-novice/2006-03/msg00210.php

to dump the database contents to a file, drop the database (I also 
deleted the database cluster actually), recreate the database cluster 
(Continue reading)

Jan Schneider | 3 Apr 10:45 2012

Re: Possible problem with daily agendas: /usr/bin/php5 -f /usr/bin/kronolith-agenda (failed)


Zitat von gimili <gimili17 <at> gmail.com>:

> My daily agendas seem to have stopped.  Is anyone else having any  
> trouble with them?  Thank you.
> Kronolith 3.0.16
>
> sendmail: fatal: Recipient addresses must be specified on the  
> command line or via the -t option
> postdrop: warning: stdin: unexpected EOF in data, record type 78 length 76
> postdrop: fatal: uid=0: malformed input
> exception 'Horde_Mail_Exception' with message 'sendmail: temporary  
> failure (75)' in /usr/share/php/Horde/Mail/Transport/Sendmail.php:238
> Stack trace:
> #0 /usr/share/php/Horde/Mime/Part.php(1736):  
> Horde_Mail_Transport_Sendmail->send('', Array, Resource id #374)
> #1 /usr/share/php/Horde/Mime/Mail.php(497):  
> Horde_Mime_Part->send('rita, rita <at> ', Object(Horde_Mime_Headers),

                          ^^^^^^^^^^^
This doesn't look like a valid email address. It shouldn't stop  
sending agendas though.

> Object(Horde_Mail_Transport_Sendmail))
> #2 /usr/bin/kronolith-agenda(175):  
> Horde_Mime_Mail->send(Object(Horde_Mail_Transport_Sendmail))
> #3 /usr/bin/kronolith-agenda(22): send_agendas()
> #4 {main}
>
> Next exception 'Horde_Mime_Exception' with message 'sendmail:  
(Continue reading)

Jan Schneider | 3 Apr 10:50 2012

Re: Kronolith <-> Sunbird via iCalendar / webDAV + Attendance


Zitat von FS <fs <at> unique-internet.de>:

> Hi everyone,
>
> I'm currently setting up Kronolith as a replacement for our previous
> calendar solution, eGroupware. We are interested only in calendar
> functionality, a purely web based approach would be fine with us just as
> anything that would integrate into our MUA (Thunderbird).
>
> Both options are possible with Kronolith as I understand, the web UI is
> really nice and there is WebDAV+iCalendar based interaction with Lightning.
>
> Here I already ran into the first issue: What is the correct ics URL for
> a users calendar? I tried
>
>> rpc.php/kronolith/user/user.ics
>
> as well as
>
>> rpc.php/kronolith/user.ics
>
> and it didn't work. Enabling DEBUG in the horde config and checking the
> SQL requests in the log as well as the php source, I figured that
> Kronolith searches for the username in the share_name field of the
> sharesng table. That however only contains IDs for me:

Don't guess URLs. Use the URLs that Kronolith tells you to use.

>> mysql> SELECT share_name FROM horde.kronolith_sharesng;
(Continue reading)

Sebastian Arcus | 3 Apr 13:27 2012
Picon

Re: Kronolith <-> Sunbird via iCalendar / webDAV + Attendance

Hi,

On 03/04/12 09:50, Jan Schneider wrote:
>
> Zitat von FS <fs <at> unique-internet.de>:
>
>> Hi everyone,
>>
>> I'm currently setting up Kronolith as a replacement for our previous
>> calendar solution, eGroupware. We are interested only in calendar
>> functionality, a purely web based approach would be fine with us just as
>> anything that would integrate into our MUA (Thunderbird).
>>
>> Both options are possible with Kronolith as I understand, the web UI is
>> really nice and there is WebDAV+iCalendar based interaction with
>> Lightning.

Not a direct answer to your questions - but just in case it might help. 
I've tried Lightning with remote calendars (mostly Webdav and ics) - and 
I found the performance once the calendar goes beyond roughly 1000 
entries is pretty awful. It doesn't look like the Lightning interface is 
multi-threaded - so every time it syncs with the remote calendar it just 
freezes the entire application. I've been really dissapointed for a 
while now about how little effort Mozilla Foundation is putting into the 
Lightning/Sunbird development - when they have plenty of resources to 
chase pipe dreams, such as turning Firefox into a gaming platform and 
other similar non-sense.
--

-- 
kronolith mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
(Continue reading)

claudio.prono@atpss.net | 3 Apr 14:26 2012
Picon

Horde 4 - Kronolith and ICAL

Hi to all,

I have a problem with some clients and Kronolith for Horde 4. I have
found this error into the logs:

2012-04-03T11:11:03+02:00 ERR: HORDE [horde] Attribute "LAST-MODIFIED"
Not Found [pid 14297 on line 233 of
"/usr/share/php5/PEAR/Horde/Icalendar.php"]

As i can see, Ical for Mac OSX doesn't send the attribute
"LAST-MODIFIED" on the events, and the new kronolith does not accept this.

Previously, with Horde 3 and Kronolith, it works all fine.

Any solution for this?

Cordially,

Claudio Prono.

--

-- 
----------------------------------------------------------------------------
Claudio Prono                   OPST
System Developer               
		               	 <at>  Mediaservice.net Srl             
                                Tel: +39-011-32.72.100
Via Santorelli, 15      	Fax: +39-011-32.46.497
10095 Grugliasco (TO) ITALY    	http://mediaservice.net/disclaimer
----------------------------------------------------------------------------

(Continue reading)

gimili | 3 Apr 19:34 2012
Picon

Re: Possible problem with daily agendas: /usr/bin/php5 -f /usr/bin/kronolith-agenda (failed)

On 4/03/12 4:45 AM, Jan Schneider wrote:
>
> Zitat von gimili <gimili17 <at> gmail.com>:
>
>> My daily agendas seem to have stopped.  Is anyone else having any 
>> trouble with them?  Thank you.
>> Kronolith 3.0.16
>>
>> sendmail: fatal: Recipient addresses must be specified on the command 
>> line or via the -t option
>> postdrop: warning: stdin: unexpected EOF in data, record type 78 
>> length 76
>> postdrop: fatal: uid=0: malformed input
>> exception 'Horde_Mail_Exception' with message 'sendmail: temporary 
>> failure (75)' in /usr/share/php/Horde/Mail/Transport/Sendmail.php:238
>> Stack trace:
>> #0 /usr/share/php/Horde/Mime/Part.php(1736): 
>> Horde_Mail_Transport_Sendmail->send('', Array, Resource id #374)
>> #1 /usr/share/php/Horde/Mime/Mail.php(497): 
>> Horde_Mime_Part->send('rita, rita <at> ', Object(Horde_Mime_Headers),
>
>                          ^^^^^^^^^^^
> This doesn't look like a valid email address. It shouldn't stop 
> sending agendas though.

Thanks for putting me on the right track Jan.  As soon as I set an email 
in the imp preferences for user rita, the agenda email does not throw an 
error.  One email without the  <at> mycompany.com seems to stop the agenda 
script but I am not sure.  Should the script insert the default outgoing 
mail domain and address completion from imp when it is missing?
(Continue reading)

Jan Schneider | 4 Apr 12:23 2012

Re: Possible problem with daily agendas: /usr/bin/php5 -f /usr/bin/kronolith-agenda (failed)


Zitat von gimili <gimili17 <at> gmail.com>:

> On 4/03/12 4:45 AM, Jan Schneider wrote:
>>
>> Zitat von gimili <gimili17 <at> gmail.com>:
>>
>>> My daily agendas seem to have stopped.  Is anyone else having any  
>>> trouble with them?  Thank you.
>>> Kronolith 3.0.16
>>>
>>> sendmail: fatal: Recipient addresses must be specified on the  
>>> command line or via the -t option
>>> postdrop: warning: stdin: unexpected EOF in data, record type 78 length 76
>>> postdrop: fatal: uid=0: malformed input
>>> exception 'Horde_Mail_Exception' with message 'sendmail: temporary  
>>> failure (75)' in  
>>> /usr/share/php/Horde/Mail/Transport/Sendmail.php:238
>>> Stack trace:
>>> #0 /usr/share/php/Horde/Mime/Part.php(1736):  
>>> Horde_Mail_Transport_Sendmail->send('', Array, Resource id #374)
>>> #1 /usr/share/php/Horde/Mime/Mail.php(497):  
>>> Horde_Mime_Part->send('rita, rita <at> ', Object(Horde_Mime_Headers),
>>
>>                         ^^^^^^^^^^^
>> This doesn't look like a valid email address. It shouldn't stop  
>> sending agendas though.
>
> Thanks for putting me on the right track Jan.  As soon as I set an  
> email in the imp preferences for user rita, the agenda email does  
(Continue reading)

Jan Schneider | 4 Apr 13:18 2012

Re: Horde 4 - Kronolith and ICAL


Zitat von claudio.prono <at> atpss.net:

> Hi to all,
>
> I have a problem with some clients and Kronolith for Horde 4. I have
> found this error into the logs:
>
> 2012-04-03T11:11:03+02:00 ERR: HORDE [horde] Attribute "LAST-MODIFIED"
> Not Found [pid 14297 on line 233 of
> "/usr/share/php5/PEAR/Horde/Icalendar.php"]
>
> As i can see, Ical for Mac OSX doesn't send the attribute
> "LAST-MODIFIED" on the events, and the new kronolith does not accept this.
>
> Previously, with Horde 3 and Kronolith, it works all fine.
>
> Any solution for this?

Report a bug.

-- 
Jan Schneider
The Horde Project
http://www.horde.org/

--

-- 
kronolith mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
To unsubscribe, mail: kronolith-unsubscribe <at> lists.horde.org
(Continue reading)

gimili | 4 Apr 15:39 2012
Picon

Turba display names / sort names format messes up Kronolith invitations

I changed the Turba pref "Select the format to display names:" to 
"Lastname, Firstname".  Now when I invite John Smith with email 
john <at> mycompany.org it gets sent to a smith <at> mycompany.org and is 
undeliverable.  I gather this is a bug?   If I change the Turba pref 
back to no format it corrects the problem with invitees.  Would you like 
this as a bug request and if so under Turba or Kronolith?

Thanks,

-- 
gimili

--

-- 
kronolith mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
To unsubscribe, mail: kronolith-unsubscribe <at> lists.horde.org


Gmane