Hi everybody,
I have a problema I can't figure out, so any help would be appreciated.
I'm trying to write data from pmacctd on a firewall to mysql on a remote
server. Each time pmacctd try to write data the answer is:
[EMAIL PROTECTED] /home/users/simon/pmacct-0.9.6# pmacctd -f pmacctd.conf
WARN ( default/mysql ): defaulting to SRC HOST aggregation.
WARN ( default/core ): Selecting a suitable device.
OK ( default/core ): link type is: 1
ALERT ( default/mysql ): PRIMARY 'mysql' backend failed.
ALERT ( default/mysql ): PRIMARY 'mysql' backend failed.
ALERT ( default/mysql ): PRIMARY 'mysql' backend failed.
This is the configuration file:
!
! pmacctd configuration file
!
! Did you know CONFIG-KEYS contains the detailed list of all
configuration keys
! supported by 'nfacctd' and 'pmacctd' ?
!
! daemonize: true
! aggregate: src_mac,dst_mac,src_host,dst_host,src_port,dst_port,proto
plugins: mysql
! plugins: print
sql_host: 192.168.11.14
sql_user: pmacct
sql_passwd: pm4cct
sql_db: pmacct
sql_table: acct
sql_refresh_time: 1
! sql_table_version: 1
Can you help me please?
Thank you very much.
Simone