rlm_sql error, can't expand User-Password and Chap-Password, help me !

szymon roczniak simon at dischaos.com
Thu Apr 22 13:26:56 CEST 2010

On Thu, Apr 22, 2010 at 05:38:04PM +0700, VU VAN HUNG wrote:
> szymon roczniak wrote:
> > On Thu, Apr 22, 2010 at 04:50:50PM +0700, VU VAN HUNG wrote:
> I know, but in the output,  I see the following lines:
> *sql]     expand: %{User-Password} ->
> [sql]     expand: %{Chap-Password} -> *
> no information about User-Password and Chap-Password, and the query, 

I hope I'm not completely wrong here but this is probably because you're using
EAP not PAP or CHAP so these attributes are not set.

> which insert into radpostauth, is error. I dont know why.  Do you have 
> any suggests about this problem ?

the query results in an error because the username column in missing (or
misspelled) in the table:

> >> rlm_sql (sql) in sql_postauth: Database query error - Unknown column 
> >> 'username' in 'field list'*

Szymon Roczniak

More information about the Freeradius-Users mailing list