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

Post support questions that directly relate to Linux/Unix operating systems.

Moderators: Developers, Moderators

Post Reply
Rno
Cacti Pro User
Posts: 704
Joined: Wed Dec 07, 2011 9:19 am

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

Post by 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.
Test
Almalinux
php 8.2.14
mariadb 10.6.16
Cacti 1.2.27
Spine 1.2.27
RRD 1.7.2
thold 1.8
monitor 2.5
syslog 3.2
flowview: 3.3
weathermap 1.0 Beta
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

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

Post by 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
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Post Reply

Who is online

Users browsing this forum: No registered users and 4 guests