Hello! I got a erroarea following logging and do not know where to look. Can someone ajunte me? rad_recv: Access-Request packet from host 127.0.0.1:42096, id=227, length=116 Service-Type = Framed-User Framed-Protocol = PPP User-Name = "phlander" CHAP-Challenge = 0x153961bc09eaeddf1226af8d60538ee6819b24ede1c1 CHAP-Password = 0xacf1701244e94be1dffe4e11ee08f0caa4 Calling-Station-Id = "00:42:15:11:24:57" NAS-IP-Address = 10.0.0.1 NAS-Port = 0 rad_lowerpair: User-Name now 'phlander' rad_rmspace_pair: User-Name now 'phlander' Processing the authorize section of radiusd.conf modcall: entering group authorize for request 0 rlm_chap: Setting 'Auth-Type := CHAP' modcall[authorize]: module "chap" returns ok for request 0 modcall[authorize]: module "mschap" returns noop for request 0 radius_xlat: '' rlm_sql (sql): Reserving sql socket id: 3 rlm_sql (sql): SQL query error; rejecting user rlm_sql (sql): Released sql socket id: 3 modcall[authorize]: module "sql" returns fail for request 0 modcall: group authorize returns fail for request 0 There was no response configured: rejecting request 0 Server rejecting request 0. Finished request 0 Going to the next request --- Walking the entire request list --- Waking up in 1 seconds... --- Walking the entire request list --- Waking up in 1 seconds... --- Walking the entire request list --- Sending Access-Reject of id 227 to 127.0.0.1:42096 Waking up in 4 seconds... --- Walking the entire request list --- Cleaning up request 0 ID 227 with timestamp 4cb2ee7d Nothing to do. Sleeping until we see a request.
Daniel Sandulescu wrote:
Hello! I got a erroarea following logging and do not know where to look. Can someone ajunte me?
It means you've edited the default configuration, and broken it.
modcall[authorize]: module "mschap" returns noop for request 0 radius_xlat: ''
i.e. the SQL query is empty. It shouldn't be empty. You're also running 1.1.x. I *strongly* suggest upgrading to 2.1.10, which was released last week. Alan DeKok.
I upgraded to version 2.1.10 and now I have this erroare: rad_recv: Access-Request packet from host 127.0.0.1 port 48934, id=235, length=116 Service-Type = Framed-User Framed-Protocol = PPP User-Name = "phlander" CHAP-Challenge = 0x697c26c79cb6f40f57fbbbddb6bc63d8e805ee6a9b75 CHAP-Password = 0x8c0a8927b6df3d0ac0c6f0cc6444b19ed9 Calling-Station-Id = "00:42:15:11:24:57" NAS-IP-Address = 10.0.0.1 NAS-Port = 0 # Executing section authorize from file /usr/local/etc/raddb/radiusd.conf +- entering group authorize {...} [chap] Setting 'Auth-Type := CHAP' ++[chap] returns ok ++[mschap] returns noop rlm_sql (sql): Reserving sql socket id: 1 [sql] expand: -> [sql] Error generating query; rejecting user rlm_sql (sql): Released sql socket id: 1 ++[sql] returns fail Delaying reject of request 3 for 1 seconds Going to the next request Waking up in 0.9 seconds. Sending delayed reject for request 3 Sending Access-Reject of id 235 to 127.0.0.1 port 48934 Waking up in 4.9 seconds. Cleaning up request 3 ID 235 with timestamp +164 Ready to process requests. ----- Original Message ----- From: "Alan DeKok" <aland@deployingradius.com> To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Sent: Monday, October 11, 2010 3:21 PM Subject: Re: SQL query error; rejecting user
Daniel Sandulescu wrote:
Hello! I got a erroarea following logging and do not know where to look. Can someone ajunte me?
It means you've edited the default configuration, and broken it.
modcall[authorize]: module "mschap" returns noop for request 0 radius_xlat: ''
i.e. the SQL query is empty. It shouldn't be empty.
You're also running 1.1.x. I *strongly* suggest upgrading to 2.1.10, which was released last week.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Daniel Sandulescu wrote:
I upgraded to version 2.1.10 and now I have this erroare:
The entire point of the debug output is to *read* it. You have the same problem as last time. And even worse, you "upgraded" to 2.1.10, and left all of the problematic configuration files in place. Instead, use the 2.1.10 configuration files, and then edit them. See "man radiusd" Alan DeKok.
Returning, we came up here and do not know where erroarea .. rad_recv: Access-Request packet from host 127.0.0.1 port 58178, id=244, length=115 Service-Type = Framed-User Framed-Protocol = PPP User-Name = "phlander" CHAP-Challenge = 0x4ff1c005798fc649dd7acb1270f8d142d169b3e1f4 CHAP-Password = 0x14362cd1151241b3faf7b4826269ee9771 Calling-Station-Id = "00:42:15:11:24:57" NAS-IP-Address = 10.0.0.1 NAS-Port = 0 WARNING: Empty authorize section. Using default return values. ERROR: No authenticate method (Auth-Type) found for the request: Rejecting the user Failed to authenticate the user. 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 244 to 127.0.0.1 port 58178 Waking up in 4.9 seconds. Cleaning up request 0 ID 244 with timestamp +13 Ready to process requests. ----- Original Message ----- From: "Alan DeKok" <aland@deployingradius.com> To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Sent: Monday, October 11, 2010 4:44 PM Subject: Re: SQL query error; rejecting user
Daniel Sandulescu wrote:
I upgraded to version 2.1.10 and now I have this erroare:
The entire point of the debug output is to *read* it. You have the same problem as last time.
And even worse, you "upgraded" to 2.1.10, and left all of the problematic configuration files in place.
Instead, use the 2.1.10 configuration files, and then edit them. See "man radiusd"
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Daniel Sandulescu wrote:
Returning, we came up here and do not know where erroarea ..
If you're not going to read the messages on this list, then I don't see why you are posting questions. You have DELETED the entire configuration. Why? Use the configuration from 2.1.10. It's not hard. Delete the existing /etc/raddb directory (or move it somewhere else), and install it again. And then CHECK the configuration directory. If it's empty, don't bother posting to the list. Go fix it yourself. Alan DeKok.
So I did, I deleted everything in / etc / raddb and I configuration, again depending on the requirements there. My question was, if I can see where misuse. Sincerely, Daniel ----- Original Message ----- From: "Alan DeKok" <aland@deployingradius.com> To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Sent: Monday, October 11, 2010 6:23 PM Subject: Re: SQL query error; rejecting user
Daniel Sandulescu wrote:
Returning, we came up here and do not know where erroarea ..
If you're not going to read the messages on this list, then I don't see why you are posting questions.
You have DELETED the entire configuration. Why?
Use the configuration from 2.1.10. It's not hard. Delete the existing /etc/raddb directory (or move it somewhere else), and install it again.
And then CHECK the configuration directory. If it's empty, don't bother posting to the list. Go fix it yourself.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hi,
So I did, I deleted everything in / etc / raddb and I configuration, again depending on the requirements there.
check that the raddb directory is the right onw - I seem to recall that one of your logs showed it was /usr/local/etc/raddb/ the default configuration works for basic tests etc - it certainly doesnt have the blank query error that you posted. alan
Here it is installed : radiusd: #### Loading Virtual Servers #### server { # from file /usr/local/etc/raddb/radiusd.conf And this is the error : rad_recv: Access-Request packet from host 127.0.0.1 port 57115, id=255, length=115 Service-Type = Framed-User Framed-Protocol = PPP User-Name = "phlander" CHAP-Challenge = 0xf73651aeca5a7c950c9aa1bb7c2717b2c069a238e8 CHAP-Password = 0x73ebd7551d76b3caa221e5b64085a07b1d Calling-Station-Id = "00:42:15:11:24:57" NAS-IP-Address = 10.0.0.1 NAS-Port = 0 WARNING: Empty authorize section. Using default return values. ERROR: No authenticate method (Auth-Type) found for the request: Rejecting the user Failed to authenticate the user. 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 255 to 127.0.0.1 port 57115 Waking up in 4.9 seconds. ----- Original Message ----- From: "Alan Buxey" <A.L.M.Buxey@lboro.ac.uk> To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Sent: Tuesday, October 12, 2010 11:20 AM Subject: Re: SQL query error; rejecting user
Hi,
So I did, I deleted everything in / etc / raddb and I configuration, again depending on the requirements there.
check that the raddb directory is the right onw - I seem to recall that one of your logs showed it was /usr/local/etc/raddb/
the default configuration works for basic tests etc - it certainly doesnt have the blank query error that you posted.
alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Daniel Sandulescu wrote:
Here it is installed :
radiusd: #### Loading Virtual Servers #### server { # from file /usr/local/etc/raddb/radiusd.conf
And this is the error :
Which is the same as before. The solution is the same as before: ensure you have the default configuration files in place. Until you do that, *stop* posting the same debug log. We know your system is broken. We're trying to convince you to fix it, and you're not listening. Alan DeKok.
Hi,
radiusd: #### Loading Virtual Servers #### server { # from file /usr/local/etc/raddb/radiusd.conf ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
look. thats where your config is living. delete it all and reinstall
WARNING: Empty authorize section. Using default return values. ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
look. its empty! thats not what a default, working install would give you. you really are not helping us here - the docs say to post the full radiusd -X - and you are just giving us tiny little snippets....which means that we have to play masssive guessing games. I'd guess that you dont have ANY sites-enabled/ stuff at all alan
If I want to upload schema.sql same bug as here: http://www.mail-archive.com/freeradius-users@ lists.freeradius.org/msg61853.html ----- Original Message ----- From: "Alan Buxey" <A.L.M.Buxey@lboro.ac.uk> To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Sent: Tuesday, October 12, 2010 11:20 AM Subject: Re: SQL query error; rejecting user
Hi,
So I did, I deleted everything in / etc / raddb and I configuration, again depending on the requirements there.
check that the raddb directory is the right onw - I seem to recall that one of your logs showed it was /usr/local/etc/raddb/
the default configuration works for basic tests etc - it certainly doesnt have the blank query error that you posted.
alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
That's not a bug, that is someone trying to use the MS SQL schema on a MySQL server. Obviously those files will only work for the database server they were written for. -----Original Message----- From: freeradius-users-bounces+marius=mindspring.co.za@lists.freeradius.org [mailto:freeradius-users-bounces+marius=mindspring.co.za@lists.freeradius.org] On Behalf Of Daniel Sandulescu Sent: Tuesday, October 12, 2010 10:46 AM To: FreeRadius users mailing list Subject: Re: SQL query error; rejecting user If I want to upload schema.sql same bug as here: http://www.mail-archive.com/freeradius-users@ lists.freeradius.org/msg61853.html ----- Original Message ----- From: "Alan Buxey" <A.L.M.Buxey@lboro.ac.uk> To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Sent: Tuesday, October 12, 2010 11:20 AM Subject: Re: SQL query error; rejecting user
Hi,
So I did, I deleted everything in / etc / raddb and I configuration, again depending on the requirements there.
check that the raddb directory is the right onw - I seem to recall that one of your logs showed it was /usr/local/etc/raddb/
the default configuration works for basic tests etc - it certainly doesnt have the blank query error that you posted.
alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
I agree with what you say, but anyone can solve for mysql Ver 14.12 Distrib 5.0.51a ----- Original Message ----- From: "Marius Pesé" <Marius@mindspring.co.za> To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Sent: Tuesday, October 12, 2010 11:50 AM Subject: RE: SQL query error; rejecting user
That's not a bug, that is someone trying to use the MS SQL schema on a MySQL server. Obviously those files will only work for the database server they were written for.
-----Original Message----- From: freeradius-users-bounces+marius=mindspring.co.za@lists.freeradius.org [mailto:freeradius-users-bounces+marius=mindspring.co.za@lists.freeradius.org] On Behalf Of Daniel Sandulescu Sent: Tuesday, October 12, 2010 10:46 AM To: FreeRadius users mailing list Subject: Re: SQL query error; rejecting user
If I want to upload schema.sql same bug as here: http://www.mail-archive.com/freeradius-users@ lists.freeradius.org/msg61853.html
----- Original Message ----- From: "Alan Buxey" <A.L.M.Buxey@lboro.ac.uk> To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Sent: Tuesday, October 12, 2010 11:20 AM Subject: Re: SQL query error; rejecting user
Hi,
So I did, I deleted everything in / etc / raddb and I configuration, again depending on the requirements there.
check that the raddb directory is the right onw - I seem to recall that one of your logs showed it was /usr/local/etc/raddb/
the default configuration works for basic tests etc - it certainly doesnt have the blank query error that you posted.
alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hi,
If I want to upload schema.sql same bug as here: http://www.mail-archive.com/freeradius-users@ lists.freeradius.org/msg61853.html
which DB system are you using? please note my answer in the thread that you've highlighted - that user was trying to throw the MSSQL schema over their MySQL system. t h a t j u s t w o n t w o r k I'm not sure what/why you are playing with things at this point - have you checked the schemas supplied by freeradius in the install tarball (or hopefully distro provided docs/resource tree?). the MySQL schema is pretty much there and will just work out of the box...accounting and all. i havent used it myself for some years as i moved to postgresql (oh yes, you'll be back asking about why packets are being resent and rejected if you blindly throw SQL schemas around and dont have the relevant SQL expertise) alan
participants (4)
-
Alan Buxey -
Alan DeKok -
Daniel Sandulescu -
Marius Pesé