How To Install freeradius-postgresql on CentOS 8

freeradius-postgresql is Postgresql support for freeradius

Introduction

In this tutorial we learn how to install freeradius-postgresql on CentOS 8.

What is freeradius-postgresql

This plugin provides the postgresql support for the FreeRADIUS server project.

We can use yum or dnf to install freeradius-postgresql on CentOS 8. In this tutorial we discuss both methods but you only need to choose one of method to install freeradius-postgresql.

Install freeradius-postgresql on CentOS 8 Using dnf

Update yum database with dnf using the following command.

sudo dnf makecache --refresh

The output should look something like this:

CentOS Linux 8 - AppStream                                       43 kB/s | 4.3 kB     00:00    
CentOS Linux 8 - BaseOS                                          65 kB/s | 3.9 kB     00:00    
CentOS Linux 8 - ContinuousRelease                               43 kB/s | 3.0 kB     00:00    
CentOS Linux 8 - Extras                                          23 kB/s | 1.5 kB     00:00    
CentOS Linux 8 - FastTrack                                       40 kB/s | 3.0 kB     00:00    
CentOS Linux 8 - HighAvailability                                36 kB/s | 3.9 kB     00:00    
CentOS Linux 8 - Plus                                            24 kB/s | 1.5 kB     00:00    
CentOS Linux 8 - PowerTools                                      50 kB/s | 4.3 kB     00:00    
Extra Packages for Enterprise Linux Modular 8 - x86_64           13 kB/s | 9.2 kB     00:00    
Extra Packages for Enterprise Linux 8 - x86_64                   24 kB/s | 8.5 kB     00:00    
Metadata cache created.

After updating yum database, We can install freeradius-postgresql using dnf by running the following command:

sudo dnf -y install freeradius-postgresql

Install freeradius-postgresql on CentOS 8 Using yum

Update yum database with yum using the following command.

sudo yum makecache --refresh

The output should look something like this:

CentOS Linux 8 - AppStream                                       43 kB/s | 4.3 kB     00:00    
CentOS Linux 8 - BaseOS                                          65 kB/s | 3.9 kB     00:00    
CentOS Linux 8 - ContinuousRelease                               43 kB/s | 3.0 kB     00:00    
CentOS Linux 8 - Extras                                          23 kB/s | 1.5 kB     00:00    
CentOS Linux 8 - FastTrack                                       40 kB/s | 3.0 kB     00:00    
CentOS Linux 8 - HighAvailability                                36 kB/s | 3.9 kB     00:00    
CentOS Linux 8 - Plus                                            24 kB/s | 1.5 kB     00:00    
CentOS Linux 8 - PowerTools                                      50 kB/s | 4.3 kB     00:00    
Extra Packages for Enterprise Linux Modular 8 - x86_64           13 kB/s | 9.2 kB     00:00    
Extra Packages for Enterprise Linux 8 - x86_64                   24 kB/s | 8.5 kB     00:00    
Metadata cache created.

After updating yum database, We can install freeradius-postgresql using yum by running the following command:

sudo yum -y install freeradius-postgresql

How To Uninstall freeradius-postgresql on CentOS 8

To uninstall only the freeradius-postgresql package we can use the following command:

sudo dnf remove freeradius-postgresql

freeradius-postgresql Package Contents on CentOS 8

/etc/raddb/mods-config/sql/counter/postgresql
/etc/raddb/mods-config/sql/counter/postgresql/dailycounter.conf
/etc/raddb/mods-config/sql/counter/postgresql/expire_on_login.conf
/etc/raddb/mods-config/sql/counter/postgresql/monthlycounter.conf
/etc/raddb/mods-config/sql/counter/postgresql/noresetcounter.conf
/etc/raddb/mods-config/sql/cui/postgresql
/etc/raddb/mods-config/sql/cui/postgresql/queries.conf
/etc/raddb/mods-config/sql/cui/postgresql/schema.sql
/etc/raddb/mods-config/sql/ippool/postgresql
/etc/raddb/mods-config/sql/ippool/postgresql/procedure.sql
/etc/raddb/mods-config/sql/ippool/postgresql/queries.conf
/etc/raddb/mods-config/sql/ippool/postgresql/schema.sql
/etc/raddb/mods-config/sql/main/postgresql
/etc/raddb/mods-config/sql/main/postgresql/extras
/etc/raddb/mods-config/sql/main/postgresql/extras/cisco_h323_db_schema.sql
/etc/raddb/mods-config/sql/main/postgresql/extras/voip-postpaid.conf
/etc/raddb/mods-config/sql/main/postgresql/queries.conf
/etc/raddb/mods-config/sql/main/postgresql/schema.sql
/etc/raddb/mods-config/sql/main/postgresql/setup.sql
/usr/lib/.build-id
/usr/lib/.build-id/cf
/usr/lib/.build-id/cf/1f2e610cb81d2e882c16f78463cf4e8d22bc57
/usr/lib64/freeradius/rlm_sql_postgresql.so

References

Summary

In this tutorial we learn how to install freeradius-postgresql on CentOS 8 using yum and dnf.