Hi All,
Here are just a few optimizations that you can do, in order to make
rlm_sql work faster with GnuGK:
a. The RadAcct tables are made of text fields, of type VARCHAR. If you
change those fields to CHAR, it will work much faster. After all,
Framed-IP-Address is always an IP, whose length is 15 chars max.
b. The result from authorize_check_query should always be of the following
form (when using GnuGK): [random_number],%{SQL-User-Name},"Password",%{SQL-User-Name},"op".
So if you are creating your own scheme to authorize remote IP addresses or remote
users, make sure you DON'T use the radacct table in your query, in order not
to make your Radius response too slugish.
c. If there are fields in the radacct table you don't use, remove them from
the scheme, and change the accounting_queries in sql.conf accordingly. No
use in storing useless information in the DB.
d. And most importantly - when authorizing requests, make sure you query
static tables, and not dynamic tables. In addition, don't get the radacct
table involved in the authorization process.
I've managed to increase the performance of FreeRadius with GnuGk by over
500% using these tips.
--
__________________________________________________________________
Nir Simionovich
IT Manager
m-Wise Ltd.
e-Mail: nirs@m-wise.com
cell: +972-54-482826
-------------------------------------------------------
This SF.net email is sponsored by: IBM Linux Tutorials.
Become an expert in LINUX or just sharpen your skills. Sign up for IBM's
Free Linux Tutorials. Learn everything from the bash shell to sys admin.
Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click
_______________________________________________
List: Openh323gk-users@lists.sourceforge.net
Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549
Homepage: http://www.gnugk.org/
