> -----Original Message-----
> From: Chris Parker [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, November 26, 2002 7:47 PM
> To: [EMAIL PROTECTED]
>
> > > Maybe they cache the responses from Oracle. Look at the queries they do to Oracle, to see what's going on.
> >May be. But OpenRADIUS and Navis Radius use simple SQL queries: "SELECT password FROM users WHERE username = ?".
> >It seems to me, in FreeRadius 0.8 SQL query is not configurable parameter.
> >But FreeRadius 0.7.1 used almost the same SQL query (it was in file sql.conf).
>
> Nope, you can edit the queries in 'sql.conf' for all versions of FreeRADIUS.
> Try editing it and see what it does to the performance. A simpler
> query ( assuming properly indexed tables, etc ) should return faster.
Thank you for advice, Chris.
I tried to leave in file 'sql.conf' only 1 line with SELECT:
authorize_check_query = "SELECT id,UserName,Attribute,Value,op FROM ${authcheck_table} WHERE Username = '%{SQL-User-Name}' ORDER BY id"
It improved results: instead of 25-30% CPU load, now works with Oracle takes 15-20% CPU load.
May be, source of my problem was so. I filled only table 'radcheck', but left in file 'sql.conf' all SQL queries, which tried to search in empty tables.
Best regards,
Alexander Novoselsky, Programmer
E-mail: [EMAIL PROTECTED]
