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
