MySQL 5?

[Dawn]

I tried yesterday the backports.org (Debian) PHP 5 and MySQL 5 backport. Same problem. The wrong library is linked...

Greets,
Dawn

 

[tannenba]

Thank you Dawn.

I have another dummy question. If the client is mysql4.x
are we really running mysql5? I am trying to learn this out
of a book, and the scripts for mysql4 are the ones that work.
ei connect to mysqli gives undefined operation.

Sorry if this question seems lame, but I am trying to learn
(relearn?) Debian, mysql, and php and apache all at the same
time. I am trying to come up with a platform to follow along
in 'PHP and MYSQL for Dummies'. I want to see if I can learn
enough to make a web based observation log for Astronomy.

Joe

 

[atomicturtle]

The version of mysql reported by php is the version of the client library. It has nothing to do with the server in any way. The impact would be on the client side features (SSL support for example) available to your application.

 

[tannenba]

Thanks for the info. So, as long as the client is 4.x
then the whole thing act like 4? Ei: mysqli_connect() not working?
Please excuse if this sounds dumb.

joe

 

[atomicturtle]

With the 5.x php rpms, mysqli is built into the php-mysql package, and 5.0 and up were all linked against 4.1. So yes mysqli would be available.

 

[Vengent]

I think he mentioned he's using debs rather than rpms.

Are you on sarge, or etch?

dpkg -l | grep php5

do that, and see which mysql module you're using with php.

 

[tannenba]

Thank you,
Joe

 

[Dawn]

I fould be feeling really lucky if anyone can build a modified version of backports.org PHP 5 which is linked against mysql 5 client and supports mysqli. As I read arount the net, I think there a lot of ppl which would enjoy such a thing.

Personaly I'm using sarge. I know I could compile my own PHP 5 version with support of this features but I don't think I could do that a good as the guys from backports.org or dotdeb.

Perhaps if anyone offers such a thing and update it regulary we could donate to a good open-source project for this kind of support?

 

[VIB-host]

I ask again..... How about UNIX FreeBSD any experiences ?

 

[Vengent]

MysqlI is definitely supported with the 4 client.

mysqli
MysqlI Support enabled
Client API library version 4.1.15
Client API header version 4.1.15

This is on sarge, with dotdeb.

ii mysql-server-5 5.0.32-1.dotde mysql database server binaries

ii mysql-client-5 5.0.32-1.dotde mysql database client binaries

ii php5-mysql 5.2.0-0.dotdeb MySQL module for php5

ii libmysqlclient 4.0.24-10sarge mysql database client library
ii libmysqlclient 4.1.15-0.dotde mysql database client library
ii libmysqlclient 5.0.32-1.dotde mysql database client library

 

[tannenba]

Originally posted by Vengent
I think he mentioned he's using debs rather than rpms.

Are you on sarge, or etch?

dpkg -l | grep php5

do that, and see which mysql module you're using with php.

Sorry about not getting back sooner..

my mach shows:
ii libapache-mod-php5 5.2.0-8~bpo.2
ii libapache2-mod-php4 4.4.4-0.dotdeb.3
ii libapache2-mod-php5.0 5.0.5-0.8~sarge1
ii php-pear 5.2.0-0.dotdeb.3
ii php4 4.4.4-0.dotdeb.3
ii php4-common 4.4.4-0.dotdeb.3
ii php4-mysql 4.4.4-0.dotdeb.3
ii php5-cli 5.2.0-8~bpo.2
ii php5-common 5.2.0-8~bpo.2
ii php5-mysql 5.2.0-8~bpo.2
ii php5.0-common 5.0.5-0.8~sarge1
ii phpmyadmin 2.6.2-3sarge1

Joe

 

[tannenba]

And while I am at it, here are the MySQL files:

ii libdbd-mysql-perl 2.9007-0.dotdeb.0
ii libmysqlclient12 4.0.24-10sarge2
ii libmysqlclient14 4.1.15-0.dotdeb.4
ii libmysqlclient15-dev 5.0.32-1.dotdeb.1
ii libmysqlclient15off 5.0.32-1.dotdeb.1
ii mysql-admin 1.1.10-1~bpo.1
ii mysql-admin-common 1.1.10-1~bpo.1
ii mysql-client-5.0 5.0.32-1.dotdeb.1
ii mysql-common 5.0.32-1.dotdeb.1
ii mysql-server 5.0.32-1.dotdeb.1
ii mysql-server-5.0 5.0.32-1.dotdeb.1
ii php4-mysql 4.4.4-0.dotdeb.3
ii php5-mysql 5.2.0-8~bpo.2

 

