On Fri, Jun 29, 2012 at 9:19 PM, Taz Manian <djtazie@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@realm
[sql] sql_set_user escaped user --> 'username@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@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@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