Re: rlm_sqlippool Oracle sql error : ORA-00907: missing right parenthesis

westwood wrote:

freeradius versions 2.1.8/9/10 + oracle 10.2.0 ... rlm_sql_oracle: query failed in sql_select_query: ORA-00907: missing right parenthesis

That's an Oracle error. The query is malformed.

i find the error occured when allocate-find executed in the file "sql/oracle/ippool.conf" , but this statement can work well in mysql.

Uh... you're using MySQL syntax for an Oracle server?

How can i make it works ?

Use Oracle SQL syntax. Alan DeKok.