RE: sql: ERROR: rlm_sql_oracle: ORA-01403: no data found
No answer anymore ? For refresh, my radius 3.0.11 server works perfectly except unjustified errors ORA-01403 each time that authorize_check_query is executed. However, query is still nicely executed, as radius server always take good decisions depending the result of the query. Regards, Vincent.
On Feb 15, 2016, at 11:23 AM, Vincent MARCEL <Vincent.MARCEL@monext.net> wrote:
No answer anymore ?
We answered this many times. If you don't believe us, that's not a problem we can solve. Alan DeKok.
We answered this many times. If you don't believe us, that's not a problem we can solve.
Alan DeKok. No you did not answer, you just have said that I'm lying when I say that my query returns data. But I'm not and I have proved it. You don't argue nor try to search where the problem could be when I'm just asking help respectfully. I'm sorry but but this is narrow minded and supercilious. Generating a "no data found" error whenever data is returned or not don't have any sense when it is not mandatory that authorize_check_query returns data. The problem might be elsewhere, maybe it is not related to authorize_check_query ...
On Feb 16, 2016, at 5:01 AM, Vincent MARCEL <Vincent.MARCEL@monext.net> wrote:
No you did not answer, you just have said that I'm lying when I say that my query returns data.
Stop your personal attacks or you will be unsubscribed from the list, and permanently banned. As I've said repeatedly, the error is being returned from Oracle. No amount of poking FreeRADIUS can fix the error. Blame Oracle for an Oracle error.
But I'm not and I have proved it. You don't argue nor try to search where the problem could be when I'm just asking help respectfully.
I told you where the problem is. You don't believe me. That's not my problem,
I'm sorry but but this is narrow minded and supercilious.
Stop the personal attacks, or you will be unsubscribed from the list and permanently banned.
Generating a "no data found" error whenever data is returned or not don't have any sense when it is not mandatory that authorize_check_query returns data. The problem might be elsewhere, maybe it is not related to authorize_check_query ...
The problem is Oracle. Stop complaining about the problem here. Or you will be unsubscribed from the list, and permanently banned. Alan DeKok.
On 16 Feb 2016, at 10:01, Vincent MARCEL <Vincent.MARCEL@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. Regards, 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.
participants (3)
-
Adam Bishop -
Alan DeKok -
Vincent MARCEL