Error getting data from database

[Nirmal]

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 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20050721/cdf061a9/attachment.html>