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

Jasper Frumau jasperfrumau at gmail.com
Thu Jul 29 09:35:22 PDT 2010 

On Thu, Jul 29, 2010 at 8:27 PM, Ali A Samii <samii at me.com> wrote:

>
> On 29 Jul, 2010, at 18:19 , Jasper Frumau wrote:
>
>
>
> On Thu, Jul 29, 2010 at 8:15 PM, Ali A Samii <samii at me.com> wrote:
>
>> OK, I solved those errors. I had to move from the development to the
>> production version of php.ini
>>
>> But now I have another problem.
>>
>> I can't load the root level of the /opt/local/www
>>
>> In my /etc/hosts, I have defined 3 virtual domains:
>>
>> 127.0.0.1 pma
>> 127.0.0.1 dev.thesamiis.com
>> 127.0.0.1 dev.lesamisdestan.com
>>
>> The standard lines that were in the hosts file by default were not
>> touched, and they included:
>> 127.0.0.1 localhost.
>>
>> In the /opt/local/apache2/conf/extra/httpd-vhosts.conf I have also added a
>> Virtual Host for pma, dev.thesamiis.com and dev.lesamisdestan.com using
>> your suggested format:
>>
>> <VirtualHost *:80>
>>     DocumentRoot "/opt/local/www/phpmyadmin"
>>     ServerName pma
>> </VirtualHost>
>>
>> But now, when I point my browser to http://localhost/ phpmyadmin loads.
>>
>> And if I point my browser to http://localhost/info.php I get this:
>>
>> Not Found
>>
>> The requested URL /info.php was not found on this server.
>>
>
> What did you find in the Apache logs cat /opt/local/apache2/logs/access_log
> and cat /opt/local/apache2/logs/error_log ?
>
>
> Well, it seems that it sees the pma directory as the root
>
> [Thu Jul 29 18:24:51 2010] [error] [client ::1] script
> '/opt/local/www/phpmyadmin/info.php' not found or unable to stat
>

Well maybe:

<VirtualHost *:80>
    DocumentRoot "/opt/local/www/phpmyadmin"
    ServerName pma
</VirtualHost>

should be

<VirtualHost *:80>
    DocumentRoot "/opt/local/www"
    ServerName pma
</VirtualHost>

That is what I have:

Jaspers-MacBook-Pro:conf jasper$ pwd
/opt/local/apache2/conf
Jaspers-MacBook-Pro:conf jasper$ ls
extra        httpd.conf.bak    magic        original
httpd.conf    httpd.conf~    mime.types
Jaspers-MacBook-Pro:conf jasper$ cd /opt/local/apache2/conf/extra
Jaspers-MacBook-Pro:extra jasper$ ls
httpd-autoindex.conf        httpd-multilang-errordoc.conf
httpd-dav.conf            httpd-phpmyadmin.conf
httpd-default.conf        httpd-phpmyadmin.conf~
httpd-info.conf            httpd-ssl.conf
httpd-languages.conf        httpd-userdir.conf
httpd-manual.conf        httpd-vhosts.conf
httpd-mpm.conf            mod_php.conf
Jaspers-MacBook-Pro:extra jasper$ cat httpd-vhosts.conf
#
# Virtual Hosts
#
# If you want to maintain multiple domains/hostnames on your
# machine you can setup VirtualHost containers for them. Most configurations
# use only name-based virtual hosts so the server doesn't need to worry
about
# IP addresses. This is indicated by the asterisks in the directives below.
#
# Please see the documentation at
# <URL:http://httpd.apache.org/docs/2.2/vhosts/>
# for further details before you try to setup virtual hosts.
#
# You may use the command line option '-S' to verify your virtual host
# configuration.

#
# Use name-based virtual hosting.
#
NameVirtualHost *:80

