i write a module ,but when freeradius run for a while with it enable ,"no DB handles to use" come up to me...,I don't know why and how to solve this problem (In my module ,i use the sql api in rlm_sqlippool to communicate with sql ,and release after i have use the API)
but there is not much data in it ,and it performance well when i has tested it without the new module by stress-testing 。 is there any other facts? 2010/11/25 Alan DeKok <aland@deployingradius.com>
westwood wrote:
i write a module ,but when freeradius run for a while with it enable ,"no DB handles to use" come up to me...,I don't know why and how to solve this problem
The database is too slow. Use indexes, or delete old data from it.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/devel.html
You can also increase the value of "num_sql_socks" in "sql.conf". Chris westwood wrote:
but there is not much data in it ,and it performance well when i has tested it without the new module by stress-testing 。 is there any other facts?
2010/11/25 Alan DeKok <aland@deployingradius.com <mailto:aland@deployingradius.com>>
westwood wrote: > i write a module ,but when freeradius run for a while with it enable > ,"no DB handles to use" come up to me...,I don't know why and how to > solve this problem
The database is too slow. Use indexes, or delete old data from it.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/devel.html
------------------------------------------------------------------------
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/devel.html
it has no effect when the freeradius runs for a long time..... 2010/11/25 Chris Moules <chris@gms.lu>
You can also increase the value of "num_sql_socks" in "sql.conf".
Chris
but there is not much data in it ,and it performance well when i has tested it without the new module by stress-testing 。 is there any other facts?
2010/11/25 Alan DeKok <aland@deployingradius.com <mailto:aland@deployingradius.com>>
westwood wrote: > i write a module ,but when freeradius run for a while with it enable > ,"no DB handles to use" come up to me...,I don't know why and how to > solve this problem
The database is too slow. Use indexes, or delete old data from it.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/devel.html
------------------------------------------------------------------------
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/devel.html
westwood wrote: - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/devel.html
your module is not releasing the db handles _____ De: freeradius-devel-bounces+lscrlstld=gmail.com@lists.freeradius.org [mailto:freeradius-devel-bounces+lscrlstld=gmail.com@lists.freeradius.org] Em nome de westwood Enviada em: quinta-feira, 25 de novembro de 2010 11:51 Para: FreeRadius developers mailing list Assunto: Re: no DB handles to use but there is not much data in it ,and it performance well when i has tested it without the new module by stress-testing 。 is there any other facts? 2010/11/25 Alan DeKok <aland@deployingradius.com> westwood wrote:
i write a module ,but when freeradius run for a while with it enable ,"no DB handles to use" come up to me...,I don't know why and how to solve this problem
The database is too slow. Use indexes, or delete old data from it. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/devel.html
i fell i have released it ... i use the oracle, and after i jave used the socket create by "data->sql_inst->sql_get_socket" , i will use " data->sql_inst->sql_release_socket(data->sql_inst, sqlsocket);" to release it , is there any other API i must use to release or any other facts can result in this problem? 2010/11/25 Toledo, Luis Carlos <lscrlstld@gmail.com>
your module is not releasing the db handles
------------------------------
*De:* freeradius-devel-bounces+lscrlstld=gmail.com@lists.freeradius.org[mailto: freeradius-devel-bounces+lscrlstld <freeradius-devel-bounces%2Blscrlstld>= gmail.com@lists.freeradius.org] *Em nome de *westwood *Enviada em:* quinta-feira, 25 de novembro de 2010 11:51 *Para:* FreeRadius developers mailing list *Assunto:* Re: no DB handles to use
but there is not much data in it ,and it performance well when i has tested it without the new module by stress-testing 。 is there any other facts?
2010/11/25 Alan DeKok <aland@deployingradius.com>
westwood wrote:
i write a module ,but when freeradius run for a while with it enable ,"no DB handles to use" come up to me...,I don't know why and how to solve this problem
The database is too slow. Use indexes, or delete old data from it.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/devel.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/devel.html
yes , i finnal found the problem. I haven't release the socket handle in another module..... thanks 2010/11/25 Toledo, Luis Carlos <lscrlstld@gmail.com>
your module is not releasing the db handles
------------------------------
*De:* freeradius-devel-bounces+lscrlstld=gmail.com@lists.freeradius.org[mailto: freeradius-devel-bounces+lscrlstld <freeradius-devel-bounces%2Blscrlstld>= gmail.com@lists.freeradius.org] *Em nome de *westwood *Enviada em:* quinta-feira, 25 de novembro de 2010 11:51 *Para:* FreeRadius developers mailing list *Assunto:* Re: no DB handles to use
but there is not much data in it ,and it performance well when i has tested it without the new module by stress-testing 。 is there any other facts?
2010/11/25 Alan DeKok <aland@deployingradius.com>
westwood wrote:
i write a module ,but when freeradius run for a while with it enable ,"no DB handles to use" come up to me...,I don't know why and how to solve this problem
The database is too slow. Use indexes, or delete old data from it.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/devel.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/devel.html
participants (4)
-
Alan DeKok -
Chris Moules -
Toledo, Luis Carlos -
westwood