1.1.7 MySQL postauth_query

[Hugh Messenger]

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

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20070716/ddbdbbcc/attachment.html>