FATAL: password authentication failed for user "openremuser"

52 views
Skip to first unread message

Nayron Medeiros Soares nayronsoares

unread,
Aug 5, 2022, 4:10:25 PM8/5/22
to OpenREM
Hi Ed.

I have the following problem. Could you help us?

Kind regards,

Nayron


root@openrem:/# cd /usr/local/lib/python2.7/dist-packages/openrem/
root@openrem:/usr/local/lib/python2.7/dist-packages/openrem# python manage.py makemigrations remapp
Comando 'python' não encontrado, você quis dizer:
  comando 'python3' do deb python3
  comando 'python' do deb python-is-python3
root@openrem:/usr/local/lib/python2.7/dist-packages/openrem# python2 manage.py makemigrations remapp
No changes detected in app 'remapp'
root@openrem:/usr/local/lib/python2.7/dist-packages/openrem# python2 manage.py migrate
Traceback (most recent call last):
  File "manage.py", line 10, in <module>
    execute_from_command_line(sys.argv)
  File "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", line 354, in execute_from_command_line
    utility.execute()
  File "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", line 346, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 394, in run_from_argv
    self.execute(*args, **cmd_options)
  File "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 445, in execute
    output = self.handle(*args, **options)
  File "/usr/local/lib/python2.7/dist-packages/django/core/management/commands/migrate.py", line 93, in handle
    executor = MigrationExecutor(connection, self.migration_progress_callback)
  File "/usr/local/lib/python2.7/dist-packages/django/db/migrations/executor.py", line 19, in __init__
    self.loader = MigrationLoader(self.connection)
  File "/usr/local/lib/python2.7/dist-packages/django/db/migrations/loader.py", line 47, in __init__
    self.build_graph()
  File "/usr/local/lib/python2.7/dist-packages/django/db/migrations/loader.py", line 191, in build_graph
    self.applied_migrations = recorder.applied_migrations()
  File "/usr/local/lib/python2.7/dist-packages/django/db/migrations/recorder.py", line 59, in applied_migrations
    self.ensure_schema()
  File "/usr/local/lib/python2.7/dist-packages/django/db/migrations/recorder.py", line 49, in ensure_schema
    if self.Migration._meta.db_table in self.connection.introspection.table_names(self.connection.cursor()):
  File "/usr/local/lib/python2.7/dist-packages/django/db/backends/base/base.py", line 164, in cursor
    cursor = self.make_cursor(self._cursor())
  File "/usr/local/lib/python2.7/dist-packages/django/db/backends/base/base.py", line 135, in _cursor
    self.ensure_connection()
  File "/usr/local/lib/python2.7/dist-packages/django/db/backends/base/base.py", line 130, in ensure_connection
    self.connect()
  File "/usr/local/lib/python2.7/dist-packages/django/db/utils.py", line 98, in __exit__
    six.reraise(dj_exc_type, dj_exc_value, traceback)
  File "/usr/local/lib/python2.7/dist-packages/django/db/backends/base/base.py", line 130, in ensure_connection
    self.connect()
  File "/usr/local/lib/python2.7/dist-packages/django/db/backends/base/base.py", line 119, in connect
    self.connection = self.get_new_connection(conn_params)
  File "/usr/local/lib/python2.7/dist-packages/django/db/backends/postgresql_psycopg2/base.py", line 176, in get_new_connection
    connection = Database.connect(**conn_params)
  File "/usr/local/lib/python2.7/dist-packages/psycopg2/__init__.py", line 127, in connect
    conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
django.db.utils.OperationalError: FATAL:  password authentication failed for user "openremuser"

root@openrem:/usr/local/lib/python2.7/dist-packages/openrem#



local_settings.py

Ed McDonagh

unread,
Aug 5, 2022, 4:35:12 PM8/5/22
to Nayron Medeiros Soares nayronsoares, OpenREM
Hi Nayron

It looks like the username and password in the local settings file don't match the username and password you used when the database was created. Look at this document - https://docs.openrem.org/en/0.10.0-docs/postgresql.html

Does that help?

Kind regards

Ed

[PT] Mensagem para uso exclusivo do destinatário. Apague-a imediatamente se a recebeu por engano.
[EN] Message for exclusive use of the recipient. Erase it immediately if you received it by mistake.
[ES] Mensaje para el uso exclusivo del destinatario. Eliminar de inmediato si lo recibió por error.
HCPA - Hospital de Clínicas de Porto Alegre.

--
You received this message because you are subscribed to the Google Groups "OpenREM" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openrem+u...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/openrem/11fedf4b-0d82-4a05-a42f-21ad46a29d0an%40googlegroups.com.

Nayron Medeiros Soares nayronsoares

unread,
Sep 1, 2022, 3:42:46 PM9/1/22
to OpenREM
Thanks, Ed. It worked!!
Reply all
Reply to author
Forward
0 new messages