RE: MySQL does not automatically start at BOOT time??
Hello List: Few days ago I posted MySQL does not automatically start at BOOT time?? on this list. Several people responded but the problem was not resolved. I did a fresh install of RH9 MySQL 4.0.18 (Binary) on a DUAL CPU 1.5 GB Mem server. After reading the MySQL documentation MySQL book by Paul DUBois, I found the problem. Problem: Size of log file in /etc/my.cnf /usr/local/mysql/data/ is different. Here is the actual error msg: InnoDB: Error: log file /usr/local/mysql/data/ib_logfile0 is of different size 0 5242880 bytes InnoDB: than specified in the .cnf file 0 67108864! - I commented the InnoDB_log_file_size in /etc/my.cnf file and MySQL started like a PRO. I have the following questions: Q1: === My setup is all from default settings. Therefore size of log file, both in /etc/my.cnf /usr/local/mysql/data/ are set by the default. Why default setting for one parameter are different in locations? Q2: === How to fix this problem? If there is an explanation in the MySQL documentation, I sure like to read about it if someone responds with the Section Number. Thanks Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 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]
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 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] -- MySQL General Mailing List For list archives: http
RE: MySQL does not automatically start at BOOT time??
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 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
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
RE: MySQL does not automatically start at BOOT time??
Sam: I removed MySQL by removing the directory /etc/local/mysql-version /etc/local/mysql and then re-installing the mysql-4.0.18.tar.gz. I follwed the procedure (as you described) from mysql documentation again I can not get mysql auto start. Do you know which directory/file has mysql error so I can look into it. I am completely burned!! Will start again tomarrow morning if I get few responses. Kirti -Original Message- From: Sam [mailto:[EMAIL PROTECTED] Sent: Sunday, May 09, 2004 6: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
RE: MySQL does not automatically start at BOOT time??
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
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]
RE: MySQL does not automatically start at BOOT time??
Paul: Did what you said. Here is the output: % chkconfig --list mysql.server mysql.server 0:off 1:off 2:on 3:on 4:on 5:on 6:off 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL does not automatically start at BOOT time??
Paul: I did not realize that I sent the response directly to you instead of the list. In any case, it did not work now I re-start with a clean RH9 install. I thought why to wait until Monday. I need to get it done. Thanks again. You gave me lots of new instructions to read about. Kirt -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]
