ipac - psql - could not translate host name

Tomáš Vondra vondra na karneval.cz
Pátek Červen 17 02:59:29 CEST 2005


Strelba od boku - nesnazi se jedno spojit pres socket (to co funguje)
a druhe pres TCP/IP? Zkuste se podivat jestli postgres posloucha i na
siti (casto je default prave "socket only", nicmene nevim jak to mate
nastavene a vzhledem k tomu ze FC3 neznam tak nemuzu poradit).
Kazdopadne psql se umi spojit i pres TCP/IP - zkuste neco jako

#  psql -h 127.0.0.1 -d ipac -U ... atd.

Pokud tohle zafuguje tak se zkuste podivat do nastaveni ipacu - to
prazdne hostname je velmi podivne (vam se to divne nezda?), a bud tam
nastavte socket nebo localhosta (pripadne spravneho hosta).

T.V.

rad bych zahal pou>>mvat ipac-ng, ale mam problim
rad bych zahal pou>>s rozchozenmm ukladanm 
MK> do psql

MK> [root na proxy ~]# fetchipac
MK> Connection to database 'ipac' failed.
MK> could not translate host name "
MK> " to address: Name or service not known
MK> fetchipac: storage reports error on open, switching to spool mode

MK> Pravdlpodobnl je to zpysobeno pxmstupem k db, ale proh funguje toto:
MK> [marek na proxy ~]$ psql -d ipac -U ipac -c "select * from logs"
MK> Password:
MK>  rule_name | bytes | pkts | hostname | that_time
MK> -----------+-------+------+----------+-----------
MK> (0 rows)

MK> pg_hba.conf obsahuje pouze:
MK> local  all    all  password
MK> host   all    127.0.0.1     255.255.255.255    password

MK> /etc/ipac-ng/ipac.conf:
MK> # This parameters controls database location
MK> # left blank 'db host', 'db port' for local database
MK> # as now, both databasess (access and storage) configured by these
MK> parameters
MK> db host =
MK> db name = ipac
MK> db user = ipac
MK> db port =
MK> db pass = "password"

MK> ipac-ng-1.31
MK> psql 7.4.8



Další informace o konferenci Linux