subject:"\[pmacct\-discussion\] pmacct 1.7.0, can't connect to mysql"

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 
wrote:

> >On Fri, Nov 3, 2017 at 6:27 AM, Paolo Lucente  wrote:
>
> >Enable sql_history. Start with 5 mins time bins then you can customise
> >with what you really need:
>
> >sql_history: 5m
> >sql_history_roundoff: m
>
> Thanks. I missed that entirely.
>
> >This is because you have set sql_num_hosts to true. You could remove
> >that or you should customise your schema. See the relevant section from
> >README.mysql:
>
> Thanks.
> I also needed to enlarge the ip_src/dest fields for IPv6.
>
> And after that it runs fine on Ubuntu 17.10, so thank you very much.
> .Nick G
>
> >https://github.com/pmacct/pmacct/blob/master/sql/README.mysql#L115-L122
>
> Paolo
>
>
> On Fri, Nov 3, 2017 at 6:27 AM, Paolo Lucente  wrote:
>
>>
>> Hi Nick,
>>
>> Inline:
>>
>> On Thu, Nov 02, 2017 at 05:10:31PM -0500, Nicholas Geovanis wrote:
>> >
>> > INSERT INTO `acct_v8` (vlan, ip_src, ip_dst, as_src, as_dst, port_src,
>> > port_dst, tcp_flags, tos, ip_proto, agent_id, class_id, mac_src,
>> mac_dst,
>> > packets, bytes, flows) VALUES (0, INET6_ATON('192.168.50.211'),
>> > INET6_ATON('192.168.50.18'), 0, 0, 0, 0, 0, 0, '0', 0, 'unknown',
>> > '0:0:0:0:0:0', '0:0:0:0:0:0', 4, 340, 0)
>> > ERROR ( default_mysql/mysql ): Field 'stamp_inserted' doesn't have a
>> > default value
>>
>> Enable sql_history. Start with 5 mins time bins then you can customise
>> with what you really need:
>>
>> sql_history: 5m
>> sql_history_roundoff: m
>>
>> > INSERT INTO `acct_v8` (vlan, ip_src, ip_dst, as_src, as_dst, port_src,
>> > port_dst, tcp_flags, tos, ip_proto, agent_id, class_id, mac_src,
>> mac_dst,
>> > packets, bytes, flows) VALUES (0, INET6_ATON('fe80::5e26:aff:fe8
>> 6:58b8'),
>> > INET6_ATON('ff02::fb'), 0, 0, 0, 0, 0, 0, '0', 0, 'unknown',
>> '0:0:0:0:0:0',
>> > '0:0:0:0:0:0', 1, 174, 0)
>> > ERROR ( default_mysql/mysql ): Data too long for column 'ip_src' at row
>> 1
>>
>> This is because you have set sql_num_hosts to true. You could remove
>> that or you should customise your schema. See the relevant section from
>> README.mysql:
>>
>> https://github.com/pmacct/pmacct/blob/master/sql/README.mysql#L115-L122
>>
>> Paolo
>>
>
>
___
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists

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

2017-11-03 Thread Nicholas Geovanis

>On Fri, Nov 3, 2017 at 6:27 AM, Paolo Lucente  wrote:

>Enable sql_history. Start with 5 mins time bins then you can customise
>with what you really need:

>sql_history: 5m
>sql_history_roundoff: m

Thanks. I missed that entirely.

>This is because you have set sql_num_hosts to true. You could remove
>that or you should customise your schema. See the relevant section from
>README.mysql:

Thanks.
I also needed to enlarge the ip_src/dest fields for IPv6.

And after that it runs fine on Ubuntu 17.10, so thank you very much.
.Nick G

>https://github.com/pmacct/pmacct/blob/master/sql/README.mysql#L115-L122

Paolo


On Fri, Nov 3, 2017 at 6:27 AM, Paolo Lucente  wrote:

>
> Hi Nick,
>
> Inline:
>
> On Thu, Nov 02, 2017 at 05:10:31PM -0500, Nicholas Geovanis wrote:
> >
> > INSERT INTO `acct_v8` (vlan, ip_src, ip_dst, as_src, as_dst, port_src,
> > port_dst, tcp_flags, tos, ip_proto, agent_id, class_id, mac_src, mac_dst,
> > packets, bytes, flows) VALUES (0, INET6_ATON('192.168.50.211'),
> > INET6_ATON('192.168.50.18'), 0, 0, 0, 0, 0, 0, '0', 0, 'unknown',
> > '0:0:0:0:0:0', '0:0:0:0:0:0', 4, 340, 0)
> > ERROR ( default_mysql/mysql ): Field 'stamp_inserted' doesn't have a
> > default value
>
> Enable sql_history. Start with 5 mins time bins then you can customise
> with what you really need:
>
> sql_history: 5m
> sql_history_roundoff: m
>
> > INSERT INTO `acct_v8` (vlan, ip_src, ip_dst, as_src, as_dst, port_src,
> > port_dst, tcp_flags, tos, ip_proto, agent_id, class_id, mac_src, mac_dst,
> > packets, bytes, flows) VALUES (0, INET6_ATON('fe80::5e26:aff:
> fe86:58b8'),
> > INET6_ATON('ff02::fb'), 0, 0, 0, 0, 0, 0, '0', 0, 'unknown',
> '0:0:0:0:0:0',
> > '0:0:0:0:0:0', 1, 174, 0)
> > ERROR ( default_mysql/mysql ): Data too long for column 'ip_src' at row 1
>
> This is because you have set sql_num_hosts to true. You could remove
> that or you should customise your schema. See the relevant section from
> README.mysql:
>
> https://github.com/pmacct/pmacct/blob/master/sql/README.mysql#L115-L122
>
> Paolo
>
___
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists

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

2017-11-03 Thread Paolo Lucente


Hi Nick,

Inline:

On Thu, Nov 02, 2017 at 05:10:31PM -0500, Nicholas Geovanis wrote:
> 
> INSERT INTO `acct_v8` (vlan, ip_src, ip_dst, as_src, as_dst, port_src,
> port_dst, tcp_flags, tos, ip_proto, agent_id, class_id, mac_src, mac_dst,
> packets, bytes, flows) VALUES (0, INET6_ATON('192.168.50.211'),
> INET6_ATON('192.168.50.18'), 0, 0, 0, 0, 0, 0, '0', 0, 'unknown',
> '0:0:0:0:0:0', '0:0:0:0:0:0', 4, 340, 0)
> ERROR ( default_mysql/mysql ): Field 'stamp_inserted' doesn't have a
> default value

Enable sql_history. Start with 5 mins time bins then you can customise
with what you really need:

sql_history: 5m
sql_history_roundoff: m

> INSERT INTO `acct_v8` (vlan, ip_src, ip_dst, as_src, as_dst, port_src,
> port_dst, tcp_flags, tos, ip_proto, agent_id, class_id, mac_src, mac_dst,
> packets, bytes, flows) VALUES (0, INET6_ATON('fe80::5e26:aff:fe86:58b8'),
> INET6_ATON('ff02::fb'), 0, 0, 0, 0, 0, 0, '0', 0, 'unknown', '0:0:0:0:0:0',
> '0:0:0:0:0:0', 1, 174, 0)
> ERROR ( default_mysql/mysql ): Data too long for column 'ip_src' at row 1

This is because you have set sql_num_hosts to true. You could remove
that or you should customise your schema. See the relevant section from
README.mysql:

https://github.com/pmacct/pmacct/blob/master/sql/README.mysql#L115-L122

Paolo

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

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

2017-11-02 Thread Nicholas Geovanis

Hi -
It turned-out that I needed to specify the sql_passwd line with "no space"
after the colon,
such as "sql_passwd:arealsmartpwd". Then pmacctd connects OK.

But I still have schema problems, such as:

INSERT INTO `acct_v8` (vlan, ip_src, ip_dst, as_src, as_dst, port_src,
port_dst, tcp_flags, tos, ip_proto, agent_id, class_id, mac_src, mac_dst,
packets, bytes, flows) VALUES (0, INET6_ATON('192.168.50.211'),
INET6_ATON('192.168.50.18'), 0, 0, 0, 0, 0, 0, '0', 0, 'unknown',
'0:0:0:0:0:0', '0:0:0:0:0:0', 4, 340, 0)
ERROR ( default_mysql/mysql ): Field 'stamp_inserted' doesn't have a
default value

...and...
INSERT INTO `acct_v8` (vlan, ip_src, ip_dst, as_src, as_dst, port_src,
port_dst, tcp_flags, tos, ip_proto, agent_id, class_id, mac_src, mac_dst,
packets, bytes, flows) VALUES (0, INET6_ATON('fe80::5e26:aff:fe86:58b8'),
INET6_ATON('ff02::fb'), 0, 0, 0, 0, 0, 0, '0', 0, 'unknown', '0:0:0:0:0:0',
'0:0:0:0:0:0', 1, 174, 0)
ERROR ( default_mysql/mysql ): Data too long for column 'ip_src' at row 1

As I mentioned I am using the v8 schema. Unless I notice something soon I
will probably move to the previous version and try that.
Thanks to Yann and Paolo. 10 years now since I was in bell'Italia; I would
go tomorrow if I could.
Buona notte.Nick G

On Thu, Nov 2, 2017 at 3:38 PM, Paolo Lucente  wrote:

>
> Hi Nicholas,
>
> For the user permission issue i would recommend trying one of the
> following things: 1) adding a 'sql_host: 127.0.0.1' to your config or 2)
> configuring your user as 'pmacct'@'%'. If i recall correctly, when
> connecting locally you could opt for the loopback interface or the UNIX
> socket; 'localhost' applies when using the loopback interface (and not
> the UNIX socket). 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:04PM -0500, Nicholas Geovanis wrote:
> > I also don't know if this is relevant or important, but I note that the
> > subsequent failing
> > SQL UPDATE statements are referencing columns which do not exist in the
> > acct_v8 table.
> > Here's an example; note that the schema defines column "port_src", not
> the
> > missing "src_port":
> >
> > UPDATE `acct_v8` SET packets=packets+21, bytes=bytes+9818 WHERE
> > ip_src=INET6_ATON('192.168.50.133') AND
> > ip_dst=INET6_ATON('239.255.255.250') AND src_port=0 AND dst_port=0 AND
> > ip_proto='0' AND mac_src='0:0:0:0:0:0' AND mac_dst='0:0:0:0:0:0'
> > ERROR ( default_mysql/mysql ): Unknown column 'src_port' in 'where
> clause'
> >
> > Here's the running DB:
> > mysql> describe acct_v8;
> > ++-+--+-+-+---+
> > | Field  | Type| Null | Key | Default | Extra |
> > ++-+--+-+-+---+
> > | agent_id   | int(4) unsigned | NO   | PRI | NULL|   |
> > | class_id   | char(16)| NO   | PRI | NULL|   |
> > | mac_src| char(17)| NO   | PRI | NULL|   |
> > | mac_dst| char(17)| NO   | PRI | NULL|   |
> > | vlan   | int(2) unsigned | NO   | PRI | NULL|   |
> > | as_src | int(4) unsigned | NO   | PRI | NULL|   |
> > | as_dst | int(4) unsigned | NO   | PRI | NULL|   |
> > | ip_src | char(15)| NO   | PRI | NULL|   |
> > | ip_dst | char(15)| NO   | PRI | NULL|   |
> > | port_src   | int(2) unsigned | NO   | PRI | NULL|   |
> > | port_dst   | int(2) unsigned | NO   | PRI | NULL|   |
> > | tcp_flags  | int(4) unsigned | NO   | | NULL|   |
> > | ip_proto   | char(6) | NO   | PRI | NULL|   |
> > | tos| int(4) unsigned | NO   | PRI | NULL|   |
> > | packets| int(10) unsigned| NO   | | NULL|   |
> > | bytes  | bigint(20) unsigned | NO   | | NULL|   |
> > | flows  | int(10) unsigned| NO   | | NULL|   |
> > | 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 <
> nickgeova...@gmail.com>
> > wrote:
> >
> > > On Thu, Nov 2, 2017 at 11:59 AM, Yann Belin 
> 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

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

