-------- Original Message -------- Hello,
I'm working on a CalDAV backend for my calendar plugin (http://myroundcube.googlecode.com).
It works quite good with Google's CalDAV but is not tested with other backends.
So, I'd like to ask if I could get some test accounts on your CalDAV servers.
Thanks in advance!
List info: http://lists.roundcube.net/dev/ BT/aba52c80
On Fri, 20 May 2011 06:34:07 +0200, Roland Liebl wrote:
-------- Original Message -------- Hello,
I'm working on a CalDAV backend for my calendar plugin (http://myroundcube.googlecode.com).
It works quite good with Google's CalDAV but is not tested with other backends.
So, I'd like to ask if I could get some test accounts on your CalDAV servers.
Thanks in advance!
Neat ! I want to test that. I have a davical/postgresql running on debian, I'll try to give your plugin a shot tomorrow.
Julien
List info: http://lists.roundcube.net/dev/ BT/aba52c80
On Fri, 20 May 2011 00:45:32 -0400, Julien Vehent wrote:
On Fri, 20 May 2011 06:34:07 +0200, Roland Liebl wrote:
-------- Original Message -------- Hello,
I'm working on a CalDAV backend for my calendar plugin (http://myroundcube.googlecode.com).
It works quite good with Google's CalDAV but is not tested with other backends.
So, I'd like to ask if I could get some test accounts on your CalDAV servers.
Thanks in advance!
Neat ! I want to test that. I have a davical/postgresql running on debian, I'll try to give your plugin a shot tomorrow.
It would be very kind, if I could get a test account on your server. If you agree, please mail me access details to myroundcube[at]mail4us[dot]net. Thank you.
Julien
List info: http://lists.roundcube.net/dev/ BT/8d1870bd
List info: http://lists.roundcube.net/dev/ BT/aba52c80
Thanks for all the test accounts.
If someone volunteers to give me a permanent test account please let me know.
As far as I can see the CalDAV backend works. Check http://myroundcube.googlecode.com (bundle v2.7).
On Fri, 20 May 2011 06:34:07 +0200, Roland Liebl wrote:
-------- Original Message -------- Hello,
I'm working on a CalDAV backend for my calendar plugin (http://myroundcube.googlecode.com).
It works quite good with Google's CalDAV but is not tested with other backends.
So, I'd like to ask if I could get some test accounts on your CalDAV servers.
Thanks in advance!
List info: http://lists.roundcube.net/dev/ BT/8d1870bd
List info: http://lists.roundcube.net/dev/ BT/aba52c80
On Sat, 21 May 2011 08:49:47 +0200, Roland Liebl wrote:
Thanks for all the test accounts.
If someone volunteers to give me a permanent test account please let me know.
As far as I can see the CalDAV backend works. Check http://myroundcube.googlecode.com (bundle v2.7).
Hi Roland, Thanks a lot for coding this. I pushed it to my roundcube installation, but I'm a bit confusing on how to connect it to my davical calendar. Could you please provide a config example that works with davical ?
Thanks, Julien
List info: http://lists.roundcube.net/dev/ BT/aba52c80
On Sat, 21 May 2011 13:31:58 -0400 Julien Vehent julien@linuxwall.info wrote:
Hi Roland, Thanks a lot for coding this. I pushed it to my roundcube installation, but I'm a bit confusing on how to connect it to my davical calendar. Could you please provide a config example that works with davical ?
I have found out that the reason behind it do not work is a matter of some missing tables - events_cache and caldav_event. There are no information about the data structures of these tables.
On Sat, 21 May 2011 13:31:58 -0400 Julien Vehent julien@linuxwall.info wrote:
I pushed it to my roundcube installation, but I'm a bit confusing on how to connect it to my davical calendar. Could you please provide a config example that works with davical ?
Table problem fixed. But it still not works. Getting this error on every request: [22-May-2011 01:20:07] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_pgsql_113b5df1e7ef8942dddeeafde94f9f955f66537ba1 ('0', '1', '1')] [Native message: ERROR: date/time field value out of range: "0" LINE 1: ...pgsql_113b5df1e7ef8942dddeeafde94f9f955f66537ba1 ('0', '1', ... ^ HINT: Perhaps you need a different "datestyle" setting.]
On Sat, 21 May 2011 20:13:24 +0200, Michael Rasmussen wrote:
On Sat, 21 May 2011 13:31:58 -0400 Julien Vehent julien@linuxwall.info wrote:
Hi Roland, Thanks a lot for coding this. I pushed it to my roundcube installation, but I'm a bit confusing on how to connect it to my davical calendar. Could you please provide a config example that works with davical ?
I have found out that the reason behind it do not work is a matter of some missing tables - events_cache and caldav_event. There are no information about the data structures of these tables.
You need to create three database tables: (*) events (*) events_cache (*) events_caldav
The scripts are located in the plugin's SQL folder.
To connect to a CalDAV you just need to toogle the Provider select box in calendar settings. When saved you'll see input fields to insert the access data.
-- Hilsen/Regards Michael Rasmussen
Get my public GnuPG keys: michael <at> rasmussen <dot> cc http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xD3C9A00E mir <at> datanom <dot> net http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xE501F51C mir <at> miras <dot> org http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xE3E80917
--- 8< --- detachments --- 8< --- The following attachments have been detached and are available for viewing. http://detached.gigo.com/rc/ka/DbTM1J4O/signature.asc Only click these links if you trust the sender, as well as this message. --- 8< --- detachments --- 8< ---
List info: http://lists.roundcube.net/dev/ BT/aba52c80
On Sun, 22 May 2011 05:46:59 +0200, Roland Liebl wrote:
You need to create three database tables: (*) events (*) events_cache (*) events_caldav
The scripts are located in the plugin's SQL folder.
To connect to a CalDAV you just need to toogle the Provider select box in calendar settings. When saved you'll see input fields to insert the access data.
Thanks for the instructions. Works great. However you need to specify "my calendar" in the default view (instead of "all calendar") otherwise the events don't show without changing the current calendar in the interface.
Bug: I can't get the email notification to work. I created an event with a notification 15 minutes before, and while my acal/android calendar showed the notification, I didn't receive any email in roundcube. I checked the options email notification, with the proper email address and a 15 min notification.
Comments/wishlist, not critical:
events. It would be nice to have that option in the event popup. 2. the password disappears after you enter it. I thought it was a bug. Might be a better user experience to have it show as masked in the password field. 3. most system will probably use the same authentication (LDAP ?) for both the imap and the calendar system. An option to reuse the roundcube auth for the calendar would be nice, and maybe a default pattern for the calendar location (such as https://server/davical/caldav.php/<RC-USERNAME>/home).
Well, this is just a few comments. I'm already VERY happy with the current plugin ! Thanks a lot.
Julien
List info: http://lists.roundcube.net/dev/ BT/aba52c80
On Sun, 22 May 2011 14:22:26 -0400, Julien Vehent wrote:
On Sun, 22 May 2011 05:46:59 +0200, Roland Liebl wrote:
You need to create three database tables: (*) events (*) events_cache (*) events_caldav
The scripts are located in the plugin's SQL folder.
To connect to a CalDAV you just need to toogle the Provider select box in calendar settings. When saved you'll see input fields to insert the access data.
Thanks for the instructions. Works great. However you need to specify "my calendar" in the default view (instead of "all calendar") otherwise the events don't show without changing the current calendar in the interface.
Will do.
Bug: I can't get the email notification to work. I created an event with a notification 15 minutes before, and while my acal/android calendar showed the notification, I didn't receive any email in roundcube. I checked the options email notification, with the proper email address and a 15 min notification.
Reminders are not implemented for CalDAV yet. It is on my ToDo's. Also it is planned to have reminders on a per event level instead of the current global level for the database backend.
Comments/wishlist, not critical:
- most calendar client propose to configure the notifications per
events. It would be nice to have that option in the event popup.
See above.
- the password disappears after you enter it. I thought it was a
bug. Might be a better user experience to have it show as masked in the password field.
Even if you show it masked it would be displayed in the html source. It would be possible to receive the password by AJAX, but that a security issue aswell.
- most system will probably use the same authentication (LDAP ?)
for both the imap and the calendar system. An option to reuse the roundcube auth for the calendar would be nice, and maybe a default pattern for the calendar location (such as https://server/davical/caldav.php/<RC-USERNAME>/home).
Well, I could provide a global configuration value to use these defaults for login - good idea.
Well, this is just a few comments. I'm already VERY happy with the current plugin ! Thanks a lot.
Julien
List info: http://lists.roundcube.net/dev/ BT/8d1870bd
List info: http://lists.roundcube.net/dev/ BT/aba52c80
On Sun, 22 May 2011 14:22:26 -0400, Julien Vehent wrote:
- most system will probably use the same authentication (LDAP ?)
for both the imap and the calendar system. An option to reuse the roundcube auth for the calendar would be nice, and maybe a default pattern for the calendar location (such as https://server/davical/caldav.php/<RC-USERNAME>/home).
I think the following config section should do the job:
/* default CalDAV backend (null = no default settings) %u will be replaced by $_SESSION['username'] %gu will be replaced by google calendar user (requires google_contacts plugin) %p will be replaced by Roundcube Login Password %gp will be replaced by google calendar password (requires google_contacts plugin) */
$rcmail_config['default_caldav_backend'] = array( 'server' => 'ssl://www.google.com:443', 'url' => 'https://www.google.com/calendar/dav/%gu/events', 'pass' => '%gp', );
Not implemented yet, just an idea!
List info: http://lists.roundcube.net/dev/ BT/aba52c80