🙋password authentication failed for user dsmr #1583

LEJOUI · 2022-02-11T20:26:20Z

LEJOUI
Feb 11, 2022

Description

Ik probeer te upgraden naar v5, nadat ik command ./manage.py migrate heb ingetikt krijg ik krijg onderstaande error:

Traceback (most recent call last):
  File "./manage.py", line 10, in <module>
    execute_from_command_line(sys.argv)
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/core/management/__init__.py", line 419, in execute_from_command_line
    utility.execute()
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/core/management/__init__.py", line 413, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/core/management/base.py", line 354, in run_from_argv
    self.execute(*args, **cmd_options)
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/core/management/base.py", line 398, in execute
    output = self.handle(*args, **options)
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/core/management/base.py", line 89, in wrapped
    res = handle_func(*args, **kwargs)
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/core/management/commands/migrate.py", line 75, in handle
    self.check(databases=[database])
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/core/management/base.py", line 423, in check
    databases=databases,
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/core/checks/registry.py", line 76, in run_checks
    new_errors = check(app_configs=app_configs, databases=databases)
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/core/checks/model_checks.py", line 34, in check_all_models
    errors.extend(model.check(**kwargs))
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/db/models/base.py", line 1303, in check
    *cls._check_indexes(databases),
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/db/models/base.py", line 1695, in _check_indexes
    connection.features.supports_covering_indexes or
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/utils/functional.py", line 48, in __get__
    res = instance.__dict__[self.name] = self.func(instance)
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/db/backends/postgresql/features.py", line 93, in is_postgresql_11
    return self.connection.pg_version >= 110000
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/utils/functional.py", line 48, in __get__
    res = instance.__dict__[self.name] = self.func(instance)
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/db/backends/postgresql/base.py", line 329, in pg_version
    with self.temporary_connection():
  File "/usr/lib/python3.7/contextlib.py", line 112, in __enter__
    return next(self.gen)
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/db/backends/base/base.py", line 603, in temporary_connection
    with self.cursor() as cursor:
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/utils/asyncio.py", line 33, in inner
    return func(*args, **kwargs)
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/db/backends/base/base.py", line 259, in cursor
    return self._cursor()
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/db/backends/base/base.py", line 235, in _cursor
    self.ensure_connection()
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/utils/asyncio.py", line 33, in inner
    return func(*args, **kwargs)
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/db/backends/base/base.py", line 219, in ensure_connection
    self.connect()
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/db/utils.py", line 90, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/db/backends/base/base.py", line 219, in ensure_connection
    self.connect()
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/utils/asyncio.py", line 33, in inner
    return func(*args, **kwargs)
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/db/backends/base/base.py", line 200, in connect
    self.connection = self.get_new_connection(conn_params)
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/utils/asyncio.py", line 33, in inner
    return func(*args, **kwargs)
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/db/backends/postgresql/base.py", line 187, in get_new_connection
    connection = Database.connect(**conn_params)
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/psycopg2/__init__.py", line 122, in connect
    conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
django.db.utils.OperationalError: connection to server at "localhost" (::1), port 5432 failed: FATAL:  password authentication failed for user "dsmr"
connection to server at "localhost" (::1), port 5432 failed: FATAL:  password authentication failed for user "dsmr"

DSMR-reader version

v5

DSMR-reader platform

Native (e.g. manual installation)

Debug info dump

