FreeRADIUS SQl Ippool problem -

[Fajar A. Nugraha]

On Fri, Jun 29, 2012 at 9:19 PM, Taz Manian <djtazie at hotmail.com> wrote:
> [sql]   expand: SELECT id, groupname, attribute,           Value,
> op           FROM radgroupcheck           WHERE groupname =
> '%{Sql-Group}'           ORDER BY id -> SELECT id, groupname,
> attribute,           Value, op           FROM radgroupcheck           WHERE
> groupname = 'MyGroup'           ORDER BY id

so it reads radgroupcheck ...

> # Executing section post-auth from file /etc/raddb/sites-enabled/default
> +- entering group post-auth {...}
> [sql]   expand: %{User-Name} -> username at realm
>
> [sql] sql_set_user escaped user --> 'username at realm'
> [sql]   expand: %{User-Password} -> 1234567
> [sql]   expand: INSERT INTO radpostauth                           (username,
> pass, reply, authdate)                           VALUES
> (                           '%{User-Name}',
> '%{%{User-Password}:-%{Chap-Password}}',
> '%{reply:Packet-Type}', '%S') -> INSERT INTO
> radpostauth                           (username, pass, reply,
> authdate)                           VALUES (
> 'username at realm',
> '1234567',                           'Access-Accept', '2012-06-29 15:13:08')
> rlm_sql (sql) in sql_postauth: query is INSERT INTO
> radpostauth                           (username, pass, reply,
> authdate)                           VALUES (
> 'username at realm',
> '1234567',                           'Access-Accept', '2012-06-29 15:13:08')
>
> rlm_sql (sql): Reserving sql socket id: 0
> rlm_sql (sql): Released sql socket id: 0
> ++[sql] returns ok
> ++[exec] returns noop
> Sending Access-Accept of id 97 to 192.168.1.150 port 56916


... but no mention of sqlippool call on post-auth. I have to ask
again, did you REALLY read the wiki? Thoroughly? Did you follow the
instructions there?
Did you put a call to sqlippool instance inside post-auth, like the
wiki tells you to?

-- 
Fajar