2017-11-02 Thread Paolo Lucente


Hi Nicholas,

For the user permission issue i would recommend trying one of the
following things: 1) adding a 'sql_host: 127.0.0.1' to your config or 2)
configuring your user as 'pmacct'@'%'. If i recall correctly, when
connecting locally you could opt for the loopback interface or the UNIX
socket; 'localhost' applies when using the loopback interface (and not
the UNIX socket). 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:04PM -0500, Nicholas Geovanis wrote:
> I also don't know if this is relevant or important, but I note that the
> subsequent failing
> SQL UPDATE statements are referencing columns which do not exist in the
> acct_v8 table.
> Here's an example; note that the schema defines column "port_src", not the
> missing "src_port":
> 
> UPDATE `acct_v8` SET packets=packets+21, bytes=bytes+9818 WHERE
> ip_src=INET6_ATON('192.168.50.133') AND
> ip_dst=INET6_ATON('239.255.255.250') AND src_port=0 AND dst_port=0 AND
> ip_proto='0' AND mac_src='0:0:0:0:0:0' AND mac_dst='0:0:0:0:0:0'
> ERROR ( default_mysql/mysql ): Unknown column 'src_port' in 'where clause'
> 
> Here's the running DB:
> mysql> describe acct_v8;
> ++-+--+-+-+---+
> | Field  | Type| Null | Key | Default | Extra |
> ++-+--+-+-+---+
> | agent_id   | int(4) unsigned | NO   | PRI | NULL|   |
> | class_id   | char(16)| NO   | PRI | NULL|   |
> | mac_src| char(17)| NO   | PRI | NULL|   |
> | mac_dst| char(17)| NO   | PRI | NULL|   |
> | vlan   | int(2) unsigned | NO   | PRI | NULL|   |
> | as_src | int(4) unsigned | NO   | PRI | NULL|   |
> | as_dst | int(4) unsigned | NO   | PRI | NULL|   |
> | ip_src | char(15)| NO   | PRI | NULL|   |
> | ip_dst | char(15)| NO   | PRI | NULL|   |
> | port_src   | int(2) unsigned | NO   | PRI | NULL|   |
> | port_dst   | int(2) unsigned | NO   | PRI | NULL|   |
> | tcp_flags  | int(4) unsigned | NO   | | NULL|   |
> | ip_proto   | char(6) | NO   | PRI | NULL|   |
> | tos| int(4) unsigned | NO   | PRI | NULL|   |
> | packets| int(10) unsigned| NO   | | NULL|   |
> | bytes  | bigint(20) unsigned | NO   | | NULL|   |
> | flows  | int(10) unsigned| NO   | | NULL|   |
> | 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 
> wrote:
> 
> > On Thu, Nov 2, 2017 at 11:59 AM, Yann Belin  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:

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

