Tough time getting FreeRADIUS 3.0.9 to work with mysql

[Alan DeKok]

On Jul 12, 2015, at 7:27 PM, Kwesi Yankson via Freeradius-Users <freeradius-***@lists.freeradius.org> wrote:
> Hello,I am a freeRADIUS 2.x user and want to start using freeRADIUS 3.x.xI have installed freeRADIUS 3.0.9 and done a lot of reading since I want to avoid being told to "RTFM"I can't seem to get an Access-Accept when I do a radtest for MySQL users. I'm sure I'm missing something (still adjusting to the difference between the two version). Can someone help or point me in the right direction? Below is my debug:.
...
> (1) sql: EXPAND SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id
> (1) sql: --> SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'me' ORDER BY id
> (1) sql: Executing select query: SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'me' ORDER BY id
> rlm_sql (sql): Released connection (7)
> rlm_sql (sql): 0 of 1 connections in use. Need more spares
> rlm_sql (sql): Opening additional connection (8), 1 of 31 pending slots used
> (1) [sql] = not found

So... that SELECT statement returns nothing. What happens when you run the SELECT statement by hand? What does it return?

That's why the SELECT is printed in debug mode... so you can see for yourself what's going on.

Odds are that it doesn't work because there's no row in radchekc with "username = me". That should be simple enough to fix.

Alan DeKok.


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/u

[Alan DeKok]

On Jul 13, 2015, at 5:54 PM, Kwesi Yankson via Freeradius-Users <freeradius-***@lists.freeradius.org> wrote:

> Thank you Alan.When I run the query in mysql this is what I get:mysql> SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'me' ORDER BY id;
> +----+----------+--------------------+-------+----+
> | id | username | attribute | value | op |
> +----+----------+--------------------+-------+----+
> | 9 | me | Cleartext-Password | pass | := |
> +----+----------+--------------------+-------+----+

Well, then the server should work. There's really no magic in it.

Alan DeKok.



-
List info/subscribe/unsubscribe? See http://www.

[Krauss International]

can someone black him

Thanks & regards
Mankomal Singh
Krauss International
P: [phone]
E: ***@kc-india.com
PS: Send all bulk emails to ***@gmail.com ONLY



On Mon, Nov 19, 2018 at 6:00 PM Christian Salway via Freeradius-Users <
freeradius-***@lists.freeradius.org> wrote:

> Why dont you unsubscribe??
>
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html <
> http://www.freeradius.org/list/users.html>
>
>
> > On 19 Nov 2018, at 12:16, Song Zou via Freeradius-Users <
> freeradius-***@lists.freeradius.org> wrote:
> >
> > please don’t send email
> >
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://w

[Zubair Ayub]

I don't want to unsubscribe this group i found this useful.
But song zou keep sending spam email again n again written "please don't reply"

Regards
ZUBAIR AYUB
Thanks

________________________________
From: Freeradius-Users <freeradius-users-bounces+zubairayub=***@lists.freeradius.org> on behalf of Christian Salway via Freeradius-Users <freeradius-***@lists.freeradius.org>
Sent: Monday, November 19, 2018 5:19:34 PM
To: FreeRadius users mailing list
Cc: Christian Salway
Subject: Re: Tough time getting FreeRADIUS 3.0.9 to work with mysql

Why dont you unsubscribe??

List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html <http://www.freeradius.org/list/users.html>


> On 19 Nov 2018, at 12:16, Song Zou via Freeradius-Users <freeradius-***@lists.freeradius.org> wrote:
>
> please don’t send email
>

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http