Error getting data from database
Hi, i have installed freeradius 1.0.4 on linux 7.3 with postgresql.... i m getting following error !! what could be the reason ? ================================================================================ rad_recv: Access-Request packet from host 127.0.0.1:24001, id=138, length=114 Service-Type = Framed-User Framed-Protocol = PPP User-Name = "nirmal" CHAP-Challenge = 0x495c6bb35556d77a941033c89ed87af63e097e202bc7 CHAP-Password = 0x01f5435e9f2d79af0f9b5b3b31486d3392 Calling-Station-Id = "00:80:AD:83:1D:90" NAS-IP-Address = 192.168.0.61 NAS-Port = 4 Processing the authorize section of radiusd.conf modcall: entering group authorize for request 0 modcall[authorize]: module "preprocess" returns ok 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: 'nirmal' rlm_sql (sql): sql_set_user escaped user --> 'nirmal' radius_xlat: 'SELECT Id, UserName, Attribute, Value, Op ??FROM radcheck ??WHERE Username = 'nirmal' ??ORDER BY Id' rlm_sql (sql): Reserving sql socket id: 4 rlm_sql_postgresql: query: SELECT Id, UserName, Attribute, Value, Op ??FROM radcheck ??WHERE Username = 'nirmal' ??ORDER BY Id rlm_sql_postgresql: Status: PGRES_TUPLES_OK rlm_sql_postgresql: affected rows = rlm_sql: Failed to create the pair: Unknown attribute "User-Password " rlm_sql (sql): Error getting data from database rlm_sql (sql): SQL query error; rejecting user rlm_sql (sql): Released sql socket id: 4 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 --- Sending Access-Reject of id 138 to 127.0.0.1:24001 Waking up in 4 seconds... --- Walking the entire request list --- Cleaning up request 0 ID 138 with timestamp 42e08a78 Nothing to do. Sleeping until we see a request. ================================================================================ Please help me out. Thanks in advance Nirmal __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
On Thu, Jul 21, 2005 at 11:34:17PM -0700, Nirmal wrote:
Hi,
i have installed freeradius 1.0.4 on linux 7.3 with postgresql.... i m getting following error !!
what could be the reason ?
rlm_sql: Failed to create the pair: Unknown attribute "User-Password "
Perhaps that space at the end of the attribute string? Oliver.
Thanks for your help which file i should look into in order to remove this space ? Nirmal Oliver Graf <ograf@rz-online.net> wrote: On Thu, Jul 21, 2005 at 11:34:17PM -0700, Nirmal wrote:
Hi,
i have installed freeradius 1.0.4 on linux 7.3 with postgresql.... i m getting following error !!
what could be the reason ?
rlm_sql: Failed to create the pair: Unknown attribute "User-Password "
Perhaps that space at the end of the attribute string? Oliver. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html --------------------------------- Start your day with Yahoo! - make it your home page
Thanks oliver, there was problem in my database.. i am able to connect my user in new radius now. thanks :) Nirmal Oliver Graf <ograf@rz-online.net> wrote: On Fri, Jul 22, 2005 at 04:32:56AM -0700, Nirmal wrote:
Thanks for your help
which file i should look into in order to remove this space ?
It's in your SQL database. Oliver. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Nirmal wrote:
i have installed freeradius 1.0.4 on linux 7.3 with postgresql.... i m getting following error !!
[...]
rlm_sql: Failed to create the pair: Unknown attribute "User-Password " ^^ I guess FreeRADIUS complains about the extraneous space you have mistakenly added when provisioning the database.
-- Nicolas Baradakis
participants (3)
-
Nicolas Baradakis -
Nirmal -
Oliver Graf