Date: Sun, 01 Mar 2009 12:52:26 +0000 From: Matthew Seaman <m.seaman@infracaninophile.co.uk> To: "Aryeh M. Friedman" <aryeh.friedman@gmail.com> Cc: Jos Chrispijn <jos@webrz.net>, FreeBSD Questions <freebsd-questions@freebsd.org> Subject: Re: MySQL / php differ Message-ID: <49AA850A.6020105@infracaninophile.co.uk> In-Reply-To: <49AA6302.2000408@gmail.com> References: <49AA6060.60604@webrz.net> <49AA6302.2000408@gmail.com>
index | next in thread | previous in thread | raw e-mail
[-- Attachment #1 --]
Aryeh M. Friedman wrote:
> Jos Chrispijn wrote:
>> | FreeBSD 6.4-STABLE
>>
>> Just upgraded my MySQL server/client to v5.0.77 and php version to
>> php5-5.2.8 but something struck my eye when opening phpmyadmin, saying:
>>
>> 'Your PHP MySQL library version 4.0.27 differs from your MySQL server
>> version 5.0.77. This may cause unpredictable behavior'.
>>
>> I obviously have my php MySQL library running wrong version. Can you
>> tell me How could I solve this matter in a quick way?
>>
>> thanks,
>> Jos Chrispijn
> portmaster -rf database/phpmyadmin
Actually, you may only need to recompile databases/php5-mysql (possibly plus some
dependencies) and then restart apache. If your DB is on the same machine as where
you're running phpMyAdmin, then you will have the 5.0.77 client libraries already
installed and recompiling that one package should fix the observed problem.
If not, then you may need to update the mysql client libraries and anything
that links to them on the phpMyAdmin machine. You can check what php5-mysql
depends on like so:
% pkg_info -rx php5-mysql
Information for php5-mysql-5.2.8:
Depends on:
Dependency: expat-2.0.1
Dependency: openssl-0.9.8j_1
Dependency: perl-5.8.9_1
Dependency: pkg-config-0.23_1
Dependency: pcre-7.8
Dependency: mysql-client-5.0.77
Dependency: db46-4.6.21.3
Dependency: cyrus-sasl-2.1.22_2
Dependency: openldap-sasl-client-2.4.15
Dependency: libiconv-1.11_1
Dependency: libxml2-2.7.3
Dependency: apache-2.2.11_3
Dependency: php5-5.2.8
You won't get exactly the same list -- the important bit is the 'mysql-client'
line. If you aren't using 5.0.77 client then:
# portupgrade -o databases/mysql50-client -fr mysql-client-X.X.XX
(fill in the version number of the client libraries you actually do have
installed). You may also see output for php5-mysqli if you have that
module installed: the portupgrade command above should fix both modules.
Cheers,
Matthew
--
Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard
Flat 3
PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate
Kent, CT11 9PW
[-- Attachment #2 --]
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.10 (FreeBSD)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iEYEAREIAAYFAkmqhRAACgkQ8Mjk52CukIyIXwCggFZ9mIu53V69aKyB7+NaOf2F
FIMAoI3FvxRQwYVIq/87VHmNIBqwd1QW
=ZkFC
-----END PGP SIGNATURE-----
help
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?49AA850A.6020105>