[tannenba]

PS..I forgot to answer you. I am on Sarge.

Joe

 

[tannenba]

Progress!
I removed all the php and mysql packages and purged them.
Then I reloaded all from only dotdeb. I also said 'no' this
time to the question 'do you want to connect from a Sarge box?'
Now I have both mysql and mysqli working. My files are;

ii libdbd-mysql-perl 2.9007-0.dotdeb.0
ii libmysqlclient14 4.1.15-0.dotdeb.4
ii libmysqlclient15off 5.0.32-1.dotdeb.1
ii mysql-admin 1.0.20-1
ii mysql-admin-common 1.0.20-1
ii mysql-client-5.0 5.0.32-1.dotdeb.1
ii mysql-common 5.0.32-1.dotdeb.1
ii mysql-server 5.0.32-1.dotdeb.1
ii mysql-server-5.0 5.0.32-1.dotdeb.1
ii php5-mysql 5.2.0-0.dotdeb.3

Thanks for all the help.

Joe

 

[Dawn]

I'm not sure if I understand you: Is MySQL Server 5 and MySQL Client 5 working? In the past I didn't had any problems with MySQL 5 Server but PHP used only MySQL Client 4.x...

Can you please tell me how did you removed and purged all your listed packages without removing Plesk? I only could replace them via "apt-get --reinstall install [packetname]". A litte be more details from you would be nice...

Greets and thanks a lot anyway,
Dawn

 

[tannenba]

Dawn,
I never got far enough for Plesk. This was a machine for me
to learn on. I had originally loaded mysql and php and apache2
when I loaded sarge on the machine. Then I was reading about the
changes as mysqli... That led to my part in this discussion.
To purge (get rid of config files) I did "dpkg --purge packagename'
and made sure the package was gone. (I didn't have anything in my
SQL databases yet that I needed to worry about either)
This script causes all the info to be displayed, and with what I
have now, I have a mysqli section after mysql

<html>
<head>
<title>PHP Test</title>
<?php
phpinfo();
?>
</body></html>

Shows:

my client api,headers, and version to be 4.1.15

I don't know if I cleared anything up,

I hope it's been some help.

Greetings from Phoenix, AZ, USA

 

[Vengent]

I've got the 5 client headers working with Etch, but still not sarge.

From phpMyAdmin - 2.9.2

* MySQL client version: 5.0.30
* Used PHP extensions: mysqli

From phpinfo

Client API library version 5.0.30
Client API header version 5.0.30

ii libmysqlclient15off 5.0.30-3 mysql database client library
ii mysql-client-5.0 5.0.30-3 mysql database client binaries
ii mysql-common 5.0.30-3 mysql database common files (e.g. /etc/mysql
ii mysql-server-5.0 5.0.30-3 mysql database server binaries
ii php5-mysql 5.2.0-8 MySQL module for php5


This is all with plesk 8.1 running, and its fine with the 5 headers.

I haven't tested further on sarge.

 

[Dawn]

Hi tannenba,

Then it's clear for me: You had other problems than me and you are now using the DotDeb Packages for MySQLi-Support. The MySQL 5 packages and libraries are on your system but PHP 5 is linked against MySQL 4. Perhaps I din't read your post carefully enough....

Sounds nice that it works on Edge but I'm a little bit scared about a distr-upgrade. Can you please tell me here if you get it working with Sarge?

Greets and best regards from Central-Switzerland,
Dawn

 

[Vengent]

Originally posted by Dawn

Sounds nice that it works on Edge but I'm a little bit scared about a distr-upgrade. Can you please tell me here if you get it working with Sarge?

Greets and best regards from Central-Switzerland,
Dawn [/B]

Aye, I hear you. My production box is still sarge with dotdeb. And I've resigned myself to the 4 client headers thus far.

It's still just the test box running etch. As soon as I get a stable upgrade path, I will definitely post.

 

[Dawn]

Nice to hear that THX