Re: [PHP-DB] Waiting for localhost

On 04/02/2015 06:17 AM, Richard wrote:
>
>

<snip>
>> Here are some hints....
>>
>> service apache2 restart
>> [....] Restarting web server: apache2AH00558: apache2: Could not
>> reliably determine the server's fully qualified domain name, using
>> 127.0.1.1. Set the 'ServerName' directive globally to suppress
>> this message
>> . ok
>>
>>
>>    using 127.0.1.1 OUCH
>>
>> Added this as last line in  /etc/apache2/apache2.conf
>>
>> ServerName localhost
>>
>> root@meow:/var/www# service apache2 restart
>> [ ok ] Restarting web server: apache2
>>
>> OK ...good
>>
>> But ... I am still getting the same performance - TestConnect [the
>> code above] gives the same result, and HandleWeight hangs!!!
>>
>
> As I pointed out on the apache list, 127.0.1.1 != localhost. It's
> not clear where all you've stapled that incorrect value in at this
> point, but that will account for why apache gave you that error.
>
> In the php code, you are not handling the output from
> mysqli_fetch_array correctly. Read the documentation, there are many
> examples -- including q/a responses that almost exactly match your
> code.
>
> You have shown no debugging effort on "HandleWeight", so we have no
> way of providing any insights on it.
>
> You additionally need to provide the version/release level
> information for your installed versions of:
>
>    - OS
>    - apache
>    - mysql
>    - php

Richard -

Thanks.

service Apache2 restart
 >> [....] Restarting web server: apache2AH00558: apache2: Could not
 >> reliably determine the server's fully qualified domain name, using
 >> 127.0.1.1. Set the 'ServerName' directive globally to suppress
 >> this message

This is what was returned on a restart of Apache.

Modified the configuration file.....

  Added this as last line in  /etc/apache2/apache2.conf
 >>
 >> ServerName localhost

Now on a restart...

  root@meow:/var/www# service apache2 restart
 >> [ ok ] Restarting web server: apache2

Fixed the mysqli_fetch_array.

OS Debian Jessie
Apache/2.4.9 (Debian)
MySQL  Ver 14.14 Distrib 5.5.37, for debian-linux-gnu (x86_64) using readline 6.3
PHP  5.6.0RC2 (cli)

Debug

Here is the connection block w/ debug.

$hostname="localhost";
$database="Store";
$username="ethan";
$password="xxxxx";


$link = mysqli_connect($hostname, $username, $password);
if (!$link) {
die('Connection failed: ' . mysqli_error());
}
else{
      echo "Connection to MySQL server " .$hostname . " successful!
" . PHP_EOL;
}

$db_selected = mysql_select_db( $link,$database);
if (!$db_selected) {
     die ('Can\'t select database: ' . mysql_error());
}
else {
     echo 'Database ' . $database . ' successfully selected!';
}

Never connects. Hangs


TIA

Ethan