same login pass pair, different behaviour.
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@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
Hi all, I have these users in my PGSQL table username | pwd ----------+--------- u_3 | pwd_3 u_one | pwd_one u_two | pwd_two
That's not freeradius schema.
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?
Where did you find those queries? They will work just with pap (and fail on chap, mschap, ...). Use provided schema and default queries and everything will work. If you want to invent your own, you better know what you are doing. Ivan Kalik Kalik Informatika ISP
07/24/2009 05:00 PM, Ivan Kalik::
username | pwd ----------+--------- u_3 | pwd_3 u_one | pwd_one u_two | pwd_two
That's not freeradius schema.
Yes, I know, that table was not to show my current schema. Our current one is: id | username | attribute | value | op -----+----------+--------------------+---------+---- 111 | u_two | Cleartext-Password | pwd_two | := But I solved the problem, there were a NAS filtering in place, So that if I connect from one NAS, there was the Reject. -- Architecte Informatique: Administration Systeme, Recherche & Developpement + 261 32 11 401 65 Pensez a l'environnement avant d'imprimer ce message
participants (2)
-
Ivan Kalik -
Rakotomandimby Mihamina