Hi, I have successfully compiled pmacct-0.12.0rc3 on a Dlink DNS-323 Network Attached Storage which runs Linux on an ARM processor.
I was able to run pmacctd using the memory plug-in and get traffic statistics all right. Great program! I then re-compiled with the Sqlite3 support, initialized a Sqlite3 database in Version 1, updated by config file for sqlite3 logging, and launched pmacctd again. But nothing gets written to the database, although I have seen a blank file appear if the destination database file is not in place. I run everything as root. I issued a "SELECT * from acct" statement on the database and it works, although there are no results (the timestamp of the database file never changes which confirms nothing gets written). When I issue a "pmacct -t" command I get the error : INFO: Connection refused while trying to connect to '/tmp/collect.pipe'. If that normal when the sqlite3 plugin is used? Furthermore, a bunch of "pmacctd: SQLite3 Plugin -- DB Writer [in]" processes are created, which suggest to me the program does try to write to the database but fails. The write permissions to the database file are ok. I enabled debug mode and syslogging but I have no inormation from the sqlite3 plugin on what could be the problem, so I am a bit at loss now. Any suggestions? Thanks, More info follows. Jean-Francois Libraries: libpcap-1.0.0, sqlite-3.5.6 Config file: ! debug: true syslog: kern plugin_buffer_size: 10240 plugin_pipe_size: 10240 interface: egiga0 daemonize: false promisc: false sql_cache_entries: 2 plugins: sqlite3[in] sql_max_writers: 2 pidfile: /vol1/pmacct.pid sql_db: /vol1/pmacct.db aggregate[in]: dst_host aggregate_filter[in]: dst net 11.0.3.0/24 sql_table[in]: acct sql_table_version: 1 sql_refresh_time: 5 ! Logs: Nov 9 04:24:06 dns323 user.info syslog[28125]: INFO ( default/core ): Start logging ... Nov 9 04:24:06 dns323 user.info syslog[28125]: INFO ( in/sqlite3 ): Pipe size obtained: 104448 / 4. Nov 9 04:24:07 dns323 user.debug syslog[28125]: DEBUG ( default/core ): PCAP buffer: obtained 104448 / 10240 bytes. Nov 9 04:24:07 dns323 user.info syslog[28125]: OK ( default/core ): link type is: 1 Nov 9 04:26:21 dns323 user.debug syslog[28212]: ( in/sqlite3 ) *** Purging cache - START *** Nov 9 04:26:21 dns323 user.debug syslog[28212]: ( in/sqlite3 ) *** Purging cache - END (QN: 0, ET: 0) *** Nov 9 04:26:26 dns323 user.debug syslog[28216]: ( in/sqlite3 ) *** Purging cache - START *** Nov 9 04:26:26 dns323 user.debug syslog[28216]: ( in/sqlite3 ) *** Purging cache - END (QN: 0, ET: 0) *** Nov 9 04:26:31 dns323 user.debug syslog[28217]: ( in/sqlite3 ) *** Purging cache - START *** Nov 9 04:26:31 dns323 user.debug syslog[28217]: ( in/sqlite3 ) *** Purging cache - END (QN: 0, ET: 0) *** Nov 9 04:26:36 dns323 user.debug syslog[28219]: ( in/sqlite3 ) *** Purging cache - START *** ... _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
