{"action":"created","issue":{"url":"https://api.github.com/repos/FreeRADIUS/freeradius-server/issues/499","labels_url":"https://api.github.com/repos/FreeRADIUS/freeradius-server/issues/499/labels{/name}","comments_url":"https://api.github.com/repos/FreeRADIUS/freeradius-server/issues/499/comments","events_url":"https://api.github.com/repos/FreeRADIUS/freeradius-server/issues/499/events","html_url":"https://github.com/FreeRADIUS/freeradius-server/issues/499","id":25459200,"number":499,"title":"read_group=yes but radgroupreply doesnot work","user":{"login":"krajdyal","id":3018383,"avatar_url":"https://avatars.githubusercontent.com/u/3018383?v=3","gravatar_id":"","url":"https://api.github.com/users/krajdyal","html_url":"https://github.com/krajdyal","followers_url":"https://api.github.com/users/krajdyal/followers","following_url":"https://api.github.com/users/krajdyal/following{/other_user}","gists_url":"https://api.github.com/users/krajdyal/gists{/gist_id}","starred_url":"https://api.github.com/users/krajdyal/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/krajdyal/subscriptions","organizations_url":"https://api.github.com/users/krajdyal/orgs","repos_url":"https://api.github.com/users/krajdyal/repos","events_url":"https://api.github.com/users/krajdyal/events{/privacy}","received_events_url":"https://api.github.com/users/krajdyal/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":11,"created_at":"2014-01-12T09:03:50Z","updated_at":"2015-03-03T07:35:51Z","closed_at":"2014-01-12T13:02:36Z","body":" sql {\r\n        driver = \"rlm_sql_mysql\"\r\n        server = \"localhost\"\r\n        port = \"3306\"\r\n        login = \"root\"\r\n        password = \"XYZXYZXYZ\"\r\n        radius_db = \"radius\"\r\n        read_groups = yes\r\n        read_clients = yes\r\n        delete_stale_sessions = yes\r\n        sql_user_name = \"%{User-Name}\"\r\n        default_user_profile = \"DEFAULT\"\r\n        client_query = \"SELECT id, nasname, shortname, type, secret, server FROM nas\"\r\n        authorize_check_query = \"SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id\"\r\n        authorize_reply_query = \"SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id\"\r\n        authorize_group_check_query = \"SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{Sql-Group}' ORDER BY id\"\r\n        authorize_group_reply_query = \"SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{Sql-Group}' ORDER BY id\"\r\n        group_membership_query = \"SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority\"\r\n        simul_count_query = \"SELECT COUNT(*) FROM radacct WHERE username = '%{SQL-User-Name}' AND acctstoptime IS NULL\"\r\n        simul_verify_query = \"SELECT radacctid, acctsessionid, username, nasipaddress, nasportid, framedipaddress, callingstationid, framedprotocol FROM radacct WHERE username = '%{SQL-User-Name}' AND acctstoptime IS NULL\"\r\n        safe_characters = \"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /\"\r\n  }\r\n\r\n\r\n-----------------------------------------------------\r\n(0) sql :       expand: \"%{User-Name}\" -> 'parsa'\r\n(0) sql : SQL-User-Name set to 'parsa'\r\nrlm_sql (sql): Reserved connection (19)\r\n(0) sql :       expand: \"SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id\" -> 'SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'parsa' ORDER BY id'\r\nrlm_sql (sql): Executing query: 'SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'parsa' ORDER BY id'\r\n(0) sql : User found in radcheck table\r\n(0) sql : Check items matched\r\n(0) sql :       expand: \"SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id\" -> 'SELECT id, username, attribute, value, op FROM radreply WHERE username = 'parsa' ORDER BY id'\r\nrlm_sql (sql): Executing query: 'SELECT id, username, attribute, value, op FROM radreply WHERE username = 'parsa' ORDER BY id'\r\n(0) sql : User found in radreply table\r\n(0) sql :       expand: \"SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority\" -> 'SELECT groupname FROM radusergroup WHERE username = 'parsa' ORDER BY priority'\r\nrlm_sql (sql): Executing query: 'SELECT groupname FROM radusergroup WHERE username = 'parsa' ORDER BY priority'\r\nrlm_sql (sql): Released connection (19)\r\n(0)   [-sql] = ok\r\n(0) expiration : Account will expire at 'Jan 22 2014 00:00:00 NPT'\r\n(0)   [expiration] = ok\r\n---------------------------------------------------------\r\nDoesnot process radgroupreply"},"comment":{"url":"https://api.github.com/repos/FreeRADIUS/freeradius-server/issues/comments/76899897","html_url":"https://github.com/FreeRADIUS/freeradius-server/issues/499#issuecomment-76899897","issue_url":"https://api.github.com/repos/FreeRADIUS/freeradius-server/issues/499","id":76899897,"user":{"login":"ShakyShip","id":11286213,"avatar_url":"https://avatars.githubusercontent.com/u/11286213?v=3","gravatar_id":"","url":"https://api.github.com/users/ShakyShip","html_url":"https://github.com/ShakyShip","followers_url":"https://api.github.com/users/ShakyShip/followers","following_url":"https://api.github.com/users/ShakyShip/following{/other_user}","gists_url":"https://api.github.com/users/ShakyShip/gists{/gist_id}","starred_url":"https://api.github.com/users/ShakyShip/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ShakyShip/subscriptions","organizations_url":"https://api.github.com/users/ShakyShip/orgs","repos_url":"https://api.github.com/users/ShakyShip/repos","events_url":"https://api.github.com/users/ShakyShip/events{/privacy}","received_events_url":"https://api.github.com/users/ShakyShip/received_events","type":"User","site_admin":false},"created_at":"2015-03-03T07:35:51Z","updated_at":"2015-03-03T07:35:51Z","body":"Thanks brother, finally my freeradius sent group reply to my Mikrotik\r\nbut you should put the fixed one on CentOS 7 repo, cause before I change to 3.0.2 I've installed 3.0.2 from repo"}}