errors

[Pedro Loupa]

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