I've been trying to get pmacctd to work with mysql(4.1) as the backed.
It alway fails to connect. I've verified that I can connect to the DB
using the mysql command line tools with the pmaccts user and password.
Enabling debug does not give me much info, just:
INFO ( default/mysql ): 109568 bytes are available to address shared
memory segment; buffer size is 64 bytes.
INFO ( default/mysql ): Trying to allocate a shared memory segment of
1753088 bytes.
OK ( default/core ): link type is: 1
ALERT ( default/mysql ): PRIMARY 'mysql' backend failed.
( default/mysql ) *** Purging cache - START ***
( default/mysql ) *** Purging cache - END (QN: 42, ET: 0) ***
with the last three lines being repeated until I kill the process.
Here is my config (it's based on a sample that came with pmacct):
debug: true
interface: eth1
daemonize: false
aggregate: src_host,dst_host
plugins: mysql
sql_db: pmacct
sql_table: acct
sql_table_version: 1
sql_passwd: pmacct
sql_user: pmacct
sql_refresh_time: 10
sql_history: 10m
sql_history_roundoff: mh
pidfile: /var/run/pmacctd.pid
The mysqld logs don't show any connection attempts. Is there a way to
increase the debugging info. strace is impratical with the flow of data
coming in from the interface.
pmaccts is version 0.9.6.
Any ideas/tips?
Also, are there archives available for the list that I can search before
email questions?
David
--
David Filion
[EMAIL PROTECTED]
System / Network Administrator
Auto123.com / XPrima Corporation
(450)681-5868 ext. 252
