Ad Widget

Collapse

Problem with connecting to postgres

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • pietro54
    Senior Member
    • Feb 2011
    • 112

    #1

    Problem with connecting to postgres

    Hi,
    I got problem with connection to my DB, first i saw was that screan:


    Next I`v try to connect form console
    psql -U zabbix zabbix -W
    Password for user zabbix:
    psql: FATAL: Ident authentication failed for user "zabbix"

    So, there is a question, what is wrong.
    Ofc i made changes in pg_hba.conf
    ##z manuala zabbixa http://www.zabbix.com/wiki/howto/db/postgres
    local zabbix zabbix md5

    ##local all all md5
    ##host all all 0.0.0.0/0 trust <- i try even with this and doesnt help
    to be sure, the zabbix db exsist i make \list in psql
    List of databases
    Name | Owner | Encoding | Collation | Ctype | Access privileges
    -----------+----------+----------+-------------+-------------+-----------------------
    postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
    template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
    : postgres=CTc/postgres
    template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
    : postgres=CTc/postgres
    zabbix | zabbix | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
    (4 rows)
    I even alter my password for user zabbix...
    still nothing.

    What can I do to make it work?
  • pietro54
    Senior Member
    • Feb 2011
    • 112

    #2
    Ok, topic to revoke.
    I solved my problem.

    Problem was in hba file.

    I just left
    local all all trust
    host all all 0.0.0.0/0 trust
    and made hash# on evry other entry.

    Hope this will help some one.

    P.

    Comment

    Working...