Date: Wed, 22 Jul 2015 16:35:00 -0700
From: Gary Roach <garyroach@verizon.net>
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Icedove/31.7.0
MIME-version: 1.0
To: python-list@python.org
Subject: Re: password authentication failed
References: <55A694AB.2020408@verizon.net> <CAPTjJmq8fRP3DohC5hZMLSXUZ=oCvA7VSA1WBtJWRoG=sq6fKA@mail.gmail.com> <55A83F93.4030403@verizon.net> <CAPTjJmrq8r-EDJA0wDZN0sw=6Qnri7nD4fyyc0VncM+jvAJQXg@mail.gmail.com>
In-reply-to: <CAPTjJmrq8r-EDJA0wDZN0sw=6Qnri7nD4fyyc0VncM+jvAJQXg@mail.gmail.com>
Content-type: text/plain; charset=windows-1252; format=flowed
Content-transfer-encoding: 7bit
Precedence: list
Newsgroups: comp.lang.python
Message-ID: <mailman.903.1437636416.3674.python-list@python.org>
Lines: 81
NNTP-Posting-Host: 2001:888:2000:d::a6
Path: csiph.com!usenet.pasdenom.info!news.stben.net!border1.nntp.ams1.giganews.com!nntp.giganews.com!bcyclone02.am1.xlned.com!bcyclone02.am1.xlned.com!newsfeed.xs4all.nl!newsfeed7.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Xref: csiph.com comp.lang.python:94430

On 07/16/2015 04:53 PM, Chris Angelico wrote:
> 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;
I did the above.
> 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;
I did all of the above. Since I only plan on one datebase - excluding 
the system db's - I'm dumping everything into the public schema.
> Hope that helps!
>
> ChrisA
I'm still getting the same migration error.

At this point, I'm confused about a few things. Does the postgresql 
server and my archivedb reside globally or are they inside my archivedb 
virtual environment. I think globally.

To get pgAdmin3 to work, I  have to have it set so that it logs in as 
gary ( no choice with this) and set group to root. Then in application > 
advanced options set run as different user to root. This assumes that 
you are using a KDE4 desktop and have these option by right clicking the 
icons.

pgAdmin3 data:
     Server Group > Server(1) > archivedb
                                                     |_ Host name - 
127.0.0.1
                                                     |_ username - archive
                                                     |_ connected - no
Archivedb requires a password to go deeper and takes the xxxxxx password 
that is in the django settings.py file. This opens up access to 
archivedb and lists archivedb > Schema(1) > public > tables(10). At this 
point I found that all  of the sequences and all of the tables are owned 
by root. This is probably the root (no pun intended) cause. Now what do 
I do about it. I'm not sure how this came about so don't know how to fix it.

In the OS I have a postgres user in the passwd file and in the group 
file have the following:
     gary:x:1000:root,backuppc,sudo,postgres,users
     root:x:0:backuppc,gary,staff,postgres,users
     postgres:x:117:root,gary

Normally, I don't have to worry too much about security because my two 
user network resides behind a verizon router firewall. I don't have much 
in the way of sensitive data either. This project may be different. So 
maybe I need to tighten things up a bit.

Thanks for your help

Gary R