mysql 3.23.52 Jaguar compile failing
OS X 10.2, Mysql 3.23.52 I got past one failure by setting the -ltermcap flag in the configure file as suggested at macosxhints.com. Now the compile fails due to a missing header file: g++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local/m ysql\ -DDATADIR=\/usr/local/mysql/var\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DHAVE_CONFIG_H -I./../include -I./../regex -I. -I.. /include -I.. -I.-O3 -DDBUG_OFF -fno-implicit-templates -fno-exception s -fno-rtti -traditional-cpp -DHAVE_DARWIN_THREADS -D_P1003_1B_VISIBLE -DSIG NAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -c sql_udf.cc sql_udf.cc:57:19: dlfcn.h: No such file or directory I tried installing the dlcompat package from osxgnu.org but no change. That header file isn't to be found. Yes I installed the dev tools. Why don't you just use the binary package at whatever.ch?: Because I don't want to. Period. I want to compile these things myself. Using ./configure --with-prefix=/usr/local/mysql -- John McCauley - CTGi703-352-0590 The CTGi Web page: http://www.ctgusa.com The BMD web page: http://www.bmdc.org - 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: Remote admin app?
phpMyAdmin Great tool. - Original Message - From: neal [EMAIL PROTECTED] To: mySQL [EMAIL PROTECTED] Sent: Friday, August 30, 2002 4:07 PM Subject: Remote admin app? What do you guys use for remote admin of mySQL? mySQL-front? MySQLGUI? Other? What's most popular and why? Thanks! Neal - 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: starting mysqld on boot (Mac OS X 10.1.3)?
- Create a dir in /Library/StartupItems called mysql
- make a shell file called mysql containing (and make it executable)(this
assumes that user-id stuff is in /etc/my.cnf):
#!/bin/sh
. /etc/rc.common
if [ ${mysql:=-NO-} = -YES- ]; then
ConsoleMessage Starting MySQL Server
cd /usr/local/mysql;./bin/safe_mysqld
fi
- Make a file called StartupParameters.plist containing:
{
Description = MySQL Server;
Provides= (mysql);
Requires= (NetInfo);
OrderPreference = None;
Messages =
{
start = Starting MySQL Server;
stop = Stopping MySQL Server;
};
}
- edit /etc/hostconfig adding the following line:
mysql=-YES-
- That's it.
--
John McCauley - CTGi703-352-0590
The CTGi Web page: http://www.ctgusa.com
The BMD web page: http://www.bmdc.org
-
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
3.23.49 and still can't kill mysql in OS X
Compiled MySQL 3.23.49 from source and I still can't kill the server without -9 in OS X 10.1.3 sigh... -- John McCauley CTGi, Oakton, VA USA - 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
OS X kill problem still there in .48 release
Was hoping that the OS X no-can-stop-db problem might me rectified in the new .48 release of MySQL but, alas, I compiled from source and still can't kill the processes without the dreaded -9. Here's hoping that it gets fixed soon before I corrupt a database. I know that this is not a consistent problem across all OS X installs. -- John McCauley CTGi, Oakton, VA USA - 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 compile error, mysql-3.23.47, Mac OS X 10.1.2
Cool. And the file ./mysql-3.23.47/sql/sql_udf.cc is present? Did you try a make clean? It shouldn't have any effect on configure but... -- John McCauley CTGi Oakton, VA 703-352-0590 http://www.ctgusa.com From: Ryan Walker [EMAIL PROTECTED] Date: Wed, 30 Jan 2002 00:21:44 -0800 To: [EMAIL PROTECTED] Subject: Re: MySQL compile error, mysql-3.23.47, Mac OS X 10.1.2 Yes. Dumb question. You did install the OS X developer tools, yes? I just compiled 3.23.47 from source this morning on 10.1.2 with not a problem at all. -- John McCauley CTGi Oakton, VA 703-352-0590 http://www.ctgusa.com From: Ryan Walker [EMAIL PROTECTED] Date: Tue, 29 Jan 2002 18:40:12 -0800 To: [EMAIL PROTECTED] Subject: MySQL compile error, mysql-3.23.47, Mac OS X 10.1.2 I'm trying to compile MySQL on Mac OS X 10.1.2. Ideally, I'd like to compile it with: ./configure --with-mysqld-user=mysql \ --enable-thread-safe-client \ --with-pthread \ --with-raid Unfortunately, I can't even get it to compile with just: ./configure Produces error: sql_show.cc c++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local\ -DDATADIR=\/usr/local/var\ -DSHAREDIR=\/usr/local/share/mysql\ -DHAVE_CONFIG_H -I./../include -I./../regex -I. -I../include -I.. -I.-O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -traditional-cpp -DHAVE_DARWIN_THREADS -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -c sql_udf.cc sql_udf.cc:57: dlfcn.h: No such file or directory make[3]: *** [sql_udf.o] Error 1 make[2]: *** [all-recursive] Error 1 make[1]: *** [all-recursive] Error 1 make: *** [all-recursive-am] Error 2 Any suggestions? Ryan - 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: Workaround: Shutdown on OS X
No luck with that here. The daemon is unstoppable! -- John McCauley CTGi Oakton, VA 703-352-0590 http://www.ctgusa.com From: Steve Fox [EMAIL PROTECTED] Date: Wed, 30 Jan 2002 09:33:44 -0600 To: [EMAIL PROTECTED] Subject: Workaround: Shutdown on OS X For anyone having trouble with shutting down mysqld on OS X (especially if it times out waiting on the PID file): I had been having trouble getting mysql (3.23.26) to shutdown on OS X (10.1.1). I had been using sudo to start safe_mysqld with user mysql Now I su as user mysql to run safe_mysqld To stop I su mysql and run mysqladmin. I start and stop it frequently since its running on a laptop and I haven't had a shutdown problem since I started doing it this way. Steve Fox UT CMHC - 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
OS X still can't stop mysqld without sure kill
I compiled mysql 3.23.47 from source and still can't shutdown the daemon with a mysql.server stop or a simple kill command. Only way to stop it is with a kill -9. I previously installed the precompiled binary and had the same problem. I guess this isn't fully fixed with the .45 version as was posted, though it appears that some of you are not having the problem anymore. So how much potential damage am I doing with a sure kill? I'm running OS X 10.1.2 on an iBook 600. -- John McCauley CTGi Oakton, VA 703-352-0590 http://www.ctgusa.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 compile error, mysql-3.23.47, Mac OS X 10.1.2
Dumb question. You did install the OS X developer tools, yes? I just compiled 3.23.47 from source this morning on 10.1.2 with not a problem at all. -- John McCauley CTGi Oakton, VA 703-352-0590 http://www.ctgusa.com From: Ryan Walker [EMAIL PROTECTED] Date: Tue, 29 Jan 2002 18:40:12 -0800 To: [EMAIL PROTECTED] Subject: MySQL compile error, mysql-3.23.47, Mac OS X 10.1.2 I'm trying to compile MySQL on Mac OS X 10.1.2. Ideally, I'd like to compile it with: ./configure --with-mysqld-user=mysql \ --enable-thread-safe-client \ --with-pthread \ --with-raid Unfortunately, I can't even get it to compile with just: ./configure Produces error: sql_show.cc c++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local\ -DDATADIR=\/usr/local/var\ -DSHAREDIR=\/usr/local/share/mysql\ -DHAVE_CONFIG_H -I./../include -I./../regex -I. -I../include -I.. -I.-O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -traditional-cpp -DHAVE_DARWIN_THREADS -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -c sql_udf.cc sql_udf.cc:57: dlfcn.h: No such file or directory make[3]: *** [sql_udf.o] Error 1 make[2]: *** [all-recursive] Error 1 make[1]: *** [all-recursive] Error 1 make: *** [all-recursive-am] Error 2 Any suggestions? Ryan - 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: Mcan't stop daemon on OS X
[localhost:local/mysql/bin] root# ./mysqld -v ./mysqld Ver 3.23.47 for apple-darwin5.1 on powerpc On Sun, 27 Jan 2002 18:52:34 -0600 Paul DuBois [EMAIL PROTECTED] wrote: At 19:21 -0500 1/27/02, John McCauley wrote: I'm running 3.23.47 on Mac OS X 10.1.2 and can't stop the mysqld without resorting to a kill -9 I read in a past post that this was fixed in 3.23.45. Any further info? Works for me. Is it possible your system actually is still running an older version of the server? -- John McCauley CTGi - http://www.ctgusa.com Oakton, VA USA [EMAIL PROTECTED] -- John McCauley CTGi - http://www.ctgusa.com Oakton, VA USA [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: Mcan't stop daemon on OS X
Nope. Binary dist from the mysql site. Looks like it's source time... -- John McCauley CTGi Oakton, VA 703-352-0590 http://www.ctgusa.com From: Paul DuBois [EMAIL PROTECTED] Date: Sun, 27 Jan 2002 20:42:49 -0600 To: John McCauley [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Mcan't stop daemon on OS X At 21:29 -0500 1/27/02, John McCauley wrote: [localhost:local/mysql/bin] root# ./mysqld -v ./mysqld Ver 3.23.47 for apple-darwin5.1 on powerpc % ./mysqld -v ./mysqld Ver 3.23.47 for apple-darwin5.2 on powerpc I built mine from source. Did you? On Sun, 27 Jan 2002 18:52:34 -0600 Paul DuBois [EMAIL PROTECTED] wrote: At 19:21 -0500 1/27/02, John McCauley wrote: I'm running 3.23.47 on Mac OS X 10.1.2 and can't stop the mysqld without resorting to a kill -9 I read in a past post that this was fixed in 3.23.45. Any further info? Works for me. Is it possible your system actually is still running an older version of the server? -- John McCauley CTGi - http://www.ctgusa.com Oakton, VA USA [EMAIL PROTECTED] -- John McCauley CTGi - http://www.ctgusa.com Oakton, VA USA [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