Traceback (most recent call last):
  File "./manage.py", line 10, in <module>
    execute_from_command_line(sys.argv)
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/core/management/__init__.py", line 419, in execute_from_command_line
    utility.execute()
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/core/management/__init__.py", line 413, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/core/management/base.py", line 354, in run_from_argv
    self.execute(*args, **cmd_options)
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/core/management/base.py", line 398, in execute
    output = self.handle(*args, **options)
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/core/management/base.py", line 89, in wrapped
    res = handle_func(*args, **kwargs)
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/core/management/commands/migrate.py", line 75, in handle
    self.check(databases=[database])
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/core/management/base.py", line 423, in check
    databases=databases,
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/core/checks/registry.py", line 76, in run_checks
    new_errors = check(app_configs=app_configs, databases=databases)
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/core/checks/model_checks.py", line 34, in check_all_models
    errors.extend(model.check(**kwargs))
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/db/models/base.py", line 1303, in check
    *cls._check_indexes(databases),
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/db/models/base.py", line 1695, in _check_indexes
    connection.features.supports_covering_indexes or
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/utils/functional.py", line 48, in __get__
    res = instance.__dict__[self.name] = self.func(instance)
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/db/backends/postgresql/features.py", line 93, in is_postgresql_11
    return self.connection.pg_version >= 110000
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/utils/functional.py", line 48, in __get__
    res = instance.__dict__[self.name] = self.func(instance)
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/db/backends/postgresql/base.py", line 329, in pg_version
    with self.temporary_connection():
  File "/usr/lib/python3.7/contextlib.py", line 112, in __enter__
    return next(self.gen)
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/db/backends/base/base.py", line 603, in temporary_connection
    with self.cursor() as cursor:
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/utils/asyncio.py", line 33, in inner
    return func(*args, **kwargs)
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/db/backends/base/base.py", line 259, in cursor
    return self._cursor()
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/db/backends/base/base.py", line 235, in _cursor
    self.ensure_connection()
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/utils/asyncio.py", line 33, in inner
    return func(*args, **kwargs)
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/db/backends/base/base.py", line 219, in ensure_connection
    self.connect()
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/db/utils.py", line 90, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/db/backends/base/base.py", line 219, in ensure_connection
    self.connect()
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/utils/asyncio.py", line 33, in inner
    return func(*args, **kwargs)
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/db/backends/base/base.py", line 200, in connect
    self.connection = self.get_new_connection(conn_params)
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/utils/asyncio.py", line 33, in inner
    return func(*args, **kwargs)
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/django/db/backends/postgresql/base.py", line 187, in get_new_connection
    connection = Database.connect(**conn_params)
  File "/home/dsmr/dsmr-reader/.venv/lib/python3.7/site-packages/psycopg2/__init__.py", line 122, in connect
    conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
django.db.utils.OperationalError: connection to server at "localhost" (::1), port 5432 failed: FATAL:  password authentication failed for user "dsmr"
connection to server at "localhost" (::1), port 5432 failed: FATAL:  password authentication failed for user "dsmr"

Answered by LEJOUI

Feb 11, 2022

Typo in een .env variabele. werkt nu :)

View full answer

LEJOUI · 2022-02-11T20:32:13Z

LEJOUI
Feb 11, 2022
Author

Typo in een .env variabele. werkt nu :)

0 replies

dennissiemensma · 2022-02-12T00:16:44Z

dennissiemensma
Feb 12, 2022
Maintainer

Bedankt voor je melding en het delen van de oplossing!

0 replies

PetersPlace · 2023-07-19T20:40:23Z

PetersPlace
Jul 19, 2023

en wat is de oplossing ? Ik zit hier mee ?
raspberry i 3b+ docker + portainer wachtwoorden kloppen
172.17.0.3 = Ip postres database
django.db.utils.OperationalError: connection to server at "172.17.0.3", port 5432 failed: FATAL: password authentication failed for user "dsmrreader"

4 replies

dennissiemensma Jul 19, 2023
Maintainer

Je kunt kijken of het wachtwoord dat je ingesteld hebt wel klopt: https://github.com/xirixiz/dsmr-reader-docker#db-related-defaults-are-shown-as-value

PetersPlace Jul 21, 2023

Ik heb dit in POSTGRES container als env varaibelen staan

POSTGRES_USER=dsmrreader
POSTGRES_PASSWORD=dsmrreader
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/15/bin
GOSU_VERSION=1.16
LANG=en_US.utf8
PG_MAJOR=15
PG_VERSION=15.3-1.pgdg120+1
PGDATA=/var/lib/postgresql/data

Network as Bridge Postgres en heeft IP 172.17.0.3

In DSMR heb ik onderstaand staan

