<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style id="owaParaStyle" type="text/css">
<!--
p
{margin-top:0;
margin-bottom:0}
-->
</style>
</head>
<body>
<div style="direction:ltr; font-family:Tahoma; color:#000000; font-size:10pt">Hello,<br>
<br>
We are doing a query which are supposed to comeback with a bunch of subscriber accounts.<br>
<br>
update request {<br>
Subscriber-Accounts := "%{sql-cisco-bng:SELECT GROUP_CONCAT(username SEPARATOR ';') FROM radcheck WHERE username LIKE '%{User-Name}%%'}"<br>
}<br>
<br>
But it seems that there is a limit on how long the return string can be? <br>
In this case a query for acccount for user "10.33.2.3_GigabitEthernet0/0/2" did return below accounts but the return query cuts off after a while. (And yes port 1 and port 2 also gets account for 10-19 and 20-22 which is why we noticed this bugg/feature..?)<br>
<br>
10.33.2.3_GigabitEthernet0/0/21<br>
10.33.2.3_GigabitEthernet0/0/20 CH_VoIP<br>
10.33.2.3_GigabitEthernet0/0/20 CH_IPTV<br>
10.33.2.3_GigabitEthernet0/0/20<br>
10.33.2.3_GigabitEthernet0/0/2 KAL_IPTV<br>
10.33.2.3_GigabitEthernet0/0/20 KAL_IPTV<br>
10.33.2.3_GigabitEthernet0/0/2<br>
<br>
Here is from the debug where one can see where it gets cut off<br>
rlm_perl: sub-pre-auth: Debug: RAD_REQUEST in sub authorize: Subscriber-Accounts = 10.33.2.3_GigabitEthernet0/0/21;10.33.2.3_GigabitEthernet0/0/20 CH_VoIP;10.33.2.3_GigabitEthernet0/0/20 CH_IPTV;10.33.2.3_GigabitEthernet0/0/20;10.33.2.3_GigabitEthernet0/0/2
KAL_IPTV;10.33.2.3_GigabitEthernet0/0/20 KAL_IPTV;10.33.2.3_GigabitEth<br>
<br>
And and after splitted<br>
rlm_perl: sub-pre-auth: i = 0, SQL Found Account[0]: 10.33.2.3_GigabitEthernet0/0/21<br>
rlm_perl: sub-pre-auth: i = 1, SQL Found Account[1]: 10.33.2.3_GigabitEthernet0/0/20 CH_VoIP<br>
rlm_perl: sub-pre-auth: i = 2, SQL Found Account[2]: 10.33.2.3_GigabitEthernet0/0/20 CH_IPTV<br>
rlm_perl: sub-pre-auth: i = 3, SQL Found Account[3]: 10.33.2.3_GigabitEthernet0/0/20<br>
rlm_perl: sub-pre-auth: i = 4, SQL Found Account[4]: 10.33.2.3_GigabitEthernet0/0/2 KALEJDO_IPTV<br>
rlm_perl: sub-pre-auth: i = 5, SQL Found Account[5]: 10.33.2.3_GigabitEthernet0/0/20 KALEJDO_IPTV<br>
rlm_perl: sub-pre-auth: i = 6, SQL Found Account[6]: 10.33.2.3_GigabitEth<br>
<br>
So my question is if there is a limitation can i change it somewhere and why is there one in the first place?<br>
<br>
We temporary fixed it by a better matched SQL query which doesnt give us accounts we are not asking for..<br>
Subscriber-Accounts := "%{sql-cisco-bng:SELECT GROUP_CONCAT(username SEPARATOR ';') AS FOO_RID FROM radcheck WHERE username LIKE '%{User-Name} %' OR username = '%{User-Name}'}"<br>
<br>
but it is still going to give us problems in the future since users can have more than above exemples of accounts.<br>
<br>
Thanks for your time.<br>
<br>
Alex<br>
</div>
<br>
<div><font face="Tahoma" size="1">********* DISCLAIMER ********* <br>
<br>
This message and any attachment are confidential and may be privileged or otherwise protected from disclosure and may include proprietary information. If you are not the intended recipient, please telephone or email the sender and delete this message and any
attachment from your system. If you are not the intended recipient you must not copy this message or attachment or disclose the contents to any other person
<br>
</font></div>
</body>
</html>