RE: Reinstallation HANG
If I pull the hostname, I don't get 'myserver.com', but this server never was called 'myserver.com' to begin with. The 'myserver.com' domain was expired for the last year or so, but I never removed it from the DNS records until recently. So really, for the last year, 'myserver.com' never refered to anything. I don't want to revert back to the old DNS records, because there were other problems. Do you think that the problem is somewhere else in the server config or is it isolated to mysql? I don't have any other problems with software on this box, which makes me think it's mysql. -Original Message- From: Gerald L. Clark [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 10:56 AM To: Weber, Jeff Cc: [EMAIL PROTECTED] Subject: Re: Reinstallation HANG when you enter the unix command hostname what do you get ? This had better be resolvable with your DNS. Maybe you forgot to fix your hostname when the domain was changed. "Weber, Jeff" wrote: > > I've gathered more data on my problem here. We have recently made a few DNS > changes that I think have hosed mysql. See the error message below: > > DBI->connect failed: Unknown MySQL Server Host 'myserver.com' (2) at > /home/httpd/test/stage2/cgi-bin/send_requests.cgi line 28 > Can't call method "prepare" on an undefined value at > /home/httpd/test/stage2/cgi-bin/send_requests.cgi line 32. > > The 'myserver.com' is no longer a viable domain, so is there anything in the > installation or starting of mysql that needs this domain? I have the same > 'hanging' error on start and stop of mysql. And if so, where can I change it > so it uses our new domain? Or do I have to do a complete reinstall with a > newly compiled > installation app? > > Thanks, > > Jeff > > -----Original Message- > From: Gerald L. Clark [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 12, 2001 4:19 PM > To: Weber, Jeff > Cc: [EMAIL PROTECTED] > Subject: Re: Reinstallation HANG > > "Weber, Jeff" wrote: > > > > Mysql is hanging when started on my Linux box (Red Hat Linux release 6.2 > > (Zoot) > > Kernel 2.2.14-5.0 on an i686 -- mysqld, Version: 3.23.21), so I thought I > > would reinstall mysql_install_db. This hangs too, see below... > > > > [root@myserver mysql]# mysql_install_db > > Creating func table > > Creating tables_priv table > > Creating columns_priv table > > > > Server doesn't come back after this, I have to kill -9 to stop it. Anyone > > have any idea why the install would hang this quickly? > > > > Thanks, > > Jeff > > > You should have run > mysql_install_db --user=mysql > > Now the database directory and all the files are probably owned by root, > and mysqld can't read the directory. > > chown -R mysql /var/mysql/data > > replacing "/var/mysql/data" with actual mysql database directory. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Reinstallation HANG
when you enter the unix command hostname what do you get ? This had better be resolvable with your DNS. Maybe you forgot to fix your hostname when the domain was changed. "Weber, Jeff" wrote: > > I've gathered more data on my problem here. We have recently made a few DNS > changes that I think have hosed mysql. See the error message below: > > DBI->connect failed: Unknown MySQL Server Host 'myserver.com' (2) at > /home/httpd/test/stage2/cgi-bin/send_requests.cgi line 28 > Can't call method "prepare" on an undefined value at > /home/httpd/test/stage2/cgi-bin/send_requests.cgi line 32. > > The 'myserver.com' is no longer a viable domain, so is there anything in the > installation or starting of mysql that needs this domain? I have the same > 'hanging' error on start and stop of mysql. And if so, where can I change it > so it uses our new domain? Or do I have to do a complete reinstall with a > newly compiled > installation app? > > Thanks, > > Jeff > > -Original Message- > From: Gerald L. Clark [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 12, 2001 4:19 PM > To: Weber, Jeff > Cc: [EMAIL PROTECTED] > Subject: Re: Reinstallation HANG > > "Weber, Jeff" wrote: > > > > Mysql is hanging when started on my Linux box (Red Hat Linux release 6.2 > > (Zoot) > > Kernel 2.2.14-5.0 on an i686 -- mysqld, Version: 3.23.21), so I thought I > > would reinstall mysql_install_db. This hangs too, see below... > > > > [root@myserver mysql]# mysql_install_db > > Creating func table > > Creating tables_priv table > > Creating columns_priv table > > > > Server doesn't come back after this, I have to kill -9 to stop it. Anyone > > have any idea why the install would hang this quickly? > > > > Thanks, > > Jeff > > > You should have run > mysql_install_db --user=mysql > > Now the database directory and all the files are probably owned by root, > and mysqld can't read the directory. > > chown -R mysql /var/mysql/data > > replacing "/var/mysql/data" with actual mysql database directory. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Reinstallation HANG
I've gathered more data on my problem here. We have recently made a few DNS changes that I think have hosed mysql. See the error message below: DBI->connect failed: Unknown MySQL Server Host 'myserver.com' (2) at /home/httpd/test/stage2/cgi-bin/send_requests.cgi line 28 Can't call method "prepare" on an undefined value at /home/httpd/test/stage2/cgi-bin/send_requests.cgi line 32. The 'myserver.com' is no longer a viable domain, so is there anything in the installation or starting of mysql that needs this domain? I have the same 'hanging' error on start and stop of mysql. And if so, where can I change it so it uses our new domain? Or do I have to do a complete reinstall with a newly compiled installation app? Thanks, Jeff -Original Message- From: Gerald L. Clark [mailto:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 4:19 PM To: Weber, Jeff Cc: [EMAIL PROTECTED] Subject: Re: Reinstallation HANG "Weber, Jeff" wrote: > > Mysql is hanging when started on my Linux box (Red Hat Linux release 6.2 > (Zoot) > Kernel 2.2.14-5.0 on an i686 -- mysqld, Version: 3.23.21), so I thought I > would reinstall mysql_install_db. This hangs too, see below... > > [root@myserver mysql]# mysql_install_db > Creating func table > Creating tables_priv table > Creating columns_priv table > > Server doesn't come back after this, I have to kill -9 to stop it. Anyone > have any idea why the install would hang this quickly? > > Thanks, > Jeff > You should have run mysql_install_db --user=mysql Now the database directory and all the files are probably owned by root, and mysqld can't read the directory. chown -R mysql /var/mysql/data replacing "/var/mysql/data" with actual mysql database directory. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Reinstallation HANG
What is your swap size? What is your drive space? It sounds like you need to upgrade to their latest. Did you load all the updates on your 6.2 box? Charles Hagen On Mon, 12 Mar 2001, Weber, Jeff wrote: > Mysql is hanging when started on my Linux box (Red Hat Linux release 6.2 > (Zoot) > Kernel 2.2.14-5.0 on an i686 -- mysqld, Version: 3.23.21), so I thought I > would reinstall mysql_install_db. This hangs too, see below... > > [root@myserver mysql]# mysql_install_db > Creating func table > Creating tables_priv table > Creating columns_priv table > > Server doesn't come back after this, I have to kill -9 to stop it. Anyone > have any idea why the install would hang this quickly? > > Thanks, > Jeff > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > -- Charles L. Hagen Engineer Hagen IT 920-261-8499 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Reinstallation HANG
"Weber, Jeff" wrote: > > Mysql is hanging when started on my Linux box (Red Hat Linux release 6.2 > (Zoot) > Kernel 2.2.14-5.0 on an i686 -- mysqld, Version: 3.23.21), so I thought I > would reinstall mysql_install_db. This hangs too, see below... > > [root@myserver mysql]# mysql_install_db > Creating func table > Creating tables_priv table > Creating columns_priv table > > Server doesn't come back after this, I have to kill -9 to stop it. Anyone > have any idea why the install would hang this quickly? > > Thanks, > Jeff > You should have run mysql_install_db --user=mysql Now the database directory and all the files are probably owned by root, and mysqld can't read the directory. chown -R mysql /var/mysql/data replacing "/var/mysql/data" with actual mysql database directory. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Reinstallation HANG
Mysql is hanging when started on my Linux box (Red Hat Linux release 6.2 (Zoot) Kernel 2.2.14-5.0 on an i686 -- mysqld, Version: 3.23.21), so I thought I would reinstall mysql_install_db. This hangs too, see below... [root@myserver mysql]# mysql_install_db Creating func table Creating tables_priv table Creating columns_priv table Server doesn't come back after this, I have to kill -9 to stop it. Anyone have any idea why the install would hang this quickly? Thanks, Jeff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php