You first have to install the devel packages for unixodbc, then add a line in rawopts file and rebuild Apache+PHP.
1. Install the UnixODBC devel packages:
yum install unixODBC unixODBC-devel
2. You now need to create a file “all_php7″ to add a line to enable odbc so that apache build will pick it up from there. File all_php5 is for PHP7 and all_php8 is for PHP8.
nano /var/cpanel/easy/apache/rawopts/all_php73. Add the following line:
–with-unixODBC=/usr
4. Rebuild Apache/PHP using the “easyapache” script and the above file will be picked up automatically:
/scripts/easyapache
Once the compilation completes, you should have odbc module compiled with PHP. You can check the module either using a phpinfo() file OR through shell by executing:
php -i | grep odbc