Re: [Davical-general] SQL error after upgrade: ":collection_id" => "-1"

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Hi Giuseppe,

That doesn't appear to be the collection that was mentioned in the last
error, which was /caldav.php/giuseppe/addresses . Although I see this is
also complaining. Just a different error. Are you able to use the web UI to
check the configuration of your collections?

On Sun, 2023-06-18 at 10:00 +0200, Giuseppe Sacco via Davical-general wrote:
> Hello Andrew,
> thank you for your reply.
> 
> Il giorno dom, 18/06/2023 alle 14.16 +1200, Andrew Ruthven ha scritto:
> > If the collection belongs to your user, not being a member of a group
> > shouldn't be a problem.
> > 
> > Can you please turn on
> > debugging? https://wiki.davical.org/index.php?title=Debugging
> 
> I think this is what you requested, using evolution as a client:
> 
> ALL: I18N:Set locale to =it_IT.UTF-8=
> ALL: I18N:Bound domain =davical= to location =/usr/share/davical/locale=
> using character set =UTF-8=
> ALL: caldav:Version (1.1.12) == 1001.12
> LOG: always: Query: DBGQ: SELECT schema_major, schema_minor, schema_patch
> FROM awl_db_revision ORDER BY schema_id DESC LIMIT 1;
> LOG: always: Query: DBGQ: Took: 0,000621 to find 1 rows.
> LOG: always: Query: DBGQ: SET TIMEZONE TO ?
> LOG: always: Query: DBGQ:  "0" => "UTC"
> LOG: always: Query: DBGQ: Took: 0,000275 to find 0 rows.
> LOG: :***************** Request Header ****************
> LOG: :REPORT /caldav.php/giuseppe/calendar/
> LOG: headers:-->Depth: 1
> LOG: headers:-->Authorization: Delicious tasty password eaten by debugging
> monster!
> LOG: headers:-->Accept-Language: it-it, it;q=0.9
> LOG: headers:-->Accept-Encoding: gzip, deflate, br
> LOG: headers:-->Content-Length: 278
> LOG: headers:-->Content-Type: application/xml; charset="utf-8"
> LOG: headers:-->Pragma: no-cache
> LOG: headers:-->Cache-Control: no-cache
> LOG: headers:-->User-Agent: Evolution/3.46.4
> LOG: headers:-->Host: cal.domani.tld
> LOG: :******************** Request ********************
> LOG: request:--><calendar-query xmlns="urn:ietf:params:xml:ns:caldav"
> xmlns:D="DAV:"><D:prop><D:getetag/></D:prop><filter><comp-filter
> name="VCALENDAR"><comp-filter name="VEVENT"><time-range
> start="20230514T074916Z" end="20230723T074916Z"/></comp-filter></comp-
> filter></filter></calendar-query>
> ALL: Cache:memcache_servers isn't set, using NoCache dummy interface
> LOG: Principal: Query: DBGQ: SELECT *, 0::BIT(24) AS privileges FROM
> dav_principal WHERE lower(username)=lower(text(:param))
> LOG: Principal: Query: DBGQ:  ":param" => "giuseppe"
> LOG: Principal: Query: DBGQ: Took: 0,001792 to find 1 rows.
> LOG: BasicAuth: Query: DBGQ: SELECT role_name FROM role_member m join
> roles r ON r.role_no = m.role_no WHERE user_no = :user_no
> LOG: BasicAuth: Query: DBGQ:  ":user_no" => "1001"
> LOG: BasicAuth: Query: DBGQ: Took: 0,000435 to find 0 rows.
> ALL: Principal:No useful path split possible
> LOG: Principal: Query: DBGQ: SELECT *,
> pprivs(:session_principal::int8,principal_id,:scan_depth::int) AS
> privileges FROM dav_principal WHERE lower(username)=lower(text(:param))
> LOG: Principal: Query: DBGQ:  ":session_principal" => "1001"
> LOG: Principal: Query: DBGQ:  ":scan_depth" => "2"
> LOG: Principal: Query: DBGQ:  ":param" => "giuseppe"
> LOG: Principal: Query: DBGQ: Took: 0,001548 to find 1 rows.
> LOG: caldav: Query: DBGQ: SELECT * FROM collection WHERE dav_name =
> :exact_name OR dav_name = :truncated_name OR dav_name =
> :trailing_slash_name ORDER BY LENGTH(dav_name) DESC LIMIT 1
> LOG: caldav: Query: DBGQ:  ":exact_name" => ""
> LOG: caldav: Query: DBGQ:  ":truncated_name" => ""
> LOG: caldav: Query: DBGQ:  ":trailing_slash_name" => "/"
> LOG: caldav: Query: DBGQ: Took: 0,000459 to find 0 rows.
> ALL: caldav: Collection '' is 0, type
> ALL: Principal:No useful path split possible
> LOG: Principal: Query: DBGQ: SELECT *,
> pprivs(:session_principal::int8,principal_id,:scan_depth::int) AS
> privileges FROM dav_principal WHERE lower(username)=lower(text(:param))
> LOG: Principal: Query: DBGQ:  ":session_principal" => "1001"
> LOG: Principal: Query: DBGQ:  ":scan_depth" => "2"
> LOG: Principal: Query: DBGQ:  ":param" => "giuseppe"
> LOG: Principal: Query: DBGQ: Took: 0,000383 to find 1 rows.
> LOG: DAVPrincipal: Query: DBGQ: SELECT usr.username FROM group_member JOIN
> principal ON (principal_id=group_id) JOIN usr USING(user_no) WHERE
> usr.active=true AND member_id = :member_id UNION SELECT usr.username FROM
> group_member LEFT JOIN grants ON (to_principal=group_id)
> LOG: DAVPrincipal: Query: DBGQ:  JOIN principal ON
> (principal_id=by_principal) JOIN usr USING(user_no) WHERE usr.active=true
> AND member_id = :member_id and by_principal != member_id ORDER BY 1
> LOG: DAVPrincipal: Query: DBGQ:  ":member_id" => "1001"
> LOG: DAVPrincipal: Query: DBGQ: Took: 0,001114 to find 0 rows.
> ALL: principal: User: giuseppe (1001) URL: /caldav.php/giuseppe/, By
> Email: 0
> ALL: caldav:Full read permissions for user accessing /
> ALL: caldav: Parsed incoming XML request body.
> ALL: REPORT:method handler
> ng:  fopen(/var/log/davical/REPORT.debug): Failed to open stream: File o
> directory non esistente in /usr/share/davical/inc/caldav-REPORT.php on
> line 19
> ALL: DAVResource::FetchCollection: Looking for collection for "/".
> LOG: DAVResource: Query: DBGQ: SELECT collection.*,
> path_privs(:session_principal::int8,
> collection.dav_name,:scan_depth::int), p.principal_id, p.type_id AS
> principal_type_id, p.displayname AS principal_displayname,
> p.default_privileges AS principal_default_privileges, t
> LOG: DAVResource: Query: DBGQ: imezones.vtimezone FROM collection LEFT
> JOIN principal p USING (user_no) LEFT JOIN timezones ON
> (collection.timezone=timezones.tzid) WHERE collection.dav_name = :raw_path
> ORDER BY LENGTH(collection.dav_name) DESC LIMIT 1
> LOG: DAVResource: Query: DBGQ:  ":raw_path" => "/"
> LOG: DAVResource: Query: DBGQ:  ":session_principal" => "1001"
> LOG: DAVResource: Query: DBGQ:  ":scan_depth" => "2"
> LOG: DAVResource: Query: DBGQ: Took: 0,000811 to find 0 rows.
> ALL: Cache::FetchCollection: Setting cache ns "collection-/" key
> "dav_resource1001". Type: root
> ALL: DAVResource::FetchCollection: Found collection named "/" of type
> "root".
> ALL: DAVResource::FromPath: Path "/" is <DAV::collection/> a collection.
> ALL: DAVResource::FetchPrivileges: Read permissions for user accessing /
> ALL: DAVResource:Testing any privileges of "Array" (1000000001) against
> allowed "110001" => "1" (1)
> ALL: DAVResource::FetchCollection: Looking for collection for "/".
> LOG: DAVResource: Query: DBGQ: SELECT collection.*,
> path_privs(:session_principal::int8,
> collection.dav_name,:scan_depth::int), p.principal_id, p.type_id AS
> principal_type_id, p.displayname AS principal_displayname,
> p.default_privileges AS principal_default_privileges, t
> LOG: DAVResource: Query: DBGQ: imezones.vtimezone FROM collection LEFT
> JOIN principal p USING (user_no) LEFT JOIN timezones ON
> (collection.timezone=timezones.tzid) WHERE collection.dav_name = :raw_path
> ORDER BY LENGTH(collection.dav_name) DESC LIMIT 1
> LOG: DAVResource: Query: DBGQ:  ":raw_path" => "/"
> LOG: DAVResource: Query: DBGQ:  ":session_principal" => "1001"
> LOG: DAVResource: Query: DBGQ:  ":scan_depth" => "2"
> LOG: DAVResource: Query: DBGQ: Took: 0,000767 to find 0 rows.
> ALL: Cache::FetchCollection: Setting cache ns "collection-/" key
> "dav_resource1001". Type: root
> ALL: DAVResource::FetchCollection: Found collection named "/" of type
> "root".
> ALL: DAVResource::FromPath: Path "/" is <DAV::collection/> a collection.
> ALL: I18N:Translated =The calendar-query report must be run against a
> calendar or a scheduling collection= into =The calendar-query report must
> be run against a calendar or a scheduling collection=
> LOG: :Response status 403 for REPORT /caldav.php/giuseppe/calendar/
> LOG: :***************** Response Header ****************
> LOG: headers:-->Server: 1.1
> LOG: headers:-->DAV: 1, 2, 3, access-control, calendar-access, calendar-
> schedule
> LOG: headers:-->DAV: extended-mkcol, bind, addressbook, calendar-auto-
> schedule, calendar-proxy
> LOG: headers:-->X-DAViCal-Version: DAViCal/1.1.12; DB/1.3.5
> LOG: headers:-->Content-type: text/plain; charset="utf-8"
> LOG: :******************** Response ********************
> LOG: response:-->The calendar-query report must be run against a calendar
> or a scheduling collection
> 
> Thank you very much,
> Giuseppe
> 
> 
> _______________________________________________
> Davical-general mailing list
> Dav...@li...
> https://lists.sourceforge.net/lists/listinfo/davical-general

-- 
Andrew Ruthven, Wellington, New Zealand
an...@et... |
Catalyst Cloud: | This space intentionally left blank
https://catalystcloud.nz |