Re: pool name per nas AND per user

15 Oct 2008

      tnt@kalik.net a écrit :
...
...
So In the authorize section i tried to add an update directive where i
define a variable which has the result of the sql query as value.
Then i want to concatenate this variable with the value of the Pool-Name
attribute as defined in the users file and set it as the new value of
Pool-Name. I think this would work for what i want to do.
update control {
               "%{MANA-DSL-Type}" = mysqldb:"SELECT value FROM radcheck
WHERE attribute='Subscription-Type' AND username='%{User-Name}'"
               if ("%{MANA-DSL-Type}") {
                       Pool-Name := "%{Pool-Name}""%{ADSL-Type}"
               }
       }
Ugh.
I knew you was going to said that :)
...
1. Forget custom dictionaries. Use already defined temporary attributes
from freeradius internal dictionary (ie. Tmp-String-0,...,
Tmp-Integer-0, ... etc.)
good
...
2. "%{}" goes around the value not attribute name:
Tmp-String-0 = "%{mysqldb:SELECT value FROM...}"
understood
...
3. You can't put if inside the control section. You can put update
control inside if section.
update control {
      read temporary value from the database
}
if(whatever) {
     update control { ...
ok here is what i have now:

    # I want the pool to be the concatenation of pool-name as previously
set by huntgroup in
    # users file, the expanded value of tmp-String-0 and the string
"_pool" if possible
    update control {
                Tmp-String-0 = "%{mysqldb:SELECT forfait FROM test WHERE
username='%{User-Name}'}"
                Pool-Name := "%{Pool-Name}""%{Tmp-String-0}"_pool
    }

Two problems I can see in the debug output:

- 1 - control returns noop (the update control is placed at the end
ofthe authorize section after pap), and so nothing happens...
- 2 - when expanded "%{Pool-Name}" is empty whereas users as been
proceed before the "update control".

Any idea?

here is the revelant debug:
rlm_sql (mysqldb): - sql_xlat
    expand: %{User-Name} -> scott
rlm_sql (mysqldb): sql_set_user escaped user --> 'scott'
    expand: SELECT forfait FROM test WHERE username='%{User-Name}' ->
SELECT forfait FROM test WHERE username='scott'
    expand: /var/log/freeradius/sqltrace.sql ->
/var/log/freeradius/sqltrace.sql
rlm_sql (mysqldb): Reserving sql socket id: 4
rlm_sql_mysql: query:  SELECT forfait FROM test WHERE username='scott'
rlm_sql (mysqldb): - sql_xlat finished
rlm_sql (mysqldb): Released sql socket id: 4
    expand: %{mysqldb:SELECT forfait FROM test WHERE
username='%{User-Name}'} -> ADSL512
    expand: %{Pool-Name} ->
++[control] returns noop
...
Ivan Kalik
Kalik Informatika ISP
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: pool name per nas AND per user

Alexandre Chapellon