I seem to recall having this problem when I first ran 1.1.6. The postauth_query is:
postauth_query = "INSERT into ${postauth_table} (id, user, pass, reply, date) values ('', '%{User-Name}', '%{User-Password:-Chap-Password}', '%{reply:Packet-Type}', NOW())" . but MySQL barfs about an invalid 'id' value. Maybe this is down to my schema . but surely, being an auto increment, we just don't need to specify the 'id' in the INSERT? I've modified it at my end to just be . postauth_query = "INSERT into ${postauth_table} (user, pass, reply, date) values ('%{User-Name}', '%{User-Password:-Chap-Password}', '%{reply:Packet-Type}', NOW())" . which works fine. -- hugh
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html