Bug #11800 | Problems with multiple versions (4.0, 4.1) with mysqld_safe | ||
---|---|---|---|
Submitted: | 8 Jul 2005 0:01 | Modified: | 8 Jul 2005 18:00 |
Reporter: | David Koopman | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: Installing | Severity: | S3 (Non-critical) |
Version: | 4.1.12 | OS: | Linux (RH Linux 2.4.18-18.8.0smp) |
Assigned to: | CPU Architecture: | Any |
[8 Jul 2005 0:01]
David Koopman
[8 Jul 2005 0:28]
David Koopman
I've posted this problem on my website, if anyone wants to discuss it with me off the mysql website: http://www.modphp.org/viewtopic.php?t=394
[8 Jul 2005 11:14]
Geert Vanderkelen
Hi, I'm starting sometimes 5 versions all at once using mysqld_safe, and 'never' had problems. Similar setup as yours. There must be something missing, can't see it right away. Instead of opening a thread on external forums, can you make one on ours? http://forums.mysql.com/list.php?11 If the outcome is a bug in mysqld_safe, then we can continue with the bug report :) Thanks, Geert
[8 Jul 2005 17:54]
David Koopman
I think you are right, there was something missing. I moved to a new machine that does not have MySQL on it at all, then did this: cd /usr/local tar -xzf src/mysql-standard-4.1.12-pc-linux-gnu-i686.tar.gz ln -s mysql-standard-4.1.12-pc-linux-gnu-i686 mysql-41 cd mysql-41 /usr/sbin/groupadd mysql /usr/sbin/useradd -g mysql mysql scripts/mysql_install_db --user=mysql chown -R root . chown -R mysql data chgrp -R mysql . echo '[mysqld] basedir=/usr/local/mysql-41 datadir=/usr/local/mysql-41/data port=3306 socket=/tmp/mysql-41.sock skip-locking key_buffer=16M max_allowed_packet=16M table_cache=64 sort_buffer_size=512K net_buffer_length=8K read_buffer_size=256K read_rnd_buffer_size=512K myisam_sort_buffer_size=8M server-id = 1' > /etc/my-41.cnf cd / This command: /usr/local/mysql-41/bin/mysqld_safe --defaults-file=/etc/my-41.cnf --user=mysql & Produces: /usr/local/mysql-41/bin/mysqld_safe: line 1: my_print_defaults: command not found /usr/local/mysql-41/bin/mysqld_safe: line 1: my_print_defaults: command not found The file /usr/local/mysql/bin/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/mysqld_safe. See http://dev.mysql.com/doc/mysql/en/mysqld_safe.html for more information [1]+ Exit 1 /usr/local/mysql-41/bin/mysqld_safe --defaults-file=/etc/my-41.cnf --user=mysql (Note: No error log was created.) This command: cd /usr/local/mysql-41 bin/mysqld_safe --defaults-file=/etc/my-41.cnf --user=mysql & Produces: Starting mysqld daemon with databases from /usr/local/mysql-41/data So, it works fine, as long as you cd to the /usr/local/mysql-41/ directory first, then call bin/mysqld_safe. Works for me! I looked at my first machine to find out why it was so broken there and discovered this: $ rpm -qa | grep -i mysql MySQL-client-4.0.9-0 MySQL-devel-4.0.9-0 MySQL-Max-4.0.9-0 MySQL-shared-3.23.56-1.0.23 MySQL-4.0.9-0 Bunch of RPMs that I didn't know where there and are not in use. So, I did a: rpm -e MySQL-client-4.0.9-0 MySQL-devel-4.0.9-0 MySQL-Max-4.0.9-0 MySQL-shared-3.23.56-1.0.23 MySQL-4.0.9-0 Then I ran: cd /usr/local/mysql-4.1 bin/mysqld_safe --defaults-file=/etc/my-4.1-1.cnf --max-connect-errors=10000 --user=mysql & ... and now it works fine! So, the problem has something to do with the existence of one of those older RPMs. Sorry for the mis-reported bug, but hopefully this will help someone else that runs into this.
[8 Jul 2005 18:00]
Geert Vanderkelen
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug. Support on using our products is available both free in our forums at http://forums.mysql.com and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/ Thank you for your interest in MySQL. Additional info: Doh, yeah, true, missed that :) Actually, it's documented: http://dev.mysql.com/doc/mysql/en/unix-post-installation.html Put it as reply on your forum on modphp.org, so people know ;) Cheers, Geert
[9 Jul 2005 4:15]
David Koopman
I updated my site http://www.modphp.org/viewtopic.php?t=394 to include the link you provided, and I posted the nutshell of the issue here: http://forums.mysql.com/read.php?11,33600,33600 in case anybody cares to discuss it further.