search

julien-nc / phonetrack

Nextcloud app to create tracking sessions to display phones position in real time and export activity to gpx.
GNU Affero General Public License v3.0
67 stars 6 forks source link

Showing datapoints/Tracks in Webbrowser is broken after upgrade/downgrade of mysql #12

Open marc4s opened 1 year ago

marc4s commented 1 year ago

Hi,

somehow the view of datapoints is broken in my instance. Via Phonetrack-App it is still fine.

From my point of view it was general broken after the latest mysql/libmysql security update

Upgrade: libmysqlclient-dev:amd64 (8.0.33-0ubuntu0.20.04.2, 8.0.33-0ubuntu0.20.04.4), mysql-client-8.0:amd64 (8.0.33-0ubuntu0.20.04.2, 8.0.33-0ubuntu0.20.04.4), mysql-server:amd64 (8.0.33-0ubuntu0.20.04.2, 8.0.33-0ubuntu0.20.04.4), mysql-server-8.0:amd64 (8.0.33-0ubuntu0.20.04.2, 8.0.33-0ubuntu0.20.04.4), mysql-client:amd64 (8.0.33-0ubuntu0.20.04.2, 8.0.33-0ubuntu0.20.04.4), mysql-client-core-8.0:amd64 (8.0.33-0ubuntu0.20.04.2, 8.0.33-0ubuntu0.20.04.4), libmysqlclient21:amd64 (8.0.33-0ubuntu0.20.04.2, 8.0.33-0ubuntu0.20.04.4), mysql-server-core-8.0:amd64 (8.0.33-0ubuntu0.20.04.2, 8.0.33-0ubuntu0.20.04.4)

as after this upgrade everything was broken. webview, update and view view phonetrack. the only hint from logfile:

2023/07/26 13:14:43 [error] 1583#1583: *1 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Doctrine\DBAL\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory in /data1TB/www/nextcloud/lib/private/DB/Connection.php:139
Stack trace:
#0 /data1TB/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\DB\Connection->connect()
#1 /data1TB/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\DBAL\Connection->getWrappedConnection()
#2 /data1TB/www/nextcloud/lib/private/DB/Connection.php(261): Doctrine\DBAL\Connection->executeQuery()
#3 /data1TB/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\DB\Connection->executeQuery()
#4 /data1TB/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(281): Doctrine\DBAL\Query\QueryBuilder->execute()
#5 /data1TB/www/nextcloud/lib/private/AppConfig.php(419): OC\DB\QueryBuilder\QueryBuilder->execute()
#6 /data1TB/www/nextcloud/lib/private/AppConfig.php(184): OC\AppConfig->loadConfigValu" while reading response header from upstream, client: 2a03:4000:24:10::1, server: nextcloud.HOSTNAME.de, request: "GET /ocs/v2.php/apps/notifications/api/v2/notifications HTTP/2.0", upstream: "fastcgi://unix:/var/run/php/php8.1-fpm.sock:", host: "nextcloud.HOSTNAME.de:PORT", referrer: "https://nextcloud.HOSTNAME.de:PORT/"
2023/07/26 13:14:43 [error] 1583#1583: *1 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Doctrine\DBAL\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory in /data1TB/www/nextcloud/lib/private/DB/Connection.php:139
Stack trace:
#0 /data1TB/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\DB\Connection->connect()
#1 /data1TB/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\DBAL\Connection->getWrappedConnection()
#2 /data1TB/www/nextcloud/lib/private/DB/Connection.php(261): Doctrine\DBAL\Connection->executeQuery()
#3 /data1TB/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\DB\Connection->executeQuery()
#4 /data1TB/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(281): Doctrine\DBAL\Query\QueryBuilder->execute()
#5 /data1TB/www/nextcloud/lib/private/AppConfig.php(419): OC\DB\QueryBuilder\QueryBuilder->execute()
#6 /data1TB/www/nextcloud/lib/private/AppConfig.php(184): OC\AppConfig->loadConfigValu" while reading response header from upstream, client: 2a03:4000:24:10::1, server: nextcloud.HOSTNAME.de, request: "PUT /ocs/v2.php/apps/user_status/api/v1/heartbeat?format=json HTTP/2.0", upstream: "fastcgi://unix:/var/run/php/php8.1-fpm.sock:", host: "nextcloud.HOSTNAME.de:PORT", referrer: "https://nextcloud.HOSTNAME.de:PORT/"
2023/07/26 13:17:26 [error] 1583#1583: *52 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 2a02:3031:201:dde5:f555:dfb2:261b:268c, server: nextcloud.HOSTNAME.de, request: "POST /index.php/apps/phonetrack/logPost/f6a6163b381408e5adbdc0e05f9efe14/M2102J20SGPocoX3 HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php8.1-fpm.sock", host: "nextcloud.HOSTNAME.de:PORT"
2023/07/26 13:20:14 [error] 1583#1583: *65 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 2a03:4000:24:10::1, server: nextcloud.HOSTNAME.de, request: "GET /ocs/v2.php/apps/notifications/api/v2/notifications HTTP/2.0", upstream: "fastcgi://unix:/var/run/php/php8.1-fpm.sock", host: "nextcloud.HOSTNAME.de:PORT", referrer: "https://nextcloud.HOSTNAME.de:PORT/"
2023/07/26 13:20:25 [error] 1583#1583: *87 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 2a03:4000:24:10::1, server: nextcloud.HOSTNAME.de, request: "GET /apps HTTP/2.0", upstream: "fastcgi://unix:/var/run/php/php8.1-fpm.sock", host: "nextcloud.HOSTNAME.de:PORT"

after downgrading the packages above to "8.0.33-0ubuntu0.20.04.2" pohnetrack-android was able to send updates to the server and the phoinetrack app is able to show the datapoints. but not the webview in browser. it is still broken...

Would be great to get some help for fixing the webview