Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
Stabilisation of dev-db/mysql-4.1.14
View unanswered posts
View posts from last 24 hours

Goto page Previous  1, 2  
Reply to topic    Gentoo Forums Forum Index Networking & Security
View previous topic :: View next topic  
Author Message
Robert S
Guru
Guru


Joined: 15 Aug 2004
Posts: 460
Location: Canberra Australia

PostPosted: Sat Oct 22, 2005 2:28 am    Post subject: Reply with quote

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
View user's profile Send private message
WladyX
Guru
Guru


Joined: 25 Nov 2004
Posts: 503
Location: Romania

PostPosted: Sat Oct 22, 2005 3:32 pm    Post subject: Reply with quote

My upgrade went pretty good on three gentoo systems :)
_________________
We are not alone.
Back to top
View user's profile Send private message
BastianBalthazarBux
Retired Dev
Retired Dev


Joined: 10 Dec 2004
Posts: 78

PostPosted: Sun Oct 23, 2005 12:19 am    Post subject: Reply with quote

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
View user's profile Send private message
Robelix
l33t
l33t


Joined: 21 Jul 2002
Posts: 760
Location: in a World created by a Flying Spaghetti Monster

PostPosted: Sun Oct 23, 2005 9:56 am    Post subject: Re: Quick note Reply with quote

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 :o
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
View user's profile Send private message
xming
Guru
Guru


Joined: 02 Jul 2002
Posts: 441

PostPosted: Mon Oct 24, 2005 3:11 pm    Post subject: Reply with quote

MySQL 5.0.15 declared stable, do we have to through this again? :)

xming
_________________
http://wojia.be
Back to top
View user's profile Send private message
Grexe
n00b
n00b


Joined: 26 Oct 2005
Posts: 29
Location: Vienna

PostPosted: Wed Oct 26, 2005 10:37 am    Post subject: Upgrade from 4.0.x to 5.0 Reply with quote

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
View user's profile Send private message
nl0pvm
n00b
n00b


Joined: 08 Nov 2004
Posts: 46
Location: Netherlands

PostPosted: Sun Nov 27, 2005 12:54 pm    Post subject: Reply with quote

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? :twisted:
_________________
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
View user's profile Send private message
bonbons
Apprentice
Apprentice


Joined: 04 Sep 2004
Posts: 250

PostPosted: Mon Dec 05, 2005 6:05 pm    Post subject: Reply with quote

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? :twisted:
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
View user's profile Send private message
nl0pvm
n00b
n00b


Joined: 08 Nov 2004
Posts: 46
Location: Netherlands

PostPosted: Mon Dec 05, 2005 6:55 pm    Post subject: Reply with quote

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
View user's profile Send private message
schachti
Advocate
Advocate


Joined: 28 Jul 2003
Posts: 3765
Location: Gifhorn, Germany

PostPosted: Fri Dec 16, 2005 10:25 am    Post subject: Reply with quote

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... :oops:
_________________
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
View user's profile Send private message
SiLvEr40
n00b
n00b


Joined: 22 Dec 2005
Posts: 1

PostPosted: Thu Dec 22, 2005 9:40 am    Post subject: help Reply with quote

Hello,
I am gentoo newbie :oops: 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 :oops:
Back to top
View user's profile Send private message
Spida
Tux's lil' helper
Tux's lil' helper


Joined: 08 Feb 2003
Posts: 97
Location: Germany

PostPosted: Tue Feb 14, 2006 1:10 am    Post subject: Reply with quote

[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
View user's profile Send private message
[clu]
Apprentice
Apprentice


Joined: 23 Feb 2004
Posts: 160
Location: 127.0.0.1

PostPosted: Fri Mar 03, 2006 4:55 pm    Post subject: Reply with quote

can't insert cyrillic letters - they appears as question marks ('?')...
Back to top
View user's profile Send private message
eagle_cz
Apprentice
Apprentice


Joined: 06 Jun 2003
Posts: 214

PostPosted: Sun Mar 19, 2006 9:22 pm    Post subject: Re: Quick note Reply with quote

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
View user's profile Send private message
zeek
Guru
Guru


Joined: 16 Nov 2002
Posts: 480
Location: Bantayan Island

PostPosted: Sun Jul 15, 2007 7:51 am    Post subject: Reply with quote

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
View user's profile Send private message
think4urs11
Bodhisattva
Bodhisattva


Joined: 25 Jun 2003
Posts: 6659
Location: above the cloud

PostPosted: Tue Feb 19, 2008 12:36 pm    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Networking & Security All times are GMT
Goto page Previous  1, 2
Page 2 of 2

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum