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
