• Registered: 2010-11-11
  • Posts: 9

Topic: mysqlnd used in php-zts

I just noticed that in the php spec file mysqlnd is used as driver for php-zts but not for the other SAPIs. Is this intentional?

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

Re: mysqlnd used in php-zts

Yes

mysqlnd is very experimental. So I only enable it for testing in this SAPI.

+

Desktop: Fedora 37 + rpmfusion + remi-test
Laptop:  Fedora 36 + rpmfusion + remi (SCL only)
Hosting Server: CentOS 8 Stream with EPEL, rpmfusion, remi

Remi's Website

  • Registered: 2011-03-16
  • Posts: 1

Re: mysqlnd used in php-zts

Remi wrote:

Yes

mysqlnd is very experimental. So I only enable it for testing in this SAPI.

+

I don't think this is the case anymore. It's the default set by the PHP people and it's considered stable by the authors of the driver (MySQL themselves). Is there any reason to continue considering it "experimental"? It offers numerous advantages that would be nice to have available.

4 Reply by oridan (edited by oridan 2011-04-19 09:37:49)

  • Registered: 2011-04-19
  • Posts: 5

Re: mysqlnd used in php-zts

Since php-zts moved from remi-test repo to remi repo it does not seem to be working, php is not running with mysqlnd, nor is it loading the -zts extensions.  It is almost like apache is not loading in worker-mpm, but apache has not changed.

Is anyone else finding this problem?

Many Thanks,
Tom


EDIT:  To confirm, apache is running worker:  service httpd status
httpd.worker (pid  19473) is running...

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

Re: mysqlnd used in php-zts

Have you install php ?
This package, which provides to apache module also provides the configuration file (/etc/httpd/conf.d/php.conf) which enable php is zts mode.

Desktop: Fedora 37 + rpmfusion + remi-test
Laptop:  Fedora 36 + rpmfusion + remi (SCL only)
Hosting Server: CentOS 8 Stream with EPEL, rpmfusion, remi

Remi's Website

  • Registered: 2011-04-19
  • Posts: 5

Re: mysqlnd used in php-zts

Hi Remi, thanks for the quick reply.
I have php and php-zts installed and the contents of my php.conf seem to be correct (see below).

I really appreciate your help,

Tom

# PHP is an HTML-embedded scripting language which attempts to make it
# easy for developers to write dynamically generated webpages.
#
<IfModule prefork.c>
  LoadModule php5_module modules/libphp5.so
</IfModule>
<IfModule worker.c>
  LoadModule php5_module modules/libphp5-zts.so
</IfModule>

#
# Cause the PHP interpreter to handle files with a .php extension.
#
AddHandler php5-script .php
AddType text/html .php

#
# Add index.php to the list of files that will be served as directory
# indexes.
#
DirectoryIndex index.php

#
# Uncomment the following line to allow PHP to pretty-print .phps
# files as PHP source code:
#
#AddType application/x-httpd-php-source .phps
  • Remi
  • Remi
  • Administrateur
  • Offline
  • From: Champagne...
  • Registered: 2009-04-28
  • Posts: 3,739

Re: mysqlnd used in php-zts

How do you launch httpd in worker mode ?
The right solution is by editing /etc/sysconfig/httpd

I have just try it, and don't encounter issue...

Which distro, arch, version are you using ?

Desktop: Fedora 37 + rpmfusion + remi-test
Laptop:  Fedora 36 + rpmfusion + remi (SCL only)
Hosting Server: CentOS 8 Stream with EPEL, rpmfusion, remi

Remi's Website

8 Reply by oridan (edited by oridan 2011-04-20 08:34:55)

  • Registered: 2011-04-19
  • Posts: 5

Re: mysqlnd used in php-zts

I am using CentOS 5.6 x86_64.
I have found that php-zts works when running php as apache module, but not as fastcgi.

does php-zts work with fastcgi? or was it my imagination?

Ideally i would like to use mysqlnd with fastcgi.

Many Thanks,
Tom

edit: this may help:

httpd.x86_64                                          2.2.3-45.el5.centos                      installed

mod_fcgid.x86_64                                      2.2-11.el5                               installed

php.x86_64                                            5.3.6-3.el5.remi                         installed
php-cli.x86_64                                        5.3.6-3.el5.remi                         installed
php-common.x86_64                                     5.3.6-3.el5.remi                         installed
php-devel.x86_64                                      5.3.6-3.el5.remi                         installed
php-gd.x86_64                                         5.3.6-3.el5.remi                         installed
php-mbstring.x86_64                                   5.3.6-3.el5.remi                         installed
php-mcrypt.x86_64                                     5.3.6-3.el5.remi                         installed
php-mysql.x86_64                                      5.3.6-3.el5.remi                         installed
php-pdo.x86_64                                        5.3.6-3.el5.remi                         installed
php-zts.x86_64                                        5.3.6-3.el5.remi                         installed

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

Re: mysqlnd used in php-zts

> I have found that php-zts works when running php as apache module, but not as fastcgi.
Exactly

> Ideally i would like to use mysqlnd with fastcgi.
Not supported with my RPM.

Desktop: Fedora 37 + rpmfusion + remi-test
Laptop:  Fedora 36 + rpmfusion + remi (SCL only)
Hosting Server: CentOS 8 Stream with EPEL, rpmfusion, remi

Remi's Website

  • Registered: 2011-04-19
  • Posts: 5

Re: mysqlnd used in php-zts

ok, thank you Remi  smile

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

Re: mysqlnd used in php-zts

php-mysqlnd is now available.
Read : http://blog.famillecollet.com/post/2011 … ive-Driver

Desktop: Fedora 37 + rpmfusion + remi-test
Laptop:  Fedora 36 + rpmfusion + remi (SCL only)
Hosting Server: CentOS 8 Stream with EPEL, rpmfusion, remi

Remi's Website