Setting up FreeRADIUS API for SAS PCE/SPE

RADIUS API requests radius client’s data from SAS PCE/SPE to dynamically update the clients in FreeRADIUS database.

In case of a fresh SafeNet server installation with MySQL database, RADIUS API encounters an issue with MySQL database (MySQL MySql.Data.EntityFramework.dll in GAC missing). It is a limitation of MySQL Connector 8.0.32.

Before installation, ensure that the following steps are performed:

1. After installing SafeNet server, install MySQL 8.0.32 Connector.

2. Configure SafeNet server with MySQL database.

Follow the steps:

For Windows Server 2012, 2012 R2, 2016, 2019, and 2022

1. Copy the following text in a text file and save the file in the .ps1 file format:

   #Note that you should be running PowerShell as an Administrator
   [System.Reflection.Assembly]::Load("System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")            
   $publish = New-Object System.EnterpriseServices.Internal.Publish            
   $publish.GacInstall("C:\Program Files (x86)\MySQL\MySQL Connector Net 8.0.32\Assemblies\v4.5.2\MySql.Data.EntityFramework.dll")
   # If installing into the GAC on a server hosting web applications in IIS, you need to restart IIS for the #applications to pick up the change.
   Iisreset
   

2. Run the .ps1 file, as an administrator in the PowerShell.

3. Reset IIS.

Points to Remember

• Default location:

  System Directory:\Program Files (x86)\MySQL\MySQL Connector Net 8.0.32\Assemblies\v4.5.2

• If someone changes the directory location while installing the MySQL Connector, the above path also needs to be updated in the script.

• Open the PowerShell script and change the path to where your DLL resides.