LANG=C.UTF-8
GPG_KEY=A035C8C19219BA821ECEA86B64E628F8D684696D
PYTHON_VERSION=3.11.3
PYTHON_PIP_VERSION=22.3.1
PYTHON_SETUPTOOLS_VERSION=65.5.1
PYTHON_GET_PIP_URL=https://github.com/pypa/get-pip/raw/d5cb0afaf23b8520f1bbcfed521017b4a95f5c01/public/get-pip.py
PYTHON_GET_PIP_SHA256=394be00f13fa1b9aaa47e911bdb59a09c3b2986472130f30aa0bfaf7f3980637
PS1=$(whoami)@dsmr_reader_docker:$(pwd)\$
TERM=xterm
QEMU_ARCH=x86_64
S6_BEHAVIOUR_IF_STAGE2_FAILS=2
DSMR_VERSION=5.10.3
DOCKER_TARGET_RELEASE=2023.04.02
VACUUM_DB_ON_STARTUP=false
DJANGO_SECRET_KEY=dsmrreader
DJANGO_DATABASE_ENGINE=django.db.backends.postgresql
DJANGO_DATABASE_NAME=**dsmrreader**
DJANGO_DATABASE_USER=**dsmrreader**
DJANGO_DATABASE_PASSWORD=**dsmrreader**
DJANGO_DATABASE_HOST=**172.17.0.3**
DJANGO_DATABASE_PORT=**5432**
DJANGO_TIME_ZONE=Europe/Amsterdam
DSMRREADER_SUPPRESS_STORAGE_SIZE_WARNINGS=True
DSMRREADER_ADMIN_USER=admin
DSMRREADER_ADMIN_PASSWORD=admin
DSMRREADER_OPERATION_MODE=standalone
DSMRREADER_REMOTE_DATALOGGER_INPUT_METHOD=serial
DSMRREADER_REMOTE_DATALOGGER_SERIAL_PORT=/dev/ttyUSB1
DSMRREADER_REMOTE_DATALOGGER_SERIAL_BAUDRATE=115200
DSMRREADER_REMOTE_DATALOGGER_SERIAL_BYTESIZE=8
DSMRREADER_REMOTE_DATALOGGER_SERIAL_PARITY=N
DSMRREADER_REMOTE_DATALOGGER_NETWORK_HOST=127.0.0.1
DSMRREADER_REMOTE_DATALOGGER_NETWORK_PORT=23
VIRTUAL_HOST=localhost)

dennissiemensma Jul 21, 2023
Maintainer

Ik zie ** staan in deze waardes:

DJANGO_DATABASE_NAME=**dsmrreader**
DJANGO_DATABASE_USER=**dsmrreader**
DJANGO_DATABASE_PASSWORD=**dsmrreader**
DJANGO_DATABASE_HOST=**172.17.0.3**
DJANGO_DATABASE_PORT=**5432**

Klopt dat of probeerde je ze bold te maken?

dennissiemensma Jul 21, 2023
Maintainer

En anders kun je het beste even zoeken in oude issues bij het docker-project:

https://github.com/xirixiz/dsmr-reader-docker/issues?q=is%3Aissue+password+authentication+failed+for+user+dsmr+is%3Aclosed

Of daar een nieuw issue maken als je het niet kan vinden. Het lijkt gerelateerd aan je setup.

PetersPlace · 2023-07-22T06:54:57Z

PetersPlace
Jul 22, 2023

Heeft inderdaad te maken met de PostgreSQL installatie, inmiddels PGadmin container erbij gemaakt. Mag niet inloggen als dsmrreader.
Maar eens een nieuwe maken.

Update, database connectie werkend

Oplossing in portainer een console openen en
psql -U dsmrreader ( als je user dsmreader gemaakt hebt)
dan ingeven
dsmrreader=# \password dsmrreader
2 x nieuw password ingeven bv "mypassword"

Daarna in de dsmrcontainer bij de enviroment de wachtwoorden gelijk maken
DJANGO_SECRET_KEY=mypassword
DJANGO_DATABASE_PASSWORD=mypassword
Daarna een rebuild van je container.

