Hello,
for many reasons I have to change web server and switch from lighttpd
to nginx. Does anyone have experience with DAViCal and nginx? My first
tries have failed: first nginx does not implement required HTTP methods
such as OPTIONS and PROPFIND, but even adding an extention that
implement them, I still get a few errors:
1. syncing from and android implementation, I see these errors in the
nginx log:
192.168.222.54 - giuseppe [04/Oct/2020:16:20:48 +0200] "PROPFIND /davical/htdocs/caldav.php/giuseppe/calendar/ HTTP/2.0" 301 185 "-" "DAVx5/3.3.1-ose (2020/09/11; dav4jvm; okhttp/4.8.1) Android/10"
192.168.222.54 - giuseppe [04/Oct/2020:16:20:48 +0200] "PROPFIND /davical/htdocs/caldav.php/giuseppe/addresses/ HTTP/2.0" 301 185 "-" "DAVx5/3.3.1-ose (2020/09/11; dav4jvm; okhttp/4.8.1) Android/10"
192.168.222.54 - giuseppe [04/Oct/2020:16:20:49 +0200] "PROPFIND /davical/htdocs/caldav.php/giuseppe/calendar/ HTTP/2.0" 500 19 "-" "DAVx5/3.3.1-ose (2020/09/11; dav4jvm; okhttp/4.8.1) Android/10"
as you see, the third call fails with this details:
davical/htdocs/caldav.php: Query: QF: istruzione SQL "INSERT INTO sync_tokens(collection_id, sync_token) VALUES( in_collection_id, new_token )" funzione PL/pgSQL new_sync_token(bigint,bigint) riga 31 a istruzione SQL"
davical/htdocs/caldav.php: Query: QF: SELECT new_sync_token( 0, :collection_id) AS sync_token
davical/htdocs/caldav.php: Query: DBGQ: SELECT new_sync_token( 0, :collection_id) AS sync_token
davical/htdocs/caldav.php: Query: DBGQ: ":collection_id" => "-1"
davical/htdocs/caldav.php: Query: QF: SQL error "23503" - ERRORE: la INSERT o l'UPDATE sulla tabella "sync_tokens" viola il vincolo di chiave esterna "sync_tokens_collection_id_fkey" DETTAGLI: La chiave (collection_id)=(-1) non è presente nella tabella "collection". CONTESTO:
davical/htdocs/caldav.php: Query: QF: istruzione SQL "INSERT INTO sync_tokens(collection_id, sync_token) VALUES( in_collection_id, new_token )" funzione PL/pgSQL new_sync_token(bigint,bigint) riga 31 a istruzione SQL"
davical/htdocs/caldav.php: Query: QF: SELECT new_sync_token( 0, :collection_id) AS sync_token
:DAViCal Fatal Error: [0] Problem with database query at /usr/share/davical/inc/DAVResource.php:1359
So, the collection_id=-1 is not a valid value.
2. syncing from a CalDAV client (evolution from Gnome on Linux)
the error message is about a REPORT method. I think to understand this
is an HTTP method but I do not understand if this has to be implemented
in the web server (and it is missing on nginx, even with the dav-ext
extention) or in DAViCal that seems to advertise it support that
method.
About the latter possibility, I tried to define:
$c->override_allowed_methods = "OPTIONS, GET, HEAD, PUT, DELETE,
PROPFIND, MKCOL";
in my config.php file, but this hasn't fixed the problem.
Thank you,
Giuseppe
_______________________________________________
Davical-general mailing list
Davical-general@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/davical-general
for many reasons I have to change web server and switch from lighttpd
to nginx. Does anyone have experience with DAViCal and nginx? My first
tries have failed: first nginx does not implement required HTTP methods
such as OPTIONS and PROPFIND, but even adding an extention that
implement them, I still get a few errors:
1. syncing from and android implementation, I see these errors in the
nginx log:
192.168.222.54 - giuseppe [04/Oct/2020:16:20:48 +0200] "PROPFIND /davical/htdocs/caldav.php/giuseppe/calendar/ HTTP/2.0" 301 185 "-" "DAVx5/3.3.1-ose (2020/09/11; dav4jvm; okhttp/4.8.1) Android/10"
192.168.222.54 - giuseppe [04/Oct/2020:16:20:48 +0200] "PROPFIND /davical/htdocs/caldav.php/giuseppe/addresses/ HTTP/2.0" 301 185 "-" "DAVx5/3.3.1-ose (2020/09/11; dav4jvm; okhttp/4.8.1) Android/10"
192.168.222.54 - giuseppe [04/Oct/2020:16:20:49 +0200] "PROPFIND /davical/htdocs/caldav.php/giuseppe/calendar/ HTTP/2.0" 500 19 "-" "DAVx5/3.3.1-ose (2020/09/11; dav4jvm; okhttp/4.8.1) Android/10"
as you see, the third call fails with this details:
davical/htdocs/caldav.php: Query: QF: istruzione SQL "INSERT INTO sync_tokens(collection_id, sync_token) VALUES( in_collection_id, new_token )" funzione PL/pgSQL new_sync_token(bigint,bigint) riga 31 a istruzione SQL"
davical/htdocs/caldav.php: Query: QF: SELECT new_sync_token( 0, :collection_id) AS sync_token
davical/htdocs/caldav.php: Query: DBGQ: SELECT new_sync_token( 0, :collection_id) AS sync_token
davical/htdocs/caldav.php: Query: DBGQ: ":collection_id" => "-1"
davical/htdocs/caldav.php: Query: QF: SQL error "23503" - ERRORE: la INSERT o l'UPDATE sulla tabella "sync_tokens" viola il vincolo di chiave esterna "sync_tokens_collection_id_fkey" DETTAGLI: La chiave (collection_id)=(-1) non è presente nella tabella "collection". CONTESTO:
davical/htdocs/caldav.php: Query: QF: istruzione SQL "INSERT INTO sync_tokens(collection_id, sync_token) VALUES( in_collection_id, new_token )" funzione PL/pgSQL new_sync_token(bigint,bigint) riga 31 a istruzione SQL"
davical/htdocs/caldav.php: Query: QF: SELECT new_sync_token( 0, :collection_id) AS sync_token
:DAViCal Fatal Error: [0] Problem with database query at /usr/share/davical/inc/DAVResource.php:1359
So, the collection_id=-1 is not a valid value.
2. syncing from a CalDAV client (evolution from Gnome on Linux)
the error message is about a REPORT method. I think to understand this
is an HTTP method but I do not understand if this has to be implemented
in the web server (and it is missing on nginx, even with the dav-ext
extention) or in DAViCal that seems to advertise it support that
method.
About the latter possibility, I tried to define:
$c->override_allowed_methods = "OPTIONS, GET, HEAD, PUT, DELETE,
PROPFIND, MKCOL";
in my config.php file, but this hasn't fixed the problem.
Thank you,
Giuseppe
_______________________________________________
Davical-general mailing list
Davical-general@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/davical-general