RE: SQL Authentication Failure

2002-11-29 Thread Valakos Yorgos 
Try INSERT INTO radcheck ('Id','Username','Attribute','op','Value')
('','vreddy','Password','==','test');
That did the work for me at least .
And I m a newcomer.in the gang ... :)


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

Re: SQL Authentication Failure

2002-11-29 Thread Alan DeKok 
Vijay Reddy <[EMAIL PROTECTED]> wrote:
>I Installed  FreeRadius and MySQL on Linux ,I inserted the record in the
> radcheck using query into the server
>  
> Insert into radcheck(UserName,Attribute,Value) values
> ("vreddy","vreddy","test");

  That won't work.

> rlm_sql_mysql: query:  SELECT id,UserName,Attribute,Value,op FROM radcheck
> WHERE Username = 'vreddy' ORDER BY id
> rlm_sql: unknown attribute 

  Upgrade to 0.8.  It has a bit better error messages, and will tell
you what you're doing wrong.

  Alan DeKok.

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

RE: SQL Authentication Failure

2002-11-29 Thread Vijay Reddy 



Hi,
Sorry 
If i am disturbing a lot,
Now 
following error is occured,after modifying the radiusd.conf with authenticate 
module(only PAP is enabled)
 
  
rlm_sql (sql): Pairs do not match for user [vreddy]rlm_sql (sql): Released 
sql socket id: 2  modcall[authorize]: module "sql" returns 
notfound    users: Matched DEFAULT at 152  
modcall[authorize]: module "files" returns okmodcall: group authorize 
returns ok  rad_check_password:  Found Auth-Type PAPauth: type 
"PAP"modcall: entering group authtyperlm_pap: empty password 
supplied  modcall[authenticate]: module "pap" returns 
invalidmodcall: group authtype returns invalidauth: Failed to validate 
the user.
 
what 
should be the record in the radcheck table,
so 
that 
radtest vreddy Password localhost 0  
testing123client program need to work
 
Thanks 
in Advance
 
regards
Vijay 
reddy
 
 

  -Original Message-From: Novel S Sidabutar 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, November 29, 2002 11:49 
  AMTo: [EMAIL PROTECTED]Subject: Re: SQL 
  Authentication Failure
  You can try configure again your 
  rlm_sql free radius source on 
  /free~/src/modules/rlm_sql/ and do configure 
  again,
  $./configure
  $./make
  $./make install
   
  
Hi,
 
   I 
Installed  FreeRadius and MySQL on Linux ,I inserted the record in the 
radcheck using query into the server
 
Insert into 
radcheck(UserName,Attribute,Value) values 
("vreddy","vreddy","test");
 
Now we started 
the Radius Server as radiusd -X,and when we started the test client with 
options as below
 
radtest vreddy 
test localhost 0 testing123
 
client is 
sending & resending the Access-Request packets,but server is not 
responding,the following error is occured at Server Side
 
rad_recv: 
Access-Request packet from host 127.0.0.1:33380, id=72, 
length=58    User-Name = 
"vreddy"    User-Password = 
"vreddy"    NAS-IP-Address = 
255.255.255.255    NAS-Port = 
0modcall: entering group authorize  modcall[authorize]: module 
"preprocess" returns okrlm_chap: Could not find proper Chap-Password 
attribute in request  modcall[authorize]: module "chap" returns 
noop  modcall[authorize]: module "mschap" returns 
notfound    rlm_realm: No '@' in User-Name = "vreddy", 
looking up realm NULL    rlm_realm: No such realm 
NULL  modcall[authorize]: module "suffix" returns 
noopradius_xlat:  'vreddy'rlm_sql (sql): sql_set_user escaped 
user --> 'vreddy'radius_xlat:  'SELECT 
id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'vreddy' ORDER 
BY id'rlm_sql (sql): Reserving sql socket id: 4rlm_sql_mysql: 
query:  SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE 
Username = 'vreddy' ORDER BY idrlm_sql: unknown attribute rlm_sql 
(sql): Error getting data from databaserlm_sql (sql): SQL query error; 
rejecting userrlm_sql (sql): Released sql socket id: 4  
modcall[authorize]: module "sql" returns failmodcall: group authorize 
returns failFinished request 0Going to the next 
request
 
 
 
regards
Vijay 
Reddy
 
 

RE: SQL Authentication Failure

2002-11-28 Thread Chhai Thach 









See
below

 

-Original
Message-
From: Vijay Reddy
[mailto:[EMAIL PROTECTED]] 
Sent: Friday, 29
 November 2002
4:25
 PM
To: [EMAIL PROTECTED]
Subject: SQL Authentication
Failure

 



Hi,





 





   I Installed 
FreeRadius and MySQL on Linux ,I inserted the record in the radcheck using
query into the server





 





Insert into
radcheck(UserName,Attribute,Value) values
("vreddy","vreddy","test");





 





Now we started the Radius Server as
radiusd -X,and when we started the test client with options as below





 





radtest vreddy test localhost 0
testing123





 





client is sending & resending
the Access-Request packets,but server is not responding,the following error is
occured at Server Side





 





rad_recv: Access-Request packet from
host 127.0.0.1:33380, id=72, length=58
    User-Name = "vreddy"
    User-Password = "vreddy"
    NAS-IP-Address = 255.255.255.255
    NAS-Port = 0
modcall: entering group authorize
  modcall[authorize]: module
