Re: Radius server setup

From: Jared Still <jkstill@xxxxxxxxx>
To: leroy.kemnitz@xxxxxxxxxxxxxxxxxx
Date: Tue, 9 Feb 2021 07:09:43 -0800

These blogs may be of interest to you

https://blog.pythian.com/using-freeradius-to-authorize-oracle-connections/

https://blog.pythian.com/oracle-database-and-two-factor-authentication-2fa/

On Wed, Feb 3, 2021 at 09:47 Kemnitz, LeRoy <
leroy.kemnitz@xxxxxxxxxxxxxxxxxx> wrote:

Hello –

I am trying to setup a Radius server for the 1st time for my database.

I am running Oracle database 12.1 on Linux 6.  I have a Radius server
setup on a separate server.  I have updated my sqlnet,ora to start to use
the Radius server for logins.  I was also using the Oracle Unified
Directory (OUD) for authentication up to this point.  I want to now switch
over to use the Radius server which pulls the users from OUD.

I run the command line test using ‘radtest’, which is successful.  I then
run a test from the database, but it fails with ‘Invalid username/password’
error.  My network guy was able to tell me that the instance is sending the
login attempt to the OUD, and not to the Radius server.  This frustrating
to me since have updated sqlnet.ora file define the Radius server ip
address.

Any ideas about what else to check???  Has anyone else experienced this
before?  How did you fix it?

LeRoy

*LeRoy Kemnitz *Database Administrator

Office of Technology Services

780 Regent Street, Madison, WI 53715
<https://www.google.com/maps/search/780+Regent+Street,+Madison,+WI+53715?entry=gmail&source=g>
608-265-5775 | wisconsin.edu <https://www.wisconsin.edu/>

[image: UW System Logo]

[image: All In Wisconsin]

[image: signature_1705595041] <https://twitter.com/uwsystem>

[image: signature_1504484223] <https://www.facebook.com/uwsystem>

References:
- Radius server setup
  - From: Kemnitz, LeRoy

Re: Radius server setup

Other related posts: