Mysql xlat help

[Go WiFi]

sql sql2 {

}
sql sql_gowifi{
driver = "rlm_sql_mysql"

# Connection info:
server = "localhost"
#port = 3306
login = "dbuser"
password = "pass"
radius_db = "radius"
 # Print all SQL statements when in debug mode (-x)
sqltrace = yes
sqltracefile = ${logdir}/custom.sql

# number of sql connections to make to server
num_sql_socks = 5

# number of seconds to dely retrying on a failed database
connect_failure_retry_delay = 60

# lifetime of an SQL socket.  If you are having network issues
# such as TCP sessions expiring
lifetime = 0

# Maximum number of queries used by an SQL socket.  If you are
# having issues with SQL sockets lasting "too long".
max_queries = 0

# Set to 'yes' to read radius clients from the database ('nas' table)
readclients = yes

#default_user_profile = "0"


sql_user_name = "%{sql2:select s.* from (select @user:=BINARY
'%{User-Name}' p) parm , upm s}"

group_membership_query = "SELECT plan FROM `voucher` WHERE (code =BINARY
'%{SQL-User-Name}' and `sts`='1')"
}

this is the section where i am having problem and i will give the debug
output shortly

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20130615/4e6f308c/attachment.html>