errors

Tue Jun 26 00:45:43 CEST 2018

Hello,

One more question, is it a problem if I use the data base from my 2.x
radius? I guess the structure is the same, right?

Thanks in advance

Best

On Tue, Jun 26, 2018 at 12:42 AM, Pedro Loupa <pedroloupa32 at gmail.com>
wrote:

> Hello Alan,
>
> I followed the tutorial, I configured everything as per it, and I get the
> following errors when I use radtest:
>
> Ready to process requests
> (0) Received Access-Request Id 24 from 127.0.0.1:50116 to 127.0.0.1:1812
> length 75
> (0)   User-Name = "fredf"
> (0)   User-Password = "wilma"
> (0)   NAS-IP-Address = 5.135.246.126
> (0)   NAS-Port = 0
> (0)   Message-Authenticator = 0x9f158964d9d6b8ef09a954ab469767e3
> (0) # Executing section authorize from file /etc/freeradius/3.0/sites-
> enabled/default
> (0)   authorize {
> (0)     [preprocess] = ok
> (0)     [chap] = noop
> (0)     [mschap] = noop
> (0) suffix: Checking for suffix after "@"
> (0) suffix: No '@' in User-Name = "fredf", looking up realm NULL
> (0) suffix: No such realm "NULL"
> (0)     [suffix] = noop
> (0) eap: No EAP-Message, not doing EAP
> (0)     [eap] = noop
> (0)     [files] = noop
> (0) sql: EXPAND %{User-Name}
> (0) sql:    --> fredf
> (0) sql: SQL-User-Name set to 'fredf'
> rlm_sql (sql): Reserved connection (0)
> (0) sql: EXPAND SELECT id, username, attribute, value, op FROM radcheck
> WHERE username = '%{SQL-User-Name}' ORDER BY id
> (0) sql:    --> SELECT id, username, attribute, value, op FROM radcheck
> WHERE username = 'fredf' ORDER BY id
> (0) sql: Executing select query: SELECT id, username, attribute, value, op
> FROM radcheck WHERE username = 'fredf' ORDER BY id
> (0) sql: EXPAND SELECT groupname FROM radusergroup WHERE username =
> '%{SQL-User-Name}' ORDER BY priority
> (0) sql:    --> SELECT groupname FROM radusergroup WHERE username =
> 'fredf' ORDER BY priority
> (0) sql: Executing select query: SELECT groupname FROM radusergroup WHERE
> username = 'fredf' ORDER BY priority
> (0) sql: User not found in any groups
> rlm_sql (sql): Released connection (0)
> Need 5 more connections to reach 10 spares
> rlm_sql (sql): Opening additional connection (5), 1 of 27 pending slots
> used
> (0)     [sql] = notfound
> (0)     [expiration] = noop
> (0)     [logintime] = noop
> (
>
>
>
> *0) pap: WARNING: No "known good" password found for the user.  Not
> setting Auth-Type(0) pap: WARNING: Authentication will fail unless a "known
> good" password is available(0)     [pap] = noop(0)   } # authorize = ok(0)
> ERROR: No Auth-Type found: rejecting the user via Post-Auth-Type = Reject*
> (0) Failed to authenticate the user
> (0) Using Post-Auth-Type Reject
> (0) # Executing group from file /etc/freeradius/3.0/sites-enabled/default
> (0)   Post-Auth-Type REJECT {
> (0) sql: EXPAND .query
> (0) sql:    --> .query
> (0) sql: Using query template 'query'
> rlm_sql (sql): Reserved connection (1)
> (0) sql: EXPAND %{User-Name}
> (0) sql:    --> fredf
> (0) sql: SQL-User-Name set to 'fredf'
> (0) sql: EXPAND INSERT INTO radpostauth (username, pass, reply, authdate)
> VALUES ( '%{SQL-User-Name}', '%{%{User-Password}:-%{Chap-Password}}',
> '                       %{reply:Packet-Type}', '%S')
> (0) sql:    --> INSERT INTO radpostauth (username, pass, reply, authdate)
> VALUES ( 'fredf', 'wilma', 'Access-Reject', '2018-06-26 00:39:13')
> (0) sql: EXPAND /var/log/freeradius/sqllog.sql
> (0) sql:    --> /var/log/freeradius/sqllog.sql
> (0) sql: Executing query: INSERT INTO radpostauth (username, pass, reply,
> authdate) VALUES ( 'fredf', 'wilma', 'Access-Reject', '2018-06-26
> 00:39                       :13')
> (0) sql: SQL query returned: success
> (0) sql: 1 record(s) updated
> rlm_sql (sql): Released connection (1)
> (0)     [sql] = ok
> (0) attr_filter.access_reject: EXPAND %{User-Name}
> (0) attr_filter.access_reject:    --> fredf
> (0) attr_filter.access_reject: Matched entry DEFAULT at line 11
> (0)     [attr_filter.access_reject] = updated
> (0)     [eap] = noop
> (0)     policy remove_reply_message_if_eap {
> (0)       if (&reply:EAP-Message && &reply:Reply-Message) {
> (0)       if (&reply:EAP-Message && &reply:Reply-Message)  -> FALSE
> (0)       else {
> (0)         [noop] = noop
> (0)       } # else = noop
> (0)     } # policy remove_reply_message_if_eap = noop
> (0)   } # Post-Auth-Type REJECT = updated
> (0) Delaying response for 1.000000 seconds
> Waking up in 0.3 seconds.
> Waking up in 0.6 seconds.
> (0) Sending delayed response
> (0) Sent Access-Reject Id 24 from 127.0.0.1:1812 to 127.0.0.1:50116
> length 20
> Waking up in 3.9 seconds.
> (0) Cleaning up request packet ID 24 with timestamp +17
> Ready to process requests
>
> Any clue how to fix it?
>
> Thanks!
>
> Best
>
> On Mon, Jun 25, 2018 at 11:57 PM, Alan Buxey <alan.buxey at gmail.com> wrote:
>
>> looks like debian/ubuntu - for v3 try:
>>
>> https://wiki.freeradius.org/guide/SQL-HOWTO-for-freeradius-
>> 3.x-on-Debian-Ubuntu
>>
>>
>> On 25 June 2018 at 21:40, Pedro Loupa <pedroloupa32 at gmail.com> wrote:
>>
>> > Hello,
>> >
>> > Following this wiki:
>> > https://wiki.freeradius.org/guide/SQL%20HOWTO#before-you-start
>> >
>> > I see that sql.conf does not exist, I edited*
>> > /etc/freeradius/3.0/mods-available/sql. Is that correct?*
>> >
>> >
>> > The line database = "mysql" does not exist either, could somebody tell
>> me
>> > where is it?
>> >
>> > Thank you very much in advance
>> >
>> > Regards
>> > -
>> > List info/subscribe/unsubscribe? See http://www.freeradius.org/
>> > list/users.html
>> -
>> List info/subscribe/unsubscribe? See http://www.freeradius.org/list
>> /users.html
>
>
>