> > Hey Tuc, > > Regarding your issue, check the radiusd.conf file, in the modules{} section > for > the pap module settings, you probably have it set to encryption_scheme = > crypt, if so, change it to clear. > No, its the standard :
pap { auto_header = no } I had followed (I thought) : http://wiki.freeradius.org/SQL_HOWTO just like I did (I think) for MySQL and had that working straight off. > > [Discussion of his sourceforge project that comes with just about > every reply he does deleted] > So not sure whats happening or not happening.. Tuc > Liran. > > > On Tue, May 13, 2008 at 3:20 AM, Tuc at T-B-O-H.NET <[EMAIL PROTECTED]> wrote: > > > Hi, > > > > I've got a new install, and I have it working fine with plain text > > files. I'm trying to go this time to Postgresql (Don't ask....) and I'm > > just not having a good time of it. I don't get why its doing the following > > (2.0.4 with Postgresql 8.1.11) : > > > > Ready to process requests. > > User-Name = "tuc" > > User-Password = "ICANSEE" > > NAS-IP-Address = 192.168.3.128 > > NAS-Port = 1812 > > +- entering group authorize > > ++[preprocess] returns ok > > ++[chap] returns noop > > ++[mschap] returns noop > > rlm_realm: No '@' in User-Name = "tuc", looking up realm NULL > > rlm_realm: No such realm "NULL" > > ++[suffix] returns noop > > rlm_eap: No EAP-Message, not doing EAP > > ++[eap] returns noop > > ++[unix] returns updated > > ++[files] returns noop > > expand: %{User-Name} -> tuc > > rlm_sql (sql): sql_set_user escaped user --> 'tuc' > > rlm_sql (sql): Reserving sql socket id: 4 > > expand: SELECT id, UserName, Attribute, Value, Op FROM radcheck > > WHERE Username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, UserName, > > Attribute, Value, Op FROM radcheck WHERE Username = 'tuc' ORDER BY id > > rlm_sql_postgresql: query: SELECT id, UserName, Attribute, Value, Op > > FROM radcheck WHERE Username = 'tuc' ORDER BY id > > rlm_sql_postgresql: Status: PGRES_TUPLES_OK > > rlm_sql_postgresql: query affected rows = 1 , fields = 5 > > rlm_sql (sql): User found in radcheck table > > expand: SELECT id, UserName, Attribute, Value, Op FROM radreply > > WHERE Username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, UserName, > > Attribute, Value, Op FROM radreply WHERE Username = 'tuc' ORDER BY id > > rlm_sql_postgresql: query: SELECT id, UserName, Attribute, Value, Op > > FROM radreply WHERE Username = 'tuc' ORDER BY id > > rlm_sql_postgresql: Status: PGRES_TUPLES_OK > > rlm_sql_postgresql: query affected rows = 1 , fields = 5 > > expand: SELECT GroupName FROM radusergroup WHERE > > UserName='%{SQL-User-Name}' ORDER BY priority -> SELECT GroupName FROM > > radusergroup WHERE UserName='tuc' ORDER BY priority > > rlm_sql_postgresql: query: SELECT GroupName FROM radusergroup WHERE > > UserName='tuc' ORDER BY priority > > rlm_sql_postgresql: Status: PGRES_TUPLES_OK > > rlm_sql_postgresql: query affected rows = 0 , fields = 1 > > rlm_sql (sql): Released sql socket id: 4 > > ++[sql] returns ok > > ++[expiration] returns noop > > ++[logintime] returns noop > > ++[pap] returns updated > > rad_check_password: Found Auth-Type > > auth: type "PAP" > > +- entering group PAP > > rlm_pap: login attempt with password "ICANSEE" > > rlm_pap: Using CRYPT encryption. > > rlm_pap: Passwords don't match > > ++[pap] returns reject > > auth: Failed to validate the user. > > Login incorrect (rlm_pap: CRYPT password check failed): [tuc/ICANSEE] > > (from client localhost port 1812) > > Found Post-Auth-Type Reject > > +- entering group REJECT > > expand: %{User-Name} -> tuc > > attr_filter: Matched entry DEFAULT at line 11 > > ++[attr_filter.access_reject] returns updated > > Delaying reject of request 0 for 1 seconds > > > > > > > > Why does it head to crypt? I have in radcheck : > > > > Welcome to psql 8.1.11, the PostgreSQL interactive terminal. > > > > Type: \copyright for distribution terms > > \h for help with SQL commands > > \? for help with psql commands > > \g or terminate with semicolon to execute query > > \q to quit > > > > radius=> select * from radcheck; > > id | username | attribute | op | value > > ----+----------+--------------------+----+--------- > > 2 | tuc | Cleartext-Password | := | ICANSEE > > (1 row) > > > > radius=> > > > > Thanks, Tuc - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html