On May 29, 2015, at 10:05 AM, Jeremy Ravel <Jeremy.Ravel@etu.univ-savoie.fr> wrote:
Thanks, but i still got a problem,
One issue is that you're not following instructions.
Whatever I give for my date attribut , I match the if(for the date) so I cant logon Maybe I don't give a good date format ? I use this kind of date " May 29 2015 14:38:27 CEST "
That should work.
Fri May 29 15:57:33 2015 : Debug: sqlcounter_expand: 'SELECT value FROM `radcheck` WHERE UserName = '%{User-Name}' AND attribute = 'Acc-start-date'' Fri May 29 15:57:33 2015 : Info: [Acc-start-date] expand: SELECT value FROM `radcheck` WHERE UserName = '%{User-Name}' AND attribute = 'Acc-start-date' -> SELECT value FROM `radcheck` WHERE UserName = 'day2' AND attribute = 'Acc-start-date' Fri May 29 15:57:33 2015 : Debug: WARNING: Please replace '%S' with '${sqlmod-inst}' Fri May 29 15:57:33 2015 : Debug: sqlcounter_expand: '%{sql:SELECT value FROM `radcheck` WHERE UserName = 'day2' AND attribute = 'Acc-start-date'}'
What are you doing there? That makes no sense. Don't do that. The normal SQL module already takes care of setting the attribute. If you're having trouble with SQL (and you are), just put the attribute into the "users" file. Simplify your tests. Maybe try different date formats... Right now, you're trying to do it the most complicated way possible. I have no idea why. Alan DeKok.