[vz-users] Network Error /entity.json?unique=1755939064657: Bad Request

applicationMGR ecoCuyo applicationMGR at ecoCuyo.de
Sa Aug 23 11:14:59 CEST 2025


Hallo zusammen,

habe einen neuen Volkszäher installiert (vom image).
Leider kann ich keine Kanäle anlegen. Beim Versuch erscheint der o.g. Fehler am Frontend: Network Error /entity.json?unique=1755939064657:  Bad Request

Bei weiteren Fragen freue mich über Rückmeldungen...

Würde mich freuen, wenn mir jemand weiterhelfen kann!

Viele Grüße
Armin


Hier einige Infos zur Konfiguration:

$ 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"

$ vzlogger -V
0.8.1
 based on git version: heads/master-0-g76e868feed
 last commit date: Wed, 20 Apr 2022 08:39:54 +0200


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

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`                               |
+-----------------------------------------------------------------------------------------------------------+
5 rows in set (0.001 sec)

MariaDB [volkszaehler]> show grants for 'vz-admin'@'localhost';
+-----------------------------------------------------------------------------------------------------------------+
| Grants for vz-admin at localhost                                                                                   |
+-----------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO `vz-admin`@`localhost` IDENTIFIED BY PASSWORD '*A36BA850A6E748679226B01E159EF1A7BF946195' |
| GRANT ALL PRIVILEGES ON `volkszaehler`.* TO `vz-admin`@`localhost` WITH GRANT OPTION                            |
+-----------------------------------------------------------------------------------------------------------------+
2 rows in set (0.000 sec)

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                                                                           |
+-----------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.000 sec)


Ansonsten ist die DB leer:

MariaDB [volkszaehler]> show tables;
+------------------------+
| Tables_in_volkszaehler |
+------------------------+
| aggregate              |
| data                   |
| entities               |
| entities_in_aggregator |
| properties             |
+------------------------+
5 rows in set (0.001 sec)

MariaDB [volkszaehler]> select * from entities;
Empty set (0.001 sec)

MariaDB [volkszaehler]> select * from properties;
Empty set (0.001 sec)

MariaDB [volkszaehler]> select * from data;
Empty set (0.001 sec)

Die /var/www/volkszaehler.org/etc/ <http://volkszaehler.org/etc/config.yaml>config.yaml <http://volkszaehler.org/etc/config.yaml> sieht so aus:

$ cat config.yaml
# general settings overriding php configuration
php:
  timezone: Europe/Berlin
  locale: ['de_DE', 'en_US', 'C']

# Doctrine database configuration
# http://www.doctrine-project.org/projects/doctrine-dbal/en/2.6
db:
  driver: pdo_mysql
  host: localhost
  # port: 3306
  user: vz
  password: demo
  charset: utf8
  dbname: volkszaehler
  path: volkszaehler # only used for sqlite

  # db admin credentials (used by doctrine cli and setup script)
  admin:
    user: vz-admin
    password: secure

  # database optimizer - leave empty for automatic
  # optimizer: Volkszaehler\Interpreter\SQL\MySQLOptimizer # provides additional group=15m setting for demo purposes

# push server for realtime frontend updates
push:
  server: 5582
  broadcast: 8082
  # routes for wamp access
  wamp:
    - /
    - /ws
  # routes for plain web socket access
  websocket:
    - /socket

network:
  # limit maximum POST body size, e.g. 4096
  postlimit: false

# enable debug messages by default if true
debug: false

VZLOGGER.conf

$ cat /etc/vzlogger.conf
/**
 * vzlogger configuration
 *
 * Use properly encoded JSON with javascript comments
 *
 * Take a look at the wiki for detailed information:
 * http://wiki.volkszaehler.org/software/controller/vzlogger#configuration
 *
 * For an online configuration editor refer to:
 * http://volkszaehler.github.io/vzlogger/
 */

{
    // General settings
    "verbosity": 5,         // log verbosity (0=log_alert, 1=log_error, 3=log_warning, 5=log_info, 10=log_debug, 15=log_finest)
    "log": "/var/log/vzlogger/vzlogger.log", // log file, optional
    "retry": 3,            // http retry delay in seconds

    // Build-in HTTP server
    "local": {
        "enabled": false,   // enable local HTTPd for serving live readings
        "port": 8080,       // TCP port for local HTTPd
        "index": true,      // provide index listing of available channels if no UUID was requested
        "timeout": 30,      // timeout for long polling comet requests in seconds (0 disables comet)
        "buffer": 600        // HTTPd buffer configuration for serving readings, default -1
                            //   >0: number of seconds of readings to serve
                            //   <0: number of tuples to server per channel (e.g. -3 will serve 3 tuples)
    },

    // realtime notification settings
    "push": [
        {
            "url": "http://127.0.0.1:5582"  // notification destination, e.g. frontend push-server
        }
    ],

    // mqtt client support (if ENABLE_MQTT set at cmake generation)
    "mqtt": {
        "enabled": false,  // enable mqtt client. needs host and port as well
        "host": "test.mosquitto.org", // mqtt server addr
        "port": 1883, // 1883 for unencrypted, 8883 enc, 8884 enc cert needed,
        "cafile": "", // optional file with server CA
        "capath": "", // optional path for server CAs. see mosquitto.conf. Specify only cafile or capath
        "certfile": "", // optional file for your client certificate (e.g. client.crt)
        "keyfile": "", // optional path for your client certficate private key (e.g. client.key)
        "keypass": "", // optional password for your private key
        "keepalive": 30, // optional keepalive in seconds.
        "topic": "vzlogger/data", // optional topic dont use $ at start and no / at end
        "id": "", // optional static id, if not set "vzlogger_<pid>" will be used
        "user": "", // optional user name for the mqtt server
        "pass": "", // optional password for the mqtt server
        "retain": false, // optional use retain message flag
        "rawAndAgg": false, // optional publish raw values even if agg mode is used
        "qos": 0, // optional quality of service, default is 0
        "timestamp": false // optional whether to include a timestamp in the payload
    },

    // Meter configuration
    "meters" : [{
	"protocol" : "sml",
	"enabled" : true,
	"device" : "/dev/ttyUSB0",
	"parity" : "8N1",
	"baudrate" : 9600,
	"use_local_time": true,  // manche Zaehler sind falsch konfiguriert und liefern unbrauchbare Zeitstempel
	"aggtime" : -1,
	"aggfixedinterval" : true,
	"channels": [{
		"api": "volkszaehler",      // middleware api, default volkszaehler
		"uuid" : "",
		"middleware" : "http://localhost/middleware.php",
		"identifier" : "1-0:1.8.2", // kann bei manchen Zählern auch "1-0:1.8.0" sein (siehe Logfile)
		"aggmode" : "MAX"
		}]
	}
    ]
}
 
-------------- nächster Teil --------------
Ein Dateianhang mit HTML-Daten wurde abgetrennt...
URL: <http://demo.volkszaehler.org/pipermail/volkszaehler-users/attachments/20250823/7194e4e8/attachment-0001.htm>


Mehr Informationen über die Mailingliste volkszaehler-users