same login pass pair, different behaviour.

[Rakotomandimby Mihamina]

Hi all,
I have these users in my PGSQL table
  username |   pwd
----------+---------
     u_3   | pwd_3
     u_one | pwd_one
     u_two | pwd_two

When testing with radtest:
========================================================
mihamina at rktmb:~$ radtest u_one pwd_one radius20 10 cot357
Sending Access-Request of id 240 to 41.204.103.216 port 1812
	User-Name = "u_one"
	User-Password = "pwd_one"
	NAS-IP-Address = 127.0.1.1
	NAS-Port = 10
rad_recv: Access-Accept packet from host 41.204.103.216 port 1812, id=240, length=26
	Session-Timeout = 320
========================================================

and freeradius -X trace:
========================================================
[...]
auth: type Local
auth: user supplied User-Password matches local User-Password
Login OK: [u_one/pwd_one] (from client quarante_un_deux_cent_quatre port 10)
+- entering group post-auth
rlm_sql (sql): Processing sql_postauth
	expand: %{User-Name} -> u_one
rlm_sql (sql): sql_set_user escaped user --> 'u_one'
	expand: SELECT * FROM f_prepaid_activate('%{SQL-User-Name}') -> SELECT * FROM f_prepaid_activate('u_one')
rlm_sql (sql) in sql_postauth: query is SELECT * FROM f_prepaid_activate('u_one')
rlm_sql (sql): Reserving sql socket id: 3
rlm_sql_postgresql: Status: PGRES_TUPLES_OK
rlm_sql_postgresql: query affected rows = 1 , fields = 1
rlm_sql (sql): Released sql socket id: 3
++[sql] returns ok
++[exec] returns noop
Sending Access-Accept of id 128 to 41.204.104.9 port 60642
	Session-Timeout = 320
Finished request 18.
Going to the next request
Waking up in 4.9 seconds.
=======================================================



When trying through the coova web form, same login/pass: Failure.
Attached is the output of "freeradius -X"

My collegues tell me coova must use CHAP for this project.
What last setup is missing?
Thank you!

-- 
                             Architecte Informatique:
    Administration Systeme, Recherche & Developpement
                                   + 261 32 11 401 65
Pensez a l'environnement avant d'imprimer ce message
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: freeradius-x-2.txt
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20090724/56cffe3b/attachment.txt>