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

[Ali A Samii]

Thanks Ryan. Just vt adding "ServerName localhost" to httpd.conf, that solved the warning. True that it made no difference and I could still point to http://localhost/ and it would go to the right place, but it's all a matter of a clean install, isn't it!

So, keeping up with the clean install matter, I have one other issue which I come across all the time now.

Any new file I add or create in /opt/local/www or its sub-directories I am forced to create as root user. Then, if I try and browse, I get all sorts of errors. I then have to manually go and recursively set permissions to 777, which isn't really ideal. Parent directory permissions do not seem to be inherited.

Any solutions there?

On 29 Jul, 2010, at 20:48 , Ryan Schmidt wrote:

> On Jul 29, 2010, at 13:42, Ali A Samii wrote:
> 
>> And re #3 below?
>> 
>> On 29 Jul, 2010, at 20:40 , Ryan Schmidt wrote:
>> 
>>> On Jul 29, 2010, at 13:15, Ali A Samii wrote:
>>> 
>>>> 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
>>> 
>>> I'm afraid it has been several years since I have dealt with phpmyadmin's configuration options. Perhaps someone else here knows, but you're more likely to get good help for this by reading the phpmyadmin documentation and asking in a phpmyadmin support venue.
>>> 
>>> http://www.phpmyadmin.net/home_page/docs.php
>>> 
>>> http://www.phpmyadmin.net/home_page/support.php
> 
> I have not seen that error message before so I can only guess. It sounds to me like you have not specified a ServerName, so you should specify one. If that's not it, then I'm not sure, and I would refer you to Apache documentation and support venues. In any case it sounds like a warning, not an error, so your server should work even if you don't do anything to resolve that.
> 
> You could also search Google:
> 
> http://www.google.com/search?q=%22Could+not+reliably+determine+the+server's+fully+qualified+domain+name%22
> 
>