Forum OpenACS Q&A: psql error : cant t open the database

Collapse
Posted by bars remi on
Hi,I m trying to install openacs with postgresqli have create the database with the user nsadmini launch postgresql with :/usr/local/pgsql/bin/postmaster -D/usr/local/pgsql/datathere is a part of my nsd.tclns_section "ns/server/${server}/module/nssock"        ns_param  port        $httpport        ns_param  hostname    192.9.200.145ns_section "ns/db/pools"    ns_param  main      "OpenACS Main Pool"    ns_param  log        "OpenACS Log Pool"    ns_param  subquery  "OpenACS Subquery Pool"ns_section "ns/db/pool/main"    ns_param Driver postgres    ns_param Connections 5                  ;# 5 is a good number.    ns_param DataSource 192.9.200.145:8000:dexem        ;    ns_param User nsadmin                  ;    ns_param Password ""    ns_param Verbose On                    ;    ns_param LogSQLErrors On    ns_param ExtendedTableInfo On  # ns_param MaxOpen 1000000000            ;#  # ns_param MaxIdle=1000000000            ;#ns_section "ns/db/pool/log"    ns_param Driver postgres    ns_param Connections 5    ns_param DataSource 192.9.200.145:8000:dexemns_param User nsadminns_param Password ""ns_param Verbose Onns_param LogSQLErrors Onns_param ExtendedTableInfo On# ns_param MaxOpen 1000000000# ns_param MaxIdle=1000000000ns_section "ns/db/pool/subquery"ns_param Driver postgresns_param Connections 2ns_param DataSource 192.9.200.145:8000:dexemns_param User nsadminns_param Password ""ns_param Verbose Onns_param LogSQLErrors Onns_param ExtendedTableInfo On# ns_param MaxOpen 1000000000# ns_param MaxIdle=1000000000his error :when i launch aolserver i have this message in the server.log Notice: nsd.db: opening:  postgres:192.9.200.145:8000:dexem[17/Jul/2000:16:27:11][498.1026][-sched-] Notice: Opening dexem on192.9.200.145, port 8000[17/Jul/2000:16:27:11][498.4101][-conn1-] Notice: starting: waitingfor connections[17/Jul/2000:16:27:41][498.1026][-sched-] Error:Ns_PgOpenDb(postgres):  Could not connect to 192.9.200.145:8000:dexem: PQconnectPoll() -- expected authentication requestcould someone help methankRmi
Collapse
Posted by bars remi on
i think i have missed to configure my  data/pg_hba.conf fileremi
Collapse
Posted by Roberto Mello on
We want to help you but the message you posted is almost unreadable. Please put <PRE> tags around the config snippet and select HTML in the box right below the message box.

Also, please use some line feeds.

Are you trying to access psql from the same machine or remotely through the network?