"preprocess" returns ok
rlm_chap: Could not find proper Chap-Password attribute in request

 

I think the client dial up tries to use
CHAP but you only have User-Password stored in your database. 

If you change the dial up client to PAP it
should works. 

 


  modcall[authorize]: module "chap"
returns noop
  modcall[authorize]: module "mschap"
returns notfound
    rlm_realm: No '@' in User-Name = "vreddy", looking
up realm NULL
    rlm_realm: No such realm NULL
  modcall[authorize]: module "suffix"
returns noop
radius_xlat:  'vreddy'
rlm_sql (sql): sql_set_user escaped user --> 'vreddy'
radius_xlat:  'SELECT id,UserName,Attribute,Value,op
FROM radcheck WHERE Username = 'vreddy' ORDER BY id'
rlm_sql (sql): Reserving sql socket id: 4
rlm_sql_mysql: query:  SELECT id,UserName,Attribute,Value,op
FROM radcheck WHERE Username = 'vreddy' ORDER BY id
rlm_sql: unknown attribute 
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
modcall: group authorize returns fail
Finished request 0
Going to the next request





 





 





 





regards





Vijay Reddy





 





 

Re: SQL Authentication Failure

2002-11-28 Thread Novel S Sidabutar 



You can try configure again your rlm_sql free 
radius source on 
/free~/src/modules/rlm_sql/ and do configure 
again,
$./configure
$./make
$./make install
 

  Hi,
   
     I 
  Installed  FreeRadius and MySQL on Linux ,I inserted the record in the 
  radcheck using query into the server
   
  Insert into 
  radcheck(UserName,Attribute,Value) values 
  ("vreddy","vreddy","test");
   
  Now we started the 
  Radius Server as radiusd -X,and when we started the test client with options 
  as below
   
  radtest vreddy 
  test localhost 0 testing123
   
  client is sending 
  & resending the Access-Request packets,but server is not responding,the 
  following error is occured at Server Side
   
  rad_recv: 
  Access-Request packet from host 127.0.0.1:33380, id=72, 
  length=58    User-Name = 
  "vreddy"    User-Password = 
  "vreddy"    NAS-IP-Address = 
  255.255.255.255    NAS-Port = 
  0modcall: entering group authorize  modcall[authorize]: module 
  "preprocess" returns okrlm_chap: Could not find proper Chap-Password 
  attribute in request  modcall[authorize]: module "chap" returns 
  noop  modcall[authorize]: module "mschap" returns 
  notfound    rlm_realm: No '@' in User-Name = "vreddy", 
  looking up realm NULL    rlm_realm: No such realm 
  NULL  modcall[authorize]: module "suffix" returns 
  noopradius_xlat:  'vreddy'rlm_sql (sql): sql_set_user escaped 
  user --> 'vreddy'radius_xlat:  'SELECT 
  id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'vreddy' ORDER 
  BY id'rlm_sql (sql): Reserving sql socket id: 4rlm_sql_mysql: 
  query:  SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE 
  Username = 'vreddy' ORDER BY idrlm_sql: unknown attribute rlm_sql 
  (sql): Error getting data from databaserlm_sql (sql): SQL query error; 
  rejecting userrlm_sql (sql): Released sql socket id: 4  
  modcall[authorize]: module "sql" returns failmodcall: group authorize 
  returns failFinished request 0Going to the next 
  request
   
   
   
  regards
  Vijay 
  Reddy
   
   

SQL Authentication Failure

2002-11-28 Thread Vijay Reddy 



Hi,
 
   I 
Installed  FreeRadius and MySQL on Linux ,I inserted the record in the 
radcheck using query into the server
 
Insert into 
radcheck(UserName,Attribute,Value) values 
("vreddy","vreddy","test");
 
Now we started the 
Radius Server as radiusd -X,and when we started the test client with options as 
below
 
radtest vreddy test 
localhost 0 testing123
 
client is sending 
& resending the Access-Request packets,but server is not responding,the 
following error is occured at Server Side
 
rad_recv: 
Access-Request packet from host 127.0.0.1:33380, id=72, 
length=58    User-Name = 
"vreddy"    User-Password = 
"vreddy"    NAS-IP-Address = 
255.255.255.255    NAS-Port = 
0modcall: entering group authorize  modcall[authorize]: module 
"preprocess" returns okrlm_chap: Could not find proper Chap-Password 
attribute in request  modcall[authorize]: module "chap" returns 
noop  modcall[authorize]: module "mschap" returns 
notfound    rlm_realm: No '@' in User-Name = "vreddy", 
looking up realm NULL    rlm_realm: No such realm 
NULL  modcall[authorize]: module "suffix" returns 
noopradius_xlat:  'vreddy'rlm_sql (sql): sql_set_user escaped user 
--> 'vreddy'radius_xlat:  'SELECT id,UserName,Attribute,Value,op 
FROM radcheck WHERE Username = 'vreddy' ORDER BY id'rlm_sql (sql): Reserving 
sql socket id: 4rlm_sql_mysql: query:  SELECT 
id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'vreddy' ORDER BY 
idrlm_sql: unknown attribute rlm_sql (sql): Error getting data from 
databaserlm_sql (sql): SQL query error; rejecting userrlm_sql (sql): 
Released sql socket id: 4  modcall[authorize]: module "sql" returns 
failmodcall: group authorize returns failFinished request 0Going to 
the next request
 
 
 
regards
Vijay 
Reddy