MySQL 5.1.41 compatible with Mac OS X Server 10.6?
Hi, I've installed MySQL 5.1.41 x86_64 on fresh install of Mac OS X Server 10.6.2 (where the bundled version is 5.0.82. Just a couple questions: 1. Have any of your encountered compatibility issues with MySQL 5.1.x on Mac OS X Server 10.6.2? (Since I am in the process of migrating several MySQL+PHP applications over from Server 10.4.x and thought it worthwhile to ask.) 2. Installing MySQL 5.1.41 went fine -- no complaints from the installer. Now, I'm wondering how to hook-up the Server Admin MySQL Service to this newly installed MySQL instead of the bundled version. (Such that it mysqld 5.1.41 starts at bootup, and the nice move data directory feature of the Server Admin service works. Thanks! ...Rene -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
MySQL quits serving on Mac OS X Server 10.2
Hello all, All of a sudden, we are having MySQL (3.23.51) quit serving, running on OS X Server (10.2.1). This particular box has been running flawlessly for a month. There are about 140 databases on it. When I log in via shell and do a show databases; I get this: ++ | Database | ++ | Mount01| | Mount02| | Mount03| | Mount04| | mds| | vi.recover | | zBooterMnt | ++ 7 rows in set (0.00 sec) What the heck does that mean? If I reboot the server, everything comes back fine again. How can I track down what is happening to cause this? Thanks for any advice! Bill -- Bill Leonard [EMAIL PROTECTED] www.machinemen.com - 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: MySQL quits serving on Mac OS X Server 10.2
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday 18 November 2002 13:37, Bill Leonard wrote: All of a sudden, we are having MySQL (3.23.51) quit serving, running on OS X Server (10.2.1). This particular box has been running flawlessly for a month. There are about 140 databases on it. When I log in via shell and do a show databases; I get this: ++ | Database | ++ | Mount01| | Mount02| | Mount03| | Mount04| | mds| | vi.recover | | zBooterMnt | ++ 7 rows in set (0.00 sec) What the heck does that mean? If I reboot the server, everything comes back fine again. How can I track down what is happening to cause this? You have experienced a bug that Mac OS X seems to have inherited from FreeBSD, which shows a similar behaviour. For a very detailed description, see this entry in Jeremy's blog http://jeremy.zawodny.com/blog/archives/000264.html#000264 Current versions of MySQL for Mac OS X have been compiled with the - -DHAVE_BROKEN_REALPATH option to work around this problem. 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.0 (GNU/Linux) iD8DBQE92OeySVDhKrJykfIRAjS3AJ0Z/raY0aX4ZEhnUcs00z5KVpDy3ACfYanV QHV9LrxB3G3qdmGw0fiuplM= =+7Ob -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
Re: MySQL quits serving on Mac OS X Server 10.2
In the last episode (Nov 18), Lenz Grimmer said: You have experienced a bug that Mac OS X seems to have inherited from FreeBSD, which shows a similar behaviour. For a very detailed description, see this entry in Jeremy's blog http://jeremy.zawodny.com/blog/archives/000264.html#000264 Current versions of MySQL for Mac OS X have been compiled with the - -DHAVE_BROKEN_REALPATH option to work around this problem. Could one of you submit a problem report to the FreeBSD people (use the send-pr command on the system you see the problem on)? They can't fix bugs they don't know about :) -- Dan Nelson [EMAIL PROTECTED] - 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: MySQL quits serving on Mac OS X Server 10.2
On Mon, Nov 18, 2002 at 09:54:21AM -0600, Dan Nelson wrote: In the last episode (Nov 18), Lenz Grimmer said: You have experienced a bug that Mac OS X seems to have inherited from FreeBSD, which shows a similar behaviour. For a very detailed description, see this entry in Jeremy's blog http://jeremy.zawodny.com/blog/archives/000264.html#000264 Current versions of MySQL for Mac OS X have been compiled with the - -DHAVE_BROKEN_REALPATH option to work around this problem. Could one of you submit a problem report to the FreeBSD people (use the send-pr command on the system you see the problem on)? They can't fix bugs they don't know about :) Based on talking with our FreeBSD guys at work, I got the impression they are well aware of the problem. Interestingly, it seems to only affect users on LinuxThreads. The native FreeBSD threads implementation appears not to trigger the problem. But there are so many problems with FreeBSD's native threads that I'm not sure why you'd want to use them... Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 104 days, processed 2,258,639,256 queries (250/sec. avg) - 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
Enabling MySQL on Mac OS X Server
Does anyone know if these instructions actually work? (they didn't for me) http://cerebus.sandiego.edu/~jerry/UnixTips/mysql.html I'd like to fix them up so I and others never have to seek this out again, tall order? Who can help me? after I followed these the server didn't start. I had to use the --force option to install the default dbases. I will say that my particular problem may be due to my lack setting my host name correctly. I have very recently installed OS X Server (10.1.4) just so I could try this on a clean system. I don't understand too much about host names, here's what I do know: I have host names that I get from dynydns.org, e.g., mbase.dyndns.org. the Domain Name Servers in my Network settings are pointed to my provider's DNS numbers. I have many of these host and I know which one the main one is. This setup works great and I have had MySQL running on this before and similarly on OS X client. I simply want to to use/enable the MySQL that comes with OS X Server. I have written Apple about exactly the same. Thanks Lloyd - 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
MAC OS X Server
New error msg, I think I have permissions right 020711 08:37:57 mysqld started 020711 8:37:57 /usr/libexec/mysqld: Can't create/write to file '/usr/var/e-mac .pid' (Errcode: 13) 020711 8:37:57 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno : 13) 020711 8:37:57 /usr/libexec/mysqld: Error on delete of '/usr/var/e- mac.pid' (E rrcode: 2) 020711 08:37:57 mysqld ended 020711 08:38:46 mysqld started 020711 8:38:46 /usr/libexec/mysqld: Can't create/write to file '/usr/var/e-mac .pid' (Errcode: 13) 020711 8:38:46 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno : 13) 020711 8:38:46 /usr/libexec/mysqld: Error on delete of '/usr/var/e- mac.pid' (E rrcode: 2) - 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: MAC OS X Server
A. John Peters wrote: New error msg, I think I have permissions right No you don't. Mysql must own the database directories and files. 020711 08:37:57 mysqld started 020711 8:37:57 /usr/libexec/mysqld: Can't create/write to file '/usr/var/e-mac .pid' (Errcode: 13) 020711 8:37:57 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno : 13) 020711 8:37:57 /usr/libexec/mysqld: Error on delete of '/usr/var/e- mac.pid' (E rrcode: 2) 020711 08:37:57 mysqld ended 020711 08:38:46 mysqld started 020711 8:38:46 /usr/libexec/mysqld: Can't create/write to file '/usr/var/e-mac .pid' (Errcode: 13) 020711 8:38:46 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno : 13) 020711 8:38:46 /usr/libexec/mysqld: Error on delete of '/usr/var/e- mac.pid' (E rrcode: 2) - 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 - 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: MAC OS X Server
You can go this link and get MySQL in package form it works great... http://www.entropy.ch/software/MacOSx/mysql Hope this helps. Chuck Payne Magi Design and Support http://www.magidesign.com - 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: MAC OS X Server
Got it on a none server machine I had typed my chown without the /P at the end. Also used the package from entropy. I may have used it before. John On Thursday, July 11, 2002, at 08:43 AM, A. John Peters wrote: New error msg, I think I have permissions right 020711 08:37:57 mysqld started 020711 8:37:57 /usr/libexec/mysqld: Can't create/write to file '/usr/var/e-mac .pid' (Errcode: 13) 020711 8:37:57 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno : 13) 020711 8:37:57 /usr/libexec/mysqld: Error on delete of '/usr/var/e- mac.pid' (E rrcode: 2) 020711 08:37:57 mysqld ended 020711 08:38:46 mysqld started 020711 8:38:46 /usr/libexec/mysqld: Can't create/write to file '/usr/var/e-mac .pid' (Errcode: 13) 020711 8:38:46 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno : 13) 020711 8:38:46 /usr/libexec/mysqld: Error on delete of '/usr/var/e- mac.pid' (E rrcode: 2) - 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-ajpeters=otg- [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
binary test failed on Mac OS X Server 1.2
Description: binary test failed on Mac OS X Server 1.2 using mysql 3.23.40. Problem appears with both binary distribution and built from source according to manual instructions. How-To-Repeat: make test Fix: not known. Submitter-Id: submitter ID Originator:David Cake Organization: System Administration team tomandandy MySQL support: none Synopsis: fails binary test on Mac OS X Server 1.2 Severity: serious Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.40 (Source distribution) Environment: Power Computing, Mac OS X Server 1.2, rhapsody-ppc-5.6, pcthreads lib System: Rhapsody duchamp 5.6 Kernel Release 5.6: Tue Nov 23 15:07:38 PST 1999; root(rcbuilder):Objects/kernel-187.obj~2/RELEASE_PPC Copyright (c) 1988-1995,1997-1999 Apple Computer, Inc. All Rights Reserved. Power Macintosh Some paths: /usr/bin/perl /bin/make /usr/bin/cc Compilation info: CC='cc' CFLAGS='-O2 -fomit-frame-pointer' CXX='cc' CXXFLAGS='-O2 -fomit-frame-pointer' LDFLAGS='' LIBC: Configure command: ./configure --prefix=/usr/local/mysql --with-extra-charsets=complex --disable-shared Perl: This is perl, version 5.005_02 built for rhapsody - 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: Mac OS X Server 10.0.4 and startup
On 5/7/01 4:40 pm, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi -- Has anyone installed MySQL on MacOS X Server and has safe_mysqld start automatically at boot? On my LinuxPPC box, I add the provided startup script to the /etc/rc.d dir structure. In MacOS X, there is no such directory. Thanks! Have a look at the instructions at: http://www.devshed.com/Server_Side/Administration/BuildingOnOSX/ It tells you how to build Apache, MySQL, and PHP on Mac OS X Client and in the instructions for MySQL it shows you how to create a start up item for it. I don't suppose it should be any different on Mac OS X Server. Cheers, Ian Fieldhouse - 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: Mac OS X Server 10.0.4 and startup
go here: and put it in that folder. http://www.diax.ch/users/liyanage/software/macosx/mysql-startupitem.pkg.tar.gz note that the user might have to be changed from its default mysql at the line: /usr/local/bin/safe_mysqld --user=mysql --err- TR At 11:06 PM -0400 7/5/01, Patrick Larkin wrote: I did find that directory. I created a dir called MySQL within and a file within that directory like so: #!/bin/sh /usr/local/mysql/bin/safe_mysqld and made the file executable (chmod 555) but it still didn't work. This is basically the same way that other software starts up (albeit with a mo complex script). I'm not sure what to do. Its not documented anywhere that I can find. From: Paul DuBois [EMAIL PROTECTED] Date: Thu, 5 Jul 2001 19:37:52 -0500 To: Patrick J. Larkin [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Mac OS X Server 10.0.4 and startup At 11:40 AM -0400 7/5/01, Patrick J. Larkin wrote: Hi -- Has anyone installed MySQL on MacOS X Server and has safe_mysqld start automatically at boot? On my LinuxPPC box, I add the provided startup script to the /etc/rc.d dir structure. In MacOS X, there is no such directory. Thanks! Have a look at: /System/Library/StartupItems and subdirectories therein. -- Patrick Larkin Information and Communications Technology Bethlehem Area School District -- Paul DuBois, [EMAIL PROTECTED] - 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 - 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 - 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: Mac OS X Server 10.0.4 and startup
Hi! I build mine successfully using the instructions at http://www.devshed.com/Server_Side/Administration/BuildingOnOSX/. That one including the startup item wich is edscribed there... Sincerely, Victor -- database,sql,query,table - 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: MAC OS X Server
Howdy: On 06/05/2001 15:42 USA PT (-0800), [EMAIL PROTECTED] ( Angela Neff ), wrote... Below is a link and article sent to me by a Consultant stating that MySQL works with the brand new MAC OS X Server. Has this indeed been thoroughly tested by MySQL programmers? I don't want to get one unless it works like a charm. I've been running MySQL for over a year on Mac OSX Server v.1.2.x with little or no problems ( though the install might be a bit non-standard ), so there shouldn't be any reason why it can't run happily on either the new OSX 10.x, or the newer OSX Server v.2.x ( at least the install will be more standard ). Also, is there or will there be a MAC My SQL listserv? Good question? Glenn - 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: MAC OS X Server
Apple has tested MySQL on MAC OS X to the best of my knowledge. Given that MAC OS X is essentially FreeBSD Unix with a pretty wrapping, it makes sense that MySQL would work easily. If someone said MySQL worked on MAC OS 9, or older, I would be more cautious. At 02:42 PM 6/5/01 -0800, Angela Neff wrote: Below is a link and article sent to me by a Consultant stating that MySQL works with the brand new MAC OS X Server. Has this indeed been thoroughly tested by MySQL programmers? I don't want to get one unless it works like a charm. Also, is there or will there be a MAC My SQL listserv? SOURCE: http://maccentral.macworld.com/news/0106/04.mysql.shtml Thanks, Angela Apple releases MySQL update Staff Report, [EMAIL PROTECTED] June 4, 2001, 4:25 pm ET If you're using a Mac configured with Mac OS X Server and MySQL, you should be aware of a new update in circulation. Apple's Software Downloads Web site now lists a new update for MySQL. MySQL 3.23.32 Update is available for download from Apple's site now. MySQL is a relational database management system developed by MySQL AB. The software exists as open source code, and is able to run on Mac OS X Server. In fact, MySQL is included with Mac OS X server, along with many other applications. The new update lists Mac OS X Server 10.0.3 as required to run the software, so make sure you're running the latest version of Mac OS X Server before downloading the update. Angela Neff :) (: Technology Director St. Matthew's Episcopal Day School 16 Baldwin Avenue San Mateo, California 94401 VOICE: 650.342.5436 x214 FAX: 650.342.4019 E-MAIL: [EMAIL PROTECTED] Growth is more than anything, a refining of a sense of truthfulness. --Willa Cather - 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 - 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
MAC OS X Server
Below is a link and article sent to me by a Consultant stating that MySQL works with the brand new MAC OS X Server. Has this indeed been thoroughly tested by MySQL programmers? I don't want to get one unless it works like a charm. Also, is there or will there be a MAC My SQL listserv? SOURCE: http://maccentral.macworld.com/news/0106/04.mysql.shtml Thanks, Angela Apple releases MySQL update Staff Report, [EMAIL PROTECTED] June 4, 2001, 4:25 pm ET If you're using a Mac configured with Mac OS X Server and MySQL, you should be aware of a new update in circulation. Apple's Software Downloads Web site now lists a new update for MySQL. MySQL 3.23.32 Update is available for download from Apple's site now. MySQL is a relational database management system developed by MySQL AB. The software exists as open source code, and is able to run on Mac OS X Server. In fact, MySQL is included with Mac OS X server, along with many other applications. The new update lists Mac OS X Server 10.0.3 as required to run the software, so make sure you're running the latest version of Mac OS X Server before downloading the update. Angela Neff :) (: Technology Director St. Matthew's Episcopal Day School 16 Baldwin Avenue San Mateo, California 94401 VOICE: 650.342.5436 x214 FAX: 650.342.4019 E-MAIL: [EMAIL PROTECTED] Growth is more than anything, a refining of a sense of truthfulness. --Willa Cather - 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
mySQL and Mac OS X Server
Hello all - I'm a new mySQL user and am interested to know if anyone has successfully installed mySQL in the Mac OS X Server environment - if so, is there a precompiled binary or install instructions for the platform? Thanks and sorry for the newbie question. Doug -- Doug Dockery [EMAIL PROTECTED] - 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