password authentication failed
Gary Roach
gary719_list1 at verizon.net
Thu Jul 16 19:34:43 EDT 2015
On 07/15/2015 11:25 AM, Chris Angelico wrote:
> On Thu, Jul 16, 2015 at 3:13 AM, Gary Roach <gary719_list1 at verizon.net> wrote:
>> Every time I try to do a python manage.py migrate I get:
>> django.db.utils.OperationalError: FATAL: password
>> authentication failed for user "postgres"
>> FATAL: password authentication failed for user "postgres"
>>
>>
>> DATABASES = {
>> 'default': {
>> 'USER': 'postgres',
>> 'PASSWORD': 'xxxxxx', # A valid debian pw
>> }
>> }
> PostgreSQL users are not the same as Unix users, and their passwords
> aren't necessarily the same. I would recommend *not* using the
> postgres user, which is the database superuser; instead, create a new
> user explicitly. On most Debian PostgreSQL installations, you should
> be able to invoke 'psql' while running as user 'postgres', either by
> su'ing to postgres or with sudo, for instance:
>
> $ sudo sudo -u postgres psql
>
> That should get you into a database CLI as superuser. Your prompt
> should look like this:
>
> postgres=#
>
> You should then be able to create a regular user, and grant
> appropriate permissions:
>
> postgres=# create user archives password 'traded-links-linguistics-informal';
> CREATE ROLE
> postgres=# grant all on database archivedb to archives;
> GRANT
>
> (Make sure you have the semicolons at the ends, otherwise you'll think
> it's done nothing. It's actually waiting for you to type more lines
> for the same command, but the prompt difference is so subtle that it's
> easy to think it's silently ignoring you.)
>
> Then you should be able to use user name 'archives' and password
> 'traded-links-linguistics-informal' (of course, you don't want to use
> that; that's just what my password generating parrot came up with)
> instead of 'postgres' and whatever the Unix password was.
>
> Incidentally, I usually don't have any password on my postgres Unix
> user, nor on the corresponding database users. Safer to use sudo, eg
> to root and then down to postgres, as shown above.
>
> ChrisA
I really appreciate the help Chris. I created a user archive with
password 'xxxxxx' and changed the settings.py file accordingly. When I
tried python manage.py migrate I got the following error with it's
traceback:
(archivedb)root at supercrunch:~/archivedb# python manage.py migrate
Traceback (most recent call last):
File "manage.py", line 10, in <module>
execute_from_command_line(sys.argv)
File
"/root/.virtualenvs/archivedb/local/lib/python2.7/site-packages/django/core/management/__init__.py",
line 338, in execute_from_command_line
utility.execute()
File
"/root/.virtualenvs/archivedb/local/lib/python2.7/site-packages/django/core/management/__init__.py",
line 330, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File
"/root/.virtualenvs/archivedb/local/lib/python2.7/site-packages/django/core/management/base.py",
line 390, in run_from_argv
self.execute(*args, **cmd_options)
File
"/root/.virtualenvs/archivedb/local/lib/python2.7/site-packages/django/core/management/base.py",
line 441, in execute
output = self.handle(*args, **options)
File
"/root/.virtualenvs/archivedb/local/lib/python2.7/site-packages/django/core/management/commands/migrate.py",
line 93, in handle
executor = MigrationExecutor(connection,
self.migration_progress_callback)
File
"/root/.virtualenvs/archivedb/local/lib/python2.7/site-packages/django/db/migrations/executor.py",
line 19, in __init__
self.loader = MigrationLoader(self.connection)
File
"/root/.virtualenvs/archivedb/local/lib/python2.7/site-packages/django/db/migrations/loader.py",
line 47, in __init__
self.build_graph()
File
"/root/.virtualenvs/archivedb/local/lib/python2.7/site-packages/django/db/migrations/loader.py",
line 180, in build_graph
self.applied_migrations = recorder.applied_migrations()
File
"/root/.virtualenvs/archivedb/local/lib/python2.7/site-packages/django/db/migrations/recorder.py",
line 60, in applied_migrations
return set(tuple(x) for x in self.migration_qs.values_list("app",
"name"))
File
"/root/.virtualenvs/archivedb/local/lib/python2.7/site-packages/django/db/models/query.py",
line 162, in __iter__
self._fetch_all()
File
"/root/.virtualenvs/archivedb/local/lib/python2.7/site-packages/django/db/models/query.py",
line 965, in _fetch_all
self._result_cache = list(self.iterator())
File
"/root/.virtualenvs/archivedb/local/lib/python2.7/site-packages/django/db/models/query.py",
line 1220, in iterator
for row in compiler.results_iter():
File
"/root/.virtualenvs/archivedb/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py",
line 783, in results_iter
results = self.execute_sql(MULTI)
File
"/root/.virtualenvs/archivedb/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py",
line 829, in execute_sql
cursor.execute(sql, params)
File
"/root/.virtualenvs/archivedb/local/lib/python2.7/site-packages/django/db/backends/utils.py",
line 79, in execute
return super(CursorDebugWrapper, self).execute(sql, params)
File
"/root/.virtualenvs/archivedb/local/lib/python2.7/site-packages/django/db/backends/utils.py",
line 64, in execute
return self.cursor.execute(sql, params)
File
"/root/.virtualenvs/archivedb/local/lib/python2.7/site-packages/django/db/utils.py",
line 97, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File
"/root/.virtualenvs/archivedb/local/lib/python2.7/site-packages/django/db/backends/utils.py",
line 64, in execute
return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: permission denied for relation
django_migrations
(archivedb)root at supercrunch:~/archivedb#
I'm not at all sure what this means. Any help will be sincerely appreciated.
Gary R.
More information about the Python-list
mailing list