Accounting in MySQL - Password

[Alan DeKok]

P K wrote:
> Thanks Alan. I understand now.  I've created my own postauth table and
> updated the sql query. My query is like this:

  That should work.

> outer.request:User-Name works when this query is being executed from
> inner-tunnel but not in outer obviously. So I want to put an if
> condition. I'm fine with the syntax but i'm struggling to determine
> what to put a condition on. What variable should I look at to
> determine if I'm in inner or outer tunnel?  I was thinking
> virtual-server .. not sure.

  You put a condition on the expansion.  See "man unlang"

	%{%{outer.request:User-Name}:-NONE}

> Also I want to record protocol TTLS/PAP or PEAP/MSCHAP that has been
> in action. What variable should I use for this?

  outer.request:EAP-Type.

> Is there a variable that would indicate the module that succeeded e.g
> ldap, mysql etc. so that I could record it? Auth-Type??

  No.  Because the EAP module is doing authentication.

  Alan DeKok.