Need help with install on a new server php 8.2, mariadb 10.6, galera, proxysql

[Rno]

Hello,
I try to setup my new cacti setup.
It will be composed of
2 mariadb 10.6 in cluster configuration with galera (this part is working 100%)
a front-end for cacti using almalinux 4.18, php 8.2

And i try to setup the php setup, I follow the php install I find into the docs/Install-Under-CentOS_LAMP.html
and the php part is:
yum install -y php php-common php-bcmath php-cli \
php-mysqlnd php-gd php-gmp php-intl \
php-json php-ldap php-mbstring \
php-pdo php-pear php-snmp php-process \
php-xml php-zip
All installed

And I'm still getting this error on the web server:

Code: Select all

FATAL: Connection to Cacti database failed. Please ensure:

    the PHP MySQL module is installed and enabled.
    the database is running.
    the credentials in config.php are valid.
    

I know the access to the DB is working, I was able to setup the cacti table, with the cacti user defined inside the config.php.

The cacti.log give me this:

Code: Select all

PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/mysqli.so' (tried: /usr/lib64/php/modules/mysqli.so (/usr/lib64/php/modules/mysqli.so: undefined symbol: mysqlnd_global_stats), /usr/lib64/php/modules//usr/lib64/php/modules/mysqli.so.so (/usr/lib64/php/modules//usr/lib64/php/modules/mysqli.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'pdo_mysql' (tried: /usr/lib64/php/modules/pdo_mysql (/usr/lib64/php/modules/pdo_mysql: cannot open shared object file: No such file or directory), /usr/lib64/php/modules/pdo_mysql.so (/usr/lib64/php/modules/pdo_mysql.so: undefined symbol: mysqlnd_get_client_info)) in Unknown on line 0

the 2 files are there:

Code: Select all

ls -l /usr/lib64/php/modules/mysqli.so
-rwxr-xr-x. 1 root root 167624 Sep 26 14:18 /usr/lib64/php/modules/mysqli.so
 ls -l /usr/lib64/php/modules/pdo_mysql.so
-rwxr-xr-x. 1 root root 33680 Sep 26 14:18 /usr/lib64/php/modules/pdo_mysql.so

The php -m give me:

Code: Select all

[PHP Modules]
bcmath
bz2
calendar
Core
ctype
curl
date
dom
exif
fileinfo
filter
ftp
gd
gettext
gmp
hash
iconv
intl
json
ldap
libxml
mbstring
mysqli
mysqlnd
openssl
pcntl
pcre
PDO
pdo_mysql
pdo_sqlite
Phar
posix
random
readline
Reflection
session
shmop
SimpleXML
snmp
sockets
sodium
SPL
sqlite3
standard
sysvmsg
sysvsem
sysvshm
tokenizer
xml
xmlreader
xmlwriter
xsl
Zend OPcache
zip
zlib

[Zend Modules]
Zend OPcache

I can't find what to do, so any clue link idea is welcome.

[TheWitness]

Well, the PHP package is php-mysqlnd and you seem to have a half pregnant php-mysqli. So, this looks to be a packaging error. You might want to uninstall php-mysqli if installed. Here is my setup. I'm using the Remi repos as he's doing a great job with packaging.

Code: Select all

[root@vmhost5 ~]# rpm -qa | grep "php-"
php-8.2.10-1.el7.remi.x86_64
oniguruma5php-6.9.8-1.el7.remi.x86_64
php-intl-8.2.10-1.el7.remi.x86_64
php-gd-8.2.10-1.el7.remi.x86_64
php-fpm-8.2.10-1.el7.remi.x86_64
gd3php-2.3.3-7.el7.remi.x86_64
php-pear-1.10.13-5.el7.remi.noarch
php-xml-8.2.10-1.el7.remi.x86_64
php-sodium-8.2.10-1.el7.remi.x86_64
php-gmp-8.2.10-1.el7.remi.x86_64
php-process-8.2.10-1.el7.remi.x86_64
php-mbstring-8.2.10-1.el7.remi.x86_64
php-cli-8.2.10-1.el7.remi.x86_64
php-ldap-8.2.10-1.el7.remi.x86_64
php-snmp-8.2.10-1.el7.remi.x86_64
php-pdo-8.2.10-1.el7.remi.x86_64
php-common-8.2.10-1.el7.remi.x86_64
php-mysqlnd-8.2.10-1.el7.remi.x86_64