{"action":"created","issue":{"url":"https://api.github.com/repos/sysown/proxysql/issues/655","repository_url":"https://api.github.com/repos/sysown/proxysql","labels_url":"https://api.github.com/repos/sysown/proxysql/issues/655/labels{/name}","comments_url":"https://api.github.com/repos/sysown/proxysql/issues/655/comments","events_url":"https://api.github.com/repos/sysown/proxysql/issues/655/events","html_url":"https://github.com/sysown/proxysql/issues/655","id":172781783,"number":655,"title":"host stays as 127.0.0.1 on admin interface","user":{"login":"fipar","id":945799,"avatar_url":"https://avatars.githubusercontent.com/u/945799?v=3","gravatar_id":"","url":"https://api.github.com/users/fipar","html_url":"https://github.com/fipar","followers_url":"https://api.github.com/users/fipar/followers","following_url":"https://api.github.com/users/fipar/following{/other_user}","gists_url":"https://api.github.com/users/fipar/gists{/gist_id}","starred_url":"https://api.github.com/users/fipar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fipar/subscriptions","organizations_url":"https://api.github.com/users/fipar/orgs","repos_url":"https://api.github.com/users/fipar/repos","events_url":"https://api.github.com/users/fipar/events{/privacy}","received_events_url":"https://api.github.com/users/fipar/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"renecannao","id":3645227,"avatar_url":"https://avatars.githubusercontent.com/u/3645227?v=3","gravatar_id":"","url":"https://api.github.com/users/renecannao","html_url":"https://github.com/renecannao","followers_url":"https://api.github.com/users/renecannao/followers","following_url":"https://api.github.com/users/renecannao/following{/other_user}","gists_url":"https://api.github.com/users/renecannao/gists{/gist_id}","starred_url":"https://api.github.com/users/renecannao/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/renecannao/subscriptions","organizations_url":"https://api.github.com/users/renecannao/orgs","repos_url":"https://api.github.com/users/renecannao/repos","events_url":"https://api.github.com/users/renecannao/events{/privacy}","received_events_url":"https://api.github.com/users/renecannao/received_events","type":"User","site_admin":false},"assignees":[{"login":"renecannao","id":3645227,"avatar_url":"https://avatars.githubusercontent.com/u/3645227?v=3","gravatar_id":"","url":"https://api.github.com/users/renecannao","html_url":"https://github.com/renecannao","followers_url":"https://api.github.com/users/renecannao/followers","following_url":"https://api.github.com/users/renecannao/following{/other_user}","gists_url":"https://api.github.com/users/renecannao/gists{/gist_id}","starred_url":"https://api.github.com/users/renecannao/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/renecannao/subscriptions","organizations_url":"https://api.github.com/users/renecannao/orgs","repos_url":"https://api.github.com/users/renecannao/repos","events_url":"https://api.github.com/users/renecannao/events{/privacy}","received_events_url":"https://api.github.com/users/renecannao/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/sysown/proxysql/milestones/7","html_url":"https://github.com/sysown/proxysql/milestones/v1.2.2","labels_url":"https://api.github.com/repos/sysown/proxysql/milestones/7/labels","id":1919583,"number":7,"title":"v1.2.2","description":"","creator":{"login":"renecannao","id":3645227,"avatar_url":"https://avatars.githubusercontent.com/u/3645227?v=3","gravatar_id":"","url":"https://api.github.com/users/renecannao","html_url":"https://github.com/renecannao","followers_url":"https://api.github.com/users/renecannao/followers","following_url":"https://api.github.com/users/renecannao/following{/other_user}","gists_url":"https://api.github.com/users/renecannao/gists{/gist_id}","starred_url":"https://api.github.com/users/renecannao/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/renecannao/subscriptions","organizations_url":"https://api.github.com/users/renecannao/orgs","repos_url":"https://api.github.com/users/renecannao/repos","events_url":"https://api.github.com/users/renecannao/events{/privacy}","received_events_url":"https://api.github.com/users/renecannao/received_events","type":"User","site_admin":false},"open_issues":12,"closed_issues":5,"state":"open","created_at":"2016-08-03T00:05:07Z","updated_at":"2016-08-31T16:44:59Z","due_on":"2016-09-02T00:00:00Z","closed_at":null},"comments":1,"created_at":"2016-08-23T19:11:01Z","updated_at":"2016-08-31T16:45:39Z","closed_at":null,"body":"Hello! \r\n\r\nI am building from source on master (at 3931c98e95f08c9a500f7b4cbcf10f6f36e75184, version reported as 1.2.1) and while using this configuration : \r\n\r\n#file proxysql.cfg\r\n\r\n# This config file is parsed using libconfig , and its grammar is described in:\r\n# http://www.hyperrealm.com/libconfig/libconfig_manual.html#Configuration-File-Grammar\r\n# Grammar is also copied at the end of this file\r\n\r\n\r\n\r\ndatadir=\"/var/lib/proxysql\"\r\n\r\nadmin_variables=\r\n{\r\n       \tadmin_credentials=\"admin:admin\"\r\n       \tmysql_ifaces=\"0.0.0.0:6032;/tmp/proxysql_admin.sock\"\r\n#      \trefresh_interval=2000\r\n       \tdebug=true\r\n}\r\n\r\nmysql_variables=\r\n{\r\n       \tthreads=4\r\n       \tmax_connections=2048\r\n       \tdefault_query_delay=0\r\n       \tdefault_query_timeout=36000000\r\n       \thave_compress=true\r\n       \tpoll_timeout=2000\r\n       \tinterfaces=\"0.0.0.0:6033;/tmp/proxysql.sock\"\r\n       \tdefault_schema=\"information_schema\"\r\n       \tstacksize=1048576\r\n       \tserver_version=\"5.1.30\"\r\n       \tconnect_timeout_server=10000\r\n       \tmonitor_history=60000\r\n       \tmonitor_connect_interval=200000\r\n       \tmonitor_ping_interval=200000\r\n       \tping_interval_server=10000\r\n       \tping_timeout_server=200\r\n       \tcommands_stats=true\r\n       \tsessions_sort=true\r\n        session_debug=true\r\n}\r\n\r\n\r\n# defines all the MySQL servers\r\nmysql_servers =\r\n(\r\n)\r\n\r\n\r\n# defines all the MySQL users\r\nmysql_users:\r\n(\r\n)\r\n\r\n\r\n\r\n#defines MySQL Query Rules\r\nmysql_query_rules:\r\n(\r\n)\r\n\r\nI still get admin binding to 127.0.0.1: \r\n\r\n\r\nvagrant@miles proxysql]$ sudo ./src/proxysql -D /data/proxysql/ -f -C /etc/proxysql.cnf\r\n2016-08-23 15:09:26 ProxySQL_Admin.cpp:2777:flush_mysql_variables___database_to_runtime(): [ERROR] Impossible to set not existing variable session_debug with value \"(null)\". Deleting\r\nStandard ProxySQL Admin rev. 0.2.0902 -- ProxySQL_Admin.cpp -- Tue Aug 23 10:46:52 2016\r\nStandard MySQL Threads Handler rev. 0.2.0902 -- MySQL_Thread.cpp -- Tue Aug 23 10:46:52 2016\r\nStandard MySQL Authentication rev. 0.2.0902 -- MySQL_Authentication.cpp -- Tue Aug 23 10:46:52 2016\r\n2016-08-23 15:09:26 [INFO] New mysql_replication_hostgroups table\r\nStandard Query Processor rev. 0.2.0902 -- Query_Processor.cpp -- Tue Aug 23 10:46:52 2016\r\nIn memory Standard Query Cache (SQC) rev. 0.2.0902 -- Query_Cache.cpp -- Thu Jun 30 00:03:32 2016\r\nStandard MySQL Monitor (StdMyMon) rev. 1.2.0723 -- MySQL_Monitor.cpp -- Tue Aug 23 10:46:52 2016\r\n\r\n[root@miles ~]# netstat -nltp|grep prox\r\ntcp        0      0 127.0.0.1:6032          0.0.0.0:*               LISTEN      19575/./src/proxysq\r\ntcp        0      0 0.0.0.0:6033            0.0.0.0:*               LISTEN      19575/./src/proxysq\r\n\r\nI would like to access the admin interface from another host (I'm currently using iptables for this). \r\n\r\n\r\nThanks!"},"comment":{"url":"https://api.github.com/repos/sysown/proxysql/issues/comments/243826084","html_url":"https://github.com/sysown/proxysql/issues/655#issuecomment-243826084","issue_url":"https://api.github.com/repos/sysown/proxysql/issues/655","id":243826084,"user":{"login":"renecannao","id":3645227,"avatar_url":"https://avatars.githubusercontent.com/u/3645227?v=3","gravatar_id":"","url":"https://api.github.com/users/renecannao","html_url":"https://github.com/renecannao","followers_url":"https://api.github.com/users/renecannao/followers","following_url":"https://api.github.com/users/renecannao/following{/other_user}","gists_url":"https://api.github.com/users/renecannao/gists{/gist_id}","starred_url":"https://api.github.com/users/renecannao/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/renecannao/subscriptions","organizations_url":"https://api.github.com/users/renecannao/orgs","repos_url":"https://api.github.com/users/renecannao/repos","events_url":"https://api.github.com/users/renecannao/events{/privacy}","received_events_url":"https://api.github.com/users/renecannao/received_events","type":"User","site_admin":false},"created_at":"2016-08-31T16:45:39Z","updated_at":"2016-08-31T16:45:39Z","body":"@fipar : can you please confirm this issue is not present anymore on 1.2.2 ?\r\nThanks"}}
{"actor":{"display_login":"renecannao"}}