Problem with mySQL and Mac OS X
Hi, I've recently been having some problems with mySQL on one of my OS X computers. It was working perfectly until I upgraded from OS 10.2.6 to OS 10.2.8, and now mysqld refuses to start up, showing the following -- [EMAIL PROTECTED] mysql]$ sudo ./bin/mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 031220 01:08:05 mysqld ended [EMAIL PROTECTED] mysql]$ -- The error log shows the following: -- 031220 01:08:05 mysqld started 031220 1:08:05 Can't start server : Bind on unix socket: Permission denied 031220 1:08:05 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 031220 1:08:05 Aborting -- I've tried reinstalling mySQL, I've repaired permissions, I've also done some fairly radical things with permissions, but to no avail. If anyone has any suggestions, I'd be incredibly grateful. I'm running mySQL (standard) 4.1.1a for MacOS X, running under MacOS 10.2.8. Thanks for any help, -Jon --- http://www.jonpearse.net[EMAIL PROTECTED] Some people come into our lives and quickly go. Some stay for a while and leave footprints on our hearts. And we are never, ever the same. --- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem with mySQL and Mac OS X
I'm running mysql 4.0.17 on Mac OS X 10.2.8 without problems. My first guess would be that the upgrade reset the permissions on /tmp, so now the mysql user doesn't have permission to create mysql.sock. Try cd /tmp sudo chmod 1777 . then see if mysqld will start. (While you're in /tmp, make sure there isn't an old mysql.sock still sitting there.) Michael Jon Pearse wrote: Hi, I've recently been having some problems with mySQL on one of my OS X computers. It was working perfectly until I upgraded from OS 10.2.6 to OS 10.2.8, and now mysqld refuses to start up, showing the following -- [EMAIL PROTECTED] mysql]$ sudo ./bin/mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 031220 01:08:05 mysqld ended [EMAIL PROTECTED] mysql]$ -- The error log shows the following: -- 031220 01:08:05 mysqld started 031220 1:08:05 Can't start server : Bind on unix socket: Permission denied 031220 1:08:05 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 031220 1:08:05 Aborting -- I've tried reinstalling mySQL, I've repaired permissions, I've also done some fairly radical things with permissions, but to no avail. If anyone has any suggestions, I'd be incredibly grateful. I'm running mySQL (standard) 4.1.1a for MacOS X, running under MacOS 10.2.8. Thanks for any help, -Jon --- http://www.jonpearse.net[EMAIL PROTECTED] Some people come into our lives and quickly go. Some stay for a while and leave footprints on our hearts. And we are never, ever the same. --- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem reinstalling MySQL on Mac OS X
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, thanks for reporting this. I assume, you used the MySQL package from mysql.com? On Thu, 6 Mar 2003, Perry Arnold wrote: I installed the MySQL binary (4.0.11-gamma package) on my Mac OS X machine (version 10.2.4) and I couldn't get it to start up. When I run bin/mysqld_safe, I kept getting the error Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist [note: I later figured out that I *think* I'm getting this error because my machine does not have a recognizable hostname (i.e. you can't look it up via normal DNS)]. Hmm, this case is currently not properly handled, indeed. Thanks for the hint! mysql_install_db simply aborts, if the host name cannot be resolved, but the error does not get fed back to the installer itself... After mucking around for quite a while without much success, I decided to start over and reinstall from scratch. So, I deleted my mysql directory and reinstalled from the Package. Now, when I try to run bin/mysqld_safe, I get the following error: InnoDB: Operating system error number 13 in a file operation. It looks like when you reinstall from the package, it skips the step where it changes file permissions of the data directory and its subdirectories. How-To-Repeat: On a fresh MacOS X 10.2.4 system, (1) install the 4.0.11-gamma package, (2) delete the mysql directories (the /usr/local/mysql link and /usr/local/mysql-standard-4.0.11-gamma-apple-darwin6.4-powerpc directory), (3) install the 4.0.11 package again, (4) run bin/mysqld_safe. Fix: Change the file permissions of the data directory and its subdirectories. Ideally, this would be fixed within the Package installer, but a release note or something would work as well. This is interesting. Are you sure you removed all mysql directories in /usr/local? The installation package includes a postinstall script, that does the following: [SNIP] if cd /usr/local/mysql ; then if [ ! -f data/mysql/db.frm ] ; then ./scripts/mysql_install_db fi if [ -d data ] ; then chown -R mysql data fi else exit $? fi [SNIP] /usr/local/mysql is a symlink, pointing to the real installation directory and is included in the package itself. So if you really removed all files, the ownerships should have been set up correctly. Unfortunately it's very hard to debug this problem, since the Package Installer does not offer any logging functionality... After looking through your mail again, I wonder how you tried to start MySQL. Did you use sudo mysqld_safe, as described in the docs? If you try it as a normal user (omitting sudo, the directory permissions and ownerships indeed will give you a permission denied error message. This is intentional! Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE+eJjQSVDhKrJykfIRAu9eAJ9AWiSgVNOB9e3LMMxzllQ2VTNESQCfa/mg /FXb3eaPfsHvOtK0zfPXqsg= =glQe -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem reinstalling MySQL on Mac OS X
Description: I installed the MySQL binary (4.0.11-gamma package) on my Mac OS X machine (version 10.2.4) and I couldn't get it to start up. When I run bin/mysqld_safe, I kept getting the error Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist [note: I later figured out that I *think* I'm getting this error because my machine does not have a recognizable hostname (i.e. you can't look it up via normal DNS)]. After mucking around for quite a while without much success, I decided to start over and reinstall from scratch. So, I deleted my mysql directory and reinstalled from the Package. Now, when I try to run bin/mysqld_safe, I get the following error: InnoDB: Operating system error number 13 in a file operation. It looks like when you reinstall from the package, it skips the step where it changes file permissions of the data directory and its subdirectories. How-To-Repeat: On a fresh MacOS X 10.2.4 system, (1) install the 4.0.11-gamma package, (2) delete the mysql directories (the /usr/local/mysql link and /usr/local/mysql-standard-4.0.11-gamma-apple-darwin6.4-powerpc directory), (3) install the 4.0.11 package again, (4) run bin/mysqld_safe. Fix: Change the file permissions of the data directory and its subdirectories. Ideally, this would be fixed within the Package installer, but a release note or something would work as well. Submitter-Id: Perry Arnold/[EMAIL PROTECTED] Originator: Organization: organization of PR author (multiple lines) MySQL support: none Synopsis: MacOS Installation Bug Severity: serious Priority: low Category: mysql Class: sw-bug Release:mysql-4.0.11-gamma-standard (Official MySQL-standard binary) C compiler:gcc (GCC) 3.1 20020420 (prerelease) C++ compiler: gcc (GCC) 3.1 20020420 (prerelease) Environment: PowerMac Dual 1.25Ghz/OS X 10.2.4 System: Darwin localhost 6.4 Darwin Kernel Version 6.4: Wed Jan 29 18:50:42 PST 2003; root:xnu/xnu-344.26.obj~1/RELEASE_PPC Power Macintosh powerpc Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/libexec/gcc/darwin/ppc/3.1/specs Thread model: posix Apple Computer, Inc. GCC version 1175, based on gcc version 3.1 20020420 (prerelease) Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' ASFLAGS='' LIBC: lrwxr-xr-x 1 root wheel 15 Mar 3 18:32 /usr/lib/libc.dylib - libSystem.dylib Configure command: ./configure '--prefix=/usr/local/mysql' '--with-comment=Official MySQL-standard binary' '--with-extra-charsets=complex' '--with-server-suffix=-standard' '--enable-thread-safe-client' '--enable-local-infile' '--disable-shared' '--with-innodb' 'CC=gcc' 'CFLAGS=-O3 -fno-omit-frame-pointer' 'CXXFLAGS=-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' 'CXX=gcc' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem installing mySql on Mac OS X
I am having a few problems with the install. First off Mac OS X does not support the groupadd or useradd commands. Next the scripts/mysql_install_db fails and tells me to look for more i\ nformation in ./data logs, however in the data directory there are no log files\ . How-To-Repeat: Follow the instructions in the INSTALL-BINARY file. Fix: ??? Submitter-Id: submitter ID Originator:System Administrator Organization: organization of PR author (multiple lines) MySQL support: none Synopsis: Installing on Mac OS X Severity: critical Priority: medium Category: mysql Class: support Release: mysql-3.23.42-apple-rhapso (Official MySQL binary) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem installing mySql on Mac OS X
This site has precompiled MySQL binaries for Mac OS X: http://www.entropy.ch/software/macosx/mysql/ It also has easy to follow installation instructions. You need to use your Users utility to add the MySQL user instead of the useradd and groupadd commands. Complete instructions are at the site. On Thursday, September 13, 2001, at 05:39 PM, [EMAIL PROTECTED] wrote: I am having a few problems with the install. First off Mac OS X does not support the groupadd or useradd commands. Next the scripts/mysql_install_db fails and tells me to look for more i\ nformation in ./data logs, however in the data directory there are no log files\ . How-To-Repeat: Follow the instructions in the INSTALL-BINARY file. Fix: ??? Submitter-Id: submitter ID Originator:System Administrator Organization: organization of PR author (multiple lines) MySQL support: none Synopsis: Installing on Mac OS X Severity: critical Priority: medium Category: mysql Class: support Release: mysql-3.23.42-apple-rhapso (Official MySQL binary) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php