Re: Problems connecting to PostgreSQL

Path	csiph.com!eternal-september.org!feeder.eternal-september.org!mx02.eternal-september.org!.POSTED!not-for-mail
From	Cecil Westerhof <Cecil@decebal.nl>
Newsgroups	comp.lang.python
Subject	Re: Problems connecting to PostgreSQL
Date	Mon, 09 Nov 2015 13:59:01 +0100
Organization	Decebal Computing
Lines	57
Message-ID	<87pozj5nxm.fsf@Equus.decebal.nl> (permalink)
References	<87wptt5qg4.fsf@Equus.decebal.nl> <mailman.119.1446971807.16136.python-list@python.org>
Mime-Version	1.0
Content-Type	text/plain; charset=utf-8
Content-Transfer-Encoding	8bit
Injection-Info	mx02.eternal-september.org; posting-host="528adfd6ad074c92fdc6a7f8fb9e23d8"; logging-data="1174"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/4i9MR9icpfNwjL93jfDoNZL3OSqETVkQ="
User-Agent	Gnus/5.13 (Gnus v5.13) Emacs/24.3 (gnu/linux)
Cancel-Lock	sha1:Iu8P6LGqxQ3BvqNtofqmTgF+Ed4= sha1:VlYr6BwUdd0SGHAkVgHScE+8+WM=
X-Homepage	http://www.decebal.nl/
Xref	csiph.com comp.lang.python:98519

Show key headers only | View raw

On Sunday  8 Nov 2015 09:36 CET, Chris Warrick wrote:

> On 8 November 2015 at 00:40, Cecil Westerhof <Cecil@decebal.nl> wrote:
>> I followed http://zetcode.com/db/postgresqlpythontutorial/.
>>
>> I used:
>> sudo -u postgres createuser stressTest
>> this create the role, but also gave:
>> could not change directory to "/root": Permission denied
>> and I did not get the questions.
>
> This is not an error, just a warning — and it comes from sudo,
> postgres doesn’t care. To silence it, you need to work from a
> different directory than /root.  The commands actually worked just
> fine.
>
>> Then I used:
>> sudo -u postgres createdb stressTest -O stressTest
>> This gave also:
>> could not change directory to "/root": Permission denied
>>
>> The database is created, but when I execute: conn =
>> psycopg2.connect(database = postgres_database, user = 'stressTest')
>> I get: psycopg2.OperationalError: FATAL: Peer authentication failed
>> for user "stressTest"
>>
>> What do I need to do to get things working?
>
> You need to configure your PostgreSQL database to use md5
> authentication, and set a password for your user.
>
> # cd /
> # sudo -u postgres psql
> postgres=# ALTER ROLE stressTest WITH PASSWORD 'swordfish';
> postgres=# \q
> # vim /var/lib/postgres/data/pg_hba.conf
>
> Change host settings to look like this:
> # IPv4 local connections:
> host    all             all             127.0.0.1/32            md5
> # IPv6 local connections:
> host    all             all             ::1/128                 md5
>
> Then you can connect using:
>
> conn = psycopg2.connect(database='stressTest', user='stressTest',
> password='swordfish', host='localhost')

Thanks. The file to edit on my system is:
    /var/lib/pgsql/data/pg_hba.conf
and it also looks like I cannot use mixed case. But at the moment I
have it working. I will delve deeper into it later.

-- 
Cecil Westerhof
Senior Software Engineer
LinkedIn: http://www.linkedin.com/in/cecilwesterhof

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

Thread

Problems connecting to PostgreSQL Cecil Westerhof <Cecil@decebal.nl> - 2015-11-08 00:40 +0100
  Re: Problems connecting to PostgreSQL Chris Angelico <rosuav@gmail.com> - 2015-11-08 10:54 +1100
  Re: Problems connecting to PostgreSQL Chris Warrick <kwpolska@gmail.com> - 2015-11-08 09:36 +0100
    Re: Problems connecting to PostgreSQL Cecil Westerhof <Cecil@decebal.nl> - 2015-11-09 13:59 +0100

csiph-web