From owner-freebsd-questions@FreeBSD.ORG Sun Mar 1 12:52:39 2009 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 70D0D106564A for ; Sun, 1 Mar 2009 12:52:39 +0000 (UTC) (envelope-from m.seaman@infracaninophile.co.uk) Received: from smtp.infracaninophile.co.uk (gate6.infracaninophile.co.uk [IPv6:2001:8b0:151:1::1]) by mx1.freebsd.org (Postfix) with ESMTP id CBBA28FC08 for ; Sun, 1 Mar 2009 12:52:38 +0000 (UTC) (envelope-from m.seaman@infracaninophile.co.uk) Received: from happy-idiot-talk.infracaninophile.co.uk (localhost [IPv6:::1]) (authenticated bits=0) by smtp.infracaninophile.co.uk (8.14.3/8.14.3) with ESMTP id n21CqW9e016317; Sun, 1 Mar 2009 12:52:33 GMT (envelope-from m.seaman@infracaninophile.co.uk) X-DKIM: Sendmail DKIM Filter v2.8.2 smtp.infracaninophile.co.uk n21CqW9e016317 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=infracaninophile.co.uk; s=200708; t=1235911954; bh=8DcoS8aaiUnJSgCW5iND4dgRbUHtSpVUr9EBhJOVUp4=; h=Message-ID:Date:From:MIME-Version:To:CC:Subject:References: In-Reply-To:Content-Type:Cc:Content-Type:Date:From:In-Reply-To: Message-ID:Mime-Version:References:To; z=Message-ID:=20<49AA850A.6020105@infracaninophile.co.uk>|Date:=20S un,=2001=20Mar=202009=2012:52:26=20+0000|From:=20Matthew=20Seaman= 20|Organization:=20Infracaninophi le|User-Agent:=20Thunderbird=202.0.0.19=20(X11/20090218)|MIME-Vers ion:=201.0|To:=20"Aryeh=20M.=20Friedman"=20|CC:=20Jos=20Chrispijn=20,=20=0D=0A=20FreeBSD=20 Questions=20|Subject:=20Re:=20MySQL =20/=20php=20differ|References:=20<49AA6060.60604@webrz.net>=20<49 AA6302.2000408@gmail.com>|In-Reply-To:=20<49AA6302.2000408@gmail.c om>|X-Enigmail-Version:=200.95.6|Content-Type:=20multipart/signed= 3B=20micalg=3Dpgp-sha256=3B=0D=0A=20protocol=3D"application/pgp-si gnature"=3B=0D=0A=20boundary=3D"------------enig6CA22CC53E2365C489 B859FA"; b=us0uaTnfHZJRsHtcmcg0WcvvMXLQjP/7TcU3z1PESxvJwZUos/7YIY8isAYF6jWkB eouGMdLTr6SJV4Cb+9gwZVnZ87/93tEkouB7BNjNLDZFqJEyxEvQwUnNy+sVMBtCvM QjUHuRo5c/o9ZvchosBRq2q07ryNf2YAeEmryFbM= X-Authentication-Warning: happy-idiot-talk.infracaninophile.co.uk: Host localhost [IPv6:::1] claimed to be happy-idiot-talk.infracaninophile.co.uk Message-ID: <49AA850A.6020105@infracaninophile.co.uk> Date: Sun, 01 Mar 2009 12:52:26 +0000 From: Matthew Seaman Organization: Infracaninophile User-Agent: Thunderbird 2.0.0.19 (X11/20090218) MIME-Version: 1.0 To: "Aryeh M. Friedman" References: <49AA6060.60604@webrz.net> <49AA6302.2000408@gmail.com> In-Reply-To: <49AA6302.2000408@gmail.com> X-Enigmail-Version: 0.95.6 Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------enig6CA22CC53E2365C489B859FA" X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0.1 (smtp.infracaninophile.co.uk [IPv6:::1]); Sun, 01 Mar 2009 12:52:34 +0000 (GMT) X-Virus-Scanned: ClamAV 0.94.2/9059/Sun Mar 1 09:05:32 2009 on happy-idiot-talk.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-3.0 required=5.0 tests=AWL,BAYES_00,DKIM_SIGNED, DKIM_VERIFIED,NO_RELAYS autolearn=ham version=3.2.5 X-Spam-Checker-Version: SpamAssassin 3.2.5 (2008-06-10) on happy-idiot-talk.infracaninophile.co.uk Cc: Jos Chrispijn , FreeBSD Questions Subject: Re: MySQL / php differ X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 01 Mar 2009 12:52:41 -0000 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--