The build from scratch on a redhat machine is not 100% straight forward. I believe the S90mysqld link in the redhat /etc/rc.d/rc3.d/ looks specifically for the boot file in /etc/rc.d/init.d/mysqld in order to start. It's auto generated on a rpm but if you wanted to try subqueries which is only available in mysql4.1, redhat9 has no rpm built for that. That's why I needed to build from scratch.
Some of the shortcuts are removed when I typed rpm -e to get rid of the old stuff. One of those files would be the my.cfg in the /etc. That's very annoying when you have a fine-tuned my.cfg and in a flash it's gone. The other file is the boot script in /etc/rc.d/init.d/ . That missing file had me stumped for a day or two. RH9 boot starts everything in the rc3.d or rc5.d with a good "S" (for start) in the appropriate folder a "K" file is used to kill the fill during that sequence. So is Kirti needed to Start the mysql server during boot and he was using a system that boots to a graphical login then he would need to do this. cd /etc/rc.d ln -s ../init.d/mysqld rc5.d/S90mysqld rm rc5.d/K15mysqld ../init.d/mysqld start Or for a command line booted machine. cd /etc/rc.d ln -s ../init.d/mysqld rc3.d/S90mysqld rm rc3.d/K15mysqld ../init.d/mysqld start Or to have it boot in all conditions. cd /etc/rc.d ln -s ../init.d/mysqld rc2.d/S90mysqld ln -s ../init.d/mysqld rc3.d/S90mysqld ln -s ../init.d/mysqld rc4.d/S90mysqld ln -s ../init.d/mysqld rc5.d/S90mysqld rm rc2.d/K15mysqld rm rc3.d/K15mysqld rm rc4.d/K15mysqld rm rc5.d/K15mysqld ../init.d/mysqld start This is just a RedHat thing. Good luck! You can do this. > -----Original Message----- > From: Sam [mailto:[EMAIL PROTECTED] > Sent: Sunday, May 09, 2004 4:52 PM > To: [EMAIL PROTECTED] > Subject: RE: MySQL does not automatically start at BOOT time?? > > Kirti: > > I think you already did that as you said in you first > msg about you installation steps. > > > > >>Setup to start MySQL automatically > > > >> % cp /usr/local/<mysql Version > > No>/mysql.server > > > >>/etc/init.d > > > Did you get my prev msg where I suggested to check the > > previleges on your mysql. > > Usually I do it this way: > > 8) Change ownership of binaries to root and > ownership of the data directory > to the user that you will run mysqld as (in our > case mysql): > > chown -R root . > chown -R mysql var > chgrp -R mysql . ( this is important too) > > 9) To start MySQL server automatically when you > boot your machine, > copy the mysql.server script to the `/etc/init.d' > directory with the name > mysql, and then make it executable > > cp support-files/mysql.server /etc/init.d/mysql > chmod +x /etc/init.d/mysql > > 10) Activate to run the script at system startup by > adding to the chkconfig list > > chkconfig --add mysql > chkconfig --level 345 mysql on > > For more information read > http://dev.mysql.com/doc/mysql/en/Automatic_start.html > > Good luck... > > Sam > > --- "Kirti S. Bajwa" <[EMAIL PROTECTED]> wrote: > > Brian: > > > > No. From where I copy this file from? Is it stright > > copy or something else? > > > > You might be my savior!! > > > > Thanks. > > > > Kirti > > > > -----Original Message----- > > From: Brian Duke [mailto:[EMAIL PROTECTED] > > Sent: Sunday, May 09, 2004 5:44 PM > > To: 'Kirti S. Bajwa'; [EMAIL PROTECTED] > > Subject: RE: MySQL does not automatically start at > > BOOT time?? > > > > > > I know that feeling. perhaps I can help. > > do you have an /etc/rc.d/init.d/mysqld file? > > > > > -----Original Message----- > > > From: Kirti S. Bajwa [mailto:[EMAIL PROTECTED] > > > Sent: Sunday, May 09, 2004 3:29 PM > > > To: '[EMAIL PROTECTED]' > > > Subject: RE: MySQL does not automatically start at > > BOOT time?? > > > > > > Hello List: > > > > > > I have spent the entire weekend solving this > > problem without success. > > > PLEASE > > > HELP. > > > > > > After the last response from Paul, and MySQL not > > starting at BOOT time, I > > > thought that I may have done something wrong. So I > > went ahead and did a > > > fresh install of RH9 & MySQL Source Distro with > > one difference. This time > > > I > > > installed "mysql-4.0.18". I followed the > > installation script as noted > > > below, > > > still MySQL does not automatically re-start at > > BOOT time. > > > > > > For those who did not follow this posting; > > previously I have installed > > > MySQL > > > and followed the same installation script. Each > > time MySQL started at BOOT > > > time. The only major difference is that in > > previous cases, I installed > > > from > > > the "binaries" & this time I installed from > > "source". > > > > > > I can start the MySQL by "mysqld_safe". > > > > > > Paul had suggested looking into the MySQL error > > logs. Since I am new, I > > > can't find where are error logs are kept. I have > > looked in "/var/log" & > > > "/usr/local/mysql" and have not found any error > > logs for MySQL. > > > > > > I sure need help!! > > > > > > Thanks. > > > > > > Kirti > > > > > > > > > > > > > > > -----Original Message----- > > > From: Paul DuBois [mailto:[EMAIL PROTECTED] > > > Sent: Saturday, May 08, 2004 6:44 PM > > > To: Kirti S. Bajwa > > > Subject: RE: MySQL does not automatically start at > > BOOT time?? > > > > > > > > > >Paul: > > > > > > > >Did what you said. Here is the response: > > > > > > > >% chkconfig --list mysql.server > > > >mysql.server 0:off 1:off 2:on 3:on 4:on 5:on > > 6:off > > > > > > That looks correct. > > > > > > If you did chkconfig mysql.server on, *and then > > restarted*, and the > > > server still doesn't start automatically, check > > the MySQL error log > > > to see if it has a clue. If it doesn't, I dunno. > > > > > > > > > > > > > > >What next? > > > > > > > >Kirti > > > > > > > > > > > >-----Original Message----- > > > >From: Paul DuBois [mailto:[EMAIL PROTECTED] > > > >Sent: Saturday, May 08, 2004 2:24 PM > > > >To: Kirti S. Bajwa; [EMAIL PROTECTED] > > > >Subject: Re: MySQL does not automatically start > > at BOOT time?? > > > > > > > > > > > >At 14:08 -0400 5/8/04, Kirti S. Bajwa wrote: > > > >>Hello List: > > > >> > > > >>I have been learning MySQL. I have installed & > > tested MySQL server 3-4 > > > >times > > > >>without problem. This time I used the an > > "alpha-nightly snapshot" and > > > have > > > >>run into problems. > > > >> > > > >>My current Installation: > > > >>---------------------- > > > >>LINUX RH9 > > > >>Source Installaion: > > mysql-5.0.1-alpha-nightly-20040504.tar.gz > > > >> > > > >>DUAL Pentium 1GHz CPU > > > >>1.5 GB Memory > > > >> > > > >>Installation Procedure: > > > >>---------------------- > > > >>I follow the installation procedure is as > > described in MySQL > > > documentation > > > >& > > > >>a doze of consulting MySQL by Paul DuBois book: > > > >> > > > >> % cd /usr/local > > > >> % gunzip -dc > > mysql-5.0.1-alpha-nightly-20040504.tar.gz | tar xvf > > - > > > >> % cd mysql-5.0.1-alpha-nightly-20040504 > > > >> % ./configure -prefix=/usr/local/mysql > > > >> % make > > > >> % make install > > > >>% scripts/mysql_install_db > > > >> % chown -R mysqladm.mysqlgrp > > /usr/local/mysql/var > > > >> % chown -R mysqladm.mysqlgrp /rad/var > > > >> % chmod -R go-rwx /usr/local/mysql/var > > > >> * It is a good idea to first see if the MySQL > > can be > > > >>started: > > > >> % /usr/local/mysql/bin/mysqld_safe > > -user=mysqladm & > > > >> % ps -aux | grep mysql > > > >> There should be 4-5 lines showing how MySQL > > > >>is running. > > > >> Wonderful, MySQL is running. > > > >> % reboot > > > >>Setup to start MySQL automatically > > > >> % cp /usr/local/<mysql Version > > No>/mysql.server > > > >>/etc/init.d > > > >> % cd /etc/init.d > > > >> % chmod 500 mysql.server > > > >> % chkconfig - -add mysql.server > > > > > > > >Try adding: > > > > > > > >chkconfig mysql.server on > > > > > > > >Then run this to see if it's been enabled for the > > appropriate runlevels: > > > > > > > >chkconfig --list mysql.server > > > > > > > >> % reboot > > > >> > > > >> Check if MySQL is running: > > > >> % ps -aux | grep mysql > > > >> > > > >>Problem: > > > >>--------- > > > >>Well, MySQL does not start automatically. > > > > > > >>------------------------------------------------------------------------ > > > -- > > > - > > > >- > > > >>---------- > > > >>As I said, I have used a similar installation > > script before without > > > === message truncated === > > > ===== > _o /\ ---- __o > -< \_ / \ ---- < \, > __(_)/_(_)________/ \_______(_) /_(_)__ > > > > > __________________________________ > Do you Yahoo!? > Win a $20,000 Career Makeover at Yahoo! HotJobs > http://hotjobs.sweepstakes.yahoo.com/careermakeover > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]