View previous topic :: View next topic |
Author |
Message |
Robert S Guru
Joined: 15 Aug 2004 Posts: 460 Location: Canberra Australia
|
Posted: Sat Oct 22, 2005 2:28 am Post subject: |
|
|
I've just spent much of the morning on the upgrade. Much worse than apache2 which went without much of a hitch. Had problems recreating my database from the mysqldump - it didn't like some of the records in the key fields. I had to re-emerge mod_php (for some reason this got missed in revdep-rebuild). I also had to uninstall and reinstall phpmyadmin - I had problems with re-assigning the pma password. This was compounded by the fact that phpmyadmin needed a security upgrade.
All seems to be OK now. |
|
Back to top |
|
|
WladyX Guru
Joined: 25 Nov 2004 Posts: 503 Location: Romania
|
Posted: Sat Oct 22, 2005 3:32 pm Post subject: |
|
|
My upgrade went pretty good on three gentoo systems _________________ We are not alone. |
|
Back to top |
|
|
BastianBalthazarBux Retired Dev
Joined: 10 Dec 2004 Posts: 78
|
Posted: Sun Oct 23, 2005 12:19 am Post subject: |
|
|
My apologies for every issue you may have encountered, following a short resume of what I can remember.
use Code: | revdep-rebuild --library=libmysqlclient.so.12 | instead of a plain revdep-rebuild, will be documented soon
for a mysql-4.1 ==> 5.0 upgrade
use Code: | revdep-rebuild --library=libmysqlclient.so.14 |
There has been a (short) period of time where /var/log/mysql was not created, if it's missing please do:
Code: |
mkdir "/var/log/mysql"
touch /var/log/mysql/mysql.{log,err}
chmod 0660 /var/log/mysql/mysql.{log,err}
|
more in depth 1000 byte key issue:
https://bugs.gentoo.org/show_bug.cgi?id=109960
The mysql-herd is intentioned in maintaining as long as possible every version of MySQL, avoid 4.1 upgrades is as easy as
Code: | echo '>=dev-db/mysql-4.1' >> /etc/portage/package.mask |
as far as I know we still have working mysql-3.23.58 ebuild .
4.0.26 is already there and 4.0.27 will be, when out.
P.S. as you can see from the number of my post I'm not a frequent forum poster/reader, bugs and mail reach me much faster.
Regards,
Francesco |
|
Back to top |
|
|
Robelix l33t
Joined: 21 Jul 2002 Posts: 760 Location: in a World created by a Flying Spaghetti Monster
|
Posted: Sun Oct 23, 2005 9:56 am Post subject: Re: Quick note |
|
|
plastix wrote: | On my upgrade I ran into an error with mysqldump:
Code: | mysqldump: Got error: 1105: Unknown error when doing refresh |
I fixed this by issueing :
Code: | # mysqldump \
-uroot \
-p$PASSWORD \
-hlocalhost \
--all-databases \
--all \
--opt \
--allow-keywords \
--hex-blob \
--master-data \
--max_allowed_packet=16M \
--quote-names \
--result-file=BACKUP_MYSQL_4.0.SQL |
(Basically I removed the --flush-logs option) Hope this helps anyone who has a similar problem. |
I had this error on one box and tried it without flush-logs. No more errors, but I was missing at least one database after importing
So I stepped back to 4.0 for now. _________________ mysql> SELECT question FROM life, universe, everything WHERE answer=42;
Empty set (2079460347 sec) |
|
Back to top |
|
|
xming Guru
Joined: 02 Jul 2002 Posts: 441
|
Posted: Mon Oct 24, 2005 3:11 pm Post subject: |
|
|
MySQL 5.0.15 declared stable, do we have to through this again?
xming _________________ http://wojia.be |
|
Back to top |
|
|
Grexe n00b
Joined: 26 Oct 2005 Posts: 29 Location: Vienna
|
Posted: Wed Oct 26, 2005 10:37 am Post subject: Upgrade from 4.0.x to 5.0 |
|
|
I thought I'd take the big step now that 5.0 is out and - success:) - the excellent howto was all I needed.
revdep-rebuild had some problems with a stale qt-package that it did not find anymore, so I manually emerged the necessary packages (and took fresh versions along the way).
However I also got the "MySQL not started. Proceeding anyway"-message, but only on first start.
Log-files had the correct user- and group-permissions (mysql:mysql).
Running at 5.0.15 now, without problems so far (only did some rudimentary testing with mediawiki).
Thanks for all the infos in this Thread! |
|
Back to top |
|
|
nl0pvm n00b
Joined: 08 Nov 2004 Posts: 46 Location: Netherlands
|
Posted: Sun Nov 27, 2005 12:54 pm Post subject: |
|
|
I did the upgrade exactly according to the manual but i ended up with this problem:
Code: | Warning: Unable to load '//usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
.051127 13:42:01 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
051127 13:42:01 [ERROR] Aborting
051127 13:42:01 [Note] //usr/sbin/mysqld: Shutdown complete
....ERROR 2002 (HY000): Can't connect to local MySQL server through socket '//var/run/mysqld/mysqld.sock' (2)
* Loading "zoneinfo" this step may require few seconds
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '//var/run/mysqld/mysqld.sock' (2)
cat: //var/run/mysqld/mysqld.pid: No such file or directory
kill: usage: kill [-s sigspec | -n signum | -sigspec] [pid | job]... or kill -l [sigspec]
* done
|
when i tried to run mysql I got this error:
Code: | bruce pveerman # /etc/init.d/mysql start
* Caching service dependencies ... [ ok ]
* ERROR: "mysql" does not have a start function.
|
which is not a big suprise as my /etc/init.d/mysql only contains the following:
Code: | bruce pveerman # less /etc/init.d/mysql
#!/sbin/runscript
# Copyright 1999-2004 Gentoo Foundation
# Distributed under the terms of the GNU General Public License v2
|
What should i do now?
1. uninstall mysql 4.1 then redo the whole procedure?
2. uninstall 4.1 install 4.0 rebuild DB and then do the whole procedure again?
3. rollback to 4.0 and forget upgrading my complete life.
4. switch distribution? _________________ SUN E250 2 x UltrasparcII@400Mhz 512MB RAM 6 x 9GB Kernel 2.6.8 (SMP)
SUN E250 UltrasparcII@400Mhz 512MB RAM 2 x 9GB Kernel 2.6.11
SUN E250 UltrasparcII@400Mhz 1024MB RAM 2 x 9GB
SPARCstation 10 MP 2 x 390Z55@40Mhz 512MB RAM Kernel 2.4.30 4GB & 9GB |
|
Back to top |
|
|
bonbons Apprentice
Joined: 04 Sep 2004 Posts: 250
|
Posted: Mon Dec 05, 2005 6:05 pm Post subject: |
|
|
nl0pvm wrote: | when i tried to run mysql I got this error:
Code: | bruce pveerman # /etc/init.d/mysql start
* Caching service dependencies ... [ ok ]
* ERROR: "mysql" does not have a start function.
|
which is not a big suprise as my /etc/init.d/mysql only contains the following:
Code: | bruce pveerman # less /etc/init.d/mysql
#!/sbin/runscript
# Copyright 1999-2004 Gentoo Foundation
# Distributed under the terms of the GNU General Public License v2
|
What should i do now?
1. uninstall mysql 4.1 then redo the whole procedure?
2. uninstall 4.1 install 4.0 rebuild DB and then do the whole procedure again?
3. rollback to 4.0 and forget upgrading my complete life.
4. switch distribution? | Hard to say what exactly is wrong...
Are you sure your timezone configuration is correct and working?
For the empty init script, you could just look at the mysql ebuild and manually copy the appropriate file from /usr/portage/dev-db/mysql/files/ to /etc/init.d/.
What useflags are you using for mysql? |
|
Back to top |
|
|
nl0pvm n00b
Joined: 08 Nov 2004 Posts: 46 Location: Netherlands
|
Posted: Mon Dec 05, 2005 6:55 pm Post subject: |
|
|
This is already some days ago and this is what i remember:
My use flags:
Code: | -cups -3ds ansi apache2 bash-completion bzlib -doc innodb mailwrapper mime php serial session sftplogging soap sockets vim -gtk -gnome -qt -X -xv |
and during the emerge i can remember some vague warnings about a very weard timezone in asia or something like that.
I solved the problem bij emerge -C and a second try :S
Then i ended up with some other problems but those i could work around. _________________ SUN E250 2 x UltrasparcII@400Mhz 512MB RAM 6 x 9GB Kernel 2.6.8 (SMP)
SUN E250 UltrasparcII@400Mhz 512MB RAM 2 x 9GB Kernel 2.6.11
SUN E250 UltrasparcII@400Mhz 1024MB RAM 2 x 9GB
SPARCstation 10 MP 2 x 390Z55@40Mhz 512MB RAM Kernel 2.4.30 4GB & 9GB |
|
Back to top |
|
|
schachti Advocate
Joined: 28 Jul 2003 Posts: 3765 Location: Gifhorn, Germany
|
Posted: Fri Dec 16, 2005 10:25 am Post subject: |
|
|
I'm having problems with mysqldump - it doesn't dump the data:
Code: |
web ~ # mysqldump -uroot -p$PASSWORD -hlocalhost --all-databases --all --opt --allow-keywords --flush-logs --hex-blob --master-data --max_allowed_packet=16M --quote-names --result-file=BACKUP_MYSQL_4.0.SQL
Enter password:
web ~ # cat BACKUP_MYSQL_4.0.SQL
-- MySQL dump 9.11
--
-- Host: localhost Database:
-- ------------------------------------------------------
-- Server version 4.0.25
--
-- Current Database: mysql
--
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mysql`;
USE mysql;
--
-- Current Database: phpBB
--
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `phpBB`;
USE phpBB;
--
-- Current Database: test
--
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test`;
USE test;
|
No data is put into the dump... _________________ Never argue with an idiot. He brings you down to his level, then beats you with experience.
How-To: Daten verschlüsselt auf DVD speichern. |
|
Back to top |
|
|
SiLvEr40 n00b
Joined: 22 Dec 2005 Posts: 1
|
Posted: Thu Dec 22, 2005 9:40 am Post subject: help |
|
|
Hello,
I am gentoo newbie and i have a problem with :
emerge =dev-db/mysql ,
MySql return an error
Code: |
* MySQL does not support building statically with SSL support
!!! ERROR: dev-db/mysql-5.0.17 failed.
!!! Function src_unpack, Line 209, Exitcode 0
!!! MySQL does not support building statically with SSL support
!!! If you need support, post the topmost build error, NOT this status message.
|
What should I do?
EDIT : I solve the problem !
I remove static flag from /etc/make.conf |
|
Back to top |
|
|
Spida Tux's lil' helper
Joined: 08 Feb 2003 Posts: 97 Location: Germany
|
Posted: Tue Feb 14, 2006 1:10 am Post subject: |
|
|
[quote]/etc/init.d/mysql start
* Starting mysqld (/etc/mysql/my.cnf) ...
..... * MySQL NOT started, proceding anyway[/quote]
chown mysql:mysql /var/run/mysqld helps sometimes, too |
|
Back to top |
|
|
[clu] Apprentice
Joined: 23 Feb 2004 Posts: 160 Location: 127.0.0.1
|
Posted: Fri Mar 03, 2006 4:55 pm Post subject: |
|
|
can't insert cyrillic letters - they appears as question marks ('?')... |
|
Back to top |
|
|
eagle_cz Apprentice
Joined: 06 Jun 2003 Posts: 214
|
Posted: Sun Mar 19, 2006 9:22 pm Post subject: Re: Quick note |
|
|
plastix wrote: | On my upgrade I ran into an error with mysqldump:
(Basically I removed the --flush-logs option) Hope this helps anyone who has a similar problem. |
It did , thx a lot |
|
Back to top |
|
|
zeek Guru
Joined: 16 Nov 2002 Posts: 480 Location: Bantayan Island
|
Posted: Sun Jul 15, 2007 7:51 am Post subject: |
|
|
Perhaps this thread from Oct 2005 doesn't need to be stickied anymore? Are these forums still being actively maintained?
mysql-4.0 is unsupported by Mysql AB and anyone needing help to upgrade to 4.1 probably already got it. |
|
Back to top |
|
|
think4urs11 Bodhisattva
Joined: 25 Jun 2003 Posts: 6659 Location: above the cloud
|
Posted: Tue Feb 19, 2008 12:36 pm Post subject: |
|
|
removed sticky _________________ Nothing is secure / Security is always a trade-off with usability / Do not assume anything / Trust no-one, nothing / Paranoia is your friend / Think for yourself |
|
Back to top |
|
|
|