Re: All sockets are being used!
Gillou [EMAIL PROTECTED] wrote: I have the same problem as Tim : Error: rlm_sql: All sockets are being used! but increasing the value of num_sql_socks didn't help. I've increased it reaching 1024 (default = 5). Freeradius take longer to tell me that all socket are used but they are all used nevertheless. So find out *why* all of the sockets are being used. Increasing the number of allowed sockets just works around the problem. What's *probably* happening is that the SQL server is taking a long time to respond. So every radius request takes 3-4 second longer than normal, due to SQL. If you get 100's of requests per second, then you will run out of sockets quickly. Have you indexed your SQL tables? How long does it take to do the queries when you run in debug mode, and send it test packets? Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: All sockets are being used!
Well, I thought that as well, and I honestly havent *seen* that message since I wrote that original email. My sql server is on a box by itself, no web servers, etc running with it. Its a 1.2 intel machine with barracuda scsi drives so its a decent box , Its answering querys in about .03 seconds on the average during tests I have done during peak times. My radcheck table is only about 400 users deep. The only thing I can think is that possibly it gets hit in short spurts all at once and this may use up some sockets. BTW, Its it normal for the radius server to start up 5 processes on the system when it starts? I dont remember the last version doing that. Thanks Again Tim The following message was sent by Alan DeKok [EMAIL PROTECTED] on Sat, 16 Feb 2002 09:54:46 -0500. Gillou [EMAIL PROTECTED] wrote: I have the same problem as Tim : Error: rlm_sql: All sockets are being used! but increasing the value of num_sql_socks didn't help. I've increased it reaching 1024 (default = 5). Freeradius take longer to tell me that all socket are used but they are all used nevertheless. So find out *why* all of the sockets are being used. Increasing the number of allowed sockets just works around the problem. What's *probably* happening is that the SQL server is taking a long time to respond. So every radius request takes 3-4 second longer than normal, due to SQL. If you get 100's of requests per second, then you will run out of sockets quickly. Have you indexed your SQL tables? How long does it take to do the queries when you run in debug mode, and send it test packets? Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html . - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: All sockets are being used!
What's *probably* happening is that the SQL server is taking a long time to respond. So every radius request takes 3-4 second longer than normal, due to SQL. If you get 100's of requests per second, then you will run out of sockets quickly. You're right, the server take a long time to respond ! And even with only 2 or 3 radius request per second, the SQL server can't answer to radius needs ! Have you indexed your SQL tables? How long does it take to do the queries when you run in debug mode, and send it test packets? In debug mode, it can take up to 8 second to answer. This happen because i do a lot of extraction on the SQL server. To solve the problem, I install another SQL server with SQL replication to the server where i do a lot of SQL query. Now freeradius-snapshot-20020215 doesn't complaint with socket :o) Freeradius is the best free radius server. Thanks everybody for your help - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: All sockets are being used!
icrease the value of num_sql_socks variable in sql.conf file. From: Tim Monaghan [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: FREE RADIUS [EMAIL PROTECTED] Subject: All sockets are being used! Date: Fri, 15 Feb 2002 13:05:08 -0600 Fri Feb 15 07:08:45 2002 : Error: rlm_sql: All sockets are being used! Please increase the maximum number of sockets! Any ideas on this one? Its not refering to unix sockets is it? Thanks alot! Tim . - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html