• robv
  • New member
  • Offline
  • Registered: 2011-03-23
  • Posts: 5

Topic: problem with php 5.3.6 on centos5

i had 5.3.5 on centos5 and it worked fine upgraded to 5.3.6 and i get this error now.

'SQLSTATE[HY000] [2019] Can't initialize character set (path: /usr/share/mysql/charsets/)'

anyone know if i can download the 5.3.6 rpms from anywhere ???
this is a production box and i would rather not run the test rpms.

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

Re: problem with php 5.3.6 on centos5

I you search a little ?

Php 5.3.6 => read the blog

Don't ever know which distro / version / arch you are using
How do you install
What do you install
...

You need to provides more informations if you want some help.

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

  • robv
  • New member
  • Offline
  • Registered: 2011-03-23
  • Posts: 5

Re: problem with php 5.3.6 on centos5

not sure what you are asking for?
yes i read the blog, not sure how that helps me.

i install via yum. on centos5 x86_64.
i get the error above on php 5.3.6 whereas on 5.3.5 i did not.

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

Re: problem with php 5.3.6 on centos5

Error you report are about MySQL. Not PHP.

rpm  -qa  php\*  mysql\*
rpm --verify mysql-libs
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

  • robv
  • New member
  • Offline
  • Registered: 2011-03-23
  • Posts: 5

Re: problem with php 5.3.6 on centos5

#rpm  -qa  php\*  mysql\*
php-5.3.6-1.el5.remi
php-mcrypt-5.3.6-1.el5.remi
php-mbstring-5.3.6-1.el5.remi
php-pear-1.9.2-2.el5.remi
php-pecl-ncurses-1.0.1-1.el5.remi
mysql-libs-5.1.56-1.el5.remi
php-pdo-5.3.6-1.el5.remi
php-cli-5.3.6-1.el5.remi
php-xml-5.3.6-1.el5.remi
php-gd-5.3.6-1.el5.remi
php-process-5.3.6-1.el5.remi
php-xmlrpc-5.3.6-1.el5.remi
php-eaccelerator-0.9.6.1-5.el5.remi
php-pecl-memcache-3.0.5-1.el5.remi
php-pear-PhpDocumentor-1.4.3-1.el5.remi
php-gearman-0.7.0-2
php-mysql-5.3.6-1.el5.remi
php-fpm-5.3.6-1.el5.remi
php-soap-5.3.6-1.el5.remi
php-Smarty-2.6.26-1.el5
phpdoc-1.4.3-1.el5.remi

#rpm --verify mysql-libsphp-common-5.3.6-1.el5.remi
returns nothing.

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

Re: problem with php 5.3.6 on centos5

When did this error is displayed ? from which command ?

For me, this is a "SQL server" error, and you don't seem to have mysql-server installed, so...

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

  • robv
  • New member
  • Offline
  • Registered: 2011-03-23
  • Posts: 5

Re: problem with php 5.3.6 on centos5

this happens in a php app that calls mysql(pdo). the only thing in the environment that has changed is the php version on this server.
mysql has not been upgraded.

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

Re: problem with php 5.3.6 on centos5

As I said above, mysql (an mysql-server) is not installed on this server (should be list on your comment 5).
Or you are using RPM from another source (such as Oracle RPM) which is not compatible with RPM from my (or CentOS) repository.

rpm -qa | grep -i mysql | sort
mysql --version
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

  • robv
  • New member
  • Offline
  • Registered: 2011-03-23
  • Posts: 5

Re: problem with php 5.3.6 on centos5

Remi wrote:

As I said above, mysql (an mysql-server) is not installed on this server (should be list on your comment 5).
Or you are using RPM from another source (such as Oracle RPM) which is not compatible with RPM from my (or CentOS) repository.

rpm -qa | grep -i mysql | sort
mysql --version

correct mysql is not installed the mysql-libs is as it is required my php-mysql.
the problem is all i upgraded was php from your 5.3.5 to 5.3.6 and suddenly my app is throwing these errors.