[pmacct-discussion] pmacctd + pgsql not talking to each other

[Gregory Machin]

Hi
Please advise
I'm using the example config  ./examples/pmacctd-sql_v2.conf.example
With postgresql..
I have selected to pgsql plugin.

!
! pmacctd configuration example
!
! Did you know CONFIG-KEYS contains the detailed list of all configuration keys
! supported by 'nfacctd' and 'pmacctd' ?
!
debug: true
!
interface: eth0
daemonize: false
post_tag: 1
aggregate: src_host,dst_host
! aggregate: src_net,dst_net
plugins: pgsql
!plugins: mysql
sql_host: 127.0.0.1
sql_db: pmacct
sql_table: acct
sql_table_version: 2
sql_passwd: arealsmartpwd
sql_user: pmacct
sql_refresh_time: 90
! sql_optimize_clauses: true
sql_history: 10m
sql_history_roundoff: mh
! sql_preprocess: qnum=1000, minp=5
!
! networks_file: ./networks.example
! ports_file: ./ports.example
! sampling_rate: 10
! sql_trigger_time: 1h
! sql_trigger_exec: /home/paolo/codes/hello.sh

I'm getting the following error ..
ALERT ( default/pgsql ): primary PostgreSQL server failed.

i tryed adding sql_host : 127.0.0.1  but this did not help..
the pgsql server is up and listening on 127.0.0.1:5432

What did i miss ?
--
Gregory Machin
[EMAIL PROTECTED]
[EMAIL PROTECTED]
www.linuxpro.co.za
www.exponent.co.za
Web Hosting Solutions
Scalable Linux Solutions
www.iberry.info (support and admin)

+27 72 524 8096