<div dir="ltr"><div class="gmail_extra"><div class="gmail_extra">sql sql2 {</div><div class="gmail_extra"><br></div><div class="gmail_extra">}</div><div class="gmail_extra">sql sql_gowifi{</div><div class="gmail_extra"><span class="" style="white-space:pre">      </span>driver = "rlm_sql_mysql"</div>
<div class="gmail_extra"><br></div><div class="gmail_extra"><span class="" style="white-space:pre">       </span># Connection info:</div><div class="gmail_extra"><span class="" style="white-space:pre">   </span>server = "localhost"</div>
<div class="gmail_extra"><span class="" style="white-space:pre">      </span>#port = 3306</div><div class="gmail_extra"><span class="" style="white-space:pre"> </span>login = "dbuser"</div><div class="gmail_extra"><span class="" style="white-space:pre">   </span>password = "pass"</div>
<div class="gmail_extra"><span class="" style="white-space:pre">      </span>radius_db = "radius"</div><div class="gmail_extra"><span class="" style="white-space:pre">       </span></div><div class="gmail_extra"><span class="" style="white-space:pre">     </span># Print all SQL statements when in debug mode (-x)<br>
</div><div class="gmail_extra"><span class="" style="white-space:pre">  </span>sqltrace = yes</div><div class="gmail_extra"><span class="" style="white-space:pre">       </span>sqltracefile = ${logdir}/custom.sql</div><div class="gmail_extra">
<br></div><div class="gmail_extra"><span class="" style="white-space:pre">        </span># number of sql connections to make to server</div><div class="gmail_extra"><span class="" style="white-space:pre">        </span>num_sql_socks = 5</div>
<div class="gmail_extra"><br></div><div class="gmail_extra"><span class="" style="white-space:pre">       </span># number of seconds to dely retrying on a failed database</div><div class="gmail_extra"><span class="" style="white-space:pre">    </span>connect_failure_retry_delay = 60</div>
<div class="gmail_extra"><br></div><div class="gmail_extra"><span class="" style="white-space:pre">       </span># lifetime of an SQL socket.  If you are having network issues</div><div class="gmail_extra"><span class="" style="white-space:pre">       </span># such as TCP sessions expiring</div>
<div class="gmail_extra"><span class="" style="white-space:pre">      </span>lifetime = 0</div><div class="gmail_extra"><br></div><div class="gmail_extra"><span class="" style="white-space:pre">  </span># Maximum number of queries used by an SQL socket.  If you are</div>
<div class="gmail_extra"><span class="" style="white-space:pre">      </span># having issues with SQL sockets lasting "too long".</div><div class="gmail_extra"><span class="" style="white-space:pre">       </span>max_queries = 0</div>
<div class="gmail_extra"><br></div><div class="gmail_extra"><span class="" style="white-space:pre">       </span># Set to 'yes' to read radius clients from the database ('nas' table)</div><div class="gmail_extra">
<span class="" style="white-space:pre">       </span>readclients = yes</div><div class="gmail_extra"><br></div><div class="gmail_extra"><span class="" style="white-space:pre">     </span>#default_user_profile = "0"</div><div class="gmail_extra">
<br></div><div class="gmail_extra"><br></div><div class="gmail_extra">sql_user_name = "%{sql2:select s.* from (select @user:=BINARY '%{User-Name}' p) parm , upm s}"<br></div><div class="gmail_extra"><br>
</div><div class="gmail_extra">group_membership_query = "SELECT plan FROM `voucher` WHERE (code =BINARY '%{SQL-User-Name}' and `sts`='1')"<br></div><div>}</div><div><br></div><div style>this is the section where i am having problem and i will give the debug output shortly</div>
<div style><br></div><div style>also i denied to give the full code as it's part of my confidential company files if i give the full code then someone might get the details about the table structure</div>
</div></div>