Re: rlm_sql Error

2012-08-14 Thread Iliya Peregoudov
Hello Antonio, rlm_sql does not wait for connection from connection pool to become available. If all connections are busy the module just return fail. You can avoid these spurious failures if you set num_sql_socks equal to max_servers. Antonio Modesto wrote: Hi, Here in the ISP which I

Re: rlm_sql Error

2012-08-13 Thread Antonio Modesto
2012/8/13 Alan DeKok > Antonio Modesto wrote: > > My tables is using MyISAM engine, as this server is running freeradius > > 1.X, it's quite old. The problem is that I've dumped my database to > > another server to do some tests, and tried to alter the engine to see > > how long it would take, af

Re: rlm_sql Error

2012-08-13 Thread Alan DeKok
Antonio Modesto wrote: > My tables is using MyISAM engine, as this server is running freeradius > 1.X, it's quite old. The problem is that I've dumped my database to > another server to do some tests, and tried to alter the engine to see > how long it would take, after some hours running I've simpl

Re: rlm_sql Error

2012-08-13 Thread Antonio Modesto
2012/8/13 alan buxey > Hi, > > > Here in the ISP which I work we have a Freeradius 1.X in > production, and > > a 2.X that we're testing to replace the old one. On both Radius we > get > > the following error sometimes, What can be causing this? The SQL > > Database is in the

Re: rlm_sql Error

2012-08-13 Thread alan buxey
Hi, > Here in the ISP which I work we have a Freeradius 1.X in production, and > a 2.X that we're testing to replace the old one. On both Radius we get > the following error sometimes, What can be causing this? The SQL > Database is in the same server of freeradius 1.X, but the

Re: rlm_sql Error

2012-08-13 Thread Chris Knipe
sql.conf: # number of sql connections to make to server num_sql_socks = 5 You prob need to up this. On Mon, Aug 13, 2012 at 3:00 PM, Antonio Modesto wrote: > > Hi, > > > Here in the ISP which I work we have a Freeradius 1.X in production, and a > 2.X that we're testing to replac

Re: rlm_sql Error

2012-08-13 Thread Marinko Tarlać
> would it make any difference? It won't help in case you have x trillion records in radacct table and this table is MyISAM, used for simult. login detection, etc... On 13.8.2012 15:00, Antonio Modesto wrote: Hi, Here in the ISP which I work we have a Freeradius 1.X in production, and a 2

rlm_sql Error

2012-08-13 Thread Antonio Modesto
Hi, Here in the ISP which I work we have a Freeradius 1.X in production, and a 2.X that we're testing to replace the old one. On both Radius we get the following error sometimes, What can be causing this? The SQL Database is in the same server of freeradius 1.X, but the load is low, we have about

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

2010-04-23 Thread Alan DeKok
VU VAN HUNG wrote: > How do I make NAS send User-Password or CHAP-Password attribute ? Read the NAS documentation. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

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

2010-04-23 Thread VU VAN HUNG
szymon roczniak wrote: In order to have PAP or CHAP working you need your NAS to send either User-Password or CHAP-Password attribute. If you look at your log file again you'll see that both the pap and the chap module return noop, this is because these attributes are not present in the query.

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

2010-04-23 Thread szymon roczniak
On Fri, Apr 23, 2010 at 03:22:44PM +0700, VU VAN HUNG wrote: > szymon roczniak wrote: > > 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 edited some columns' name in radius database, so

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

2010-04-23 Thread VU VAN HUNG
szymon roczniak wrote: 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:

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

2010-04-22 Thread szymon roczniak
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 i

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

2010-04-22 Thread VU VAN HUNG
szymon roczniak wrote: 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 (

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

2010-04-22 Thread szymon roczniak
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 > ( '%{

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

2010-04-22 Thread VU VAN HUNG
Hi all, This is my first post. I'm trying to make a AAA server based on freeRadius and MySQL. After I configure radius server and run server in debug mode, I get some problem with rlm_sql about User-Password and Chap-Password. It seems that the server can't expand User-Password and Chap-Passw

Re: rlm_sql error in pre2

2007-09-12 Thread Norbert Wegener
My first tests indicate, that it seems to work. Thank you. Norbert Wegener Alan DeKok wrote: Norbert Wegener wrote: In some cases I do not have the need to query for groupmembership. When I undefine group_membership_query, I get the following error: Please do "cvs update", rebuild,

Re: rlm_sql error in pre2

2007-09-11 Thread Alan DeKok
Norbert Wegener wrote: > In some cases I do not have the need to query for groupmembership. > When I undefine group_membership_query, I get the following error: Please do "cvs update", rebuild, and test. If you undefined the groupmembership query, it should now simply not match. Alan DeKok

rlm_sql error in pre2

2007-09-07 Thread Norbert Wegener
In some cases I do not have the need to query for groupmembership. When I undefine group_membership_query, I get the following error: rlm_sql (voipsipsql): Error retrieving group list^M rlm_sql (voipsipsql): Error processing groups; rejecting user Maybe an information about the non availability

Re: rlm_sql error

2004-10-06 Thread Alan DeKok
Edgars <[EMAIL PROTECTED]> wrote: > what could cause such errors appear? > > Wed Oct 6 15:22:25 2004 : Error: rlm_sql (sql): failed after re-connect > Wed Oct 6 15:22:25 2004 : Error: rlm_sql_getvpdata: database query error > Wed Oct 6 15:22:25 2004 : Error: No memory A memory leak, I guess.

rlm_sql error

2004-10-06 Thread Edgars
Hello, what could cause such errors appear? Wed Oct 6 15:22:25 2004 : Error: rlm_sql (sql): failed after re-connect Wed Oct 6 15:22:25 2004 : Error: rlm_sql_getvpdata: database query error Wed Oct 6 15:22:25 2004 : Error: No memory Wed Oct 6 15:22:25 2004 : Auth: Login OK: [edgars/] (from clien