Hello
i am getting an issue with xlat
i tried this
sql sql2 {
}
sql sql_gowifi{
sql_user_name = %{sql2:select s.* from (select
@userhttps://github.com/user:=BINARY
'%{User-Name}' p) parm , upm s}
}
and using sql_gowifi in sites-enabled/default for mysql based login and
accounting
again when
this is the section i am having issues
so i don't think it's needed to post the full config
also there is nothing special in debug just the sql_user_name field is blank
also i managed to write some sql functions to archive the same
-
List info/subscribe/unsubscribe? See
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
ok after a close look at the debug i found the log
[sql_gowifi] WARNING: Unknown module sql2 in string expansion %
[sql_gowifi] sql_set_user escaped user -- ''
it's not able to find the module sql2 but in my config the very first line
is sql sql2 {
-
List info/subscribe/unsubscribe? See
can you tell what files you need??
and the code i am giving is form sql configurations file to simulate this
according to your instruction i changed the file like
sql sql2{
sql_user_name = %{sql_inst2:select s.* from (select @user:=BINARY
'%{User-Name}' p) parm , upm s}
}
and in
sql sql_gowifi{
5 matches
Mail list logo