Good day. I'd like to install on FreeBSD 9.2 FreeRadius2 with MySQL # radiusd -X ... rad_recv: Access-Request packet from host 1.2.3.4 port 15191, id=95, length=46 User-Name = "krylov" User-Password = "password" # Executing section authorize from file /usr/local/etc/raddb/sites-enabled/default +group authorize { rlm_sql (sql): Reserving sql socket id: 4 [sql] expand: -> [sql] Error generating query; rejecting user rlm_sql (sql): Released sql socket id: 4 ++[sql] = fail +} # group authorize = fail Using Post-Auth-Type REJECT WARNING: Unknown value specified for Post-Auth-Type. Cannot perform requested action. Delaying reject of request 0 for 1 seconds Going to the next request Waking up in 0.9 seconds. Sending delayed reject for request 0 Sending Access-Reject of id 95 to 1.2.3.4 port 15191 Waking up in 4.9 seconds. =-=-=-=-=-=-=-=-=-=-=-=-=-=- Radius can't create sql-query Please, help me. May be anybody nows where is examples or howto...
Am Montag, 10. März 2014, 11:41:31 schrieb krylov@ukr.net:
[sql] expand: -> [sql] Error generating query; rejecting user
Your query is empty. the is nothing to be expanded. Please check (or post) your sql part of your setup. You also could post the complete debug output. Greetings, -- Mit freundlichen Grüßen, Michael Schwartzkopff -- [*] sys4 AG http://sys4.de, +49 (89) 30 90 46 64, +49 (162) 165 0044 Franziskanerstraße 15, 81669 München Sitz der Gesellschaft: München, Amtsgericht München: HRB 199263 Vorstand: Patrick Ben Koetter, Marc Schiffbauer Aufsichtsratsvorsitzender: Florian Kirstein
On Mon, Mar 10, 2014 at 4:41 PM, <krylov@ukr.net> wrote:
Good day.
I'd like to install on FreeBSD 9.2 FreeRadius2 with MySQL
# radiusd -X ... rad_recv: Access-Request packet from host 1.2.3.4 port 15191, id=95, length=46 User-Name = "krylov" User-Password = "password" # Executing section authorize from file /usr/local/etc/raddb/sites-enabled/default +group authorize { rlm_sql (sql): Reserving sql socket id: 4 [sql] expand: -> [sql] Error generating query; rejecting user rlm_sql (sql): Released sql socket id: 4 ++[sql] = fail +} # group authorize = fail Using Post-Auth-Type REJECT WARNING: Unknown value specified for Post-Auth-Type. Cannot perform requested action. Delaying reject of request 0 for 1 seconds Going to the next request Waking up in 0.9 seconds. Sending delayed reject for request 0 Sending Access-Reject of id 95 to 1.2.3.4 port 15191 Waking up in 4.9 seconds. =-=-=-=-=-=-=-=-=-=-=-=-=-=- Radius can't create sql-query Please, help me. May be anybody nows where is examples or howto...
How did you install the package? Did you remove the default queries or include files? The defaults is usually good-enough for normal/light usage. Group authorize queries would be (from https://github.com/FreeRADIUS/freeradius-server/blob/v2.x.x/raddb/sql/mysql/... ): group_membership_query = "SELECT groupname \ FROM ${usergroup_table} \ WHERE username = '%{SQL-User-Name}' \ ORDER BY priority" authorize_group_check_query = "SELECT id, groupname, attribute, \ Value, op \ FROM ${groupcheck_table} \ WHERE groupname = '%{Sql-Group}' \ ORDER BY id" authorize_group_reply_query = "SELECT id, groupname, attribute, \ value, op \ FROM ${groupreply_table} \ WHERE groupname = '%{Sql-Group}' \ ORDER BY id" those queries should be printed out on the debug log. Did you delete those lines from dialup.conf? Did you remove the lines from sql.conf that include dialup.conf? -- Fajar
Hi,
I'd like to install on FreeBSD 9.2 FreeRadius2 with MySQL
which bits of http://wiki.freeradius.org/guide/SQL-HOWTO did you follow, which bits didnt work? alan
participants (4)
-
A.L.M.Buxey＠lboro.ac.uk -
Fajar A. Nugraha -
krylov＠ukr.net -
Michael Schwartzkopff