Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #93973

Re: password authentication failed

Show all headers | View raw

On Fri, Jul 17, 2015 at 9:34 AM, Gary Roach <gary719_list1@verizon.net> wrote:
> On 07/15/2015 11:25 AM, Chris Angelico wrote:
>
>> 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
>
> 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@supercrunch:~/archivedb# python manage.py migrate
> [chomp]
> django.db.utils.ProgrammingError: permission denied for relation
> django_migrations

This suggests that your new user doesn't have permissions set yet. Did
you do the grant command as listed above? If so, you may have to also
do this:

$ sudo sudo -u postgres psql archivedb
postgres=# grant all on all tables in schema X to archives;

Replace X with the name of the database schema you use - possibly
"public" or some other user name. You can list multiple schema names,
separated by commas, if you need to.

To list all schemas in the database:

select distinct table_schema from information_schema.tables;

Hope that helps!

ChrisA

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread

Thread

Re: password authentication failed Chris Angelico <rosuav@gmail.com> - 2015-07-17 09:53 +1000

csiph-web