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 2500 subscribers. I was thinking about increasing the number of sql connections, which is set to 4, would it make any difference? Database server load: load averages: 1.10, 1.05, 1.03 Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Thanks in advance.
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.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 2500 subscribers. I was thinking about increasing the number of sql connections, which is set to 4, would it make any difference?
Database server load: load averages: 1.10, 1.05, 1.03
Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Thanks in advance.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
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 2500 subscribers. I was thinking about increasing the number of sql connections, which is set to 4, would it make any difference?
Database server load: load averages: 1.10, 1.05, 1.03
Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
load is > 1.0 which actually means the server is busy. its 'above normal' - certainly not 'low'. In the first instance , I would suggest that you increase number of connections to the SQL to at least 10. secondly, add some indexes to the tables - find what your queries are and then use 'explain' to check that those queries are using nice index values and not having to trawl through all records for each query. finally update the database engine to InnoDB rather than the defauly MyISAM. that will improve things alan
2012/8/13 alan buxey <A.L.M.Buxey@lboro.ac.uk>
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 2500 subscribers. I was thinking about increasing the number of sql connections, which is set to 4, would it make any difference?
Database server load: load averages: 1.10, 1.05, 1.03
Error: rlm_sql (sql): There are no DB handles to use! skipped 0,
tried
to connect 0
load is > 1.0 which actually means the server is busy. its 'above normal' - certainly not 'low'.
In the first instance , I would suggest that you increase number of connections to the SQL to at least 10. secondly, add some indexes to the tables - find what your queries are and then use 'explain' to check that those queries are using nice index values and not having to trawl through all records for each query. finally update the database engine to InnoDB rather than the defauly MyISAM.
that will improve things
alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
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 simply given up. I'm thinking about making a backup of this table and truncating it. As it's not possible for us to wait so long to alter the table engine (We don't have backup yet). Thanks a lot.
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 simply given up.
Why alter the engine? Just create a table on the new system, with the new engine. Then, import the old data. If you have data going back years, you're better off just starting over. All old data stays on the old machine, and new data goes to the new machine.
I'm thinking about making a backup of this table and truncating it. As it's not possible for us to wait so long to alter the table engine (We don't have backup yet).
That's a problem. Alan DeKok.
2012/8/13 Alan DeKok <aland@deployingradius.com>
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 simply given up.
Why alter the engine? Just create a table on the new system, with the new engine. Then, import the old data.
If you have data going back years, you're better off just starting over. All old data stays on the old machine, and new data goes to the new machine.
I'm thinking I'll let on radacct just the rows for active sections, and put the old acct data in a separate database. That's a lot of old radacct data.
I'm thinking about making a backup of this table and truncating it. As it's not possible for us to wait so long to alter the table engine (We don't have backup yet).
That's a problem.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
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 <modesto@isimples.com.br> 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 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 2500 subscribers. I was thinking about increasing the number of sql connections, which is set to 4, would it make any difference?
Database server load: load averages: 1.10, 1.05, 1.03
Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Thanks in advance.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Regards, Chris Knipe
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 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 2500 subscribers. I was thinking about increasing the number of sql connections, which is set to 4, would it make any difference?
Database server load: load averages: 1.10, 1.05, 1.03
Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Thanks in advance.
------------------------------------------------------------------------
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (6)
-
alan buxey -
Alan DeKok -
Antonio Modesto -
Chris Knipe -
Iliya Peregoudov -
Marinko Tarlać