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>
next in thread | previous in thread | raw e-mail | index | archive | help
This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--------------enig6CA22CC53E2365C489B859FA
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
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=20
>> 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=20
>> 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 p=
lus some=20
dependencies) and then restart apache. If your DB is on the same machine =
as where=20
you're running phpMyAdmin, then you will have the 5.0.77 client libraries=
already=20
installed and recompiling that one package should fix the observed proble=
m. =20
If not, then you may need to update the mysql client libraries and anythi=
ng
that links to them on the phpMyAdmin machine. You can check what php5-mys=
ql
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-cl=
ient'
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
--=20
Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard
Flat 3
PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate
Kent, CT11 9PW
--------------enig6CA22CC53E2365C489B859FA
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"
-----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-----
--------------enig6CA22CC53E2365C489B859FA--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?49AA850A.6020105>