Paolo Lucente wrote:
Hello David,
i've tested your configuration against a MySQL 4.1 server and it seems
to work just fine to my eyes. The password you specified is 'pmacct'
which is not the default one - 'arealsmartpwd'. The SQL table creation
script uses such password by default.
Did you change it in the script aswell ? Or are you able to connect to
the DB with 'pmacct' as both username and password ? Does the MySQL
server listen over the usual 'mysql.sock' socket (if you don't know,
you should be able to find it with 'netstat') or just on the TCP port ?
If this is the case you should add to your configuration the line
'sql_host: 127.0.0.1'.
Debugging such messy behaviours via strace or gdb is not that good; the
solution should be to keep an eye to the logs and I'm working to return
more explicit SQL server error messages; i don't actually know how to
increase the MySQL log verbosity (anyone has idea ?). And about the
mailing-list archives: archives are available for the subscribers but
not searchable (that is, you have to dig through the messages manually).
Let me know how things get evolved !
Cheers,
Paolo
_______________________________________________
pmacct-discussion mailing list
[email protected]
http://muffin.area.ba.cnr.it/mailman/listinfo/pmacct-discussion
Got it! I didn't have a sql_host entry in the config (db is on another
server).
The problem I have now is the mac_src, mac_dst, src_port and dst_port
fields
are always 0 (protocol is ip). I've added a ports file that currently
lists all ports
as described by the ports_file option but the port numbers still appear
as 0.
Here is my config as it currently stands;
debug: true
interface: eth1
daemonize: false
aggregate: src_host
plugins: mysql
sql_db: pmacct
sql_table: acct
sql_table_version: 1
sql_passwd: pmacct
sql_user: pmacct
sql_host: 10.0.0.187
sql_refresh_time: 10
sql_history: 10m
sql_history_roundoff: mh
pidfile: /var/run/pmacctd.pid
ports_file: /etc/pmacctd-ports
David
--
David Filion
[EMAIL PROTECTED]
System / Network Administrator
Auto123.com / XPrima Corporation
(450)681-5868 ext. 252
