Please send contents of current mysqld file

[David Gentry]

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

[David Gentry]

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

[David Gentry]

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

problems running mysql_install_db5 (was Re: Please send contents of current mysqld file)

[Bayard Bell]

I'm looking at this and trying to decide where it's going wrong:

# my_print_defaults so that we can execute it first, then later re-parse
# the command line to add any extra bits that we need.
parse_arguments PICK-ARGS-FROM-ARGV $@

#
# We can now find my_print_defaults.  This script supports:
#
#   --srcdir=path pointing to compiled source tree
#   --basedir=path pointing to installed binary location
#
# or default to compiled-in locations.
#
if test -n $srcdir  test -n $basedir
then
  echo ERROR: Specify either --basedir or --srcdir, not both.
  exit 1
fi
if test -n $srcdir
then
  if test -z $builddir
  then
builddir=$srcdir
  fi
  print_defaults=$builddir/extra/my_print_defaults
elif test -n $basedir
then
  print_defaults=`find_in_basedir my_print_defaults bin extra`
  if test -z $print_defaults
  then
cannot_find_file my_print_defaults $basedir/bin $basedir/extra
exit 1
  fi
else
  print_defaults=/opt/local/lib/mysql5/bin/my_print_defaults
fi

if test ! -x $print_defaults
then
  cannot_find_file $print_defaults
  exit 1
fi

Reading the documentation for the command at mysql.com appears to confirm my 
belief that you really don't want --datadir and --basedir to be the same thing. 
You'll probably also want to run it as the mysql ID rather than defaulting to 
root (i.e. you dropped the -u mysql from the invocation below).

Given that you don't seem very comfortable around a Unix shell, perhaps you 
might give a second thought to getting a binary distribution of MySQL, GUI 
administration tools, and commercial support? I don't know much of anything 
about MySQL–I'm just someone who knows a bit about MacPorts and Unix who's got 
a bit too much time on his hands to respond to e-mail, and it's pretty clear to 
me that you're not working from much of a Unix foundation. Given where you're 
starting from, going the port route is almost certainly putting more distance 
between you and what you want to do with the software. I don't want to 
discourage you from learning if that's really what you want to do, but if you 
really do wish to learn at this level of detail from the systems side, you need 
to follow instruction and documentation in both their letter and sense (modify 
your PATH for use with ports, get your sudo invocation right, know what options 
to choose for the command you're invoking) and, should that not get you as far 
as you need to go, you need to be willing to work your way through some basic 
shell code to at least come back with a clearer statement of the problem. 
Pre-packaged distributions and admin tools are a perfectly reasonable 
alternative way to get MySQL up and running.

Also, putting replies in as indented with a  and in italics is more or less 
the exact opposite of mail citation conventions. It would be a lot less 
confusing if my previous message didn't appear to be responding to your 
response. ;-

Cheers,
Bayard

On 16 Mar 2011, at 16:58, David Gentry wrote:

 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

Re: Please send contents of current mysqld file

[David Gentry]

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

[Scott Webster]

On Mon, Mar 14, 2011 at 12:48 PM, David Gentry
localbusinesswebsi...@earthlink.net wrote:
 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

What is the output of which mysql_install_db5?

I don't think the macports version would search those directories?

Scott
___
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

[Andrea D'Amore]

On Mon, Mar 14, 2011 at 8:48 PM, David Gentry
localbusinesswebsi...@earthlink.net wrote:
 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

Out of curiosity, can you paste your $PATH env variable? Seems you
have /usr/local before MP's $prefix .


-- 
Andrea
___
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 Schmidt]

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.


___
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

[David Gentry]

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

[Bayard Bell]

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.

On 14 Mar 2011, at 19:48, David Gentry wrote:

 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
 
 
 
 
 
 



smime.p7s
Description: S/MIME cryptographic signature


PGP.sig
Description: This is a digitally signed message part
___
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

[David Gentry]

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

[Ryan Schmidt]

On Mar 13, 2011, at 17:04, David Gentry wrote:

 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?

That's not one of the paths that mysql would look for my.cnf while it's running 
so it's of no consequence.

Now I don't know what is causing your mysql to behave differently from 
everybody else's.

 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?

Not a problem. It's correct that mysql5 does not install a my.cnf file. Indeed, 
it is MacPorts policy that ports shall not install conf files. They shall 
install *samples* of conf files that users can copy and modify at will. mysql5 
installs sample conf files for you in /opt/local/share/mysql5/mysql.


___
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 Schmidt]

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.


___
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

[David Gentry]

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

[David Gentry]

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

[David Gentry]

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

[Rainer Müller]

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?

Rainer
___
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

[David Gentry]

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

Re: Please send contents of current mysqld file

[Bayard Bell]

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?

On 9 Mar 2011, at 18:54, David Gentry wrote:

 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



smime.p7s
Description: S/MIME cryptographic signature
___
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

[David Gentry]

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: Please send contents of current mysqld file

[Scott Webster]

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
localbusinesswebsi...@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 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

Re: Please send contents of current mysqld file

[Bradley Giesbrecht]

On Mar 9, 2011, at 2:09 PM, David Gentry 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


David,


MacPorts does not support having anything in a directory named /usr/ 
local.


Please reply with the output of the following comments.

$ echo $PATH
$ ls -la /usr/local
$ port contents mysql5


Regards,
Bradley Giesbrecht___
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 Schmidt]

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

[Ryan Schmidt]

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

Please send contents of current mysqld file

[David Gentry]

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: Please send contents of current mysqld file

[Ryan Schmidt]

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.



___
macports-users mailing list
macports-users@lists.macosforge.org
http://lists.macosforge.org/mailman/listinfo.cgi/macports-users