As I understood, for authentication without accounting FreeRadius 0.8 with Oracle uses in minimal configuration:
- 5 tables (radcheck, radreply, radgroupcheck, radgroupreply, usergroup) and
- 4 SQL queries in file 'sql.conf' (authorize_check_query, authorize_reply_query, authorize_group_check_query, authorize_group_reply_query).
It is reasonable decision. But there are situation, when we need only 1 SQL query, or 2, or 3.
If I use only 1 SQL query (authorize_check_query) and comment other SQL queries, all works OK, CPU load is about 12%.
But each authentication request makes in log file 3 following records:
Mon Dec 2 16:53:37 2002 : Error: rlm_sql_oracle: prepare failed in sql_select_query: ORA-24373: invalid length specified for statement
Mon Dec 2 16:53:37 2002 : Error: rlm_sql_getvpdata: database query error
I think, that cause of it - commented SQL query. It does not create problems. FreeRadius 0.8 works stable.
From other side, each additional SQL query takes on my PC the additional 6% CPU load:
1 SQL query 12% CPU load,
2 SQL query 18% CPU load,
3 SQL query 24% CPU load,
4 SQL query 30% CPU load.
It seems to me, that it would be useful to have possibility to configure the number of SQL queries.
Because only to comment them is not enough.
Best regards,
Alexander Novoselsky
E-mail: [EMAIL PROTECTED]
