how to configure mysql for debug installation
in [Shell]
|
Prev: error while executing ksh script
Next: shell calculator
From: Greg Russell on 23 Dec 2009 23:59 In news:bb3017f3-4795-4984-825a-fdc13df5aedf(a)z10g2000prh.googlegroups.com, JRough <jlrough(a)yahoo.com> typed: >> The README in the code you say you downloaded contains no >> installation instructions. The MySQL code you have is already >> compiled and simply needs to be installed according to the >> instructions in the INSTALL-BINARY file. > > Okay, I don't need to compile it. Jerry is right I don't need debug. > I ran the installation script. I think all that is left is a $PATH > environment variable issue. And the error messages mean nothing to you? > sh-3.2# /usr/local/mysql/bin/mysqld_safe --user=_mysql & > sh-3.2# 091223 17:30:03 mysqld_safe Logging to '/usr/local//usr/local/ > mysql-5.0.82-osx10.5-powerpc/data/janis-roughs-power-mac- > g5.local.err'. > touch: /usr/local//usr/local/mysql-5.0.82-osx10.5-powerpc/data/janis- > roughs-power-mac-g5.local.err: No such file or directory > chown: /usr/local//usr/local/mysql-5.0.82-osx10.5-powerpc/data/janis- > roughs-power-mac-g5.local.err: No such file or directory Do you really believe you have an absolute path /usr/local//usr/local/mysql-5.0.82-osx10.5-powerpc/... ? Obviously, you've botched the installation commands. Undo everything you've done and start over again, carefully following the INSTALL-BINARY instructions in the stated order. > I think if I get the $PATH correct then the installation script will > run. My opinion from everything you've posted here and in other newsgroups is that you're very confused and working against yourself. The instructions in the INSTALL-BINARY file are simple, straight-ahead, and step-by-step. The problem you've created for yourself is mixing other, unrelated instructions that are years old with the current task, along with an apparent lack of understanding of absolute vs. relative path.
From: JRough on 24 Dec 2009 15:53 On Dec 23, 8:59 pm, "Greg Russell" <gruss...(a)invalid.com> wrote: > Innews:bb3017f3-4795-4984-825a-fdc13df5aedf(a)z10g2000prh.googlegroups.com, > JRough <jlro...(a)yahoo.com> typed: > > >> The README in the code you say you downloaded contains no > >> installation instructions. The MySQL code you have is already > >> compiled and simply needs to be installed according to the > >> instructions in the INSTALL-BINARY file. > > > Okay, I don't need to compile it. Jerry is right I don't need debug. > > I ran the installation script. I think all that is left is a $PATH > > environment variable issue. > > And the error messages mean nothing to you? > > > sh-3.2# /usr/local/mysql/bin/mysqld_safe --user=_mysql & > > sh-3.2# 091223 17:30:03 mysqld_safe Logging to '/usr/local//usr/local/ > > mysql-5.0.82-osx10.5-powerpc/data/janis-roughs-power-mac- > > g5.local.err'. > > touch: /usr/local//usr/local/mysql-5.0.82-osx10.5-powerpc/data/janis- > > roughs-power-mac-g5.local.err: No such file or directory > > chown: /usr/local//usr/local/mysql-5.0.82-osx10.5-powerpc/data/janis- > > roughs-power-mac-g5.local.err: No such file or directory > > Do you really believe you have an absolute path > /usr/local//usr/local/mysql-5.0.82-osx10.5-powerpc/... ? Obviously, you've > botched the installation commands. Undo everything you've done and start > over again, carefully following the INSTALL-BINARY instructions in the > stated order. > > > I think if I get the $PATH correct then the installation script will > > run. > > My opinion from everything you've posted here and in other newsgroups is > that you're very confused and working against yourself. The instructions in > the INSTALL-BINARY file are simple, straight-ahead, and step-by-step. The > problem you've created for yourself is mixing other, unrelated instructions > that are years old with the current task, along with an apparent lack of > understanding of absolute vs. relative path. I did it over exactly as the binary instructions. It stops on the install script. First I checked a mysql group and user are already assigned: sh-3.2# dscacheutil -q group -a name mysql name: _mysql password: * gid: 74 name: _mysql password: * uid: 74 gid: 74 dir: /var/empty shell: /usr/bin/false gecos: MySQL Server This is my history of the install: gunzip < /Users/jlrough/src/mysql-5.1.40-osx10.5-powerpc.tar.gz | tar xvf - 504 pwd 505 ln -s /usr/local mysql 506 chown -R mysql . 507 chgrp -R mysql . So now I need to run the install script but I get an error. It looks like I ran it from the right directory. sh-3.2# /usr/local/mysql/scripts/mysql_install_db FATAL ERROR: Could not find mysqld The following directories were searched: /usr/local/mysql-5.0.82-osx10.5-powerpc/bin//libexec /usr/local/mysql-5.0.82-osx10.5-powerpc/bin//sbin /usr/local/mysql-5.0.82-osx10.5-powerpc/bin//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 think the $PATH variable is okay. Why can't it find the mysqld? thanks,
From: Jerry Stuckle on 24 Dec 2009 23:08 JRough wrote: > On Dec 23, 8:59 pm, "Greg Russell" <gruss...(a)invalid.com> wrote: >> Innews:bb3017f3-4795-4984-825a-fdc13df5aedf(a)z10g2000prh.googlegroups.com, >> JRough <jlro...(a)yahoo.com> typed: >> >>>> The README in the code you say you downloaded contains no >>>> installation instructions. The MySQL code you have is already >>>> compiled and simply needs to be installed according to the >>>> instructions in the INSTALL-BINARY file. >>> Okay, I don't need to compile it. Jerry is right I don't need debug. >>> I ran the installation script. I think all that is left is a $PATH >>> environment variable issue. >> And the error messages mean nothing to you? >> >>> sh-3.2# /usr/local/mysql/bin/mysqld_safe --user=_mysql & >>> sh-3.2# 091223 17:30:03 mysqld_safe Logging to '/usr/local//usr/local/ >>> mysql-5.0.82-osx10.5-powerpc/data/janis-roughs-power-mac- >>> g5.local.err'. >>> touch: /usr/local//usr/local/mysql-5.0.82-osx10.5-powerpc/data/janis- >>> roughs-power-mac-g5.local.err: No such file or directory >>> chown: /usr/local//usr/local/mysql-5.0.82-osx10.5-powerpc/data/janis- >>> roughs-power-mac-g5.local.err: No such file or directory >> Do you really believe you have an absolute path >> /usr/local//usr/local/mysql-5.0.82-osx10.5-powerpc/... ? Obviously, you've >> botched the installation commands. Undo everything you've done and start >> over again, carefully following the INSTALL-BINARY instructions in the >> stated order. >> >>> I think if I get the $PATH correct then the installation script will >>> run. >> My opinion from everything you've posted here and in other newsgroups is >> that you're very confused and working against yourself. The instructions in >> the INSTALL-BINARY file are simple, straight-ahead, and step-by-step. The >> problem you've created for yourself is mixing other, unrelated instructions >> that are years old with the current task, along with an apparent lack of >> understanding of absolute vs. relative path. > > I did it over exactly as the binary instructions. It stops on the > install script. First I checked a mysql group and user are already > assigned: > sh-3.2# dscacheutil -q group -a name mysql > name: _mysql > password: * > gid: 74 > name: _mysql > password: * > uid: 74 > gid: 74 > dir: /var/empty > shell: /usr/bin/false > gecos: MySQL Server > > This is my history of the install: > gunzip < /Users/jlrough/src/mysql-5.1.40-osx10.5-powerpc.tar.gz | tar > xvf - > 504 pwd > 505 ln -s /usr/local mysql > 506 chown -R mysql . > 507 chgrp -R mysql . > > So now I need to run the install script but I get an error. It looks > like I ran it from the right directory. > sh-3.2# /usr/local/mysql/scripts/mysql_install_db > > FATAL ERROR: Could not find mysqld > > The following directories were searched: > > /usr/local/mysql-5.0.82-osx10.5-powerpc/bin//libexec > /usr/local/mysql-5.0.82-osx10.5-powerpc/bin//sbin > /usr/local/mysql-5.0.82-osx10.5-powerpc/bin//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 think the $PATH variable is okay. Why can't it find the mysqld? > thanks, All mysql_install_db does is install the initial databases. Look at the list of directories being searched. Notice anything unusual? -- ================== Remove the "x" from my email address Jerry Stuckle JDS Computer Training Corp. jstucklex(a)attglobal.net ==================
From: JRough on 26 Dec 2009 20:41 On Dec 24, 8:08 pm, Jerry Stuckle <jstuck...(a)attglobal.net> wrote: > JRough wrote: > > On Dec 23, 8:59 pm, "Greg Russell" <gruss...(a)invalid.com> wrote: > >> Innews:bb3017f3-4795-4984-825a-fdc13df5aedf(a)z10g2000prh.googlegroups.com, > >> JRough <jlro...(a)yahoo.com> typed: > > >>>> The README in the code you say you downloaded contains no > >>>> installation instructions. The MySQL code you have is already > >>>> compiled and simply needs to be installed according to the > >>>> instructions in the INSTALL-BINARY file. > >>> Okay, I don't need to compile it. Jerry is right I don't need debug. > >>> I ran the installation script. I think all that is left is a $PATH > >>> environment variable issue. > >> And the error messages mean nothing to you? > > >>> sh-3.2# /usr/local/mysql/bin/mysqld_safe --user=_mysql & > >>> sh-3.2# 091223 17:30:03 mysqld_safe Logging to '/usr/local//usr/local/ > >>> mysql-5.0.82-osx10.5-powerpc/data/janis-roughs-power-mac- > >>> g5.local.err'. > >>> touch: /usr/local//usr/local/mysql-5.0.82-osx10.5-powerpc/data/janis- > >>> roughs-power-mac-g5.local.err: No such file or directory > >>> chown: /usr/local//usr/local/mysql-5.0.82-osx10.5-powerpc/data/janis- > >>> roughs-power-mac-g5.local.err: No such file or directory > >> Do you really believe you have an absolute path > >> /usr/local//usr/local/mysql-5.0.82-osx10.5-powerpc/... ? Obviously, you've > >> botched the installation commands. Undo everything you've done and start > >> over again, carefully following the INSTALL-BINARY instructions in the > >> stated order. > > >>> I think if I get the $PATH correct then the installation script will > >>> run. > >> My opinion from everything you've posted here and in other newsgroups is > >> that you're very confused and working against yourself. The instructions in > >> the INSTALL-BINARY file are simple, straight-ahead, and step-by-step. The > >> problem you've created for yourself is mixing other, unrelated instructions > >> that are years old with the current task, along with an apparent lack of > >> understanding of absolute vs. relative path. > > > I did it over exactly as the binary instructions. It stops on the > > install script. First I checked a mysql group and user are already > > assigned: > > sh-3.2# dscacheutil -q group -a name mysql > > name: _mysql > > password: * > > gid: 74 > > name: _mysql > > password: * > > uid: 74 > > gid: 74 > > dir: /var/empty > > shell: /usr/bin/false > > gecos: MySQL Server > > > This is my history of the install: > > gunzip < /Users/jlrough/src/mysql-5.1.40-osx10.5-powerpc.tar.gz | tar > > xvf - > > 504 pwd > > 505 ln -s /usr/local mysql > > 506 chown -R mysql . > > 507 chgrp -R mysql . > > > So now I need to run the install script but I get an error. It looks > > like I ran it from the right directory. > > sh-3.2# /usr/local/mysql/scripts/mysql_install_db > > > FATAL ERROR: Could not find mysqld > > > The following directories were searched: > > > /usr/local/mysql-5.0.82-osx10.5-powerpc/bin//libexec > > /usr/local/mysql-5.0.82-osx10.5-powerpc/bin//sbin > > /usr/local/mysql-5.0.82-osx10.5-powerpc/bin//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 think the $PATH variable is okay. Why can't it find the mysqld? > > thanks, > > All mysql_install_db does is install the initial databases. > > Look at the list of directories being searched. Notice anything unusual? > > -- > ================== > Remove the "x" from my email address > Jerry Stuckle > JDS Computer Training Corp. > jstuck...(a)attglobal.net > ================== anis-roughs-power-mac-g5:bin jlrough$ /usr/local/mysql/bin/mysqld_safe --user=msyql & [1] 779 janis-roughs-power-mac-g5:bin jlrough$ /usr/local/mysql/bin/ mysqld_safe: line 2: FATAL: command not found /usr/local/mysql/bin/mysqld_safe: line 4: The: command not found /usr/local/mysql/bin/mysqld_safe: line 6: /usr/local/mysql-5.0.82- osx10.5-powerpc/bin//libexec: No such file or directory /usr/local/mysql/bin/mysqld_safe: line 7: /usr/local/mysql-5.0.82- osx10.5-powerpc/bin//sbin: No such file or directory /usr/local/mysql/bin/mysqld_safe: line 8: /usr/local/mysql-5.0.82- osx10.5-powerpc/bin//bin: No such file or directory /usr/local/mysql/bin/mysqld_safe: line 10: If: command not found /usr/local/mysql/bin/mysqld_safe: line 11: copy: command not found /usr/local/mysql/bin/mysqld_safe: line 13: If: command not found /usr/local/mysql/bin/mysqld_safe: line 14: level: command not found /usr/local/mysql/bin/mysqld_safe: line 15: pointing: command not found [1]+ Exit 127 /usr/local/mysql/bin/mysqld_safe -- user=msyql janis-roughs-power-mac-g5:bin jlrough$ echo $PATH /usr/local/bin:/usr/local/sbin:/usr/local/mysql/bin:/usr/bin:/bin:/usr/ sbin:/sbin:/usr/local/bin:/usr/X11/bin Can you give me a hint here? The mysqld_safe command is in /usr/local/mysql/bin/mysqld_safe directory. So it is looking in the symlink directory /usr/local/ mysql-5.0.82-osx10.5-powerpc/bin but why does it look in //libexec or //sbin or //bin? Why doesn't it find it in /usr/local/mysql/bin/ mysqld_safe Is it the $PATH variable?/usr/local/bin:/usr/local/sbin:/usr/local/ mysql/bin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin Why does it say on line 2 FATAL? should it be /usr/local/bin:/usr/local/sbin:/usr/local/mysql*/bin: etc etc
From: Jerry Stuckle on 26 Dec 2009 21:26
JRough wrote: > On Dec 24, 8:08 pm, Jerry Stuckle <jstuck...(a)attglobal.net> wrote: >> JRough wrote: >>> On Dec 23, 8:59 pm, "Greg Russell" <gruss...(a)invalid.com> wrote: >>>> Innews:bb3017f3-4795-4984-825a-fdc13df5aedf(a)z10g2000prh.googlegroups.com, >>>> JRough <jlro...(a)yahoo.com> typed: >>>>>> The README in the code you say you downloaded contains no >>>>>> installation instructions. The MySQL code you have is already >>>>>> compiled and simply needs to be installed according to the >>>>>> instructions in the INSTALL-BINARY file. >>>>> Okay, I don't need to compile it. Jerry is right I don't need debug. >>>>> I ran the installation script. I think all that is left is a $PATH >>>>> environment variable issue. >>>> And the error messages mean nothing to you? >>>>> sh-3.2# /usr/local/mysql/bin/mysqld_safe --user=_mysql & >>>>> sh-3.2# 091223 17:30:03 mysqld_safe Logging to '/usr/local//usr/local/ >>>>> mysql-5.0.82-osx10.5-powerpc/data/janis-roughs-power-mac- >>>>> g5.local.err'. >>>>> touch: /usr/local//usr/local/mysql-5.0.82-osx10.5-powerpc/data/janis- >>>>> roughs-power-mac-g5.local.err: No such file or directory >>>>> chown: /usr/local//usr/local/mysql-5.0.82-osx10.5-powerpc/data/janis- >>>>> roughs-power-mac-g5.local.err: No such file or directory >>>> Do you really believe you have an absolute path >>>> /usr/local//usr/local/mysql-5.0.82-osx10.5-powerpc/... ? Obviously, you've >>>> botched the installation commands. Undo everything you've done and start >>>> over again, carefully following the INSTALL-BINARY instructions in the >>>> stated order. >>>>> I think if I get the $PATH correct then the installation script will >>>>> run. >>>> My opinion from everything you've posted here and in other newsgroups is >>>> that you're very confused and working against yourself. The instructions in >>>> the INSTALL-BINARY file are simple, straight-ahead, and step-by-step. The >>>> problem you've created for yourself is mixing other, unrelated instructions >>>> that are years old with the current task, along with an apparent lack of >>>> understanding of absolute vs. relative path. >>> I did it over exactly as the binary instructions. It stops on the >>> install script. First I checked a mysql group and user are already >>> assigned: >>> sh-3.2# dscacheutil -q group -a name mysql >>> name: _mysql >>> password: * >>> gid: 74 >>> name: _mysql >>> password: * >>> uid: 74 >>> gid: 74 >>> dir: /var/empty >>> shell: /usr/bin/false >>> gecos: MySQL Server >>> This is my history of the install: >>> gunzip < /Users/jlrough/src/mysql-5.1.40-osx10.5-powerpc.tar.gz | tar >>> xvf - >>> 504 pwd >>> 505 ln -s /usr/local mysql >>> 506 chown -R mysql . >>> 507 chgrp -R mysql . >>> So now I need to run the install script but I get an error. It looks >>> like I ran it from the right directory. >>> sh-3.2# /usr/local/mysql/scripts/mysql_install_db >>> FATAL ERROR: Could not find mysqld >>> The following directories were searched: >>> /usr/local/mysql-5.0.82-osx10.5-powerpc/bin//libexec >>> /usr/local/mysql-5.0.82-osx10.5-powerpc/bin//sbin >>> /usr/local/mysql-5.0.82-osx10.5-powerpc/bin//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 think the $PATH variable is okay. Why can't it find the mysqld? >>> thanks, >> All mysql_install_db does is install the initial databases. >> >> Look at the list of directories being searched. Notice anything unusual? >> >> -- >> ================== >> Remove the "x" from my email address >> Jerry Stuckle >> JDS Computer Training Corp. >> jstuck...(a)attglobal.net >> ================== > anis-roughs-power-mac-g5:bin jlrough$ /usr/local/mysql/bin/mysqld_safe > --user=msyql & > [1] 779 > janis-roughs-power-mac-g5:bin jlrough$ /usr/local/mysql/bin/ > mysqld_safe: line 2: FATAL: command not found > /usr/local/mysql/bin/mysqld_safe: line 4: The: command not found > /usr/local/mysql/bin/mysqld_safe: line 6: /usr/local/mysql-5.0.82- > osx10.5-powerpc/bin//libexec: No such file or directory > /usr/local/mysql/bin/mysqld_safe: line 7: /usr/local/mysql-5.0.82- > osx10.5-powerpc/bin//sbin: No such file or directory > /usr/local/mysql/bin/mysqld_safe: line 8: /usr/local/mysql-5.0.82- > osx10.5-powerpc/bin//bin: No such file or directory > /usr/local/mysql/bin/mysqld_safe: line 10: If: command not found > /usr/local/mysql/bin/mysqld_safe: line 11: copy: command not found > /usr/local/mysql/bin/mysqld_safe: line 13: If: command not found > /usr/local/mysql/bin/mysqld_safe: line 14: level: command not found > /usr/local/mysql/bin/mysqld_safe: line 15: pointing: command not found > > [1]+ Exit 127 /usr/local/mysql/bin/mysqld_safe -- > user=msyql > janis-roughs-power-mac-g5:bin jlrough$ echo $PATH > /usr/local/bin:/usr/local/sbin:/usr/local/mysql/bin:/usr/bin:/bin:/usr/ > sbin:/sbin:/usr/local/bin:/usr/X11/bin > > > Can you give me a hint here? > The mysqld_safe command is in /usr/local/mysql/bin/mysqld_safe > directory. So it is looking in the symlink directory /usr/local/ > mysql-5.0.82-osx10.5-powerpc/bin but why does it look in //libexec > or //sbin or //bin? Why doesn't it find it in /usr/local/mysql/bin/ > mysqld_safe > Is it the $PATH variable?/usr/local/bin:/usr/local/sbin:/usr/local/ > mysql/bin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin > Why does it say on line 2 FATAL? > > should it be > /usr/local/bin:/usr/local/sbin:/usr/local/mysql*/bin: etc etc > > It fails because //libexec, etc. are invalid directories. You need to figure out why that is. I didn't install your system, so I have no idea what you did (on Linux, I use the Linux distribution's installer to install MySQL). -- ================== Remove the "x" from my email address Jerry Stuckle JDS Computer Training Corp. jstucklex(a)attglobal.net ================== |