From owner-freebsd-questions@FreeBSD.ORG Thu May 31 23:32:45 2012 Return-Path: Delivered-To: FreeBSD-questions@FreeBSD.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 86352106566C for ; Thu, 31 May 2012 23:32:45 +0000 (UTC) (envelope-from fbsd@brightstar.bomgardner.net) Received: from brightstar.bomgardner.net (brightstar.bomgardner.net [63.229.207.48]) by mx1.freebsd.org (Postfix) with ESMTP id 3A8268FC0C for ; Thu, 31 May 2012 23:32:45 +0000 (UTC) Received: from brightstar.bomgardner.net (localhost [127.0.0.1]) by brightstar.bomgardner.net (Postfix) with ESMTP id 6AB4E3AE for ; Thu, 31 May 2012 18:32:42 -0500 (CDT) From: "Gene" To: "Freebsd Questions" Date: Thu, 31 May 2012 18:32:42 -0500 Message-Id: <20120531231411.M27823@brightstar.bomgardner.net> In-Reply-To: <4FC65661.2020709@FreeBSD.org> References: <20120530165017.M37727@brightstar.bomgardner.net> <4FC65661.2020709@FreeBSD.org> X-Mailer: OpenWebMail 2.53 X-OriginatingIP: 192.168.0.2 (fbsd) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Cc: Subject: Re: Corrections to: unable to upgrade to mysql55-server 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: Thu, 31 May 2012 23:32:45 -0000 On Wed, 30 May 2012 18:18:25 +0100, Matthew Seaman wrote > On 30/05/2012 17:57, Gene wrote: > > I've been trying to install the port databases/mysql55-server, updating from > > the older 5.4 version. mysql55-client installed just fine. However, when I > > "make" the '-server' port I get the errors shown in the first listing below. > > So I tried > > "portmanager databases/mysql55-server -l -u" > > (latest version of portmanager - 0.4.1_9). > > Did you update to databases/mysql55-client before trying this? > mysqlXX-server depends on mysqlXX-client for the libmysql shared library > and related header files. > > Generally to switch from mysql 5.4 to mysql 5.5 you'ld do something like > this: > > 0) Backups, fasting, ritual cleansing, sacrifice of black > cockerel, you know the drill. > > 1) Stop MySQL -- plus any web servers or whatever that access mysql. > > # /usr/local/etc/rc.d/mysql-server stop > # ... > > 2) If there is any mention of MYSQL related variables in > /etc/make.conf, particularly those referring to version > numbers, comment them out. > > 3) Upgrade mysql-client: > > # portmaster -o databases/mysql55-client 'mysql-client-5.4.*' > > 4) Upgrade mysql-server: > > # portmaster -o databases/mysql55-server 'mysql-server-5.4.*' > > 5) If you've got them installed, upgrade mysql-scripts: > > # portmaster -o databases/mysql55-scripts 'mysql-scripts-5.4.*' > > 6) Upgrade anything that links against libmysql.so -- you can use > sysutils/bsdadminscripts which contains a handy script to tell > you what applications on your system are affected. Or, for the > lazy and those with excess spare time: > > # portmaster -r databases/mysql55-client > > (but this will do far more work than necessary) > > 7) Restart mysql and run the supplied program to update schemas etc. > > # /usr/local/etc/rc.d/mysql-server start > # mysql_upgrade > > 8) Restart any applications that use mysql. > > 9) Test. > > Cheers, > > Matthew > Actually, I did just as above except using portmanager.. Tried deleting the two packages & tried again with portmaster. Still no luck. So I deleted them again and installed from packages. mysql-client-5.4.. installed lib/mysql/ libmysqlclient.so.18, but mysql-server-5.4... wanted lib/mysql/ libmysqlclient.so.16. Finally, after giving ritual sacrifice to the backup gods, I went to the ZFS snapshots and just restored directories wholesale and everything is working again albeit with previous versions of mysql (and postfix which also gave me fits) but with the package database entries now missing (for some strange reason, I hadn't been backing up that directory. You'd think I'd learn - if it ain't broke, don't fix it. Still wonder what went wrong though.... Seems every time I try to update any ports, things get broken, ports don't compile, etc., etc., ad infinitum, ad nauseum. I've got to be doing something wrong. Incidentally, portmaster, when updating mysql54-server reliably rebooted the system. Hmmm.... Anyone know if there is a good memory test utility that can be run on FBSD AMD64? Anyway - thanks for the assistance... Gene > -- > Dr Matthew J Seaman MA, D.Phil. > PGP: http://www.infracaninophile.co.uk/pgpkey --