Bug#1004285: [DAViCal-devel] Bug#1004285: fixed in davical 1.1.11-1
Dear Florian, On 18/10/2022 13:01, Florian Schlichting wrote: On Mon, Oct 10, 2022 at 12:46:57PM +0200, Benno Overeinder wrote: Unfortunately the problem persists after updating to davical 1.1.11-1. I see the same messages in the Apache2 error.log as previously reported. looking at your error log from February, I think the crucial part is Fri Feb 18 21:14:58.430957 2022] [php:notice] [pid 49689] [client 192.168.1.1:64517] davical: BUG: :DAViCal Fatal Error: [0A000] SQLSTATE[0A000]: Feature not supported: 7 ERROR: set-returning functions are not allowed in CASE... This sounds like https://gitlab.com/davical-project/davical/-/issues/171 The important bit is to make sure that update-davical-database is run from the new package, and that it has replaced the expand_memberships function to not contain a CASE statement any more. Thanks for your email. I updated to php8.1 again and ran the update-davical-database script, and then restarted apache2. At first I saw the same errors, but after rebooting the server, DAViCal worked perfectly as before. Maybe some sticky state in one of the components (postgresql?). Thanks again for your support and maintaining the davical package. Cheers, -- Benno
Bug#1004285: fixed in davical 1.1.11-1
Thank you for your message. Unfortunately the problem persists after updating to davical 1.1.11-1. I see the same messages in the Apache2 error.log as previously reported. I am available to debug and test, as long as I can install packages or other necessary software. -- Benno -- System Information: Debian Release: bookworm/sid APT prefers testing APT policy: (500, 'testing') Architecture: amd64 (x86_64) Kernel: Linux 5.19.0-2-amd64 (SMP w/4 CPU threads; PREEMPT) Kernel taint flags: TAINT_FIRMWARE_WORKAROUND Locale: LANG=en_US.UTF-8, LC_CTYPE=C.UTF-8 (charmap=UTF-8), LANGUAGE=en_US:en Shell: /bin/sh linked to /usr/bin/dash Init: systemd (via /run/systemd/system) LSM: AppArmor: enabled Versions of packages davical depends on: ii libawl-php0.63-1 ii libdbd-pg-perl3.16.0-1 ii libyaml-perl 1.30-1 ii perl 5.34.0-5 ii php 2:8.1+92 ii php-pgsql 2:8.1+92 ii php-xml 2:8.1+92 ii php8.1 [php] 8.1.7-1 ii php8.1-cli [php-cli] 8.1.7-1+b1 ii php8.1-pgsql [php-pgsql] 8.1.7-1+b1 ii php8.1-xml [php-xml] 8.1.7-1+b1 ii postgresql-client-14 [postgresql-client] 14.5-2 Versions of packages davical recommends: ii php-curl2:8.1+92 ii php8.1-curl [php-curl] 8.1.7-1+b1 ii postgresql 14+243 Versions of packages davical suggests: pn php-ldap | php5-ldap On 04/10/2022 14:34, Debian FTP Masters wrote: Source: davical Source-Version: 1.1.11-1 Done: Florian Schlichting We believe that the bug you reported is fixed in the latest version of davical, which is due to be installed in the Debian FTP archive. A summary of the changes between this version and the previous one is attached. Thank you for reporting the bug, which will now be closed. If you have further comments please address them to 1004...@bugs.debian.org, and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Florian Schlichting (supplier of updated davical package) (This message was generated automatically at their request; if you believe that there is a problem with it please contact the archive administrators by mailing ftpmas...@ftp-master.debian.org) Format: 1.8 Date: Tue, 04 Oct 2022 13:56:36 +0200 Source: davical Architecture: source Version: 1.1.11-1 Distribution: unstable Urgency: medium Maintainer: Davical Development Team Changed-By: Florian Schlichting Closes: 1004285 1004393 Changes: davical (1.1.11-1) unstable; urgency=medium . * New upstream release(closes: #1004285, #1004393) * Depend on AWL 0.63 * Update copyright years * Declare compliance with Debian Policy 4.6.1 Checksums-Sha1: c549089a0cae8700da529349ea73a11dc5f092b8 2084 davical_1.1.11-1.dsc 06d8180a1c4daa86dcc970e11a3dc594a73968b0 1371432 davical_1.1.11.orig.tar.xz 5b74408b65427baf04a16555b558db3849f5e2eb 13016 davical_1.1.11-1.debian.tar.xz 8a18eba5624bccd5a912e0a9e015caa237c90c3b 7048 davical_1.1.11-1_amd64.buildinfo Checksums-Sha256: e3dee1c549f3a6c4536f8255779dd969ccd227c19f35d17d44f04dd33e675e11 2084 davical_1.1.11-1.dsc 75a6d821d51f9755f41181680466d0352679231b422519d9b4c12d1f52994f51 1371432 davical_1.1.11.orig.tar.xz bf3740bed8b239fb8a4a8f47bde1badd66172d0f199dc4c06b00f57afa08021e 13016 davical_1.1.11-1.debian.tar.xz 2d987e61478d734e8d7b31be27e396452dad9f27edbad7dc80f64f7ed51c4331 7048 davical_1.1.11-1_amd64.buildinfo Files: 8c95ce83fc74592be2f1ef24fc2fbeb8 2084 web optional davical_1.1.11-1.dsc e86053532dcfe8d06f11a9f46c7e66d5 1371432 web optional davical_1.1.11.orig.tar.xz b7a276491c71eeed2a6ea975e5bf3343 13016 web optional davical_1.1.11-1.debian.tar.xz 758834b092283fd179a9de739209e5f8 7048 web optional davical_1.1.11-1_amd64.buildinfo
Bug#1004285: [DAViCal-devel] Bug#1004285: davical: problems after upgrade to php 8, calendar clients reports "500"
Hi Florian, Thank you for your email. I haven't tested it with the git versions of AWL and DAViCal yet, but here is more are more lines from the apache log file. After upgrading (again) to php8, the following lines are in the apache2 error.log. I hope the formatting stays okay. I changed the IP address and username for the caldav.php references to the calendars. Hope this helps. If I have a bit more time, I can try the github version of AWL and DAViCal. [Fri Feb 18 21:13:27.917136 2022] [mpm_prefork:notice] [pid 47871] AH00163: Apache/2.4.52 (Debian) OpenSSL/1.1.1m configured -- resuming normal operations [Fri Feb 18 21:13:27.917271 2022] [core:notice] [pid 47871] AH00094: Command line: '/usr/sbin/apache2' [Fri Feb 18 21:14:15.536261 2022] [mpm_prefork:notice] [pid 47871] AH00170: caught SIGWINCH, shutting down gracefully [Fri Feb 18 21:14:15.642859 2022] [mpm_prefork:notice] [pid 49687] AH00163: Apache/2.4.52 (Debian) OpenSSL/1.1.1m configured -- resuming normal operations [Fri Feb 18 21:14:15.642922 2022] [core:notice] [pid 49687] AH00094: Command line: '/usr/sbin/apache2' [Fri Feb 18 21:14:58.422246 2022] [php:notice] [pid 49689] [client 192.168.1.1:64517] davical: ***: ERROR:XML parsing error: Unknown (202) at line 4, column 26 [Fri Feb 18 21:14:58.422288 2022] [php:notice] [pid 49689] [client 192.168.1.1:64517] davical: ***: ERROR:Error occurred in:\n\n /caldav.php/username/work/\n /caldav.php/username/home/\n\n [Fri Feb 18 21:14:58.422294 2022] [php:notice] [pid 49689] [client 192.168.1.1:64517] davical: ***: ERROR:XML namespace error but tags extracted, trying to continue [Fri Feb 18 21:14:58.430957 2022] [php:notice] [pid 49689] [client 192.168.1.1:64517] davical: BUG: :DAViCal Fatal Error: [0A000] SQLSTATE[0A000]: Feature not supported: 7 ERROR: set-returning functions are not allowed in CASE\nLINE 4: ... expanded.g_id FROM (SELECT CASE WHEN $2 > 0 THEN expand_mem...\n ^\nHINT: You might be able to move the set-returning function into a LATERAL FROM item.\nQUERY: \n SELECT group_id FROM group_member WHERE member_id = $1\n UNION\n SELECT expanded.g_id FROM (SELECT CASE WHEN $2 > 0 THEN expand_memberships( group_id, $2 - 1) END AS g_id\n FROM group_member WHERE member_id = $1) AS expanded\n WHERE expanded.g_id IS NOT NULL;\n\nCONTEXT: SQL function "expand_memberships" during startup\nSQL statement "SELECT bit_or(subquery.privileges)FROM\n(\n SELECT privileges FROM grants WHERE by_principal=in_grantor AND by_collection IS NULL\n AND (to_principal=in_accessor OR to_principal IN (SELECT expand_memberships(in_accessor,in_depth)))\nUNION\n SELECT 32::BIT(24) AS privileges FROM expand_memberships(in_accessor,in_depth) WHERE expand_memberships = in_grantor\n) AS subquery"\nPL/pgSQL function pprivs(bigint,bigint,integer) line 14 at SQL statement at /usr/share/awl/inc/AwlDatabase.php:94 [Fri Feb 18 21:14:58.430975 2022] [php:notice] [pid 49689] [client 192.168.1.1:64517] = Stack Trace === [Fri Feb 18 21:14:58.430999 2022] [php:notice] [pid 49689] [client 192.168.1.1:64517] davical: LOG: :Response status 500 for PROPFIND /caldav.php/username/ [Fri Feb 18 21:14:58.431005 2022] [php:notice] [pid 49689] [client 192.168.1.1:64517] davical: LOG: :* Response Header [Fri Feb 18 21:14:58.431009 2022] [php:notice] [pid 49689] [client 192.168.1.1:64517] davical: LOG: headers:-->Server: 1.1 [Fri Feb 18 21:14:58.431013 2022] [php:notice] [pid 49689] [client 192.168.1.1:64517] davical: LOG: headers:-->DAV: 1, 2, 3, access-control, calendar-access, calendar-schedule [Fri Feb 18 21:14:58.431017 2022] [php:notice] [pid 49689] [client 192.168.1.1:64517] davical: LOG: headers:-->DAV: extended-mkcol, bind, addressbook, calendar-auto-schedule, calendar-proxy [Fri Feb 18 21:14:58.431020 2022] [php:notice] [pid 49689] [client 192.168.1.1:64517] davical: LOG: headers:-->X-DAViCal-Version: DAViCal/1.1.10; DB/1.3.3 [Fri Feb 18 21:14:58.431024 2022] [php:notice] [pid 49689] [client 192.168.1.1:64517] davical: LOG: headers:-->Content-type: text/plain; charset="utf-8" [Fri Feb 18 21:14:58.431027 2022] [php:notice] [pid 49689] [client 192.168.1.1:64517] davical: LOG: : Response [Fri Feb 18 21:14:58.431064 2022] [php:notice] [pid 49689] [client 192.168.1.1:64517] davical: LOG: response:-->DAViCal Fatal Error [Fri Feb 18 21:14:58.725790 2022] [php:notice] [pid 49690] [client 192.168.1.1:64518] davical: ***: ERROR:XML parsing error: Unknown (202) at line 4, column 26 [Fri Feb 18 21:14:58.725814 2022] [php:notice] [pid 49690] [client 192.168.1.1:64518] davical: ***: ERROR:Error occurred in:\n\n /caldav.php/username/work/\n /caldav.php/username/home/\n\n [Fri Feb 18 21:14:58.725820 2022] [php:notice]
Bug#1004285: davical: problems after upgrade to php 8, calendar clients reports "500"
Some additional information. On 24/01/2022 11:58, Benno Overeinder wrote: * What exactly did you do (or not do) that was effective (or ineffective)? I have looked at the apache2 log files and checked the /etc/php and /etc/davical directories if there were any references to php7 instead of php/php8. The apache2 log file reported [Mon Jan 24 11:29:29.678647 2022] [php:notice] [pid 684] [client /IPv6 address/] davical: LOG: response:-->DAViCal Fatal Error The macOS Calendar application warned with the error message: “500” to operation CalDAVAccountRefreshQueueableOperation
Bug#1004285: davical: problems after upgrade to php 8, calendar clients reports "500"
Package: davical Version: 1.1.10-1 Severity: grave Justification: renders package unusable X-Debbugs-Cc: be...@overeinder.net Dear Maintainer, *** Reporter, please consider answering these questions, where appropriate *** * What led up to the situation? I am using debian testing. After upgrade to php8 (with all dependencies), my calendar applications/clients on laptop and mobile were unable to contact the davical server. I have also logged into the davical (apache2) server via web browser, and there the user administration web pages seem to work as before. * What exactly did you do (or not do) that was effective (or ineffective)? I have looked at the apache2 log files and checked the /etc/php and /etc/davical directories if there were any references to php7 instead of php/php8. The apache2 log file reported [Mon Jan 24 11:29:29.678647 2022] [php:notice] [pid 684] [client /IPv6 address/] davical: LOG: response:-->DAViCal Fatal Error * What was the outcome of this action? There were no hints or clues for me to further investigate what might be going on. * What outcome did you expect instead? *** End of the template - remove these template lines *** -- System Information: Debian Release: bookworm/sid APT prefers testing APT policy: (500, 'testing') Architecture: amd64 (x86_64) Kernel: Linux 5.15.0-3-amd64 (SMP w/4 CPU threads) Kernel taint flags: TAINT_FIRMWARE_WORKAROUND Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE=en_US:en Shell: /bin/sh linked to /usr/bin/dash Init: systemd (via /run/systemd/system) LSM: AppArmor: enabled Versions of packages davical depends on: ii libawl-php0.62-1 ii libdbd-pg-perl3.15.0-2 ii libyaml-perl 1.30-1 ii perl 5.32.1-6 ii php 2:8.1+92 ii php-pgsql 2:8.1+92 ii php-xml 2:8.1+92 ii php8.1 [php] 8.1.1-4 ii php8.1-cli [php-cli] 8.1.1-4 ii php8.1-pgsql [php-pgsql] 8.1.1-4 ii php8.1-xml [php-xml] 8.1.1-4 ii postgresql-client-14 [postgresql-client] 14.1-5 Versions of packages davical recommends: ii php-curl2:8.1+92 ii php8.1-curl [php-curl] 8.1.1-4 ii postgresql 14+237 Versions of packages davical suggests: pn php-ldap | php5-ldap -- no debconf information