Volgende moet ik nog fixen,
dsmr draait alleen vertikt om de data op te halen van sernet ondanks dat de settings

DSMRREADER_REMOTE_DATALOGGER_INPUT_METHOD=ipv4
DSMRREADER_REMOTE_DATALOGGER_NETWORK_HOST=192.168.2.167
DSMRREADER_REMOTE_DATALOGGER_NETWORK_PORT=23

( deze instelling werkt ook in HA)
Echter blijft in de log de volgende regel verschijnen

 File "/usr/local/lib/python3.11/site-packages/serial/serialposix.py", line 325, in open
    raise SerialException(msg.errno, "could not open port {}: {}".format(self._port, msg))
serial.serialutil.SerialException: [Errno 2] could not open port /dev/ttyUSB0: [Errno 2] No such file or directory: '/dev/ttyUSB0'

Waarom dsmr probeert de usb te pakken die er niet is is mij onduidelijk ipv4 zou voldoende moeten zijn dacht ik.

0 replies

PetersPlace · 2023-07-23T08:34:10Z

PetersPlace
Jul 23, 2023

Voor de mensen die hier ook tegen aan lopen
Ik ben eruit, na de fix met de database toegang tijden zitten rommelen met de enviroment settings en de logmeldingen in de container .
De enviroment settings van de container welke hieronder staan worden niet gebruikt /cq door dsmrreader bij een start overschreven
(Zelfs als je deze enviroment regels weggooit staan ze er na een container reboot weer terug)
Als dsmrreader start naar de configuratie pagina > Datalogger > Serial port config

DSMRREADER_REMOTE_DATALOGGER_INPUT_METHOD     | ipv4
DSMRREADER_REMOTE_DATALOGGER_NETWORK_HOST     | 192.168.2.167
DSMRREADER_REMOTE_DATALOGGER_NETWORK_PORT     | 23
DSMRREADER_REMOTE_DATALOGGER_SERIAL_BAUDRATE  | 115200
DSMRREADER_REMOTE_DATALOGGER_SERIAL_BYTESIZE  | 8
DSMRREADER_REMOTE_DATALOGGER_SERIAL_PARITY    | 1
DSMRREADER_REMOTE_DATALOGGER_SERIAL_PORT      | dev/ttyUSB0

0 replies

dennissiemensma · 2023-07-23T08:48:50Z

dennissiemensma
Jul 23, 2023
Maintainer

Houd er overigens rekening mee dat je niet de remote datalogger, die via env vars werkt, door elkaar haalt met de ingebouwde datalogger, die de database instellingen binnen DSMR-reader pakt. Zie ook xirixiz/dsmr-reader-docker#329 (comment)

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

🙋password authentication failed for user dsmr #1583

{{title}}

{{editor}}'s edit

{{editor}}'s edit

Replies: 6 comments 4 replies

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

Select a reply

🙋password authentication failed for user dsmr #1583

LEJOUI Feb 11, 2022

Description

DSMR-reader version

DSMR-reader platform

Debug info dump

Replies: 6 comments · 4 replies

LEJOUI Feb 11, 2022 Author

dennissiemensma Feb 12, 2022 Maintainer

PetersPlace Jul 19, 2023

dennissiemensma Jul 19, 2023 Maintainer

PetersPlace Jul 21, 2023

dennissiemensma Jul 21, 2023 Maintainer

dennissiemensma Jul 21, 2023 Maintainer

PetersPlace Jul 22, 2023

PetersPlace Jul 23, 2023

dennissiemensma Jul 23, 2023 Maintainer

LEJOUI
Feb 11, 2022

Replies: 6 comments 4 replies

LEJOUI
Feb 11, 2022
Author

dennissiemensma
Feb 12, 2022
Maintainer

PetersPlace
Jul 19, 2023

dennissiemensma Jul 19, 2023
Maintainer

dennissiemensma Jul 21, 2023
Maintainer

dennissiemensma Jul 21, 2023
Maintainer

PetersPlace
Jul 22, 2023

PetersPlace
Jul 23, 2023

dennissiemensma
Jul 23, 2023
Maintainer