MySQL / php differ

[Matthew Seaman]

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

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 259 bytes
Desc: OpenPGP digital signature
Url : http://lists.freebsd.org/pipermail/freebsd-questions/attachments/20090301/b30a4638/signature.pgp