MySQL error installing Drupal

[Jasper Frumau]

Well I changed /opt/local/etc/php5/ and finally saw a change in the error
message. Still no correct path to the sock though:

*Warning*: mysql_connect()
[function.mysql-connect<http://localhost/function.mysql-connect>]:
[2002] No such file or directory (trying to connect via
unix:///opt/local/var/run/mysql5/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

Then I saw I had to use mysqld.sock and voila:

Connected successfully

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

> 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/562333c3/attachment.html>