Re: [pmacct-discussion] MySQL and pmacctd

[Paolo Lucente]

Hi Rene,

i know this may sound a bit simplistic: version 0.10.1 is a bit outdated now,
can you please switch to a more recent pmacct version? 0.11.4 is out for quite
a while and shouldn't pose stability issues. 

Cheers,
Paolo


On Fri, Mar 28, 2008 at 12:21:23PM +0100, "Schultz Consult - [Ren? Madsen]" 
wrote:
> Hi,
> 
> I have a server running with pmacctd and mysql and the following configfile:
> 
> ! pmacctd configuration
> !
> !
> !
> daemonize: true
> pidfile: /var/run/pmacctd.pid
> syslog: daemon
> !
> ! interested in in and outbound traffic
> aggregate: src_host,dst_host,src_port,dst_port
> ! on this network
> !pcap_filter: net 127.0.0.0/8
> ! on this interface
> interface: eth0
> !
> ! storage methods
> plugins: mysql[in], mysql[out]
> !plugins: memory[inbound], memory[outbound]
> sql_host: localhost
> sql_table: acct
> sql_user: yyyyyyy
> sql_passwd: xxxxxxxx
> sql_table_version: 1
> 
> ! refresh the db every minute
> sql_refresh_time: 60
> ! reduce the size of the insert/update clause
> sql_optimize_clauses: true
> ! accumulate values in each row for up to an hour
> sql_history: 5m
> ! create new rows on the minute, hour, day boundaries
> sql_history_roundoff: mhd
> ! in case of emergency, log to this file
> !sql_recovery_logfile: /var/lib/pmacct/recovery_log
> 
> After a couple of minuts I have 502-505 of these processes running:
>     
> root     17871  0.0  0.2  13364  5004 ?        S    Mar26   0:00 
> pmacctd: MySQL Plugin -- DB Writer [in]     
> root     17895  0.0  0.2  13364  5000 ?        S    Mar26   0:00 
> pmacctd: MySQL Plugin -- DB Writer [out]
> 
> Why is it not closing the mysql connections or reusing the connections?
> 
> uname -a
> Linux tfb 2.6.18-6-686 #1 SMP Sun Feb 10 22:11:31 UTC 2008 i686 GNU/Linux
> 
> Promiscuous Mode Accounting Daemon, pmacctd 0.10.1
> 
> mysql --version
> mysql  Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2
> 
> Hope anyone have a clue what to try :-)
> 
> -- 
> Med venlig hilsen
> Ren? Madsen
> Schultz Conuslt
> 
> Glanshatten 54b
> 5220 Odense S?
> tlf.: (+45) 46 95 08 82
> mobil: (+45) 28 34 36 85
> www.schultzconsult.dk
> Kontortid: man-tor 08.30-18.30 fre 08.30-15.45 


_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists