On Thu, Apr 22, 2010 at 04:50:50PM +0700, VU VAN HUNG wrote:
It looks like you have a problem with this INSERT query:
[..]
> [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 (
> 'hung', '',
> 'Access-Accept', '2010-04-21 20:22:27')
> rlm_sql (sql) in sql_postauth: query is INSERT INTO
> radpostauth (username, pass, reply,
> authdate) VALUES (
> 'hung', '',
> 'Access-Accept', '2010-04-21 20:22:27')
> *rlm_sql (sql): Reserving sql socket id: 2
> rlm_sql_mysql: MYSQL check_error: 1054 received
> rlm_sql (sql) in sql_postauth: Database query error - Unknown column
> 'username' in 'field list'*
Everything seems to be fine until you get to this postauth stage so I guess
fixing the query should solve your problem.
--
Szymon Roczniak
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
