
oliver.werner at kontrast
Jul 5, 2013, 5:09 AM
Post #1 of 6
(127 views)
Permalink
|
|
Davical with Mountain Lion
|
|
Hi, I have a Problem with our Davical-Server (Version 1.1.1). My Mac (10.8.4) is connect via iCal with the Server. When invite some people in a Event i got an Error with: Die Anfrage (CalDAVScheduleEventQueueableOperation) für „„Neues Ereignis“ in „Test123“ im Account „devkalender.kontrast.de““ ist fehlgeschlagen. In Serverlog I found this. --------- [Fri Jul 05 13:49:56 2013] [error] [client 192.168.111.209] davical: LOG: PUT: Query: Error: QF in '/daten/davical/inc/caldav-PUT-functions.php' on line 1379 [Fri Jul 05 13:49:56 2013] [error] [client 192.168.111.209] davical: LOG: PUT: Query: QF: SQL error "23505" - FEHLER: doppelter Schl\xc3\xbcsselwert verletzt Unique-Constraint \xc2\xbbcaldav_data_pkey\xc2\xab DETAIL: Schl\xc3\xbcssel \xc2\xbb(user_no, dav_name)=(1001, /oliver.werner/.in/86f173ed386c2f72cdacd650787c73d9.ics)\xc2\xab existiert bereits." [Fri Jul 05 13:49:56 2013] [error] [client 192.168.111.209] davical: LOG: PUT: Query: Error: QF in '/daten/davical/inc/caldav-PUT-functions.php' on line 1379 [Fri Jul 05 13:49:56 2013] [error] [client 192.168.111.209] davical: LOG: PUT: Query: QF: INSERT INTO caldav_data ( dav_id, user_no, dav_name, dav_etag, caldav_data, caldav_type, logged_user, created, modified, collection_id, weak_etag ) VALUES( :dav_id, :user_no, :dav_name, :etag, :dav_data, :caldav_type, :session_user, :create [Fri Jul 05 13:49:56 2013] [error] [client 192.168.111.209] davical: LOG: PUT: Query: QF: d, :modified, :collection_id, :weak_etag ) [Fri Jul 05 13:49:56 2013] [error] [client 192.168.111.209] davical: FATAL: :Insert into calendar_item failed... [Fri Jul 05 13:49:56 2013] [error] [client 192.168.111.209] ================= Stack Trace =================== [Fri Jul 05 13:49:56 2013] [error] [client 192.168.111.209] ===> /daten/davical/htdocs/caldav.php[114] calls include() [Fri Jul 05 13:49:56 2013] [error] [client 192.168.111.209] ===> /daten/davical/inc/caldav-POST.php[157] calls handle_schedule_request() [Fri Jul 05 13:49:56 2013] [error] [client 192.168.111.209] ===> /daten/davical/inc/caldav-PUT-functions.php[263] calls write_resource() ----------- After this I can't do any this my Caldav-Account. I need to delete it from iCal and create the Account again. Also i got the Error CalDAVScheduleEventQueueableOperation when delete an Kalender via iCal. Here are my url-conf.php: (I'm using LDAP-User) -------- ## Datenbank Anbindung $c->pg_connect[] ='dbname=davical port=5432 host=127.0.0.1 user=davical password='; ## Settings $c->system_name = "DEV CalDAV Server"; $c->default_locale = "de_DE.UTF-8"; $c->admin_email ='oliver.werner [at] kontrast'; $c->enable_row_linking = true; # Sonstige Anpassungen $c->enable_auto_schedule = true; $c->public_freebusy_url = true; $c->default_privileges = array('read-free-busy', 'schedule-query-freebusy'); $c->override_dav_header = '1, 2, 3, access-control, calendar-access, calendar-schedule, extended-mkcol, calendar-proxy, bind'; ## LDAP $c->authenticate_hook['call'] = 'LDAP_check'; $c->authenticate_hook['config'] = array( 'host' => 'ipadress', //host name of your LDAP Server 'port' => '389', //port 'protocolVersion' => 3, //Version of LDAP protocol to use 'baseDNUsers'=> 'o=people,dc=kontrast,dc=de', //where to look at valid user 'filterUsers' => 'objectClass=*', //filter which must validate a user according to RFC4515, i.e. surrounded by brackets 'baseDNGroups' => 'ou=Groups,dc=kontrast,dc=de', //not used ATM 'filterGroups' => 'objectClass=posixGroup', //not used ATM 'mapping_field' => array("username" => "uid", "fullname" => "cn" , "email" =>"mail" ), //used to create the user based on his ldap properties 'format_updated' => array('Y' => array(0,4), 'm' => array(4,2), 'd'=> array(6,2), 'H' => array(8,2), 'M'=>array(10,2), 'S' => array(12,2)), /** used to set default value for all users, will be overcharged by ldap if defined also in mapping_field **/ //'default_value' => array("date_format_type" => "E","locale" => "de_DE"), /** foreach key set start and length in the string provided by ldap example for openLDAP timestamp : 20070503162215Z **/ 'scope' => 'subtree' //'startTLS' => false, ); include('drivers_ldap.php'); ------------------------------------------------ Somewhere have an idea or tip for me? Thanks
|