• Registered: 2018-07-09
  • Posts: 1

Topic: Build pecl-database-mysql extension with php56-devel

This might be a very stupid question, but bear with me.

I am trying to setup an old-ass application copied from a shared hosting over to a fedora 28 VPS. The shared hosting has the following configuration according to phpinfo():

php 5.6.30
mysql Client API version 5.5.48 (whatever this means)
MYSQL_MODULE_TYPE external

Initially, I tried using php7 from the VPS's default package manager, along with pecl-database-mysql from https://github.com/php/pecl-database-mysql (because the app uses the legacy mysql functions), but it just throws errors about exhausting the memory available (I have even tried setting the mem limit to -1 on a 16 GB host, and it eats all that too). Then, I tried using php56-php-fpm together with php56-php-mysql but the app throws the same kind of errors.

My last hope is building the pecl-database-mysql against php56-php-devel to see if it works, but that's where I'm stuck. According to this post at My-PHP-Workstation under Working on PHP extensions I am supposed to call the module load command to switch the context to php56, but the problem is that such command is nowhere to be found and the extension's source does not provide 'a shell-specific initialization script' as to source it and be able to call the module command. Any ideas?

  • Remi
  • Remi
  • Administrateur
  • Offline
  • From: Champagne...
  • Registered: 2009-04-28
  • Posts: 3,836

Re: Build pecl-database-mysql extension with php56-devel

You don't need to build the pecl extension.
The deprecated "mysql" extension is still available in PHP 5.x (removed in 7.x)
And for 7.x, the php-pecl-mysql package is available.

> it just throws errors about exhausting the memory available

This could be because of "mysqlnd" driver which use PHP memory allocator (thus restrain the memory usage under the memory_limit)

With old driver (libmysqlclient), your app can consumme all the server memory, without restriction (but this is obviously bad).
I only provides the mysql extension for the old driver (php-mysql package) for PHP 5.4.

See http://php.net/manual/en/mysqlinfo.library.choosing.php

BTW, your legacy app need to be fixed.

Laptop:  Fedora 38 + rpmfusion + remi (SCL only)
x86_64 builder: Fedora 39 + rpmfusion + remi-test
aarch64 builder: RHEL 9 with EPEL
Hosting Server: CentOS 8 Stream with EPEL, rpmfusion, remi

Remi's Website