[HCoop-Help] MySQL/PHP lost ability to connect in the last 24 hours

[C. Howell]

Again, I haven't changed anything, but it is working again.  Here's
the MySQL I use-- connect with (username, password, host) and select
database separately.

$local_status = mysql_connect("mysql","myusername","mysecretpassword");
if ($local_status > 0)
{
   if (mysql_select_db("caden_samples") == false)
   {
      $local_error_code = "DATABASE";
      $local_error_message = "Unable to select database.";
   }
}

Thanks for writing back.   If there are different settings I should
use to make this connection more resilient, I'd happily use them. :)
Caden

On Mon, Sep 29, 2008 at 5:49 AM, Davor Ocelic <docelic at hcoop.net> wrote:
> On Sat, 27 Sep 2008 20:54:43 -0500
> "C. Howell" <caden at hcoop.net> wrote:
>
>> Hello,
>>
>> I've made no changes to my portfolio in the last 24 hours, but PHP no
>> longer connects to MySQL.
>>
>> I can connect to MySQL from the command line:
>>
>> caden at mire:~/caden_htdocs$ mysql -hmysql -p
>> Enter password:
>> Welcome to the MySQL monitor.  Commands end with ; or \g.
>> Your MySQL connection id is 2956114
>>
>> However, when I connect within a PHP page I get:
>>
>> Warning: mysql_connect() [function.mysql-connect]: Unknown MySQL
>> server host 'mysql' (2) in
>> /afs/hcoop.net/user/c/ca/caden/caden_htdocs/cadenhowell.com/samples/index.php
>> on line 11
>
> Okay, so looks the problem is not related to mysql per-se, but with
> inability to find or contact server 'mysql'.
>
>> Warning: mysql_query() [function.mysql-query]: Can't connect to local
>> MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in
>> /afs/hcoop.net/user/c/ca/caden/caden_htdocs/cadenhowell.com/samples/index.php
>> on line 37
>
> Here we see that PHP is trying to connect through local unix socket,
> which won't work because unix sockets only work locally and not accross
> network.
>
> In your case, you do need network connection to host 'mysql'.
>
>> Does anyone have any suggestions?  Has anything related on the server
>> changed?  Environment variables, network configuration related to
>> mysql?  My whole portfolio site is database-driven so I'd be grateful
>> for any tips.
>
> Well first of all check if it's still giving the same message.
>
> Then next thing is checking where you have defined your MySQL connection
> settings, and see if you have host/port option explicitly set.
>
> If it still tries to connect to local Unix socket on Mire, we'll
> see what to do next.
>
> -doc
>
> _______________________________________________
> HCoop-Help mailing list
> HCoop-Help at lists.hcoop.net
> https://lists.hcoop.net/listinfo/hcoop-help
>