<div>Hey Tuc,</div>
<div> </div>
<div>Regarding your issue, check the radiusd.conf file, in the modules{} section for</div>
<div>the pap module settings, you probably have it set to encryption_scheme = crypt, if so, change it to clear.</div>
<div> </div>
<div>Also, daloRADIUS was built to be an SQL-based platform for managing everything</div>
<div>though it is roughly tested and built on MySQL. I have attempted to keep most</div>
<div>of the queries very ANSI SQL specific to conform with other servers like PostgreSQL.</div>
<div>And so, if you would like to give it a chance with Postgres still then I am willing to</div>
<div>be entirely available to you and assist you in getting things up and running as well as</div>
<div>adding support to any changes to fit PostgreSQL.</div>
<div> </div>
<div>Let me know if you decided to go for it.</div>
<div> </div>
<div> </div>
<div>Liran.</div>
<div><br> </div>
<div class="gmail_quote">On Tue, May 13, 2008 at 3:20 AM, Tuc at <a href="http://T-B-O-H.NET">T-B-O-H.NET</a> <<a href="mailto:ml@t-b-o-h.net">ml@t-b-o-h.net</a>> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Hi,<br><br> I've got a new install, and I have it working fine with plain text<br>files. I'm trying to go this time to Postgresql (Don't ask....) and I'm<br>
just not having a good time of it. I don't get why its doing the following<br>(2.0.4 with Postgresql 8.1.11) :<br><br>Ready to process requests.<br> User-Name = "tuc"<br> User-Password = "ICANSEE"<br>
NAS-IP-Address = <a href="http://192.168.3.128/" target="_blank">192.168.3.128</a><br> NAS-Port = 1812<br>+- entering group authorize<br>++[preprocess] returns ok<br>++[chap] returns noop<br>++[mschap] returns noop<br>
rlm_realm: No '@' in User-Name = "tuc", looking up realm NULL<br> rlm_realm: No such realm "NULL"<br>++[suffix] returns noop<br> rlm_eap: No EAP-Message, not doing EAP<br>++[eap] returns noop<br>
++[unix] returns updated<br>++[files] returns noop<br> expand: %{User-Name} -> tuc<br>rlm_sql (sql): sql_set_user escaped user --> 'tuc'<br>rlm_sql (sql): Reserving sql socket id: 4<br> 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<br>
rlm_sql_postgresql: query: SELECT id, UserName, Attribute, Value, Op FROM radcheck WHERE Username = 'tuc' ORDER BY id<br>rlm_sql_postgresql: Status: PGRES_TUPLES_OK<br>rlm_sql_postgresql: query affected rows = 1 , fields = 5<br>
rlm_sql (sql): User found in radcheck table<br> 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<br>
rlm_sql_postgresql: query: SELECT id, UserName, Attribute, Value, Op FROM radreply WHERE Username = 'tuc' ORDER BY id<br>rlm_sql_postgresql: Status: PGRES_TUPLES_OK<br>rlm_sql_postgresql: query affected rows = 1 , fields = 5<br>
expand: SELECT GroupName FROM radusergroup WHERE UserName='%{SQL-User-Name}' ORDER BY priority -> SELECT GroupName FROM radusergroup WHERE UserName='tuc' ORDER BY priority<br>rlm_sql_postgresql: query: SELECT GroupName FROM radusergroup WHERE UserName='tuc' ORDER BY priority<br>
rlm_sql_postgresql: Status: PGRES_TUPLES_OK<br>rlm_sql_postgresql: query affected rows = 0 , fields = 1<br>rlm_sql (sql): Released sql socket id: 4<br>++[sql] returns ok<br>++[expiration] returns noop<br>++[logintime] returns noop<br>
++[pap] returns updated<br> rad_check_password: Found Auth-Type<br>auth: type "PAP"<br>+- entering group PAP<br>rlm_pap: login attempt with password "ICANSEE"<br>rlm_pap: Using CRYPT encryption.<br>rlm_pap: Passwords don't match<br>
++[pap] returns reject<br>auth: Failed to validate the user.<br>Login incorrect (rlm_pap: CRYPT password check failed): [tuc/ICANSEE] (from client localhost port 1812)<br> Found Post-Auth-Type Reject<br>+- entering group REJECT<br>
expand: %{User-Name} -> tuc<br> attr_filter: Matched entry DEFAULT at line 11<br>++[attr_filter.access_reject] returns updated<br>Delaying reject of request 0 for 1 seconds<br><br><br><br> Why does it head to crypt? I have in radcheck :<br>
<br>Welcome to psql 8.1.11, the PostgreSQL interactive terminal.<br><br>Type: \copyright for distribution terms<br> \h for help with SQL commands<br> \? for help with psql commands<br> \g or terminate with semicolon to execute query<br>
\q to quit<br><br>radius=> select * from radcheck;<br> id | username | attribute | op | value<br>----+----------+--------------------+----+---------<br> 2 | tuc | Cleartext-Password | := | ICANSEE<br>
(1 row)<br><br>radius=><br><br> Thanks, Tuc<br>-<br>List info/subscribe/unsubscribe? See <a href="http://www.freeradius.org/list/users.html" target="_blank">http://www.freeradius.org/list/users.html</a><br>
</blockquote></div>
<div><br> </div>
<div> </div>
<div>Regards,</div>
<div>Liran Tal.</div>