Error Loading Apache2
Scott, thanks very much. The commands worked fine. Ryan, thank you. On my system, where apache2 loads fine, the permissions are: $ ls -l /Library/LaunchDaemons/org.macports.apache2.plist lrwxr-xr-x ?1 root ?wheel ?76 Feb 27 23:24 /Library/LaunchDaemons/org.macports.apache2.plist - /opt/local/etc/LaunchDaemons/org.macports.apache2/org.macports.apache2.plist $ ls -l /opt/local/etc/LaunchDaemons/org.macports.apache2/org.macports.apache2.plist -rw-r--r-- ?2 root ?wheel ?958 Feb 27 23:23 /opt/local/etc/LaunchDaemons/org.macports.apache2/org.macports.apache2.plist Here are my current permissions. ?Can you please tell me how to fix them using sudo chmod? $ ls -l /Library/LaunchDaemons/org.macports.apache2.plist lrwxr-xr-x ?1 root ?wheel ?76 Mar ?1 14:33 /Library/LaunchDaemons/org.macports.apache2.plist - /opt/local/etc/LaunchDaemons/org.macports.apache2/org.macports.apache2.plist $ ls -l /opt/local/etc/LaunchDaemons/org.macports.apache2/org.macports.apache2.plist -rw-rw-r--+ 2 root ?admin ?958 Mar ?1 14:33 /opt/local/etc/LaunchDaemons/org.macports.apache2/org.macports.apache2.plist sudo chmod g-w /opt/local/etc/LaunchDaemons/org.macports.apache2/org.macports.apache2.plist sudo chgrp wheel /opt/local/etc/LaunchDaemons/org.macports.apache2/org.macports.apache2.plist David ___ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
Error Loading Apache2
$ sudo port load apache2 Password: Error: Target org.macports.load returned: launchctl: Dubious permissions on file (skipping): /Library/LaunchDaemons/org.macports.apache2.plist nothing found to load Log for apache2 is at: /opt/local/var/macports/logs/_opt_local_var_macports_sources_rsync.macports.org_release_ports_www_apache2/main.log Error: Status 1 encountered during processing. To report a bug, see http://guide.macports.org/#project.tickets Here is a copy of the main.log: version:1 :debug:main Executing org.macports.main (apache2) :debug:load load phase started at Thu Mar 31 13:04:09 CDT 2011 :debug:load Executing org.macports.load (apache2) :error:load Target org.macports.load returned: launchctl: Dubious permissions on file (skipping): /Library/LaunchDaemons/org.macports.apache2.plist nothing found to load :debug:load Backtrace: launchctl: Dubious permissions on file (skipping): /Library/LaunchDaemons/org.macports.apache2.plist nothing found to load while executing exec $launchctl_path load -w $path (procedure portload::load_main line 11) invoked from within $procedure $targetname :info:load Warning: the following items did not execute (for apache2): org.macports.load :notice:load Log for apache2 is at: /opt/local/var/macports/logs/_opt_local_var_macports_sources_rsync.macports.org_release_ports_www_apache2/main.log Help would be appreciated. David ___ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
Re: Error Loading Apache2
Ryan, $ sudo port load apache2 Password: Error: Target org.macports.load returned: launchctl: Dubious permissions on file (skipping): /Library/LaunchDaemons/org.macports.apache2.plist I'm not sure why the permissions on /Library/LaunchDaemons/org.macports.apache2.plist are wrong on your system, but they need to be fixed, using sudo chmod. On my system, where apache2 loads fine, the permissions are: $ ls -l /Library/LaunchDaemons/org.macports.apache2.plist lrwxr-xr-x 1 root wheel 76 Feb 27 23:24 /Library/LaunchDaemons/org.macports.apache2.plist - /opt/local/etc/LaunchDaemons/org.macports.apache2/org.macports.apache2.plist $ ls -l /opt/local/etc/LaunchDaemons/org.macports.apache2/org.macports.apache2.plist -rw-r--r-- 2 root wheel 958 Feb 27 23:23 /opt/local/etc/LaunchDaemons/org.macports.apache2/org.macports.apache2.plist Here are my current permissions. Can you please tell me how to fix them using sudo chmod? $ ls -l /Library/LaunchDaemons/org.macports.apache2.plist lrwxr-xr-x 1 root wheel 76 Mar 1 14:33 /Library/LaunchDaemons/org.macports.apache2.plist - /opt/local/etc/LaunchDaemons/org.macports.apache2/org.macports.apache2.plist $ ls -l /opt/local/etc/LaunchDaemons/org.macports.apache2/org.macports.apache2.plist -rw-rw-r--+ 2 root admin 958 Mar 1 14:33 /opt/local/etc/LaunchDaemons/org.macports.apache2/org.macports.apache2.plist David On Mar 31, 2011, at 1:56 PM, Ryan Schmidt wrote: On Mar 31, 2011, at 13:43, David Gentry wrote: $ sudo port load apache2 Password: Error: Target org.macports.load returned: launchctl: Dubious permissions on file (skipping): /Library/LaunchDaemons/org.macports.apache2.plist I'm not sure why the permissions on /Library/LaunchDaemons/org.macports.apache2.plist are wrong on your system, but they need to be fixed, using sudo chmod. On my system, where apache2 loads fine, the permissions are: $ ls -l /Library/LaunchDaemons/org.macports.apache2.plist lrwxr-xr-x 1 root wheel 76 Feb 27 23:24 /Library/LaunchDaemons/org.macports.apache2.plist - /opt/local/etc/LaunchDaemons/org.macports.apache2/org.macports.apache2.plist $ ls -l /opt/local/etc/LaunchDaemons/org.macports.apache2/org.macports.apache2.plist -rw-r--r-- 2 root wheel 958 Feb 27 23:23 /opt/local/etc/LaunchDaemons/org.macports.apache2/org.macports.apache2.plist ___ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
problems running mysql_install_db
Brad, David, it's most common on this list to use reply-all because using reply replies to the sender and not the list. Please fix your email account so our emails to you are not auto-replied with your anti-spam counter measures. Whoops. I did not have macports-users@lists.macosforge.org in my address book. Since I have added it, when someone on the list replies he or she should not encounter my email spamblocker. I apologize for the inconvenience. I also added a *@macports.org to my address book. I have not tried to use a * before so I don't know if it will work. David FWI, the wildcard * didn't seem to work :) I discovered that my webmail software through earthlink.net, which provides my spamblocker, allows domains to be added to its address book. I added lists.macosforge.org and macports.org. As far as I can tell, my mac mail address book does not allow domains to be added. I don't know if adding the domains to my webmail software will allow a new user to get through my spamblocker. Thanks, again, for your help. Much appreciated. David ___ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
problems running mysql_install_db5
Brad, David, it's most common on this list to use reply-all because using reply replies to the sender and not the list. Please fix your email account so our emails to you are not auto-replied with your anti-spam counter measures. Whoops. I did not have macports-users@lists.macosforge.org in my address book. Since I have added it, when someone on the list replies he or she should not encounter my email spamblocker. I apologize for the inconvenience. I also added a *@macports.org to my address book. I have not tried to use a * before so I don't know if it will work. David ___ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
problems running mysql_install_db5
Bradley, I ran the commands you gave me on Mar. 18, and they all ran fine except the very last one: $ mysqladmin5 -p -u root password 'x' Enter password: mysqladmin5: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)' David ___ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
problems running mysql_install_db5
Bradley, Concerning this command and output: $ /opt/local/lib/mysql5/bin/my_print_defaults client mysql mysqld --port=3306 --socket=__PREFIX/var/run/mysqld/mysqld.sock --skip-innodb --user=mysql --pid-file=__PREFIX/var/run/mysqld/mysqld.pid --socket=__PREFIX/var/run/mysqld/mysqld.sock --port=3306 --log=__PREFIX/var/log/mysql/mysql.log --basedir=/usr/local/mysql-5.5.6-rc-osx10.6-x86_64 --datadir=/usr/local/mysql-5.5.6-rc-osx10.6-x86_64/data --language=__PREFIX/share/mysql/english --skip-locking --set-variable=key_buffer=16M --set-variable=max_allowed_packet=1M --set-variable=thread_stack=128K --enable-named-pipe --connect_timeout=3 You wrote: Did you replace the actual prefix with __PREFIX or is that the unaltered output? __PREFIX is wrong. These paths should have the same prefix as your MacPorts install. Example: __PREFIX/var/run/mysqld/mysqld.sock should be /opt/local/var/run/mysqld/mysqld.sock That is unaltered output. Concerning this command and output: $ ls -la /etc/my.cnf/etc/mysql/my.cnf/opt/local/etc/mysql5/my.cnf ~/.my.cnf ls: /Users/davidgentry/.my.cnf: No such file or directory ls: /etc/my.cnf/etc/mysql/my.cnf/opt/local/etc/mysql5/my.cnf: Not a directory You wrote: There are spaces missing after each my.cnf. Try this: $ /opt/local/lib/mysql5/bin/my_print_defaults | grep my.cnf | xargs ls -l Sorry I missed the spaces. $ /opt/local/lib/mysql5/bin/my_print_defaults | grep my.cnf |xargs ls -l ls: /etc/mysql/my.cnf: No such file or directory ls: /opt/local/etc/mysql5/my.cnf: No such file or directory ls: ~/.my.cnf: No such file or directory -rw-rw-r-- 1 davidgentry admin 1616 Dec 16 21:38 /etc/my.cnf I am extremely encouraged by your optimism. I don't want to proceed with the clean-up until I report the above to you. Please let me know what I should do now. Is it OK to proceed with the clean-up? David ___ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
problems running mysql_install_db5
Bradley, Thank you for your response. I am responding to your request that I run 3 commands: $ /opt/local/lib/mysql5/bin/my_print_defaults client mysql mysqld --port=3306 --socket=__PREFIX/var/run/mysqld/mysqld.sock --skip-innodb --user=mysql --pid-file=__PREFIX/var/run/mysqld/mysqld.pid --socket=__PREFIX/var/run/mysqld/mysqld.sock --port=3306 --log=__PREFIX/var/log/mysql/mysql.log --basedir=/usr/local/mysql-5.5.6-rc-osx10.6-x86_64 --datadir=/usr/local/mysql-5.5.6-rc-osx10.6-x86_64/data --language=__PREFIX/share/mysql/english --skip-locking --set-variable=key_buffer=16M --set-variable=max_allowed_packet=1M --set-variable=thread_stack=128K --enable-named-pipe --connect_timeout=3 $ ls -la /etc/my.cnf/etc/mysql/my.cnf/opt/local/etc/mysql5/my.cnf ~/.my.cnf ls: /Users/davidgentry/.my.cnf: No such file or directory ls: /etc/my.cnf/etc/mysql/my.cnf/opt/local/etc/mysql5/my.cnf: Not a directory $ ls -l /opt/local/var/db total 0 drwxrwxr-x+ 4 root admin 136 Mar 14 13:23 mysql5 I searched for my.cnf on my Mac, and the only place I found it was: /opt/local/var/macports/sources/rsync.macports.org/release/ports/databases/mysql4/files/my.cnf The Finder calls it a document file. David ___ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
problems running mysql_install_db5
Bayard, Thank you for taking the time to do research and to provide advice. I am sort of glad the answer is not evident to you after your research. Maybe I am not insane. I have read the same documentation you have in the reference manual and as you quoted from mysql_install_db5. I have run the command both with -u mysql and, as you saw, without. I have specified the basedir as /opt/local/bin (where the aliases are) and as /opt/local/lib/mysql5/bin (where the original files are). I have specified the datadir as /opt/local/var/db/mysql5 because that appears to be the correct location for the datadir. I am sorry I don't have the knowledge of unix and shells that might help me better define the problem. Unless Bradley Giesbrecht can provide insight from my responses to his requests, I will turn to other sources for mysql as you recommended. Thanks, again. David ___ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
Please send contents of current mysqld file
Bayard, Maybe we are making progress. I am responding to your email: Message: 8 Date: Tue, 15 Mar 2011 02:02:02 + From: Bayard Bell buffer.g.overf...@googlemail.com To: David Gentry localbusinesswebsi...@earthlink.net Cc: Ryan Schmidt ryandes...@macports.org, MacPorts macports-users@lists.macosforge.org Subject: Re: Please send contents of current mysqld file Message-ID: 4dbe94ec-1229-4cf3-a77a-e0681d00b...@googlemail.com Content-Type: text/plain; charset=us-ascii I've got other ports running and thus don't have a chance at the moment to download and install mysql5-server, but the stock install includes the following: if test -z $basedir then basedir=/usr bindir=/usr/bin mysqld=/usr/libexec/mysqld pkgdatadir=/usr/share/mysql else As the post-destroot patches don't appear to change this. Maybe the next thing to try is to set --basedir to /opt/local and probably set --datadir as well and generally check the documentation for the command you've been asked to invoke. Following your suggestion, I ran: sudo mysql_install_db5 --basedir=/opt/local --datadir=/opt/local Password: FATAL ERROR: Could not find my_print_defaults The following directories were searched: /opt/local/bin /opt/local/extra If you compiled from source, you need to run 'make install' to copy the software into the correct location ready for operation. If you are using a binary release, you must either be at the top level of the extracted archive, or pass the --basedir option pointing to that location. I don't understand this result because my_print_defaults5, an alias file, is in /opt/local/bin which was searched. It appears that mysql_install_db5 could not properly treat an alias file. The original, my_print_defaults is in /opt/local/lib/mysql5/bin. Curiously, I ran: echo $PATH /opt/local/bin:/opt/local/sbin:/opt/local/bin:/opt/local/sbin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin Then, using the Finder, I got information about my_print_defaults and discovered that it is an executable file. So I ran: /opt/local/bin/my_print_defaults5 /opt/local/bin/my_print_defaults5 Ver 1.6 for apple-darwin10.6.0 at i386 This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Prints all arguments that is give to some program using the default files Usage: /opt/local/bin/my_print_defaults5 [OPTIONS] groups -c, --config-file=name Deprecated, please use --defaults-file instead. Name of config file to read; if no extension is given, default extension (e.g., .ini or .cnf) will be added -#, --debug[=#] This is a non-debug version. Catch this and exit -c, --defaults-file=name Like --config-file, except: if first option, then read this file only, do not read global or per-user config files; should be the first option -e, --defaults-extra-file=name Read this file after the global config file and before the config file in the users home directory; should be the first option -g, --defaults-group-suffix=name In addition to the given groups, read also groups with this suffix -e, --extra-file=name Deprecated. Synonym for --defaults-extra-file. -n, --no-defaults Return an empty string (useful for scripts). -?, --help Display this help message and exit. -v, --verbose Increase the output level -V, --version Output version information and exit. Default options are read from the following files in the given order: /etc/my.cnf /etc/mysql/my.cnf /opt/local/etc/mysql5/my.cnf ~/.my.cnf Variables (--variable-name=value) and boolean options {FALSE|TRUE} Value (after reading options) - - config-file my defaults-file my defaults-extra-file (No default value) defaults-group-suffix (No default value) extra-file(No default value) Example usage: /opt/local/bin/my_print_defaults5 --defaults-file=example.cnf client mysql I got lost here. My knowledge is not advanced enough to understand this result and construct a command. Am I on the right track? Where do I go from here? David ___ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
Please send contents of current mysqld file
Scott, Thank you very much for trying to help. I am responding to your message: What is the output of which mysql_install_db5? I don't think the macports version would search those directories? I ran: which mysql_install_db5 /opt/local/bin/mysql_install_db5 Following Bayard Bell's suggestion, I set a basedir and datadir of /opt/local, and I received a message that the program could not find my_print_defaults. For the rest of the story, please look at my response to Bayard. ___ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
Please send contents of current mysqld file
Andrea, Thank you very much for trying to help. I am responding to your message: Out of curiosity, can you paste your $PATH env variable? Seems you have /usr/local before MP's $prefix. I ran: echo $PATH /opt/local/bin:/opt/local/sbin:/opt/local/bin:/opt/local/sbin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin MacPorts is looking in the correct place -- /opt/local/bin -- and it appears it is looking there first. In /opt/local/bin is mysql_install_db5, which is an alias for mysql_install_db which is in /opt/local/lib/mysql5/bin. For a continuation of my saga, please look at my response of today to Bayard Bell. ___ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
Re: Please send contents of current mysqld file
Ryan, I don't trust my memory to put the files I moved back to their origins, so I uninstalled mysql5 @5.1.55_0 and mysql5-server @5.1.55_0. Then I installed them. Then, following the installation directions, I ran sudo port load mysql5-server. Then, again following the directions, I ran sudo -u _mysql mysql_install_db5 with this result: FATAL ERROR: Could not find mysqld The following directories were searched: /usr/local/mysql-5.5.6-rc-osx10.6-x86_64/libexec /usr/local/mysql-5.5.6-rc-osx10.6-x86_64/sbin /usr/local/mysql-5.5.6-rc-osx10.6-x86_64/bin If you compiled from source, you need to run 'make install' to copy the software into the correct location ready for operation. If you are using a binary release, you must either be at the top level of the extracted archive, or pass the --basedir option pointing to that location. Then, following the wiki which says if that command does not work try sudo mysql5_install_db5, I ran it with the same result as above. Then I tried this command: sudo -u mysql mysql_install_db5 with the same result as above. This is the command from the wiki. The command in the terminal installation directions is slightly different: sudo -u _mysql mysql_install_db5. Then, just for fun, I followed the wiki to see if the server is running. I ran ps -ax | grep mysql. The result was: 5406 ?? 0:00.02 /opt/local/bin/daemondo --label=mysql5 --start-cmd /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper start ; --stop-cmd /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper stop ; --restart-cmd /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper restart ; --pid=none 5875 ttys0000:00.00 grep mysql I have never run that command, but I see no error messages, so I suspect the server is running. Thanks for your patience, and I would appreciate any ideas you have. David On Mar 13, 2011, at 5:17 PM, Ryan Schmidt wrote: On Mar 10, 2011, at 15:10, David Gentry wrote: Bayard, I am responding to your message: It's not really clear what leads you to suspect corruption in the first instance. Perhaps we might start with how you get to that conclusion and work out a shared understanding of the problem on that basis? Please refer to my reply to rai...@macports.org which is message 10 is the list of March 9, 2011. If you don't have that message 10, I would be happy to repeat it for you. David, I assume you're referring to this message: http://lists.macosforge.org/pipermail/macports-users/2011-March/023756.html There, all you showed was that mysql_install_db5 was unable to find mysqld in directories under /usr/local/mysql-5.5.6-rc-osx10.6-x86_64. Those directories are where an official mysql.com installation of mysql would have put files, so that's not the correct place for a MacPorts mysql to be searching for things, and you already said you deleted all files there, so it's no surprise it can't find it there. This does not indicate mysqld is corrupt; it indicates mysql_install_db5 is searching for mysqld in the wrong places. We need to figure out why it's doing that. Following that, you started moving MacPorts-installed files around, which should not be necessary for success, so I'm not going to deal with anything past that point. Put all MacPorts-installed files back where they were, then we can investigate further. David J. Gentry President Good Things -- Small Packages, LLC 205-637-8000 dgen...@localbusinesswebsites.com www.localbusinesswebsites.com ___ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
Re: Please send contents of current mysqld file
Ryan, Thanks. I will track them down. I only moved 2 or 3 the second time around. I know which ones they were. I will find them and trash them. David On Mar 14, 2011, at 6:22 PM, Ryan Schmidt wrote: On Mar 14, 2011, at 14:48, David Gentry wrote: I don't trust my memory to put the files I moved back to their origins, so I uninstalled mysql5 @5.1.55_0 and mysql5-server @5.1.55_0. Then I installed them. Note that this will only uninstall the files from their original locations. Any files you moved will stay where you moved them. David J. Gentry President Good Things -- Small Packages, LLC 205-637-8000 dgen...@localbusinesswebsites.com www.localbusinesswebsites.com ___ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
Re: Please send contents of current mysqld file
Ryan, You suggested that I might have a rogue my.cnf file somewhere. I can find only one my.cnf on my Mac. The Finder says it is a Plain text file, and I opened it with TextEdit: # /etc/mysql/my.cnf: The global mysql configuration file. # This file can be simultaneously placed in three places: # 1. /etc/mysql/my.cnf to set global options. # 2. /var/lib/mysql/my.cnf to set server-specific options. # 3. ~/.my.cnf to set user-specific options. # # One can use all long options that the program supports. # Run the program with --help to get a list of them. # # The following values assume you have at least 32M RAM! [client] #password = my_password port= 3306 socket = __PREFIX/var/run/mysqld/mysqld.sock [safe_mysqld] err-log = __PREFIX/var/log/mysql/mysql.err pid-file= __PREFIX/var/run/mysqld/mysqld.pid socket = __PREFIX/var/run/mysqld/mysqld.sock [mysqld_safe] err-log = __PREFIX/var/log/mysql/mysql.err pid-file= __PREFIX/var/run/mysqld/mysqld.pid socket = __PREFIX/var/run/mysqld/mysqld.sock [mysqld] #skip-networking skip-innodb user= mysql pid-file= __PREFIX/var/run/mysqld/mysqld.pid socket = __PREFIX/var/run/mysqld/mysqld.sock port= 3306 log = __PREFIX/var/log/mysql/mysql.log basedir = __PREFIX datadir = __PREFIX/var/db/mysql tmpdir = /tmp language= __PREFIX/share/mysql/english skip-locking set-variable= key_buffer=16M set-variable= max_allowed_packet=1M set-variable= thread_stack=128K [mysqldump] quick set-variable= max_allowed_packet=1M [mysql] #no-auto-rehash # faster start of mysql but no tab completition [isamchk] set-variable= key_buffer=16 The location is /opt/local/var/macports/sources/rsync.macports.org/release/ports/databases/mysql4/files/. How do I determine if it is a rogue file? On March 10, I ran port contents mysql5, and I sent the results to Bradley with a copy to you. I don't see a my.cnf file in the contents of my mysql5 port. Is that a problem? Thanks in advance for your help. David On Mar 10, 2011, at 12:04 AM, Ryan Schmidt wrote: On Mar 9, 2011, at 12:54, David Gentry wrote: I did not mean to imply that the MacPorts file, mysqld, is corrupt. Somehow it is getting corrupted on my system, and I intend to find out how. I did not know that every system will treat mysqld differently. That is good to know. However, that information just adds to the mystery. My system is a bread and butter Mac OS X version 10.6.6. Not *every* system. But it differs based on OS version and processor architecture, at least. So if I send you the mysqld generated on my 64-bit Intel machine running Snow Leopard, that won't work for you if your Snow Leopard machine only has a 32-bit processor. It probably also won't work if you're running Leopard or Tiger, or a PowerPC processor. The reason I asked for the file contents, such as a text file, is that if I get the executable file my system might mess it up. mysqld is not a text file. It is a compiled executable program. I will continue to pursue other avenues to solve the mystery of why my system corrupts the MacPorts mysqld. As I have more information, I will pass it on to the email list. It might help someone. I doubt your mysqld is corrupt. Assuming you are following the wiki instructions correctly, and they are not working for you, I believe you have files on your system that are interfering with the normal way of setting up MacPorts MySQL. Perhaps a rogue my.cnf somewhere containing references to the files in /usr/local/mysql* that you already deleted. ___ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
Re: Please send contents of current mysqld file
I understand. Moving files around in other applications has not worked for me either. I was just experimenting with the MacPorts files, and I did learn some important things, such as basedir and srcdir which the MySQL 5.1 Reference Manual says are sometimes necessary to set up the main database. David On Mar 10, 2011, at 12:00 AM, Ryan Schmidt wrote: On Mar 9, 2011, at 16:09, David Gentry wrote: I can resolve that error by moving mysqld to the same directory as mysql_install_db We can't help you if you move things around after MacPorts has installed them into the proper locations... ___ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
Re: Please send contents of current mysqld file
Thanks for the info. I agree with your concluding diagnosis about possibly a rogue my.cnf somewhere. As I said, I have done my best to clean my system, but I will continue to do so. David On Mar 10, 2011, at 12:04 AM, Ryan Schmidt wrote: On Mar 9, 2011, at 12:54, David Gentry wrote: I did not mean to imply that the MacPorts file, mysqld, is corrupt. Somehow it is getting corrupted on my system, and I intend to find out how. I did not know that every system will treat mysqld differently. That is good to know. However, that information just adds to the mystery. My system is a bread and butter Mac OS X version 10.6.6. Not *every* system. But it differs based on OS version and processor architecture, at least. So if I send you the mysqld generated on my 64-bit Intel machine running Snow Leopard, that won't work for you if your Snow Leopard machine only has a 32-bit processor. It probably also won't work if you're running Leopard or Tiger, or a PowerPC processor. The reason I asked for the file contents, such as a text file, is that if I get the executable file my system might mess it up. mysqld is not a text file. It is a compiled executable program. I will continue to pursue other avenues to solve the mystery of why my system corrupts the MacPorts mysqld. As I have more information, I will pass it on to the email list. It might help someone. I doubt your mysqld is corrupt. Assuming you are following the wiki instructions correctly, and they are not working for you, I believe you have files on your system that are interfering with the normal way of setting up MacPorts MySQL. Perhaps a rogue my.cnf somewhere containing references to the files in /usr/local/mysql* that you already deleted. David J. Gentry President Good Things -- Small Packages, LLC 205-637-8000 dgen...@localbusinesswebsites.com www.localbusinesswebsites.com ___ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
Please send contents of current mysqld file
Bayard, I am responding to your message: It's not really clear what leads you to suspect corruption in the first instance. Perhaps we might start with how you get to that conclusion and work out a shared understanding of the problem on that basis? Please refer to my reply to rai...@macports.org which is message 10 is the list of March 9, 2011. If you don't have that message 10, I would be happy to repeat it for you. Regards, David ___ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
Re: Please send contents of current mysqld file
Ryan, I did not mean to imply that the MacPorts file, mysqld, is corrupt. Somehow it is getting corrupted on my system, and I intend to find out how. I did not know that every system will treat mysqld differently. That is good to know. However, that information just adds to the mystery. My system is a bread and butter Mac OS X version 10.6.6. The reason I asked for the file contents, such as a text file, is that if I get the executable file my system might mess it up. I will continue to pursue other avenues to solve the mystery of why my system corrupts the MacPorts mysqld. As I have more information, I will pass it on to the email list. It might help someone. From what I have learned, at this point I doubt that the MacPorts wiki is out of date. David On Mar 9, 2011, at 12:06 AM, Ryan Schmidt wrote: On Mar 8, 2011, at 19:51, David Gentry wrote: My Mac appears to corrupt the mysqld file whenever I download mysql5 and mysql5-server from MacPorts. I would very much like to see a current copy of the contents of mysqld. Maybe that way I can determine what my Mac is doing to mysqld. Could someone please send me a copy of the contents of mysqld? I can 100% assure you that if MacPorts extracts the downloaded file (and then patches, configures, builds, destroots, and installs it), it is not corrupt. MacPorts includes checksums on all distfiles and will not proceed if the file you downloaded is not exactly byte-for-byte the same file that I (in the case of the mysql ports) verified works correctly. mysqld is a compiled program, and how it is compiled depends on your operating system version and processor architecture. So getting one from someone else won't necessarily get you something that works on your system. From what you've written on this topic before, I have no reason so far to believe there is a fault in the mysqld program particularly. It's certainly possible our instructions in the wiki have gone out of date; I have not tried to follow them in a long time. David J. Gentry President Good Things -- Small Packages, LLC 205-637-8000 dgen...@localbusinesswebsites.com www.localbusinesswebsites.com ___ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
Fwd: Please send contents of current mysqld file
Rainer, I am responding to your message of today: On 03/09/2011 02:51 AM, David Gentry wrote: My Mac appears to corrupt the mysqld file whenever I download mysql5 and mysql5-server from MacPorts. I would very much like to see a current copy of the contents of mysqld. Maybe that way I can determine what my Mac is doing to mysqld. Could someone please send me a copy of the contents of mysqld? What makes you think it is corrupt? What is the error message or behavior you are seeing? The behavior I am seeing: I am following the MacPorts wiki, and I run either sudo -u mysql mysql_install_db5 or sudo mysql_install_db5. I get the same response: FATAL ERROR: Could not find mysqld The following directories were searched: /usr/local/mysql-5.5.6-rc-osx10.6-x86_64/libexec /usr/local/mysql-5.5.6-rc-osx10.6-x86_64/sbin /usr/local/mysql-5.5.6-rc-osx10.6-x86_64/bin If you compiled from source, you need to run 'make install' to copy the software into the correct location ready for operation. If you are using a binary release, you must either be at the top level of the extracted archive, or pass the --basedir option pointing to that location. I had trashed the directories searched, and then I had run secure empty trash. I can resolve that error by moving mysqld to the same directory as mysql_install_db, namely /opt/local/lib/mysql5/bin/, and then running sudo mysql_install_db5 --basedir=/opt/local/lib/mysql5/bin. The response is: FATAL ERROR: Could not find my_print_defaults The following directories were searched: /opt/local/lib/mysql5/bin/bin /opt/local/lib/mysql5/bin/extra If you compiled from source, you need to run 'make install' to copy the software into the correct location ready for operation. If you are using a binary release, you must either be at the top level of the extracted archive, or pass the --basedir option pointing to that location. If I move my_print_defaults to the same basedir as mysqld and mysql_install_db5, then the above error message will be resolved but another will appear concerning another file. If I move that file to the basedir, I will get another error message about another file. After I move 5-7 files and run the same command, I will get a message like Establishing tables [I don't remember the exact words] and the text of mysqld: 110309 14:31:30 [Warning] '--log' is deprecated and will be removed in a future release. Please use ''--general_log'/'--general_log_file'' instead. 110309 14:31:30 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead. 110309 14:31:30 [Warning] /opt/local/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead. 110309 14:31:30 [Warning] /opt/local/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead. 110309 14:31:30 [Warning] /opt/local/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead. 110309 14:31:30 [ERROR] Can't find messagefile '/usr/local/mysql-5.5.6-rc-osx10.6-x86_64/share/mysql5/mysql/__PREFIX/share/mysql/english/errmsg.sys' 110309 14:31:30 [Warning] Can't create test file /usr/local/mysql-5.5.6-rc-osx10.6-x86_64/data/DAVID.lower-test 110309 14:31:30 [Warning] Can't create test file /usr/local/mysql-5.5.6-rc-osx10.6-x86_64/data/DAVID.lower-test /opt/local/libexec/mysqld: Can't change dir to '/usr/local/mysql-5.5.6-rc-osx10.6-x86_64/data/' (Errcode: 2) 110309 14:31:30 [ERROR] Aborting 110309 14:31:30 [Note] Except for the timestamp, the text is the same as when I run /opt/local/lib/mysql5/bin/mysqld. The aborting message to me means that mysqld does not run fully. It seems to get derailed at the first ERROR message by a file which has been securely deleted from my Mac: /usr/local/mysql-5.5.6-rc-osx10.6-x86_64. Today, I did not go further than moving mysqld and my_print_defaults to a basedir [the same directory as mysql_install_db5]. A day or two ago, I moved 5-7 files as I describe above. Today, before I moved mysqld and my_print_defaults to a basedir, I ran port provides on them, and I got the response that they came from mysql5. After I moved them to my basedir, I ran port provides again, and I got the message that the files are not provided by a MacPorts port -- which makes sense because after I moved them they were no longer in the directories in which MacPorts installed them. David Begin forwarded message: From: David Gentry localbusinesswebsi...@earthlink.net Date: March 9, 2011 12:54:01 PM CST To: Ryan Schmidt ryandes...@macports.org Cc: MacPorts macports-users@lists.macosforge.org Subject: Re: Please send contents of current mysqld file Ryan, I did not mean to imply that the MacPorts file, mysqld, is corrupt
Re: Could not find my_print_defaults
Ryan, I did all of the cleaning I knew how, and the results are not good. I still get Could not find mysqld and the statement that non-existent directories were searched. I can fix that with --basedir= or --srcdir=, but that will not help if mysqld is corrupt which it is. It appears that my Mac is corrupting mysqld when I download it. I am going to open another thread asking if anyone could send me a copy of the contents of a current mysqld. Maybe that way I can determine what is happening when I download one. David On Mar 7, 2011, at 9:05 PM, Ryan Schmidt wrote: On Mar 7, 2011, at 19:29, David Gentry wrote: I apologize for the message below. After I sent it, I discovered that my mysqld file is not provided by MacPorts. None of the other files I moved today are provided by MacPorts either. Since they are not provided by MacPorts, I trashed my mysqld file and the other files I moved to /opt/local/lib/mysql5/bin. Please ignore the below message! I am sorry for any inconvenience it caused. Unless you have a better idea, I am going to: 1. Delete the mysql and mysql-server ports in the manner you described in an email to me. 2. Delete all other files on my Mac with mysql in the names that could possibly conflict with files from MacPorts. 3. Again, install the mysql and mysql-server ports. 4. Return to the wiki to set up a main database, etc. Ah, I'm glad you found that the files were not the ones provided by MacPorts, because I wasn't sure what to suggest otherwise. Let us know if everything works after cleaning up and trying again. David J. Gentry President Good Things -- Small Packages, LLC 205-637-8000 dgen...@localbusinesswebsites.com www.localbusinesswebsites.com ___ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
Please send contents of current mysqld file
My Mac appears to corrupt the mysqld file whenever I download mysql5 and mysql5-server from MacPorts. I would very much like to see a current copy of the contents of mysqld. Maybe that way I can determine what my Mac is doing to mysqld. Could someone please send me a copy of the contents of mysqld? David ___ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
Re: Could not find my_print_defaults
will try that. I did not have good luck downloading MySQL directly from mysql.com. Do you have advice concerning what I should do now? I am determined to get MySQL working on my Mac unless there is another database management software program I could use. I want to develop shopping cart websites. I am curious to know if anyone has used successfully the wiki I am using. Should I just send a query to the MacPorts address list? David On Mar 6, 2011, at 12:14 PM, Ryan Schmidt wrote: On Mar 5, 2011, at 16:47, David Gentry wrote: I am using the MAMP#mysql wiki. I am working on Set up the main database. For quite some time, I could not get past FATAL ERROR: Could not find mysql_install_db. This command got me past that error message: sudo mysql_install_db5 --basedir=/opt/local/bin, but it gave me the following error: FATAL ERROR: Could not find my_print_defaults The following directories were searched: /opt/local/bin/bin /opt/local/bin/extra If you compiled from source, you need to run 'make install' to copy the software into the correct location ready for operation. If you are using a binary release, you must either be at the top level of the extracted archive, or pass the --basedir option pointing to that location. Please help. Note: my_print_defaults5 is an alias in /opt/local/bin. Since I named the basedir as /opt/local/bin, I don't understand why the program looked in /opt/local/bin/bin. To my knowledge, the instructions in the wiki MAMP article remain correct. Make sure you are following them correctly. But I have not tried to follow them in a long time; something may have broken. Instead of /opt/local/bin, try specifying a basedir of /opt/local/lib/mysql5. David J. Gentry President Good Things -- Small Packages, LLC 205-637-8000 dgen...@localbusinesswebsites.com www.localbusinesswebsites.com ___ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
Fwd: Could not find my_print_defaults
Ryan, I apologize for the message below. After I sent it, I discovered that my mysqld file is not provided by MacPorts. None of the other files I moved today are provided by MacPorts either. Since they are not provided by MacPorts, I trashed my mysqld file and the other files I moved to /opt/local/lib/mysql5/bin. Please ignore the below message! I am sorry for any inconvenience it caused. Unless you have a better idea, I am going to: 1. Delete the mysql and mysql-server ports in the manner you described in an email to me. 2. Delete all other files on my Mac with mysql in the names that could possibly conflict with files from MacPorts. 3. Again, install the mysql and mysql-server ports. 4. Return to the wiki to set up a main database, etc. David Begin forwarded message: From: David Gentry localbusinesswebsi...@earthlink.net Date: March 7, 2011 3:26:39 PM CST To: Ryan Schmidt ryandes...@macports.org Cc: macports-users@lists.macosforge.org Subject: Re: Could not find my_print_defaults Ryan, 1. I tried specifying a basedir as you suggested to no avail. Adding /bin to /opt/local/lib/mysql5 helped but not much. Then I tried sudo mysql_install_db5 --srcdir=/opt/local/lib/mysql5/bin, and I received an error message telling me exactly where mysql_install_db5 was looking for my_print_defaults which was /opt/local/lib/mysql5/bin/extra. I added /extra as a folder to /opt/local/lib/mysql5/bin, and I moved my_print_defaults to that folder. Then I got another error message saying another file was in the wrong place, so I moved it. I moved about 5-8 files from various places, but all of them to /opt/local/lib/mysql5/bin. Sometimes I had to create a folder in /bin to move a file to. 2. Then I ran the same command as in all of the instances above: sudo mysql_install_db5 --srcdir=/opt/local/lib/mysql5/bin, and I received the following: Installing MySQL system tables... 110307 14:31:22 [Warning] '--log' is deprecated and will be removed in a future release. Please use ''--general_log'/'--general_log_file'' instead. 110307 14:31:22 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead. 110307 14:31:22 [Warning] /opt/local/lib/mysql5/bin/sql/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead. 110307 14:31:22 [Warning] /opt/local/lib/mysql5/bin/sql/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead. 110307 14:31:22 [Warning] /opt/local/lib/mysql5/bin/sql/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead. 110307 14:31:22 [ERROR] /opt/local/lib/mysql5/bin/sql/mysqld: unknown option '--enable-named-pipe' 110307 14:31:22 [ERROR] Aborting 110307 14:31:22 [Note] /opt/local/lib/mysql5/bin/sql/mysqld: Shutdown complete Installation of system tables failed! Examine the logs in /opt/local/var/db/mysql5 for more information. You can try to start the mysqld daemon with: shell /opt/local/lib/mysql5/bin/sql/mysqld --skip-grant and use the command line tool /opt/local/lib/mysql5/bin/client/mysql to connect to the mysql database and look at the grant tables: shell /opt/local/lib/mysql5/bin/client/mysql -u root mysql mysql show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in /opt/local/var/db/mysql5 that may be helpful. Please consult the MySQL manual section 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source are the MySQL email archives available at http://lists.mysql.com/. Please check all of the above before mailing us! And remember, if you do mail us, you MUST use the /opt/local/lib/mysql5/bin/scripts/mysqlbug script! 3. I looked for the logs and there were two empty files there. 4. I wanted to read mysqld, so I ran: /opt/local/lib/mysql5/bin/sql/mysqld ; exit; I received: 110307 14:14:25 [Warning] '--log' is deprecated and will be removed in a future release. Please use ''--general_log'/'--general_log_file'' instead. 110307 14:14:25 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead. 110307 14:14:25 [Warning] /opt/local/lib/mysql5/bin/sql/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead. 110307 14:14:25 [Warning] /opt/local/lib/mysql5/bin/sql/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead. 110307 14:14:25 [Warning] /opt/local/lib/mysql5/bin/sql/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead. 110307 14:14:25 [ERROR] Can't find messagefile '/usr/local/mysql-5.5.6-rc-osx10.6-x86_64/share/mysql5/mysql/__PREFIX/share/mysql/english/errmsg.sys' 110307 14:14:25 [Warning] Can't create test file /usr/local/mysql-5.5.6-rc-osx10.6-x86_64/data/DAVID.lower-test 110307 14:14:25 [Warning] Can't create test file /usr/local
Could not find my_print_defaults
I am using the MAMP#mysql wiki. I am working on Set up the main database. For quite some time, I could not get past FATAL ERROR: Could not find mysql_install_db. This command got me past that error message: sudo mysql_install_db5 --basedir=/opt/local/bin, but it gave me the following error: FATAL ERROR: Could not find my_print_defaults The following directories were searched: /opt/local/bin/bin /opt/local/bin/extra If you compiled from source, you need to run 'make install' to copy the software into the correct location ready for operation. If you are using a binary release, you must either be at the top level of the extracted archive, or pass the --basedir option pointing to that location. Please help. Note: my_print_defaults5 is an alias in /opt/local/bin. Since I named the basedir as /opt/local/bin, I don't understand why the program looked in /opt/local/bin/bin. David ___ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
Fwd: FATAL ERROR: Could not find mysqld Missing Port 3306
Ryan, You offered to compare your /opt/local/lib/mysql5/bin/mysql_install_db script to mine to possibly help determine where my FATAL ERROR is coming from. My script is in the email below. I really appreciate your help. David Begin forwarded message: From: David Gentry localbusinesswebsi...@earthlink.net Date: January 9, 2011 2:31:59 PM CST To: Ryan Schmidt ryandes...@macports.org Cc: MacPorts macports-users@lists.macosforge.org Subject: Re: FATAL ERROR: Could not find mysqld Missing Port 3306 Ryan, here is the script of my /opt/local/lib/mysql5/bin/mysql_install_db: #!/bin/sh # Copyright (C) 2002-2003 MySQL AB # # This program is free software; you can redistribute it and/or modify # it under the terms of the GNU General Public License as published by # the Free Software Foundation; version 2 of the License. # # This program is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License for more details. # # You should have received a copy of the GNU General Public License # along with this program; if not, write to the Free Software # Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA # This scripts creates the MySQL Server system tables # # All unrecognized arguments to this script are passed to mysqld. basedir= builddir= ldata=/opt/local/var/db/mysql5 langdir= srcdir= args= defaults= mysqld_opt= user= force=0 in_rpm=0 ip_only=0 cross_bootstrap=0 usage() { cat EOF Usage: $0 [OPTIONS] --basedir=path The path to the MySQL installation directory. --builddir=path If using --srcdir with out-of-directory builds, you will need to set this to the location of the build directory where built files reside. --cross-bootstrapFor internal use. Used when building the MySQL system tables on a different host than the target. --datadir=path The path to the MySQL data directory. --force Causes mysql_install_db to run even if DNS does not work. In that case, grant table entries that normally use hostnames will use IP addresses. --ldata=path The path to the MySQL data directory. Same as --datadir. --rpmFor internal use. This option is used by RPM files during the MySQL installation process. --skip-name-resolve Use IP addresses rather than hostnames when creating grant table entries. This option can be useful if your DNS does not work. --srcdir=pathThe path to the MySQL source directory. This option uses the compiled binaries and support files within the source tree, useful for if you don't want to install MySQL yet and just want to create the system tables. --user=user_name The login username to use for running mysqld. Files and directories created by mysqld will be owned by this user. You must be root to use this option. By default mysqld runs using your current login name and files and directories that it creates will be owned by you. All other options are passed to the mysqld program EOF exit 1 } s_echo() { if test $in_rpm -eq 0 -a $cross_bootstrap -eq 0 then echo $1 fi } parse_arg() { echo $1 | sed -e 's/^[^=]*=//' } parse_arguments() { # We only need to pass arguments through to the server if we don't # handle them here. So, we collect unrecognized options (passed on # the command line) into the args variable. pick_args= if test $1 = PICK-ARGS-FROM-ARGV then pick_args=1 shift fi for arg do case $arg in --force) force=1 ;; --basedir=*) basedir=`parse_arg $arg` ;; --builddir=*) builddir=`parse_arg $arg` ;; --srcdir=*) srcdir=`parse_arg $arg` ;; --ldata=*|--datadir=*) ldata=`parse_arg $arg` ;; --user=*) # Note that the user will be passed to mysqld so that it runs # as 'user' (crucial e.g. if log-bin=/some_other_path/ # where a chown of datadir won't help) user=`parse_arg $arg` ;; --skip-name-resolve) ip_only=1 ;; --verbose) verbose=1 ;; # Obsolete --rpm) in_rpm=1 ;; --help) usage ;; --no-defaults|--defaults-file=*|--defaults-extra-file=*) defaults=$arg ;; --cross-bootstrap|--windows) # Used when building the MySQL system tables on a different host than # the target. The platform-independent files that are created in # --datadir on the host can be copied to the target system. # # The most common use for this feature is in the Windows installer # which will take the files from datadir and include them as part of # the install package. See top
Re: FATAL ERROR: Could not find mysqld Missing Port 3306
% compatible echo with this binary MySQL version. The MySQL daemon, mysqld, should work echo normally with the exception that host name resolving will not work. echo This means that you should use IP addresses instead of hostnames echo when specifying MySQL privileges ! fi fi if test $ip_only -eq 1 then hostname=`echo $resolved | awk '/ /{print $6}'` fi # Create database directories for dir in $ldata $ldata/mysql $ldata/test do if test ! -d $dir then mkdir -p $dir chmod 700 $dir fi if test -w / -a ! -z $user then chown $user $dir fi done if test -n $user then args=$args --user=$user fi # When doing a cross bootstrap install, no reference to the current # host should be added to the system tables. So we filter out any # lines which contain the current host name. if test $cross_bootstrap -eq 1 then filter_cmd_line=sed -e '/@current_hostname/d' else filter_cmd_line=cat fi # Configure mysqld command line mysqld_bootstrap=${MYSQLD_BOOTSTRAP-$mysqld} mysqld_install_cmd_line=$mysqld_bootstrap $defaults $mysqld_opt --bootstrap \ --basedir=$basedir --datadir=$ldata --log-warnings=0 --loose-skip-innodb \ --loose-skip-ndbcluster $args --max_allowed_packet=8M \ --default-storage-engine=myisam \ --net_buffer_length=16K # Create the system and help tables by passing them to mysqld --bootstrap s_echo Installing MySQL system tables... if { echo use mysql;; cat $create_system_tables $fill_system_tables; } | eval $filter_cmd_line | $mysqld_install_cmd_line /dev/null then s_echo OK else echo echo Installation of system tables failed! Examine the logs in echo $ldata for more information. echo echo You can try to start the mysqld daemon with: echo echo shell $mysqld --skip-grant echo echo and use the command line tool $bindir/mysql echo to connect to the mysql database and look at the grant tables: echo echo shell $bindir/mysql -u root mysql echo mysql show tables echo echo Try 'mysqld --help' if you have problems with paths. Using --log echo gives you a log in $ldata that may be helpful. echo echo Please consult the MySQL manual section echo 'Problems running mysql_install_db', and the manual section that echo describes problems on your OS. Another information source are the echo MySQL email archives available at http://lists.mysql.com/.; echo echo Please check all of the above before mailing us! And remember, if echo you do mail us, you MUST use the $scriptdir/mysqlbug script! echo exit 1 fi s_echo Filling help tables... if { echo use mysql;; cat $fill_help_tables; } | $mysqld_install_cmd_line /dev/null then s_echo OK else echo echo WARNING: HELP FILES ARE NOT COMPLETELY INSTALLED! echo The \HELP\ command might not work properly. fi # Don't output verbose information if running inside bootstrap or using # --srcdir for testing. In such cases, there's no end user looking at # the screen. if test $cross_bootstrap -eq 0 test -z $srcdir then s_echo s_echo To start mysqld at boot time you have to copy s_echo support-files/mysql.server to the right place for your system echo echo PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! echo To do so, start the server, then issue the following commands: echo echo $bindir/mysqladmin -u root password 'new-password' echo $bindir/mysqladmin -u root -h $hostname password 'new-password' echo echo Alternatively you can run: echo $bindir/mysql_secure_installation echo echo which will also give you the option of removing the test echo databases and anonymous user created by default. This is echo strongly recommended for production servers. echo echo See the manual for more instructions. if test $in_rpm -eq 0 then echo echo You can start the MySQL daemon with: echo cd $basedir ; $bindir/mysqld_safe echo echo You can test the MySQL daemon with mysql-test-run.pl echo cd $basedir/mysql-test ; perl mysql-test-run.pl fi echo echo Please report any problems with the $scriptdir/mysqlbug script! echo fi exit 0 On Jan 8, 2011, at 3:14 AM, Ryan Schmidt wrote: On Jan 7, 2011, at 14:39, David Gentry wrote: Your guess makes sense to me: the FATAL ERROR came from script that I did not successfully uninstall. I ran which mysql_install_db5 and the response was /opt/local/bin/mysql_install_db5. The file and a lot of other mysql files were in that directory and they were alias files. I sent all of them to trash. Those symlinks were put there by MacPorts and they belonged there; you should not have trashed them. Now we need to put them back. The easiest way is to deactivate and reactivate mysql5. sudo port -f deactivate mysql5 sudo port activate mysql5 Before you trash something that might have been installed by MacPorts, you can use the port provides command; if it says the file was provided by a port, then you probably don't want to remove or change
Re: FATAL ERROR: Could not find mysqld Missing Port 3306
Your guess makes sense to me: the FATAL ERROR came from script that I did not successfully uninstall. I ran which mysql_install_db5 and the response was /opt/local/bin/mysql_install_db5. The file and a lot of other mysql files were in that directory and they were alias files. I sent all of them to trash. Then I returned to the web page you referred me to: http://trac.macports.org/wiki/howto/MAMP#mysql. I ran the following commands as instructed to set up the main database. I separated the commands by semicolons. sudo -u mysql mysql_install_db5 sudo chown -R mysql:mysql /opt/local/var/db/mysql5/ sudo chown -R mysql:mysql /opt/local/var/run/mysql5/ sudo chown -R mysql:mysql /opt/local/var/log/mysql5/ The response was: sudo: mysql_install_db5: command not found. Then I ran the same four commands separated by . I got the same result. Then I ran the first command alone. I got the same result. Then I ran the following three commands as advised, If that doesn't work try this: sudo mysql_install_db5 sudo chown -R mysql:mysql /opt/local/var/db/mysql5/ sudo chown -R mysql:mysql /opt/local/var/run/mysql5/ The result was the same: sudo: mysql_install_db5: command not found. Then I searched for mysql_install_db5. I found two Portfiles at the following locations: /opt/local/var/macports/sources/rsync.macports.org/release/ports/databases/mysql5-server-devel/Portfile /opt/local/var/macports/sources/rsync.macports.org/release/ports/databases/mysql5-server/Portfile Then I ran which mysql_install_db5 and the result was to return me to the command prompt. Background: A couple of days ago, when I tried to uninstall all disk image copies of MySQL, I also uninstalled MacPorts' mysql5 and mysql5-server. Then I installed the ports. I got no error messages. Then I ran port selfupdate and I did not get any error messages. What does this information tell you? On Jan 7, 2011, at 12:18 AM, Ryan Schmidt wrote: On Jan 6, 2011, at 13:49, David Gentry wrote: Following your advice, I carefully tried to uninstall all previous disk image versions of MySQL that I had downloaded from the MySQL web site. Also, I uninstalled mysql and mysql-server using sudo port uninstall. I carefully followed the instructions on the web page you referred me to. I had no trouble until I tried to install the mysql main database. Using both commands given, I received the following reply: FATAL ERROR: Could not find mysqld The following directories were searched: /usr/local/mysql-5.5.6-rc-osx10.6-x86_64/libexec /usr/local/mysql-5.5.6-rc-osx10.6-x86_64/sbin /usr/local/mysql-5.5.6-rc-osx10.6-x86_64/bin If you compiled from source, you need to run 'make install' to copy the software into the correct location ready for operation. If you are using a binary release, you must either be at the top level of the extracted archive, or pass the --basedir option pointing to that location. Whatever program or script generated that error message was not provided by MacPorts; MacPorts would not be looking for anything in /usr/local/mysql-5.5.6-rc-osx10.6-x86_64. I'm guessing it was provided by the software in that directory, which I'm guessing was not completely uninstalled. What command did you run to get that message? something with mysql_install_db(5)? (It appears to be an error message that mysql_install_db(5) would produce.) If so, where is the mysql_install_db(5) it is finding -- what does which mysql_install_db (or which mysql_install_db5) say? What is in your path -- what does echo $PATH say? I searched for mysqld on my Mac, and I found it installed yesterday (when I was working from your referred instructions) in the following two locations: /opt/local/libexec/mysqld /opt/local/var/macports/software/mysql5/mysql5.1.51_0/opt/local/libexec/mysqld Yes, those are where MacPorts would install it, so that's normal. David J. Gentry President Good Things -- Small Packages, LLC 205-637-8000 dgen...@localbusinesswebsites.com www.localbusinesswebsites.com ___ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
Fwd: FATAL ERROR: Could not find mysqld Missing Port 3306
Question [This question won't make sense until you read my previous email below.] As I said below, the alias files -- mysql_install_db5, mysql5_config, etc. -- were in /opt/local/bin/ before I moved them to trash. I found the original items for the aliases in /opt/local/lib/mysql5/bin/. These originals do not have the 5 as part of the file name. Should I add a 5 to the file names of the originals and determine if the setting up the main database commands at http://trac.macports.org/wiki/howto/MAMP#mysql will work? Begin forwarded message: From: David Gentry localbusinesswebsi...@earthlink.net Date: January 7, 2011 2:39:52 PM CST To: Ryan Schmidt ryandes...@macports.org Cc: MacPorts macports-users@lists.macosforge.org Subject: Re: FATAL ERROR: Could not find mysqld Missing Port 3306 Your guess makes sense to me: the FATAL ERROR came from script that I did not successfully uninstall. I ran which mysql_install_db5 and the response was /opt/local/bin/mysql_install_db5. The file and a lot of other mysql files were in that directory and they were alias files. I sent all of them to trash. Then I returned to the web page you referred me to: http://trac.macports.org/wiki/howto/MAMP#mysql. I ran the following commands as instructed to set up the main database. I separated the commands by semicolons. sudo -u mysql mysql_install_db5 sudo chown -R mysql:mysql /opt/local/var/db/mysql5/ sudo chown -R mysql:mysql /opt/local/var/run/mysql5/ sudo chown -R mysql:mysql /opt/local/var/log/mysql5/ The response was: sudo: mysql_install_db5: command not found. Then I ran the same four commands separated by . I got the same result. Then I ran the first command alone. I got the same result. Then I ran the following three commands as advised, If that doesn't work try this: sudo mysql_install_db5 sudo chown -R mysql:mysql /opt/local/var/db/mysql5/ sudo chown -R mysql:mysql /opt/local/var/run/mysql5/ The result was the same: sudo: mysql_install_db5: command not found. Then I searched for mysql_install_db5. I found two Portfiles at the following locations: /opt/local/var/macports/sources/rsync.macports.org/release/ports/databases/mysql5-server-devel/Portfile /opt/local/var/macports/sources/rsync.macports.org/release/ports/databases/mysql5-server/Portfile Then I ran which mysql_install_db5 and the result was to return me to the command prompt. Background: A couple of days ago, when I tried to uninstall all disk image copies of MySQL, I also uninstalled MacPorts' mysql5 and mysql5-server. Then I installed the ports. I got no error messages. Then I ran port selfupdate and I did not get any error messages. What does this information tell you? On Jan 7, 2011, at 12:18 AM, Ryan Schmidt wrote: On Jan 6, 2011, at 13:49, David Gentry wrote: Following your advice, I carefully tried to uninstall all previous disk image versions of MySQL that I had downloaded from the MySQL web site. Also, I uninstalled mysql and mysql-server using sudo port uninstall. I carefully followed the instructions on the web page you referred me to. I had no trouble until I tried to install the mysql main database. Using both commands given, I received the following reply: FATAL ERROR: Could not find mysqld The following directories were searched: /usr/local/mysql-5.5.6-rc-osx10.6-x86_64/libexec /usr/local/mysql-5.5.6-rc-osx10.6-x86_64/sbin /usr/local/mysql-5.5.6-rc-osx10.6-x86_64/bin If you compiled from source, you need to run 'make install' to copy the software into the correct location ready for operation. If you are using a binary release, you must either be at the top level of the extracted archive, or pass the --basedir option pointing to that location. Whatever program or script generated that error message was not provided by MacPorts; MacPorts would not be looking for anything in /usr/local/mysql-5.5.6-rc-osx10.6-x86_64. I'm guessing it was provided by the software in that directory, which I'm guessing was not completely uninstalled. What command did you run to get that message? something with mysql_install_db(5)? (It appears to be an error message that mysql_install_db(5) would produce.) If so, where is the mysql_install_db(5) it is finding -- what does which mysql_install_db (or which mysql_install_db5) say? What is in your path -- what does echo $PATH say? I searched for mysqld on my Mac, and I found it installed yesterday (when I was working from your referred instructions) in the following two locations: /opt/local/libexec/mysqld /opt/local/var/macports/software/mysql5/mysql5.1.51_0/opt/local/libexec/mysqld Yes, those are where MacPorts would install it, so that's normal. David J. Gentry President Good Things -- Small Packages, LLC 205-637-8000 dgen...@localbusinesswebsites.com www.localbusinesswebsites.com David J. Gentry President Good Things -- Small Packages, LLC 205-637-8000 dgen...@localbusinesswebsites.com
Re: FATAL ERROR: Could not find mysqld Missing Port 3306
Ryan, Following your advice, I carefully tried to uninstall all previous disk image versions of MySQL that I had downloaded from the MySQL web site. Also, I uninstalled mysql and mysql-server using sudo port uninstall. I carefully followed the instructions on the web page you referred me to. I had no trouble until I tried to install the mysql main database. Using both commands given, I received the following reply: FATAL ERROR: Could not find mysqld The following directories were searched: /usr/local/mysql-5.5.6-rc-osx10.6-x86_64/libexec /usr/local/mysql-5.5.6-rc-osx10.6-x86_64/sbin /usr/local/mysql-5.5.6-rc-osx10.6-x86_64/bin If you compiled from source, you need to run 'make install' to copy the software into the correct location ready for operation. If you are using a binary release, you must either be at the top level of the extracted archive, or pass the --basedir option pointing to that location. I searched for mysqld on my Mac, and I found it installed yesterday (when I was working from your referred instructions) in the following two locations: /opt/local/libexec/mysqld /opt/local/var/macports/software/mysql5/mysql5.1.51_0/opt/local/libexec/mysqld Note: The directories searched for mysqld by the database install script don't exist anymore on my Mac. How can I resolve the FATAL ERROR? David On Dec 21, 2010, at 11:06 AM, Ryan Schmidt wrote: On Dec 21, 2010, at 10:08, David Gentry wrote: FATAL ERROR: Could not find mysqld I removed a version of mysql from my iMac, and I installed the latest community version. As a recommended post-installation task, I ran mysql_install_db. Here is the command and the response: command: /opt/local/lib/mysql5/bin/mysql_install_db ; response: exit; FATAL ERROR: Could not find mysqld The following directories were searched: /usr/local/mysql-5.5.6-rc-osx10.6-x86_64/libexec /usr/local/mysql-5.5.6-rc-osx10.6-x86_64/sbin /usr/local/mysql-5.5.6-rc-osx10.6-x86_64/bin If you compiled from source, you need to run 'make install' to copy the software into the correct location ready for operation. If you are using a binary release, you must either be at the top level of the extracted archive, or pass the --basedir option pointing to that location. logout Would someone please give me more detail on the specific make install command that I should use? Missing port 3306 After installing the latest MacPorts' mysql and mysql.server, I used my iMac's Network Utility to do a port scan on 127.0.0.1, and 3306 was not listed as an open port. I received the same result to a port scan on localhost. If I fix the fatal error above, will 3306 become an open port or is there something else that I need to do? You should uninstall the MySQL that you installed via the disk image you downloaded from the MySQL web site, and instead use the MySQL provided by MacPorts. Instructions for setting it up are in our wiki: http://trac.macports.org/wiki/howto/MAMP#mysql David J. Gentry President Good Things -- Small Packages, LLC 205-637-8000 dgen...@localbusinesswebsites.com www.localbusinesswebsites.com ___ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
FATAL ERROR: Could not find mysqld Missing Port 3306
FATAL ERROR: Could not find mysqld I removed a version of mysql from my iMac, and I installed the latest community version. As a recommended post-installation task, I ran mysql_install_db. Here is the command and the response: command: /opt/local/lib/mysql5/bin/mysql_install_db ; response: exit; FATAL ERROR: Could not find mysqld The following directories were searched: /usr/local/mysql-5.5.6-rc-osx10.6-x86_64/libexec /usr/local/mysql-5.5.6-rc-osx10.6-x86_64/sbin /usr/local/mysql-5.5.6-rc-osx10.6-x86_64/bin If you compiled from source, you need to run 'make install' to copy the software into the correct location ready for operation. If you are using a binary release, you must either be at the top level of the extracted archive, or pass the --basedir option pointing to that location. logout Would someone please give me more detail on the specific make install command that I should use? Missing port 3306 After installing the latest MacPorts' mysql and mysql.server, I used my iMac's Network Utility to do a port scan on 127.0.0.1, and 3306 was not listed as an open port. I received the same result to a port scan on localhost. If I fix the fatal error above, will 3306 become an open port or is there something else that I need to do? ___ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
Re: FATAL ERROR: Could not find mysqld Missing Port 3306
Roger and wilco. (I'm a pilot. Wilco means will comply.) Thanks. On Dec 21, 2010, at 11:06 AM, Ryan Schmidt wrote: On Dec 21, 2010, at 10:08, David Gentry wrote: FATAL ERROR: Could not find mysqld I removed a version of mysql from my iMac, and I installed the latest community version. As a recommended post-installation task, I ran mysql_install_db. Here is the command and the response: command: /opt/local/lib/mysql5/bin/mysql_install_db ; response: exit; FATAL ERROR: Could not find mysqld The following directories were searched: /usr/local/mysql-5.5.6-rc-osx10.6-x86_64/libexec /usr/local/mysql-5.5.6-rc-osx10.6-x86_64/sbin /usr/local/mysql-5.5.6-rc-osx10.6-x86_64/bin If you compiled from source, you need to run 'make install' to copy the software into the correct location ready for operation. If you are using a binary release, you must either be at the top level of the extracted archive, or pass the --basedir option pointing to that location. logout Would someone please give me more detail on the specific make install command that I should use? Missing port 3306 After installing the latest MacPorts' mysql and mysql.server, I used my iMac's Network Utility to do a port scan on 127.0.0.1, and 3306 was not listed as an open port. I received the same result to a port scan on localhost. If I fix the fatal error above, will 3306 become an open port or is there something else that I need to do? You should uninstall the MySQL that you installed via the disk image you downloaded from the MySQL web site, and instead use the MySQL provided by MacPorts. Instructions for setting it up are in our wiki: http://trac.macports.org/wiki/howto/MAMP#mysql David J. Gentry President Good Things -- Small Packages, LLC 205-637-8000 dgen...@localbusinesswebsites.com www.localbusinesswebsites.com ___ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
Re: Error: Status 1 encountered during processing.
Ryan, Thanks very much for responding. I followed your directions but I can't decide if the server is running or not, and I have been using recommended commands from the online mysql manual. Also: 1. I ran mysql_install_db, and I received the following: DAVID:~ davidgentry$ /opt/local/lib/mysql5/bin/mysql_install_db ; exit; FATAL ERROR: Could not find mysqld The following directories were searched: /usr/local/mysql-5.5.6-rc-osx10.6-x86_64/libexec /usr/local/mysql-5.5.6-rc-osx10.6-x86_64/sbin /usr/local/mysql-5.5.6-rc-osx10.6-x86_64/bin If you compiled from source, you need to run 'make install' to copy the software into the correct location ready for operation. If you are using a binary release, you must either be at the top level of the extracted archive, or pass the --basedir option pointing to that location. logout Note: I installed from a downloaded dmg file. I am going to look at the online mysql manual. I think I read somewhere that I can provide a path to mysqld. Do you have any advice? What does this part of the above message mean to me: If you compiled from source, you need to run 'make install' to copy the software into the correct location ready for operation.? 2. I used my iMac's Network Utility to do a port scan after installing mysql5 and mysql5.server, and the port scan for 127.0.0.1 and for localhost did not reveal port 3306. Using my Terminal, I determined that mysql5 and mysql5.server are both active. Help! Could this problem be related to number 1 above? David On Dec 19, 2010, at 10:45 PM, Ryan Schmidt wrote: On Dec 19, 2010, at 18:12, dgen...@localbusinesswebsites.com wrote: I updated my MacPorts version, and I installed the latest community version of Mysql. I received the following message when I updated MacPorts: A startup item has been generated that will aid in starting mysql5-server with launchd. It is disabled by default. Execute the following command to start it, and to cause it to launch at startup: sudo port load mysql5-server When I executed the command, I received the attached message. Will someone please help me? I will report a bug, if necessary.mysql error report.tiff The message in the attached screenshot reads Error: Target org.macports.load returned: org.macports.mysql5: Already loaded. So there is no error, the mysql5-server plist is already loaded and the server should already be running. If you want to restart the mysqld server, you can sudo port unload mysql5-server and then, after a few moments, sudo port load mysql5-server again. In the future, please just supply the text of the error messages, not an image of them. David J. Gentry President Good Things -- Small Packages, LLC 205-637-8000 dgen...@localbusinesswebsites.com www.localbusinesswebsites.com ___ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
Re: Error: port activate failed: Registry error: No port of e installed.
Port 8500 is used by Adobe ColdFusion for its embedded server. Since I plan to use ColdFusion, I guess I will need port 8500, but I don't know for sure yet. On Oct 13, 2010, at 6:21 PM, Ryan Schmidt wrote: On Oct 13, 2010, at 13:16, David Gentry wrote: Dear Ryan Schmidt, John B Brown, and Rainer Muller, Thank you all so much. I used Disk Utility to verify and then repair permissions. Then I executed sudo port install apache2. I got sudo: /var/db/sudo writable by non-owner (040775), should be mode 0700. After several tries, I corrected the ownership issue, and the sudo port install apache2 command installed and activated apache2! I had almost given up which would mean that I would abandon building my application. Now, all I need to do is install mysql5 and whatever other ports are required to use ports 80, 8500, and 3306. Glad you got it working. According to common usage, port 80 is for a web server and port 3306 is for a MySQL server, so you're on track there with Apache and MySQL. The IANA assignment list has port 8500 listed as Flight Message Transfer Protocol. I don't know what that is, but perhaps you were using port 8500 for a different purpose (an alternate web server maybe). David J. Gentry President Good Things -- Small Packages, LLC 205-637-8000 dgen...@localbusinesswebsites.com www.localbusinesswebsites.com ___ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
Re: Error: port activate failed: Registry error: No port of e installed.
Dear Ryan Schmidt, John B Brown, and Rainer Muller, Thank you all so much. I used Disk Utility to verify and then repair permissions. Then I executed sudo port install apache2. I got sudo: /var/db/sudo writable by non-owner (040775), should be mode 0700. After several tries, I corrected the ownership issue, and the sudo port install apache2 command installed and activated apache2! I had almost given up which would mean that I would abandon building my application. Now, all I need to do is install mysql5 and whatever other ports are required to use ports 80, 8500, and 3306. Thanks, again. David On Oct 13, 2010, at 6:39 AM, Ryan Schmidt wrote: On Oct 12, 2010, at 18:34, dgen...@localbusinesswebsites.com wrote: I installed Xcode successfully. When I ran sudo port install apache2, I got: sudo: /etc/sudoers is mode 0666, should be 0440 Segmentation fault I wonder why your sudoers has the wrong permissions. It certainly needs to be corrected. I googled that result and then I ran chmod 0440 /etc/sudoers. The result was: chmod: Unable to change file mode on /etc/sudoers: Operation not permitted. You need root permission to change the permissions of the sudoers file. Ordinarily that would mean run sudo chmod 0440 /etc/sudoers but in this cas your sudo command doesn't work because the sudoers file has the wrong permissions. Catch 22. If using Disk Utility's Repair Permissions command does not repair the permissions of /etc/sudoers you may have to su root and do it there. This means you'd need to enable your root account, which is not generally recommended, and you should disable the root account again afterward. Or you could change the permissions while booted to single user mode. These are rather advanced topics. I ran port install apache2 and, quoting just the last several lines, I got: --- Staging apache2 into destroot Error: Target org.macports.destroot returned: shell command failed Log for apache2 is at: /opt/local/var/macports/logs/_opt_local_var_macports_sources_rsync.macports.org_release_ports_www_apache2/main.log Error: Status 1 encountered during processing. To report a bug, see http://guide.macports.org/#project.tickets I expect this too will have failed because you did not have sufficient privileges and needed to have used sudo port install apache2, except that your sudo command is broken because of the permissions on the /etc/sudoers file. ___ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/macports-users David J. Gentry President Good Things -- Small Packages, LLC 205-637-8000 dgen...@localbusinesswebsites.com www.localbusinesswebsites.com ___ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
Error: port activate failed: Registry error: No port of e installed.
I am glad I signed up for this email list last week because one post made me think that maybe I am not crazy. The post said that a port disappeared. Well, I have had 3 ports disappear. Here is the sequence of events: 1. Last week, I installed Macports. 2. Per the documentation, I ran port selfupdate. 3. I noticed that I could not connect to TCP ports 80, 3306, and 8500 from an http browser address -- all ports that are necessary for the shopping cart application I am developing. I got a browser message, Unable to connect to server, both from Firefox and Safari. I am dead in the water. Before I installed Macports, I could readily connect to my embedded Apache2 server on my Mac by entering my computer's IP address or IP address address and port number on a browser address line. 4. I checked my Mac firewall and permissions to see if they presented a problem that may account for my failure to connect to my Apache2 server. I could detect no problem with my firewall or permissions. 5. I used Mac's Network Utility to run a Port Scan for my computer's IP address. Much to my amazement, the result was that my three TCP ports -- 80, 3306, and 8500 -- are not open! 6. In my terminal window, I ran a command to list all inactive ports. I picked several to run a port activate command on. For example, I said, port activate [apache2] and port activate [mysql5]. I received the error message in the subject line of this email. What should I do now? I need my ports back! I have a couple of thoughts: 1. I could run a command to determine if the ports I need are even installed. If not, I could run an install command. 2. I could use Mac's Time Machine backup to restore my system to the way it was the day before I installed Macports. Any other suggestions? ___ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo.cgi/macports-users