[vz-users] [Error] Failed to load resource: the server responded with a status of 400 (Bad Request) (channel.json, line 0)

applicationMGR ecoCuyo applicationMGR at ecoCuyo.de
So Sep 3 12:28:22 CEST 2023


Hallo,

habe nach einem Datenbank Crash die Volkszähler DB mit purge entfernt und wieder neu installiert. Sowie die Middleware mit install.sh neu installiert.

Jetzt kann man jedoch im Frontend keine Kanäle anlegen.
Im Safari-Debugger kommt der Fehler im Betreff oben und verweist auf http://<ip-des servers>/api/channel.json
Im code hängt das ganze dann hier fest:

{
    "version": "0.3",
    "exception": {
        "message": "Call to undefined method Doctrine\\ORM\\UnitOfWork::assignPostInsertId()",
        "type": "Error",
        "code": 0
    }
}

Die User Rechte sollten so stimmen, nehm ich an?

MariaDB [volkszaehler]> show grants for 'vz'@'localhost';
+-----------------------------------------------------------------------------------------------------------+
| Grants for vz at localhost                                                                                   |
+-----------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO `vz`@`localhost` IDENTIFIED BY PASSWORD '*C142FB215B6E05B7C134B1A653AD4B455157FD79' |
| GRANT SELECT, INSERT, UPDATE, DELETE ON `volkszaehler`.* TO `vz`@`localhost`                              |
| GRANT DELETE ON `volkszaehler`.`aggregate` TO `vz`@`localhost`                                            |
| GRANT DELETE ON `volkszaehler`.`properties` TO `vz`@`localhost`                                           |
| GRANT DELETE ON `volkszaehler`.`entities_in_aggregator` TO `vz`@`localhost`                               |
+—————————————————————————————————————————————————————+

MariaDB [volkszaehler]> show grants for 'vz-admin'@'localhost';
+-----------------------------------------------------------------------------------------------------------------+
| Grants for vz-admin at localhost                                                                                   |
+-----------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO `vz-admin`@`localhost` IDENTIFIED BY PASSWORD '*DD8B9C6D80A0168BCFDE81CBFF4C5EB8C0CCCECA' |
| GRANT ALL PRIVILEGES ON `volkszaehler`.* TO `vz-admin`@`localhost` WITH GRANT OPTION                            |
+-----------------------------------------------------------------------------------------------------------------+

MariaDB [volkszaehler]> show grants for 'root'@'localhost';
+-----------------------------------------------------------------------------------------------------------------------------------------+
| Grants for root at localhost                                                                                                               |
+-----------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO `root`@`localhost` IDENTIFIED VIA mysql_native_password USING 'invalid' OR unix_socket WITH GRANT OPTION |
| GRANT PROXY ON ''@'%' TO 'root'@'localhost' WITH GRANT OPTION                                                                           |
+-----------------------------------------------------------------------------------------------------------------------------------------+

Hat jemand eine Idee für mich, wo ich anpacken muss?


Infos:

$ cat /etc/os-release 
PRETTY_NAME="Raspbian GNU/Linux 11 (bullseye)"
NAME="Raspbian GNU/Linux"
VERSION_ID="11"
VERSION="11 (bullseye)"
VERSION_CODENAME=bullseye
ID=raspbian
ID_LIKE=debian
HOME_URL="http://www.raspbian.org/"
SUPPORT_URL="http://www.raspbian.org/RaspbianForums"
BUG_REPORT_URL="http://www.raspbian.org/RaspbianBugs“

$ mysql -V
mysql  Ver 15.1 Distrib 10.5.19-MariaDB, for debian-linux-gnueabihf (armv7l) using  EditLine wrapper

$ vzlogger -V
0.8.2
 based on git version: heads/master-0-g35426c0a6e
 last commit date: Fri, 21 Jul 2023 11:27:17 +0200

$ php -version
PHP 7.4.33 (cli) (built: Jun  9 2023 16:51:37) ( NTS )
Copyright (c) The PHP Group
Zend Engine v3.4.0, Copyright (c) Zend Technologies
    with Zend OPcache v7.4.33, Copyright (c), by Zend Technologies


Viele Grüße
Armin
-------------- nächster Teil --------------
Ein Dateianhang mit HTML-Daten wurde abgetrennt...
URL: <http://demo.volkszaehler.org/pipermail/volkszaehler-users/attachments/20230903/1557b7ea/attachment.htm>


Mehr Informationen über die Mailingliste volkszaehler-users