6 messages in com.mysql.lists.mysqlRe: Reinstallation HANG
FromSent OnAttachments
Weber, Jeff12 Mar 2001 13:08 
Gerald L. Clark12 Mar 2001 13:18 
Charles L Hagen12 Mar 2001 13:56 
Weber, Jeff13 Mar 2001 07:50 
Gerald L. Clark13 Mar 2001 07:55 
Weber, Jeff13 Mar 2001 08:20 
Subject:Re: Reinstallation HANG
From:Gerald L. Clark (gera@suppliersystems.com)
Date:03/13/2001 07:55:21 AM
List:com.mysql.lists.mysql

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:gera@suppliersystems.com] Sent: Monday, March 12, 2001 4:19 PM To: Weber, Jeff Cc: mys@lists.mysql.com 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.