Re: Corrections to: unable to upgrade to mysql55-server
On 01/06/2012 00:32, Gene wrote: 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. Something is definitely not right with your system. It really shouldn't be that painful. The missing package database entries can usually be recovered by forcing a reinstall of the package over what is already on disk, but if everything is working properly, I wouldn't worry too much about the contents of /var/db/pkg. I'm thinking that having the registry of installed ports in a completely separate partition or ZFS (ie /var) to where the ports are installed (/usr/local) is not ideal, especially when using snapshots to provide a roll-back capability. /usr/local/var/db/pkg perhaps? 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? Yes -- you could well be having hardware problems. Try a few passes of memtest86. It's in ports, but it's a standalone application you boot into so concepts of compatibility with particular OSes is irrelevant. Also do the usual stuff removing any dust or fluff that may be clogging up the ventilation holes or heatsinks, check that you've still got a good thermal contact between the heatsink and CPU (replace thermal compound if necessary). Also make sure your power supply is up to the job. They can fade over time, or you may have added a peripheral too far. [Although generally if anything here was wrong, you'ld see the machine crashing and rebooting rather than it affecting use of the ports...] Cheers, Matthew -- Dr Matthew J Seaman MA, D.Phil. PGP: http://www.infracaninophile.co.uk/pgpkey signature.asc Description: OpenPGP digital signature
Re: Corrections to: unable to upgrade to mysql55-server
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 -- ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Corrections to: unable to upgrade to mysql55-server
Running 8.1 amd64. Ports are up to date (via portsnap). 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). Attempts to update produce multiple looping errors as in the second listing below. I've found references to this error, but the latest version of portmanager (I thought) was supposed to fix this (or did it just eliminate infinite loops?). Note that I have attempted to compile some of the looping ports individually and they compile and install with no problems. Does anyone have an idea what might be going on here? Thanks in advance... First listing === snip /usr/bin/c++ -O2 -fno-strict-aliasing -pipe -Wall -Wno-unused-parameter - fno-implicit-templates -fno-exceptions -fno-rtti -O2 -fno-strict-aliasing - pipe -DDBUG_OFF -Wl,--export-dynamic CMakeFiles/mysqld.dir/main.cc.o -o mysqld -pthread libsql.a ../mysys/libmysys.a ../storage/perfschema/ libperfschema.a ../storage/myisam/libmyisam.a ../storage/csv/libcsv.a ../ storage/myisammrg/libmyisammrg.a ../storage/heap/libheap.a ../storage/ innobase/libinnobase.a libpartition.a ../mysys/libmysys.a ../dbug/libdbug.a ../mysys/libmysys.a ../dbug/libdbug.a -lz -lm ../strings/libstrings.a ../ vio/ libvio.a ../regex/libregex.a -lwrap -lcrypt ../extra/yassl/libyassl.a ../ extra/yassl/taocrypt/libtaocrypt.a -pthread libsql.a(sql_yacc.cc.o)(.text+0xb696): In function `MYSQLparse(void*)': : undefined reference to `vtable for Alter_table_truncate_partition_statement' libsql.a(sql_yacc.cc.o)(.text+0xb72a): In function `MYSQLparse(void*)': : undefined reference to `vtable for Alter_table_repair_partition_statement' libsql.a(sql_yacc.cc.o)(.text+0xb77a): In function `MYSQLparse(void*)': : undefined reference to `vtable for Alter_table_check_partition_statement' libsql.a(sql_yacc.cc.o)(.text+0xb7de): In function `MYSQLparse(void*)': : undefined reference to `vtable for Alter_table_analyze_partition_statement' libsql.a(sql_yacc.cc.o)(.text+0xb842): In function `MYSQLparse(void*)': : undefined reference to `vtable for Alter_table_optimize_partition_statement' *** Error code 1 1 error === Second listing skipping tcl-modules-8.5.11 /lang/tcl-modules marked IGNORE reason: looping, 3rd attempt at make skipping python26-2.6.8 /lang/python26 marked IGNORE reason: looping, 3rd attempt at make skipping expat-2.0.1_2 /textproc/expat2 marked IGNORE reason: looping, 3rd attempt at make skipping renderproto-0.11.1 /x11/renderproto marked IGNORE reason: looping, 3rd attempt at make skipping gmp-5.0.5 /math/gmp marked IGNORE reason: looping, 3rd attempt at make and many more -- ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: Corrections to: unable to upgrade to mysql55-server
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 -- Dr Matthew J Seaman MA, D.Phil. PGP: http://www.infracaninophile.co.uk/pgpkey signature.asc Description: OpenPGP digital signature
