On Wed, May 29, 2002 at 01:50:01PM -0400, Alan DeKok wrote: > "Deramus, Chris" <[EMAIL PROTECTED]> wrote: > > I have another group on which is using the VPN concentrators method of > > authentication, (only supports 500 users however, and we require 1500 or > > entries) and set that group up to pass all accounting information out to the > > Radius server on port 1813. It's logging VPN connections, so the MySQL > > module has to be configured properly I would think. I used the schema in > > /src/modules/rlm_sql/drivers/rlm_sql_mysql/ and it imported the correct > > tables. Is there a line that I'm missing my sql.conf or does it look like > > something is screwy in the radiusd.conf itself possibly? > > No, you've probably got the SQL module pulling password information > out of the SQL database. That's OK. The problem is that you're not > telling the server what to *do* with that password. > > I would suggest setting somewhere (DEFAULT in 'users' file?): > > DEFAULT Auth-Type := Local > > Which tells the server to look for a password, and to authenticate > against PAP/CHAP/whatever internally. > > Alan DeKok.
Actually, after having another look i don't quite agree. The lines: Radius_xlat: '' Rlm_sql Reserving sql socket id: 4 MYSQL Error: Cannot get result MYSQL Error: Query was empty >From the first mail in the thread would indicate that, umm.. the query was empty. The message 'Query was empty' is, not very suprisingly exactly what libmysqlclient returns in mysql_error() for empty querys. An empty query won't return much in the way of anything. This looks like a messed up raddb/sql.conf , have you made any changes to the querys in there? Ofcourse, i could very well be way of :) -- Simon - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
