Question about WARNING in rlm_sql_mysql
Hello all, Can somebody shed some light what the 'You probably need to lower "min"' means. I just installed fresh freeradius from git. All my settings are the same as in the last version but apart from the radiusd -X not working (but the radiusd -lxx -l stdout is) radius.log displays this warning about lowering number of sql connections. Can anybody give some advice?? Regards, Krzysztof
On Tue, Jan 31, 2012 at 4:31 PM, Krzysztof Grobelak <kgrobelak@airspeed.ie> wrote:
Hello all,
Can somebody shed some light what the 'You probably need to lower "min"' means. I just installed fresh freeradius from git. All my settings are the same as in the last version but apart from the radiusd -X not working
Which part is "not working"?
(but the radiusd -lxx -l stdout is) radius.log displays this warning about lowering number of sql connections.
Can anybody give some advice??
"git blame" and "git show" to the rescue :) $ git show a966a18e commit a966a18e757bff638bbf725d6f9150b5026fe07d Author: Alan T. DeKok <aland@freeradius.org> Date: Sun Nov 6 11:02:44 2011 +0100 Print WARNING if we fall below "min" connections We want to close idle sessions, sessions with max lifetime or max uses. BUT we want to enforce "min". The code will currently close a connection, notice "num < min", and spawn a new one. We warn the user that this is happening, so that they can fix their configuration. -- Fajar
Krzysztof Grobelak wrote:
Can somebody shed some light what the 'You probably need to lower "min"' means.
See raddb/modules/sql in the latest "git" repository. The values and functionality are documented there.
I just installed fresh freeradius from git. All my settings are the same as in the last version but apart from the radiusd -X not working (but the radiusd -lxx -l stdout is) radius.log displays this warning about lowering number of sql connections.
Can anybody give some advice??
Try lowering the minimum number of connections? Alan DeKok.
On 31/01/12 09:47, Alan DeKok wrote:
Krzysztof Grobelak wrote:
Can somebody shed some light what the 'You probably need to lower "min"' means. See raddb/modules/sql in the latest "git" repository. The values and functionality are documented there.
I just installed fresh freeradius from git. All my settings are the same as in the last version but apart from the radiusd -X not working (but the radiusd -lxx -l stdout is) radius.log displays this warning about lowering number of sql connections.
Can anybody give some advice?? Try lowering the minimum number of connections?
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html Thanks for the reply.
I did lower it, as it recommends but i did not have to do it in previous versions and I wanted to understand what has changed in the new release. And thanks for handy git commands Fajar. The radiusd -X command does not start the debug. It advises to use the radiusd -lxx -l stdout command to start it. I thought that freeradius is compiled with threads usage by default. Regards, Krzysztof
Krzysztof Grobelak wrote:
I did lower it, as it recommends but i did not have to do it in previous versions and I wanted to understand what has changed in the new release.
Read raddb/mods-available/sql Really. You managed to edit that file. This means you saw the comments in that file describing what changed.
And thanks for handy git commands Fajar. The radiusd -X command does not start the debug. It advises to use the radiusd -lxx -l stdout command to start it. I thought that freeradius is compiled with threads usage by default.
Yes, it is. But debug mode is single threaded. And if you want to use radsec, you MUST use threaded mode for debugging. The message describes what to do. If you don't use radsec, then delete raddb/sites-enabled/tls Alan DeKok.
participants (3)
-
Alan DeKok -
Fajar A. Nugraha -
Krzysztof Grobelak