{"action":"created","issue":{"url":"https://api.github.com/repos/firehol/netdata/issues/3141","repository_url":"https://api.github.com/repos/firehol/netdata","labels_url":"https://api.github.com/repos/firehol/netdata/issues/3141/labels{/name}","comments_url":"https://api.github.com/repos/firehol/netdata/issues/3141/comments","events_url":"https://api.github.com/repos/firehol/netdata/issues/3141/events","html_url":"https://github.com/firehol/netdata/issues/3141","id":282620270,"node_id":"MDU6SXNzdWUyODI2MjAyNzA=","number":3141,"title":"[FREEBSD] Can't get data from mysql plugin","user":{"login":"tisc0","id":18009937,"node_id":"MDQ6VXNlcjE4MDA5OTM3","avatar_url":"https://avatars0.githubusercontent.com/u/18009937?v=4","gravatar_id":"","url":"https://api.github.com/users/tisc0","html_url":"https://github.com/tisc0","followers_url":"https://api.github.com/users/tisc0/followers","following_url":"https://api.github.com/users/tisc0/following{/other_user}","gists_url":"https://api.github.com/users/tisc0/gists{/gist_id}","starred_url":"https://api.github.com/users/tisc0/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tisc0/subscriptions","organizations_url":"https://api.github.com/users/tisc0/orgs","repos_url":"https://api.github.com/users/tisc0/repos","events_url":"https://api.github.com/users/tisc0/events{/privacy}","received_events_url":"https://api.github.com/users/tisc0/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2017-12-16T12:23:16Z","updated_at":"2018-07-02T12:29:43Z","closed_at":"2017-12-17T01:07:43Z","author_association":"NONE","body":"Hi !\r\nRunning netdata under FreeBSD 10.3, following install process on documentation page + added package py27-pymysql-0.7.11\r\n\r\n```\r\n/opt/netdata/usr/libexec/netdata/plugins.d/python.d.plugin debug 1 mysql\r\n\r\n2017-12-16 13:07:55: python.d INFO: plugin: main: Using python 2\r\n2017-12-16 13:07:55: python.d DEBUG: plugin: main: module load source: 'mysql' => [OK]\r\n2017-12-16 13:07:55: python.d DEBUG: plugin: main: module load config: 'mysql' => [OK]\r\n2017-12-16 13:07:55: python.d DEBUG: plugin: main: job initialization: 'mysql mycnf1' => ['OK']\r\n2017-12-16 13:07:55: python.d DEBUG: plugin: main: job initialization: 'mysql mycnf2' => ['OK']\r\n2017-12-16 13:07:55: python.d DEBUG: plugin: main: job initialization: 'mysql debiancnf' => ['OK']\r\n2017-12-16 13:07:55: python.d DEBUG: plugin: main: job initialization: 'mysql socket1' => ['OK']\r\n2017-12-16 13:07:55: python.d DEBUG: plugin: main: job initialization: 'mysql socket2' => ['OK']\r\n2017-12-16 13:07:55: python.d DEBUG: plugin: main: job initialization: 'mysql socket3' => ['OK']\r\n2017-12-16 13:07:55: python.d DEBUG: plugin: main: job initialization: 'mysql socket4' => ['OK']\r\n2017-12-16 13:07:55: python.d DEBUG: plugin: main: job initialization: 'mysql tcp' => ['OK']\r\n2017-12-16 13:07:55: python.d DEBUG: plugin: main: job initialization: 'mysql tcpipv4' => ['OK']\r\n2017-12-16 13:07:55: python.d DEBUG: plugin: main: job initialization: 'mysql tcpipv6' => ['OK']\r\n2017-12-16 13:07:55: python.d DEBUG: plugin: main: job initialization: 'mysql mycnf1_root' => ['OK']\r\n2017-12-16 13:07:55: python.d DEBUG: plugin: main: job initialization: 'mysql mycnf2_root' => ['OK']\r\n2017-12-16 13:07:55: python.d DEBUG: plugin: main: job initialization: 'mysql socket1_root' => ['OK']\r\n2017-12-16 13:07:55: python.d DEBUG: plugin: main: job initialization: 'mysql socket2_root' => ['OK']\r\n2017-12-16 13:07:55: python.d DEBUG: plugin: main: job initialization: 'mysql socket3_root' => ['OK']\r\n2017-12-16 13:07:55: python.d DEBUG: plugin: main: job initialization: 'mysql socket4_root' => ['OK']\r\n2017-12-16 13:07:55: python.d DEBUG: plugin: main: job initialization: 'mysql tcp_root' => ['OK']\r\n2017-12-16 13:07:55: python.d DEBUG: plugin: main: job initialization: 'mysql tcpipv4_root' => ['OK']\r\n2017-12-16 13:07:55: python.d DEBUG: plugin: main: job initialization: 'mysql tcpipv6_root' => ['OK']\r\n2017-12-16 13:07:55: python.d DEBUG: plugin: main: job initialization: 'mysql mycnf1_netdata' => ['OK']\r\n2017-12-16 13:07:55: python.d DEBUG: plugin: main: job initialization: 'mysql mycnf2_netdata' => ['OK']\r\n2017-12-16 13:07:55: python.d DEBUG: plugin: main: job initialization: 'mysql socket1_netdata' => ['OK']\r\n2017-12-16 13:07:55: python.d DEBUG: plugin: main: job initialization: 'mysql socket2_netdata' => ['OK']\r\n2017-12-16 13:07:55: python.d DEBUG: plugin: main: job initialization: 'mysql socket3_netdata' => ['OK']\r\n2017-12-16 13:07:55: python.d DEBUG: plugin: main: job initialization: 'mysql socket4_netdata' => ['OK']\r\n2017-12-16 13:07:55: python.d DEBUG: plugin: main: job initialization: 'mysql tcp_netdata' => ['OK']\r\n2017-12-16 13:07:55: python.d DEBUG: plugin: main: job initialization: 'mysql tcpipv4_netdata' => ['OK']\r\n2017-12-16 13:07:55: python.d DEBUG: plugin: main: job initialization: 'mysql tcpipv6_netdata' => ['OK']\r\n2017-12-16 13:07:55: python.d DEBUG: plugin: main: module status: 'mysql' => [OK] (jobs: 28)\r\n(...)\r\n2017-12-16 13:07:55: python.d ERROR: mysql: mycnf1_root: \"my.cnf\" parsing is not working for pymysql\r\n2017-12-16 13:07:55: python.d ERROR: mysql: mycnf1_root: Can't establish connection to MySQL: (1045, u\"Access denied for user 'root'@'localhost' (using password: NO)\")\r\n2017-12-16 13:07:55: python.d ERROR: mysql: mycnf1_root: check() => [FAILED]\r\n(...)\r\n2017-12-16 13:16:54: python.d ERROR: mysql: tcp_netdata: Can't establish connection to MySQL: (1045, u\"Access denied for user 'netdata'@'localhost' (using password: NO)\")\r\n2017-12-16 13:16:54: python.d ERROR: mysql: tcp_netdata: check() => [FAILED]\r\n2017-12-16 13:16:54: python.d ERROR: mysql: tcpipv4_netdata: _get_data() returned no data or type is not <dict>\r\n2017-12-16 13:16:54: python.d ERROR: mysql: tcpipv4_netdata: check() => [FAILED]\r\n```\r\nJust giving some line examples for the '\"my.cnf\" parsing is not working for pymysql' since I wondering why the .my.cnf files are not parsed.\r\n\r\nWhat I'm more interested in is to understand why, whatever way I connect my user netdata or 'backup' (socket/tcpipva4,tcp, mycnf doesnt work then), I can't get any data (mysql: tcpipv4_netdata: _get_data() returned no data or type is not <dict>).\r\n\r\nOnly 'tcpipv4_root:' works properly (and generate charts), but of course I don't like that way at all.\r\n\r\nAny idea welcome !\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/firehol/netdata/issues/comments/401788219","html_url":"https://github.com/firehol/netdata/issues/3141#issuecomment-401788219","issue_url":"https://api.github.com/repos/firehol/netdata/issues/3141","id":401788219,"node_id":"MDEyOklzc3VlQ29tbWVudDQwMTc4ODIxOQ==","user":{"login":"adrianTNT","id":11273076,"node_id":"MDQ6VXNlcjExMjczMDc2","avatar_url":"https://avatars0.githubusercontent.com/u/11273076?v=4","gravatar_id":"","url":"https://api.github.com/users/adrianTNT","html_url":"https://github.com/adrianTNT","followers_url":"https://api.github.com/users/adrianTNT/followers","following_url":"https://api.github.com/users/adrianTNT/following{/other_user}","gists_url":"https://api.github.com/users/adrianTNT/gists{/gist_id}","starred_url":"https://api.github.com/users/adrianTNT/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/adrianTNT/subscriptions","organizations_url":"https://api.github.com/users/adrianTNT/orgs","repos_url":"https://api.github.com/users/adrianTNT/repos","events_url":"https://api.github.com/users/adrianTNT/events{/privacy}","received_events_url":"https://api.github.com/users/adrianTNT/received_events","type":"User","site_admin":false},"created_at":"2018-07-02T12:29:43Z","updated_at":"2018-07-02T12:29:43Z","author_association":"NONE","body":"I had the same errors, mine worked after installing `yum install MySQL-python.x86_64` , this topic helped."}}
{"actor":{"display_login":"adrianTNT"}}