RADGROUPREPLY QUERY NOT EXECUTED
Have tried several version builds on Centos 5.x - currently using FR 2.1.12 rlm_mysql stops after the group check query and does not execute the group reply query. 19:00:43 2012 : Info: [sql] expand: SELECT id, username, attribute, value, op FROM radreply Sun Sep 9 19:00:43 2012 : Info: [sql] expand: SELECT groupname FROM usergroup Sun Sep 9 19:00:43 2012 : Info: [sql] expand: SELECT id, groupname, attribute,Value, op FROM radgroupcheck Sun Sep 9 19:00:43 2012 : Debug: rlm_sql (sql): Released sql socket id: 4 Queries are listed during module instantiation and queries work when run manually. Have seen similar unresolved thread. Greatly appreciate any help. Thanks ________________________________________________________________ Message sent using DataCom.MW 1.2.0
Works fine for me... All centos versions, all FR versions since 1.1.3... On 9/9/2012 7:33 PM, Mada wrote:
Have tried several version builds on Centos 5.x - currently using FR 2.1.12
rlm_mysql stops after the group check query and does not execute the group reply query.
19:00:43 2012 : Info: [sql] expand: SELECT id, username, attribute, value, op FROM radreply Sun Sep 9 19:00:43 2012 : Info: [sql] expand: SELECT groupname FROM usergroup Sun Sep 9 19:00:43 2012 : Info: [sql] expand: SELECT id, groupname, attribute,Value, op FROM radgroupcheck Sun Sep 9 19:00:43 2012 : Debug: rlm_sql (sql): Released sql socket id: 4
Queries are listed during module instantiation and queries work when run manually. Have seen similar unresolved thread.
Greatly appreciate any help.
Thanks
________________________________________________________________ Message sent using DataCom.MW 1.2.0
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
On 9 Sep 2012, at 18:33, Mada <mada@datacom.mw> wrote:
Have tried several version builds on Centos 5.x - currently using FR 2.1.12
rlm_mysql stops after the group check query and does not execute the group reply query.
19:00:43 2012 : Info: [sql] expand: SELECT id, username, attribute, value, op FROM radreply Sun Sep 9 19:00:43 2012 : Info: [sql] expand: SELECT groupname FROM usergroup Sun Sep 9 19:00:43 2012 : Info: [sql] expand: SELECT id, groupname, attribute,Value, op FROM radgroupcheck Sun Sep 9 19:00:43 2012 : Debug: rlm_sql (sql): Released sql socket id: 4
Queries are listed during module instantiation and queries work when run manually. Have seen similar unresolved thread.
Um weird... Don't suppose you want to build with 3.0 and see if the problem still exists? :) I'll check the code for something obvious. -Arran
On 9 Sep 2012, at 20:39, Arran Cudbard-Bell <a.cudbardb@freeradius.org> wrote:
On 9 Sep 2012, at 18:33, Mada <mada@datacom.mw> wrote:
Have tried several version builds on Centos 5.x - currently using FR 2.1.12
rlm_mysql stops after the group check query and does not execute the group reply query.
19:00:43 2012 : Info: [sql] expand: SELECT id, username, attribute, value, op FROM radreply Sun Sep 9 19:00:43 2012 : Info: [sql] expand: SELECT groupname FROM usergroup Sun Sep 9 19:00:43 2012 : Info: [sql] expand: SELECT id, groupname, attribute,Value, op FROM radgroupcheck Sun Sep 9 19:00:43 2012 : Debug: rlm_sql (sql): Released sql socket id: 4
Queries are listed during module instantiation and queries work when run manually. Have seen similar unresolved thread.
Um weird...
Don't suppose you want to build with 3.0 and see if the problem still exists? :)
I'll check the code for something obvious.
Wait... your query strings are massively truncated? -Arran
On Mon, Sep 10, 2012 at 12:33 AM, Mada <mada@datacom.mw> wrote:
Have tried several version builds on Centos 5.x - currently using FR 2.1.12
rlm_mysql stops after the group check query and does not execute the group reply query.
19:00:43 2012 : Info: [sql] expand: SELECT id, username, attribute, value, op FROM radreply Sun Sep 9 19:00:43 2012 : Info: [sql] expand: SELECT groupname FROM usergroup Sun Sep 9 19:00:43 2012 : Info: [sql] expand: SELECT id, groupname, attribute,Value, op FROM radgroupcheck Sun Sep 9 19:00:43 2012 : Debug: rlm_sql (sql): Released sql socket id: 4
Queries are listed during module instantiation and queries work when run manually. Have seen similar unresolved thread.
I'm guessing you keep all the config files from the old versions, instead of using fresh config and modify-as-necessary? What's the value of "read_groups" in sql.conf (or whatever file contains your sql module instance)? Have you tried explicitly setting it to "yes"? -- Fajar
participants (4)
-
Arran Cudbard-Bell -
Fajar A. Nugraha -
Mada -
Marinko Tarlac