Please send contents of current mysqld file

Wed Mar 9 14:14:17 PST 2011

I don't see anything in there that would indicate that anything has
been corrupted?

Scott

On Wed, Mar 9, 2011 at 2:09 PM, David Gentry
<localbusinesswebsites at earthlink.net> wrote:
> 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 <localbusinesswebsites at earthlink.net>
> Date: March 9, 2011 12:54:01 PM CST
> To: Ryan Schmidt <ryandesign at macports.org>
> Cc: MacPorts <macports-users at 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.  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
> dgentry at localbusinesswebsites.com
> www.localbusinesswebsites.com
>
>
>
>
>
>
>
> David J. Gentry
> President
> Good Things -- Small Packages, LLC
> 205-637-8000
> dgentry at localbusinesswebsites.com
> www.localbusinesswebsites.com
>
>
>
>
>
>
> _______________________________________________
> macports-users mailing list
> macports-users at lists.macosforge.org
> http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
>
>