[pmacct-discussion] sfacctd, mysql

2017-11-21 Thread Nicholas Geovanis
Hi - Using pmacctd/sfacctd 1.7.0, I notice that the "-P mysql" operand on the sfacctd executable is supported and accepted OK (don't have sflow data in the DB yet). But when I use "plugins: mysql" in the conf file, I receive message WARN:Unable to handle key: plugins. Ignored at the

Re: [pmacct-discussion] pmacct 1.7.0, can't connect to mysql

2017-11-10 Thread Nicholas Geovanis
Also reporting successful build and basic operation of pmacct 1.7.0 on up-to-date Ubuntu 16.04 LTS with the Ubuntu-repository-supplied Mysql 5.7 back end, under VMware 6.5.0 and ESXi 5.5.0. On Fri, Nov 3, 2017 at 12:34 PM, Nicholas Geovanis <nickgeova...@gmail.com> wrote: > >On Fri,

Re: [pmacct-discussion] pmacct 1.7.0, can't connect to mysql

2017-11-03 Thread Nicholas Geovanis
s://github.com/pmacct/pmacct/blob/master/sql/README.mysql#L115-L122 Paolo On Fri, Nov 3, 2017 at 6:27 AM, Paolo Lucente <pa...@pmacct.net> wrote: > > Hi Nick, > > Inline: > > On Thu, Nov 02, 2017 at 05:10:31PM -0500, Nicholas Geovanis wrote: > > > >

Re: [pmacct-discussion] pmacct 1.7.0, can't connect to mysql

2017-11-02 Thread Nicholas Geovanis
Shall none of this work, please rever to 1.6.2 to see > if that is (not) working for you. > > For the SQL UPDATE statement, you are using a v8 schema and should set > pmacct to use that same version: a 'sql_table_version: 8' should do. > > Paolo > > On Thu, Nov 02, 2017 at 02:11:0

Re: [pmacct-discussion] pmacct 1.7.0, can't connect to mysql

2017-11-02 Thread Nicholas Geovanis
| | stamp_inserted | datetime| NO | PRI | NULL| | | stamp_updated | datetime| YES | | NULL| | ++-+--+-+-+---+ 19 rows in set (0.00 sec) On Thu, Nov 2, 2017 at 1:58 PM, Nicholas Geovanis

Re: [pmacct-discussion] pmacct 1.7.0, can't connect to mysql

2017-11-02 Thread Nicholas Geovanis
INFO ( default/core ): link type is: 1 > Yann > On Thu, Nov 2, 2017, 17:54 Nicholas Geovanis <nickgeova...@gmail.com> > 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.

[pmacct-discussion] pmacct 1.7.0, can't connect to mysql

2017-11-02 Thread Nicholas Geovanis
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: