You need to set authtype to local. Jeremy
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ciolo_-^DusT^-_WebMaster Sent: Saturday, February 14, 2004 8:04 AM To: [EMAIL PROTECTED] Subject: Re: Access-Reject, how to auth-type -> check password inpostgresql Now MySQL work properly but I have the same problem of this user with MySQL. the output of radiusd -X is identic! ----- Original Message ----- From: "Truong Manh Cuong" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, February 14, 2004 7:50 AM Subject: Access-Reject, how to auth-type -> check password inpostgresql > Hi all, > I don't know why radiusd don't check username/password in postgresql. > Please show me how to config: > check username/password in postgresql > Using clear text password (I don't know this is chap or pap) > > this is log when I run radiusd -X: > ............................................................................ ............ > sql: group_membership_query = "" > sql: connect_failure_retry_delay = 60 > sql: simul_count_query = "" > sql: simul_verify_query = "" > rlm_sql (sql): Driver rlm_sql_postgresql (module rlm_sql_postgresql) > loaded and linked > rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/radiusdb > rlm_sql (sql): starting 0 > rlm_sql (sql): Attempting to connect rlm_sql_postgresql #0 > rlm_sql (sql): Connected new DB handle, #0 > rlm_sql (sql): starting 1 > rlm_sql (sql): Attempting to connect rlm_sql_postgresql #1 > rlm_sql (sql): Connected new DB handle, #1 > rlm_sql (sql): starting 2 > rlm_sql (sql): Attempting to connect rlm_sql_postgresql #2 > rlm_sql (sql): Connected new DB handle, #2 > rlm_sql (sql): starting 3 > rlm_sql (sql): Attempting to connect rlm_sql_postgresql #3 > rlm_sql (sql): Connected new DB handle, #3 > rlm_sql (sql): starting 4 > rlm_sql (sql): Attempting to connect rlm_sql_postgresql #4 > rlm_sql (sql): Connected new DB handle, #4 > Module: Instantiated sql (sql) > Listening on IP address *, ports 1812/udp and 1813/udp, with proxy on > 1814/udp. > Ready to process requests. > rad_recv: Access-Request packet from host 127.0.0.1:32769, id=1, length=59 > User-Name = "tmcuong" > User-Password = "C\376]\221\243l\305\326\356\271\343\236\373<\016$" > NAS-IP-Address = 255.255.255.255 > NAS-Port = 1812 > modcall: entering group authorize for request 0 > modcall[authorize]: module "preprocess" returns ok for request 0 > modcall[authorize]: module "chap" returns noop for request 0 > modcall[authorize]: module "eap" returns noop for request 0 > rlm_realm: No '@' in User-Name = "tmcuong", looking up realm NULL > rlm_realm: No such realm "NULL" > modcall[authorize]: module "suffix" returns noop for request 0 > users: Matched DEFAULT at 152 > modcall[authorize]: module "files" returns ok for request 0 > modcall: group authorize returns ok for request 0 > rad_check_password: Found Auth-Type System > auth: type "System" > auth: Failed to validate the user. > WARNING: Unprintable characters in the password. ? Double-check the > shared secret on the server and the NAS! > Delaying request 0 for 1 seconds > Finished request 0 > Going to the next request > --- Walking the entire request list --- > Waking up in 1 seconds... > --- Walking the entire request list --- > Waking up in 1 seconds... > --- Walking the entire request list --- > Sending Access-Reject of id 1 to 127.0.0.1:32769 > Waking up in 4 seconds... > --- Walking the entire request list --- > Cleaning up request 0 ID 1 with timestamp 402dc041 > Nothing to do. Sleeping until we see a request. > rad_recv: Access-Request packet from host 127.0.0.1:32769, id=31, length=57 > User-Name = "cuser" > User-Password = "C\366M\220\245l\305\326\356\271\343\236\373<\016$" > NAS-IP-Address = 255.255.255.255 > NAS-Port = 1812 > modcall: entering group authorize for request 1 > modcall[authorize]: module "preprocess" returns ok for request 1 > modcall[authorize]: module "chap" returns noop for request 1 > modcall[authorize]: module "eap" returns noop for request 1 > rlm_realm: No '@' in User-Name = "cuser", looking up realm NULL > rlm_realm: No such realm "NULL" > modcall[authorize]: module "suffix" returns noop for request 1 > users: Matched DEFAULT at 152 > modcall[authorize]: module "files" returns ok for request 1 > modcall: group authorize returns ok for request 1 > rad_check_password: Found Auth-Type System > auth: type "System" > auth: Failed to validate the user. > WARNING: Unprintable characters in the password. ? Double-check the > shared secret on the server and the NAS! > Delaying request 1 for 1 seconds > Finished request 1 > Going to the next request > --- Walking the entire request list --- > Waking up in 1 seconds... > --- Walking the entire request list --- > Waking up in 1 seconds... > --- Walking the entire request list --- > Sending Access-Reject of id 31 to 127.0.0.1:32769 > Waking up in 4 seconds... > --- Walking the entire request list --- > Cleaning up request 1 ID 31 with timestamp 402dc1ce > Nothing to do. Sleeping until we see a request. > > > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html