[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freeradius-users
Subject:    Re: Updating nas-port after authentication
From:       rgreiner <mrgreiner () gmail ! com>
Date:       2008-12-23 14:47:34
Message-ID: 4950FA06.9050700 () gmail ! com
[Download RAW message or body]

tnt@kalik.net wrote:
>> The query I tried looks like this:
>>
>>        postauth_query = "UPDATE radcheck SET radcheck.value='%{NAS-Port}' \
>>                        WHERE radcheck.username = '%{User-Name}' \
>>                        and radcheck.attribute='NAS-Port'"
>>
>>     
>
> More important is how does it look in the debug. Is it used? You should
>   
Of course. If I had done this in first place, I would have seen my
mistake. I'm using <%{User-Name}> in the query, but I'm also using
domains, so the query ended up like ....WHERE radcheck.username =
'name@domain'. Of course, there is no such user, so no update was done.
I'm using <%{Stripped-User-Name}> now, and it worked fine.
> change the op in the same time.
>   
Yes, that's exactly what I intended to do. ^_^

Thanks a lot for the help,

Roberto


-- 
  -----------------------------------------------------
                Marcos Roberto Greiner

   Os otimistas acham que estamos no melhor dos mundos
    Os pessimistas tem medo de que isto seja verdade
                                       Murphy
  -----------------------------------------------------

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
[prev in list] [next in list] [prev in thread] [next in thread]