#
# VirtualHost example:
# Almost any Apache directive may go into a VirtualHost container.
# The first VirtualHost section is used for all requests that do not
# match a ServerName or ServerAlias in any <VirtualHost> block.
#
#<VirtualHost *:80>
#    ServerAdmin webmaster at dummy-host.example.com
#    DocumentRoot "/opt/local/apache2/docs/dummy-host.example.com"
#    ServerName dummy-host.example.com
#    ServerAlias www.dummy-host.example.com
#    ErrorLog "logs/dummy-host.example.com-error_log"
#    CustomLog "logs/dummy-host.example.com-access_log" common
#</VirtualHost>




> That's from the error_log
>
> ::1 - - [29/Jul/2010:18:26:08 +0200] "GET /info.php HTTP/1.1" 404 206
>
> And that is from the access_log
>
>
>
>
>
>> So not sure what the problem is...Just need to solve this, and hopefully,
>> solving this will not bring about another issue. Seems like every time I
>> solve one problem, another one crops up.
>>
>> Help, ASAP, would really be appreciated. I'm going on 48 hours sans
>> working on the project that has about 24 hours of development work to
>> complete and is due in about 18 hours!!!
>>
>> Thanks
>>
>> On 29 Jul, 2010, at 15:17 , Ali A Samii wrote:
>>
>> Well, I thought everything went smoothly until I imported a Joomla site.
>>
>> Result was a whole long list of errors, so I decided to try a clean
>> install of joomla 1.5.20.
>>
>> Everything went smoothly until I got to "Install Sample Data".
>>
>> At that point, I got the following "*Error: the XML response that was
>> returned from the server is invalid.*"
>>
>> I clicked OK and decided to proceed without the sample data, went to the
>> final screen, then deleted the installation directory as needed, and clicked
>> on "Administrator" to load the admin interface of Joomla.
>>
>> Wow, 200 lines of errors and no admin interface.
>>
>> One sample line:
>>
>> Strict Standards: Non-static method JLoader::import() should not be called
>> statically in /opt/local/www/
>> dev.lesamisdestan.com/libraries/joomla/import.php on line 29
>>
>> All start with Strict Standards.
>>
>> If I can get this issue solved...I'll be on my way with a great
>> thanks...but I really need to start finishing my project due tomorrow, which
>> I have been unable to do any work on for over 46 hours due to the problems
>> I've been having and the need to reinstall my entire macports installation
>> about 5-6 times to get it to work.
>>
>>
>> On 29 Jul, 2010, at 12:15 , Scott Haneda wrote:
>>
>> Ok, now I am completely confused.  Are there two people having near
>> identical issues with Macports and Mysql?  My emails to the list will
>> probably sound a bit confusing as I am treating this as one person.  Ugh,
>> sleep, I am on my way :)
>>
>> Sorry about the confusion.
>>
>> I have pulled the files of my notes/tutorial, I would suggest using the
>> MacPorts MAMP guide.  Sorry for mixing two people up, I feel silly :)
>>
>> I am sure with the list that you will have this up and running tomorrow
>> without much more effort.
>> --
>> Scott (* For off-list contact, replace talklists@ with scott@ *)
>>
>> On Jul 29, 2010, at 2:45 AM, Ali A Samii wrote:
>>
>> Hi Scott:
>>
>>
>> Since I couldn't get things to work for me last night (I'm in Paris,
>> France) and I had been up to almost 6 AM to get things to work, I gave up
>> for the night (or I should say the morning) and went to get some sleep.
>>
>>
>> Anyway, I just got your email with the tutorial, and I am going to do a
>> fresh, clean and directed reinstall of everything according to your
>> tutorial, and I'll get back to you in the event of a hiccup and/or in the
>> event of success.
>>
>>
>> If all else fails, log into my system. I'll get you the info needed at
>> that time.
>>
>>
>> Thanks,
>>
>>
>> Ali
>>
>>
>>
>>
>>
>> _______________________________________________
>> macports-users mailing list
>> macports-users at lists.macosforge.org
>> http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
>>
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/macports-users/attachments/20100729/2e6b69a7/attachment.html>

More information about the macports-users mailing list