sql: ERROR: rlm_sql_oracle: ORA-01403: no data found

Adam Bishop Adam.Bishop at jisc.ac.uk
Tue Feb 16 15:54:11 CET 2016

On 16 Feb 2016, at 10:01, Vincent MARCEL <Vincent.MARCEL at monext.net> wrote:
> But I'm not and I have proved it.

You have not. You've shown two different results, doing two different things. That's not proof, nor a surprise. Database servers are complex beasts, and there are a hundred places queries can be denied, including different user accounts, IP addresses, and even the time of day.

Proof would be a packet capture showing the database server sending the rows over the network to the RADIUS server in response to that query, and not Oracle's "No Rows Returned" error code.

Proof would be logs from the Oracle database server showing the incoming query and any returned data.

Personally, if it were me, I'd avoid wasting my time on either of those though and just fix my database server.


Adam Bishop

  gpg: 0x6609D460

jisc.ac.uk | Networkshop 44: Save the date!
           | 22-24 March 2016 @ University of Manchester

Jisc is a registered charity (number 1149740) and a company limited by guarantee which is registered in England under Company No. 5747339, VAT No. GB 197 0632 86. Jisc’s registered office is: One Castlepark, Tower Hill, Bristol, BS2 0JA. T 0203 697 5800.

Jisc Services Limited is a wholly owned Jisc subsidiary and a company limited by guarantee which is registered in England under company number 2881024, VAT number GB 197 0632 86. The registered office is: One Castle Park, Tower Hill, Bristol BS2 0JA. T 0203 697 5800.  

More information about the Freeradius-Users mailing list