Still have MySQL problems that need to get solved soon (was: Re: Apache and MySQL won't start)

[Ali A Samii]

Thank you Ryan, that solved that.

Couple of small remaining issues left.

1. Connection for controluser as defined in your configuration failed!

2. The additional features for working with linked tables have been deactivated. To find out why click here.
	Clicking "here gives me "not OK" status on everything except:
		cfg['Servers'][$i]['pmadb'] ...	OK

3. Starting or stopping apache2 gives me the following:
httpd: Could not reliably determine the server's fully qualified domain name, using 192.168.1.59 for ServerName

That's about it!


On 29 Jul, 2010, at 19:04 , Ryan Schmidt wrote:

> On Jul 29, 2010, at 11:44, Ali A Samii wrote:
> 
>> What I assume it is supposed to be able to do (and does with the other two virtual hosts I have defined) is that I can type:
>> 
>> http://localhost/		============> /opt/local/www				# loads phpmyadmin!!! :(
>> http://pma/			============> /opt/local/www/phpmyadmin/		# works like a charm
>> http://dev.thesamiis.com/	============> /opt/local/www/dev.thesamiis.com/		# works like a charm
>> http://dev.lesamisdestan.com/	============> /opt/local/www/dev.lesamisdestan.com/	# works like a charm
> 
> What you may not realize is that as soon as you turn on name-based virtual hosting, the very first virtual host you define will respond to all hostnames that have not otherwise been defined. See the "Main host goes away" block on this page of the Apache documentation:
> 
> http://httpd.apache.org/docs/2.2/vhosts/name-based.html
> 
> See also the comments in your own httpd.conf file:
> 
> On Jul 29, 2010, at 11:44, Ali A Samii wrote:
> 
>>> # The first VirtualHost section is used for all requests that do not
>>> # match a ServerName or ServerAlias in any <VirtualHost> block.
> 
> I assume you do not have a virtual host defined for "ServerName localhost", therefore anytime you request a URL starting with http://localhost/, you will get the first vhost, which in your case is your phpmyadmin vhost.
> 
> To fix this, create a new virtual host, defined before any of the other vhosts, that uses the server's default configuration. That is, add this block before all other VirtualHost blocks:
> 
> # Default virtual host
> <VirtualHost *:80>
> 	ServerName localhost
> </VirtualHost>
> 
> I don't think what you put as the ServerName here is important, since any unknown requests will go here, but the documentation says to use the same ServerName here that you use in the global part of the config file. You don't need to define DocumentRoot or anything else for this vhost since they will be inherited from the global part of the config file.
> 
>