2017-11-02 Thread Nicholas Geovanis

I also don't know if this is relevant or important, but I note that the
subsequent failing
SQL UPDATE statements are referencing columns which do not exist in the
acct_v8 table.
Here's an example; note that the schema defines column "port_src", not the
missing "src_port":

UPDATE `acct_v8` SET packets=packets+21, bytes=bytes+9818 WHERE
ip_src=INET6_ATON('192.168.50.133') AND
ip_dst=INET6_ATON('239.255.255.250') AND src_port=0 AND dst_port=0 AND
ip_proto='0' AND mac_src='0:0:0:0:0:0' AND mac_dst='0:0:0:0:0:0'
ERROR ( default_mysql/mysql ): Unknown column 'src_port' in 'where clause'

Here's the running DB:
mysql> describe acct_v8;
++-+--+-+-+---+
| Field  | Type| Null | Key | Default | Extra |
++-+--+-+-+---+
| agent_id   | int(4) unsigned | NO   | PRI | NULL|   |
| class_id   | char(16)| NO   | PRI | NULL|   |
| mac_src| char(17)| NO   | PRI | NULL|   |
| mac_dst| char(17)| NO   | PRI | NULL|   |
| vlan   | int(2) unsigned | NO   | PRI | NULL|   |
| as_src | int(4) unsigned | NO   | PRI | NULL|   |
| as_dst | int(4) unsigned | NO   | PRI | NULL|   |
| ip_src | char(15)| NO   | PRI | NULL|   |
| ip_dst | char(15)| NO   | PRI | NULL|   |
| port_src   | int(2) unsigned | NO   | PRI | NULL|   |
| port_dst   | int(2) unsigned | NO   | PRI | NULL|   |
| tcp_flags  | int(4) unsigned | NO   | | NULL|   |
| ip_proto   | char(6) | NO   | PRI | NULL|   |
| tos| int(4) unsigned | NO   | PRI | NULL|   |
| packets| int(10) unsigned| NO   | | NULL|   |
| bytes  | bigint(20) unsigned | NO   | | NULL|   |
| flows  | int(10) unsigned| NO   | | NULL|   |
| 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 
wrote:

> On Thu, Nov 2, 2017 at 11:59 AM, Yann Belin  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

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

2017-11-02 Thread Nicholas Geovanis

On Thu, Nov 2, 2017 at 11:59 AM, Yann Belin  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 
> 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

[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:

/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

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

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

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

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

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

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

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

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

8 matches

Site Navigation

Mail list logo

Footer information