On Thu, Nov 2, 2017 at 11:59 AM, Yann Belin <[email protected]> wrote:
> Hi Nicholas, > > How is your MySQL user defined, xxx@'localhost'? > Hi - I've tried both pmacct and pmacct@localhost in the conf file, but the result is the same. Also tried with and without quotes. Perhaps not related, but I also noticed a syntax error message in the conf file from the following line: plugins: mysql Leaving that line out of the conf file causes the error message to not appear at startup, but doesn't attain database connection either. Here are the log lines in that case (note the sql_passwd is the shipped default): DEBUG: [/home/nick/src/pmacct.conf] plugins:mysql WARN: [/home/nick/src/pmacct.conf:11] Unable to handle key: plugins. Ignored. INFO ( default/core ): Promiscuous Mode Accounting Daemon, pmacctd 1.7.0 (20170924-00+c1) Here is the full startup log without the "plugins: mysql" line in the conf file. Note that the sql_passwd is set to the shipped default: root@nick-OptiPlex-755:/home/nick/src/pmacct-1.7.0# /usr/local/sbin/pmacctd -d -P mysql -f /home/nick/src/pmacct.conf 192.168.50.211 DEBUG: [/home/nick/src/pmacct.conf] plugin name/type: 'default'/'core'. DEBUG: [/home/nick/src/pmacct.conf] plugin name/type: 'default_mysql'/'mysql'. DEBUG: [/home/nick/src/pmacct.conf] daemonize:false DEBUG: [/home/nick/src/pmacct.conf] aggregate:src_host, dst_host DEBUG: [/home/nick/src/pmacct.conf] interface:enp0s25 DEBUG: [/home/nick/src/pmacct.conf] sql_db:pmacct DEBUG: [/home/nick/src/pmacct.conf] sql_user:pmacct DEBUG: [/home/nick/src/pmacct.conf] sql_passwd:arealsmartpwd DEBUG: [/home/nick/src/pmacct.conf] sql_table:acct_v8 DEBUG: [/home/nick/src/pmacct.conf] sql_num_hosts:true DEBUG: [/home/nick/src/pmacct.conf] debug:true INFO ( default/core ): Promiscuous Mode Accounting Daemon, pmacctd 1.7.0 (20170924-00+c1) INFO ( default/core ): '--enable-mysql' '--enable-l2' '--enable-ipv6' '--enable-64bit' '--enable-threads' '--enable-traffic-bins' '--enable-bgp-bins' '--enable-bmp-bins' '--enable-st-bins' INFO ( default/core ): Reading configuration file '/home/nick/src/pmacct.conf'. INFO ( default_mysql/mysql ): plugin_pipe_size=4096000 bytes plugin_buffer_size=288 bytes INFO ( default_mysql/mysql ): ctrl channel: obtained=212992 bytes target=113776 bytes INFO ( default_mysql/mysql ): cache entries=32771 base cache memory=11631392 bytes INFO ( default/core ): link type is: 1 > Yann > On Thu, Nov 2, 2017, 17:54 Nicholas Geovanis <[email protected]> > wrote: > >> Hi - >> I have pmacct 1.7.0 installed from source on an Ubuntu 17.10 system >> running MySQL 5.7. Just experimenting so far. I have specified both >> sql_user and sql_passwd (and sql_table and sql_db) in the conf file, run >> the initialization sql successfully, and started pmacctd like this: >> >> /home/nick/src/pmacct-1.7.0# /usr/local/sbin/pmacctd -d -P mysql -f >> /home/nick/src/pmacct.conf 192.168.50.211 >> >> No matter what I do, pmacctd cannot connect to the database: >> >> ERROR ( default_mysql/mysql ): PRIMARY 'mysql' backend trouble. >> ERROR ( default_mysql/mysql ): The SQL server says: Access denied for >> user 'pmacct'@'localhost' (using password: YES) >> >> Despite this, I can successfully connect using the very same password >> which is defined in the pmacct.conf file if I type it by hand: >> "nick@nick-OptiPlex-755:~$ mysql -u pmacct -p >> Enter password: >> Welcome to the MySQL monitor. Commands end with ; or \g. >> Your MySQL connection id is 163 >> Server version: 5.7.20-0ubuntu0.17.10.1 (Ubuntu) >> >> Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights >> reserved. >> >> Oracle is a registered trademark of Oracle Corporation and/or its" >> ...and so on, clipped. >> >> There is no difference if I enclose the conf file's sql_passwd argument >> in quotes or not. >> What is my issue here? Thanks.....Nick >> >>
_______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
