Topic: Compile PHP 5.4 against MariaDB 10.0.4

Even Google is switching to this version, and since I've started using MariaDB I cannot use your repo, because I'm getting such warnings:

Warning:  mysql_pconnect(): Headers and client library minor version mismatch. Headers:50533 Library:100004 in /etc/httpd/htdocs/test.php on line 58

Can you fix this remi ?

Re: Compile PHP 5.4 against MariaDB 10.0.4

Use php-mysqlnd instead of php-mysql.

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

Re: Compile PHP 5.4 against MariaDB 10.0.4

Remi wrote:

Use php-mysqlnd instead of php-mysql.

It says:

Error: php-mysql conflicts with php-mysqlnd-5.4.20-1.el6.remi.x86_64
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest

Re: Compile PHP 5.4 against MariaDB 10.0.4

"instead" means you have to remove php-mysql.

http://blog.famillecollet.com/post/2011 … ive-Driver


P.S. note: with PHP 5.5 I don't provide php-mysql anymore.

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

Re: Compile PHP 5.4 against MariaDB 10.0.4

Spacedust wrote:
Remi wrote:

Use php-mysqlnd instead of php-mysql.

It says:

Error: php-mysql conflicts with php-mysqlnd-5.4.20-1.el6.remi.x86_64
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest

OK. Got it, but some scripts are unable to connect then hmm

Warning: mysql_error() expects parameter 1 to be resource, boolean given in /home/wraten/domain/mysql.php on line 31

Re: Compile PHP 5.4 against MariaDB 10.0.4

Perhaps the old_password issue ?

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

Re: Compile PHP 5.4 against MariaDB 10.0.4

Run this request:

MariaDB [mysql]> select User,Host,Password from mysql.user where length(Password)<41;

Password of all listed users must be changed.

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

Re: Compile PHP 5.4 against MariaDB 10.0.4

Showed me 2423 rows wink

I found the only solution is to have mysqlclient18 which will be a bridge beetween your PHP and MariaDB, but you don't have it inside your repo. Can you add it ?

Re: Compile PHP 5.4 against MariaDB 10.0.4

> Showed me 2423 rows wink

Really you should remove "old_password=1" and start generate new password.
Keeping pre MySQL 4.1 stuff is just too risky (and unsecure)

> I found the only solution is to have mysqlclient18 which will be a bridge beetween your PHP and MariaDB, but you don't have it inside your repo. Can you add it ?

I will check, I think I already have the "compat-mysql55" RPM ready... just need to be checked / build / push.

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

10 (edited by Spacedust 2013-10-11 18:02:14)

Re: Compile PHP 5.4 against MariaDB 10.0.4

OK - removed. How to convert all old passwords to the new ones ?

Re: Compile PHP 5.4 against MariaDB 10.0.4

Something like.

UPDATE mysql.user SET Password=PASSWORD('thenewpassword') WHERE user.User='theusername';

But of course, if you want to keep the old password, you need to know it wink

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

Re: Compile PHP 5.4 against MariaDB 10.0.4

That's the problem hmm

Re: Compile PHP 5.4 against MariaDB 10.0.4

I've extracted your package: mysql-libs-5.5.34-1.el6.remi.x86_64.rpm and got libmysqlclient.so.18.0.0 from it.

Now I'm having: Client API library version     5.5.34 and Client API header version     5.5.33

Re: Compile PHP 5.4 against MariaDB 10.0.4

Sometime I'm tired.... and forget simple solution....

compat-mysql55 is available in remi-test for >2 years..

And this is even explained in the FAQ (Can PHP be updated without MySQL)...

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

Re: Compile PHP 5.4 against MariaDB 10.0.4

It should be updated wink

Re: Compile PHP 5.4 against MariaDB 10.0.4

Tried yesterday... new version don't even build... sad

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

Re: Compile PHP 5.4 against MariaDB 10.0.4

I was definitively too tired yesterday... fix is so simple...

Updated to 5.5.34 done (upload in progress)

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

Re: Compile PHP 5.4 against MariaDB 10.0.4

Remi wrote:

I was definitively too tired yesterday... fix is so simple...

Updated to 5.5.34 done (upload in progress)

In which repo ?

Re: Compile PHP 5.4 against MariaDB 10.0.4

In remi-test, see previous link.

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