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