<HTML><BODY>Hi,<br><br>regarding Semulteneous-Use issue:<br><br>I use cisco NAS, usernames 'user'<br><br>============<br><p>ad_recv: Accounting-Request packet from host 10.169.33.11 port 1646, id=85, length=323<br> Acct-Session-Id = "00003306"<br> Called-Station-Id = "0013.1a08.9340"<br> Calling-Station-Id = "0013.e8f4.3f0d"<br> Cisco-AVPair = "ssid=HAYATT"<br> Cisco-AVPair = "vlan-id=55"<br> Cisco-AVPair = "nas-location=unspecified"<br> Cisco-AVPair = "auth-algo-type=eap-peap"<br> User-Name = "user"<br> Acct-Authentic = RADIUS<br> Cisco-AVPair = "connect-progress=Call Up"<br> Acct-Session-Time = 1<br> Acct-Input-Octets = 284<br> Acct-Output-Octets = 485<br> Acct-Input-Packets = 5<br> Acct-Output-Packets = 6<br> Acct-Terminate-Cause = Lost-Carrier<br> Cisco-AVPair = "disc-cause-ext=No Reason"<br> Acct-Status-Type = Stop<br> NAS-Port-Type = Wireless-802.11<br> Cisco-NAS-Port = "13257"<br> NAS-Port = 13257<br> Service-Type = Framed-User<br> NAS-IP-Address = 10.169.33.11<br> Acct-Delay-Time = 15<br># Executing section preacct from file /usr/local/etc/raddb/sites-enabled/default<br>+- entering group preacct {...}<br>++[preprocess] returns ok<br>[acct_unique] Hashing 'NAS-Port = 13257,Client-IP-Address = 10.169.33.11,NAS-IP-Address = 10.169.33.11,Acct-Session-Id = "00003306",User-Name = "user"'<br>[acct_unique] Acct-Unique-Session-ID = "f879723bff47e643".<br>++[acct_unique] returns ok<br>[suffix] No '@' in User-Name = "user", looking up realm NULL<br>[suffix] No such realm "NULL"<br>++[suffix] returns noop<br>++[files] returns noop<br># Executing section accounting from file /usr/local/etc/raddb/sites-enabled/default<br>+- entering group accounting {...}<br>[detail] expand: /var/log/radacct/%{Client-IP-Address}/detail-%Y%m%d -> /var/log/radacct/10.169.33.11/detail-20111207<br>[detail] /var/log/radacct/%{Client-IP-Address}/detail-%Y%m%d expands to /var/log/radacct/10.169.33.11/detail-20111207<br>[detail] expand: %t -> Wed Dec 7 10:17:11 2011<br>++[detail] returns ok<br>++[unix] returns fail<br>Finished request 83.<br>Cleaning up request 83 ID 85 with timestamp +189<br>Going to the next request<br>Waking up in 4.8 seconds.<br>rad_recv: Accounting-Request packet from host 10.169.33.11 port 1646, id=86, length=224<br> Acct-Session-Id = "00003308"<br> Called-Station-Id = "0013.1a08.9340"<br> Calling-Station-Id = "0013.e8f4.3f0d"<br> Cisco-AVPair = "ssid=HAYATT"<br> Cisco-AVPair = "vlan-id=55"<br> Cisco-AVPair = "nas-location=unspecified"<br> User-Name = "user"<br> Cisco-AVPair = "connect-progress=Call Up"<br> Acct-Authentic = RADIUS<br> Acct-Status-Type = Start<br> NAS-Port-Type = Wireless-802.11<br> Cisco-NAS-Port = "13258"<br> NAS-Port = 13258<br> Service-Type = Framed-User<br> NAS-IP-Address = 10.169.33.11<br> Acct-Delay-Time = 15<br># Executing section preacct from file /usr/local/etc/raddb/sites-enabled/default<br>+- entering group preacct {...}<br>++[preprocess] returns ok<br>[acct_unique] Hashing 'NAS-Port = 13258,Client-IP-Address = 10.169.33.11,NAS-IP-Address = 10.169.33.11,Acct-Session-Id = "00003308",User-Name = "user"'<br>[acct_unique] Acct-Unique-Session-ID = "45341f9e68e705da".<br>++[acct_unique] returns ok<br>[suffix] No '@' in User-Name = "user", looking up realm NULL<br>[suffix] No such realm "NULL"<br>++[suffix] returns noop<br>++[files] returns noop<br># Executing section accounting from file /usr/local/etc/raddb/sites-enabled/default<br>+- entering group accounting {...}<br>[detail] expand: /var/log/radacct/%{Client-IP-Address}/detail-%Y%m%d -> /var/log/radacct/10.169.33.11/detail-20111207<br>[detail] /var/log/radacct/%{Client-IP-Address}/detail-%Y%m%d expands to /var/log/radacct/10.169.33.11/detail-20111207<br>[detail] expand: %t -> Wed Dec 7 10:17:11 2011<br>++[detail] returns ok<br>++[unix] returns fail<br>Finished request 84.<br>Cleaning up request 84 ID 86 with timestamp +189<br>Going to the next request<br>Waking up in 4.3 seconds.<br>Cleaning up request 82 ID 226 with timestamp +188<br>Ready to process requests.<br>rad_recv: Accounting-Request packet from host 10.169.33.11 port 1646, id=87, length=323<br> Acct-Session-Id = "00003308"<br> Called-Station-Id = "0013.1a08.9340"<br> Calling-Station-Id = "0013.e8f4.3f0d"<br> Cisco-AVPair = "ssid=HAYATT"<br> Cisco-AVPair = "vlan-id=55"<br> Cisco-AVPair = "nas-location=unspecified"<br> Cisco-AVPair = "auth-algo-type=eap-peap"<br> User-Name = "user"<br> Acct-Authentic = RADIUS<br> Cisco-AVPair = "connect-progress=Call Up"<br> Acct-Session-Time = 41<br> Acct-Input-Octets = 310<br> Acct-Output-Octets = 509<br> Acct-Input-Packets = 6<br> Acct-Output-Packets = 7<br> Acct-Terminate-Cause = Lost-Carrier<br> Cisco-AVPair = "disc-cause-ext=No Reason"<br> Acct-Status-Type = Stop<br> NAS-Port-Type = Wireless-802.11<br> Cisco-NAS-Port = "13258"<br> NAS-Port = 13258<br> Service-Type = Framed-User<br> NAS-IP-Address = 10.169.33.11<br> Acct-Delay-Time = 0<br># Executing section preacct from file /usr/local/etc/raddb/sites-enabled/default<br>+- entering group preacct {...}<br>++[preprocess] returns ok<br>[acct_unique] Hashing 'NAS-Port = 13258,Client-IP-Address = 10.169.33.11,NAS-IP-Address = 10.169.33.11,Acct-Session-Id = "00003308",User-Name = "user"'<br>[acct_unique] Acct-Unique-Session-ID = "45341f9e68e705da".<br>++[acct_unique] returns ok<br>[suffix] No '@' in User-Name = "user", looking up realm NULL<br>[suffix] No such realm "NULL"<br>++[suffix] returns noop<br>++[files] returns noop<br># Executing section accounting from file /usr/local/etc/raddb/sites-enabled/default<br>+- entering group accounting {...}<br>[detail] expand: /var/log/radacct/%{Client-IP-Address}/detail-%Y%m%d -> /var/log/radacct/10.169.33.11/detail-20111207<br>[detail] /var/log/radacct/%{Client-IP-Address}/detail-%Y%m%d expands to /var/log/radacct/10.169.33.11/detail-20111207<br>[detail] expand: %t -> Wed Dec 7 10:17:36 2011<br>++[detail] returns ok<br>++[unix] returns fail<br>Finished request 85.<br>Cleaning up request 85 ID 87 with timestamp +214<br>Going to the next request<br>Ready to process requests.<br>rad_recv: Accounting-Request packet from host 10.169.33.11 port 1646, id=88, length=323<br> Acct-Session-Id = "00003308"<br> Called-Station-Id = "0013.1a08.9340"<br> Calling-Station-Id = "0013.e8f4.3f0d"<br> Cisco-AVPair = "ssid=HAYATT"<br> Cisco-AVPair = "vlan-id=55"<br> Cisco-AVPair = "nas-location=unspecified"<br> Cisco-AVPair = "auth-algo-type=eap-peap"<br> User-Name = "user"<br> Acct-Authentic = RADIUS<br> Cisco-AVPair = "connect-progress=Call Up"<br> Acct-Session-Time = 41<br> Acct-Input-Octets = 310<br> Acct-Output-Octets = 509<br> Acct-Input-Packets = 6<br> Acct-Output-Packets = 7<br> Acct-Terminate-Cause = Lost-Carrier<br> Cisco-AVPair = "disc-cause-ext=No Reason"<br> Acct-Status-Type = Stop<br> NAS-Port-Type = Wireless-802.11<br> Cisco-NAS-Port = "13258"<br> NAS-Port = 13258<br> Service-Type = Framed-User<br> NAS-IP-Address = 10.169.33.11<br> Acct-Delay-Time = 5<br># Executing section preacct from file /usr/local/etc/raddb/sites-enabled/default<br>+- entering group preacct {...}<br>++[preprocess] returns ok<br>[acct_unique] Hashing 'NAS-Port = 13258,Client-IP-Address = 10.169.33.11,NAS-IP-Address = 10.169.33.11,Acct-Session-Id = "00003308",User-Name = "user"'<br>[acct_unique] Acct-Unique-Session-ID = "45341f9e68e705da".<br>++[acct_unique] returns ok<br>[suffix] No '@' in User-Name = "user", looking up realm NULL<br>[suffix] No such realm "NULL"<br>++[suffix] returns noop<br>++[files] returns noop<br># Executing section accounting from file /usr/local/etc/raddb/sites-enabled/default<br>+- entering group accounting {...}<br>[detail] expand: /var/log/radacct/%{Client-IP-Address}/detail-%Y%m%d -> /var/log/radacct/10.169.33.11/detail-20111207<br>[detail] /var/log/radacct/%{Client-IP-Address}/detail-%Y%m%d expands to /var/log/radacct/10.169.33.11/detail-20111207<br>[detail] expand: %t -> Wed Dec 7 10:17:41 2011<br>++[detail] returns ok<br>++[unix] returns fail<br>Finished request 86.<br>Cleaning up request 86 ID 88 with timestamp +219<br>Going to the next request<br>Ready to process requests.<br>rad_recv: Accounting-Request packet from host 10.169.33.11 port 1646, id=89, length=323<br> Acct-Session-Id = "00003308"<br> Called-Station-Id = "0013.1a08.9340"<br> Calling-Station-Id = "0013.e8f4.3f0d"<br> Cisco-AVPair = "ssid=HAYATT"<br> Cisco-AVPair = "vlan-id=55"<br> Cisco-AVPair = "nas-location=unspecified"<br> Cisco-AVPair = "auth-algo-type=eap-peap"<br> User-Name = "user"<br> Acct-Authentic = RADIUS<br> Cisco-AVPair = "connect-progress=Call Up"<br> Acct-Session-Time = 41<br> Acct-Input-Octets = 310<br> Acct-Output-Octets = 509<br> Acct-Input-Packets = 6<br> Acct-Output-Packets = 7<br> Acct-Terminate-Cause = Lost-Carrier<br> Cisco-AVPair = "disc-cause-ext=No Reason"<br> Acct-Status-Type = Stop<br> NAS-Port-Type = Wireless-802.11<br> Cisco-NAS-Port = "13258"<br> NAS-Port = 13258<br> Service-Type = Framed-User<br> NAS-IP-Address = 10.169.33.11<br> Acct-Delay-Time = 10<br># Executing section preacct from file /usr/local/etc/raddb/sites-enabled/default<br>+- entering group preacct {...}<br>++[preprocess] returns ok<br>[acct_unique] Hashing 'NAS-Port = 13258,Client-IP-Address = 10.169.33.11,NAS-IP-Address = 10.169.33.11,Acct-Session-Id = "00003308",User-Name = "user"'<br>[acct_unique] Acct-Unique-Session-ID = "45341f9e68e705da".<br>++[acct_unique] returns ok<br>[suffix] No '@' in User-Name = "user", looking up realm NULL<br>[suffix] No such realm "NULL"<br>++[suffix] returns noop<br>++[files] returns noop<br># Executing section accounting from file /usr/local/etc/raddb/sites-enabled/default<br>+- entering group accounting {...}<br>[detail] expand: /var/log/radacct/%{Client-IP-Address}/detail-%Y%m%d -> /var/log/radacct/10.169.33.11/detail-20111207<br>[detail] /var/log/radacct/%{Client-IP-Address}/detail-%Y%m%d expands to /var/log/radacct/10.169.33.11/detail-20111207<br>[detail] expand: %t -> Wed Dec 7 10:17:46 2011<br>++[detail] returns ok<br>++[unix] returns fail<br>Finished request 87.<br>Cleaning up request 87 ID 89 with timestamp +224<br>Going to the next request<br>Ready to process requests.<br>rad_recv: Accounting-Request packet from host 10.169.33.11 port 1646, id=90, length=323<br> Acct-Session-Id = "00003308"<br> Called-Station-Id = "0013.1a08.9340"<br> Calling-Station-Id = "0013.e8f4.3f0d"<br> Cisco-AVPair = "ssid=HAYATT"<br> Cisco-AVPair = "vlan-id=55"<br> Cisco-AVPair = "nas-location=unspecified"<br> Cisco-AVPair = "auth-algo-type=eap-peap"<br> User-Name = "user"<br> Acct-Authentic = RADIUS<br> Cisco-AVPair = "connect-progress=Call Up"<br> Acct-Session-Time = 41<br> Acct-Input-Octets = 310<br> Acct-Output-Octets = 509<br> Acct-Input-Packets = 6<br> Acct-Output-Packets = 7<br> Acct-Terminate-Cause = Lost-Carrier<br> Cisco-AVPair = "disc-cause-ext=No Reason"<br> Acct-Status-Type = Stop<br> NAS-Port-Type = Wireless-802.11<br> Cisco-NAS-Port = "13258"<br> NAS-Port = 13258<br> Service-Type = Framed-User<br> NAS-IP-Address = 10.169.33.11<br> Acct-Delay-Time = 15<br># Executing section preacct from file /usr/local/etc/raddb/sites-enabled/default<br>+- entering group preacct {...}<br>++[preprocess] returns ok<br>[acct_unique] Hashing 'NAS-Port = 13258,Client-IP-Address = 10.169.33.11,NAS-IP-Address = 10.169.33.11,Acct-Session-Id = "00003308",User-Name = "user"'<br>[acct_unique] Acct-Unique-Session-ID = "45341f9e68e705da".<br>++[acct_unique] returns ok<br>[suffix] No '@' in User-Name = "user", looking up realm NULL<br>[suffix] No such realm "NULL"<br>++[suffix] returns noop<br>++[files] returns noop<br># Executing section accounting from file /usr/local/etc/raddb/sites-enabled/default<br>+- entering group accounting {...}<br>[detail] expand: /var/log/radacct/%{Client-IP-Address}/detail-%Y%m%d -> /var/log/radacct/10.169.33.11/detail-20111207<br>[detail] /var/log/radacct/%{Client-IP-Address}/detail-%Y%m%d expands to /var/log/radacct/10.169.33.11/detail-20111207<br>[detail] expand: %t -> Wed Dec 7 10:17:51 2011<br>++[detail] returns ok<br>++[unix] returns fail<br>Finished request 88.<br>Cleaning up request 88 ID 90 with timestamp +229<br>Going to the next request<br>Ready to process requests.<br>===========================<br><br>simulteneous-use not working(( </p>mysql> select * from radcheck;<br>+----+-----------------+--------------------+----+------------------+<br>| id | username | attribute | op | value |<br>+----+-----------------+--------------------+----+------------------+<br>| 11 | user | Cleartext-Password | := | user |<br>| 3 | <a rel="nofollow" target="_top">[hidden email]</a> | Cleartext-Password | := | test |<br>| 5 | <a rel="nofollow" target="_top">[hidden email]</a> | Cleartext-Password | := | test |<br>| 10 | user | Simultaneous-Use | := | 1 |<br>| 8 | <a rel="nofollow" target="_top">[hidden email]</a> | Framed-Filter-Id | := | SP=data:MSF=data |<br>| 9 | <a rel="nofollow" target="_top">[hidden email]</a> | Framed-Filter-Id | := | SP=data:MSF=data |<br>+----+-----------------+--------------------+----+------------------+<br><br><br><br><br>08 декабря 2011, 11:59 от "tolik_shavlovsky@mail.ru" <tolik_shavlovsky@mail.ru>:<br><blockquote style="border-left:1px solid #0857A6; margin:10px; padding:0 0 0 10px;" class="mailru-blockquote"><div id="class_1323331212">
<div class="js-helper">
<style type="text/css"></style>
<div id="style_13233311560000000842" class="mr_read__body">
<base target="_self" href="http://e.mail.ru/cgi-bin/">
<div id="style_13233311560000000842_BODY">
oh, sorry....<br>but that username could be authenticated)<br><br><p><br>mysql> select * from radcheck;<br>+----+-----------------+--------------------+----+------------------+<br>| id | username | attribute | op | value |<br>+----+-----------------+--------------------+----+------------------+<br>| 11 | user | Cleartext-Password | := | user |<br>| 3 | <a link="external" rel="nofollow" target="_top">[hidden email]</a> | Cleartext-Password | := | test |<br>| 5 | <a link="external" rel="nofollow" target="_top">[hidden email]</a> | Cleartext-Password | := | test |<br>| 10 | user | Simultaneous-Use | := | 1 |<br>| 8 | <a link="external" rel="nofollow" target="_top">[hidden email]</a> | Framed-Filter-Id | := | SP=data:MSF=data |<br>| 9 | <a link="external" rel="nofollow" target="_top">[hidden email]</a> | Framed-Filter-Id | := | SP=data:MSF=data |<br>+----+-----------------+--------------------+----+------------------+</p><br><br><br>08 декабря 2011, 11:51 от "Alan DeKok-2 [via FreeRadius]" <<a link="external" rel="nofollow" target="_top">[hidden email]</a>>:<br><blockquote style="border-left:1px solid #0857A6; margin:10px; padding:0 0 0 10px;" class="mailru-blockquote"><div id="class_1323331027">
<div class="style_13233311560000000842js-helper">
<div id="style_13233306850000000438" class="style_13233311560000000842mr_read__body">
<base target="_self" href="http://e.mail.ru/cgi-bin/">
<div id="style_13233306850000000438_BODY">
Толик Шавловский wrote:
<br>> Hi,
<br>>
<br>> mysql> use freeradius;
<br>> Database changed
<br>> mysql> select * from radcheck;
<br>> +----+-----------------+--------------------+----+------------------+
<br>> | id | username | attribute | op | value |
<br>> +----+-----------------+--------------------+----+------------------+
<br>> | 1 | user | Password | == | user |
<br><br> Change that to "Cleartext-Password" and ":=", like the other entries.
<br><br>> all usernames are authenticated for WiFi.
<br>>
<br>> Wimax cannot.
<br><br> Post the debug output for WiMAX. Honestly, I don't see why *anyone*
<br>needs to be told this.
<br><br> Alan DeKok.
<br>-
<br>List info/subscribe/unsubscribe? See <a rel="nofollow" link="external" target="_top" href="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</a><br>
<br>
<br>
<hr noshade="noshade" color="#cccccc" size="1">
<div style="color:#444; font: 12px tahoma,geneva,helvetica,arial,sans-serif;">
<div style="font-weight:bold">If you reply to this email, your message will be added to the discussion below:</div>
<a link="external" rel="nofollow" target="_blank" href="http://freeradius.1045715.n5.nabble.com/authentetication-with-mysql-and-NAS-type-other-tp5055689p5057987.html">http://freeradius.1045715.n5.nabble.com/authentetication-with-mysql-and-NAS-type-other-tp5055689p5057987.html</a>
</div>
<div style="color:#666; font: 11px tahoma,geneva,helvetica,arial,sans-serif;margin-top:.4em;line-height:1.5em">
To unsubscribe from authentetication with mysql and NAS type= other, <a link="external" rel="nofollow" target="_blank">click here</a>.<br>
<a link="external" rel="nofollow" target="_blank" href="http://freeradius.1045715.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.InstantMailNamespace&breadcrumbs=instant+emails%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml" style="font:9px serif">NAML</a>
<br></div>
<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br></div>
<base target="_self" href="http://e.mail.ru/cgi-bin/">
</div>
</div>
</div></blockquote><br>
<br><hr width="300" align="left">
View this message in context: <a target="_blank" href="http://freeradius.1045715.n5.nabble.com/authentetication-with-mysql-and-NAS-type-other-tp5055689p5058005.html">Re[2]: authentetication with mysql and NAS type= other</a><br>
Sent from the <a target="_blank" href="http://freeradius.1045715.n5.nabble.com/FreeRadius-User-f2740693.html">FreeRadius - User mailing list archive</a> at Nabble.com.<br>
<br><br><br></div>
<div>-<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>
<br>
</div>
<base target="_self" href="http://e.mail.ru/cgi-bin/">
</div>
</div>
</div></blockquote><br></BODY></HTML>