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 proble. >>This time, the only modifications made to the instalation script are: (1) >>Few hints from Paul DuBois book & (2) Different version of MySQL. >> >>Can somebody point me to the problem? Is in the script I am using is >missing >>something? > > >-- >Paul DuBois, MySQL Documentation Team >Madison, Wisconsin, USA >MySQL AB, www.mysql.com > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
