postgresql - PostgreSQL-身份验证在Docker中失败

Question

我试图在我的Docker容器中运行postgresql。

这是我用于PostgreSQL的DockerFile

FROM postgres:9.5.2

RUN localedef -i ru_RU -c -f UTF-8 -A /usr/share/locale/locale.alias ru_RU.UTF-8
ENV LANG ru_RU.utf8

ENV POSTGRES_PASSWORD OaO1OHrzTZ3cqyLnju2z
ENV PROJECT_USER test
ENV PROJECT_DATABASE test

COPY config/init-user-db.sh /docker-entrypoint-initdb.d/init-user-db.sh

初始化用户数据库

#!/bin/bash
set -e

psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" <<-EOSQL
    CREATE EXTENSION "adminpack";
    CREATE EXTENSION "autoinc";
    CREATE EXTENSION "cube";
    CREATE EXTENSION "file_fdw";
    CREATE EXTENSION "fuzzystrmatch";
    CREATE EXTENSION "hstore";
    CREATE EXTENSION "insert_username";
    CREATE EXTENSION "intarray";
    CREATE EXTENSION "isn";
    CREATE EXTENSION "lo";
    CREATE EXTENSION "ltree";
    CREATE EXTENSION "moddatetime";
    CREATE EXTENSION "pageinspect";
    CREATE EXTENSION "pgcrypto";
    CREATE EXTENSION "pg_trgm";
    CREATE EXTENSION "postgres_fdw";
    CREATE EXTENSION "refint";
    CREATE EXTENSION "seg";
    CREATE EXTENSION "sslinfo";
    CREATE EXTENSION "tablefunc";
    CREATE EXTENSION "tcn";
    CREATE EXTENSION "timetravel";
    CREATE EXTENSION "unaccent";
    CREATE EXTENSION "uuid-ossp";
    CREATE EXTENSION "xml2";
    CREATE USER "$PROJECT_USER" WITH password 'OaO1OHrzTZ3cqyLnju2z
';
    CREATE DATABASE "$PROJECT_DATABASE" WITH OWNER="$PROJECT_USER" TEMPLATE=template1 ;
    GRANT ALL PRIVILEGES ON DATABASE "$PROJECT_DATABASE" TO "$PROJECT_USER";
    REVOKE ALL PRIVILEGES ON DATABASE "$PROJECT_DATABASE" FROM PUBLIC;
EOSQL

多数民众赞成在我的应用程序配置(symfony 3)

parameters:
    database_host: 192.168.99.100
    database_port: 48002
    database_name: test
    database_user: test
    database_password: OaO1OHrzTZ3cqyLnju2z
    mailer_transport: smtp
    mailer_host: 127.0.0.1
    mailer_user: null
    mailer_password: null
    secret: O81s4KSjs8NdxSAacvU82AdC973aSxKdL

如您所见，我在每个地方都有相同的密码-OaO1OHrzTZ3cqyLnju2z。

但是我收到错误的密码验证失败，用户“测试”。

有什么不见了？为什么它不认证？

Answer 1

您是否直接从源代码粘贴了脚本？
因为看起来您在密码的最后一位数字和引号之间有一个空格:

    CREATE USER "$PROJECT_USER" WITH password 'OaO1OHrzTZ3cqyLnju2z
';

尝试

CREATE USER "$PROJECT_USER" WITH password 'OaO1OHrzTZ3cqyLnju2z';