Hello, please help me with SQL integration
For Sinton
forsin at inbox.kg
Thu Feb 27 17:08:46 CET 2014
it's same result
rad_recv: Access-Request packet from host 127.0.0.1 port 22576, id=125, length=75
User-Name = 'fredf'
User-Password = 'wilma'
NAS-IP-Address = 127.0.0.1
NAS-Port = 0
Message-Authenticator = 0x806917d98b3ecc59d419f16524c32881
Thu Feb 27 21:06:30 2014 : Debug: (0) # Executing section authorize from file /usr/local/etc/raddb/sites-enabled/default
Thu Feb 27 21:06:30 2014 : Debug: (0) authorize {
Thu Feb 27 21:06:30 2014 : Debug: (0) modsingle[authorize]: calling preprocess (rlm_preprocess) for request 0
Thu Feb 27 21:06:30 2014 : Debug: (0) modsingle[authorize]: returned from preprocess (rlm_preprocess) for request 0
Thu Feb 27 21:06:30 2014 : Debug: (0) [preprocess] = ok
Thu Feb 27 21:06:30 2014 : Debug: (0) ? if ("%{sql:SELECT COUNT(*) FROM radcheck WHERE username = '%{User-Name}' ORDER BY id" >= 1)
Thu Feb 27 21:06:30 2014 : Debug: %{sql:SELECT COUNT(*) FROM radcheck WHERE username = '%{User-Name}' ORDER BY id
Thu Feb 27 21:06:30 2014 : Debug: Parsed xlat tree:
Thu Feb 27 21:06:30 2014 : Debug: xlat: sql
Thu Feb 27 21:06:30 2014 : Debug: {
Thu Feb 27 21:06:30 2014 : Debug: literal: 'SELECT COUNT(*) FROM radcheck WHERE username = ''
Thu Feb 27 21:06:30 2014 : Debug: attribute: User-Name
Thu Feb 27 21:06:30 2014 : Debug: {
Thu Feb 27 21:06:30 2014 : Debug: ref 2
Thu Feb 27 21:06:30 2014 : Debug: list 1
Thu Feb 27 21:06:30 2014 : Debug: tag -128
Thu Feb 27 21:06:30 2014 : Debug: }
Thu Feb 27 21:06:30 2014 : Debug: literal: '' ORDER BY id'
Thu Feb 27 21:06:30 2014 : Debug: }
Thu Feb 27 21:06:30 2014 : Debug: %{User-Name}
Thu Feb 27 21:06:30 2014 : Debug: Parsed xlat tree:
Thu Feb 27 21:06:30 2014 : Debug: attribute: User-Name
Thu Feb 27 21:06:30 2014 : Debug: {
Thu Feb 27 21:06:30 2014 : Debug: ref 2
Thu Feb 27 21:06:30 2014 : Debug: list 1
Thu Feb 27 21:06:30 2014 : Debug: tag -128
Thu Feb 27 21:06:30 2014 : Debug: }
Thu Feb 27 21:06:30 2014 : Debug: (0) expand: "%{User-Name}" -> 'fredf'
Thu Feb 27 21:06:30 2014 : Debug: (0) SQL-User-Name set to 'fredf'
Thu Feb 27 21:06:30 2014 : Debug: rlm_sql (sql): Reserved connection (4)
Thu Feb 27 21:06:30 2014 : Debug: /var/log/sqllog.sql
Thu Feb 27 21:06:30 2014 : Debug: Parsed xlat tree:
Thu Feb 27 21:06:30 2014 : Debug: literal: '/var/log/sqllog.sql'
Thu Feb 27 21:06:30 2014 : Debug: (0) expand: "/var/log/sqllog.sql" -> '/var/log/sqllog.sql'
Thu Feb 27 21:06:30 2014 : Debug: rlm_sql (sql): Executing query: 'SELECT COUNT(*) FROM radcheck WHERE username = 'fredf' ORDER BY id'
Thu Feb 27 21:06:30 2014 : Debug: (0) SQL query returned no results
----- Исходное сообщение -----
От: "Arran Cudbard-Bell" <a.cudbardb at freeradius.org>
Кому: "FreeRadius users mailing list" <freeradius-users at lists.freeradius.org>
Отправленные: Четверг, 27 Февраль 2014 г 22:07:31
Тема: Re: Hello, please help me with SQL integration
On 27 Feb 2014, at 15:29, For Sinton <forsin at inbox.kg> wrote:
> Good day! I installed freeradius 3.0.x on a server with FreeBSD. Simple Authorization Users through a "files" works without problems. I started to connect SQL, as described in the documentation "HOW-SQL". Users added to the table radcheck, and when prompted radtest user user_pass localhost 0 testing123 - user can not login. Comes the following error
> root at gateway:~ # radtest fredf wilma 127.0.0.1 0 testing123
> Sending Access-Request of id 9 from 0.0.0.0 port 52606 to 127.0.0.1 port 1812
> User-Name = 'fredf'
> User-Password = 'wilma'
> NAS-IP-Address = 127.0.0.1
> NAS-Port = 0
> Message-Authenticator = 0x00
> rad_recv: Access-Reject packet from host 127.0.0.1 port 1812, id=9, length=20
> root at gateway:~ #
>
>
> debug message
> rad_recv: Access-Request packet from host 127.0.0.1 port 52606, id=9, length=75
> User-Name = 'fredf'
> User-Password = 'wilma'
> NAS-IP-Address = 127.0.0.1
> NAS-Port = 0
> Message-Authenticator = 0x921e720cf0599ea4cae31cf81ee1da87
> Thu Feb 27 20:06:01 2014 : Debug: (0) # Executing section authorize from file /usr/local/etc/raddb/sites-enabled/default
> Thu Feb 27 20:06:01 2014 : Debug: (0) authorize {
> Thu Feb 27 20:06:01 2014 : Debug: (0) modsingle[authorize]: calling preprocess (rlm_preprocess) for request 0
> Thu Feb 27 20:06:01 2014 : Debug: (0) modsingle[authorize]: returned from preprocess (rlm_preprocess) for request 0
> Thu Feb 27 20:06:01 2014 : Debug: (0) [preprocess] = ok
> Thu Feb 27 20:06:01 2014 : Debug: (0) ? if ("%{sql:SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{User-Name}' ORDER BY id" >= 1)
> Thu Feb 27 20:06:01 2014 : Debug: %{sql:SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{User-Name}' ORDER BY id
> Thu Feb 27 20:06:01 2014 : Debug: Parsed xlat tree:
> Thu Feb 27 20:06:01 2014 : Debug: xlat: sql
> Thu Feb 27 20:06:01 2014 : Debug: {
> Thu Feb 27 20:06:01 2014 : Debug: literal: 'SELECT id, username, attribute, value, op FROM radcheck WHERE username = ''
> Thu Feb 27 20:06:01 2014 : Debug: attribute: User-Name
> Thu Feb 27 20:06:01 2014 : Debug: {
> Thu Feb 27 20:06:01 2014 : Debug: ref 2
> Thu Feb 27 20:06:01 2014 : Debug: list 1
> Thu Feb 27 20:06:01 2014 : Debug: tag -128
> Thu Feb 27 20:06:01 2014 : Debug: }
> Thu Feb 27 20:06:01 2014 : Debug: literal: '' ORDER BY id'
> Thu Feb 27 20:06:01 2014 : Debug: }
> Thu Feb 27 20:06:01 2014 : Debug: %{User-Name}
> Thu Feb 27 20:06:01 2014 : Debug: Parsed xlat tree:
> Thu Feb 27 20:06:01 2014 : Debug: attribute: User-Name
> Thu Feb 27 20:06:01 2014 : Debug: {
> Thu Feb 27 20:06:01 2014 : Debug: ref 2
> Thu Feb 27 20:06:01 2014 : Debug: list 1
> Thu Feb 27 20:06:01 2014 : Debug: tag -128
> Thu Feb 27 20:06:01 2014 : Debug: }
> Thu Feb 27 20:06:01 2014 : Debug: (0) expand: "%{User-Name}" -> 'fredf'
> Thu Feb 27 20:06:01 2014 : Debug: (0) SQL-User-Name set to 'fredf'
> Thu Feb 27 20:06:01 2014 : Debug: rlm_sql (sql): Reserved connection (4)
> Thu Feb 27 20:06:01 2014 : Debug: /var/log/sqllog.sql
> Thu Feb 27 20:06:01 2014 : Debug: Parsed xlat tree:
> Thu Feb 27 20:06:01 2014 : Debug: literal: '/var/log/sqllog.sql'
> Thu Feb 27 20:06:01 2014 : Debug: (0) expand: "/var/log/sqllog.sql" -> '/var/log/sqllog.sql'
> Thu Feb 27 20:06:01 2014 : Debug: rlm_sql (sql): Executing query: 'SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'fredf' ORDER BY id'
> Thu Feb 27 20:06:01 2014 : Debug: (0) SQL query returned no results ------> why ? If you do this query inside mysql - i got result :(
Try SELECT COUNT(*) seeing as you're doing an integer comparison.
Arran Cudbard-Bell <a.cudbardb at freeradius.org>
FreeRADIUS Development Team
FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
More information about the Freeradius-Users
mailing list