MySQL error installing Drupal

[Jasper Frumau]

Well back to square one with PHP, MySQl and Apache under MacPorts.@
http://localhost/drupal-6.15/install.php?profile=default&locale=en after
adding database name, database user and password I get:

Failed to connect to your MySQL database server. MySQL reports the following
message: *No such file or directory*.

   - Are you sure you have the correct username and password?
   - Are you sure that you have typed the correct database hostname?
   - Are you sure that the database server is running?

For more help, see the Installation and upgrading
handbook<http://drupal.org/node/258>.
If you are unsure what these terms mean you should probably contact your
hosting provider.

and when I run http://localhost/connect-test.php I still get:

*Warning*: mysql_connect()
[function.mysql-connect<http://localhost/function.mysql-connect>]:
[2002] No such file or directory (trying to connect via
unix:///tmp/mysql.sock) in */opt/local/apache2/htdocs/connect-test.php* on
line *2*

*Warning*: mysql_connect()
[function.mysql-connect<http://localhost/function.mysql-connect>]:
No such file or directory in */opt/local/apache2/htdocs/connect-test.php* on
line *2*
Could not connect: No such file or directory

But I guess I need to add the paths to mysql.sock again..



On Thu, Jan 14, 2010 at 3:27 PM, Jasper Frumau <jasperfrumau at gmail.com>wrote:

> I have Apache and PHP running.
> Jaspers-MacBook-Pro:conf jasper$ sudo vim httpd.conf
> Jaspers-MacBook-Pro:conf jasper$ sudo /opt/local/apache2/bin/apachectl -k
> restart
> Jaspers-MacBook-Pro:conf jasper$
>
> I can see localhost and info.php shows PHP 5.3.1 with PHP.ini located @
> /opt/local/etc/php5  The link Scott gave me plus all the other tips helped a
> lot. Thanks!!
>
> Will try to install Drupal one more time now..
>
>
>
>
> On Thu, Jan 14, 2010 at 2:22 PM, Scott Haneda <talklists at newgeo.com>wrote:
>
>> On Jan 14, 2010, at 3:13 AM, Jasper Frumau wrote:
>>
>> > On Thu, Jan 14, 2010 at 2:04 PM, Scott Haneda <talklists at newgeo.com>
>> wrote:
>> >
>> >> Ok, really quick, and I need to get off to sleep…
>> >>
>> >> Maybe you can give us a clear explanation of what your goals are, is it
>> to
>> >> run Apache2, Mysql5, and php5 all under MacPorts, or do you want to mix
>> and
>> >> match bits from Apple and  MacPorts?   I suggest the former, and should
>> have
>> >> nightmares about the later in about a half hour :)
>> >>
>> >
>> > I would prefer all under MacPorts (Apache2, PHP5 and MySQL5). Apple's
>> > Websharing / Apache has been turned off and I just now need to get
>> Apache
>> > and PHP from MacPorts and get all running properly so my Wordpress will
>> run
>> > again and so I can install Drupal without any issues....  I'd like to
>> avoid
>> > further hasssles :-) But it can wait until it is day again at your side
>> of
>> > the planet. Thanks for all the help so far. I appreciate it a lot! I
>> learned
>> > a lot already!!
>>
>> Good, that makes it simple, you are mostly there.
>> I think all you need to to is run the launchctl command to load apache.
>>
>> This may help some: http://trac.macports.org/wiki/howto/MAMP
>>
>> You need to run this command:
>> sudo launchctl load -w /Library/LaunchDaemons/org.macports.apache2.plist
>>
>> But that also means you need to configure Apache a little, this means at
>> the least, the following:
>> 1) Decide if you want user directory support, enable or disable it
>> 2) Decide if you want a local copy of the Apache manual to work, enable or
>> disable it
>> 3) include the "mod_php.conf" into your Apache config file
>>        This alone could be most of your issues
>> 4) Maybe load the php module, I am not sure the state your setup is in
>> 5) Restart apache after each of those steps, test to be sure they are
>> working.
>>
>> Talk to you tomorrow.
>>
>> --
>> Scott * If you contact me off list replace talklists@ with scott@ *
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/macports-users/attachments/20100114/13c40abc/attachment.html>